Input XML file with hierarchy

Anonymous — Sat, 19 Nov 2016 00:47:46 GMT

Hello, new here. I did try searching for this issue, but didn't see anything relevant for an input file.
I am trying to take an XML file that contains a hierarchy of data and import it into Salesforce.
An example of the file is attached as taxonomy_sample.xml.txt.txt.
And the XSD is attached as taxonomy.xsd.zip.zip.

Notice how the "taxonomy" element contains a sequence element "record", and if you look at this complex type, it has a sequence element of "record". What you then have is a hierarchy of "record".
I created my data model in Salesforce where I have a "Parent" lookup relationship custom field that I will use to create this hierarchy.
When I try to add this file as an XML input file, Talend Open Studio is locking up.

Also note that the real file is somewhat large at 22mb and has about 10k entries total.

Any suggestions how can I get this input file read into Talend and import it into Salesforce?
taxonomy_sample.xml.txt.txttaxonomy.xsd.zip.zip

Re: Input XML file with hierarchy

Anonymous — Sat, 19 Nov 2016 00:50:03 GMT

It doesn't look like the files uploaded, trying again in a single archive.
xml_hierarchy.zip.zip

topic Re: Input XML file with hierarchy in Talend Studio

Input XML file with hierarchy

Re: Input XML file with hierarchy