Jewtus

Struggling with XML parsing

3 posts in this topic

I'm trying to parse an XML file and assign all the elements to various variables to loop through. I've tried using the XMLDomWrapper but that is confusing me even more than just working directly (this is my first time really working with XML)

This is the XML example:

<?xml version='1.0' encoding='UTF-8'?>
<Requests count="1" created="20110412154312">
<request endDate="201104" id="52084" retransmit="N" startDate="200903" submitted="20110412">
    <Rep>
        <lastName>Request</lastName>
        <middleName>R</middleName>
        <firstName>Test</firstName>
        <address>125 West 125th Street, 5th Floor</address>
        <city>New York</city>
        <state>NY</state>
        <zip>12345</zip>
        <phone>555-555-555</phone>
    </Rep>
    <accounts>
        <account Deposit="N">123456</account>
        <account Deposit="N">652983</account>
        <remarks>This is an example.</remarks>
    </accounts>
</request>
</Requests>

I've tried using the following scripts:

$oXML = ObjCreate("MSXML2.DOMDocument")
    ;~ $oXML.loadXML(ClipGet())
    $oXML.load($filename)
    $oXML.setProperty("SelectionLanguage", "XPath")

    ConsoleWrite("!-----------------------------------------------------------------------------------" & @LF & @LF)
    For $oDirectoryRef In $oXML.selectNodes("Requests")
        $sCount= $oDirectoryRef.getAttribute("count")
ConsoleWrite($sCount&@CRLF)
        For $oComponent In $oDirectoryRef.selectNodes("request")
            $sCompID = $oComponent.getAttribute("id")
            $sCompstart = $oComponent.getAttribute("startDate")
            $sCompend = $oComponent.getAttribute("endDate")
ConsoleWrite($sCompID&"|"&$sCompstart&"|"&$sCompend&@CRLF)
            For $oRep In $oComponent.selectNodes("Rep")
                $sRepFName = $oRep.getAttribute("firstName").value
                $sRepMName = $oRep.getAttribute("middleName")
                $sRepLName = $oRep.getAttribute("lastName")
                $sRepAddr = $oRep.getAttribute("address")
                $sRepCity = $oRep.getAttribute("city")
                $sRepState = $oRep.getAttribute("state")
                $sRepZip = $oRep.getAttribute("zip")
                $sRepPhone = $oRep.getAttribute("phone")
ConsoleWrite($sRepFName&"|"&$sRepMName&"|"&$sRepLName&"|"&$sRepAddr&"|"&$sRepCity&"|"&$sRepState&"|"&$sRepZip&"|"&$sRepPhone&@CRLF)
            Next
            For $oAccount In $oComponent.selectNodes("accounts")
                $sDirect = $oAccount.getAttribute("Deposit")
ConsoleWrite($sDirect&@CRLF)
            Next
        Next
    Next
    ConsoleWrite("!---------------------------------------------------------------------------------" & @LF & @LF)

This is the code I've tried using The dom wrapper:

If _XMLFileOpen($filename) Then
        Local $aRoot = _XMLGetChildNodes('/*')
        If Not @error Then
            For $i = 1 To $aRoot[0]
                ConsoleWrite($aRoot[$i] & @LF)
                Local $aRequest = _XMLGetChildNodes('/*/'&$aRoot[$i])
                If Not @error Then
                    For $j = 1 To $aRequest[0]
                        ConsoleWrite(@TAB&$aRequest[$j] & @LF)
                    Next
                EndIf
            Next
        EndIf
    EndIf

All I really want to do is grab the elements and put them in arrays for each of the nodes (putting the values... like direct... as the first line of the array).

 

I know I'm calling the last elements with the wrong function, but I cannot seem to figure out which function I need. I also don't quite understand how to get the value of the node and the elements in the node. Could someone point me in the right direction?

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

I'm getting a little further but I am struggling to figure out how to get the innertext for a node... nodeValue, value, text, innertext, none of them are working, but text does pull back the value of the account node correctly but not on any of the others:

