Overview
This version is for Appian 25.1 and above. Cloud customers on a lower version of Appian that want to install this plugin should open a support case. Self-managed customers can download the latest JAR for Appian 25.1 and later from the AppMarket.
Enhancement to the plug-in to enable the selection of whether or not to include the email attachments as part of the EML document. Previously, the plug-in would create an EML document with the attachments stripped out. Our client needs to preserve the original e-mail as it was sent (for auditing purposes), so the EML must include the attachments as part of it. This update extends the functionality to allow the user to select whether they want an EML with the attachments removed (original functionality), an EML with attachments included, or both (2 EMLS of original email - one without the attachments included and one with the attachments included). Any e-mail attachments will continue to be saved separately.
Key Features & Functionality
Takes all unread email from a mailbox and adds entries directly to a database table.The original email is saved as an EML based on three attachment type options
Each email attachment is saved as its own document. The database tables store the Appian document ids, email recipients, subject and body (text and HTML)
Thanks Mike. As Mathieu had already suggested, I was eventually able to fix it by changing the the MAIN_INSERT and DOC_INSERT statements in the DatabaseHandler, which are incompatible with SQL Server
Let me have a look, I don't think we tested on anything else other MySQL.
Hi Mathieu, Getting the same issue as you had, we're also using SQL Server. All tables have been added correctly after converting the MySQL code. Is there anything else you had to do?
The IMAP filter that is coded in the plugin ensures only unread emails are retrieved.
If anyone is interested, I've fixed the issue for SQL Server, was simply a question of removing the quotes around the columns names in the prepared statement. Was there a particular reason why they were there?
elakkiyav Yes, this plugin will only get Unread emails from the configured mailbox. Plugin only gets the Unread emails for our configured mailbox.
Hi Mike,
I have used this plugin in our application and found that it takes all emails from the configured mailbox [both read and unread emails] whenever it gets executed.
According to the documentation of this plugin, it takes only unread emails.
Please let me know the behaviour of this plugin.
Hi Mike Cichy
Getting the following error: Incorrect syntax near '`'.
I suspect that it is happening when writing to the DB, In my case, the DB we're using is MS SQL Server and not MySQL.
community.appian.com/.../mail-server-to-database-issue
Hi Mike Cichy,
I have used this plugin in our application, CC_NAMES and TO_NAMES are not capturing in APP_MAIL_POLLER table, could you please provide the solution for this?
Also I have following questions could you please answer for that
1.Maximum how much MB attachments this plugin will read?
2.On failure, I need to mark it as unread so is there any way to do that?
Ramesh A Unfortunately, that is not much to go on. I inspected the code and the only thing that could be happening is that the document was deleted downstream by a person or process. Without more specific replication steps, I don't see a way forward in troubleshooting this.