Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XML data import with Import Server

Hi ,

I am doing a small POC. I am trying import data automatically from a xml using MDIS (Master Data Import Server) . It is giving the StructuralX exception . But using the same xml and xml schema the data is getting loaded into repository while using Import Manager.

Can any one tell me what is wrong in my XML or XML schema.

XML -->

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

<Products>

<Product>

<Name>Acer</Name>

<Category>Laptop</Category>

<PID>1002</PID>

</Product>

<Product>

<Name>Apple IPhone</Name>

<Category>Mobile</Category>

<PID>1004</PID>

</Product>

<Product>

<Name>Canon</Name>

<Category>Digital camera</Category>

<PID>1006</PID>

</Product>

<Product>

<Name>Motorola</Name>

<Category>Mobile</Category>

<PID>1003</PID>

</Product>

<Product>

<Name>Nikon</Name>

<Category>Digital camera</Category>

<PID>1005</PID>

</Product>

<Product>

<Name>Nokia</Name>

<Category>Mobile</Category>

<PID>1007</PID>

</Product>

<Product>

<Name>Sony Vaio</Name>

<Category>Laptop</Category>

<PID>1001</PID>

</Product>

</Products>

XML schema -->

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

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" >

<xsd:element name="Products">

<xsd:complexType>

<xsd:sequence maxOccurs="unbounded">

<xsd:element ref="Product"/>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Product" >

<xsd:annotation>

<xsd:documentation>Comment describing your root element

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

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

<xsd:element name="category" type="xsd:string"/>

<xsd:element name="pid" type="xsd:string"/>

<xsd:element name="parentid" type="xsd:string"/>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:schema>

StructuralX exception -->

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

<File>

<ExceptionSubFolder>F:\SAPMDM~1.5\Server\Distributions\MDMORA_ORCL\Product_Repo\Inbound\ImportRemoteSystem\ImportXmlSchemaFile\Exception\StructuralX\</ExceptionSubFolder>

<Name>20080904054914_Prod.xml</Name>

<ExceptionType>StructuralX</ExceptionType>

<TimeStamp>20080904054914_</TimeStamp>

</File>

Any help is appreciated.

Kousik

Edited by: Kousik Mukherjee on Sep 5, 2008 3:16 PM

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question