I have a need to move data from FMP to a MySQL datebase, and also
move some other data back.

How have other people done this? Is there a procedure someone has
written and submitted for open use?

--
A host is a host from coast to coast.................wb8foz (AT) nrk (DOT) com
& no one will talk to a host that's close........[v].(301) 56-LINUX
Unless the host (that isn't close).........................pob 1433
is busy, hung or dead....................................20915-1433

On Wed, 30 May 2007 14:10:55 +0000 (UTC), David Lesher
<wb8foz (AT) panix (DOT) com> wrote:

Not really -- not until Filemaker 9 comes out (so we are led to
believe).. There are a few proprietary solutions, but none of them
are cheap. One of them might work for you; I haven't tried any of
them so I can't comment on them.

What you can do is export/import using dedicated layouts and a
standard data format, such as CSV. It's a bit clunky but it works. It
helps to have a really good SQL front end, too. FMP <-> MySQL is
something I've become pretty adept at; if you want, email me privately
and I'll try to answer some of your questions.

Hope this helps

--
FW

Martin Trautmann <t-use (AT) gmx (DOT) net> writes:


and another response:


Thanks. I was not clear. I don't want to link the databases as
if they were one; we have two databases for data security reasons
as well as simplicity. [The databases are in different states...]

But we do need to do regular batch data moves; i.e export data from
FMP, import into MySQL; and the other direction as well. My query
was of the "what's the best format for same?" ilk; do you use
CSV or XML or...?

I'll be writing to both of you for more specifics..

--
A host is a host from coast to coast.................wb8foz (AT) nrk (DOT) com
& no one will talk to a host that's close........[v].(301) 56-LINUX
Unless the host (that isn't close).........................pob 1433
is busy, hung or dead....................................20915-1433

Actually, my product FmPro Migrator can provide some assistance for the
FileMaker to MySQL part of this task (see link below [$100]). For
transferring data back to FileMaker, I usually use a an import where I match
on a primary key.

--

David Simpson
www.fmpromigrator.com
"David Lesher" <wb8foz (AT) panix (DOT) com> wrote

On Jun 3, 8:33 pm, "David Simpson" <dsimp... (AT) dotcomsolutionsinc (DOT) net>
wrote:

Jeroen