Jump to content
lrstndm

Read XML Values

Recommended Posts

lrstndm

I was searching the forum too find a way to read XML files. There are many options (also very old options), but my question is which is the best for now and which is the best for my problem?

I have a XML file like this:

<Data>
    <Values>
        <Info>Information value 1</Info>
        <Info>Information value 2</Info>
    </Values>
    <Other>Other information</Other>
</Data>

What I want to have is a function where you can basically call the function 'getValue' or 'getValues' with the path to the value(s)

e.g.

getValue('Data\Other')

or

getValues('Data\Values\Info')

What is the best solution for me? Hope someone can help me out.

Regards,
lrstndm

Share this post


Link to post
Share on other sites
MikahS

Have a look at these links in this link: Link

That should give you an idea of how to start.


Snips & Scripts


My Snips: graphCPUTemp ~ getENVvars
My Scripts: Short-Order Encrypter - message and file encryption V1.6.1 ~ AuPad - Notepad written entirely in AutoIt V1.9.4

Feel free to use any of my code for your own use.                                                                                                                                                           Forum FAQ

 

Share this post


Link to post
Share on other sites
jdelaney

Example:

;~ Create the temp xml
#include <File.au3>

_FileCreate("Temp")
FileWrite("Temp","<Data><Values><Info>Information value 1</Info><Info>Information value 2</Info></Values><Other>Other information</Other></Data>")


Local $oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.load("Temp")

$oOther = $oXML.SelectSingleNode("//Data/Other")            ; or //Other
ConsoleWrite("$oOther.text=[" & $oOther.text & "]" & @CRLF)

$oInfos = $oXML.SelectNodes("//Data/Values/Info")   ; or //Info or //Data//Info or //Values/Info
For $oInfo In $oInfos

    ConsoleWrite("$oInfo.text=[" & $oInfo.text  & "]" & @CRLF)
Next

outputs:

$oOther.text=[Other information]
$oInfo.text=[Information value 1]
$oInfo.text=[Information value 2]

  • Like 1

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites
lrstndm

jdelaney, Thank you!

This is the thing I was been looking for. With this I can work on.

Share this post


Link to post
Share on other sites
KF5WGB

jdelaney and all coders,,

Long time since this threat started. However, it has just what I needed with one exception.
The first post had only a simple "multiple node" and my xml file has more stuff in the nodes tags. If you run the script and check the created solar.xml you see what I mean.

What it does:
It downloads solardata, writes it to a xml file and then picks a few  infos out of that xml file and displays it in a MsgBox. HAM radio operators use those infos. 

My problem is at the end where a "multiple node" needs to be read and put into strings e.g $band1day, $band2day...... band$4night.

Code:

;Display Solar data in popup
;coded by: KF5WGB
;
;Get the Solar data from the net
        Global $oXML = ObjCreate("Microsoft.XMLHTTP")
        $oXML.Open("GET", "http://www.hamqsl.com/solarxml.php", 0)
        $oXML.Send
        $oReceived = $oXML.ResponseText
        $oStatusCode = $oXML.Status
;and save it as solar.xml
        If $oStatusCode == 200 then
            $file = FileOpen("solar.xml", 2) ; The value of 2 overwrites the file if it already exists
            FileWrite($file, $oReceived)
            FileClose($file)
        EndIf

Local $oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.load("solar.xml")

