Data Import from CSV file Help

[Ruchi19]

I am trying to load the data from CSV file which is '|' pipe delimited.

I created a new data source as described in wiki with attachment file. but when i loaded the data, it didn't read by column. I have attached the snapshot how it looks.
http://wiki.service-now.com/index.php?title=Data_Sources#CSV

and when i click on the particular row number, i could see the value of some of the columns. i have attached the screen shot for that too.

[john_andersen]

This file does not fit conventional file-delimited form. The label row has 14 fields and the data row has 16 fields.

This may be your problem.

[Ruchi19]

Thanks John for trying this out. I corrected the header record but still doesn't work.

when I do save as file, I see three options for CSV. Csv comma delimited, csv - ms dos and csv - macintosh.
Is there any particular format i should save the file?

[john_andersen]

That is strange...I got your file to work just fine for me when I changed all "||" to "|" to have 14 fields instead of 16.

I just edited my file in a text editor, so I didn't have to choose between the options you are mentioning.

You can check out the Data Source in the demo instance:
https://demo.service-now.com/nav_to.do?uri=sys_data_source.do?sys_id=7496954b0a0a3c1900382fd534e4ec95

The file I am using is attached to the data source. To run a test load, simply click "Test Load 20 Records"

[Ruchi19]

Thanks a ton John for working through this with me.
I also modified the file in Text editor and save it as CSV. and It works now. So the file format was the issue.