Loading XML files to PostgreSQL database using Talend

_AnonymousUser — Thu, 23 Jul 2015 16:10:05 GMT

Hi
We had of XML files that we loaded into our database, but each file only has 1 row in the table, where as each file has several rows. I believe this is because it is only recording the first entry for a node, and not all of the remaining entries. In the code example below, you will see that for Invoice items, there is 2 items in the code, but Talend is only picking up the first item, before being loaded into the database. Is there a way that the other items in the node that belong to the same tag can be imported into the database?
Thanks,
Killian

-<InvoiceItems>
 -<Item>
  <Description>ABC</Description>
  <Type>X-Ray</Type>
  <AmountExVAT>35.00</AmountExVAT>
  <InvoiceNumber/>
  <Date>2007-04-15</Date>
 </Item>
 -<Item>
  <Description>XYZ</Description>
  <Type>Medication</Type>
  <AmountExVAT>65.00</AmountExVAT>
  <InvoiceNumber/>
  <Date>2007-04-15</Date>
 </Item>
</InvoiceItems>

Re: Loading XML files to PostgreSQL database using Talend

Anonymous — Fri, 31 Jul 2015 10:00:04 GMT

Hi,
Could you please check a component TalendHelpCenter:tFileInputMSXML which reads and outputs multiple schema within an XML structured file?
Best regards
Sabrina

topic Loading XML files to PostgreSQL database using Talend in Talend Studio

Loading XML files to PostgreSQL database using Talend

Re: Loading XML files to PostgreSQL database using Talend