CSV data export OTRS

excel otrs itsm
user2614607 picture user2614607 · Nov 20, 2013 · Viewed 8.6k times · Source

When I export search result to CSV file from OTRS I get the ticket number as: 2,01101E+15 .

No problem uptill now but when I change the number to text field 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?

Answer

Hannes_hal picture Hannes_hal · Nov 25, 2013

there is actually only one way in Excel to do this. Create an empty sheet -> Choose File->Import->CSV and select your CSV file. The delimiter should be a semicolon and fields are enclosed by ". In the next step you have to choose "Text" for the Ticket# column.

This is a very annoying Excel "bug". Another way to do this would be a macro, but running macros is often not allowed.

regards

Hannes

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More