Import ACar Data Into Gas Cubby

[therza2169]

Is there anyway to import Acar data into Gas Buddy? I'm a pro user on both. I don't mind exporting to CSV and then importing if that works.

[RobertV]

Gas Cubby does not currently have an import function.
If you can hang tight a little longer, both will have sync to Fuelly which will achieve your intended result.

[therza2169]

Originally Posted by RobertV

Gas Cubby does not currently have an import function.
If you can hang tight a little longer, both will have sync to Fuelly which will achieve your intended result.

Do you have an ETA on that? I'm mainly just worried about my service records as my Android decided to self erase itself yesterday and wipe out all my fill up date since June .

[RobertV]

Originally Posted by therza2169

Do you have an ETA on that? I'm mainly just worried about my service records as my Android decided to self erase itself yesterday and wipe out all my fill up date since June .

I hoping just a couple of months. Right now we're laser focused on getting Gas Cubby (iOS) ready to launch with sync to Fuelly. After that is release we can focus our attention on pushing out aCar's beta release.

[therza2169]

Originally Posted by RobertV

I hoping just a couple of months. Right now we're laser focused on getting Gas Cubby (iOS) ready to launch with sync to Fuelly. After that is release we can focus our attention on pushing out aCar's beta release.

Robert, I have taken the SQL Lite database and modified it using one of my backups from when I switched from Gas Cubby to ACar a while back. Everything came across great except for the dates. From the looks of it you are using a base date and adding minutes to it to get the float value for the date field. Can you let me know what your base date is, and if you have the formula to covert it that would be even better. Sorry for the odd request lol.

[RobertV]

Originally Posted by therza2169

Robert, I have taken the SQL Lite database and modified it using one of my backups from when I switched from Gas Cubby to ACar a while back. Everything came across great except for the dates. From the looks of it you are using a base date and adding minutes to it to get the float value for the date field. Can you let me know what your base date is, and if you have the formula to covert it that would be even better. Sorry for the odd request lol.

From what I've read/been told-

"Apple documentation states that iOS data/time values are stored as a time value relative to an absolute reference date-the first instant of 1 January 2001."

Timestamp column in iOS SQLite database | Remko Weijnen's Blog (Remko's Blog)

As for a specific formula... that's above my understanding... so I'll have to get back to you on that.

[therza2169]

Originally Posted by RobertV

From what I've read/been told-

Timestamp column in iOS SQLite database | Remko Weijnen's Blog (Remko's Blog)

As for a specific formula... that's above my understanding... so I'll have to get back to you on that.

Thank you Robert for that. I checked it, and you guys are using 1/1/1970 for the base date, and adding the seconds since then. I will modify the tables again tonight. Thanks!

[KenRudd]

I am in the same boat, prior ACAR user with lots of data history, switched to iOS/Gas Cubby and would like to get the Data Over!

[therza2169]

If you can pull a backup of the SQLLITE database from Gas Cubby, and have an export from aCar you can marry the data together, just takes some trial and error.

[jodfie]

Originally Posted by therza2169

If you can pull a backup of the SQLLITE database from Gas Cubby, and have an export from aCar you can marry the data together, just takes some trial and error.

can you elaborate a little more on this process?