File content conversion

[Former Member]

Dear frndz,

I am new to xi, i want to post the records from flat file to r/3 (sales order) using file content conversion.

i am giving the structure of the flat file tell me the logic for conversion.

Doc_type,Sales_org,Distribution_Channel,Division,item_no,Material_no,Quantity,Partner_no,Name,Country

dt,m001,1000,12,10,m01,10,pa01,plamjith,in

dt,m001,1000,12,10,m09,04,pa01,jimathur.ge

in this i want to omit the first description line and the records from the second line should get posted.

here in this case two sale order will be created.

Thanks in advance

Karthikeyan

[Former Member · Accepted solution]

HI karthik,

in file content paramets for

rowname.addHeaderLine value should be 1

then it works fine

Regards

Sampath

[Former Member]

all guys gave the usefull answer

[Former Member]

you don't need to have the key field name and value.. you can solve with field separator and the end separator...

[Former Member]

all guys gave the usefull answer

[Former Member]

Hello

Refer

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.

Regards,

Vandana.

[Former Member]

In Sender file adapter, Content conversion section,

Document Offset = 1.. this would ignore 1 line from top

No of lines you want to ignore... write that count in this parameter..

[former_member192295]

HI,

Use fieldFixedLengths and fieldSeparator commands in fcc, ur problem will be sorted out

[Former Member]

Hi,

Set the Document Offset value as 1 in the communication channel

in the file content conversion.

For this..do as follows:1. Select the message protocol as File content conversion

2. Scroll down to the content conversion parameter.

3. Specify the Document Offset value as 1.

This will always skip reading the first line from the file.

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

Please award marks if found useful.

Thanks

Hamja

[Former Member]

Hi,

Am receiving the following error can u resolve it plz check

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'xml.keyfieldName': no value found

i am using the following content conversion parameters

Header.endSeparator 'nl'

Header.fieldNames Doc_type,Sales_org,Distribution_Channel,Division,item_no,Material_no,

Header.keyFieldValue 1

Header.keyFieldInStructure ignore

Record.endSeparator 'nl'

Record.fieldNames Doc_type,Sales_org,Distribution_Channel,Division,item_no,Material_no,

Record.keyFieldValue 2

Record.keyFieldInStructure ignore

please correct the necessary things

Thanks in advance

Karthikeyan

[Former Member]

specify a key field name and use the same name as a first parameter of Header.fieldNames, Record.fieldNames

So your Header.fieldNames will look like

keyfieldName,Doc_type,Sales_org,Distribution_Channel,Division,item_no,Material_no

Same for Record.fieldNames

Refer