Script Automation Question

[lonesomejubilee]

Don't know if this is the right place to post it because it is a server and scripting question. I want to be able to send a scheduled email. My business is a security business that runs 24/7. I want to run a script that will export a PDF of the day's actions, attach it to an e-mail and send it.

I see that most of that is NOT web compatible, so what I was thinking is to just run a "create a record" script in Server so when that record is created in FMP, then through a conditional if/then thing based on account would trigger the script that would email me.

I know it's a convoluted way to go about, but that's all I have?

So number one, it's not working right... the server says it ran successfully, but it didn't create a record in the database. Do I have to have actual FMP software on the same computer that the Server is running to make this happen?

Please help and thanks in advance...

[IdealData]

If you are still on FM 8.5, and presumably FMS 8 then you cannot achieve what you are doing on the server natively. You cannot run FMP and FMS on the same machine either. Options:

1. A plug-in to do the exporting (360 works)

2. A 'slave' machine to run at specific times to send the e-mail

3. Upgrade to FMS 10/FMP 10 as EXPORT RECORDS (xls, csv - but NO PDF) will run on FMS10 and use the Send Mail script step to send the file.

[lonesomejubilee]

I'm running server 9, sorry I forgot to change it