File content conversion

[Former Member]

Hi,

source structure:

<Datatype>

<Record>

<field name1> </field name1>

<field name 2> </field name 2>

</Record>

<Record>

<field name1> </field name1>

<field name2> </field name2>

<Record>

</Datatype>

If the above is the structure, then while using file content conversion for a comma seperated file in the configuration part..what must be given for the parameters "recordset name" , "recordset structure" and "recordsets per message".

[former_member189387]

Hi,

<i><b> then while using file content conversion for a comma seperated file in the configuration part..what must be given for the parameters "recordset name" , "recordset structure" and "recordsets per message".</b></i>

Befor answering you questins please understand what RecordSet and Structure

< MessageType>

<root>...

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

</nameA1>

<nameB>

<value4>value</value4>

</nameB>

...

</root>...

<root>

</root>

</MessageType>

Here <b>Message T</b>ype is <b>Document Name</b>

root is Structure Tile nothing but RecordSet Structure

<nameA> ..... Sub Structure

<b>Document Name</b>

is nothing but Message Type

<b> Recordset Name</b>

Specify the name of the structure: It is included in the XML schema. <b>( root )</b>

<b> Recordset Namespace</b>

The namespace is added to the name of the structure.

<b>Recordset Structure</b>

Enter the sequence and the number of substructures as follows: <NameA,nA,NameB,nB,...>.

<b> Recordsets per Message</b>

Specify the number of recordsets to be grouped together for one message.

If the number of recordsets in a document is greater than the number specified, then the adapter creates multiple messages from a document. The last message might then contain fewer recordsets than specified.

Refer Venkat blog for this

• Award points if helpful

Best Regards.,

V.Rangarajan

[Former Member]

Hi Pavithra,

<b>source structure:

<Datatype>

<Record>

<field name1> </field name1>

<field name 2> </field name 2>

</Record>

<Record>

<field name1> </field name1>

<field name2> </field name2>

<Record>

</Datatype>

If the above is the structure, then while using file content conversion for a comma seperated file in the configuration part..what must be given for the parameters "recordset name" , "recordset structure" and "recordsets per message".</b>

Recordset Name : Your Message Type Name " "

Recordset Structure: "Record"

recordsetpermessage: " splitting your message"

Eg: source has 10 records If you set Recordsetper message : 5

splits into 1(5), 2(5) TWO FILES...

I hope this might help you..

vasanth

[Former Member]

your structure should be

<Datatype>

<Record>

<Recordset>

<field name1> </field name1>

<field name 2> </field name 2>

</Recordset>

<Recordset>

<field name1> </field name1>

<field name2> </field name2>

</Recordset>

</Record>

</Datatype>

then your Recordset name is Record,

RecordsetStructure is Recordset.

Recordsets per message be 1

Regards,

S.RamNarender

[Former Member]

HI,

Record set name : any name u give

Record set structure : Record,*

Record set per message : 1

then in the table give...

Record.fieldNames: field name1,field name2

Record.fieldSeparator : ,

Record.endSeparator : 'nl'

ignoreRecordSetName: true

u can give any name for Record set name but at the end by setting ignoreRecordSetName as true u r ignoring that...

hope this helpful..

[Shabarish_Nair]

Recordset name - Give anything and then use ignorerecordset true in you FCC

Recordset structure - Record,*

Recordset per message - 1

[santhosh_kumarv]

Hi,

The FCC parameters

Recordset Name:Datatype

Recordset Structure: Record,*

ignoreRecordset = true

Record.fieldname = fieldname1,fieldname2

Record.endSeperator = 'nl'

Record.fieldSeparator = ,

Message was edited by:

Santhosh Kumar V

[former_member189387]

Hi ,

For all ur question answers are in the following blogs

Introduction to simple(File-XI-File)scenario and complete walk through for starters(Part1)

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

part II

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

NAB the File TAB

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

Hexadecimal notation for the Escape sequences

http://www.cplusplus.com/doc/papers/ascii.html

http://www.scit.wlv.ac.uk/cbook/chap1.Codes.html

Scheduling File Adapter – Part I

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d458a870-0601-0010-caab-b99...

Scheduling File Adapter – Part II

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/4f61fddf-0601-0010-7ab5-fb7...

Content conversion in Sender file adapter-- 2 new useful parameters

/people/sukumar.natarajan/blog/2007/06/12/content-conversion-in-sender-file-adapter--2-new-useful-parameters

XI Mail Adapter: An approach for sending emails with attachment with help of Java mapping

/people/stefan.grube/blog/2007/04/17/xi-mail-adapter-an-approach-for-sending-emails-with-attachment-with-help-of-java-mapping

How to send a flat file with various field lengths and variable substructures to XI 3.0

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

you have to use Adapter module for reading excel files.

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Regards.,

V.Rangarajan