Hi All,
Due to a reconfiguration of my network my Youless LS120 has got a new IP address. As a result I have lost all historic data of the Youless in Domoticz. Of course all the data is still present in the Youless.
Is there a way to import the old data of the Youless back into Domoticz?
TIA
Greetz,
Sjonnie
Youless - import old data from youless after change of IP?
Moderators: leecollings, remb0
- Sjonnie2017
- Posts: 375
- Joined: Wednesday 02 August 2017 19:43
- Target OS: Linux
- Domoticz version: Latest ß
- Location: The Netherlands
- Contact:
Youless - import old data from youless after change of IP?
ConBee II - TRÅDFRI lights + switches, loads of ChingLing dimmers and switches, Heiman and Xiaomi sensors
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
- waaren
- Posts: 6028
- Joined: Tuesday 03 January 2017 14:18
- Target OS: Linux
- Domoticz version: Beta
- Location: Netherlands
- Contact:
Re: Youless - import old data from youless after change of IP?
please have a look at this postSjonnie2017 wrote: Sunday 02 February 2020 14:02 Due to a reconfiguration of my network my Youless LS120 has got a new IP address. As a result I have lost all historic data of the Youless in Domoticz. Of course all the data is still present in the Youless.
Is there a way to import the old data of the Youless back into Domoticz?
Debian buster, bullseye on RPI-4, Intel NUC.
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
- Sjonnie2017
- Posts: 375
- Joined: Wednesday 02 August 2017 19:43
- Target OS: Linux
- Domoticz version: Latest ß
- Location: The Netherlands
- Contact:
Re: Youless - import old data from youless after change of IP?
Thanks for your reply! I have read the post you are referring to and I am struggling a bit to get this to work. For one I don't know the old idx of the youless meter. And I don't know which calendar I am supposed to be using (meter or multimeter?).
If you would be so kind to support me a bit more I would really appreciate that
TIA
Greetz,
Sjonnie
If you would be so kind to support me a bit more I would really appreciate that
TIA
Greetz,
Sjonnie
ConBee II - TRÅDFRI lights + switches, loads of ChingLing dimmers and switches, Heiman and Xiaomi sensors
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
-
JuanUil
- Posts: 500
- Joined: Friday 22 May 2015 12:21
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 4.11083
- Location: Asten NB Nederland
- Contact:
Re: Youless - import old data from youless after change of IP?
post a how to in https://www.domoticz.com/forum/viewtopi ... =28&t=8915
you have to use meter calender
you have to use meter calender
Your mind is like a parachute,
It only works when it is opened!
RPI4 several Fibaro, KaKu, Neocoolcam switches, Z-Wave, Zigbee2Mqtt, Ikea bulbs and remote, Zigbee temp nodes
It only works when it is opened!
RPI4 several Fibaro, KaKu, Neocoolcam switches, Z-Wave, Zigbee2Mqtt, Ikea bulbs and remote, Zigbee temp nodes
- Sjonnie2017
- Posts: 375
- Joined: Wednesday 02 August 2017 19:43
- Target OS: Linux
- Domoticz version: Latest ß
- Location: The Netherlands
- Contact:
Re: Youless - import old data from youless after change of IP?
Hi Jan,
Tx! I gave it a couple of tries but I was unsuccessful.
I created a CSV from the table meter calendar of a backed up database and adjusted the IDX values to the new ones. I imported them into the database but unfortunately I cannot see the data. I was sure to remove the header line and the data sits there just fine. It just won't show
Any ideas?
Greetz,
Sjonnie
Tx! I gave it a couple of tries but I was unsuccessful.
Any ideas?
Greetz,
Sjonnie
ConBee II - TRÅDFRI lights + switches, loads of ChingLing dimmers and switches, Heiman and Xiaomi sensors
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
- Sjonnie2017
- Posts: 375
- Joined: Wednesday 02 August 2017 19:43
- Target OS: Linux
- Domoticz version: Latest ß
- Location: The Netherlands
- Contact:
Re: Youless - import old data from youless after change of IP?
As it happens by importing the CSV I have inadvertently restored the gas consumption. That's great!
But how do I restore my electricity/power consumption? I cannot find any reference to it in table Meter Calendar.
EDIT: YES! Got it! Electricity is not stored in "meter calendar" but in "multimeter calendar"
Created a new CSV, deleted all records and imported the data back in. Now I have an (almost) complete history of my energy consumption. Only missing a couple days.
Thanks to all who have helped me
Greetz,
Sjonnie
But how do I restore my electricity/power consumption? I cannot find any reference to it in table Meter Calendar.
EDIT: YES! Got it! Electricity is not stored in "meter calendar" but in "multimeter calendar"
Thanks to all who have helped me
Greetz,
Sjonnie
ConBee II - TRÅDFRI lights + switches, loads of ChingLing dimmers and switches, Heiman and Xiaomi sensors
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
-
JuanUil
- Posts: 500
- Joined: Friday 22 May 2015 12:21
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 4.11083
- Location: Asten NB Nederland
- Contact:
Re: Youless - import old data from youless after change of IP?
Hi Sjonnie,
Glad that it worked for you.
Maybe a point of attention:
Don't delete the header data
Sometimes the csv file has a format for the date as 03-02-2020
Most time the dateformat in the dbase is as 2020-03-02
Sochange the format in the csv accordanly to the format in your database.
Glad to be able to help you
Jan
Glad that it worked for you.
Maybe a point of attention:
Don't delete the header data
Sometimes the csv file has a format for the date as 03-02-2020
Most time the dateformat in the dbase is as 2020-03-02
Sochange the format in the csv accordanly to the format in your database.
Glad to be able to help you
Jan
Your mind is like a parachute,
It only works when it is opened!
RPI4 several Fibaro, KaKu, Neocoolcam switches, Z-Wave, Zigbee2Mqtt, Ikea bulbs and remote, Zigbee temp nodes
It only works when it is opened!
RPI4 several Fibaro, KaKu, Neocoolcam switches, Z-Wave, Zigbee2Mqtt, Ikea bulbs and remote, Zigbee temp nodes
- Sjonnie2017
- Posts: 375
- Joined: Wednesday 02 August 2017 19:43
- Target OS: Linux
- Domoticz version: Latest ß
- Location: The Netherlands
- Contact:
Re: Youless - import old data from youless after change of IP?
Hi Jan,
I checked the header and made sure the data was all formatted the way Domoticz likes it
I just love my restored charts
Thanks for your support!
Greetz,
Sjonnie
I checked the header and made sure the data was all formatted the way Domoticz likes it
Thanks for your support!
Greetz,
Sjonnie
ConBee II - TRÅDFRI lights + switches, loads of ChingLing dimmers and switches, Heiman and Xiaomi sensors
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
SolarEdge SE4000H (with active modbus_tcp)
YouLess Energy meter
Shelly 2.5 in roller shutter mode
Who is online
Users browsing this forum: No registered users and 1 guest