Import from TeslaFi not working if converting files from Tessie to TeslaFi using third party tool

[jaswals]

Is there an existing issue for this?

• I have searched the existing issues

What happened?

I have searched existing issues, they have been closed off due to no activity
Old Issue: #2896

I have exact issue and don't know how to fix it.

• 3 files (1 file per month)
• Files were exported from Tessie then converted to TeslaFi format using this tool: https://www.myteslamate.com/tessie-to-teslamate/
• Only first file shows checkmark out of 3 but no data gets imported from any of the 3 files
• Vehicle ID is present (1)
• There are no strange/special characters in the csv
• CVS was not opened in excel (no changes were made)
• Date/time format is correct
• Display Name of Car is there and it matches with what's in the teslamate (Tesla)
• DB Container logs show no activity at all
• import folder permissions are good.

Teslamate Container logs are below:

teslamate-teslamate-1 | [info] Found 3 file(s) at '/opt/app/import'. Starting in import mode!
teslamate-teslamate-1 | 2025-01-26 19:59:28.569 [info] System Info: Erlang/OTP 26 (jit)
teslamate-teslamate-1 | 2025-01-26 19:59:28.569 [info] Version: 1.32.0
teslamate-teslamate-1 | 2025-01-26 19:59:29.026 [info] POST https://auth.tesla.com/oauth2/v3/token -> 200 (382.104 ms)
teslamate-teslamate-1 | 2025-01-26 19:59:29.026 [info] Refreshed api tokens
teslamate-teslamate-1 | 2025-01-26 19:59:29.070 [info] Scheduling token refresh in 6 h
teslamate-teslamate-1 | 2025-01-26 19:59:29.085 [info] Running TeslaMateWeb.Endpoint with cowboy 2.12.0 at :::4000 (http)
teslamate-teslamate-1 | 2025-01-26 19:59:29.086 [info] Access TeslaMateWeb.Endpoint at http://localhost/
teslamate-teslamate-1 | 2025-01-26 19:59:29.974 [info] GET /
teslamate-teslamate-1 | 2025-01-26 19:59:29.980 [info] Sent 302 in 6ms
teslamate-teslamate-1 | 2025-01-26 19:59:29.989 [info] GET /import
teslamate-teslamate-1 | 2025-01-26 19:59:29.998 [info] Sent 200 in 9ms
teslamate-teslamate-1 | 2025-01-26 19:59:39.732 [info] Importing 3 file(s) ...
teslamate-teslamate-1 | 2025-01-26 19:59:39.739 [info] Starting logger for 'Tesla'
teslamate-teslamate-1 | 2025-01-26 19:59:40.258 [info] Import complete!

Expected Behavior

Data from CSV should get imported.

Steps To Reproduce

Follow steps to place CSV in import folder
Restart Teslamate service
Go to Teslatemate URL and import prompt appears showing you the files and asking for timezone.
set timezone and tap on import button
only 1 of X files show checkmark but nothing gets imported into the DB.

Relevant log output

teslamate-teslamate-1  | [info] Found 3 file(s) at '/opt/app/import'. Starting in import mode!
teslamate-teslamate-1  | 2025-01-27 22:35:46.655 [info] Migrations already up
teslamate-teslamate-1  | [info] Found 3 file(s) at '/opt/app/import'. Starting in import mode!
teslamate-teslamate-1  | 2025-01-27 22:35:50.162 [info] System Info: Erlang/OTP 26 (jit)
teslamate-teslamate-1  | 2025-01-27 22:35:50.162 [info] Version: 1.32.0
teslamate-teslamate-1  | 2025-01-27 22:35:50.504 [info] POST https://auth.tesla.com/oauth2/v3/token -> 200 (261.011 ms)
teslamate-teslamate-1  | 2025-01-27 22:35:50.504 [info] Refreshed api tokens
teslamate-teslamate-1  | 2025-01-27 22:35:50.577 [info] Scheduling token refresh in 6 h
teslamate-teslamate-1  | 2025-01-27 22:35:50.591 [info] Running TeslaMateWeb.Endpoint with cowboy 2.12.0 at :::4000 (http)
teslamate-teslamate-1  | 2025-01-27 22:35:50.594 [info] Access TeslaMateWeb.Endpoint at http://localhost
teslamate-teslamate-1  | 2025-01-27 22:35:52.089 [info] GET /import
teslamate-teslamate-1  | 2025-01-27 22:35:52.099 [info] Sent 200 in 9ms
teslamate-teslamate-1  | 2025-01-27 22:36:57.337 [info] GET /import
teslamate-teslamate-1  | 2025-01-27 22:36:57.345 [info] Sent 200 in 7ms
teslamate-teslamate-1  | 2025-01-27 22:37:58.753 [info] Importing 3 file(s) ...
teslamate-teslamate-1  | 2025-01-27 22:37:58.760 [info] Starting logger for 'Tesla'
teslamate-teslamate-1  | 2025-01-27 22:37:59.320 [info] Import complete!

Screenshots

No response

Additional data

No response

Type of installation

Docker

Version

1.32.0

[JakobLichterfeld]

maybe related #4477

[jaswals]

maybe related #4477

It's not related, unlike #4477 I don't set any errors in the logs, instead it says import was successful.

1. anyone knows in which scenarios, I would see import completed successfully with checkmark on only first of the 3 files but not all all gets imported into the DB.
2. shouldn't the DB container logs show inserts being done in the DB? I see no activity in the DB logs at all even through testlamate says import was complete

[jaswals]

maybe related #4477

Let me know what other information is needed. (per the label you have added)