So three of the 7 months of TeslaFi imported then I got the error above.
I deleted the import files than reimported the ones that failed one by one. They all reported as imported successfully however when I check my drive history I'm missing the last 3 months.
I guess I need to find the row in the csv that's causing the error? Then I think I'll need to restart the import. But given the import tool marked 3 imports as successful yet there's no data to show, should I nuke the existing imports? Suspect I can access TeslaMate via mysql workbench or similar and delete the existing imported rows?
Yes, looks like it's a value out of range (for a signed int16) in the CSV. You can manually access postgres via the CLI (see below), or via any Postgres compatible browser if you prefer.
Code:
docker-compose exec database psql teslamate teslamate