Export to Fuelly.com
I purchased aCar yesterday, awesome program. I also purchased some gas, entered it into aCar and when I got home last night I tried an "export" so i can import into Fuelly.com.
That didn't go so well...I received a 500 error. I then looked at exported CSV and it is SO not in the format fuelly requires... Any work around? or am I missing something? Looking forward to syncing directly with fuelly. Thanks for all the hard work! Josh |
You have to manually edit the exported .csv from aCar to meet the guidelines from fuelly.com which are mentioned here: https://www.fuelly.com/csv-import
What I've tried (but I didn't succeed yet): - export all fillups from aCar to .csv format and store it on Dropbox - open the csv on my PC in Microsoft Excel - strip all unneccesary lines (Metadata, Vehicles, Service Records, Expense records, Trip records) - sort fill-ups by vehicle - copy all fill-ups from one vehicle to a new worksheet - juggle around with all collumns to meet the fuelly csv import guidelines - change collumn titles when necessary - rename all No's and Yes's in the Partial Fill-up collumn to 0 and 1 - remove useless collumns - add a collumn with title "km" (because I only have odometer readings) - check all formatting --> make sure there are no comma's or semicolons as decimal dividers or comments, change date format, currency format - save the worksheet to csv (DOS) - load the edited csv by clicking https://badges.fuelly.com/images/icon...w_columns2.png in the car detail page on fuelly.com So far I only got the error Quote:
|
So Fuelly.com owns aCar but the csv format that aCar produces can't be used by Fuelly.com without major editing? I think someone needs to pull their thumbs out... and get this sorted!?
|
Basically yes. They acquired aCar only recently, so maybe an update in aCar or the website will make this process a little easier in the future.
I've e-mailed my aCar csv to one of the developers so he could take a look at the format and try to simplify export from aCar to Fuelly.com |
After much editing I finally got to a format that Fuelly would accept, but it is ridiculous that aCar exports a format that Fuelly can't use and Fuelly can't accept a format that aCar exports!
This is what worked for me, I had to turn this: "Vehicle","Date","Time","Odometer Reading","Distance Unit","Volume","Volume Unit","Price per Unit","Total Cost","Payment","Partial Fill-Up?","Previously Missed Fill-Ups?","Fuel Efficiency","Fuel Efficiency Unit","Fuel Type","Has Fuel Additive?","Fuel Additive Name","Fuel Brand","Fueling Station Address","Latitude","Longitude","Driving Mode","City Driving Percentage","Highway Driving Percentage","Average Speed","Tags","Notes" "Renault ","30-04-2014","09:25 AM","134,417","km","46.850","L","R14.160","R663.40 ","Card","No","No","0.000","L/100","Gasoline - Premium (93)","No","","","","-26.149746","28.134921","Normal","50","50","","","" into this Fuelup_Date,Odometer,km,Litres,,Price 30-04-2014,134417,km,46.85,L,14.160 (The double comma on the first line is important.) |
In my first reply in this topic I mentioned I got an error regarding the odometer setting. Looks like the order of columns is not so important, but I don't see what would go wrong in my csv. I got this:
Quote:
Too bad I just finished manually typing over all my fillups by hand :( |
It seems "km" must be in the headings and can be in the data as ,km, or just ,,
I've been using PSPad (fancy notepad) and it's search & replace function to fix many of the errors |
I followed your format for another car I've owned in the past and of which I had fuelups stored on spritmonitor.de. This is an example of the csv after editing:
Quote:
|
Cool, I really hope they're going to sort this out soon, it's a real pain to have to do so much editing.
|
I agree. Importing the fuelups from spritmonitor was a lot easier than those of aCar, but I really liked all features in aCar. Most of them get lost when you import the fillups with the layout we used now. Lets hope those features will be added again in the future :)
|
Sorry for the delay, just to follow up, I reviewed the CSV file that was sent to me and even test-uploaded it without any issue on my end.
I have the team trying to track down why it's not going smoothly on your end. Will report back as soon as we have an answer. Thank you for your patience! |
No worries, I suppose this isn't your day job, so time can be a ***** :).
As I replied on the previous page, I managed to import it myself too. The things I changed compared to the csv file I sent you is adding a collumn "km" and filling it with the word "km" on every line, and adding a blank collumn before "price", based on the tips of Ubejani. I don't know which one did the trick, but the combination seems to work anyway. When I look at the example-csv, neither is there, so I'm still not sure why it worked now, but it did. Could the formatting be an issue? I saved as csv from Excel. I tried CSV (Comma delimited) and CSV (DOS), but neither worked at first. Also when I edited with Notepad++ and saved it didn't work. I'm not sure if encoding was ANSI or UTF8, or if that is even an issue with csv files. |
Quote:
|
@freddie: yeah I realised that at some point, so I changed all numbers which contained , to . (before also 58.1 l was 58,1 l etc.. I might have missed some commas....
The exported file looks a bit like this: Quote:
Apparantly something I did was the right trigger, because I succeeded eventually to import my exports (see my previous post in this topic). After this worked, I reformatted the exports from spritmonitor.de following the same logic, and that worked too. In both cases, I didn't use the notes field so I don't know if the , in my previous csv would have been an issue or not. |
To much to do just to import wow
|
Long time aCar user and will one day be a contributing member of these site when I can upload all more old data without any work.
|
I'm with Crf450r420. I look to computers (and that computer called a phone) to be labor savers. Let me know when my aCar app will work with Fuelly without a degree in computer science and the time it takes to apply it.
|
any news about the easy way to import from acar? tx
|
I'm just going to wait for FUELLY and aCar to "be on the same page"
Fuelly is nice, but I LOVE aCar! Can't wait until they...blend. |
Hope no one was holding their breath. Looks like we will be monitoring all electric cars before the app uploads to the site right.
|
No way I was able to load the data which are many, via CSV. Not with the example put. All that remains is to put one to one data.
|
Has the issue with syncing data to and from acar/fuely been resolved?
|
Mike, they're not working on aCar at the moment. They're working on the iOS app first to get it up to par (apparently it was a wreck of a software package?) and then they'll work on aCar.
Myself, I'm going to write a web app that'll do the conversion. I'll release it, make the source code publicly available, and usable. I've got the weekend to do this, and this smells like just a few hours worth of work. I just need to find a cheap web host since I don't want thousands of you people hitting my home server. ;) |
still waiting
|
Still waiting...
Those electric cars are here... |
Quote:
Could make adding important details easier, such as noting when I'm towing so my fuel mileage doesn't suck, just doing more work per mile. If the Ford and Toyota members don't tow and the Chevy and Ram guys do it would look like those don't don't get good mileage as the site has no way to show the difference. :( |
I also wonder is this option ever going to be fixed. I bought aCar app, and migration to Fuelly might be a interesting solution. But I do not understand why do they do not make this migration easy...
Shame... |
We are in the early testing phase of aCar 5.0. This version will be able to sync to Fuelly. It will also be able to sync with a family member using Gas Cubby.
This will also make switching to/from iOS and Android very easy for users to accomplish. The user will simply have to login to Fuelly and the data will sync with the app on their device. |
All times are GMT -8. The time now is 10:04 PM. |
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.