Plug-in (Function & Smart Service)Free

Mail Server to Database

by Appian Corporation

Description

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.

Features

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

  1. EML with attachments removed
  2. EML with attachments included
  3. Both (2 EMLs of original email) - EML with attachments removed and EML with attachments included

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)

Release notes

Resolved a library dependency issue for 26.6 Significant performance improvements.

Version history (13)

2.1.1

Replace deprecated contentservice and document APIs

2.0.4

Resolved Jakarta library dependency issue with Appian version 25.2.

2.0.3

Added License file and upgraded json library

2.0.2

Updates to Json library

2.0.1

Updates to commons-io and log4j libraries

2.0.0

Updated to support the jakarta mail library introduced in Appian 22.3. This version is for Appian 22.3 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 find the latest jar for Appian 22.2 and lower version by downloading from the app market.

1.1.6

The latest version resolves an issue with the latest version of Java, which disabled TLS 1.0 and 1.1. The new version forces TLSv1.2 connections.
NOTE: make sure your IMAP server allows for TLSv1.2 before deploying this version.

1.1.5

Added SQL Server support. Resolved issue with attachment filename encoding.

1.1.4

Bug fix based on Community user feedback: We are using latest plugin only. I observed date in header for EML with no attachments and not for the EML with attachments. EML attachment type property set to "Both".

Submitted by April Schuppel on behalf of Mike Cichy

1.1.4

Consumes all unread email from a mailbox and adds entries to a database table for use by processes.

  • The original email is saved as an EML based on three EML attachment type options
  • EML with attachments removed
  • EML with attachments included
  • Both (2 EMLs of original email) - EML with attchments removed and EML with attachments included
  • 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)

This smart service is intended for use with a single mailbox. Where multiple mailboxes exist, work with the mail server administrator to consolidate them together by either:

  1. Copying mail from individual mailboxes into a master mailbox
  2. Replace the individual mailboxes with email aliases that point to a single mailbox

If updating from an older version of the plug-in, the APP_MAIL_POLLER table/cdt will need to be updated to add the DOC_ID_WITH_ATTACHMENTS column. Prior versions of the smart service node have been deprecated and the new Configure Mail Server to Database node will need to be used.

See attachments for further documentation and examples.

1.1.3

[MIGRATED] Consumes all unread email from a mailbox and adds entries to a database table for use by processes.

  • The original email is saved as an EML based on three EML attachment type options
  • EML with attachments removed
  • EML with attachments included
  • Both (2 EMLs of original email) - EML with attchments removed and EML with attachments included
  • 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)

This smart service is intended for use with a single mailbox. Where multiple mailboxes exist, work with the mail server administrator to consolidate them together by either:

  1. Copying mail from individual mailboxes into a master mailbox
  2. Replace the individual mailboxes with email aliases that point to a single mailbox

If updating from an older version of the plug-in, the APP_MAIL_POLLER table/cdt will need to be updated to add the DOC_ID_WITH_ATTACHMENTS column. Prior versions of the smart service node have been deprecated and the new Configure Mail Server to Database node will need to be used.

See attachments for further documentation and examples.

1.1.2

[MIGRATED] Consumes all unread email from a mailbox and adds entries to a database table for use by processes.

  • The original email is saved as an EML based on three EML attachment type options
  • EML with attachments removed
  • EML with attachments included
  • Both (2 EMLs of original email) - EML with attchments removed and EML with attachments included
  • 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)

This smart service is intended for use with a single mailbox. Where multiple mailboxes exist, work with the mail server administrator to consolidate them together by either:

  1. Copying mail from individual mailboxes into a master mailbox
  2. Replace the individual mailboxes with email aliases that point to a single mailbox

If updating from an older version of the plug-in, the APP_MAIL_POLER table/cdt will need to be updated to add the DOC_ID_WITH_ATTACHMENTS column. Prior versions of the smart service node have been deprecated and the new Configure Mail Server to Database node will need to be used.

See attachments for further documentation and examples.

1.1.1

[MIGRATED] Consumes all unread email from a mailbox and adds entries to a database table for use by processes.

  • The original email is saved as an EML (with attachments removed)
  • 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)

This smart service is intended for use with a single mailbox. Where multiple mailboxes exist, work with the mail server administrator to consolidate them together by either:

  1. Copying mail from individual mailboxes into a master mailbox
  2. Replace the individual mailboxes with email aliases that point to a single mailbox

See attachments for further documentation and examples.

Resources

  • README Mail Poller.pdf

    Deployment Instructions

    Download