5/29/2013

[macsupport] Digest Number 9565

3 New Messages

Digest #9565
1a
Re: Database program for OS-X by "Peter Gold" idmacguy
1b
Re: Database program for OS-X by "T Hopkins" todhop
2
4 Keys at one time? by "Jim" jimpurcell2001

Messages

Wed May 29, 2013 9:30 am (PDT) . Posted by:

"Peter Gold" idmacguy

Good suggestion, Randy. If the original poster's existing data is in
relational or linked files, then this tool would likely be worth its price
in for the time it saves in converting, and for converting data accurately.
If the existing files are not relational, or not linked - also known as
"flat" files - then it's likely that exporting or saving them in a standard
format that preserves records and fields, would be sufficient for any
database tool to import for its own use.

Posted by: "Randy B. Singer" randy@macattorney.com Date: Tue May 28, 2013
> 11:07 am ((PDT))

On May 27, 2013, at 8:13 AM, RLN37 wrote:
>
> > have used in Windows, however, that I cannot easily give up. It is a
> database program called Foxbase.
>
> Just FYI, you can migrate your data from Foxbase to Filemaker Pro using:
>
> FMPro Migrator
> http://www.fmpromigrator.com/products/fmpro_migrator/index.html
>

John's suggestion applies to any database that can be queried from a
command line. The original poster's tasks would be to convert Fox's
commands to the given database's language, for use at the command line, and
to convert Fox's programs into the form that the database needs.

__________________________________________________________

> Posted by: "John Masters" johnmasters@me.com joemastersk
> Date: Tue May 28, 2013 12:05 pm ((PDT))

> PostgreSQL is the default database in OS X Server so if you have that
> installed you already have a very powerful database that can be queried
> from the command line. If you want to make it a little easier then try this:
> http://postgresapp.com
> It has been a few years since I last used PostgreSQL and I have not tried
> the above app.
> John Masters
> johnmasters@me.com

HTH

Regards,

Peter
_______________________
Peter Gold
KnowHow ProServices

[Non-text portions of this message have been removed]

Wed May 29, 2013 12:30 pm (PDT) . Posted by:

"T Hopkins" todhop

Well, to put a fine point on it, Filemaker is high-level database language and environment capable of building and working with "relational" databases. But relational databases are composed of multiple "flat files" (actually "tables") between which a relationship have been defined. If you don't a relationship, it's just a "flat-file."

Filemaker is the application, not the "database"; itself. It's picky, but the difference is import to understand. One might say a relational database is to a flat-file, what an html page is to a simple text document. I can build both with TextEdit, but they function differently.

Cheers,
tod

On May 27, 2013, at 11:45 PM, Jurgen Richter wrote:

> Jom wrote that FileMaker is a relational database... while true it is
> not necessarily exclusively so. You can create lots of "flat files" that
> are not related to others and they will run just fine. It's the formulae
> setups that are going to be the bear in moving the data over to
> something useful. I'm also sure that you can export out in CSV, or
> tab-separated values, or text only; though not that much use. Now Bento
> is for sure a good start, and if I recall correctly, you can move up to
> FileMaker Pro and open Bento files too. Bottom line after all the
> suggestions posted is to download the usually-free demo/trials and go
> with what works for you and fits your budget. No harm in trying, and you
> won't know otherwise....
>
>

[Non-text portions of this message have been removed]

Wed May 29, 2013 1:22 pm (PDT) . Posted by:

"Jim" jimpurcell2001

Mac designers must have serpentine fingers. :-)

Jim

GROUP FOOTER MESSAGE