XML.au3 - BETA - Support Topic

[VAN0]

It seems there is a problem handling tags with some xmlns attributes...

In my case having

<Task version="1.4" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
  <RegistrationInfo>
    <Date>2015-08-03T23:43:11.6608515</Date>
    <Author>blah</Author>
    <Description>blah</Description>
    <URI>\blah</URI>
  </RegistrationInfo>
</Tag>

makes the xml object unusable.

Edited March 15, 2017 by VAN0

[mLipok]

On 11.03.2017 at 7:48 PM, VAN0 said:

Can someone please help parse xml that created by schtasks

For some reason it returns error 21 - "Collections of objects was empty"

Is it because the <Task> tag has additional attributes?

Interesting problem, I just try and I get the same result.
Will try to go in depth today or toomorow.

 

EDIT: 
Try to use:
 

$nodes = _XML_SelectNodes($oXMLDoc, "//*[local-name()='Task']")

http://stackoverflow.com/questions/4402310/how-to-ignore-namespace-when-selecting-xml-nodes-with-xpath

or like this:
 

$nodes = _XML_SelectNodes($oXMLDoc, "//*[name()='Task']")

http://stackoverflow.com/questions/5239685/xml-namespace-breaking-my-xpath

 

Edited March 18, 2017 by mLipok

[mLipok]

On 13.03.2017 at 0:45 PM, krupa said:

I have problem with this XML file

<?xml version="1.0" encoding="UTF-8"?>
<tns:JPK xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="http://jpk.mf.gov.pl/wzor/2016/03/09/03095/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">
    <tns:Faktura typ="G">
        <tns:P_6>2017-02-16</tns:P_6>
        <tns:P_13_1>2249</tns:P_13_1>
        <tns:P_14_1>517.27</tns:P_14_1>
        <tns:P_13_2>0</tns:P_13_2>
        <tns:P_14_2>0</tns:P_14_2>
        <tns:P_13_3>0</tns:P_13_3>
        <tns:P_14_3>0</tns:P_14_3>
        <tns:P_13_4>0</tns:P_13_4>
        <tns:P_14_4>0</tns:P_14_4>
        <tns:P_13_5>0</tns:P_13_5>
        <tns:P_14_5>0</tns:P_14_5>
        <tns:P_15>2766.27</tns:P_15>
        <tns:P_16>false</tns:P_16>
        <tns:P_17>false</tns:P_17>
        <tns:P_18>false</tns:P_18>
        <tns:P_19>false</tns:P_19>
        <tns:P_20>false</tns:P_20>
        <tns:P_21>false</tns:P_21>
        <tns:P_23>false</tns:P_23>
        <tns:P_106E_2>false</tns:P_106E_2>
        <tns:P_106E_3>false</tns:P_106E_3>
     </tns:Faktura>
</tns:JPK>

I can't get any nodes or values. 

Thanks

Try to use XPath like this:

Quote

/tns:JPK/tns:Faktura

http://stackoverflow.com/questions/5239685/xml-namespace-breaking-my-xpath

 

[VAN0]

8 hours ago, mLipok said:

Try to use:

 

$nodes = _XML_SelectNodes($oXMLDoc, "//*[local-name()='Task']")

http://stackoverflow.com/questions/4402310/how-to-ignore-namespace-when-selecting-xml-nodes-with-xpath

or like this:
 

$nodes = _XML_SelectNodes($oXMLDoc, "//*[name()='Task']")

http://stackoverflow.com/questions/5239685/xml-namespace-breaking-my-xpath

No luck, unfortunately.

But no errors either (with the sample code on previous page)

[mLipok]

I use this:

expandcollapse popup

#include <Array.au3>
#include "XML.au3"

$iPID = Run(@ComSpec & ' /C schtasks /query /xml /TN "\Microsoft\Windows\Maintenance\WinSAT"', @ScriptDir, @SW_HIDE, $STDOUT_CHILD)
ProcessWaitClose($iPID)
$sOutput = StdoutRead($iPID)

