@jkandasa Thanks much.

@Tag

That's brilliant - Thank you!

McAgent is similar, so could work for both.....

I have to take Mum shopping today but will try this out in the script as soon as I can 😉

@hoegaarden_bier Sorry for the inconvenience.
You have some of the options,

do restore of your last successful backup share your corrupted database with me(I will try to fix it), I understand it is difficult to upload 9GB, If possible Start from zero with the latest build.

@rozpruwacz Thank you!

https://github.com/mycontroller-org/mycontroller/issues/459

Aha! - That was the problem (and now I know who to blame for it) 😉

Thanks for the clarification 🙂

Onwards and upwards !

@daniele no worries. I am happy that you find the root cause of the issue 🙂

Hi @jkandasa and thanks a lot for your answer!

Here is my gateway sketch:

// Enable debug prints to serial monitor #define MY_DEBUG // Enable and select radio type attached #define MY_RADIO_RFM69 #define MY_IS_RFM69HW #define MY_RFM69_FREQUENCY (RFM69_868MHZ) // Enable serial gateway #define MY_GATEWAY_SERIAL #include <MySensors.h> void setup() { // Setup locally attached sensors } void presentation() { // Present locally attached sensors } void loop() { // Send locally attached sensor data here }

I enabled MY_DEBUG but it may be a mistake and the cause of the problem. I'll try without!

I got it for the button part, everything looks ok for my dummy node, thanks!

@saturn

house-out/#, house-in/#

You should add this to both subscribe and publish topics. Can you show your MQTT client code?

Found a workaround using Node-Red, for newbies like me this might be helpful:

Flash Tasmota to your Sonoff,
set MQTT topic to e.g. sonoff-1234,
full topic to e.g. /smarthome/%prefix%/%topic%/

Install Node-Red, add node-red-dashboard.
Drag a MQTT input, set topic to /smarthome/stat/sonoff-1234/POWER
Add a switch, uncheck "If msg arrives on input, pass through to output:", let it show state of the input, set on payload to String "ON", off payload to "OFF"
Add a MQTT output, set topic to /smarthome/cmnd/sonoff-1234/power

Now you should have a working switch on the Node-Red dashboard, it should always show the state of the sonoff.

To show the state of the switch in Mycontroller, add a Function and connect it to MQTT input:
if (msg.payload == "ON") {
msg.payload = 1;
} else if(msg.payload == "OFF") {
msg.payload = 0;
}
return msg;

There is a replace function for message payloads, you could use that instead.
Connect a MQTT output to the function, set topic to
mygateway-out/<id>/<child-id>/1/0/2

This will post the converted on/off message to mysensors format to be read by the mycontroller mqtt gateway.

@anduril I have removed the old method readXmlByXpath. Introduced XmlApi class to address xml stuff.

mcApi.xml().read(uri, xpath) - Returns String uri - can be local disk path or http url xpath - should be a valid xpath mcApi.xml().readAsList(uri, xpath) - Returns List<Map<String, String>> uri - can be local disk path or http url xpath - should be a valid xpath mcApi.xml().update(uri, xpath, value) uri - should be local disk path xpath - should be a valid xpath value - String value will be replaced on xpath

Is it also possible to update the values in the xml file? I don't mean adding new nodes or other fancy stuff, only updating for example /student/details/class from Three to Four.

Yes, now it is possible with,

mcApi.xml().update("/tmp/file-xml-demo.xml", "/student/details[1]/class", "Four");

As far as I read the xpath is just a pointer in the tree of an xml, so there is no option to manipulate items. Maybe there is another function available to do this.

You can call readAsList,

var list = mcApi.xml().readAsList("/tmp/file-xml-demo.xml", "//id[text()='4']/.."); // get first result var item = list.get(0); // get name, id, class item.get("name"); item.get("id"); item.get("class");

@anduril There is no direct option available to archive this setup. However, we have a workaround.

Create a virtual node/sensor - Binary sensor (will give switch type) Add your virtual button(virtual sensor) to the dashboard Create an operation to execute a script Implement two rules that should trigger script operation when there is a change in the button If you want to control based on switch ON/OFF state, just read this switch state on your script.

Screenshots:

Operation to execute script:

0_1525356581841_d79b2213-c1df-490c-877f-107f47f3a54b-image.png

A rule for switch ON state:

0_1525356344044_161a4013-9614-47e0-be21-7b31a2c0b87c-image.png

A rule for switch OFF state:

0_1525356371901_0461c12d-a04f-4c80-8d04-9408e13a7944-image.png

Virtual switch on dashboard:

0_1525356600324_ea7aa4a3-2d68-4991-b323-734fbe3877db-image.png

MySensors serial message will be converted to MQTT via serial2mqtt

@dklinkman

If I can do any other specific diagnostics please let me know. Happy to do it.

Sure, thank you for your help!