Solved

How do I setup and trigger email from Filemaker Server?

Posted on 2010-09-05
3
500 Views
Last Modified: 2013-11-18
I'm having difficulty setting up and triggering email from Filemaker 9  Server Advanced.

My database has a table of emails that I want to send to students and centrally track.  I understand that there is a way to have these sent from the server directly using XSLT.  I have an xslt file and a table that stores emails to be sent.

The problem is that I have no idea how to make hook this up and make it work.

I tried adding a recurring script to lookup all unsent emails from the Email table and send them.  The problem, Is that I don't know what that script needs to contain of how to make it actually send the mail.  

My FM Pro Server says that XSLT is setup, but I have no clue where to put, or how to run the XSLT file.  No body in my group has ever used the advanced web features in Filemaker Server.   In that respect this is a beginner question.

Experts, thanks for any assistance you can offer. send-email-v2-ee-post.xsl
email-table1.png
email-table2.png
0
Comment
Question by:tmonteit
  • 2
3 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 33675687
why do you bother doing it this way? quite unusual... I guess nobody here has ever been using a xml file to load an email list.
do a script which works manually, then schedule it in your server.
where is the list of receivers located?
0
 

Author Comment

by:tmonteit
ID: 33710332
It seems I may be making this harder than required.  Is there an example on how to do this?  
My confusion seems to be that the script tries to send the mail through a client like outlook.  I need to send the email from the server through an SMTP client.
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 33710578
fmaker has an internal smtp client. all you need is change the 1st option (email client/smtp server)  in the send mail script command.
it will open up a new window to enter smtp server params.
once done and tested from a client, this script can be scheduled on server. of course the smtp server must accept requests from the fm server if it checks the sender's ip address.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question