"ignoreRecordsetName" doesn't work in sender file CC

[Former Member]

Hi,

I set the Content Conversion Parameters in sender file CC as follow:

Document Name: ZFileDemo

Document NameSpace:http://hand-china.com/mm/po_01

Recordset Structure:Item,1

Recordset Sequence:Ascending

Parameters:

Item.fieldSeparator = ,

Item.fieldNames = ItemNo,Matnr,Text

ignoreRecordsetName = true

The content of csv file is as follow:

1,2,3

4,5,6

But the payload message in SXI_MONITOR as follow:

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

- <ns:ZFileDemo xmlns:ns="http://hand-china.com/mm/po_01">

- <Recordset>

- <Item>

<ItemNo>1</ItemNo>

<Matnr>2</Matnr>

<Text>3</Text>

</Item>

</Recordset>

- <Recordset>

- <Item>

<ItemNo>4</ItemNo>

<Matnr>5</Matnr>

<Text>6</Text>

</Item>

</Recordset>

</ns:ZFileDemo>

Why does "</Recordset>" still exist?

I am confused "ignoreRecordsetName" doesn't work!!

Regards

Ming

[Former Member]

I got it

Document Name: ZFileDemo

Document NameSpace:http://hand-china.com/mm/po_01

<b>Recordset Structure:Item,1</b>

Recordset Sequence:Ascending

should be

Document Name: ZFileDemo

Document NameSpace:http://hand-china.com/mm/po_01

<b>Recordset Structure:Item,*</b>

Recordset Sequence:Ascending

[Former Member]

Hi,

Correct ,

if record strucute is not there then Item,*

and processing parameters item.fieldseparator :, like..

Regards

Chilla

<i>reward points if it is helpful..</i>

[former_member184619]

Hi Ming,

Use Item.endSeparator = 'nl'

in parameters

Sachin

[Former Member]

What is the SP you are in?

Regards,

Jai Shankar

[Former Member]

netweaver 2004s sps11

the latest sp

Regards

Ming

[Former Member]

Ming,

Have not worked in SP 11 yet. But there was a bug in some old SP. The same problem. It was documented in OSS Notes.

The note is 791737

But before we go there, a small check. You need to press Enter key after writing the parameter igonreRecordsetName true

I hope you have done this.

Regards,

Jai Shankar

[Former Member]

Hi,

This not bug in SP11, but this is related to XI 3.0 ,please see the note and check the solution

<i>As of patch #4 of Support Package 9 for the XI ADAPTERFRAMEWORK CORE 3.0 software component, the described behavior can be configured:

1) By default, the structure is created with a <Recordset> element.

2) If you set the parameter "ignoreRecordsetName" to "true" (without inverted commas in each case) in the structure configuration table, the <Recordset> element is not inserted. This also works if you define several structures per recordset</i>

Regards

Chilla

[Former Member]

Hi Chilla,

I dint mean this OSS note was for SP11. I encountered this problem when I was working with SP 09 in XI 3.0. I searched for a OSS note and found this. I gave the note here only coz it was the same problem and I do agree this soln is not applicable for SP 11 of PI 7.0.

Regards,

Jai Shankar

[Former Member]

Hi,experts:

What should i do now.

I don't want to change the data type in IR

Regards

Ming

[Former Member]

Hi,

Did you use enter key after the paramater?

Regards,

Jai Shankar

[Former Member]

Hi,

Can you plz give the occurrences of structure ,

Try the following.

Recordset -- -0.1

item -- 0..unbound

then recordset Recordset,item,*

and processing pearameters : item.fieldNames : give names

item.fieldSeparator : ,

item.endSeparator :'nl'

Regards

Chilla

[Former Member]

i tried ,but no luck

[Former Member]

There is no recordset in my structure.

ZFileDemo ComplexType

Item 1..unbounded

ItemNo 1

Matnr 1

Text 1

[Former Member]

Hi,

ignoreRecordsetName

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.

See the below links to get more details about File Content Conversion,

http://help.sap.com/saphelp_erp2005vp/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC - MDM

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

Regards

Chilla