;gives parce error
$sOutput = StringRegExpReplace($sOutput, '(?m:^\s*[\r\n])', '')
$oXMLDoc = _XML_CreateDOMDocument(Default)
_XML_LoadXML($oXMLDoc, $sOutput)
ClipPut($oXMLDoc.xml)
MsgBox(0, "XML", _XML_TIDY($oXMLDoc))
$nodes = _XML_SelectNodes($oXMLDoc, "//*[name()='Task']")
;~ $nodes = _XML_SelectNodes($oXMLDoc, "*:Task")
If @error Then
    MsgBox(0, '_XML_SelectNodes @error:', XML_My_ErrorParser(@error))
Else
    _ArrayDisplay(_XML_Array_GetNodesProperties($nodes))
EndIf



; #FUNCTION# ====================================================================================================================
; Name ..........: XML_My_ErrorParser
; Description ...: Changing $XML_ERR_ ... to human readable description
; Syntax ........: XML_My_ErrorParser($iXMLWrapper_Error, $iXMLWrapper_Extended)
; Parameters ....: $iXMLWrapper_Error   - an integer value.
;                  $iXMLWrapper_Extended           - an integer value.
; Return values .: description as string
; Author ........: mLipok
; Modified ......:
; Remarks .......: This function is only example of how user can parse @error and @extended to human readable description
; Related .......:
; Link ..........:
; Example .......: No
; ===============================================================================================================================
Func XML_My_ErrorParser($iXMLWrapper_Error, $iXMLWrapper_Extended = 0)
    Local $sErrorInfo = ''
    Switch $iXMLWrapper_Error
        Case $XML_ERR_SUCCESS
            $sErrorInfo = '$XML_ERR_SUCCESS=' & $XML_ERR_SUCCESS & @CRLF & 'All is ok.'
        Case $XML_ERR_GENERAL
            $sErrorInfo = '$XML_ERR_GENERAL=' & $XML_ERR_GENERAL & @CRLF & 'The error which is not specifically defined.'
        Case $XML_ERR_COMERROR
            $sErrorInfo = '$XML_ERR_COMERROR=' & $XML_ERR_COMERROR & @CRLF & 'COM ERROR OCCURED. Check @extended and your own error handler function for details.'
        Case $XML_ERR_ISNOTOBJECT
            $sErrorInfo = '$XML_ERR_ISNOTOBJECT=' & $XML_ERR_ISNOTOBJECT & @CRLF & 'No object passed to function'
        Case $XML_ERR_INVALIDDOMDOC
            $sErrorInfo = '$XML_ERR_INVALIDDOMDOC=' & $XML_ERR_INVALIDDOMDOC & @CRLF & 'Invalid object passed to function'
        Case $XML_ERR_INVALIDATTRIB
            $sErrorInfo = '$XML_ERR_INVALIDATTRIB=' & $XML_ERR_INVALIDATTRIB & @CRLF & 'Invalid object passed to function.'
        Case $XML_ERR_INVALIDNODETYPE
            $sErrorInfo = '$XML_ERR_INVALIDNODETYPE=' & $XML_ERR_INVALIDNODETYPE & @CRLF & 'Invalid object passed to function.'
        Case $XML_ERR_OBJCREATE
            $sErrorInfo = '$XML_ERR_OBJCREATE=' & $XML_ERR_OBJCREATE & @CRLF & 'Object can not be created.'
        Case $XML_ERR_NODECREATE
            $sErrorInfo = '$XML_ERR_NODECREATE=' & $XML_ERR_NODECREATE & @CRLF & 'Can not create Node - check also COM Error Handler'
        Case $XML_ERR_NODEAPPEND
            $sErrorInfo = '$XML_ERR_NODEAPPEND=' & $XML_ERR_NODEAPPEND & @CRLF & 'Can not append Node - check also COM Error Handler'
        Case $XML_ERR_PARSE
            $sErrorInfo = '$XML_ERR_PARSE=' & $XML_ERR_PARSE & @CRLF & 'Error: with Parsing objects, .parseError.errorCode=' & $iXMLWrapper_Extended & ' Use _XML_ErrorParser_GetDescription() for get details.'
        Case $XML_ERR_PARSE_XSL
            $sErrorInfo = '$XML_ERR_PARSE_XSL=' & $XML_ERR_PARSE_XSL & @CRLF & 'Error with Parsing XSL objects .parseError.errorCode=' & $iXMLWrapper_Extended & ' Use _XML_ErrorParser_GetDescription() for get details.'
        Case $XML_ERR_LOAD
            $sErrorInfo = '$XML_ERR_LOAD=' & $XML_ERR_LOAD & @CRLF & 'Error opening specified file.'
        Case $XML_ERR_SAVE
            $sErrorInfo = '$XML_ERR_SAVE=' & $XML_ERR_SAVE & @CRLF & 'Error saving file.'
        Case $XML_ERR_PARAMETER
            $sErrorInfo = '$XML_ERR_PARAMETER=' & $XML_ERR_PARAMETER & @CRLF & 'Wrong parameter passed to function.'
        Case $XML_ERR_ARRAY
            $sErrorInfo = '$XML_ERR_ARRAY=' & $XML_ERR_ARRAY & @CRLF & 'Wrong array parameter passed to function. Check array dimension and conent.'
        Case $XML_ERR_XPATH
            $sErrorInfo = '$XML_ERR_XPATH=' & $XML_ERR_XPATH & @CRLF & 'XPath syntax error - check also COM Error Handler.'
        Case $XML_ERR_NONODESMATCH
            $sErrorInfo = '$XML_ERR_NONODESMATCH=' & $XML_ERR_NONODESMATCH & @CRLF & 'No nodes match the XPath expression'
        Case $XML_ERR_NOCHILDMATCH
            $sErrorInfo = '$XML_ERR_NOCHILDMATCH=' & $XML_ERR_NOCHILDMATCH & @CRLF & 'There is no Child in nodes matched by XPath expression.'
        Case $XML_ERR_NOATTRMATCH
            $sErrorInfo = '$XML_ERR_NOATTRMATCH=' & $XML_ERR_NOATTRMATCH & @CRLF & 'There is no such attribute in selected node.'
        Case $XML_ERR_DOMVERSION
            $sErrorInfo = '$XML_ERR_DOMVERSION=' & $XML_ERR_DOMVERSION & @CRLF & 'DOM Version: ' & 'MSXML Version ' & $iXMLWrapper_Extended & ' or greater required for this function'
        Case $XML_ERR_EMPTYCOLLECTION
            $sErrorInfo = '$XML_ERR_EMPTYCOLLECTION=' & $XML_ERR_EMPTYCOLLECTION & @CRLF & 'Collections of objects was empty'
        Case $XML_ERR_EMPTYOBJECT
            $sErrorInfo = '$XML_ERR_EMPTYOBJECT=' & $XML_ERR_EMPTYOBJECT & @CRLF & 'Object is empty'
        Case Else
            $sErrorInfo = '=' & $iXMLWrapper_Error & @CRLF & 'NO ERROR DESCRIPTION FOR THIS @error'
    EndSwitch

    Local $sExtendedInfo = ''
    Switch $iXMLWrapper_Error
        Case $XML_ERR_COMERROR, $XML_ERR_NODEAPPEND, $XML_ERR_NODECREATE
            $sExtendedInfo = 'COM ERROR NUMBER (@error returned via @extended) =' & $iXMLWrapper_Extended
        Case $XML_ERR_PARAMETER
            $sExtendedInfo = 'This @error was fired by parameter: #' & $iXMLWrapper_Extended
        Case Else
            Switch $iXMLWrapper_Extended
                Case $XML_EXT_DEFAULT
                    $sExtendedInfo = '$XML_EXT_DEFAULT=' & $XML_EXT_DEFAULT & @CRLF & 'Default - Do not return any additional information'
                Case $XML_EXT_XMLDOM
                    $sExtendedInfo = '$XML_EXT_XMLDOM=' & $XML_EXT_XMLDOM & @CRLF & '"Microsoft.XMLDOM" related Error'
                Case $XML_EXT_DOMDOCUMENT
                    $sExtendedInfo = '$XML_EXT_DOMDOCUMENT=' & $XML_EXT_DOMDOCUMENT & @CRLF & '"Msxml2.DOMDocument" related Error'
                Case $XML_EXT_XSLTEMPLATE
                    $sExtendedInfo = '$XML_EXT_XSLTEMPLATE=' & $XML_EXT_XSLTEMPLATE & @CRLF & '"Msxml2.XSLTemplate" related Error'
                Case $XML_EXT_SAXXMLREADER
                    $sExtendedInfo = '$XML_EXT_SAXXMLREADER=' & $XML_EXT_SAXXMLREADER & @CRLF & '"MSXML2.SAXXMLReader" related Error'
                Case $XML_EXT_MXXMLWRITER
                    $sExtendedInfo = '$XML_EXT_MXXMLWRITER=' & $XML_EXT_MXXMLWRITER & @CRLF & '"MSXML2.MXXMLWriter" related Error'
                Case $XML_EXT_FREETHREADEDDOMDOCUMENT
                    $sExtendedInfo = '$XML_EXT_FREETHREADEDDOMDOCUMENT=' & $XML_EXT_FREETHREADEDDOMDOCUMENT & @CRLF & '"Msxml2.FreeThreadedDOMDocument" related Error'
                Case $XML_EXT_XMLSCHEMACACHE
                    $sExtendedInfo = '$XML_EXT_XMLSCHEMACACHE=' & $XML_EXT_XMLSCHEMACACHE & @CRLF & '"Msxml2.XMLSchemaCache." related Error'
                Case $XML_EXT_STREAM
                    $sExtendedInfo = '$XML_EXT_STREAM=' & $XML_EXT_STREAM & @CRLF & '"ADODB.STREAM" related Error'
                Case $XML_EXT_ENCODING
                    $sExtendedInfo = '$XML_EXT_ENCODING=' & $XML_EXT_ENCODING & @CRLF & 'Encoding related Error'
                Case Else
                    $sExtendedInfo = '$iXMLWrapper_Extended=' & $iXMLWrapper_Extended & @CRLF & 'NO ERROR DESCRIPTION FOR THIS @extened'
            EndSwitch
    EndSwitch
    ; return back @error and @extended for further debuging
    Return SetError($iXMLWrapper_Error, $iXMLWrapper_Extended, _
            '@error description:' & @CRLF & _
            $sErrorInfo & @CRLF & _
            @CRLF & _
            '@extended description:' & @CRLF & _
            $sExtendedInfo & @CRLF & _
            '')

