Reading XML File

[antmar904]

Hi all.

I'm having issues reading a xml file and returning the version number <rules version="467">

Here is an example of the xml file:

<rules version="467">
  <docMode>
    <domain docMode="9">site1</domain>
    <domain docMode="9">site2</domain>
    <domain docMode="8">site3</domain>
    <domain docMode="5">site4</domain>
    <domain docMode="9">site5</domain>
    <domain docMode="9">site6</domain>
  </docMode>

I am trying to get the "<rules version="467">" number 467 but when I read the file it does not return that line.

ConsoleWrite(FileRead("C:\Test\temp.xml") & @CRLF)

console output:

<docMode>
    <domain docMode="9">site1</domain>
    <domain docMode="9">site2</domain>
    <domain docMode="8">site3</domain>
    <domain docMode="5">site4</domain>
    <domain docMode="9">site5</domain>
    <domain docMode="9">site6</domain>
  </docMode>

and is missing <rules version="467">

[JLogan3o13]

It works for me:

  Quote

>Running:(3.3.14.2):C:\Program Files (x86)\AutoIt3\autoit3.exe "C:\Users\LoganJ\Desktop\Test Forum Scripts.au3"    
--> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop
<rules version="467">
  <docMode>
    <domain docMode="9">site1</domain>
    <domain docMode="9">site2</domain>
    <domain docMode="8">site3</domain>
    <domain docMode="5">site4</domain>
    <domain docMode="9">site5</domain>
    <domain docMode="9">site6</domain>
  </docMode>

Expand  

Are you trying to extract just the 467 number, or the whole string?

[antmar904]

just the 467.  the rules version number will be manually changed everytime the xml file is edited.

Edited November 21, 2016 by antmar904

[jdelaney]

$oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.Load(@DesktopDir & "\test.xml")
$oNode = $oXML.selectSingleNode('//rules')
$sVersion = $oNode.getAttribute('version')
ConsoleWrite($sVersion & @CRLF)

return:

467

 

Only works when I made the XML valid:

<rules version="467">
   <docMode>
     <domain docMode="9">site1</domain>
     <domain docMode="9">site2</domain>
     <domain docMode="8">site3</domain>
     <domain docMode="5">site4</domain>
     <domain docMode="9">site5</domain>
     <domain docMode="9">site6</domain>
   </docMode> 
</rules>

 

Edited November 22, 2016 by jdelaney

[antmar904]

Thanks