Content Conversion in sender SFTP in PI7.1

[Former Member]

Hi,

This is my input file

"Contract No. Call No. CAGE Code DUNS Plus4 Check No.

"W9121510C0003 07187 188459929 C06644 BVN0001

Everthing is tab delimeter.

i need to delete this first row which is label.

i have tried with this content conversion but its not deleting the first row.can any one help on this

xml.documentSkipFirstRows 1.

Regards,

Dinesh

[Former Member]

This message was moderated.

[Former Member]

Dinesh,

Use the below parameter in your sender FCC,

ignoreRecordsetName true

Regards,

Pavan

[Former Member]

Hi,

Mine is sender SFTP adapter iam doing content conversion in message Transformation Bean can i use document offset here?i tried with ignore Recordset its not working..Can anyone help on this please?

Regards,

Dinesh

Edited by: Dineshbabu.M on Dec 22, 2010 9:05 AM

[RKothari]

Hi,

Which convertion type parameter are you using SimplePlain2XML / StructPlain2XML ???

xml.documentSkipFirstRows works only with StructPlain2XML conversion type.

-Rahul

[Former Member]

Hi Rahul.

Iam using Plain2XML..Can you please suggest me what can i do

Regards,

Dinesh

[RKothari]

Hi,

I guess Plain2XML is the Module key which you would have mentioned.

I am reffering to xml.conversionType parameter.

Please check the below mentioned blogs:

/people/gabrielsagayaselvam.panneerselvam/blog/2009/08/31/solve-key-field-problem-using-structplain2xml-in-messagetransformationbean

/people/gabrielsagayaselvam.panneerselvam/blog/2009/12/07/standard-adapter-framework-modules-afmodules-in-pi-71-150part-2

[baskar_gopalakrishnan2]

Its pretty easy.. Follow this step.

use this link...

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document.

This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines.

Baskar

[Former Member]

Hi Dinesh,

In the Content conversion, For Document Offset = (keep the value) no. of rows to delete.

Thanks,