EndFunc    ;==>XML_My_ErrorParser

And get proper ArrayDisplay result.

EDIT:
What you expect and what you get ?

Edited March 18, 2017 by mLipok

[VAN0]

4 hours ago, mLipok said:

And get proper ArrayDisplay result.

EDIT:
What you expect and what you get ?

Sorry, my bad, I was using wrong command (_XML_GetChildNodes) ...

yes, it works. Thank you!

[meomeo192]

I am new. Do you have help file for XML.au3 ?

Thank you very much.

[mLipok]

No.
You must try all examples from this UDF .

And eventually ask here on the forum, best in this thread.

 

[krupa]

 

On 18.03.2017 at 7:46 AM, mLipok said:

Try to use XPath like this:

http://stackoverflow.com/questions/5239685/xml-namespace-breaking-my-xpath

 

thanks for links - but its didnt work

I need only data from XML file - so I use this

...
$sFileRead = StringReplace($sFileRead, "tns:", "")
...

and all is working

Edited March 23, 2017 by krupa

[mLipok]

Try this attached example.
The most important is to use correct DOM Version:
 

Local $oXmlDoc = _XML_CreateDOMDocument(3)

 

XML__Examples_User_Krupa_JPK.au3

[krupa]

Thanks - Yes you are right. I think that I didnt use correct DOM Version.

