I have been trying to get my head around the following conundrum:
- I am creating a solution where the client can upload a file onto a container field, to be used as an attachment in a mass mailing to the client's contacts
- The mailing itself should be run on the server (through a Perform Script on Server step) using the send mail script step in a loop
What I can't figure out is how to get the uploaded container file to get attached to the mail.
What is obviously a no-no is doing an export of the container file, as this script step is not supported on FM Server.
But I thought it might be possible by using Remote Containers and then referencing the FilePath to the Container File. I've tried this, but only got it to work if I executed the script locally on the server machine. However, if I let the server execute the script by calling it remotely through a Perform Script on Server step, it doesn't work any more.
Does anyone have any idea how I can solve this problem, preferably without plugins?
Is there something I need to be aware of when writing the file path when it is sent from the server?
The file path I'm using currently is the full path: filemac:/Server HD/Library/FileMaker Server/Data/Databases/KFTW/RC_Data_FMS/KFTW_Documents/KFTW_Documents/Attachments/IMG_3695.jpg
Is this wrong? Should it be relative to the server files? If so, can someone give me a pointer what the path should be before the RC_Data... bit?