Sender adapter: File content conversion suggestion

[former_member186078]

Hi all,

I require your suggestion on File content conversion with Sender File adapter. I am having a scenario where I would be getting multiple orders data i.e., header and item information in a single file. Suppose, we have given a chance to design the source structure. So, which would be the better way for having the source structure so that it would be easy for file content conversion and mapping. Is it like Method 1 or Method II?

Method I:

Orderno,FieldA,FieldB,FieldC

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,FieldA,FieldB,FieldC

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,FieldA,FieldB,FieldC

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Method II:

Orderno,FieldA,FieldB,FieldC

Orderno,FieldA,FieldB,FieldC

Orderno,FieldA,FieldB,FieldC

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

If you suggest method I, can you let me know how the content conversion parameters look like?

Thanks in Advance,

Adithya K

Message was edited by:

Adithya K

[Former Member · Accepted solution]

Adithya,

This blog would help you I believe.

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Can you just give the XML format of the data type.

[former_member186078 · Accepted solution]

Hi Manju,

The sample XML structure would be:

<Order_Data>

<Orderno>

<FieldA>

<FieldB>

<FieldC>

<Items>

<Orderno>

<OrderItem>

<Field1>

<Field2>

<Field3>

<Field4>

<Field5>

</Items>

<Items>

<Orderno>

<OrderItem>

<Field1>

<Field2>

<Field3>

<Field4>

<Field5>

</Items>

<Items>

<Orderno>

<OrderItem>

<Field1>

<Field2>

<Field3>

<Field4>

<Field5>

</Items>

</Orderno>

<Orderno>

<FieldA>

<FieldB>

<FieldC>

<Items>

<Orderno>

<OrderItem>

<Field1>

<Field2>

<Field3>

<Field4>

<Field5>

</Items>

</Orderno>

</Order_Data>

Message was edited by:

Adithya K

[Former Member · Accepted solution]

Adithya,

Looking at your input file I think a structure as below would be better.

<Order_Data>

<Orderno>

<Orderno/>

<FieldA/>

<FieldB/>

<FieldC/>

</Orderno>

<Items>

<Orderno/>

<OrderItem/>

<Field1/>

<Field2/>

<Field3/>

<Field4/>

<Field5/>

</Items>

</Order_Data>

Content Conversion Parameters for this would be:

RecordSet Structure OrderData,,Orderno,1,items,

OrderData.fieldNames Orderno,items

OrderData.fieldSeparator 'nl'

OrderData.endSeparator 'nl'

Orderno.fieldNames Orderno,FieldA,FieldB,FieldC

Orderno.fieldSeparator ,

Orderno.endSeparator 'nl'

items.fieldNames Orderno,OrderItem,Field1,Field2,Field3,Field4,Field5

items.fieldSeparator ,

Items.endSeparator 'nl'

ignoreRecordsetName true

Depending on which are your key fields you will have to put two more parameters:

Orderno.keyFieldValue

items.keyFieldValue

Hope this would be of some help.

Thanx,

Manju.

[Former Member]

its a simple structure.

i guess you have one header and multiple Item values,so make your structure as

<Header> 1-1

<H1>---</H1>

<H2>---</H2>

</Header>

<Item> 0-unbounded

<I1>---</I1>

</I2>---</I2>

</Item>

Thanx

Aamir

Message was edited by:

Aamir Suhail

[former_member186078]

Hi Amir,

Thanks for the immediate reply. But, my question was not complete, accidentally it was posted before I complete my question. Now I have edited the same. Can you please let me know your suggestion?

[Former Member]

but how will your source file look like? will it look as method 1 or method 2?

you data type will be based upon that

Thanx

Aamir

[former_member186078]

The source data file is not yet finalized. I was trying to ask them in the method II format which will make our life somewhat easy, so that I can handle the situation in the RFC function module by putting the TABLE parameters for header and another for Item. But, if they say its like we can get in only Method I and that's it, then I want to know how we are going to define the content conversion parameters.

Mostly, the file would come in the Method I format itself, thats the generic flat file method right.

Thanks,

Adithya K

[Former Member]

yeah,method 1 looks more standard to me.

Thanx

Aamir

[former_member186078]

But, Can you please let me know how should the recordset and structures should look like? How are the content conversion parameters should look like?