-
-
Notifications
You must be signed in to change notification settings - Fork 641
This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Feature Request] Functionality to edit/fix charging session energy and metrics #14628
Comments
Our primary goal should be to fix the root causes of wrong data (charged energy) being written to the database. In normal operation, there should be no need to manually adjust values, but I see why you might want this as an easier fixing mechanism when something goes wrong. We could make some fields UI editable, but this opens up more opportunity for other inconsistencies. The price and solar_percentage field and the upcoming savings #13950 are logically linked. We could try to build heuristics to also adjust these values based on energy change, but this will not be accurate when you e.g. have a dynamic tariff. My hope is, that this "wrong values due to bugs" use case is not widespread enough to justify this feature. Direct editing in your SQLite db always works for one-time hiccups. Nevertheless, I'll keep this issue open to collect more opinions but limit the scope (title) to charging values. Editing start/end or loadpoints is out of scope for this issue. |
I also would appreciate this option. Not because of general issues in the calculation, but in my case I e.g. made a simulation if a dynamic energy tariff would make sense. So I enabled the dynamic tariff and kept it running for couple of weeks. However, of course after the simulation my prices in the overview and savings are not correct anymore. To avoid manual adjustments directly in database for user, this feature could be helpful. For simulation as use case. (but not sure if this is wanted, anyway no priority) |
If I knew how to edit the sqlite database directly I could do that. I am running evcc as an HomeAssistant add-on and I have no idea where the database is stored/how to login into it and fix the wrong values.. |
Ich switche mal schnell auf deutsch, da das eh nur indirekt mit dem Thema zu tun hat. Generell würde ich aber empfehlen die DB nicht im Add-on zu speichern, sondern den Speicherort ins HA config Verzeichnis zu verlegen, dann kommst du zb per Samba share immer direkt drauf. (nur regelmäßig Backup machen der DB dann nicht vergessen) Für das Bearbeiten der DB gibt's auch auf Windows eigene Programme, dann kann man mit einer GUI arbeiten. Einfach mal nach Sqlite DB Browser googeln. |
Gerade wollte ich schreiben, dass ich die Datenbank gefunden habe (per docker eine Shell aufmachen und dann in Frage ist nur: wenn ich den Speicherort dann dauerhaft ändern möchte, und das confnig-File entsprechend editiere, verliere ich dann alle alten Daten, d.h. wird im neuen Zielverzeichnis die DB neu angelegt? Und, zweite Frage - wie erstelle ich ein Backup nur dieses Add-Ons (habe ich bisher noch nie gebraucht)? |
Zur ersten Frage: Wenn du das Verzeichnis im Add-on änderst, brauchst du nur die "alte" DB in das neue Verzeichnis kopieren und du hast alle Daten wie gehabt. Zweite Frage: System - Backup - Backup erstellen - partielles Backup - evcc addon auswählen. |
vielen Dank. Sorry für die Beginner-Fragen, aber wie kopiere ich eine Datei aus einem docker container (hier die evcc.db) in das HA-Filesystem? |
Am besten lädst du dir das Addon Samba share runter, dann kommst du via IP Adresse ganz normal im Windows Explorer drauf. |
Backup: hat geklappt mit dem Editieren, nur hochladen des Backup-Files gibt mir einen "Bad request"... |
Schwierig zu sagen an was es genau liegt. Am einfachsten wäre es wohl den Speicherort der DB im addon zu ändern und die gerade von dir bearbeite DB an die Stelle zu kopieren. |
This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
It unfortunately happens (issue opened already) that the amount of energy charged is recorded incorrectly by evcc. These wrong (very high) energy values mess up the charging statistics.
It'd be great if, in addition to the ability to delete an entry, a simple editing interface was available. Sufficient for me would already be if I could edit/fix the amount of energy charged. If additional values could be edited that would also be nice of course.
The text was updated successfully, but these errors were encountered: