Importing Email Into A FileMaker Database

Email is a hairy subject. Not just because we have POP, IMAP and SMTP servers to deal with, but also ports, authentication, port restrictions by ISPs, syncing problems, etc.

I generally tell users to sick to their email programs, if that’s an option.

There are certainly some times when it’s worth dealing with it and that call, my friend, you will have to make. I can tell you I once implemented HTML sending for mass-mailing purposes, and it worked really well, we even tagged the client we sent the email for and kept the campaigns, as well as created join records for the email recipients so we could track history. Of course, this was before the day of MailChimp (which we are using). I love MailChimp and there’s no need to reinvent the wheel so I can reproduce something in FileMaker.

I however, have a client who wanted to see emails sent to and received from clients’ contacts for all employees of the firm, also see them from the job’s perspective: because the previous software (DayLite) he was using did integrate email with his project management. So, I looked at different options and decided to use mail.it.

There are other options out there, but I used mail.it before so I stuck with it and I do not regret it. I had a couple of gotchas along the way (e.g. deleting emails from the server for multiple servers), but all’s well that ends well. Customer support at dacons.net is also excellent with a support forum. Their turn-around was not the quickest, but that’s not really their fault, because we have a 6 hour time-difference.

I think, at the end I accomplished creating an interface that acts and looks like an email client. I am using the webviewer to show the message as HTML. Attachments show up, and you have two options: 1. you can hold down the option key to view them in a new window or you can download them. Attachments are NOT stored in the database. Attachment handling is accomplished with SuperContainer by 360 Works.

Of course, email receiving will be accomplished from the server side. It will run at a 5-minutes interval, just as if you had it in an email client.

4 replies
  1. Stephen Dolenski says:

    Hi Agnes, good article – I to have been doing this using IMAP mail – I have had to setup a log table that creates a record with the ID’s necessary to touch the email again with an expiration date today + 14. Then FM Server every night runs a server side script that finds all records in this table ≤ the current date and the loops thru and prunes records from the IMAP server. In this particular case it’s a generic email account – not a person’s account.

  2. Stephen Dolenski says:

    I am also looking at a different method – if you have control of your mail servers. With https://www.dbmail.org/ then using FMP and ESS you could just manage or import the email as needed it to Filemaker. Excerpt: DBMail is made up of several components. A normal MTA (Postfix, SendMail, QMail, Exim) is used for accepting messages. The MTA hands the messages over to dbmail-deliver, using a pipe interface, or to dbmail-lmtpd, using LMTP (Local Mail Transport Protocol).These programs take care of injecting the message into the database. Messages can be retreived from the database using dbmail-pop3d, using the POP3 protocol, or dbmail-imapd, using the IMAP4Rev1 protocol.
    Emails are stored in the database. This includes attachments. User information is also stored in the database, so users do not need a system account on machines DBMail is running on.

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply