Youless - import old data from youless after change of IP?

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
User avatar
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?

Post by Sjonnie2017 »

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
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
User avatar
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?

Post by waaren »

Sjonnie2017 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?
please have a look at this post
Debian buster, bullseye on RPI-4, Intel NUC.
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
User avatar
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?

Post by Sjonnie2017 »

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
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
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 by JuanUil »

post a how to in https://www.domoticz.com/forum/viewtopi ... =28&t=8915

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
User avatar
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?

Post by Sjonnie2017 »

Hi Jan,

Tx! I gave it a couple of tries but I was unsuccessful. :oops: 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
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
User avatar
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?

Post by Sjonnie2017 »

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" :shock: 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. :mrgreen:

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
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 by JuanUil »

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
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
User avatar
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?

Post by Sjonnie2017 »

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 :mrgreen:

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
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest