Some fields not importing from XML when using Import Sets

[jfarrer]

I have an XML feed that I am trying to consume using Import Sets but it is not getting all of the data. As near as I can tell, it is only looking at the XML elements that exist in the first record, but not all of the elements exist in the first record such as address information, but in later records they are there. It only created and populated the fields that exist in the first record. When I made a custom example file with the second record and tried it with that then it created and populated the fields just fine.

Here is an example:

 <ROW>
   <ID>1887</ID>
   <LAST_NAME>EXAMPLE VENDOR</LAST_NAME>
   <CUST_TYPE>VENDOR</CUST_TYPE>
   <BILL_REFERENCE>C123456</BILL_REFERENCE>
   <TAX_CODE>State</TAX_CODE>
   <STATUS>1</STATUS>
   <BILLING_CYCLE>V</BILLING_CYCLE>
   <CUST_NO>C123456</CUST_NO>
 </ROW>
 <ROW>
   <ID>1580</ID>
   <LAST_NAME>ANOTHER ONE</LAST_NAME>
   <FIRST_NAME>JOHN DOE</FIRST_NAME>
   <CUST_TYPE>VENDOR-NONTAXABLE</CUST_TYPE>
   <BILL_REFERENCE>C654312</BILL_REFERENCE>
   <TAX_CODE>None</TAX_CODE>
   <STATUS>1</STATUS>
   <BILLING_CYCLE>V</BILLING_CYCLE>
   <CUST_NO>C654312 DOE</CUST_NO>
   <ADDR1>123 COUGAR WAY</ADDR1>
   <ADDR2>#1234</ADDR2>
   <CITY>PROVO</CITY>
   <STATE>UT</STATE>
   <ZIP>84602</ZIP>
 </ROW>

I have a work around in place in this case and I know I could manually retrieve and import the data but I don't think I should have to do that.

Any thoughts?

Thanks,

[jfarrer]

Yes, it worked fine with the repeated rows. Having repeated rows like that is expected. As an example, an XML exports of records from ServiceNow has repeating rows that same way.

You may want to check to make sure the tags in your XML are matched up properly. You may also want to try doing a test import with an export from SN to see if that works.

[anujamps]

Thank you very much for the fast reply.

I apologize for the confusion. Let me be more clear. I have an XML with two subchilds having the same name

This is the structure of my file

root

---child

------subchild

------subchild

------subchild1

I want to import it as a single record on the import set. I am giving the xpath: /root or /*

it is populating the whole XML file except for the the second subchild.

When I tried to to export the file I am getting the entire data of the XML file even the second subchild. I am not sure if this is a display issue.

Any idea on how to do this?

I have posted a discussion on the community-

XML File Import?

[jfarrer]

Off the top of my head I'm not sure if there's a way to get both subchild elements in the standard import process. It may be something where you have to do some manual parsing of the record but I'm not sure on that either without some more research into it.

[anujamps]

Thank you for the reply.

We have implemented a parser to do the mapping and it is working perfectly fine.

[Ruchi19]

hi Anusha,

i am trying to do the same thing. can you please guide me on XML parser which you implemented?

thanks for the help