File import issue - Fuelly Forums

Click here to see important news regarding the aCar App

Reply
 
Thread Tools Display Modes
 
Old 07-14-2009, 12:05 PM   #1
Junior Member
 
Join Date: Mar 2009
Posts: 9
Country: United States
File import issue

I am having some issues with a csv file I uploaded, it seems to have dropped April and Mays fill up and well, its also seems to not be once again calculating fill or listing fills in correct order.

Is there a way to delete an imported file ?
__________________

RobAGD is offline   Reply With Quote
Old 07-14-2009, 12:26 PM   #2
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
No there isn't a way to delete imports, but you can: 1.) delete your existing car, 2.) create a new car, 3.) try your import again.
__________________

pb is offline   Reply With Quote
Old 07-14-2009, 12:31 PM   #3
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
yeah, looks like your April fills are off. I took a look at all fuel ups and on April 20 your odometer said 88221, and then on April 21 it said 87811, so there are probably some fuel-up dates transposed along the line. If you fix those up and re-import you should be set.
pb is offline   Reply With Quote
Old 07-15-2009, 10:07 AM   #4
Junior Member
 
Join Date: Mar 2009
Posts: 9
Country: United States
ok the april booboo was a 12 vs 21 in the date.

Now looking at some other weird ness

May 22 and June 6th I belive

I have complete fills 1 with 0 mpg and 1 with 1.9

Also a partial fill is listed above ( later ) than another fill in the same day, Why wouldnt the system sort fill on teh same day by the miles ?

-R
RobAGD is offline   Reply With Quote
Old 07-15-2009, 01:47 PM   #5
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
Why wouldnt the system sort fill on teh same day by the miles ?

It should, so I'm not sure why you had the glitch with that day. It could have been a problem with the import process and having fuel-ups recorded at exactly the same time on the same day. I recalculated your mileage manually on this end and it looks like things are lining up better on those problem days now.
pb is offline   Reply With Quote
Old 07-18-2009, 09:36 PM   #6
Junior Member
 
Join Date: Mar 2009
Posts: 9
Country: United States
Thanks, when I get back into town I'll noodle through the list again and see if anything else is skewed.

-R
RobAGD is offline   Reply With Quote
Old 07-23-2009, 06:43 AM   #7
Junior Member
 
Join Date: Mar 2009
Posts: 9
Country: United States
OK I am still seeing some issues with fill ups in May.

starting 4/27 to 5/31 everything mileage wise looks correct to me and is in correct order BUT I have 3 complete fills with no calculated mpg.

Something in how your system handles partial fills is angry or something.

R
RobAGD is offline   Reply With Quote
Old 07-24-2009, 04:05 AM   #8
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
heh, nothing is angry. When you mark a fill as partial, Fuelly skips calculating the MPG for that tank and the next one. Fuelly needs a baseline full tank to start calculating MPG for individual fuel-ups again. But all of fuel-up data goes into calculating the average MPG of the vehicle, so it's still worthwhile to include partials.

There's a little more info in the FAQ: How do I account for partial fuel-ups?
pb is offline   Reply With Quote
Old 07-24-2009, 08:08 AM   #9
Junior Member
 
Join Date: Mar 2009
Posts: 9
Country: United States
Ok, there is the problem then, there is no reason to skip the calc.

If I burn through say a tank and go 400 miles on 18 gallons

how is that any differnt than if I go 1200 miles on 60 gallons ?

As long as you dont SKIP a fill there is no reason to not calc the mileage. It run look back at the DB and add the total gallons and miles up and bingo.

And somethinge lse thats a bit weird the same mileage that I uploaded here figured out to a differnt mpg than my excel sheets did.

Thanks

-R
RobAGD is offline   Reply With Quote
Old 07-24-2009, 11:07 AM   #10
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
This answer in the FAQ might answer your question: Why do I have to fill the tank all the way up every time I buy fuel?
__________________

pb 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


» Fuelly iOS Apps
Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 06:04 AM.


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