how to operate xml and properties file

[lippea]

I'd use autoit to operate xml and properties/ini files, like changing some node/key values, inserting/deleting node/key.

Not sure what's the best way to achieve this?

[BrewManNH]

There is a set of functions, a UDF, in the example scripts section for handling XML files.

AutoIt has built-in functions for dealing with INI files.

[lippea]

Thanks for replying. C

There is a set of functions, a UDF, in the example scripts section for handling XML files.

AutoIt has built-in functions for dealing with INI files.

Thanks for replying. What's the build-in functions for dealing with ini file? Is there any example for it?

[water]

Functions IniRead etc. Examples can be found in the help file.

[jdelaney]

delete nodes:

http://www.w3schools.com/dom/dom_nodes_remove.asp

add nodes:

http://www.w3schools.com/dom/dom_nodes_create.asp

change nodes:

http://www.w3schools.com/dom/dom_nodes_set.asp

example of simple query of xml:

$string = '<XML><Group name="Office1"><host><name>O1Pc1</name><ip>192.168.0.1</ip></host><host><name>O1Pc2</name><ip>192.168.0.2</ip></host></Group><Group name="Office2"><host><name>O2Pc1</name><ip>192.168.0.11</ip></host><host><name>O2Pc2</name><ip>192.168.0.12</ip></host></Group></XML>'
$oXML=ObjCreate("Microsoft.XMLDOM")
;$XML = @DesktopDir & "\xml1.xml"
;$oXML.load($XML) ; load document
$oXML.loadxml($string) ; load string
ConsoleWrite ( $oXML.xml & @CRLF)
;select single node
$result = $oXML.selectSingleNode( '//Group[@name="Office1"]' )
ConsoleWrite('Using $oXML.selectSingleNode: ' & @crlf )
ConsoleWrite ( $result.XML & @CRLF)
;select node col
$results = $oXML.selectNodes( '//Group' )
ConsoleWrite('Using $oXML.selectNodes: ' & @crlf )
For $result in $results
ConsoleWrite ($result.xml & @CRLF)
Next

Edited January 11, 2013 by jdelaney

[lippea]

Thanks, guys. I have tried iniwrite. It's pretty easy. I'm working on xml files now.

How about properties? I used iniwrite, but there is a blank section generated. Is there any better way?

[lippea]

Hi jdelaney

Thanks for your reply. Your code works fine.

But how about modify the node/properties value? And save the result back?

It will save a lot of my time on trying this if you can help me. Thanks in advance.

delete nodes:

http://www.w3schools.com/dom/dom_nodes_remove.asp

add nodes:

http://www.w3schools.com/dom/dom_nodes_create.asp

change nodes:

http://www.w3schools.com/dom/dom_nodes_set.asp

example of simple query of xml:

$string = '<XML><Group name="Office1"><host><name>O1Pc1</name><ip>192.168.0.1</ip></host><host><name>O1Pc2</name><ip>192.168.0.2</ip></host></Group><Group name="Office2"><host><name>O2Pc1</name><ip>192.168.0.11</ip></host><host><name>O2Pc2</name><ip>192.168.0.12</ip></host></Group></XML>'
$oXML=ObjCreate("Microsoft.XMLDOM")
;$XML = @DesktopDir & "\xml1.xml"
;$oXML.load($XML) ; load document
$oXML.loadxml($string) ; load string
ConsoleWrite ( $oXML.xml & @CRLF)
;select single node
$result = $oXML.selectSingleNode( '//Group[@name="Office1"]' )
ConsoleWrite('Using $oXML.selectSingleNode: ' & @crlf )
ConsoleWrite ( $result.XML & @CRLF)
;select node col
$results = $oXML.selectNodes( '//Group' )
ConsoleWrite('Using $oXML.selectNodes: ' & @crlf )
For $result in $results
ConsoleWrite ($result.xml & @CRLF)
Next

[jdelaney]

I'm thinking a property is an attribute, right? <test @att1='something'>

Use

$attribute = $node.getattributenode('att1')
$attribute.nodeValue="Somethinge else"

or, something like this:

$result1 = $oXML.selectSingleNode('//test/@att1')
$result1.text = "new attribute value"

lots of ways

Edited January 15, 2013 by jdelaney

[lippea]

Here is the modified code based on jdelaney.

For futhur info about XML DOM Methods, pls refers to http://msdn.microsoft.com/en-us/library/windows/desktop/ms757828%28v=vs.85%29.aspx

;$string = '<XML><Group name="Office1"><host><name>O1Pc1</name><ip>192.168.0.1</ip></host><host><name>O1Pc2</name><ip>192.168.0.2</ip></host></Group><Group name="Office2"><host><name>O2Pc1</name><ip>192.168.0.11</ip></host><host><name>O2Pc2</name><ip>192.168.0.12</ip></host></Group></XML>'

$oXML=ObjCreate("Microsoft.XMLDOM")

$oXML.load("D:temptest.xml") ; load string

ConsoleWrite ( $oXML.xml & @CRLF)

;select single node

$result = $oXML.selectSingleNode( '//Group[@name="Office1"]' )

ConsoleWrite('Using $oXML.selectSingleNode: ' & @crlf )

ConsoleWrite ( $result.XML & @CRLF)

;select single node by childe node value

$result = $oXML.selectSingleNode( '//Group/host[name="O1Pc1"]' )

ConsoleWrite('Using $oXML.selectSingleNode by child node value: ' & @crlf )

ConsoleWrite ( $result.XML & @CRLF)

;select single node by node value and modify the node

$result = $oXML.selectSingleNode( '//Group/host/name[text()="O1Pc1"]' )

$result.text="abcdefg"

ConsoleWrite('Using $oXML.selectSingleNode by node value and modified: ' & @crlf )

ConsoleWrite ( $result.XML & @CRLF)

;select nodes and modify attribute value

$results = $oXML.selectNodes( '//Group' )

ConsoleWrite('Using $oXML.selectNodes: ' & @crlf )

For $result in $results

ConsoleWrite ($result.xml & @CRLF)

$result.setAttribute("name", "abcdef")

ConsoleWrite ($result.xml & @CRLF)

Next

;save the modified xml

$oXML.save("D:temptest_modified.xml")

[lippea]

Does anyone know how to manipulate java properties file. It's pretty much like ini file, but without section

I tried iniwrite, but it will input a section even with null or blank value as section input.

Thanks, guys. I have tried iniwrite. It's pretty easy. I'm working on xml files now.

How about properties? I used iniwrite, but there is a blank section generated. Is there any better way?