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.

[gaidem]

I'm pretty sure SN will only take CSV with a comma delimiter.

[Ruchi19]

Really? This could be an issue since we receive the pipe delimited data from the other system.

but wondering, this are the steps given in wiki : and I tried to follow that which didn't work. Do I have to anything more than that?


To process CSV files that are delimited by any character other than a comma:
Note
Note: This is an advanced step to create a CSV import. Normally, you would upload the data and import it directly using System Import Sets, which will create this CSV data source for you automatically.

1. Create the data source using one of the following methods:

* Click New on the Data Source list.
* Create the data source using the Attachment file retrieval method.

2. Attach the CSV file to this data source.
3. Personalize the Data Source form and add the CSV Delimiter field.
4. Type the character you want as the delimiter for the CSV file in this field.

For example, you might use the pipe symbol ( | ).

5. Test load the data source.

The CSV loader will parse the CSV file, expecting it to be delimited (separated) by "|".

[john_andersen]

Yes this is supported as mentioned in the wiki. I just tried it on the Demo instance just now and it seemed to load the data in separate columns. Can you attach your Pipe delimited file to this post?

[Ruchi19]

here it is..