Ignoring first record in Sender File content conversion

[former_member462539]

Hello Experts,

Need some Help/clue in File content conversion Sender. For some reason Sender File adapter FCC is ignoring first(Control) record/row while framing XML structure. Any idea please what is missing?

Here is my input file(CSV).

01,00001,20150112

02,00002,20150112

03,00003,S

Configuration in FCC CC.

Document Name: MT_Test

Document Namespace: http://test.com/xi/Test

Recordset Structure: Control,1,Header,1,Item,*

Recordset Sequence: Ascending

Recordsets per Message: *

Key Filed name: Key

KF Type: String(case-insensitive)

Control.fieldSeparator	,
Control.processFieldNames	fromConfiguration
Control.fieldNames	ID,Num,Date
Control.keyFieldValue	01
Control.keyFieldInStructure	add
Control.endSeparator	'nl'
Header.fieldSeparator	,
Header.processFieldNames	fromConfiguration
Header.fieldNames	ID,Num,Date
Header.keyFieldValue	02
Header.keyFieldInStructure	add
Header.endSeparator	'nl'
Item.fieldSeparator	,
Item.processFieldNames	fromConfiguration
Item.fieldNames	ID,Num,Date
Item.keyFieldValue	03
Item.keyFieldInStructure	add
Item.endSeparator	'nl'
Item.lastFieldsOptional	YES
ignoreRecordsetName	true

For some reason, Control record/Node is NOT getting created from first line of CSV file(01,00001,20150112).

Here is the output which is against my configuration for FCC, where it is clearly missing Control record/Node with elements:

<?xml version="1.0" encoding="utf-8" ?>

<ns:MT_Test xmlns:ns="http://test.com/xi/Test">

- <Header>

       <ID>02</ID>

       <Num>00002</Num>

       <Date>20150112</Date>  

  </Header>

- <Item>

       <ID>03</ID>

       <Num>00003</Num>

       <Date>20150112</Date>

  </Item>

  </ns:MT_Test>

Thanks

[former_member462539 · Accepted solution]

The resolution for this issue was very SIMPLE, and STRANGE. I re-saved that input CSV file in MS Excel by choosing "Save as type:" (CSV(Comma Delimited) (*.csv)), and file adapter started converting FCC(csv file) into XML as expected.

<?xml version="1.0" encoding="utf-8" ?>

<ns:MT_Test xmlns:ns="http://test.com/xi/Test">

- <Control>

       <ID>01</ID>

       <Num>00001</Num>

       <Date>20150112</Date> 

</Control>

- <Header>

       <ID>02</ID>

       <Num>00002</Num>

       <Date>20150112</Date> 

  </Header>

- <Item>

       <ID>03</ID>

       <Num>00003</Num>

       <Date>S</Date>

  </Item>

  </ns:MT_Test>

[RaghuVamseedhar]

Brhamma,

You have given "Key Filed name: Key". Please make it "Key Filed name: ID".

Please make sure that document offset is zero (default). SAP help.