Import parts of data from other dbase

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
MikeyMan
Posts: 237
Joined: Wednesday 17 October 2018 12:11
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Import parts of data from other dbase

Post by MikeyMan »

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

Post by waaren »

MikeyMan 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?
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
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

Post by MikeyMan »

waaren wrote: Sunday 02 February 2020 14:31
MikeyMan 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?
please have a look at this post
That looks like a step in the right direction, but like i said; total n00b with this stuff...
Above my paygrade so to say :)
User avatar
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

Post by waaren »

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 :)
There are many ways to learn new things. One way is to create a safe environment and just do it.
Debian buster, bullseye on RPI-4, Intel NUC.
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

Post by MikeyMan »

waaren wrote: Sunday 02 February 2020 14:49
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 :)
There are many ways to learn new things. One way is to create a safe environment and just do it.
There are many ways to create a good piece of software...
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

Post by HvdW »

Read this post and read about exporting to cvs and awk.
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 by JuanUil »

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

Who is online

Users browsing this forum: No registered users and 1 guest