cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

XSD Syndication Problem..

Go to solution
Former Member

on ‎10-06-2006 3:00 PM

0 Kudos

Hi All,

I want to transfer data from mdm through syndicator.

I created the follwing xsd file in xi.(message mapping)

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http:
mycompany.com\mdm" targetNamespace="http:
mycompany.com\mdm">

<xsd:element name="MT_Customer" type="DT_Customer" />

<xsd:complexType name="DT_Customer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

495dde70551e11db9e560011433286d8

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Customer_Data">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a30550b11dbcb99cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Customer" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a31550b11dba3f2cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Title" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a32550b11dbcc76cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Name1" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a33550b11db9c96cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Name2" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a34550b11dbbbc7cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Name3" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a35550b11db8470cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Name4" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a36550b11dbb3bfcf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Searchterm1" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a37550b11dbae35cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Searchterm2" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a38550b11dbb7c9cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="City_Post_Code" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a39550b11dba621cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="City" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a3a550b11db9287cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Country" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a3b550b11dbb137cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Region" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a3c550b11dbcc68cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Noof_Employees" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a3d550b11db8a29cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Annual_Sales" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a3e550b11dbbe2bcf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Currency_Of_Sales" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a3f550b11dbb901cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Pobox" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a40550b11db97aecf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Language" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a41550b11dba4becf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Salesdata" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

13886a42550b11dbae61cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Bank_Details" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

1f101890551e11dbc760cf9a0abc902e

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

And add xml shema entry in mdm console for the above schema.

When I try to set destination properties in syndicator...

I selected XMLSchema as type,client system,schema name. but,I am not able to select any <b>root</b> for it and I am not able to go proceed in syndication.

Is there any problem in the above xsd file ?

Please help me.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎10-06-2006 3:25 PM
0 Kudos

Hello Rama:

It happends because on your XSD you didn't define a data root tag:

<b><xsd:element name="dataroot">

</b>

I here paste an example of this. Please note how Office Access wrapped it all on the dataroot tag:


<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:od="urn:schemas-microsoft-com:officedata">
<xsd:element name="dataroot">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="SP1PERS" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="generated" type="xsd:dateTime"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="SP1PERS">
<xsd:annotation>
<xsd:appinfo>
<od:index index-name="PrimaryKey" index-key="SPBPERS_PIDM " primary="yes" unique="yes" clustered="no"/>
<od:index index-name="STVNATN_CODE" index-key="STVNATN_CODE " primary="no" unique="no" clustered="no"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="SPBPERS_PIDM" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SP1PERS_HEIGHT_x0020_" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SP1PERS_FECHA_MATRIMONIO" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ST4TTRA_TITULO_TRATO" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="STVNATN_CODE" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="GTVZIPC_CODE_LUGAR_NACIMIENTO" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="GTVZIPC_CODE_LUGAR_PROCEDENCIA" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SP1PERS_CURP" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SP1PERS_ACTIVITY_DATE" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SP1PERS_USER_x0020_" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Field11" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="255"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>

I hope that helps

Regards

Alejandro

Show replies
Show replies

Answers (0)

Ask a Question