NOTICE: Branded Content
NOTICE: Certain versions of content (“Material”) accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.
Service Manager / Service Center User Discussions
cancel

Export data model to open in csv

Highlighted
rdellac Frequent Contributor.
Frequent Contributor.

Export data model to open in csv

Hello to all,

I tried to export data from HP Service Manager to a csv file.

It's ok to me when i open this file in notepad++

But when i want to open this file whith excel,  accents  are transformed to special characters like "é".

Do you have a solution to avoid telling the client to open his file in .txt and choose the delimitation etc.

 

Thanks a lot Experts :-)

1 REPLY
Knowledge Partner
Knowledge Partner

Re: Export data model to open in csv

This is rather an Excel issue, not HPSM. A solution would be use a better worksheet tool, like Calc :) 

Normally, Excel is capable to identify the charset being used and I personally never had this problem. Googling it I found other persons that had this issue.. I searched for: excel open csv special characters

Wish you luck!!

Regards,
Breno Abreu

If you feel this was helpful please click the KUDOS! thumb below!