import fail

[RobertV]

Originally Posted by snowfree52

It's the peugeot, and it's configured for odometer tracking.

Can you link or email me the CSV for review?

[snowfree52]

yes sure :

https://dl.dropboxusercontent.com/u/...xample-csv.csv

[RobertV]

Originally Posted by snowfree52

yes sure :

https://dl.dropboxusercontent.com/u/...xample-csv.csv

How did you do the conversion? Because I show 2 columns when there shouldn't be. (When opening in Excel). Looks like your file is using the semi-colon as the comma separator.

Do you have a CSV of your actual fillup data to try and import? I can help with that!

[snowfree52]

I used the conversion utility in excel.
This is what I see when I open it with excel, what do you see ? :



I edited ony one file to import for the moment, this one :

https://dl.dropboxusercontent.com/u/...ingsfuelly.csv

[snowfree52]

did you have the time to have a look ?

[EatinPonies]

Hi... (not to hijack this post, but...) where do I go to actually import the csv? I think the directions in the FAQ are incorrect...

EDIT: FOUND IT! Never mind... Carry on... lol

[Ratata]

My How to:
I got non-english Excel, and do as following (and it works):
-Put my data in to Excel in each cells, like this.
(PS: Price in NOK = norwegian krones)

(I save the first line of data from earlier, so I have something to work after.)

odometer,litres,price,fuelup_date,partial_fuelup,m issed_fuelup,notes
123456,50.24,14.58,2013-11-12,1,0,
216584 17,42 13,72 2014-05-04 0
216794 15,15 15,47 2014-05-15 0
216931 41,14 13,97 2014-05-19 0
217314 10,00 15,53 2014-05-27 0
217376 47,44 13,59 2014-06-02 1
217819 10,61 14,39 2014-06-14 0

Then Save as CSV3.
Open File explorer, right-click on this file, choose Edit.
File opens in Notepad, and it look like this:

odometer,litres,price,fuelup_date,partial_fuelup,m issed_fuelup,notes;;;;;
123456,50.24,14.58,2013-11-12,1,0,;;;;;
216584;17,42;13,72;2014-05-04;0;
216794;15,15;15,47;2014-05-15;0;
216931;41,14;13,97;2014-05-19;0;
217314;10,00;15,53;2014-05-27;0;
217376;47,44;13,59;2014-06-02;1;
217819;10,61;14,39;2014-06-14;0;

Do some corrections, and I got my fuel-ups ready to import. Remember to Save.
Changes:
; to ,
, to .
add at end of line 0,;;;;

odometer,litres,price,fuelup_date,partial_fuelup,m issed_fuelup,notes;;;;
216584,17.42,13.72,2014-05-04,0,0,Estimert kilometer;;;;
216794,15.15,15.47,2014-05-15,0,0,;;;;
216931,41.14,13.97,2014-05-19,0,0,;;;;
217314,10.00,15.53,2014-05-27,0,0,;;;;
217376,47.44,13.59,2014-06-02,1,0,;;;;
217819,10.61,14.39,2014-06-14,0,0,;;;;



May this help someone....

[RobertV]

^Cheers and thanks!

[Hasaf]

I realize that this thread is nine years old. That said, is there a solution?

I am still getting, "Error Your car has odometer tracking set, but no odometer heading in your CSV file." when I try to import.

The example file looks like this:
odometer, gallons, price, fuelup_date, city_percentage, tags, notes, missed_fuelup, partial_fuelup, brand

32394.0,7.5,4.199,2008-07-17,80,"test tag list","Lorem ipsum dolor sit amet.",0,0,"Shell"

My File looks like this (spaces added after the commas for formatting purposes):
odometer, gallons, price, fuelup_date, city_percentage, tags, notes, missed_fuelup, partial_fuelup, brand
85,3.938,19.37,6/18/2022,,,,0,0,DILLONS FUEL CENTER