Scheduled CSV Data Load with Headers below row 1?

[zachkenyon]

When doing an import from a CSV via the Load Data module under Import Sets, you can specify which row the header data is on.

However, I can't figure out how to do that for a repeating/scheduled data load. I've set up the Data Source to get the CSV file via SFTP, and set the Scheduled Import up, but I don't see anywhere to speficy what the header row of the CSV is.

Is there some way to specify that via a pre-import script on the Scheduled Import?

[rsander]

Any update on this one?

[zachkenyon]

I did not find a way to do this, I wound up working with the team that owned the system generating the data to get them to remove everything above the header row.

[Rhane]

Did you ever figure this out?

I am running into the same situation.

edit: Did not fully read. My bad. Doubt I can get the people to remove the top stuff on the file.

[jonfung]

I know this is an older issue however thought it would be worth sharing a possible solution anyways.

There is a Header Row field that is hidden (via UI Policy) unless it is an Excel format import.

All you need to do is add in another action in the Format == CSV UI Policy to display the Header Row field and Robert's your father's brother. Alternatively editing via the list view should work also.