But for now I would suggest to pass user name and password in two options to avoid problems with : in the password. Also the header give is for HTTP and not helping for FTP. Next the URL must contain the destination file name and ftp:// without s is not secure. I prefer sftp:// URLs.
And you may want to get the debug log from the transfer to read error messages.
Thanks for the feedback, I'm specifically preparing a demo of new native FileMaker 16 features so I'm not able to use MBS plugin, though I know it is very capable.
I don't think FM 16 supports an option for separate password, at least I'm not seeing it listed in the documentation. I do see now the example uses an http url however the documentation does say ftp and ftps are supported. I'm also aware that ftp is not secure. I spun up this ftp server simply for testing this new feature using lowest common denominator. How does one access the debug log you reference?
Even though the documentation says "The filename on the server will be the same as the filename in the container field," adding a filename to the end of the url does seem to have made it work.
Insert from URL [With dialog: Off; $$results ;
"ftp://My-Mac-Mini-Server.local/" & GetContainerAttribute(table::container;"filename"); ...
Thanks again Christian
I believe the format is: "FTP:myusername:mypassword@My-Mac-Mini_Server/Filename.CSV"
In my case, I used the URL number 000.000.000.000
But I do have a problem when I use this in version Go 16, it no long works.
So I guessing it has something to do with cURL.
Other thinks to watch is if you are on a Linux server, they are case specific. For example, I would think capitalizing "FTP" could break it too.