$oXML = ObjCreate("MSXML2.DOMDocument")
    ;~ $oXML.loadXML(ClipGet())
    $oXML.load($filename)
    $oXML.setProperty("SelectionLanguage", "XPath")

    ConsoleWrite("!-----------------------------------------------------------------------------------" & @LF & @LF)
    For $oDirectoryRef In $oXML.selectNodes("Requests")
        $sCount= $oDirectoryRef.getAttribute("count")
        $sCreated= $oDirectoryRef.getAttribute("created")
ConsoleWrite("Root: "&$sCount&"|"&$sCreated&@CRLF)
        For $oComponent In $oDirectoryRef.selectNodes("request")
            $sCompID = $oComponent.getAttribute("id")
            $sCompstart = $oComponent.getAttribute("startDate")
            $sCompend = $oComponent.getAttribute("endDate")
ConsoleWrite("Components: "&$sCompID&"|"&$sCompstart&"|"&$sCompend&@CRLF)
            For $oRep In $oComponent.selectNodes("Rep")
                $sRepFName = $oRep.getAttribute("firstName")
                $sRepMName = $oRep.getAttribute("middleName")
                $sRepLName = $oRep.getAttribute("lastName")
                $sRepAddr = $oRep.getAttribute("address")
                $sRepCity = $oRep.getAttribute("city")
                $sRepState = $oRep.getAttribute("state")
                $sRepZip = $oRep.getAttribute("zip")
                $sRepPhone = $oRep.getAttribute("phone")
ConsoleWrite("Rep: "&$sRepFName&"|"&$sRepMName&"|"&$sRepLName&"|"&$sRepAddr&"|"&$sRepCity&"|"&$sRepState&"|"&$sRepZip&"|"&$sRepPhone&@CRLF)
            Next
            For $oAccounts In $oComponent.selectNodes("accounts")
                For $oAccount In $oAccounts.selectNodes("account")
                    $sDirect = $oAccount.getAttribute("Deposit")
                    $sActNumb = $oAccount.Text
ConsoleWrite("Account: "&$sDirect&"|"&$sActNumb&@CRLF)
                Next
                $sRemarks = $oAccounts.getAttribute("remarks")
ConsoleWrite("Remarks: "&$sRemarks&@CRLF)
            Next
        Next
    Next
    ConsoleWrite("!---------------------------------------------------------------------------------" & @LF & @LF)

 

Edited by Jewtus

Share this post


Link to post
Share on other sites

Figured it out. When I run a for loop with the objects (even if there is only 1) it seems to work.

For $o in $oRep.selectNodes("firstName")
                    $sRepFName=$o.Text
                Next
                For $o in $oRep.selectNodes("middleName")
                    $sRepMName=$o.Text
                Next
                For $o in $oRep.selectNodes("lastName")
                    $sRepLName=$o.Text
                Next
                For $o in $oRep.selectNodes("address")
                    $sRepAddr=$o.Text
                Next
                For $o in $oRep.selectNodes("city")
                    $sRepCity=$o.Text
                Next
                For $o in $oRep.selectNodes("state")
                    $sRepState=$o.Text
                Next
                For $o in $oRep.selectNodes("zip")
                    $sRepZip=$o.Text
                Next
                For $o in $oRep.selectNodes("phone")
                    $sRepPhone=$o.Text
                Next

Is there a simpler way to do this? I tried using

$oRep.selectNodes("phone")[0].Text

