Page 1 of 1

Import parts of data from other dbase

Posted: Sunday 02 February 2020 14:27
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

Re: Import parts of data from other dbase

Posted: Sunday 02 February 2020 14:31
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

Re: Import parts of data from other dbase

Posted: Sunday 02 February 2020 14:35
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 :)

Re: Import parts of data from other dbase

Posted: Sunday 02 February 2020 14:49
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.

Re: Import parts of data from other dbase

Posted: Sunday 02 February 2020 15:00
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...

Re: Import parts of data from other dbase

Posted: Sunday 02 February 2020 15:27
by HvdW
Read this post and read about exporting to cvs and awk.
There is much more information on this forum.

Re: Import parts of data from other dbase

Posted: Sunday 02 February 2020 16:57
by JuanUil