I just found this topic where someone write that all working on verion 3 and dont work on version 6

 

[BrendonKoz]

Question with regard to _XML_UpdateField(). I've been able to successfully use this function to change a text value of a node with an existing value. I have not had much luck in setting a textual value to a node without an existing value. Am I using it incorrectly?

I'm running Scite 3.6.2 with AutoIT v3.3.14.2.

Example Code (follow the /account/account/name value, originally "username"):

Local $oXML = _XML_CreateDOMDocument(Default);
;Local $sXML = @ScriptDir & "\XML_Example_XML_Files\accounts.xml";
Local $sXML = _
    "<?xml version='1.0' encoding='UTF-8' ?>" & @CRLF & _
    "<account version='1.0'>" & @CRLF & _
    "   <account>" & @CRLF & _
    "       <protocol>prpl-jabber</protocol>" & @CRLF & _
    "       <name>username</name>" & @CRLF & _
    "       <password>password</password>" & @CRLF & _
    "   </account>" & @CRLF & _
    "</account>";
;_XML_Load($oXML, $sXML);
_XML_LoadXML($oXML, $sXML);

If @error Then
    MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, '_XML_Load', 'Error')
    Exit
EndIf

MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Pre-UpdateField', _XML_TIDY($oXML))
_XML_UpdateField($oXml, '/account/account/name', 'BrendonKoz');
MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Post-UpdateField', _XML_TIDY($oXML))
_XML_UpdateField($oXml, '/account/account/name', '');
MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Post-UpdateField', _XML_TIDY($oXML))
; DOES NOT UPDATE THE FOLLOWING
_XML_UpdateField($oXml, '/account/account/name', 'mLipok');
MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Post-UpdateField', _XML_TIDY($oXML))

 

