Help with some script

[fearless1]

Hi Guys,

 

I'm trying to pull some data from a range of XML files but am getting stuck. It is only returning blank results. My thought process was to:

a: Get a list of all the XML file names into an array;
b: Scroll through the array one by one and pull the relevant 4 values from the specified node.

This is my code:

expandcollapse popup

#include <Array.au3>
#include <File.au3>
#include <MsgBoxConstants.au3>

$Workingdir = FileSelectFolder("Select the working folder", "C:\Files\")

    $i = 1
    Global $aFileList = _FileListToArray($Workingdir , "*.xml")

    If @error = 1 Then
        MsgBox($MB_SYSTEMMODAL, "", "Path was invalid.")
        Exit
    EndIf
    If @error = 4 Then
        MsgBox($MB_SYSTEMMODAL, "", "No file(s) were found.")
        Exit
    EndIf
    ; Display the results returned by _FileListToArray.

    $oXML = ObjCreate("Microsoft.XMLDOM")
    $oXML.load($aFile)

    $oNodes = $oXML.selectNodes("//photo")
    Do
        $oNode = $oNodes.nextNode()
        $t = $oNode.text

        ;If $t = '' Then
        ;   Msgbox(0,'','Search returned 0 results. Contact support.')
        ;   Exit
        ;EndIf

        ConsoleWrite($aFileList[$i] & ': Value: '& $t & @CRLF)

        FileWriteLine("event.txt",$t)
        $i = $i + 1
    Until $i = $aFileList[0]

I can get the XML function to work when it is a single file to read but I can have hundreds of files to go through in one hit. Any help you can offer would be great. 

Thanks

Mike.

Edited July 17, 2015 by fearless1

[kaisies]

File list to array only returns the file name not the full file path by default. 

[guinness]

But there is a parameter you can set to return the fullpath. Help file tells you.

[RaiNote]

You want to Show XML Files within an Array right? Then Look in Help File at _WinApi_IsPathContentType

#include <Array.au3>
#include <File.au3>
#include <WinAPIShPath.au3>

Local $sFileList = _FileListToArray(@SystemDir, '*.*', 1)
Local $aSortList[UBound($sFileList) - 1]
Local $iCount = 0

For $i = 1 To $sFileList[0]
    If _WinAPI_PathIsContentType($sFileList[$i], 'text/xml') Then
        $aSortList[$iCount] = $sFileList[$i]
        $iCount += 1
    EndIf
Next
If $iCount Then
    ReDim $aSortList[$iCount]
Else
    Exit
EndIf

_ArrayDisplay($aSortList, '_WinAPI_PathIsContentType')

This is the Example of it and it Shows the XML files ^-^

[fearless1]

I can scroll through and get the list of XML files. What I am trying to pull iOS the 3 values within the node <Photo> of each XML and write those values out to a file.

[RaiNote]

If you want to read XML °-° then look for the XML UDF

https://www.autoitscript.com/forum/topic/19848-xml-dom-wrapper-com/?page=38#comment-1245937

You can Read with this UDF XML Files and if u want to write the readed text anywhere °-°

Edited July 17, 2015 by RaiNote

[fearless1]

Thanks guys. I'm not that good at this stuff but will give it a shot.