•   GETTING STARTED
  • How it works
  • Use case 1: Updating a MySQL database table
  • Use case 2: Inserting a row in an Excel file
•   CONFIGURING EMAIL SOURCES
  • Creating a POP email source
  • Creating an IMAP email source
  • Filtering incoming emails and setting a message deletion policy
•   EMAIL PARSING
  • General topics about email parsing
  • Wildcard expressions
  • Regular expressions
  • Retrieving email header fields (To, From, Subject...)
•   DATABASE ACTIONS
  • What is a database action
  • Setting up a SQL operation in a ODBC-compatible database
  • Setting up a SQL operation in a MySQL database
  • Setting up a SQL operation in a SQL Server database
  • Adding rows to an Excel file
  • Adding lines to a TXT file
  • Installing new ODBC drivers.

How it works

Email2Database is a tool designed to automatically process emails. It fills the gap between received emails (usually template-based) and a database. The process can be shown in the following diagram:

As you can see, Email2Database divides the process in three well differenciated steps:

• Emails are downloaded from the mailbox.
• Each received email is analyzed looking for specific chunks of text. This analysis is done following user configurable rules called "Field extractors".
• Database operations are launched using the obtained fields. This way yo can fill or update a specific database table, text or excel file.