Fuelly Forums - Fixed: CSV export column names mismatched

Fuelly Forums (https://www.fuelly.com/forums/)

- Fuelly Web Support and Community News (https://www.fuelly.com/forums/f2/)

- - Fixed: CSV export column names mismatched (https://www.fuelly.com/forums/f2/csv-export-column-names-mismatched-16411.html)

CSV export column names mismatched

As the title says.
The CSV export I just downloaded has the following column names in this order:
"car_name, model, l/100km, odometer, km, litres, price, city_percentage, fuelup_date, date_added, tags, notes, missed_fuelup, partial_fuelup, latitude, longitude"
The data following is clearly mismatched: the first two columns, "car_name" and "model", appear correct, but the following ones are clearly misplaced and it is not entirely clear by a quick look which goes where.

Regards,
Dimitri

Hi Dmitri,

I am not seeing a problem with the exported file. Here is an example of the first three lines of your exported file, can you point out the problem? The l/100km is 0 because of your partial fuelups. The export appears to match your fuelup log.

Code:

car_name, model, l/100km,  odometer, km, litres, price, city_percentage, fuelup_date, date_added, tags, notes, missed_fuelup, partial_fuelup, latitude, longitude

"Renault Laguna 2.2dT","Renault Laguna",0.00,200124.0,22.00,5.35,2.560,100,2014-06-22,2014-06-22 13:12:58,"eko","After Mramor, this time really to pped up",0,0,,

"Renault Laguna 2.2dT","Renault Laguna",0.00,200102.0,82.99,57.54,2.550,100,2014-06-22,2014-06-22 09:15:21,"eko","Еко вапцаров, тръгвам за преглед в мрамор, спира зареждане непълен резервоар",0,1,,

"Renault Laguna 2.2dT","Renault Laguna",0.00,200019.0,77.01,7.84,2.550,100,2014-06-19,2014-06-19 12:53:33,"eko","Eko on Константин величков",0,1,,

Now I see it from your post - the file I get has comma instead of a dot as a decimal separator and the fractional values are not in quotes, which is causing the whole problem. Is this a setting I can change?

Oh, the comma as a decimal separator, I see the issue clearly now. I will work on fixing it today.

Give it a try now. The decimal separator will now always be a dot.

I checked it out, the problem is solved now, thanks.