Appleworks database conversion/application

Discussion in 'Mac Apps and Mac App Store' started by desertman, Jul 29, 2016.

  1. desertman macrumors 6502a

    Joined:
    Jul 14, 2008
    Location:
    Arizona, USA
    #1
    Is there any application that can open or convert old Appleworks database files?

    Even a paid service that can convert such a database to, let's say, a working LibreOffice database would be ok.
     
  2. Phil in ocala macrumors 6502a

    Phil in ocala

    Joined:
    Jul 14, 2016
  3. sracer, Jul 29, 2016
    Last edited: Jul 29, 2016

    sracer macrumors 603

    sracer

    Joined:
    Apr 9, 2010
    Location:
    Land of Bongos and Beatniks
    #3
    I believe that the latest version of LibreOffice an open AppleWorks/ClarisWorks files.

    edit: I just tried to open a few .cwk database files in LibreOffice. It did open them but the custom forms were not imported. Just the data... into a spreadsheet.
     
  4. desertman thread starter macrumors 6502a

    Joined:
    Jul 14, 2008
    Location:
    Arizona, USA
    #4
    Thanks. Good to know.
    (I'm from "around the corner" in Sedona, although right now in Brazil.)
     
  5. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #5
    Wow, that's amazing. I cannot believe after all these years a current application maintains such legacy code to help a very small subset of users - I'm impressed.
     
  6. desertman thread starter macrumors 6502a

    Joined:
    Jul 14, 2008
    Location:
    Arizona, USA
    #6
    As far as I understand it is possible to open an Appleworks database file with LibreOffice - but it opens as a spreadsheet. The data is there but all layouts and all relations (or whatever this is called) are gone - the database layout has to be reprogrammed.

    I'm wondering whether it is possible to install OS X 10.6 in a virtual machine on a Mac with OS X 10.11. Anybody having any experience with that?
     
  7. Fishrrman macrumors G4

    Fishrrman

    Joined:
    Feb 20, 2009
    #7
    desertman asked:
    "I'm wondering whether it is possible to install OS X 10.6 in a virtual machine on a Mac with OS X 10.11. Anybody having any experience with that?"

    I haven't done it, but the following works:
    1. Install a virtual machine app, such as Fusion or Parallels.
    2. Install a copy of Snow Leopard Server (you MUST use the server version, regular 10.6 won't run via emulation).
    3. Turn off server features and just run it as a "regular copy" of the OS.

    This method will run 10.6 fine, I hear.

    Aside:
    Unless you really, really need to manipulate data within these old database files, easiest thing to do is use LibreOffice as mentioned above.
    Then either view the data in spreadsheet form, or import it into a "modern" database app...
     
  8. jlc1978 macrumors 68000

    jlc1978

    Joined:
    Aug 14, 2009
    #8
    Wasn't Appleworks a flat file database? If so, the spreadsheet output could be imported into a new application, such as Filemaker.
    if the spreadsheet doesn't work yo could try finding an image of the old Appleworks for Windows and run it under Wine and see if it will open the database and then convert it.
     
  9. sracer macrumors 603

    sracer

    Joined:
    Apr 9, 2010
    Location:
    Land of Bongos and Beatniks
    #9
    Correct. AppleWorks database is a flatfile database.
    I have AppleWorks 5 and 6 for Windows (along with every version of ClarisWorks for Windows). I was huge fan of that app and it is the primary reason why I switched over to Macs.

    I have Appleworks 6 running under WINE (self-contained executable, Wineskin) It runs but can't open database files. I haven't had time to tinker around with the various WINETRICKS that might get it to work.
     
  10. macfada macrumors newbie

    Joined:
    Mar 21, 2017

Share This Page