How to Display number of Records in Single XML file

[Former Member]

Hi,

In My SAP MDM DataManager I have a table called Location it contains 3 Fields. And Having 10000 Records in that.

When I am trying to make xml file through MDM Syndication Manager it is creating 10000 xml files.

I don't want to that much files and I need all the Records in a Single XML File, how can I do that in MDM Syndication server.

I have changed xsd:element attribute maxoccurs="unbound"

but there is no property like that.

I am using SAP MDM 5.5 with SP 4.

how can I see all my records in single XML file.

Thanks and Regards,

Ashok.

[Former Member · Accepted solution]

hi,

To syndicate all XML records in single XML file:

follow the steps:

1. u201CIn the Destination Items pane, click on the root ( for product repository - Product).

2. u201CIn the Properties pane, for the Repeatable XML Node field, uncheck its u201CInheritu201D flag and check its flag in the u201CValueu201D column as shown below. This will cause all records to be syndicated into one XML file.u201D

3. In the item mapping tab:

In the Source Items page, select the root node,

. u201CIn the Destination Items pane, select the Products node and map it,

and do the remaining source and destination fields mapping,

now you will get all records in single XML file.

hope this may help you,

Regards,

Srinivas

[Former Member]

Open your syndication map in the MDM Syndicator. Go to the tab Map Properties. Change the property XML File Output to Single File (All Records). That would fix your problem.

Thanks

[Former Member]

Hi,

I am using SAP MDM5.5 with SP4 there is no option like that in My Syndication Server.

Regards,

Ashok.