Loaded data cannot be recognized

[hanying]

Hi all, I've done data import many times using "load data" to upload csv files. sometimes I encounter this problem:
after uploading showing successful, click "Loaded data", it gives a blank page with the error message below:
"An invalid XML character (Unicode: 0x0) was found in the element content of the document."
and my transform map also showing empty source table..
Is it due to the file format /encoding or what? can any one help?
thanks in advance!

[rsanon]

Instead of updating the existing data source, we created a New "fresh" Data Source, and loaded the records. That seems to have resolved the error we were seeing with the "Character Reference "" is an invalid XML Character"

[hanying]

We observe the same thing, creating a new data source solved our problem too. error might be caused by the invalid char in a column name of the old data source

[ameersy]

Hi Valor,

I have similar problem, I'm using open office and saved the file to .xls, .CSV uploaded to servicenow, it loaded successfully however when I attempted to view the loaded data it keep throwing the error "An invalid XML character (Unicode: 0x11) was found in the element content of the document" 

Thanks in advance..

[khadija3]

Hello,

Check the columns of the staging table and delete any column with special characters in the name.

[Shruti Kamboj]

This helps me.