problem with csv

[amaradiswamy]

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 · Accepted solution]

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

[Chuck Tomasi]

Wow, thanks for sharing Swamy. I didn't know utf-16 was supported. Great to know.

If you can get the data in the system using utf-16, it should not impact the instance.

[amaradiswamy]

now the error is "Character reference "&#0" is an invalid XML character."

[Binh Truong2]

Any updates on this? I'm running into similar issues.

[amaradiswamy]

Hi Binh,

I have just given "charset=utf-16" in properties and deleted old junk columns and then the issue was resolved.

Thanks and regards

Swamy