on 03-15-2007 4:36 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<?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>
Have you mapped the IDOC in destination to the Main table(Products) in the Item mapping?
Pls check.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.