Importing to Postgres from Filemaker Pro

Started by Adam Haberlachabout 27 years ago3 messagesgeneral
Jump to latest
#1Adam Haberlach
haberlaa@ricochet.net

Has anyone out there done any work getting data from
a FileMaker database into postgres? I have about 16000 fairly
large records that I need to move from a crufty MacOS machine
to a Linux box. I also have Filemaker for NT handy, as well
as Lasso. At least four of the fields in the database can
contain commas, tabs, and many other simple delimiters.
Right now it looks like I may have to export from
Filemaker into a giant HTML table, and then parse that into
a bunch of INSERT commands with a special program.

In short: anyone have any simple tools to import
complex .csv, .tab or other common flat files into postgres?

#2Greg Youngblood
YoungblG@houstoncellular.com
In reply to: Adam Haberlach (#1)
RE: [GENERAL] Importing to Postgres from Filemaker Pro

ODBC may be a solution.

I dont know if Filemaker supports ODBC, but if it does you can open the
database in Filemaker and connect to postgres via ODBC and move the data to
postgres that way.

Gregory S. Youngblood
ext 2164
�
�

-----Original Message-----
From: Adam Haberlach [mailto:haberlaa@ricochet.net]
Sent: Sunday, January 31, 1999 2:50 PM
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] Importing to Postgres from Filemaker Pro

Has anyone out there done any work getting data from
a FileMaker database into postgres? I have about 16000 fairly
large records that I need to move from a crufty MacOS machine
to a Linux box. I also have Filemaker for NT handy, as well
as Lasso. At least four of the fields in the database can
contain commas, tabs, and many other simple delimiters.
Right now it looks like I may have to export from
Filemaker into a giant HTML table, and then parse that into
a bunch of INSERT commands with a special program.

In short: anyone have any simple tools to import
complex .csv, .tab or other common flat files into postgres?

#3Jackson, DeJuan
djackson@cpsgroup.com
In reply to: Greg Youngblood (#2)
RE: [GENERAL] Importing to Postgres from Filemaker Pro

Look at the COPY utility in the pgsql/bin dir and the COPY sql command
under psql...
-DEJ

Show quoted text

-----Original Message-----
From: Greg Youngblood [mailto:YoungblG@houstoncellular.com]
Sent: Monday, February 01, 1999 2:05 PM
To: 'Adam Haberlach'; pgsql-general@postgreSQL.org
Subject: RE: [GENERAL] Importing to Postgres from Filemaker Pro

ODBC may be a solution.

I dont know if Filemaker supports ODBC, but if it does you
can open the
database in Filemaker and connect to postgres via ODBC and
move the data to
postgres that way.

Gregory S. Youngblood
ext 2164
�
�

-----Original Message-----
From: Adam Haberlach [mailto:haberlaa@ricochet.net]
Sent: Sunday, January 31, 1999 2:50 PM
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] Importing to Postgres from Filemaker Pro

Has anyone out there done any work getting data from
a FileMaker database into postgres? I have about 16000 fairly
large records that I need to move from a crufty MacOS machine
to a Linux box. I also have Filemaker for NT handy, as well
as Lasso. At least four of the fields in the database can
contain commas, tabs, and many other simple delimiters.
Right now it looks like I may have to export from
Filemaker into a giant HTML table, and then parse that into
a bunch of INSERT commands with a special program.

In short: anyone have any simple tools to import
complex .csv, .tab or other common flat files into postgres?