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

[Chuck Tomasi]

View this from the thread (click on the title) if you are already looking at it in your inbox.

Next, click "Use Advanced Editor" in the upper right corner of this editor box (this does not show up with inbox view.)

Finally, you will see "Attach" in the lower right corner of the editor window.

[Chuck Tomasi]

Thank you. After reviewing the file, it's definitely the format of the data.

This appears to be a tab separated values file, not comma separated. CSV stands for comma separated values, which is what ServiceNow is expecting. There isn't a single comma in the sample file you gave me.

If you cannot change the input file to comma separated values, you can adjust your data source to accept tabs using the CSV delimiter field. To use tab, click the lightbulb icon and then click \t. It will insert a tab.

[amaradiswamy]

Thanks for your help, but still i am getting the error and no columns are getting created in import set table.

Regards,

Swamy

[Chuck Tomasi]

Hi Swamy,

Sorry to hear you are still having problems. It might be time to reach out to customer support. I'll be curious to see what they say and learn from it.

[amaradiswamy]

Thank you so much Tomasi

Could you please help me to understand on possible reasons for getting junk column names like U�t�i�l�i�z�a�t�i�o�n� �O�u�t� �(�p�c�t�i�l�e�0�5�) in import set table.

Regards,

Swamy