Importing CSV Manually

tbalestreri3
Mega Contributor

I am attempting to import CSV manually and am having trouble. I will eventually want to do a scheduled import but I figured for the time being I will create a transform map and test it out manually. I have used the import set application a lot importing and transforming excel files.

I am importing the data via the Load Data module in the Import Set application. I am creating a new new import set and I upload the CSV file from here. After this I attempt to create a transform map but see the wrong information from my source table. I have attached a screen shot with the fields I see available. Please let me know what you think... thanks.

6 REPLIES 6

To check out a valid format for a CSV file, simply export one of our service-now tables into csv. If you are logged into the demo instance, for example, you could click on this URL to export a CSV file. Then you could see what format a CSV file should be in:
http://demo.service-now.com/incident.do?CSV

Essentially, the text file would look like:
"number","caller_id","company","category","incident_state","state"
"INC0010288","","","Hardware","New","Open"
"INC0010287","Chris Corbett","Central Columbia","Software","Active","Open"


I am also attaching my excel file as an exported CSV file so that you can see it from my original example. (see attachment).


denis hoffmann
Kilo Guru

Hi,


I find your post when looking how to change delimiter, when importing CSV files.


Since a lot of people are looking for the same, here is a tip for all of us



Memo :


A CSV file is just a text file with *.csv extension.



A long time ago, CSV standed for ' Comma Separated Values', but now you could find csv files with other delimiters, like semicolon ';', pipe '|', or tab .




Servicenow use comma delimiter by default. If you import csv with another delimiter it'll upload all fields as one column, not separated.



Q : How to set another delimiter in data source ?


A:


for example, french csv use ';'   instead of ','


  1. IF you manually create   your data source, then you can easily set the semi-colon (;) in "CSV delimiter" field of your data source form.
    or
  2. IF you upload a new file directly to import set table, it'll create a new data source too, with default settings ( ie comma for CSV delimiter). And all your fields stuck in one column if you check your import set. Do not transform this one.

When you check in your Data Sources table ( sys_data_source) sorted by "Created", you should see a new data source called "yourfile.csv (uploaded)".


If so, then open this new data source and set the semi colon (;) in "CSV delimiter" field. Reload your data, the next import set should be fine.




Regards,


Denis.