I amusing FMP 5, or I should say my client is, and it will remain that way, so please direct all solutions with this in mind.

I need to export a set of records and ftp them to a remote server. I found MondoMail would do this, but it has a problem, you can export once, and then ftp, and then MondoMail locks the exported file as in use by the hidden MondoMail Daemon. I am stuck at this point, the only way to get the MondoMail Daemon to die, is to reboot. This wont work.

How can I take a scripted export from FMP and get it ftp'd to a remote server? Are there any other options other tham MondoMail, I tihnk it is a bug and I have a feeling I will not be able to get it fixed. I can not run Lasso or webcompanion for internal reasons.

Any suggestions on how to approach this?

Please specify your OS.

In Mac OS 9:

Use url access scripting

In MacOs X:

use shell script

In Windows:

use batch files or windows scripting host

Or use a ftp-plugin. Unfortunately, there is no free one.

Use FTPit by CNS (http://www.cnsplug-ins.com)

Powerful, simple, has example files that jump-start what you're trying to do

yep, that plugin is great, but $$$ if used in a bound solution.

5 lines of Applescript or a simple batchfile do the job equally well.