Loading complex XML file into MySQL tables

One Star

Loading complex XML file into MySQL tables

Hi,
I am very new to Talend and I am trying to parse a complex XML file and load into multiple MySQL tables.
here is a snippet of the file that I am trying to load.
<?xml version="1.0" encoding="UTF-8"?>
-<hasMember>

    -<OrganisationAuthority gml:id="OrganisationAuthority1" xmlns="">
         <identifier xmlns="" codeSpace="">d34e4849-77d1-4b77-a5cd-8d3cec72a451
         </identifier>
-<timeSlice>
   -<OrganisationAuthorityTimeSlice gml:id="OrganisationAuthority1_TS1">
 -<validTime xmlns="">
    -<TimePeriod ns:id="OrganisationAuthority1_TS1_TP1" xmlns:ns="">    
        <beginPosition>2013-01-10T09:01:00Z  
         </beginPosition>   
         <endPosition indeterminatePosition="unknown"/>
   </TimePeriod>
</validTime>
   <interpretation>BASELINE</interpretation>
   <sequenceNumber>1</sequenceNumber>
   <correctionNumber>0</correctionNumber>
-<featureLifetime>
  -<TimePeriod ns:id="OrganisationAuthority1_TP1" xmlns="" xmlns:ns="">
    <beginPosition>2013-01-10T09:01:00Z
    </beginPosition>
    <endPosition indeterminatePosition="unknown"/>
  </TimePeriod>
  </featureLifetime>
  <name>R-2508 COMPLEX CONTROL BOARD</name>
  <designator>R2508CCB</designator>
  <type>OTHER</type>
  </OrganisationAuthorityTimeSlice>
  </timeSlice>
  </OrganisationAuthority>
</hasMember>
-<hasMember>
-<OrganisationAuthority gml:id="OrganisationAuthority2" xmlns="">
<identifier xmlns="" codeSpace="">D0598777-DFB5-7019-E044-00144F1E5345
</identifier>
-<timeSlice>
-<OrganisationAuthorityTimeSlice gml:id="OrganisationAuthority2_TS1">
-<validTime xmlns="">
-<TimePeriod ns:id="OrganisationAuthority2_TS1_TP1" xmlns:ns="">
      <beginPosition>2012-11-15T09:01:00Z
      </beginPosition>
      <endPosition indeterminatePosition="unknown"/>
      </TimePeriod>
   </validTime>
<interpretation>BASELINE</interpretation>
<sequenceNumber>1</sequenceNumber>
<correctionNumber>0</correctionNumber>
-<featureLifetime>
-<TimePeriod ns:id="OrganisationAuthority2_TP1" xmlns="" xmlns:ns="">
   <beginPosition>2012-11-15T09:01:00Z
   </beginPosition>
   <
endPosition indeterminatePosition="unknown"/>
</TimePeriod>
</featureLifetime>
<name>FEDERAL AVIATION ADMINISTRATION</name>
<designator>FAA</designator>
<type>NTL_AUTH</type>
</OrganisationAuthorityTimeSlice>
</timeSlice>
</OrganisationAuthority>
</hasMember>
I would like to insert the data into two tables; parent_table and parent_time_slice table,. can someone point me in the right direction?
thanks
Rajani
Highlighted
One Star

Re: Loading complex XML file into MySQL tables

I am sorry, I didn't realize that I posted this question under the wrong topic. Please let me know if I should repost the question under a different thread.
thanks
Rajani

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.