Skip to Content
0
Former Member
Jun 05, 2008 at 10:48 PM

Source XML File Issue....

42 Views

Hi All,

I am importing a source xml file using import manager.But the Number of root nodes changes in the source file changes when i import a xml file with only 1 record and multiple record.So I am unable to maintain a same map for the same xml file with different records.I guess something is wrong in my xml structure.

This is my source xml file:

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

>><ns1:MT_MDM_003_Shipping xmlns:ns1="urn:HaworthInc-com:Customer_Master">

>><Record>

>><Sales_Organization>1001</Sales_Organization>

>><Distribution_Channel>00</Distribution_Channel>

>></Record>

>><Record>

>><Sales_Organization>1001</Sales_Organization>

>><Distribution_Channel>00</Distribution_Channel>

>></Record>

>></ns1:MT_MDM_003_Shipping>

If i use the above file in the import manager I am seeing the Source dropdown (Source Hierarchy) where we select the source file as

>>None

>>ns1:MT_MDM_003_Shipping

>>Records

If i use the same import file with just 1 record as follows

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

>><ns1:MT_MDM_003_Shipping xmlns:ns1="urn:HaworthInc-com:Customer_Master">

>><Record>

>><Sales_Organization>1001</Sales_Organization>

>><Distribution_Channel>00</Distribution_Channel>

>></Record>

>></ns1:MT_MDM_003_Shipping>

If i use the above file in the import manager Now I am seeing the Source dropdown (Source Hierarchy) where we select the source file as only.Records is missing

>>None

>>ns1:MT_MDM_003_Shipping

>>Records (This is missing now)

Since I am missing the Records I have to create the different map for the same file.

Is there anything missing in the XML???Or the XML structure is wrong????

Any Help greatly appreciated.