problem with csv

amaradiswamy · ‎08-02-2016

Hi All,

I am struggling with importing CSV file to import set. In import set table some junk columns are getting created and when i clicked on "Loaded data" it is showing the error "An invalid XML character (Unicode: 0x0) was found in the element content of the document."

What can be the possible issue for this?

Thanks and regards,

Swamy

amaradiswamy · ‎08-12-2016

Hi Tomasi,

Sorry, i forgot clear the junk columns which were already created. i have used utf-16 in properties, now it is working fine but to check once, will it cause any problem to the instance?

Thanks and regards,

Swamy

View solution in original post

Chuck Tomasi · ‎08-02-2016

You may be encountering utf-8 encoding. I had this happen once as well. Check the properties field on the data source and add charset=utf-8

See section 2.3.1 here

Data Sources - ServiceNow Wiki

amaradiswamy · ‎08-02-2016

Hi Tomasi,

Thanks for your reply.

i have added that property but still i am getting the same error.

i will be really greatful if you can help me to solve this issue.

Thanks and regards,

Swamy

Chuck Tomasi · ‎08-02-2016

Would you be willing to attach the CSV here so I can take a look and verify the format is good?

amaradiswamy · ‎08-02-2016

How can i attach files? can see only image type attachments.