Leslie Bisno

Q: Accessing a Phonebook.cwk document without AW

Hi,

 

I'm revisiting an issue that came up a few years ago. I've got a new MacBook Pro. I need to access an old AW Phonebook (and name & address database); the suffix is ".cwk (DB)". I downloaded the Pages application, which opens my other AW documents, but it won't open the phonebook. Questions:

- How do I open the phonebook on my new Mac?

- How do I transfer its contents to Address Book?

 

Thank you!

MacBook Pro, Mac OS X (10.7.2)

Posted on Nov 23, 2011 3:31 PM

Close

Q: Accessing a Phonebook.cwk document without AW

  • All replies
  • Helpful answers

  • by Peggy,

    Peggy Peggy Nov 23, 2011 6:28 PM in response to Leslie Bisno
    Level 8 (38,954 points)
    Applications
    Nov 23, 2011 6:28 PM in response to Leslie Bisno

    There is nothing other than AppleWorks that can open AppleWorks databases. You'll need to find someone with a Mac & AppleWorks that can save/export the database as text. The text file would be tab-delimited text that can be imported into to Address Book as well as Pages or Numbers. Try a local Mac user group or elementary school.

     

    Peggy_sig.png

  • by Leslie Bisno,

    Leslie Bisno Leslie Bisno Nov 23, 2011 7:42 PM in response to Peggy
    Level 1 (140 points)
    Mac OS X
    Nov 23, 2011 7:42 PM in response to Peggy

    Thanks, Peggy -

     

    The database is on my older Macbook with AW. It gave me the option of saving it as ASCII Text. Will that work as you indicate?

     

    - Leslie

  • by Barry,

    Barry Barry Nov 23, 2011 11:52 PM in response to Leslie Bisno
    Level 7 (32,721 points)
    iWork
    Nov 23, 2011 11:52 PM in response to Leslie Bisno

    Hi Leslie,

     

    "The database is on my older Macbook with AW. It gave me the option of saving it as ASCII Text. Will that work as you indicate?"

     

    Yes. Saving as ASCII will produce a tab delimited text file.

     

    Regards,

    Barry

  • by Peggy,

    Peggy Peggy Nov 24, 2011 10:12 AM in response to Leslie Bisno
    Level 8 (38,954 points)
    Applications
    Nov 24, 2011 10:12 AM in response to Leslie Bisno

    Yes, that is how it's done. You will need to add the .txt extension to the file name as AppleWorks won't do it for you.

     

    Peggy_sig.png

  • by Leslie Bisno,

    Leslie Bisno Leslie Bisno Dec 31, 2011 10:41 PM in response to Peggy
    Level 1 (140 points)
    Mac OS X
    Dec 31, 2011 10:41 PM in response to Peggy

    Hi, Peggy and Barry -

     

    I finally have had a chance to try your instructions. I saved the AW phonebook as described above, added the .txt suffix, and then I opened it with TextEdit and with Pages - both produced the info, but in a very awkward format. I tried importing into Address Book, but got only a series of cards that said No Name and had no info. I emailed the ASCII file to myself and tried the same things on my new Mac, running OS 10.7.2, and got the same results. Is there a way to improve my results?

     

    Thanks so much for your help.

     

    - Leslie

  • by Roger Wilmut1,

    Roger Wilmut1 Roger Wilmut1 Jan 1, 2012 4:06 AM in response to Leslie Bisno
    Level 9 (78,576 points)
    iTunes
    Jan 1, 2012 4:06 AM in response to Leslie Bisno

    You can't import it into Address Book. You can import it into Numbers, where the data will appear in a rather unattractive tabular form but will at least be available: or you could get Bento ($49, free trial available) which is a simple database program, and import it into that. The import process into Bento is described here.

  • by Peggy,

    Peggy Peggy Jan 1, 2012 9:24 AM in response to Roger Wilmut1
    Level 8 (38,954 points)
    Applications
    Jan 1, 2012 9:24 AM in response to Roger Wilmut1

    You can import a tab-delimited text file with the .txt extension into Address Book. You can also import .csv files. First I tested it with a file I had saved years ago from AppleWorks. Then, because I didn't want my data to show in the screenshots, I created a simple two line file in Pages & exported it as plain text.

     

    Open Address Book & go to  File > Import & select your .txt file then click Import. You might have to rearrange the data though if it doesn't match the Address Book fields.

     

    Address Book import 1.png

     

    Address Book import 2.png

     

    Peggy_sig.png

  • by Leslie Bisno,

    Leslie Bisno Leslie Bisno Jan 2, 2012 2:02 PM in response to Roger Wilmut1
    Level 1 (140 points)
    Mac OS X
    Jan 2, 2012 2:02 PM in response to Roger Wilmut1

    Thank you, Roger -

     

    Before I shell out the $20 for Numbers... do you know whether the resulting data in tabular format be easier to dicypher than it is in Pages or TextEdit?

     

    Thanks for your help!

     

    - Leslie

  • by Leslie Bisno,

    Leslie Bisno Leslie Bisno Jan 2, 2012 2:07 PM in response to Peggy
    Level 1 (140 points)
    Mac OS X
    Jan 2, 2012 2:07 PM in response to Peggy

    Hi, Peggy -

     

    You said above: Open Address Book & go to  File > Import & select your .txt file then click Import. You might have to rearrange the data though if it doesn't match the Address Book fields.

     

    I tried that and got only a series of address cards that said "No name" or some such, with no data.

     

    You also said: You can also import .csv files. First I tested it with a file I had saved years ago from AppleWorks. Then, because I didn't want my data to show in the screenshots, I created a simple two line file in Pages & exported it as plain text.

     

    I'm afraid that's a bit Greek to me.

     

    What do you think of Roger's solution?

     

    Thanks for you help!

     

    - Leslie

  • by Roger Wilmut1,

    Roger Wilmut1 Roger Wilmut1 Jan 2, 2012 2:15 PM in response to Leslie Bisno
    Level 9 (78,576 points)
    iTunes
    Jan 2, 2012 2:15 PM in response to Leslie Bisno

    Leslie Bisno wrote:

    do you know whether the resulting data in tabular format be easier to dicypher than it is in Pages or TextEdit?

    Youi could get the information to display in Pages or TextEdit in Rich Text mode: you need to select all and adjust the tabs to get readable columns - you probably want to be in landscape mode. However if you have more than a handful of fields, or if any of them is long, it will get unmanageable very quickly, so a spreadsheet would be better.

     

    Open Office has a spreadsheeet and is free, so you could try it in that. It also has a database section but frankly it's a shambles and I would suggest avoiding it: Bento wouldbe easier to handle.

  • by Peggy,

    Peggy Peggy Jan 2, 2012 6:54 PM in response to Leslie Bisno
    Level 8 (38,954 points)
    Applications
    Jan 2, 2012 6:54 PM in response to Leslie Bisno

    As you can see in my second screenshot, I do get the names, so I don't know what is going on with your results.

     

    If Roger's idea works for you, go for it!,

     

    Peggy_sig.png