Issue reading a CSV file

[nilambari]

Hi All,

I am using a scenario which uses the SFTP sender channel to read the CSV file.

The module helps in converting the file from CSV to XML.

However the CSV file contains the column names as first row, this line needs to be skipped while creating the XML structure.

As per the link http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm i have used the option xml.documentOffset=1 in the module to skip the first line. However this is not working.

Request a solution.

[Former Member]

Hi Nilambari,

Pelase try with xml.documentSkipFirstRows and

ignoreRecordsetName  true

Regards,

prasanth

[gagandeep_batra]

can you put screen shot for your parameter also?

Regards

Gagan

[Former Member]

Hi,

Please go through the below links.

http://scn.sap.com/thread/1855686

http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm

Regards

Venkat

[smavachee]

Can you try this alternative suggested by Arijit..

Hope it helps.!

Regards,

Sunil