Solved

How do I setup and trigger email from Filemaker Server?

Posted on 2010-09-05
3
507 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

617 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