$updated = $oXML.SelectSingleNode("solar/solardata/updated")            ; updated
ConsoleWrite("$updated.text=" & $updated.text & "" & @CRLF)
$sunspots = $oXML.SelectSingleNode("solar/solardata/sunspots")          ; sunspots
ConsoleWrite("$sunspots.text=[" & $sunspots.text & "]" & @CRLF)
$xray = $oXML.SelectSingleNode("solar/solardata/xray")                  ; xray
ConsoleWrite("$xray.text=[" & $xray.text & "]" & @CRLF)
$solarflux = $oXML.SelectSingleNode("solar/solardata/solarflux")        ; solarflux
ConsoleWrite("$solarflux.text=[" & $solarflux.text & "]" & @CRLF)
$aindex = $oXML.SelectSingleNode("solar/solardata/aindex")              ; aindex
ConsoleWrite("$aindex.text=[" & $aindex.text & "]" & @CRLF)
$kindex = $oXML.SelectSingleNode("solar/solardata/kindex")              ; kindex
ConsoleWrite("$kindex.text=[" & $kindex.text & "]" & @CRLF)
$solarwind = $oXML.SelectSingleNode("solar/solardata/solarwind")        ; solarindex
ConsoleWrite("$solarwind.text=[" & $solarwind.text & "]" & @CRLF)

$oInfos = $oXML.SelectNodes("solar/solardata/calculatedconditions/band"); ..and here is the problem
For $oInfo In $oInfos
        ;Local $band[????] = $oInfo.text                                ; array ?? how to read it??
        ConsoleWrite("$oInfo.text=[" & $oInfo.text & "]" & @CRLF)
Next

MsgBox(64,"Solardata @ " & $updated.text,"Sunspots: " & $sunspots.text & @CRLF & "Xray: " & $xray.text & @CRLF & "Solarflux:    " & $solarflux.text & @CRLF & "A:   " & $aindex.text & @CRLF & "K:  " & $kindex.text & @CRLF & "Solarwind:  " & $solarwind.text & @CRLF & @CRLF & $oInfo.text & @CRLF & @CRLF & @CRLF & "       written by:KF5WGB")

As you can see, after running the script, consolewrite shows each value. The Msgbox ($oInfo.text) shows the last value of the "multiple nodes". How would put each value in a string?

Thanks in advance

KF5WGB

 

 

Share this post


Link to post
Share on other sites
mikell

You might try this

$oInfos = $oXML.SelectNodes("solar/solardata/calculatedconditions/band"); ..and here is the problem

$test = ""
For $oInfo In $oInfos
    ;$oAttrs = $oInfo.attributes
    ;$test &= $oAttrs(0).value &" ("& $oAttrs(1).value & "): " & $oInfo.text & @crlf
    $test &= $oInfo.getattribute("name") &" ("& $oInfo.getattribute("time") & "): " & $oInfo.text & @crlf
Next
msgbox(0,"test", $test)

 

Edited by mikell
still learning xml :)
  • Like 1

Share this post


Link to post
Share on other sites
KF5WGB

mikell,

Awesome. I was happy with the first one but the second one is even better.
Thank you so much. Working the string is easy for me. I started to read the XML tutorial @ w3school.com and I must say.... I have some serious reading to do.

Thanks again

KF5WGB

Share this post


Link to post
Share on other sites
van_renier

This is a great thread.

This might be a dumb/easy question to answer, but how might I be able to read in an XML file, and get the names of the elements? like in the 1st example given.

<Data>
    <Values>
        <Info>Information value 1</Info>
        <Info>Information value 2</Info>
    </Values>
    <Other>Other information</Other>
</Data>

The script examples above clearly helped me get the values of the elements, (i.e. "Information value 1" and 2,) but How would I be able to get the elements of those?, ie. "Data", "Values", "Info", "Other", etc... This is probably more working with object-related coding than the XML file itself.  For example..

 

$oInfos = $oXML.SelectNodes("SMPUBLISH")   ; or //Info or //Data//Info or //Values/Info
For $oInfo In $oInfos
   ConsoleWrite("$oInfo.text=[" & $oInfo.text  & "]" & @CRLF)
 Next

$oInfo.text will retrieve the value within the elements, how would I get the value of the elements themselves?

=================
<SMPUBLISH>
    <SERVER>
        <SHORT_NAME>smpolicysrv </SHORT_NAME>
        <FULL_NAME>SiteMinder Policy Server </FULL_NAME>
        <PRODUCT_NAME>SiteMinder(tm) </PRODUCT_NAME>
        <VERSION>12.52 </VERSION>
    </SERVER>
