Summary
When export to text is used from a Service Manager webtier client and is then imported into MS excel some of the values for date fields are incorrectly displayed.
Question
How to correctly export date values and data from Service Manager webtier client using the "Export to text file" option.
Sometimes the date fields and their values appear as follows when viewed from Excel:
12/20/11 10:52:32
12/20/11 16:16:45
12/24/11 09:42:36
12/26/11 11:16:07
12/26/11 11:27:44
12/26/11 12:50:19
01-04-12 9:49
01-07-12 12:13
01-07-12 13:37
Answer
Example:
- Login to the webtier client as falcon
- Select the Incident Queue from the drop down.
- Goto More->Export to Text File
- Select the "Semicolon Seperated CSV" and click OK
- When Prompted to save the file choose "Save as"
- Save the file as "<filename>.txt".
- Do not let excel bring the file up automatically. You must open excel first after saving to a .txt file.
- Open MS Excel
- Goto File-Open and select your previously saved .txt file.
- You should be prompted with a Text Import Wizard
- For "Choose the file type the best describes your data:" --> Delimited
- Click Next
- Choose the semicolon delimiter and verify the data preview looks fine. Click Next.
- In Step 3 of 3 highlight the incorrectly displayed date fields and select the Date value for Column data format
- Click Finish