Clarisworks vs. Appleworks

My husband has been using a Mac computer for his personal business for about 10 years. He has been using ClarisWorks. I am trying to switch him over to a PC (due to the fact that he has increased questions about his Mac as it ages and I am not a Mac expert). My problem is in trying to take his processes from ClarisWorks to something compatable on a PC. He is not very excited about learning a whole new program, with new processes. Does anyone have any advise they can offer please?
Thank-you.

Mac OS 8.6 or Earlier, Clarisworks

Posted on Jan 7, 2008 4:30 PM

Reply
22 replies

Jan 7, 2008 5:15 PM in response to Amber W.

Hi Amber,

ClarisWorks can export word processing files in the then current version of MS Word for Windows format, and spreadsheets in the then current MS Excel format. You will likely experience problems translating embedded spreadsheet frames and Draw objects in CW word processing documents.

The data from CW database documents and spreadsheet documents can be exported as a tab-dlimited text file, which can be imported by most, if not all Windows database and spreadsheet applications. For those that cannot import tab delimited text, the file can be converted to CSV (comma separated values) text files. Depending which translators were supplied with the version of CW that he is using, database and spreadsheet docs may be exported to DBF or SYLK files respectively, preserving filed names and more of the formating.

Some versions of CW came with translators to save Paint documents in Windows' BMP format, GIF, or JPG formats, all of which cam be opened by one or more Windows applications.

Draw documents have no direct importers that I know of. These can be exported in the formats above, but doing so converts Draw's vector graphics to bitmap formats.

AppleWorks 5 and 6 came in Windows versions. The last Windows version, AW 6.2.2, was sold only through the Apple Store for Education, and was restricted to the education market.

An alternative, of course, is to get him a new Mac, install Appleworks 6.2.x on it, and continue with the processes with which he's familiar. AW 6.2.4 or AW 6.2.9 both work well under Leopard and Tiger versions of OS X. (6.2.4 is to be preferred until he has converted his files to AW 6 version, as AW 6.2.9 has difficulty opening many older CW files.)

Regards,
Barry

Jan 9, 2008 5:44 AM in response to Amber W.

Hello, Amber. Welcome to the discussions. I'd also suggest getting him a new mac. The apple store has some free introductory courses for new users (and he would be new to OS X, which is kind of an adjustment). Also, there's probably a local Mac Users Group in your area, and he could ask his questions of them instead of bothering you all the time. They also usually have a lot of advice/lessons for beginning OS X, and most of them are from very old versions of the Mac OS as well, so they would know exactly the things that might be troublesome to him at first.

Just going from Clarisworks to Word is going to keep you pretty busy, I'm afraid, if you get him a PC, aside from the other questions he'll have. It would be simpler to let him continue with Appleworks.

Jan 9, 2008 10:10 AM in response to Barry

Good morning Barry. Thank-you for the useful information. Our Mac specialist at the college I work for suggested Microsoft Works, as being compatible with ClarisWorks. I now have my son working on exporting the files off the Mac and onto the PC to see how they will work. My only concern is that in the ClarisWorks template he had created, it has a lot of macros and draws from 2 different data bases. So I am not sure how it will work, but I guess we will see.

There have been a few to suggest to keep him with a Mac, however I am not very Mac literate and he only does basic billing on his computer. He does not use his Mac for anything else, or his software as a normal accounting software would work. So since he has had so many questions with us both being somewhat frustrated in the end, that swayed the decision to go with a PC for his next computer. He has had this Mac for 10+ years. This is his second computer since the late 80's, and went with a Mac to begin with since they were the leaders at the time.

Just last night, he advised me that he was out of his printed payroll sheets. I asked him if he would like the form on his computer, with the Social Security, Medicare and Federal Tax rates to automatically calculate once he entered the wage. After a few puzzled looks, I sat down and did a simple Excel spreadsheet (and made it look very close to what he was writing out on carbonless paper) added some formulas, highlighted the fields in which he needed to input data, and the spreadsheet calculated the rest for him. He was pretty excited. So within the workbook, I created one sheet for each employee (only 4 of them). He now thinks he is pretty snazzy:)

Anyway, thanks for the info I greatly appreciate it. By the end of the weekend, I should know if this will work to convert over. I think we were looking at possibly importing the ClarisWorks files into Access.

Thanks again.
Amber

Jan 9, 2008 10:41 AM in response to Barry

Can I in turn ask for help?

I have files created in every version of CW/AW since 0.9 and am going through the tedious process of converting the dbs and wps with embedded spreadsheets in Classic/AW4 before moving them to my Intel iMac (no Classic of course) so I can get on with actually doing something with tem. Most tedious...

In the course of this I have realised that while many of the formats have sensible export forms (or rather Save as...) this does not apply to the db which only does other AW formats or text and none of them do tab or csv.

I was hoping to give them some sensible new life in Bento and given its common heritage you might think it possible. But no, the Bento manual says it only supports CSV and my exported text file is greyed out in the import window.

Any other ideas for what to do with a significant db in AW?

Cheers, Colin

Jan 9, 2008 11:28 AM in response to Colin Cohen

"the db...only does other AW formats or text and none of them do tab or csv.

Text produces a tab delimited text file. As Bento will not open this, you will need to convert it to CSV.

To convert to CSV, open the Text file in the AW word processor then use Find/Change to change all the tabs to commas. (See note below) Then Save the file (as Text, not as an AppleWorks file), adding the .csv extension to the file name.

Regards,
Barry

Note: Use "\t" in Find and "," in Change. Click Change All and OK the alert and the dialogue that follow.
If any of the actual data in your DB contains a comma, you will need to take action to keep that comma from being interpreted as a field separator when the data is imported.
One way is to use Find/Change to replace these commas with a character or string of characters not otherwise used in the DB (eg. "qqq"), then change the strings back to commas after making the transfer. Note that this change must be made BEFORE changing all the tabs to commas.
B

Jan 9, 2008 12:24 PM in response to Amber W.

After a few puzzled looks, I sat down and did a simple Excel spreadsheet (and made it look very close to what he was writing out on carbonless paper) added some formulas, highlighted the fields in which he needed to input data, and the spreadsheet calculated the rest for him


Just FWIW, he could have been doing this all along in clarisworks, too, although of course Excel allows far more complex formulas when needed.

Jan 9, 2008 1:00 PM in response to Barbara Brundage

Yes - I can see that there are a lot of people who are underwhelmed by it.

But I have several small and ancient databases that I created for a research project which are not big, but have valuable data that I had to transcribe from 17th century and earlier mss. I need to get them into some 21st century/Intel format and so that I can refer to them from time to time - Bento seemed the best solution as Apple have no offering and tho I have now have Numbers I'm not sure a spreadsheet is the way to go for what is essentially organised text [Descriptions/locations of properties, tenants, rents, etc].

Any other suggestions welcome...

Cheers, Colin

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Clarisworks vs. Appleworks

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.