I'm trying to export a record to a FTP. The file has to be changed to .bol extension for the end user access. Can anyone help me in the right direction.
All you need to do is calculate a path with a custom name in a variable, like:
Set Variable [ $path ; "file:" & get(desktoppath) & "myFile.someExtension" ]
then specify the export to $path in the export location dialog.
What are the contents of the file? If it's just text content, then there's no reason you can't script a custom extension on the end of your filename when exported. I regularly set .csv as the extension of a .mer file to get a CSV with a header row.
As for exporting to the FTP. There are plugins that support FTP (FTPeek, FTPitPro), or if you're using a mac, you can applescript it easily:
FileMaker Custom Function:FTPUpload ( URL ; user ; password ; directory ; file ; localdirectory ; localfile )
Yes I'm just trying to export a text field. Can you guide me in the right direction of creating the script that would change the extension.
As for the FTP I was actually looking at the (FTPeek) plugin, I've already downloaded the demo and I'm making test. Then I guest the next step after I got that figured out, would be to set a Server Side Script to automate it everynight.
Thanks for the reply.
Perfect, that should help. Let me go do some research. You have been really helpfull.
MBS Plugin can do FTP upload via CURL.
Also sftp and ftps for security as well as proxies or authentication if needed.
And you can upload text via plugin without writing a text file.
Perfect, Found the solution with the help of a plugin and some hard work. Thanks for all of your input.
Retrieving data ...