#6 import Amiga database

v0.44
closed-fixed
5
2009-12-01
2009-10-27
JCV
No

Can't import an amiga database especially made for Gamebase. Whenever I try to launch jgamebase (last release), it checks for databases, found the new one and display a java error on a new window : "Access import failed", when it is still at the stage 1/3 "Exporting to csv files" (on another window).

Additionnaly, clicking "ok" to get rid of this window error displays "Select gamebase to load" window, but doesn't close "Exporting to csv files" window.

Running Ubuntu 9.04.

BTW, amiga database's named "Gamebase Amiga" and can be downloaded from http://gbamiga.elowar.com/GameBase%20Amiga%20v1.6%20Setup.exe (yeah, a strange exe file, but can be uncompressed using wine)

Discussion

  • F. Gerbig

    F. Gerbig - 2009-10-29

    Hi Psyko,

    if the import fails in step one, please check that the name of the database directory doesn't contain spaces.

    If the import fails later: there is a violation of a foreign key constraint in the extras of GameBase Amiga 1.6 (another hint that Access is not really a reliable database ;-).
    Unfortunately there is no ad hoc solution; I think I’ll have to revive the toolbox so that you can control the import step by step – then you could export the database, fix the offending csv-file and import it.
    This would still be a kludge - if you have a better idea please tell me :-)

    Kind regards,
    Frank.

     
  • F. Gerbig

    F. Gerbig - 2009-10-29
    • status: open --> open-accepted
     
  • JCV

    JCV - 2009-10-29

    Thanks for you help, Frank.

    What you suspected has happened.

    Database directory contained a space; I removed it, relaunched import, and passed first step.
    But... it failed at third step. Which means I would be grateful if you could resurrect that poor toolbox, which could help me a lot.

    I've no better idea, sadly!

    Jean-Claude

     
  • F. Gerbig

    F. Gerbig - 2009-11-02

    Hi Psyko,

    I just uploaded a new patch. Please try it and give me feedback.

    I rewrote the toolbox (start jGameBase with the parameter “toolbox”), but then it occurred to me that there could be a better way: I extended the import mechanism – if the import of a csv file fails then the import switches to an alternate import method. This alternate import method imports the inconsistent csv file line by line, so that only the inconsistent lines are skipped (but this takes some time).

    Kind regards,
    Frank.

     
  • F. Gerbig

    F. Gerbig - 2009-11-02
    • status: open-accepted --> pending-accepted
     
  • JCV

    JCV - 2009-11-02

    Great work, Frank! Import went smoothly, displayed an error message (I've been advised to post here :) and finished.

    Now I've to figure how to create a bash script to launch WinUAE, but that's another story :)

    Thanks for your work. I'm able to select, when starting jgamebase, between amiga and c64 databases; that's great !

     
  • F. Gerbig

    F. Gerbig - 2009-11-03

    Hi Psyko,

    Thanks for your positive feedback :-)

    If you write a script there are some points to consider:
    - Do you want to use uae or really WinUae (possibly through wine)?
    - This will help you start adf files, but whd files would need a different approach (much information is saved in the extra definition). For the windows version there is a tool called whdrun.exe - you would have to build something similar (which IMHO could better be done through a javascript-script or gamebase-plugin)
    - Some time in the (near/far?) future I plan to change from bash-scripts to javascript because of portability and maintainability (have a look at the bash script...)

    These points aside I appreciate the work you offer. Which solution you may choose - please remember to contribute it back so that others can benefit from your work.

    If you want to discuss possible approaches further, or have other ideas for jGameBase, please contact me directly via my sourceforge account.

    Kind regards,
    Frank.

     
  • F. Gerbig

    F. Gerbig - 2009-11-03
    • status: pending-accepted --> closed-accepted
     
  • F. Gerbig

    F. Gerbig - 2009-12-01
    • status: closed-accepted --> closed-fixed
     

Anonymous
Anonymous

Cancel  Add attachments