Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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
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
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?
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 (?, ?, ?)";