- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2017 06:43 AM
Hello,
I am wondering if it is possible to import a CSV file that it doesn't any header. I tried and ServiceNow says expected two columns but there is only one.
I checked out on google and I see that some peope having same requirement sometimes while working this type of no header data files.
Have you ever tried? Is there any feature in ServiceNow for this?
---
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2017 07:39 AM
So the short answer is "You need headers to import a CSV in ServiceNow." How you get those headers in is up to you (or the upstream data provider.)
If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.
If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2017 06:47 AM
HI Mehmet,
Are you indicating that your CSV has no header row in it? It just starts out as
Chuck
Mehmet
Fred
Don
And no "name" or other indicator at the top to tell you what the field is?
If that's the case, then no. It won't work in ServiceNow. It needs something to reference to map the incoming field to the target field. I recommend opening the file in a text editor and put one in. Then you can do the proper mapping.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2017 06:51 AM
Yes, I mean that 'name' row that names to subsequent rows' column names.
So, I need to find out a another way.
I can change file but there are tons of file, this is not a one file to import and use. Those files come regularly from an external source that I have to have ServiceNow processing them.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2017 06:50 AM
Hello Mehmet.
Maybe you could explore the workaround from here:
Re: Importing a csv file without column headers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2017 06:52 AM
Thank you Corina.
But the problem is that it is not just one or couple of files. Tons of.
