AnsweredAssumed Answered

Mail container as attachment from FM Server

Question asked by andrewblackwell on Sep 16, 2014
Latest reply on Sep 16, 2014 by monkeybreadsoftware

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?

 

Thanks

Andrew

Outcomes