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