Can I manually edit data?

[djpalmis]

I would like to change the first update date: it is the date I installed teslamate, it's not the real firmware update date.

Also: I was charging at home. There was a blackout. Powerline adapter turned off and car was unable to send data to servers.
Turns out that for teslamate that charge was never stopped.. even if it has no data for a long time frame.
So it would be nice to edit that charge session.

[eliluong]

You can use something like pgAdmin to connect to the database. You will have to look at the data and study how the database is structured, and then should be able to safely edit it (after making a backup of the database, of course).

[djpalmis]

Thank You, I searched on google but honestly I can't do it: It would be better if it were editable on grafana, at least the first firmware update data field.

[eliluong]

Unfortunately, I think any incorrect edit can probably ruin the database or prevent data from being parsed properly, and developer would have to implement code for editing, too.

For updates, there is a table called updates that has the firmware start and end date and version number:

For charging, there is a table called charged_processes that is the record of each charge start/stop time, along with the data for each charge session (minus the individual battery level, charge voltage, etc at each timepoint, which is stored in a different table).

I've never edited a charge session before so I don't know what may happen if the end time overlaps with the start time of something else.