I'm trying to add the ability to send/receive emails from FileMaker Server Advance 8 (soon to upgrade to 9). Ideally, I'd like emails to be triggered from within an IWP session, but I'm ok if the email is not sent immediately, but is within a few minutes. Needs to run on OS X.

I'd like to avoid the use of Robot FM clients -- I'm ok with third party commercial software if needed. I would like this to work in FMSA 8, but if I have to upgrade to 9 to get it to work, I will. The emails don't need to be fancy (no attachments or styled text), though that may be a nice feature later on.

So far, it seems like the major problem is that a lot of the plugins don't work in FileMaker Server when run in IWP or within Server Scheduled Scripts. Other solutions require you to turn on PHP serving -- which is not the end of the world but I'd like to keep this simple.

Anyone out there solved this problem in fewer than 10 steps?

"I'd like to avoid the use of Robot FM clients..."

Hmmm, might be hard to do otherwise.

I've heard that a folderaction or a timed applescript can thew on the servers logfile, via some shell scripting can get enough to go on in order to make:

http://www.lestang.org/article63.html

Act as mail client on behalf of all the users of an IWP soultion.

--sd

Update regarding plugins:

SMTPit from http://cnsplug-ins.com they say not compatible with IWP or SSS

Mail.It from http://www.dacons.net/fmplugins/mailit/ : supposedly IS compatible with IWP, but only if you are careful and avoid any interactive features or attachments, and make sure it's only used by one process at a time -- see http://fmforums.com/forum/showtopic.php?tid/188266/post/258004/hl/dacons/fromsearch/1/#258004 Not clear if it would work from a server-scheduled script...

Anyone know about any of the other SMTP/Pop plugins?

Edited August 8, 200718 yr by Guest

Idea: Is this possible?

1. Upgrade to FMSA9, enable PHP.

2. Using Server Admin, create a scheduled server side shell script which regularly calls a PHP program. This PHP program would query the fm database, send any outstanding emails and mark them as sent.

My main question is : does PHP have access to filemaker databases when running via the command-line invocation of PHP? Or only when running as a mod-PHP from within Apache?

The 360Works email plugin will send and receive emails from within IWP / Web Publishing Engine. It can also be triggered by Server 9 scheduled scripts.