Inbound csv import starting at a specific row

[tricial]

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

[tricial]

Yes I have the header row set to 5 in my inbound action current.header_row =5 and also when I created the initial manual import I set the header row to 5

No I don't get any other errors in the log and it only tries to import 2 records and then does not import anymore

Thank you

Tricia

[Gowrisankar Sat]

Can you share a screenshot of those 2 records?

[tricial]

Yes so this is the import set records I opened and looked at the audit history

They are the title rows in the csv file that are on lines 1 - 4

So even though I have the header row set to 5 it still looks like it is trying to import the data from row 1 and is failing

THis is the csv data file

If I open the record from the import set history it appears to be the row1 which is Part of the report title

[Gowrisankar Sat]

Are you implementing this as per this blog, check if you set the type to "CSV"

Loading data from an email attachment

[tricial]

Yes I am using this and the type is set to CSV