Loaded data cannot be recognized
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2010 02:12 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2010 07:15 AM
Is this type of file something you could post as an attachment? Sounds like something to do with the file itself.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2010 07:24 AM
It looks like it's choking on ampersands..
If you send the file to me, I'll take a look at it for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2010 06:20 PM
Hi all, problem solved! as Valor suggested, just save as xls format will do. thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2011 06:38 AM
We tried saving as an xls as well, but that did not do the trick. Any other ideas?