Domoticz

How can i get the info out of an xml file and use it in domoticz?
So there be devices with the given info from the xml file in domoticz.
Example : CloseInBoiler status=on usage=0W
See my xml file:

<PlugwiseSource Version="1.0">
<Appliances>
<Appliance Id="13" Name="CloseInBoiler" Type="water_heater_vessel" PowerUsage="0,0000" TotalUsage="927,83" PowerState="on" Module="14" Image="/sysimg/32/water_heater_vessel_on.png"/>
<Appliance Id="9" Name="CV-ketel" Type="heater_central" PowerUsage="69,0000" TotalUsage="394,95" PowerState="on" Module="10" Image="/sysimg/32/heater_central_on_locked.png"/>
<Appliance Id="5" Name="Droger" Type="dryer" PowerUsage="0,0000" TotalUsage="1161,39" PowerState="on" Module="6" Image="/sysimg/32/dryer_on.png"/>
<Appliance Id="1" Name="HsProServer" Type="monitor" PowerUsage="0,0000" TotalUsage="49,03" PowerState="on" Module="2" Image="/sysimg/32/monitor_on_locked.png"/>
<Appliance Id="14" Name="Koelkast" Type="refrigerator" PowerUsage="0,0000" TotalUsage="700,04" PowerState="on" Module="15" Image="/sysimg/32/refrigerator_on.png"/>
<Appliance Id="8" Name="Magnetron" Type="oven_microwave" PowerUsage="1,0000" TotalUsage="56,97" PowerState="on" Module="9" Image="/sysimg/32/oven_microwave_on.png"/>
<Appliance Id="2" Name="MediaCenter" Type="hometheater" PowerUsage="0,0000" TotalUsage="206,49" PowerState="unknown" Module="3" Image="/sysimg/32/hometheater_unknown_locked.png"/>
<Appliance Id="3" Name="Multimedia" Type="hometheater" PowerUsage="36,0000" TotalUsage="433,33" PowerState="on" Module="4" Image="/sysimg/32/hometheater_on.png"/>
<Appliance Id="10" Name="ongebruikt" Type="zz_misc" PowerUsage="0,0000" TotalUsage="19,24" PowerState="unknown" Module="11" Image="/sysimg/32/zz_misc_unknown.png"/>
<Appliance Id="17" Name="Ongebruikt2" Type="zz_misc" PowerUsage="0,0000" TotalUsage="40,99" PowerState="unknown" Module="18" Image="/sysimg/32/zz_misc_unknown.png"/>
<Appliance Id="6" Name="PcEd" Type="computer_desktop" PowerUsage="0,0000" TotalUsage="4,59" PowerState="unknown" Module="7" Image="/sysimg/32/computer_desktop_unknown.png"/>
<Appliance Id="4" Name="Router" Type="router" PowerUsage="24,0000" TotalUsage="44,83" PowerState="on" Module="5" Image="/sysimg/32/router_on_locked.png"/>
<Appliance Id="11" Name="Senseo" Type="coffee_maker" PowerUsage="1,0000" TotalUsage="75,64" PowerState="on" Module="12" Image="/sysimg/32/coffee_maker_on.png"/>
<Appliance Id="16" Name="Televisie" Type="tv" PowerUsage="0,0000" TotalUsage="567,99" PowerState="on" Module="17" Image="/sysimg/32/tv_on.png"/>
<Appliance Id="12" Name="TvSlaapkamer" Type="tv" PowerUsage="0,0000" TotalUsage="61,55" PowerState="off" Module="13" Image="/sysimg/32/tv_off.png"/>
<Appliance Id="15" Name="VijverPomp" Type="pump_heater" PowerUsage="2,0000" TotalUsage="46,50" PowerState="unknown" Module="16" Image="/sysimg/32/pump_heater_unknown.png"/>
<Appliance Id="7" Name="Wasmachine" Type="washingmachine" PowerUsage="0,0000" TotalUsage="382,05" PowerState="on" Module="8" Image="/sysimg/32/washingmachine_on.png"/>

Could someone help me with this?
Thanks
Regards
Edwin

Should be possible with PHP.
I use this command to get the status of a Denon receiver wich is also presented in XML format:
Values are then available in a associated array, for ex: the function file_get_contents can be url or local file.

It can also be done directly in Lua, just like JSON.
There's an XML.lua file available, and LuaRocks has at least one library.

Thanks for your help
but Cant get it done in lua example.xml i get errors i do something wrong.
Can u please give me a filled in example? What to fill in at : s = request['content'];
sorry total new to scripting


My xml is:
http://192.168.2.166:port/xml/appliances.xml



-- Example of XML parser handling data with the following structure
--<?xml version="1.0" encoding="UTF-8"?>
--<sensor>
-- <id>13</id>
-- <value>29.99</value>
--</sensor>

--}

-- A test with curl would be : curl -X POST -d "@test.xml" 'http://192.168.1.17:8080/json.htm?type= ... le_xml.lua'

-- Retrieve the request content
s = request['content'];

-- Update some devices (index are here for this example)
local id = domoticz_applyXPath(s,'//id/text()')
local s = domoticz_applyXPath(s,'//value/text()')
domoticz_updateDevice(id,'',s)

nobody?

You know it's very agressive to bump your topic with a comment like that?
I provided a way but you didn't even bother to try or respond on it.

Advise to first use (in future) the search-function in this forum, because at least 2 other, older threads which follow the line of your question, and may provide a solution:
http://www.domoticz.com/forum/viewtopic.php?f=28&t=1837
http://www.domoticz.com/forum/viewtopic ... 23&t=11472

Sorry didnt ment it that way, i did try the xml.lua filled in my ip and the line of the xml
But i only get errors.
I told in my previous post that i dont have scripting experience or program skills , so its hard for me to understand the script. I search the internet for something simmulair but couldt find it.
Im very thankfull for your help and answer,
I Will wait for a solution that i understand

Thanks
Regards
Edwin

The php solution is pretty simple and straight forward AND there's a HUGE userbase for php, so you'll find anything for it.

Thanks monday for your php solution,
Can u tell me how i get the outcome in domoticz?

Regards
Edwin

Best way to go is first set up a PHP enabled webserver if you don't have that already.
Then create a PHP file with the function posted above and loop through the array until you have the desired values in variables.
Then put those variables in a json command to sent them to domoticz.

For experimenting/learning to work with a PHP-enabled webserver looking for a small software package (of at least Apache/PHP/SQL) to run at one of the local 'leftover-PCs' with WindowsXP. Have been trying to install&configure Xitami+PHP5 and as alternative EasyPHPDevserver, but still meet problems. Xitami+PHP5 is rather small, but limited (e.g. no SQL_DB). EasyPHP-package is complete, but rather big for the available PCs.
Any other, simple & small & robust package recommended?