Tuesday, 11 October 2016

XML : xml file to database

I have an xml file with the following format:

  <DATASET>  <ROW1>  <ITCHS>01012100</ITCHS>  <DESCRIPTION>Animals</DESCRIPTION>  <HS4>HORSES </HS4>  <HS5>Horses</HS5>  <HS6>Horses</HS6>  <HS8>Purebred </HS8>  <POLICY>Restricted</POLICY>  <CONDITION/>  </ROW1>  <ROW2>  <ITCHS>01012910</ITCHS>  <DESCRIPTION>Horses for Polo</DESCRIPTION>  <HS4>MULES AND HINNIES</HS4>  <HS5>Horses</HS5>  <HS6>Other</HS6>  <HS8>Horses for Polo</HS8>  <POLICY>Restricted</POLICY>  <CONDITION/>  </ROW2>  <ROW3>  .  .  .    

I've tried the suggestions seen in other posts, but the structure of my xml file is slightly different from the rest: It's labelled as <row1> <row2> <row3> ... instead of a constant I'm not sure whether that makes a difference, but what I've tried didn't work so far. Thanks!

No comments:

Post a Comment