Sender File Adapter Behaviour

[Former Member]

Hi everyone,

Could it be possible to create a XML with plain structure from flatfile that is with out recordset.

Eg., my flatfile will be like

name1,age1,sal1

name2,age2,sal2

I have to get the xml as

<Recordset>

<name>name1</name>

<age>age1</age>

<sal>sal1</sal>

</recordset>

<Recordset>

<name>name2</name>

<age>age2</age>

<sal>sal2</sal>

</recordset>

The important thing is <Recordset> element should be created under 'Recordsetname' parameter in sender adapter.

My question, Is it possible to create a xml without recordset as shown above because there is no recordset to specify in 'recordset structure' parameter.

And Is it possible to generate complex XML structures using sender file adapter, i.e subnodes with parent child relationship.

Regards,

Yuva

[VijayKonam]

Hi,

Check this out.. <a href="http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm[url=http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm]http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm[url=http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm]http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm</a>

Also, you can not create XML without recordset name since this is the name of the message type you create in Repository. You can manipulate only the sub nodes in the message type (data types).

VJ

[Former Member]

VJ,

<Recordset> is not my message type name.

<b>You can manipulate only the sub nodes in the message type (data types)</b>

-I cant understand this.

Regards,

Yuva

[justin_santhanam]

Yuvraj,

Can u paste the output as u needed?

raj.

[Former Member]

Raj,

I already stated the flatfile and also the required target XML.. plz provide me the fcc parameters .

Regards,

Yuva

[Former Member]

Yuvraj,

I think this is straight forward...

name1,age1,sal1

name2,age2,sal2

I have to get the xml as

<Recordset>

<name>name1</name>

<age>age1</age>

<sal>sal1</sal>

</recordset>

<Recordset>

<name>name2</name>

<age>age2</age>

<sal>sal2</sal>

</recordset>

Just specify "Recordset" in "Recordset name" under "Content conversion parameters"...remaining FCC i think you must be knowing...

Let us know if you need more details.

Nilesh

[nisarkhan_n]

have to get the xml as

<Recordset>

<name>name1</name>

<age>age1</age>

<sal>sal1</sal>

</recordset>

<Recordset>

<name>name2</name>

<age>age2</age>

<sal>sal2</sal>

</recordset>

The important thing is <Recordset> element should be created under 'Recordsetname' parameter in sender adapter.My question, Is it possible to create a xml without recordset as shown above because there is no recordset to specify in 'recordset structure' parameter.

Ans: Recordset is the mandt in the FCC patameter, recordsetname is optional if you are not specfiing the recordset name in the FCC then it will add the default name to it but when yo dnt specify the recordset strucutre then it will throw error....

in your case the recordsetname is not present so add the ignorerecordsetname - true...and recordset name will be the root node name in the FCC.

You need to enter the recordset.

[Former Member]

Nilesh,

Its ok, but what to fill in Rescordset structure and how to add the parameters since it should be like <recordsetname>.<parameters> Right. and I am not having any 'recordset' in message type because all fields come directly under messagetype.

My question is whether it wil be possible to handle, If there is no recordset defined in datatype structure.?

Hope my question is clear.

Regards,

Yuva

[Former Member]

>>My question is whether it wil be possible to handle, If there is no recordset defined in datatype structure.?

ofcourse its possible.the structure will look like this '

MT_Sender

-->Parameter1

-->Parameter2

etc.....

Thanx

Aamir

[nisarkhan_n]

ok....kindly check the XML structure now and chcek the top root node which got created you can enter that in the recordset strucutre....

can you poste the XML strucutre of the MT (goto the MM test tab and check XML strucutre post it)

[Former Member]

Aamir,

could you give me the sender file adapter parameters for that, especially what you will fill in 'rescordstructure' parameter and '.fieldNames' parameter.

Thanks,

Yuva

[Former Member]

>> am not having any 'recordset' in message type because all fields come directly under messagetype. My question is whether it wil be possible to handle,....

yes its possible. use 'ignoreRecordsetName' n give value true.

the recordset element is not inserted.

[reward if helpful]

regards,

latika.