But that errors out.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • Simpel
      By Simpel
      Hi. I'm trying to write a xml. Here is my code:
      #include <_XMLDomWrapper.au3> #include <Date.au3> Global $g_sXMLFileName Global $g_sDestPath = @DesktopDir & "\" Global $g_sReturnedBID = "A10829" _makeXML() _AddXML(1, "A10829_Thomas/wav/T001.wav") _AddXML(2, "A10829_Thomas/wav/T002.wav") Exit Func _makeXML() Local $sXMLtime = StringReplace(StringReplace(StringReplace(_NowCalc()," ","_"),":","-"),"/","-") ; in yyyy-mm-dd_hh-mm-ss $g_sXMLFileName = $g_sDestPath & $g_sReturnedBID & "_" & "EB-Ton-Upload" & "_" & $sXMLtime & ".xml" _XMLCreateFile($g_sXMLFileName, "gemagvl", 1,1) _XMLFileOpen($g_sXMLFileName) EndFunc Func _AddXML($iCount, $sDateiname) _XMLCreateRootNodeWAttr("row", "count", $iCount, "") _XMLCreateChildNode("//row", "picklistenname", $g_sReturnedBID & "_EB-Ton-Upload") _XMLCreateChildNode("//row", "picklisteninfo") _XMLCreateChildNode("//row", "bid", $g_sReturnedBID) _XMLCreateChildNode("//row", "audiodateiname", $sDateiname) _XMLCreateChildNode("//row", "titel", StringTrimRight(StringTrimLeft($sDateiname, 7), 4)) _XMLCreateChildNode("//row", "interpret", "EB") _XMLCreateChildNode("//row", "quelle", "Ton") EndFunc It returns:
      <?xml version="1.0" encoding="UTF-8"?><gemagvl> <row count="1"> <picklistenname>A10829_EB-Ton-Upload</picklistenname> <picklisteninfo/> <bid>A10829</bid> <audiodateiname>A10829_Thomas/wav/T001.wav</audiodateiname> <titel>Thomas/wav/T002</titel> <interpret>EB</interpret> <quelle>Ton</quelle> <picklistenname>A10829_EB-Ton-Upload</picklistenname> <picklisteninfo/> <bid>A10829</bid> <audiodateiname>A10829_Thomas/wav/T002.wav</audiodateiname> <titel>Thomas/wav/T003</titel> <interpret>EB</interpret> <quelle>Ton</quelle> </row> <row count="2"> <picklistenname>A10829_EB-Ton-Upload</picklistenname> <picklisteninfo/> <bid>A10829</bid> <audiodateiname>A10829_Thomas/wav/T002.wav</audiodateiname> <titel>Thomas/wav/T003</titel> <interpret>EB</interpret> <quelle>Ton</quelle> </row> </gemagvl> But it should return:
      <?xml version="1.0" encoding="UTF-8"?><gemagvl> <row count="1"> <picklistenname>A10829_EB-Ton-Upload</picklistenname> <picklisteninfo/> <bid>A10829</bid> <audiodateiname>A10829_Thomas/wav/T001.wav</audiodateiname> <titel>Thomas/wav/T002</titel> <interpret>EB</interpret> <quelle>Ton</quelle> </row> <row count="2"> <picklistenname>A10829_EB-Ton-Upload</picklistenname> <picklisteninfo/> <bid>A10829</bid> <audiodateiname>A10829_Thomas/wav/T002.wav</audiodateiname> <titel>Thomas/wav/T003</titel> <interpret>EB</interpret> <quelle>Ton</quelle> </row> </gemagvl> The second inserted nodes are double. How will it be going right?
      Regards, Conrad
    • rootx
      By rootx
      I need help to read in a loop the DVD id child and subchild. Thx
      Example...
      DVD001 - PAL - EN,FR,DE,ES,IT and filter the right title & descri language.  I tried with $oXML.SelectSingleNode but without success
      <?xml version="1.0" encoding="UTF-8"?> <datafile xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="mydvd.xsd"> <dvd name="My dvd title"> <id>DVD001</id> <region>PAL</region> <languages>EN,FR,DE,ES,IT</languages> <locale lang="EN"> <title>title en</title> <descri>descri en</descri> </locale> <locale lang="FR"> <title>title fr</title> <descri>descri fr </descri> </locale> <locale lang="DE"> <title>title de</title> <descri>descri de </descri> </locale> <locale lang="ES"> <title>title es</title> <descri>descri es</descri> </locale> <locale lang="IT"> <title>title it</title> <descri>descri it</descri> </locale> </dvd> <dvd name="My dvd title 2"> <id>DVD002</id> <region>USA</region> <languages>EN</languages> <locale lang="EN"> <title>title en</title> <descri>descri en</descri> </locale> </dvd> </datafile> #include <File.au3> $xml = @ScriptDir&"\test.xml" Local $oXML = ObjCreate("Microsoft.XMLDOM") $oXML.load($xml) $id = $oXML.SelectNodes("//dvd") For $ids In $id ConsoleWrite($ids.text &@CRLF) Next  
    • mLipok
      By mLipok
      I was asking @eltorro serveral times for any support  for XML DOM wrapper (COM) - with no success  
          So I took matters into my hands ..... I want to present XMLWrapperEx.au3 - BETA Version
      Want to join to the project ?
       
      Here is some description:
      ; #INDEX# ======================================================================================================================= ; Title .........: XMLWrapperEx.au3 ; AutoIt Version : 3.3.10.2++ ; Language ......: English ; Description ...: Functions to use for reading and writing XML using msxml. ; Remarks .......: BETA Version ; Author ........: mLipok ; Version .......: "1.1.1.01" ; _XML_MiscProperty_UDFVersion() #CS This UDF is created on the basis of: https://www.autoitscript.com/forum/topic/19848-xml-dom-wrapper-com/ For this reason, I attach also the last known (to me) previous version ($_XMLUDFVER = "1.0.3.98" _XMLDomWrapper_1.0.3.98_CN.au3 ) For the same reason I continue to recognize the achievements of the work of my predecessors (they are still noted in each Function header). . . . . !!!!!!!!! This is BETA VERSION (all could be changed) !!!!!!!!! . . . WORK IN PROGRES INFORMATION: For now 2015-09-01 the descripion (Function Header) can not entirely correctly describe the function. TODO: in many places I used "TODO" as a keyword to find what should be done in future . I want to: PREVENT THIS: The unfortunate nature of both the scripts is that the func return results are strings or arrays instead of objects. .     I want to: USE THIS CONCEPT:     .   All function should use Refernce to the object as first Function parameter     .   All function should return in most cases objects. There should be separate functions to Change Object collection to array     .   All function should use COM Error Handler in local scope.     .   All function should return @error which are defined in #Region XMLWrapperEx.au3 - @ERROR Enums     .    All function should have the same naming convention     .    All variables should have the same naming convention     .    There should not to be any Global Variable - exception is $g__oXMLDOM_Events     .   It should be possible easy to use XML DOM Events     .        https://msdn.microsoft.com/en-us/library/ms764697(v=vs.85).aspx     .   It should be possible easy to Debug     .    Ultimately, you should be able to do anything with your XML without having to use your own Error Handler. #CE  
      More info inside zip archive.
      This UDF can be downloaded from here:
      REMARK:
      This UDF was formerly named:   XMLWrapperEx.au3 
       
    • 31290
      By 31290
      Hi Guys, 
      Since I'm able to get a Dell equipment warranty status thanks to my API key, I'm using an UDF to extract data from an XML file and get the end date. > 
      Thing is, when using InetGet, the original file is in JSON format and the UDF is not working anymore, even if I download the file with the xml extension. Therefore, and when I manually download the page with Chrome, I have a proper XML file where the UDF is working fine.
      Here's my code:
      I even tried to convert the json to xml > https://www.autoitscript.com/forum/topic/185717-js-json-to-xml/
      I took a look here https://www.autoitscript.com/forum/topic/104150-json-udf-library-fully-rfc4627-compliant/ but I don't understand anything :/
       
      The XML read UDF is just perfect for my needs but I'm stuck here... 
      Thanks for any help you can provide
      -31290-
      3MTXM12.json
      3MTXM12.xml
    • Zaroz
      By Zaroz
      Alright, this is going to be a rather long explanation so bear with me.
      What I am trying to to is build a GUI program that, in the end, will look like this:
      The middle Frame is for displaying a desktop icon and the right frame is for displaying a selected image.
      The XML file I am using looks like this:
      <list> <item id="1"> <ico>Path\to\icon1<\ico> <img>Path\to\image1<\img> <exe>Path\to\program1<\exe> <label>UserDefinedLabel1<\label> <\item> <item id="2"> <ico>Path\to\icon2<\ico> <img>Path\to\image2<\img> <exe>Path\to\program2<\exe> <label>UserDefinedLabel2<\label> <\item> <\list> What I want this program to do is when I highlight an item in the listbox (which btw is displaying the <label> value associated with the item) I want the displayed icon and image to change to the ones associated with that entry. 
      Also I would like to include an additional dialog to open when the 'ADD' button is clicked that will add entries to the XML file that looks like this:

       
      The main problem I am running into is that I do not know much about XML and how to parse it into dynamic variables that can change based off of selection.
      Any help is appreciated.
       
       
       
      10-29-16 EDIT: For all intents and purposes, I basically want to create something similar to PStart, but with a preview pane with a customizable image for each item in it.