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)
Hi Mike Cichy,
Does the email pollar also store inline images as attachments? Or are they removed? or separated as "other" attachments?
The IMAP poller does not have such parameter, I think you are referencing the MSGraph poller. Hard to say what would trigger an exception.
One of the configuration properties is the Exception Folder Name where the email folder can be identified. How can I test that this folder gets populated correctly, in other words, what would cause an email to be handled as an exception?
Just keeps erroring out with Mail Poller already running. The lock never seems to get released as far as I can tell.
Can you explain what you mean by "stuck"? If there was an exception, the poller should have thrown it and released the "lock" so that a new instance can be started.
Hello - getting the following message: Mail Poller already running
We have the process running every 5 minutes. I found one instance where it got stuck. I cancelled the process but still getting this error. Is there a way to manually kill it without having to bounce the server?
Thanks,
Mat
Hi Mike,
We have an issue with attachments that are extracted from the original email. Attachment names are completely changed when writing to KC.Please see below examples and we believe it could be with special characters in attachment name.
Original Attachment Name: Don’s Speed_Adj. 1st Report_1100.pdf
After extracting the attachment from original email, the current name in KC=_utf-8_B_RG9u4oCZcyBNY05lZXNlIEV4cHJlc3MsIExMQ19BZGouIDNyZCBSZXBvcnRf_= =_utf-8_Q_10997127.pdf?=
If there are no characters like ( ’, or any special character) then the name is perfectly fine.
The issue is more around the extension when processing documents as its an invalid extension(.pdf?= ). We can do a workaround and replace it but wanted to check if this can be fixed or addressed from plugin side? Please let me know your thoughts. Mike Cichy
The column I removed was DOC_ID_WITH_ATTACHMENTS.
Hi Jasper,
I did remove 1 a column but pretty sure those were the only changes.
private static final String MAIN_INSERT = "INSERT INTO APP_MAIL_POLLER (FROM_EMAIL, FROM_NAME, TO_EMAILS, TO_NAMES, CC_EMAILS, CC_NAMES, BCC_EMAILS, BCC_NAMES, SUBJECT, RECEIVED_DATE, BODY_TEXT, BODY_HTML, MESSAGE_ID, IN_REPLY_TO, DOC_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; private static final String DOC_INSERT = "INSERT INTO APP_MAIL_POLLER_DOC (APP_MAIL_POLLER_ID, ELT, DOC_IDX) VALUES (?, ?, ?)";