cancel
Showing results for 
Search instead for 
Did you mean: 

Syndication in only one XML

0 Kudos
66

Hallo MDM Guru,

I need your Input please. I have Syndicated 300 Record. But I would like to have only one XML with all Records. But now have 300´XML file auf my Desktop. Could you tell me who i Ann´have only one XML

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member205403
Active Contributor
0 Kudos

H Badang,

By default, the MDM Syndicator creates a separate XML file for each

syndicated record. For syndicating Data into one file Proceed as Follows:

<b>1--></b>On the Destination Items tab, select the destination item that

represents the “record” element in the XML schema.(This is usually

the node just below the root item.) and check the Repeatable XML Node property is enabled for this node.

<b>2--></b>On the Item Mapping tab, map the <b>root source item</b> to the <b>destination

item node</b> representing the “record” element. Do not map the root source item to the root destination node.

<b>3--></b>Execute the syndication.

Hope this will solve your problem.Revert back to me for further queries.

Thanks,

<b>Shiv.</b>

0 Kudos

Hi Shiv. ,

thanks for your Input. I have doing what you say. but I would not successfully!

I am going to try more this Morning.

Thanks

Dominique

Former Member
0 Kudos

hello:

can you post your schema?

regards

Alejandro

Former Member
0 Kudos

Hi Alejandro,

thanks for your Feedback. here is my Schema.

?xml version="1.0" encoding="UTF-8"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">

<xs:element name="Data">

<xs:complexType>

<xs:sequence>

<xs:element ref="Record"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="Record">

<xs:complexType>

<xs:sequence>

<xs:element ref="Materialnummer"/>

<xs:element ref="Beschreibung"/>

<xs:element ref="Hertellername"/>

<xs:element ref="Herstellernummer"/>

<xs:element ref="Preis"/>

<xs:element ref="Gewicht"/>

<xs:element ref="Gewichteinheit"/>

<xs:element ref="Menge"/>

<xs:element ref="Mengeneiheit"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="Materialnummer">

<xs:complexType/>

</xs:element>

<xs:element name="Beschreibung">

<xs:complexType/>

</xs:element>

<xs:element name="Hertellername">

<xs:complexType/>

</xs:element>

<xs:element name="Herstellernummer">

<xs:complexType/>

</xs:element>

<xs:element name="Preis">

<xs:complexType/>

</xs:element>

<xs:element name="Gewicht">

<xs:complexType/>

</xs:element>

<xs:element name="Gewichteinheit">

<xs:complexType/>

</xs:element>

<xs:element name="Menge">

<xs:complexType/>

</xs:element>

<xs:element name="Mengeneiheit">

<xs:complexType/>

</xs:element>

</xs:schema>

I have try dies Morning unsuccessfully. I done all step but i can not have all Record in only one XML.

Former Member
0 Kudos

Hi Dominique,

select "Record" as "Repeatable XML Node" in the destination items tab (instead of Inherit check box), save and execute map.

HTH

--

Venkat

Former Member
0 Kudos

Hi Venkat

I Thank for your Feedback, I done what you say. But I was one More unsuccessfully. I don't know what am doing false. I wrote the Syndicator Guide. But when i like for example to enable the two Check Box like the Guide, is not Possible.

Regards

Dominique

former_member205403
Active Contributor
0 Kudos

Hi Dominique,

On the Destination Items tab, select the destination record element in the XML schema (This is usually the node just below the root item.) and uncheck the first check box (inherit) and check the second one(value).After this in the Item Mapping tab, map the root source item to the destination record element and execute the syndication.

Hope this will solve your problem.Revert back to me for further queries.

Thanks,

<b>Shiv. </b>

michael_theis
Advisor
Advisor
0 Kudos

Hi Dominique,

is it possible for you to upgrade to latest MDM SP05 Patch 1 which is GA as of today?! Using the latest syndicator version you can define this behavior with a new feature of the Map Properties Tab.

Kind regards

Michael

Former Member
0 Kudos

Hi Michael,

Thanks for the Input. I hope upgrade is my latest Chance. Because until now All attempts were in vain.

Best Regards.

Dominique

michael_theis
Advisor
Advisor
0 Kudos

Hi Dominique,

just another short note: opening your schema definition from above with Altova XMLspy indicates, that your <Record> element is not defined as repeatable element. You could try the following change in the XSD as well:

Add the attribute maxOccurs="unbounded" to the element Record definition (see below).

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="Data">
<xs:complexType>
<xs:sequence>
<xs:element ref="Record" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Record">
<xs:complexType>
<xs:sequence>
<xs:element ref="Materialnummer"/>
<xs:element ref="Beschreibung"/>
<xs:element ref="Hertellername"/>
<xs:element ref="Herstellernummer"/>
<xs:element ref="Preis"/>
<xs:element ref="Gewicht"/>
<xs:element ref="Gewichteinheit"/>
<xs:element ref="Menge"/>
<xs:element ref="Mengeneiheit"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Materialnummer">
<xs:complexType/>
</xs:element>
<xs:element name="Beschreibung">
<xs:complexType/>
</xs:element>
<xs:element name="Hertellername">
<xs:complexType/>
</xs:element>
<xs:element name="Herstellernummer">
<xs:complexType/>
</xs:element>
<xs:element name="Preis">
<xs:complexType/>
</xs:element>
<xs:element name="Gewicht">
<xs:complexType/>
</xs:element>
<xs:element name="Gewichteinheit">
<xs:complexType/>
</xs:element>
<xs:element name="Menge">
<xs:complexType/>
</xs:element>
<xs:element name="Mengeneiheit">
<xs:complexType/>
</xs:element>
</xs:schema>

This might help as well because the uses XML/XSD parser in MDM is very strict.

Kind regards

Michael