Here in Canada, our government weather service helpfully publishes their data in an XML format. Unfortunately, it’s encoded in ISO-8859-1, and the special characters seem to cause some issues with the XPATH transformation, apparently because Java String objects are encoded in UTF-16.
What I would like to do is fetch the relevant XML file and update the state of items with the relevant values, e.g. temperature. However, I haven’t yet hit on a working combination of commands to fetch the XML, change the character encoding, and parse the data out.
Assuming your reply was to my post, and your reaction was in regards to updating the items through the API, my thinking was that it would be easier to use API calls in the shell script to update multiple items (the XML has more than just temperature) then to pull the values back into the rule and have to iterate through them to set the state of the items. Although, multiple scripts could be used. Anyhow, I edited my previous post to keep it simple.
Sure. I’ve been through a number of iterations, and here are some of the errors thrown:
[WARN ] [.core.transform.TransformationHelper] - Cannot get service reference for transformation service of type <?xml version='1.0' encoding='ISO-8859-1'?>
org.osgi.framework.InvalidSyntaxException: Invalid value at "(Kanata - Orl�ans)</name>[...the rest of the XML file])": (smarthome.transform=<?xml version='1.0' encoding='ISO-8859-1'?>
I tried calling a bash pipeline, but it seemed like it was returning only the value of the curl command, rather than the whole pipeline. I haven’t tried using a bash script on disk.
I’d like to use the rules engine itself, but I’m often frustrated trying to figure out how to get things done using Xtend and the Rules DSL.
Fiddling with executeCommandLine is tricky, but much easier when just calling a shell script that can be tested on the command line. Something like this:
rule "Test"
when
//Item Virtual_Switch_1 changed to ON
//or
Time cron "0 0/5 * * * ?"
then
val String currentTemp = executeCommandLine("/opt/openhab2/conf/scripts/temperature.sh",30000)
logDebug("Rules", "test: currentTemp=[{}]",currentTemp)
Virtual_Number_1.postUpdate(currentTemp)
end
Thanks, I ended up doing something similar but using Python and the REST API instead. It seems to be working, and with no drama about the encoding.
It might be heretical, but I can see a lot of advantages to this approach. I’ve spent a lot of time trying to decipher the nuances of the not-quite-Java, not-quite-Xtend DSL used for rules, and it’s definitely a lot easier to find answers to the same questions for Python.
Rule:
/*** Update weather from Environment Canada ***/
rule "Update EC weather"
when
Time cron "0 0/5 * * * ?"
then
executeCommandLine('python /etc/openhab2/rules/ec-weather.py', 10000)
end
Python:
import requests
from xml.etree import ElementTree
### Fetch data and extract values ###
response = requests.get('http://dd.weatheroffice.ec.gc.ca/citypage_weather/xml/ON/s0000430_e.xml')
xml = ElementTree.fromstring(response.content)
temp = xml.find('./currentConditions/temperature').text
humidity = xml.find('./currentConditions/relativeHumidity').text
windChill = xml.find('./currentConditions/windChill').text
forecastLow = xml.find('.//forecast/temperatures/temperature[@class="low"]').text
### Update OpenHAB items via REST API ###
s = requests.Session()
s.headers = {"Content-Type": "text/plain", "Accept": "application/json"}
s.put(url="http://192.168.0.121:8080/rest/items/Temperature/state", data = str(temp))
s.put(url="http://192.168.0.121:8080/rest/items/Humidity/state", data = str(humidity))
s.put(url="http://192.168.0.121:8080/rest/items/WindChill/state", data = str(windChill))
s.put(url="http://192.168.0.121:8080/rest/items/ForecastLow/state", data = str(forecastLow))
One thing to be aware of is that the JSR223 add-on will let you write all your Rules in Jython, JavaScript, or Groovy if you are more comfortable in those languages.
But coding something up in Python and calling it from the Rules DSL is far from heretical.
