FileMaker Pro to SFTP Server

I'm having a bit of an issue, I need to get my FileMaker Pro 16 system to automatically transfer some files to one SFTP Server, which then transfers said files to another SFTP Server. I tried looking for some information regarding what I just stated but no Forum or Technical support person is able to help me. Now I'm asking the online community if they have any suggestions, scrips, steps and maybe a link to a trusted site detailing what I need to do to make what I'm asking possible.

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.

If you can SQL-SELECT the fields, you could write a small JDBC (Java) program that, using FMP's Free JDBC driver, would connect to FMP and get your data. From there, you could write SFTP connection logic. Best yet, there are free, established (did I say free?) libraries from Apache that have SFTP logic built in. Here's a posting from a few years back. I'm sure there have been updates since then.

If you need to extract actual files, say in container fields, that's also supported by FMP's JDBC driver. I've done that, too, with FMP <--> MySQL Sync logic I wrote a couple years back.

Once you wrote the code, you could schedule it in Windows or Mac to run automatically on any schedule you like.

The one caveat is that FMI has crippled the JDBC driver so if you're using FMP and not FMS, that JDBC code will only run on the same machine as your database. I've worked around that ridiculous restriction too, but that's more work.

What I'm looking for is a script that allows you to transfer data from FileMaker Pro to the SFTP server.

What you recommended or better to say re-blogged me is a script that transferring data from the SFTP server to the FileMaker Pro system. <- that is not what I'm looking for.

Not sure exactly what you are referencing, but like I said not an intuitive script step choice.

Insert from URL in this case is not inserting a file into FM. It is inserting the response from the ftp server after transferring the data. There is an explanation of how this works in the following link, but the short answer is "--user user:pass -T $file".

When you use Insert From URL for an FTP upload, the step inserts the response back from the FTP site. Thus, this is not a download into FMP--though the step can do that as well, but an upload to the FTP site.