Hi All,
Since the last beta update crashed my domoticz and i cannot seem to bring a dbase online more recent than 07 january, i have a big gap in my logging.
Is there any way to import the P1 Meter data from 7 january till yesterday somehow?
I've looked into sqlite editors, but that seems to difficult for me to grasp as a total n00b in this field.
Would be nice funcitonality i guess? Point to a db, and select parts of data you'd like to import
Import parts of data from other dbase
Moderators: leecollings, remb0
- waaren
- Posts: 6028
- Joined: Tuesday 03 January 2017 14:18
- Target OS: Linux
- Domoticz version: Beta
- Location: Netherlands
- Contact:
Re: Import parts of data from other dbase
please have a look at this postMikeyMan wrote: Sunday 02 February 2020 14:27 Since the last beta update crashed my domoticz and i cannot seem to bring a dbase online more recent than 07 january, i have a big gap in my logging.
Is there any way to import the P1 Meter data from 7 january till yesterday somehow?
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
-
MikeyMan
- Posts: 237
- Joined: Wednesday 17 October 2018 12:11
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Import parts of data from other dbase
That looks like a step in the right direction, but like i said; total n00b with this stuff...waaren wrote: Sunday 02 February 2020 14:31please have a look at this postMikeyMan wrote: Sunday 02 February 2020 14:27 Since the last beta update crashed my domoticz and i cannot seem to bring a dbase online more recent than 07 january, i have a big gap in my logging.
Is there any way to import the P1 Meter data from 7 january till yesterday somehow?
Above my paygrade so to say
- waaren
- Posts: 6028
- Joined: Tuesday 03 January 2017 14:18
- Target OS: Linux
- Domoticz version: Beta
- Location: Netherlands
- Contact:
Re: Import parts of data from other dbase
There are many ways to learn new things. One way is to create a safe environment and just do it.MikeyMan wrote: Sunday 02 February 2020 14:35 That looks like a step in the right direction, but like i said; total n00b with this stuff...
Above my paygrade so to say![]()
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
-
MikeyMan
- Posts: 237
- Joined: Wednesday 17 October 2018 12:11
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Import parts of data from other dbase
There are many ways to create a good piece of software...waaren wrote: Sunday 02 February 2020 14:49There are many ways to learn new things. One way is to create a safe environment and just do it.MikeyMan wrote: Sunday 02 February 2020 14:35 That looks like a step in the right direction, but like i said; total n00b with this stuff...
Above my paygrade so to say![]()
One way is to take input from the users serious and make it as good as possible...
-
HvdW
- Posts: 663
- Joined: Sunday 01 November 2015 22:45
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2023.2
- Location: Twente
- Contact:
Re: Import parts of data from other dbase
Read this post and read about exporting to cvs and awk.
There is much more information on this forum.
There is much more information on this forum.
Bugs bug me.
-
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: Import parts of data from other dbase
post a how to in https://www.domoticz.com/forum/viewtopi ... =28&t=8915
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
Who is online
Users browsing this forum: Amazon [Bot], Bing [Bot] and 1 guest