Edited April 4, 2017 by BrendonKoz

[mLipok]

On 23.03.2017 at 10:36 AM, krupa said:

Thanks - Yes you are right. I think that I didnt use correct DOM Version.

I just found this topic where someone write that all working on verion 3 and dont work on version 6

 

 

As a result of reading this:

https://support.microsoft.com/en-us/help/269238/list-of-microsoft-xml-parser-msxml-versions
https://msdn.microsoft.com/en-us/library/jj152146(v=vs.85).aspx

and this:

https://en.wikipedia.org/wiki/MSXML#Versions

In next UDF version  I use XML DOM Version 3 as default value.

 

Edited April 4, 2017 by mLipok

[mLipok]

22 hours ago, BrendonKoz said:

I have not had much luck in setting a textual value to a node without an existing value. Am I using it incorrectly?

MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Pre-UpdateField', _XML_TIDY($oXML))
_XML_UpdateField($oXml, '/account/account/name', 'BrendonKoz');
MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Post-UpdateField', _XML_TIDY($oXML))
_XML_UpdateField($oXml, '/account/account/name', '');
MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Post-UpdateField', _XML_TIDY($oXML))

; DOES NOT UPDATE THE FOLLOWING
_XML_UpdateField($oXml, '/account/account/name', 'mLipok');
MsgBox($MB_SYSTEMMODAL + $MB_ICONINFORMATION, 'Post-UpdateField', _XML_TIDY($oXML))

 

I do not se any issue here.
Each _XML_UpdateFiled() works correctly for me.
Which XML UDF version you are using ?

 

[mLipok]

@Iczer asked how to get information about XML encoding.
Thanks to @Danyfirex we have a solution:

expandcollapse popup

#AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w- 4 -w 5 -w 6 -w 7
#Tidy_Parameters=/sort_funcs /reel

#include <array.au3>
#include <date.au3>
#include <MsgBoxConstants.au3>
#include "XML.au3"

; This COM Error Hanlder will be used globally (excepting inside UDF Functions)
;~ Global $oErrorHandler = ObjEvent("AutoIt.Error", ErrFunc_CustomUserHandler_MAIN)
;~ #forceref $oErrorHandler

; This is SetUp for the transfer UDF internal COM Error Handler to the user function
;~ _XML_ComErrorHandler_UserFunction(ErrFunc_CustomUserHandler_XML)

Example_GetProcessingInstructionLister()

