I looked around in the forums and found hundreds of matches for “Filemaker”, but they all deal with migrating applications, not data.
So here’s my question:
I have a Filemaker-DB (about 5.000 recs in 8 related FM-“tables”), there are images involved (BLOBs) and also references to external files (PDF, Word, etc.)
How can I pass that stuff to Servoy/Sybase? CSV obviously can’t make it, since some of the text-fields contain multi-line content. And how to deal with the images and the files?
I assume you have seen my JDBC driver from a previous post? I have never tested it with FM Container fields, so I don’t know how it will work with that, but you are welcome to give it a try. More info available at http://goldcougar83.googlepages.com . If it connects to your data okay, you may find that you can use Servoy as the bridge between FMP and Sybase to loop through records and transfer between the two.
There is also another product out there that I haven’t personaly used, but have heard about. It is designed to do exactly what you are looking for, an import/export type of transfer. http://www.dotcomsolutionsinc.net/produ … index.html
Another approach is to use proxy tables within the SQL Anywhere (Adaptive Server Anywhere) database that’s behind Servoy. A proxy table is connection to a table in remote database, but is treated like a local table within the SQL Anywhere database.
(Assuming the columns in the table are the same) you can then execute a SQL statement like:
INSERT INTO servoy_table WITH AUTO NAME SELECT col1, col2 FROM filemaker_table
You can specify specific column names if they are different between the filemaker and servoy tables.
Note, you will need a JDBC/ODBC driver for the FileMaker database. Lastly, there is no guarantee that this will work (because I’ve never done it before), but I think it’s worth a try…