Prev: LW 12/640 PS + Asante FriendlyNet on Leopard?
Next: Strange audio problem with youtube and RealPlayer downloader
From: Melba's Jammin' on 28 Mar 2010 14:42
Snow Leopard OS 10.6.2
MacBook Pro

I have several databases on my iBook G4 (Tiger, 10.4.11) that were
created in AppleWorks 6.

I believe I can export them in a format that Bento3 can use. I haven't
tried it yet. Is there anything I should be especially mindful of?
Any tips, hints, recommendations, caveats?

Thanks.

--
Barb, Mother Superior, HOSSSPoJ
http://web.me.com/barbschaller
Angel Food Dessert, March 23, 2010
From: Steve Hix on 28 Mar 2010 22:06
In article <vilain-3F26EA.16373928032010(a)news.individual.net>,
Michael Vilain <vilain(a)NOspamcop.net> wrote:

> In article <barbschaller-EE4BE9.13413328032010(a)news.iphouse.com>,
> Melba's Jammin' <barbschaller(a)earthlink.net> wrote:
>
> > Snow Leopard OS 10.6.2
> > MacBook Pro
> >
> > I have several databases on my iBook G4 (Tiger, 10.4.11) that were
> > created in AppleWorks 6.
> >
> > I believe I can export them in a format that Bento3 can use. I haven't
> > tried it yet. Is there anything I should be especially mindful of?
> > Any tips, hints, recommendations, caveats?
> >
> > Thanks.
>
> AFAIK, you can export the AW database data to a "tab separated value"
> file which will require editing, then import the data into Bento.

Database documents can be exported in various Appleworks and Clarisworks
database formats, and as ASCII text. That's it.

IIRC, each field exports as a single line, empty ones as a blank.

If that's correct, you should be able to set up a Bento db form, and
import the text. As long as you didn't miss any fields in the AW file,
you'll be close. (I've done similar conversions, but a long time ago.)

> I don't think it can read the AW database file directly. So any forms or
> report layouts go away. According to
>
> http://www.filemaker.com/products/bento/?nav=products-bento
>
> it can import Excel and Numbers spreadsheets. There's no mention of
> Appleworks on that page. So, I think you're going to do that part by
> hand.

Among other options, you can export Appleworks spreadsheets in Excel 97,
2000 and XP 2002 formats. So that's covered.

> Looking over the Bento feature set, I am _not_ impressed. It does very
> little for the money.

It's a simple, minimal db program. They don't claim it's anything more.

If I were to go with a full-featured DBMS, I'd spend the bucks on
> Filemaker Pro.

Which makes sense; nobody's claiming Bento is anything close to being
full-featured. Enough for some modest use, no more.

> Still won't get Appleworks import. I think you're stuck
> with those databases as they are. I know, it sucks.

At least it'll export as plain ASCII. Save a whole lot of extra typing,
and you'd only have to do it once, assuming that once you're done, Bento
will do what's needed, which won't be a whole lot.
From: Eckard on 30 Mar 2010 18:03
On 28/03/10 20:42, Melba's Jammin' wrote:
> Snow Leopard OS 10.6.2
> MacBook Pro
>
> I have several databases on my iBook G4 (Tiger, 10.4.11) that were
> created in AppleWorks 6.
>
> I believe I can export them in a format that Bento3 can use. I haven't
> tried it yet. Is there anything I should be especially mindful of?
> Any tips, hints, recommendations, caveats?
>
> Thanks.
>
AppleWorks 6 has been abandoned by Apple but you can still use it under
Snow Leopard, thanks to Rosetta. My AW 6.2.9 database works fine here on
an iMac Intel and OS 10.6.2
 | 
Pages: 1
Prev: LW 12/640 PS + Asante FriendlyNet on Leopard?
Next: Strange audio problem with youtube and RealPlayer downloader