Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
0 Points
2 Posts
Aug 01, 2012 07:17 PM|LINK
I am a new comer to the XML world and I am having some issues parsing an XML file for my console app:
here's the file
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
Imports System.IO
Imports System.Xml
Module ParsingUsingXmlDocument
Sub Main()
mf_xmld = New XmlDocument()
'Load the Xml file
xmlnsManager.AddNamespace("nds", "http://www.int.com.sc/MF_File")
'Get the list of name nodes
mf_nodelist = mf_xmld.SelectNodes("/nds.MF_File/nds.Batch/nds.Package", xmlnsManager)
'Loop through the nodes
For Each mf_node In mf_nodelist
Dim customerpackagekeyvalue = mf_node.ChildNodes.Item(0).InnerText
Dim interceptpackagekeyvalue = mf_node.ChildNodes.Item(1).InnerText
Dim dispositionIdvalue = mf_node.ChildNodes.Item(2).InnerText
Dim DispositionDescriptionvalue = mf_node.ChildNodes.Item(3).InnerText
'Error trapping
Console.Write(errorVariable.ToString())
End Try
End Sub
End
Module
I don't have a good understanding of how this stuff works. Can anyone help me make sense of it? I just want to parse out the package information.
Christmas
0 Points
2 Posts
Rehashing the XMLDocument and xmlns topic
Aug 01, 2012 07:17 PM|LINK
I am a new comer to the XML world and I am having some issues parsing an XML file for my console app:
here's the file
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<div class="e"> <div style="text-indent: -2em; margin-left: 1em;" class="c">- <NewDataSet xmlns="http://www.int.com.sc/MF_File"></div> <div style="text-indent: -2em; margin-left: 1em;" class="c"> </div> <div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;" class="c">- <MF_File xmlns="http://www.int.com.sc/MF_File" version="1.0"></div> <div style="text-indent: -2em; margin-left: 1em;" class="c"> </div> <div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><MFFileID>File12345</MFFileID></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><FileType>MF</FileType></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><FileDateTime>2012-07-19T16:58:18.210-04:00</FileDateTime></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><JobControlNumber>ABSCFRG_12</JobControlNumber></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><TotalPackages>1</TotalPackages></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><PrintCompleteDateTime>2012-07-19T17:58:18.210-04:00</PrintCompleteDateTime></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><InsertCompleteDateTime>2012-07-19T18:58:18.210-04:00</InsertCompleteDateTime></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><SortCompleteDateTime>2012-07-19T19:00:18.210-04:00</SortCompleteDateTime></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;" class="c">- <Batch></div> <div style="text-indent: -2em; margin-left: 1em;" class="c"> </div> <div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><PrintFileName>PrintFile1</PrintFileName></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;" class="c">- <Package></div> <div style="text-indent: -2em; margin-left: 1em;" class="c"> </div> <div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><CustomerPackageKey>00000000000001</CustomerPackageKey></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><IncepturePackageKey>11111111111111Q</IncepturePackageKey></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><DispositionId>5</DispositionId></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;"><DispositionDescription>Insert Successful</DispositionDescription></div> <div style="text-indent: -2em; margin-left: 1em;"> </div> </div> <div></Package></div> <div> </div> </div> </div> <div class="e"> <div style="text-indent: -2em; margin-left: 1em;" class="c">- <</Batch></div> <div style="text-indent: -2em; margin-left: 1em;" class="c"> </div> </div> </div> </div> <div></MF_File></div> <div> </div> </div> </div> <div></NewDataSet></div> <div> </div> <div>Here's my code:</div> <div> </div>Imports System.IO
Imports System.Xml
Module ParsingUsingXmlDocument
Sub Main()
<div>Try</div> <div>'Dim mf_xmld As New XmlDocument</div> <div>Dim mf_xmld As New System.Xml.XmlDocument()</div> <div>Dim mf_nodelist As XmlNodeList</div> <div>Dim mf_node As XmlNode</div> <div>'Create the XML Document</div>mf_xmld = New XmlDocument()
'Load the Xml file
<div>mf_xmld.Load("C:\testxml.xml")</div> <div>Dim xmlnsManager As New System.Xml.XmlNamespaceManager(mf_xmld.NameTable)</div>xmlnsManager.AddNamespace("nds", "http://www.int.com.sc/MF_File")
'Get the list of name nodes
mf_nodelist = mf_xmld.SelectNodes("/nds.MF_File/nds.Batch/nds.Package", xmlnsManager)
'Loop through the nodes
For Each mf_node In mf_nodelist
Dim customerpackagekeyvalue = mf_node.ChildNodes.Item(0).InnerText
Dim interceptpackagekeyvalue = mf_node.ChildNodes.Item(1).InnerText
Dim dispositionIdvalue = mf_node.ChildNodes.Item(2).InnerText
Dim DispositionDescriptionvalue = mf_node.ChildNodes.Item(3).InnerText
'Error trapping
Console.Write(errorVariable.ToString())
End Try
End Sub
End
Module
</div> </div>I don't have a good understanding of how this stuff works. Can anyone help me make sense of it? I just want to parse out the package information.