Inbound csv import starting at a specific row
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2018 10:33 AM
I have an inbound action that is creating a data source from a csv
On import I have the inbound action set to current.header_row = 5
I would expect the import to start from row 5 as header and then import the data from row 6 onward, however it keeps failing and is trying to still import the data in the csv file from row 1
My csv file has 4 title rows and the header row is actually on row 5
I need to ignore the files title rows and start the import from header row 5 and then the data is in rows 6-### (can be any number of rows that follow the header
This file comes from an automated system
The first 4 rows have report information
The actual data that I need to transform starts at row 5 (header row)
Any ideas how I can achieve this?
Thank you
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2018 11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2018 12:17 PM
Yes I have done this
The problem is when it imports the records it is importing only 2 records and skipping with the message Unable to resolve target record, coalesce values not present: u_system_deviceid
The file has 3600+ records and the field referenced does have the correct data
It appears that it is looking at row 1 and not row6
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2018 12:20 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2018 01:46 PM
You get that message when the header row is set to 5? Do you get any additional messages in the import log? I've tried this in the past and it worked fine.