Menu

#112 Import/export has troubles....

open
None
5
2007-02-26
2006-01-13
Alan Hoyle
No

I've tried this on 0.03.02, 0.03.06, and 0.02.07.

I'd been having lots of trouble with the maintanence
features crashing with null-pointer exceptions, so I
attempted to recreate the information by exporting to
the memopad and re-importing.

I had been using miles and USG for my units, and the
export file contains my data as input. However, if I
try to import back into pFuel, I get problems.

No matter what I set, I lose the date and category
information.

Simple examples follow:

Original data: 14.50 USG, 531 Miles, $0, can't remember
date, Jetta

How it looks in the export: (had been using USG and
miles)

37009,"14.50","531",0.0,Y,Jetta

Prefs: imported values
Km/L: Unfiled, 1-1-84,14.50 L, 531 Km
Km/G: Unfiled, 1-1-84, 3.19 G, 531 Km
Km/U: Unfiled, 1-1-84, 3.83 U, 531 Km
Mi/L: Unfiled, 1-1-84, 3.19 L, 205 Mi
Mi/G: Unfiled, 1-1-84, 0.70 G, 205 Mi
Mi/U: Unfiled, 1-1-84, 0.84 U, 205 Mi

If the distance unit is set to miles, it does a DOUBLE
conversion.

Discussion

  • Remi Ricard

    Remi Ricard - 2006-01-16
    • status: open --> closed
     
  • Remi Ricard

    Remi Ricard - 2006-01-16

    Logged In: YES
    user_id=145206

    Hi Alan,

    When importing the value I was assuming the value to be in
    KM and converting it in the units of the preference.

    I should have been the other way around since internally
    pFuel use KM.

    I will be fixed in pFuel-0.03.07 and pFuel-0.02.08

    Remi

    P.S. Do you have more info on the crash in the maintenance ?

     
  • Remi Ricard

    Remi Ricard - 2006-01-16
    • assigned_to: nobody --> papadoc
    • status: closed --> closed-fixed
     
  • Alan Hoyle

    Alan Hoyle - 2006-01-16

    Logged In: YES
    user_id=186762

    I don't have much information on it. I could probably
    restore the databases to my Palm and re-create it.
    Basically, whenever I attempted to view one of my older
    Maintenance records, it would crash with the following error:

    MemoryMgr.c, Line 3632, NULL handle

    This happened if I attempted to view the record from either
    the Maintenance view, or when it popped up after recording a
    fill-up.

     
  • Alan Hoyle

    Alan Hoyle - 2006-01-18
    • status: closed-fixed --> open-fixed
     
  • Alan Hoyle

    Alan Hoyle - 2006-01-18

    Logged In: YES
    user_id=186762

    New release of 2.08 no longer does the double conversion on
    miles, but still does the double conversion from USG to
    Liters.

     
  • Alan Hoyle

    Alan Hoyle - 2006-01-18

    Logged In: YES
    user_id=186762

    Also, it still loses date data. most things import as

     
  • Alan Hoyle

    Alan Hoyle - 2006-01-18

    Logged In: YES
    user_id=186762

    "most things import as" ... being on 1-1-84.

     
  • Remi Ricard

    Remi Ricard - 2006-01-18

    Logged In: YES
    user_id=145206

    Hi,

    Sorry, not enough sleep. I will correct the volume conversion.

    I'm not able to loose the date can you tell me what is your
    date format (Ex: M-D-Y, Y-M-D, D/M/Y, ...)

    Remi

     
  • Alan Hoyle

    Alan Hoyle - 2006-01-18

    Logged In: YES
    user_id=186762

    My date format is d-m-y. I'm on a T|T3.

     
  • Remi Ricard

    Remi Ricard - 2006-01-19

    Logged In: YES
    user_id=145206

    Hi Alan,

    Can you check if you export and import with the same version.
    Since version 0.02.xx export/import the date as epoch and
    version 0.03.yy export/import the date as "D/M/Y" (or date
    format set in Palm OS pref).

    If I export with version 0.03.yy and import with 0.02.xx I
    will always get the same wrong date.

    Remi

     
  • Nobody/Anonymous

    Logged In: NO

    Fantastic program!!

    The preference date format for my Palm TX is D/M/Y.

    When I export to Memo, the date is 1462 days short.

    That is 20th February 2007, is translated as 19th February 2003.

    I have just updated to PFuel 2.11.

    Michael
    (From Australia)

     
  • Remi Ricard

    Remi Ricard - 2007-02-26
    • status: open-fixed --> open
     
  • Remi Ricard

    Remi Ricard - 2007-02-26

    Logged In: YES
    user_id=145206
    Originator: NO

    Hi,

    I think I found the problem. The import function was using the odometer unit flag
    to find the unit for the fuel volume ???? So when the distance unit was not the default (i.e. Km) strange conversion was done on the volume.

    To confirm that this was the problem can you attach the pdb files. This will help me for the maintenance problem.

    Do a backup/hotsync and send me everything related to the pFuel
    You should have:
    pFuelDB.pdb
    pFuelMtnDB.pdb
    pFuelPrefDB.pdb

    The value:
    37009,"14.50","531",0.0,Y,Jetta
    Does not look like the output of a recent version of pFuel

    Remi

     
  • Remi Ricard

    Remi Ricard - 2007-02-26

    Logged In: YES
    user_id=145206
    Originator: NO

    Hi Michael,

    I tried to replicate your problem with 2.11 and I don't have any problem.

    Can you tell me what you get in the export file.
    I have for a date of 20/02/2007
    Epoch,FuelVolume,Odometer,Price,Full,Category
    37671,"17.41","531","0.00",Y,Jetta

    Can you send me you database and also tell me all your preference.

    Remi
    P.S. Have a nice summer. Here is was a little bit cold this morning -9 C

     

Log in to post a comment.