Import ACar Data Into Gas Cubby - Fuelly Forums

Android Users - Coming Soon! - Migrating from aCar 4.8 to 5.0

Reply
 
Thread Tools Display Modes
 
Old 10-08-2015, 07:31 PM   #1
Registered Member
 
Join Date: Dec 2012
Posts: 10
Country: United States
Import ACar Data Into Gas Cubby

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.
__________________

therza2169 is offline   Reply With Quote
Old 10-08-2015, 09:21 PM   #2
Registered Member
 
RobertV's Avatar
 
Join Date: Feb 2013
Posts: 1,900
Country: United States
Location: San Antonio, TX
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.
__________________

RobertV is offline   Reply With Quote
Old 10-09-2015, 08:53 AM   #3
Registered Member
 
Join Date: Dec 2012
Posts: 10
Country: United States
Quote:
Originally Posted by RobertV View Post
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 .
therza2169 is offline   Reply With Quote
Old 10-09-2015, 11:55 AM   #4
Registered Member
 
RobertV's Avatar
 
Join Date: Feb 2013
Posts: 1,900
Country: United States
Location: San Antonio, TX
Quote:
Originally Posted by therza2169 View Post
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.
RobertV is offline   Reply With Quote
Old 10-15-2015, 07:23 PM   #5
Registered Member
 
Join Date: Dec 2012
Posts: 10
Country: United States
Quote:
Originally Posted by RobertV View Post
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.
therza2169 is offline   Reply With Quote
Old 10-15-2015, 08:51 PM   #6
Registered Member
 
RobertV's Avatar
 
Join Date: Feb 2013
Posts: 1,900
Country: United States
Location: San Antonio, TX
Quote:
Originally Posted by therza2169 View Post
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-
Quote:
"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.
RobertV is offline   Reply With Quote
Old 10-16-2015, 11:50 AM   #7
Registered Member
 
Join Date: Dec 2012
Posts: 10
Country: United States
Quote:
Originally Posted by RobertV View Post
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!
therza2169 is offline   Reply With Quote
Old 12-18-2015, 06:56 AM   #8
Registered Member
 
Join Date: Dec 2015
Posts: 1
Country: United States
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!
KenRudd is offline   Reply With Quote
Old 12-18-2015, 07:18 AM   #9
Registered Member
 
Join Date: Dec 2012
Posts: 10
Country: United States
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.
therza2169 is offline   Reply With Quote
Old 01-11-2016, 02:05 PM   #10
Registered Member
 
Join Date: Dec 2014
Posts: 1
Country: United States
Location: Savannah,Ga
Quote:
Originally Posted by therza2169 View Post
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?
__________________

jodfie is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 05:21 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.