IWP and SSS email Send/Receive?

[xochi]

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?

[Vaughan]

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

Hmmm, might be hard to do otherwise.

[Søren Dyhr]

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

[xochi]

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, 2007 by Guest

[xochi]

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?

[Jesse Barnum]

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.