question

alaskannoob avatar image
alaskannoob asked

Decode Sqlite on CerboGX without Using VictronConnect?

Just wondering if anybody is aware of a script or something to decrypt or parse the sqlitedb on the CerboGX so the data can be downloaded via SSH, converted, and graphed in an automated fashion.

I'm not even sure what the timestamps mean in the database...

ie "1698216312"

sqlite
5 comments
2 |3000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

kevgermany avatar image kevgermany ♦♦ commented ·
@AlaskanNoob

Moved to modifications space.


Guessing the time stamp is seconds since a base date. Try converting it into days hours minutes seconds and see if that gets you back to a decent base date, like 1 Jan 1970

1 Like 1 ·
alaskannoob avatar image alaskannoob kevgermany ♦♦ commented ·

I don't know. I'm not a bright man and I'm not good with numbers, but I don't see a pattern in the first two timestamps:


First time stamp in SqlLite is: 1698183265

First VictronConnect converted record is: 10/24/2023 1:40:01 PM

Second time stamp in SqlLite is: 1698183458

Second VictronConnect converted record is: 10/24/2023 1:54:50 PM

The difference between the two time stamps is 193. I'm not sure how to make that equate to 14 minutes and 49 seconds of difference.

0 Likes 0 ·
gerard-van-seventer avatar image gerard-van-seventer alaskannoob commented ·

I think you made a conversion mistake. You can use this to check: https://www.epochconverter.com/

1 Like 1 ·
alaskannoob avatar image alaskannoob gerard-van-seventer commented ·
Thanks for sharing that tool, that seems to crack the code. Many thanks!
1 Like 1 ·
alaskannoob avatar image alaskannoob gerard-van-seventer commented ·
Wouldn't surprise me. All I did was take the first and second records in the sqlite DB and then the first and second records in the VictronConnect converted xls file.
0 Likes 0 ·
0 Answers

Related Resources

Additional resources still need to be added for this topic