1 of 1 people found this helpful
As you are aware, there are FTP plugins for FileMaker. FTPeek from 360Works is a plugin that can upload via FTP in FileMaker. http://www.360works.com/ftp-plugin/ Also, there is FTPit Pro from CNS. http://www.cnsplug-ins.com/plug-ins/ftpit_pro
You noted that this do not do what you want of exporting a Continainer Field's contents directly. What you really seem to be asking for is a syncing of two databases so that the slow system gets updates gradually that will perform much faster on that LAN. More and more solutions are coming out aimed more at syncing FileMaker servers with FileMaker Go, but it is the same principal. You might want to look at products like SyncDek (http://www.syncdek.com). Or you might check on GoZync (www.gozync.com).
FileMaker has a Support article on Syncing that you can find at: http://help.filemaker.com/app/answers/detail/a_id/7720/~/database-syncing---an-overview-of-approaches
I hope that helps! Best of luck.
That was a nice quick reply, thank you!
I am looking at FTPeek at the moment. I will look at FTPit also. The remote system is not related to Filemaker at all, so it's not a case of synchronising two Filemaker databases. Essentially, the client has a remote website that their clients have access to, and they want to be able to mark *certain* documents in their LAN-hosted Filemaker system as being available to clients who login to the remote website.
So, I have a background schedule script that identifies files that have been marked for upload, but not yet uploaded. It updates the remote SQL database to add references to these files so links to them become visible on the website; my only stumbling block is moving the files themselves from secure containers.
I'll let you know how I get on with these plugins.
Is the external system a SQL system that you can connect to via ODBC or JDBC?
I'm rethinking my last comment and I think I remember that container/blob fields are not supported in FileMaker via ODBC or there is some limitation on that. I forget, but I'm sure someone else will speak up on what the limitations are.
One thing on my list of options to check is to use the PHP SmartPill plugin to execute a query straight to the server inserting the document contents into a BLOB. However, I think there are again problems accessing the container data directly via that Plugin.
What platform are you on?
If Mac, you could consider using the Perform Applescript command to run cURL to transfer the files from the FM server to the faster web server. No plugin required.
The corresponding command line FTP for windows:
I have hit an additional obstacle, which is getting at the actual contents of an external secure container field from a script running on the server. Export Field Contents doesn't work. Part of the requirment is that the FM server does this as a background task - it isn't done by the desktop.
I'll report back when I've found a solution to that.