Insert From URL supports the FTP protocol for downloads, and is compatible with FileMaker Server.
You might run into issues if your FTP directory requires a username and password for access though. If so, you might be limited to a plugin's features.
OSX has sftp command, so server side scheduled shell script can do it.
Windows server also has ftp command, but I don't know whether it can connect SFTP server or not.
I being a new user to Fm and FM server had to do this same thing.. and the quickest solution I found because my FTP site does require a username and password was to use a stepped process...
I use CoreFTP for my FTP program.. it allows command line access so basically you need to have an FTP program that allows command line access....
I created a batch file (Windows machine) to call my FTP program and do the dirty work of downloading the file to the directory I needed... I then set a FM Server schedule to run a script to import that data into the tables I needed.
So for windows it was ...
Batch file called by scheduled task to run FTP program and download file
FM Server Schedule to run script to import FTP'd file
If there is a better way, I am all ears
chronister, that's also a good way to do it, and with FM13's perform script on server, might be a good way to perform the action on-demand as well.
What is OSX ?
Can yoy please explain it more ?
What is core FTP. Could you please write steps for this description ??
How scduele script 'll called commandline ??
Can we use php script instead of windows script?
You can execute a PHP script by calling it with Insert From URL, or loading the address to a web viewer, as long as it’s a hosted script that can be executed outside filemaker (IE loading it up in a browser).
The result of your PHP script should be to download the file to a location on a computer.
Alternatively, you can use the smartpill plugin to execute PHP from within filemaker.
Do you use our MBS Plugin? With CURL functions there you can talk to FTP, SFTP and FTPS and all without adding PHP. Also plugin can verify certificates and make sure there is some security.
OSX is Mac Operating System
CoreFTP is an FTP Client... you can use any FTP client you wish it just would need the ability to run from a command line (dos window, shell window)....
I wrote a batch file in windows and I use Windows task scheduler to call this batch file. The batch file calls the FTP program to download the file.
I understand where your coming from and I have been there before, but you should likely do basic studying on things like Operating Systems, FTP clients, Command line access in your OS (Windows, Linux, Mac) so you have a basic concept of how to schedule tasks and applications
Thanks for the reply.
which option is good ??PHP script ,windows script or plugins ??
There is no need for plugins, if you e.g. want to get a file from a FTP server and insert that file into a container field.
The FTP url scheme allows you for setting in username and password as well:
And you can add a folder after the server address.
An example of such url could be:
I have not tested this on SFTP, but otherwise you could use a plugin, which there is a handful of, who gives you FTP functionality.
Be aware that if you use "Insert From URL" Script step, you give up on security. It does not verify certificates, so you are not safe that nobody sits in the middle and watching your traffic. And it probably does not support SFTP.
By the way, passing username and password in URL will break if you have @ in username or password.
But aanshi needs to know what he wants.