on 03-04-2010 11:13 AM
Hi,
I want to generate XML file from syndicator, I have provided the XSD in destination properties. I am unable to see the properties
XML File Output, Repeatable record Name in Map properties tab.
I am able to generate XML file but it is generating individual XML file for each record.I need to set the valus for XML File Output as single File(All records), but I am unable to find this properties in the syndicator.I am using the version "5.5 SP4".
Can any one help on this.
Regards,
Venki.
Hi,
As far as I remember, These properties were unavailable in MDM 5.5 SP04.
So the requirement to have Multiple records in single file was handled at Item Mapping level.
Suppose you want to Syndicate Data from Product Repository. Create your Destination structure something like This:
<Records>
<Product>
<product_number><product_number/>
<Description><Description/>
.....
<Product/>
<Records/>
i.e. It should have a root element. In the above mentioned structure, "Product" tag will have 1 to unbounded occurrence. Now map You Main table with product Node to the destination. This way it will syndicate all product data in a single file.
Try it and let me know the result.
Regards,
Shiv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi shiv,
Thanks for reply, here with I am attaching XSD file am using.
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="QualifierTable">
<xs:complexType>
<xs:sequence>
<xs:element name="name" type="xs:string"/>
<xs:element name="gender" type="xs:boolean"/>
<xs:element name="marks" type="xs:integer"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Can you please look into it and suggest if any changes needed.
Regards,
Venki.
Hi,
I think with this XSD you may face problem. Try by adding a root element on top of "Qualifier Table"
I don't have MDM SP04 system avaiable to test but give a try with XSD like this
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Records">
<xs:complexType>
<xs:sequence>
<xs:element name="Qualifier_Table" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="Name" type="xs:string"/>
<xs:element name="Gender" type="xs:boolean"/>
<xs:element name="Marks" type="xs:integer"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Check it and revert with the result.
Regards,
Shiv
Hi Venki,
WIth the xsd you will always have one file as an output file in your service pack. Change the schema like this:
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="QualifierTable">
<xs:complexType>
<xs:sequence>
<xs:element name="Records" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="marks"/>
<xs:element name="gender"/>
<xs:element name="name"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Just copy and paste and save this xsd and use it directly. Now while mapping map like shiv mentioned. The root of the source map to Records and map the individuals fields accordingly. Then you will have all the records in one file when you syndicate.
If you have latest version then you have the option as mentioned in this docuemtn:
Regards,
---Satish
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.