Jump to content

Recommended Posts

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

Link to post
Share on other sites

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

 

Link to post
Share on other sites

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]

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.
Link to post
Share on other sites
  • 2 years later...

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

 

 

Link to post
Share on other sites

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 :)
Link to post
Share on other sites

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

Link to post
Share on other sites
  • 1 month later...

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

 

Link to post
Share on other sites
  • 10 months later...

Hi coders,

Long time, no mess up.  I think I am loosing it. Looking at a little routine for hours and do not see the problem.

I have a huge Settings.xml file and all I need is two node values out of it. The XML looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<unneeded stuff>....</unneeded stuff>
<unneeded stuff>....</unneeded stuff>
<unneeded stuff>....</unneeded stuff>
<N3FJPTCPENABLED>True</N3FJPTCPENABLED>
<N3FJPTCPPORT>1180</N3FJPTCPPORT>
<unneeded stuff>....</unneeded stuff>
<unneeded stuff>....</unneeded stuff>

All I need are those two nodes. The complete XML is attached. So far I use this:

GetServerStat()


Func GetServerStat()

    Local $oXML = ObjCreate("Microsoft.XMLDOM")
    
    If FileExists("Settings.xml") then
            $oXML.load("Settings.xml")
    Else
            MsgBox(0,"ERROR", "File not found")
    EndIf

    Local $TCPENABLED = $oXML.SelectSingleNode("N3FJPTCPENABLED") ; Server on or off
    ConsoleWrite("Server: " & $TCPENABLED.text & @CRLF)

    Local $TCPPORT = $oXML.SelectSingleNode("N3FJPTCPPORT") ; TCP Port
    ConsoleWrite("Port: " & $TCPPORT.text & @CRLF)

EndFunc   ;==>GetServerStat

