Using xml: XMLParser skipping to the last tag in a set of tags on newest questions tagged xml – Stack Overflow
I am reading an XML file into a datatable like this:
DataTable dt = XMLParser.XMLRead.ReadeFormXMLFile(filePath, "my:myFields");
however it is not capturing ALL the fields.
There are multiple practitionerlastnames and practitionerfirstnames and practitionerNPIs:
<my:group1>
<my:group2>
<my:PractitionerFirstName>Joe</my:PractitionerFirstName>
<my:PractitionerLastName>Limits</my:PractitionerLastName>
<my:PractitionerNPI>0987654321</my:PractitionerNPI>
<my:PractitionerDegree>MD</my:PractitionerDegree>
</my:group2>
<my:group2 xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-06T05:56:10">
<my:PractitionerFirstName>Him</my:PractitionerFirstName>
<my:PractitionerLastName>Haw</my:PractitionerLastName>
<my:PractitionerNPI>1234567890</my:PractitionerNPI>
<my:PractitionerDegree>PA</my:PractitionerDegree>
</my:group2>
<my:group2 xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-06T05:56:10">
<my:PractitionerFirstName>Mike</my:PractitionerFirstName>
<my:PractitionerLastName>Kim</my:PractitionerLastName>
<my:PractitionerNPI>1234567890</my:PractitionerNPI>
<my:PractitionerDegree>DO</my:PractitionerDegree>
</my:group2>
<my:group2 xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-06T05:56:10">
<my:PractitionerFirstName>Vanilla </my:PractitionerFirstName>
<my:PractitionerLastName>Ice</my:PractitionerLastName>
<my:PractitionerNPI>1231231231</my:PractitionerNPI>
<my:PractitionerDegree>MD</my:PractitionerDegree>
</my:group2>
<my:group2 xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-06T05:56:10">
<my:PractitionerFirstName>Kim</my:PractitionerFirstName>
<my:PractitionerLastName>John</my:PractitionerLastName>
<my:PractitionerNPI>1234567890</my:PractitionerNPI>
<my:PractitionerDegree>DO</my:PractitionerDegree>
</my:group2>
</my:group1>
however they are not being included. What it is currently doing is taking the LAST record in group2 and ignoring all the records preceeding this one:
<my:PractitionerFirstName>Kim</my:PractitionerFirstName>
<my:PractitionerLastName>John</my:PractitionerLastName>
<my:PractitionerNPI>1234567890</my:PractitionerNPI>
<my:PractitionerDegree>DO</my:PractitionerDegree>
question: what would cause XML parser to grab only the last record from group2 and omit everything else ?
See Answers
source: http://stackoverflow.com/questions/10358793/xmlparser-skipping-to-the-last-tag-in-a-set-of-tags
Using xml: using-xml
Recent Comments