#Region XML__Examples.au3 - Function
Func Example_GetProcessingInstructionLister()

    ; first you must create $oXmlDoc object
    Local $oXMLDoc = _XML_CreateDOMDocument(3)
    If Not @error Then
        Local $sXML_Content = _
                '<?xml version="1.0" encoding="utf-8"?>' & _
                '<Checkin>' & _
                '</Checkin>' & _
                ''
        _XML_LoadXml($oXMLDoc, $sXML_Content, "", False, False)
        If Not @error Then
            If $oXMLDoc.firstChild.nodeType = 7 And $oXMLDoc.firstChild.nodeName = "xml" Then
                ; Thanks to Danyfirex findings
                ;   https://www.autoitscript.com/forum/topic/187883-com-method-to-get-xml-encoding/?do=findComment&comment=1350438
                ;   Local $sEncoding = $oXMLDoc.FirstChild().Attributes.GetNamedItem("encoding").Value
                ;
                ; MSDN Reference Documentation
                ; https://msdn.microsoft.com/en-us/library/ms767592(v=vs.85).aspx

                Local $oAttrib_coll = $oXMLDoc.FirstChild().Attributes

                ; here we get encoding
                Local $sEncoding = $oAttrib_coll.GetNamedItem("encoding").Value
                ConsoleWrite("! $sEncoding = " & $sEncoding & @CRLF)

                ; here we enumerates all attributes in two ways
                For $iAttrib_idx = 0 To $oAttrib_coll.length - 1
                    ConsoleWrite("- " & $iAttrib_idx & '/' & $oAttrib_coll.length & @CRLF)
                    ConsoleWrite($oAttrib_coll.item($iAttrib_idx).name & '=' & $oAttrib_coll.item($iAttrib_idx).value & @CRLF)
                    ConsoleWrite($oAttrib_coll.item($iAttrib_idx).xml & @CRLF)
                Next

                ; simple display $oXmlDoc - for checking only
                MsgBox($MB_ICONINFORMATION, '$oXMLDoc endcoding is: ' & $sEncoding, $oXMLDoc.xml)
            EndIf
        EndIf

    EndIf
EndFunc   ;==>Example_GetProcessingInstructionLister
#EndRegion XML__Examples.au3 - Function

 

Edited April 16, 2017 by mLipok
small script cleanup

[mLipok]

Important note:

https://msdn.microsoft.com/en-us/library/ms755989(v=vs.85).aspx

Quote

The xml property always returns a Unicode string. That is, the xml property for DOMDocument converts the document from its original encoding to Unicode. As a result, the original encoding attribute is removed. For example, <?xml version="1.0" encoding="UTF-8"?> appears in the xmlproperty as follows.

 

 

<?xml version="1.0"?>  

If the original encoding was not removed by the xml property, the following line returns an error indicating the parser cannot switch from Unicode to UTF-8 encoding.

 

 

xmlDoc.loadxml(xmlDoc.xml);  

If you use the save method, the original encoding is preserved. For example, if you load a document in Microsoft® Windows® 1252 encoding, it will be saved in that format

 

Edited April 16, 2017 by mLipok

[GhostLine]

Hey guys !

I've to modify a XML file, and I don't know how to take care of it (I'm still trying to get how to make it work, but ...).

Here's a part of one of the files I've to check : for example, I've to check if lTaCreateNmbr exists, and if not, I've to create it with an arbitrary value.

Thanks for your help !

<?xml version='1.0' encoding='utf-8'?>
<TAS>
  <NEW_TA>
    <TA_CONTROL>
      <lTaCreateNmbr>14</lTaCreateNmbr>
      <iTaStatus>4</iTaStatus>
      <szLastCalledModul>clsTemplateDispatch</szLastCalledModul>
      <sModQuantityCnt>1</sModQuantityCnt>
      <dModQuantityQty>1</dModQuantityQty>

Edited June 7, 2017 by GhostLine

[chaoticyeshua]

I'm not able to get your Dell warranty example to return any values even when using your provided sample code (.au3 and .xml). All of the values are just blank. The console fills with data from the XML file, so I know it's being read, but the array does not have any data in it. Is there something I am doing wrong?

[TheDcoder]

@mLipok Thanks for keeping the UDF alive and updated . Just wanted to let you know that _XML_Validate_File is incorrectly mentioned as _XML_ValidateFile in the current functions list.

Edited October 11, 2017 by TheDcoder

[mLipok]

Thanks. 

I check it in my repo when I back to home