how to setup email with MS Exchange server?

Classic Servoy
1

Hi there,

I’m at a point where I need my solution to be sending out emails. Is there a tutorial out there that can show me how to set up email. We use Microsoft Exchange server. I’m on MS SQL 2000 as backend DB.

thanks,
sammy

2

Hi Sammy,

You can push samples from the mail plugin but setting up mail is simple as 1+1. You can enter the smtp properties in the preference panel and you are set to go. For the rest the documentation might be of help. Don’t know.

3

I actually need to send automated emails every day based on a query. (i.e. email all engineers with action items due 1 week from today)

I’m thinking that might be best handle on the MS SQL server side via the SQL agent, but can servoy do something like this? have the server run automated scripts that includes sendmail periodically?

4

You can set up one (1) client as a server process which you can set in the web server pages. It is named batch processor.

The processes you want to perform can be set up like you would set up a normal solution with the exception of all dialog related stuff. So formInDialog, dialogs, splashes etc are not allowed.

For your scheduled stuff there is the scheduler plugin you can use.

Have fun with it

5

IT2BE:
You can set up one (1) client as a server process which you can set in the web server pages. It is named batch processor.

The processes you want to perform can be set up like you would set up a normal solution with the exception of all dialog related stuff. So formInDialog, dialogs, splashes etc are not allowed.

For your scheduled stuff there is the scheduler plugin you can use.

Have fun with it

Thanks for the pointer, I’ve never done it before so let me see if I got this right.

  1. set up a global method in my solution database to do my search and send email. (my script requires me to loop thru different records, flag each record that needs to be emailed and then email it out to different engineers’s emails)

  2. set up another global method that uses the scheduler plugin to run my 1st global method every day

  3. set up a client as batch processor.

  4. ??? how do i tie the batch processor to the scheduler method? Am i supposed to pass in the arguments to run the scheduler method?

i’m confused about the last parts
thanks for all your help

6

You would create either a new module to do your thing or run your solution as a batch processor. Start up a server process an go to the admin pages and you will see how to do that.

Next thing is that you can, like with a headless client, assign variables to let the solution know it is running as a batch processor. This is only necessary when you run your solution instead of a seperate module

you would make your onstartupmethod recognize that variable and trigger the scheduler plugin.

I use this setup with a separate module to check an ftp server for incoming files and then process the files. Works 100% ok…