FileMaker Pro to SFTP Server

Do you need that for Mac / Win or both?

Where are the files you want to move: in FileMaker container fields?

You can you Insert from URL script to do this, but depends on there the files are to start with. Also not intuitive that when you want to send a file out you use a script to insert something into FileMaker.

FM16 can do this with Insert from URL and cURL options. Files must be in a container and must be sent one at a time To the destination.

If you need need bulk transfers look at a plugin. Base Elements and MBS and other can do this.

You can try the MBS FileMaker Plugin for SFTP via the CURL functions.

Our plugin comes with a couple of examples for uploading files via SFTP/FTP.

e.g. on this page is an example for FTP:

Monkeybread Software - MBS FileMaker Plugin: CURL.OpenInputFile

You can simply try it with a sftp:// URL and it should work.

We support authentication via password or private key file.

For WIN I recommend to install WinSCP, which has automation features see Scripting and Task Automation :: WinSCP.

In your FileMaker script you first export files from database to file system using 'export field contents',  then you call WinSCP with 'Send Event'.

You can script a routine that runs automatically but each file needs to be send individually.

With a scheduled script you could have a script check every few Minutes if there is something to upload and simply run a script to upload a file.

So first figure out which file needs to go where.

For SFTP server, you need the URL, a folder to target and of course credentials.

You already have suggestions here that do not use plug-ins nor third party programs.

Use a script with Insert From URL.

This step can only do one file at a time, but your script can use the same step repeatedly to upload all of your files.

I have not tried but with PSOS you might be able to get multiple transfers going in parallel or simply process batches regularly with a schedule.