import fail - Page 3 - Fuelly Forums

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

Reply
 
Thread Tools Display Modes
 
Old 09-03-2015, 10:10 AM   #21
Registered Member
 
RobertV's Avatar
 
Join Date: Feb 2013
Posts: 1,900
Country: United States
Location: San Antonio, TX
Quote:
Originally Posted by snowfree52 View Post
It's the peugeot, and it's configured for odometer tracking.
Can you link or email me the CSV for review?
__________________

RobertV is offline   Reply With Quote
Old 09-08-2015, 03:32 AM   #22
Registered Member
 
Join Date: Aug 2015
Posts: 14
Country: France
Location: avignon
yes sure :

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

snowfree52 is offline   Reply With Quote
Old 09-08-2015, 07:50 AM   #23
Registered Member
 
RobertV's Avatar
 
Join Date: Feb 2013
Posts: 1,900
Country: United States
Location: San Antonio, TX
Quote:
Originally Posted by snowfree52 View Post
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!
RobertV is offline   Reply With Quote
Old 09-08-2015, 08:09 AM   #24
Registered Member
 
Join Date: Aug 2015
Posts: 14
Country: France
Location: avignon
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 is offline   Reply With Quote
Old 09-18-2015, 01:13 AM   #25
Registered Member
 
Join Date: Aug 2015
Posts: 14
Country: France
Location: avignon
did you have the time to have a look ?
snowfree52 is offline   Reply With Quote
Old 10-01-2015, 03:05 PM   #26
Registered Member
 
Join Date: Oct 2015
Posts: 1
Country: United States
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
EatinPonies is offline   Reply With Quote
Old 10-08-2015, 01:40 PM   #27
Registered Member
 
Join Date: Jun 2015
Posts: 4
Country: Norway
Lightbulb

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....
Ratata is offline   Reply With Quote
Old 10-08-2015, 02:44 PM   #28
Registered Member
 
RobertV's Avatar
 
Join Date: Feb 2013
Posts: 1,900
Country: United States
Location: San Antonio, TX
^Cheers and thanks!
__________________

RobertV 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 08:46 PM.


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