</SMPUBLISH>
=================
In the above excerpt of an XML file, the elements within a node might change, The scripts earlier allow me/us to get the values of these nodes, but what about getting the name of the nodes too?

Thanks,

Van

 

Share this post


Link to post
Share on other sites
mikell

Do you mean this ?

Local $oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.load("Temp")

Local $txt = ""
$oItem = $oXML.SelectSingleNode("SMPUBLISH/SERVER") 

For $oNode In $oItem.childNodes
   $txt &= $oNode.nodename & " = " & $oNode.text & @crlf
Next
Msgbox(0,"", $txt)

 

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

    • ijourneaux
      By ijourneaux
      I am trying to read an XML file that looks like the following. I am particularly interested in the ParameterNames and ParameterValues
       
      I was able to read a simplier XML file using
      $oXML.load("DataForwardSettings.xml") Local $oInfos = $oXML.selectnodes("//Database") ; or //Info or //Data//Info or //Values/Info  but have not been able to read
      <?xml version="1.0"?> <Entities> <Entity RecordType="TrendData"> <Property Name="AlarmLimitsSetNumber" IsReadOnly="False" ValueType="System.Int32">8</Property> <Property Name="AnalysisParamaterSetNumber" IsReadOnly="False" ValueType="System.Int32">8</Property> <Property Name="ParameterNames" IsReadOnly="True" IsList="True" ListType="List<string>" ValueType="Array" ArrayType="System.String" Count="12">System.Collections.Generic.List`1[System.String]<Data>OVERALL|PK-PK WAVEFORM|HFD|CREST FACTOR|SYNC 1-6|1X|2X|3X-4X|FTF|BSF|BPFO|BPFI</Data></Property> <Property Name="ParameterValues" IsReadOnly="True" IsList="True" ListType="List<float>" ValueType="Array" ArrayType="System.Single" Count="12">System.Collections.Generic.List`1[System.Single]<Data>0.04706,0.27951,0.02640,4.85608,0.03494,0.01727,0.02256,0.01993,0.00207,0.00060,0.00178,0.00221</Data></Property> <Property Name="NumberOfParameters" IsReadOnly="False" ValueType="System.Int32">12</Property> <Property Name="ModifiedSinceLastDataDump" IsReadOnly="False" ValueType="System.Boolean">False</Property> <Property Name="Load" IsReadOnly="False" ValueType="System.Single">0</Property> <Property Name="RPM" IsReadOnly="False" ValueType="System.Single">140.962</Property> <Property Name="Value" IsReadOnly="False" ValueType="System.Single">-1.1E-20</Property> <Property Name="SampleID" IsReadOnly="False" ValueType="System.Int32">-626794</Property> <Property Name="Timestamp_as_String" IsReadOnly="True" ValueType="System.String">8/18/2018 2:05:33 PM</Property> <Property Name="Timestamp_as_UInt" IsReadOnly="False" ValueType="System.UInt32">1534619133</Property> <Property Name="Timestamp" IsReadOnly="False" ValueType="System.DateTime">8/18/2018 2:05:33 PM</Property> <Property Name="StorageFlag" IsReadOnly="False" ValueType="Enum" EnumType="Emerson.CSI.DataImport.MHM.TrendDataStorageType" EnumValue="2">RPM_And_Overall</Property> <Property Name="Parents" IsReadOnly="False" IsList="True" ListType="List<string>" ValueType="Array" ArrayType="System.String" Count="5">System.Collections.Generic.List`1[System.String]<Data>Database=phmhmdb4ts;C:\RBMdbsrv\CustData\4ts_online_1807.rbm;-99|Area=4TS;-494|Equipment=4THTS;-712|MeasurementPoint=D39;-780|DataCollectionSet=Normal Collection Dryer Rolls;-783</Data></Property> </Entity> </Entities> I tried switching to the XML UDF but was alittle lost in how to use it. I am particularly interested in the ParameterNames and ParameterValues.
    • macran
      By macran
      I want to generating a XML file (test.xml) like as follow:
      <?xml version="1.0" encoding="GBK"?>
      <!DOCTYPE SCHEMA SYSTEM "HGWSPZJK.dtd">  ;I can not generate this line
      <SCHEMA CRC="HGWSPZ201808_9131011571786229XM_CRC.XML" SSSQ="201808" CHSNAME="HGWSDKQD" NAME="HGWSPZ">

      <TAXPAYER CJRMC="sigmagroup" CJRDM="9131011571786229XM" CJLX="DKZK" RECORDCOUNT="411" SBRQ="2018-08-31" NSRMC="sigmagroup" SWSBH="9131011571786229XM">

      <Records>
      <Record BZ="" JKKADM="2244" JKKAMC="shanghai" SE="5907.82" TFRQ="2018-08-23" FPHM="224420181000752586-L02"/>
      <Record BZ="" JKKADM="2244" JKKAMC="shanghai" SE="4742.4" TFRQ="2018-08-21" FPHM="224420181000743016-L01"/>
      <Record BZ="" JKKADM="2244" JKKAMC="shanghai" SE="18720" TFRQ="2018-08-14" FPHM="224420181000719215-L01"/>
      </Records>
      </TAXPAYER>
      </SCHEMA>
      I use XML.UDF  
      Local $oXMLile=_XML_CreateFile(@ScriptDir&"\test.xml","",True) 
      but there is no function CreateDocumentType 
      It is no effort even I test use 
      Local $doct=$oXMLfile.CreateDocumentType("SCHEMA", null, "HGWSPZJK.dtd", null)
            $oXmlfile.appendChild($doct)
      pls help me thanks.
       
       
       
       
       
       
    • Skeletor
      By Skeletor
      Hi All,
      This is purely an XML Language question. I need to understand how I can add a value/element in between another XML element. 
      Code below shows the XML file. The info tag has the elements already inserted.
      <Configuration xmlns="http://schemas.datacontract.org/2004/07/Modules.Reporting.DataContracts.LineItems" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <GenConf> <Info>ID, Site, Name , Site_ID</Info> </GenConf> </Configuration> Now, I want to add a value from a node group into this code. Something like below. But the example below does not work.
      Any suggestions?
       
      <Configuration xmlns="http://schemas.datacontract.org/2004/07/Modules.Reporting.DataContracts.LineItems" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <GenConf> <Info>ID, Site, a/@id, Name , Site_ID</Info> </GenConf> </Configuration> <ProductName> <a id="Windows Server"/> </ProductName>  
    • bhns
      By bhns
      try it for make flyers old games xml + Gdi, i belive many sources had lost 
      AIT-ADRLIST.au3

    • CosminV
      By CosminV
      Hello guys,
       
      This XML things are driving me crazy...
      Please let me know how can I use the _XMLGetAttrib function... I've tried every possible way that I've read on the forum and I cannot succeed reading an attribute.
       
      The XML looks like bellow:
       
      <?xml version="1.0" encoding="UTF-8"?>
      <BATCH attr1= "aaa" attr2="bbb" attr3="ccc">
           <Node1 attr1="aaa" attr2="bbb" attr3="ccc" attr4="ddd" attr5="" attr6="eee" attr7="fff" attr8="ggg"/>
           <Node2 attr1="aaa" attr2="" attr3="" attr4="ddd"/>
           <Node3 attr1="" attr2="" attr3="ccc" attr4="" attr5="" attr6="eee"/>
           <Panel attr1="aaa" STATUS="BBB" attr3="ccc" attr4="ddd" attr5="" attr6="eee">
                <Node5 attr1="aaa" attr2="bbb" attr3="ccc" attr4="ddd" attr5="" attr6="eee" attr7="fff" attr8="ggg"/>
                .............................................................................................................................................................................
           </Panel>
      </Batch>
       
      I need to read the value of STATUS form the Panel node.
       
      Could you please help me?
       
      Best regards,
      Cococnb
×