Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do I setup and trigger email from Filemaker Server?

Posted on 2010-09-05
3
Medium Priority
?
514 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 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
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…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
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…

715 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