XMLParser skipping to the last tag in a set of tags

Mogale

New Member
I am reading an XML file into a datatable like this:\[code\]DataTable dt = XMLParser.XMLRead.ReadeFormXMLFile(filePath, "my:myFields");\[/code\]however it is not capturing ALL the fields.There are multiple practitionerlastnames and practitionerfirstnames and practitionerNPIs:\[code\] <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>\[/code\]however they are not being included. What it is currently doing is taking the LAST record in \[code\]group2\[/code\] and ignoring all the records preceeding this one:\[code\]<my:PractitionerFirstName>Kim</my:PractitionerFirstName><my:PractitionerLastName>John</my:PractitionerLastName><my:PractitionerNPI>1234567890</my:PractitionerNPI><my:PractitionerDegree>DO</my:PractitionerDegree>\[/code\]question: what would cause XML parser to grab only the last record from \[code\]group2\[/code\] and omit everything else ?
 
Back
Top