When I config a file content conversion, the recordset doubled in XML.

[Former Member]

When I config the Sender FTP Adapter to read a file in plain text format. Why the <RECORD> doubled in the XML?

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

- <ns:MT_JE xmlns:ns="http://www.oracle.com/ebs">

- <RECORD>

- <RECORD>

<BUKRS>2001</BUKRS>

<MONAT>8</MONAT>

<BLDAT>20090819</BLDAT>

<BUDAT>20090819</BUDAT>

</RECORD>

</RECORD>

</ns:MT_JE>

The plain text like follows:

2001,8,20090819,20090819

the content conversion parameters like follows:

Document Name: MT_JE

Recordset Name: RECORD

Recordset Structure: RECORD,*

[Former Member]

After checking SAP Note 791737, I know that the "Conversion with recordset name" can be done in SAP_XIAF (software component). But SAP_XIAF is not in my XI system.

I wonder can I install SAP_XIAF in my XI system.

[Former Member]

Thanks for your reply. I did as what you said.

Document Name: MT_JE

Recordset Name:

Recordset Structure: RECORD,*

ignoreRecordsetName true

But the result is not what I want.

- <ns:MT_JE xmlns:ns="http://www.oracle.com/ebs">
 - <Recordset>
  - <RECORD>
     <BUKRS>2001</BUKRS> 
     <MONAT>8</MONAT> 
     <BLDAT>2009.08.19</BLDAT> 
     <BUDAT>2009.08.19</BUDAT>

What I expect as follows:

- <ns:MT_JE xmlns:ns="http://www.oracle.com/ebs">
  - <RECORD>
     <BUKRS>2001</BUKRS> 
     <MONAT>8</MONAT> 
     <BLDAT>2009.08.19</BLDAT> 
     <BUDAT>2009.08.19</BUDAT>

[Former Member]

Hi Li,

ignoreRecordsetName as true should not get Recordset in your xml. The purpose of this is to remove Recordset only. So please inactivate and activate your communication channel and do a cache refresh and give a try once again.

You should get the result what you are trying to get.

Regards,

---Satish

[Former Member]

Hi Satish,

I inactivate and activate the communication channel.

I do the cache refresh using the Tcode SXI_CACHE.

XI Runtime Cache Status show "Cache contents are up-to-date".

But the result is still not what I expect.

Edited by: zhongliang li on Aug 21, 2009 5:02 AM

Edited by: zhongliang li on Aug 21, 2009 5:09 AM

[jyothi_anagani]

Hi ,

Document Name: MT_JE
Recordset Name: 
Recordset Structure: RECORD,*

ignoreRecordsetName             true

This will surely work.....It will not create any strucure like this..

- <ns:MT_JE xmlns:ns="http://www.oracle.com/ebs">
 - <Recordset>
  - <RECORD>
     <BUKRS>2001</BUKRS> 
     <MONAT>8</MONAT> 
     <BLDAT>2009.08.19</BLDAT> 
     <BUDAT>2009.08.19</BUDAT>

I think this may be the problem with Cache refresh or something....

Dont give anything at Recordset Name: and use the parameter ignoreRecordsetName true

just change the all the Objects and activate one moretime...Then it will surely work...

Thanks.

[Former Member]

Hi Zhon,

Try to deactivate once again activate the communication channel as well as activate the change lists when u make

modifications. I thought you may forgot activating change lists. Otherwise there may be definitely cache error.

If it is still not working then try to create new comm. channel and u can test that when u keep option ignore record set

name then it won't get RECORD tag 2 times.

[Former Member]

Hi ,

Hope your problem got solved .

Else use ignoreRecordsetName = True

Regards,

Jude

[ABHISHEK_MISHRA]

Document Name: MT_JE

Recordset Name:

Recordset Structure: RECORD,*

I think It will work...

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

[jyothi_anagani]

Hi,

Document Name: MT_JE
Recordset Name: RECORD
Recordset Structure: RECORD,*

Dont use like this..

Use like this...

Document Name: MT_JE
Recordset Name: 
Recordset Structure: RECORD,*


ignoreRecordsetName                            true

Dont give RecordsetName....

Because it is treating like RECORD is having one more structure RECORD in it.

Use the parameter ignoreRecordsetName true

A <Recordset> element is inserted in the XML structure for each recordset structure. This level is not always required, particularly if the recordset only contains one structure definition.

If you set the parameter to true, the <Recordset> element is not inserted.

Thanks.