Solved

How do I setup and trigger email from Filemaker Server?

Posted on 2010-09-05
3
501 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AngularJS directive issue 6 72
Create associate webpages / websites 3 91
Required field data in layout in Filemaker Pro 10 6 67
Make Line Items Look Good Over Mobile 2 84
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
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)
The viewer will learn the basics of jQuery including how to code hide show and toggles. 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…

820 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