When I export search result to CSV file i get the ticket number as : 2,01101E+15 .
No problem uptill now but when I change the number to text the last digit of ticket number is rounded to zero .
e.g if i have a ticket number 123456789 then excel changes it to 123456780.
how can i resolve this problem
CSV data export
Moderator: crythias
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: CSV data export
No OTRS issue, it's an Excel issue...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: CSV data export
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: CSV data export
I changed numbers to be formated as Text but it is useless as excel file already contained data from OTRS.
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: CSV data export
Excel clobbered the information on import. Your experience is expected.jj99 wrote:I changed numbers to be formated as Text but it is useless as excel file already contained data from OTRS.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: CSV data export
ok this is understandable but I have another problem. I have two instances of OTRS and when I generate Excel report then I get different formats in Excel .
how can i tell excel to treat both OTRS equally and generate reports with same format.
how can i tell excel to treat both OTRS equally and generate reports with same format.
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: CSV data export
You have not provided enough information to replicate the issue.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: CSV data export
I would suggest that you go first through the Master Support Article viewtopic.php?f=53&t=16009, then come back and ask again. Its much easier when people are aware of your setupjj99 wrote:ok this is understandable but I have another problem. I have two instances of OTRS and when I generate Excel report then I get different formats in Excel .
how can i tell excel to treat both OTRS equally and generate reports with same format.
Last edited by crythias on 26 Nov 2013, 18:39, edited 1 time in total.
Reason: removed the deep link
Reason: removed the deep link
OTRS 3.3.6 with ITSM 3.3.6 running on CentOS 6.4, PostgreSQL 9.x