Urgent : Help with XSD

[Former Member]

We are tring to syndicate the vendor numbers only from vendor repository in xml format. I created an XSD for the same. See the XSD below :

-

---

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

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

<xs:element name="Vendors">

<xs:complexType>

<xs:sequence>

<xs:element name="LIFNR" type="xs:string" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

-

---

XSD validates fine and generates an output from syndicator, but the problem that we face is that this is creating 1 file for each vendor record. We want a consolidated file. I know I am missing something but cannot make it to work.

I tried to put the unbounded parameter in <xs:element name="Vendors"> but that makes the XSD invalid.

Need urgent help on this.

Thanks

[Former Member · Accepted solution]

You have created Vendors as the root element of the XSD. This will not work.

Create a new XSD, where the root element is say <b>Vendor</b><b>s</b>.

Create a complex type called <b>Vendor</b> which is unbounded.

This complex type could contain elements like Vendor Number.

Now do the mapping in syndicator.

The main table Vendor Number in MDM should be mapped to the repeatable node Vendor.

Also in the Destination Items tab in Syndicator, make sure the "Repeatable XML node" is checked for Vendor element.

After mapping you can see if it worked in the Destination Preview tab.

[Former Member · Accepted solution]

Adhappan,

Trying to create an xsd as per what you said but am getting validation error. Would appreciate if you could correct the one that I posted in my initial message. Need to get this resolved fast.

Thanks

[Former Member · Accepted solution]

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

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

<xs:element name="Vendors">

<xs:complexType>

<xs:sequence>

<xs:element name="Vendor" type="Vendor" minOccurs="0" maxOccurs="unbounded"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:complexType name="Vendor">

<xs:sequence>

<xs:element name="LIFNR" type="xs:string"/>

</xs:sequence>

</xs:complexType>

</xs:schema>

[Former Member · Accepted solution]

Thanks buddy.. worked .

[Former Member]

Have you mapped the IDOC in destination to the Main table(Products) in the Item mapping?

Pls check.