Tessie to TeslaMate Migration #4112
Replies: 10 comments 10 replies
-
|
Could go Tessie > TeslaFi > TeslaMate since TeslaFi importing is supported. |
Beta Was this translation helpful? Give feedback.
-
|
I was incorrect with my statement. You can go TeslaFi to Tessie, but not the other way around. |
Beta Was this translation helpful? Give feedback.
-
|
If I could get a sample output, I would have a look... |
Beta Was this translation helpful? Give feedback.
-
|
Attached the drives and charges csv. Removed my location data. Let me know if you need anything further. |
Beta Was this translation helpful? Give feedback.
-
|
I don't see any location data in them. So, tables And, not sure, how to deal with So, migration probably does not make sense. |
Beta Was this translation helpful? Give feedback.
-
|
There is location data. I removed the data in the columns for privacy. Do you have an email or something that I can send the file with location data to? |
Beta Was this translation helpful? Give feedback.
-
|
Drop it here (link removed) and tell me, when done please. |
Beta Was this translation helpful? Give feedback.
-
|
So, I took a closer look at the drives data. One could fill in the columns of drives and positions partially (the blue fields come from Tessie): Not sure, what one could get then in the dashboards though. Any thoughts? (I am unsure about the 'location' in the Tessie data. What is it?) |
Beta Was this translation helpful? Give feedback.
-
|
Feel like the juice is not worth the squeeze there. More negative downstream impacts by having partial data. |
Beta Was this translation helpful? Give feedback.
-
|
Uploaded everything to dropbox. Let me know if this helps fill in some of the gaps. Will trust your discretion if this would provide benefit to TeslaMate. From my POV, I have a bunch of data sitting in Tessie that I would love to migrate in to get a more comprehensive view of my all my data. |
Beta Was this translation helpful? Give feedback.
-
|
Well, obviously a lot of information, which teslamate collects, will be missing. E.g. teslamate records the positions during a drive. With this data, we will have only start and end of a drive... Not sure, whether it is worth ist... |
Beta Was this translation helpful? Give feedback.
-
|
The Tessie devs must be listening. They have changed the available export options. The files I sent you are no longer available. They now just have an export all function that exports all data. The new data includes files that report on the states. Seemingly this state data is what you're referring to (recording the position during the drive). Apologies for the work you have done with the old exports. Hopefully this data positions you better for a more comprehensive data migration. I have uploaded the new files to your dropbox as a zip. Really appreciate your work on this! |
Beta Was this translation helpful? Give feedback.
-
|
Hmmm, that data is not usable. No way to get the necessary informations for charges and drives out os that. (At least no obvious...) Can't the Tessi guys provide a teslamate export? I attach the ER model, which should help with that. |
Beta Was this translation helpful? Give feedback.
-
|
I would not expect support from Tessie on getting the data our of their systems and into TeslaMate. The other way around is supported by them (https://help.tessie.com/article/70-import-from-teslamate) since they would like people to start using Tessie and stop with TeslaMate, not the other way around. |
Beta Was this translation helpful? Give feedback.
-
|
I understand that Tessie does not offer any export, it is up to us to work. And when I see what they export, I confirm that Teslamate is much more complete in terms of data!! To import third-party data, I base myself on the format required for TeslaFi import. So I have prepared a CSVFiddle to show how we can transform the CSV files provided by Tessie with an SQL query that will generate a "TeslaFi" type file. |
Beta Was this translation helpful? Give feedback.
-
|
I made a grinder to compile the Tessie files and create a CSV import file compatible with Teslamate. It is based on the TeslaFi format. It is available here if you want to try: https://www.myteslamate.com/tessie-to-teslamate/ The data imports correctly, I've seen drives but I have not yet verified the completeness. You can see the BigQuery query that creates the final file here |
Beta Was this translation helpful? Give feedback.
-
|
Just gave it a try. Receiving this error |
Beta Was this translation helpful? Give feedback.
-
|
Can you send me a wetransfer link of your Tessie export in the chat? |
Beta Was this translation helpful? Give feedback.
-
|
@giterdone509 Fixed |
Beta Was this translation helpful? Give feedback.
-
|
Amazing! I will give it a try.
On Oct 8, 2024, at 10:50, jlestel ***@***.***> wrote:
I made a grinder to compile the Tessie files and create a CSV import file compatible with Teslamate. It is based on the TeslaFi format.
It is available here if you want to try: https://www.myteslamate.com/tessie-to-teslamate/
The data imports correctly, I've seen drives but I have not yet verified the completeness.
You can see the BigQuery query that creates the final file here<https://github.com/MyTeslaMate/tessie-to-teslamate-import/blob/master/bigquery.sql>
—
Reply to this email directly, view it on GitHub<#4112 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BKHZAWZRCKYNWQVPNZJ2KFDZ2PWKDAVCNFSM6AAAAABLZUD6OSVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTAOBYGEZTIMY>.
You are receiving this because you were mentioned.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
Former Tessie user. I would love a feature to migrate my old Tessie data to TeslaMate. Tessie has a function to export data to a csv for import to TeslaFi.
Beta Was this translation helpful? Give feedback.
All reactions