Consolewrite gives me this:
"G:\Coding\AutoIt\findfile\getsettingsxmldata.au3" (16) : ==> The requested action with this object has failed.:
ConsoleWrite("Server: " & $TCPENABLED.text & @CRLF)
ConsoleWrite("Server: " & $TCPENABLED^ ERROR

 

I take a break for a few hours. Pretty sure I miss something simple.
Anyway... as always... Thanks for any help.

Kf5WGB

Settings.xml

Link to post
Share on other sites

I would go with _stringbetween

See this post

Spoiler

Renamer - Rename files and folders, remove portions of text from the filename etc.

GPO Tool - Export/Import Group policy settings.

MirrorDir - Synchronize/Backup/Mirror Folders

BeatsPlayer - Music player.

Params Tool - Right click an exe to see it's parameters or execute them.

String Trigger - Triggers pasting text or applications or internet links on specific strings.

Inconspicuous - Hide files in plain sight, not fully encrypted.

Regedit Control - Registry browsing history, quickly jump into any saved key.

Time4Shutdown - Write the time for shutdown in minutes.

Power Profiles Tool - Set a profile as active, delete, duplicate, export and import.

Finished Task Shutdown - Shuts down pc when specified window/Wndl/process closes.

NetworkSpeedShutdown - Shuts down pc if download speed goes under "X" Kb/s.

IUIAutomation - Topic with framework and examples

Au3Record.exe

Link to post
Share on other sites

     Local $TCPENABLED = $oXML.SelectSingleNode("//N3FJPTCPENABLED") ; Server on or off     ConsoleWrite("Server: " & $TCPENABLED.text & @CRLF)     Local $TCPPORT = $oXML.SelectSingleNode("//N3FJPTCPPORT")

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.
Link to post
Share on other sites
9 minutes ago, jdelaney said:

     Local $TCPENABLED = $oXML.SelectSingleNode("//N3FJPTCPENABLED") ; Server on or off     ConsoleWrite("Server: " & $TCPENABLED.text & @CRLF)     Local $TCPPORT = $oXML.SelectSingleNode("//N3FJPTCPPORT")

Hi jdelaney,

I had put those // in before. Did not work. That made me scratch my head and wonder.

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
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • 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 
       
    • By rudi
      Hello,
      once more I have to see, that my knowledge about XML is too poor, even to use this existing XML UDF
      If it should be a better approach to make use of StringRegEx, or maybe a totally different approach, any suggestions will be mostly appreciated.
       
      I downloaded the ZIP XML_1.1.1.13 and tried to get how to use it from the sample AU3 files included in that ZIP file, well, I don't really get it😵
       
       
      What I want to do:
      My mobile phone's backup contain all the contacts in an XML file. This is an example of such a file, backupinfo.xml, shortened to show just one fictive entry:
       
      <?xml version="1.0" encoding="utf-8" ?> <ContactRecords> <contact> <structuredName> <displayName>Max Mustermann</displayName> <givenName>Max</givenName> <familyName>Mustermann</familyName> <prefixName /> <middleName /> <suffixName /> <phoneticGivenName /> <phoneticMiddleName /> <phoneticFamily /> </structuredName> <organization> <company>Schlosserei Mustermann GmbH</company> <department /> <title /> </organization> <phones> <phone> <number>07652 881 8181</number> <type>home</type> <customLabel /> </phone> <phone> <number>0 800 435 2758</number> <type>work</type> <customLabel /> </phone> <phone> <number>+49 160 4321 222</number> <type>mobile</type> <customLabel /> </phone> </phones> <emails /> <addresses /> <ims /> <WebSites /> <Events /> <note /> <nickName /> <photo /> <netPhone /> <groups> <group> <groupName>Ungrouped</groupName> </group> </groups> </contact> </ContactRecords>  
      Basically I want to search my mobile's contacts for phone numbers to, to see, what contact they belong to. Propably it will make the task much more easy, when standardizing the mobile's contact XML to hold all numbers in "international-notation-without-any-whitespaces" (thats no problem):
       
      <?xml version="1.0" encoding="utf-8" ?> <ContactRecords> <contact> <structuredName> <displayName>Max Mustermann</displayName> <givenName>Max</givenName> <familyName>Mustermann</familyName> <prefixName /> <middleName /> <suffixName /> <phoneticGivenName /> <phoneticMiddleName /> <phoneticFamily /> </structuredName> <organization> <company>Schlosserei Mustermann GmbH</company> <department /> <title /> </organization> <phones> <phone> <number>+4976528818181</number> <type>home</type> <customLabel /> </phone> <phone> <number>+498004352758</number> <type>work</type> <customLabel /> </phone> <phone> <number>+491604321222</number> <type>mobile</type> <customLabel /> </phone> </phones> <emails /> <addresses /> <ims /> <WebSites /> <Events /> <note /> <nickName /> <photo /> <netPhone /> <groups> <group> <groupName>Ungrouped</groupName> </group> </groups> </contact> </ContactRecords>  
      What I would like to get from the XML file as a result, e.g. searching the phone number "+491604321222"
      Present in XML  or not (true) if present then return the values for... type (mobile) givenname (Max) familyname (Mustermann) company (Schlosserei Mustermann GmbH) optional: Other node names and their values within that contact, when not "empty" (like in this examle <emails /> or <middlename />)  
      The values from #2 - #6 would be perfect when returned in a 2D Array, Col0 = name, Col1 = value.
      Regards, Rudi.
       
    • By VinMe
      Dear all, i am unable to open a xml file to excel in the "xml table format" Please help me out in where i am missing
      Local $strFileToOpen = _WinAPI_OpenFileDlg('Select xml file', @WorkingDir, 'All Files(*.*)', 1, '', '', BitOR($OFN_PATHMUSTEXIST, $OFN_FILEMUSTEXIST, $OFN_HIDEREADONLY)) Global $xlXmlLoadImportToList = 2 ; Places the contents of the XML data file in an XML table $oExcel = _Excel_Open() $oWorkbook1=$oExcel.Workbooks.OpenXML($strFileToOpen, "", $xlXmlLoadImportToList) If $strFileToOpen <> False Then     Local $oWorkbook1 = _Excel_BookOpen($oExcel, $strFileToOpen) EndIf Error i am getting is:
      ......\81e_Compare_v1.au3" (46) : ==> The requested action with this object has failed.:
      $oWorkbook1=$oExcel.Workbooks.OpenXML($strFileToOpen, "", $xlXmlLoadImportToList)
      $oWorkbook1=$oExcel.Workbooks^ ERROR
      >Exit code: 1    Time: 7.338
    • By ijourneaux
      I have been using the XML UDF successfully for sometime. I am now tring to add in error handling for some bad XML files I run into.
      $oXmlDoc = _XML_CreateDOMDocument(Default) _XML_Load($oXmlDoc,$sFileXML) ;<== ENTER XML FILE PATH HERE If @error Then ; ConsoleWrite(StringFormat("_XML_load error - @error = %s", @error) & @CRLF) ; ConsoleWrite("-" & $sFileXML & @CRLF) Exit -1 EndIf ConsoleWrite("-" & $sFileXML & @CRLF) ;If no specified nodes exist, log error and exit If Not _XML_NodeExists($oXmlDoc, "//Property") Then ; ConsoleWrite("No specified nodes exist" & @CRLF) Exit -1 EndIf ;Get number of Property nodes $oProperties = _XML_SelectNodes($oXmlDoc,"//Property/Data") $iNodeCount = @extended $oParents = $oXmlDoc.SelectSingleNode("//Property[@Name='Parents']/Data") There are no error upto this point. The XML file I am trying to handle has a Data node but when I try to
      $sParam = StringSplit($oParents.text, ";") I get a fatal error (requested action on object failed). How can I test for the problem before I try to do the string split? I tried using @error, and testing $oParents but no luck.
      Appreciate any tips.
    • 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.
×
×
  • Create New...