Arclab® Inbox2DB

 

Insert Data from Incoming Messages
into a MySQL Database

 

 

Try now for free!

Collect and Export Email Data to a MySQL Database

Arclab Inbox2DB is a software program for Windows to extract data from incoming email messages (e.g. sent by a form) and export the data to a MySQL database. There is no installation on your webserver required: Inbox2DB runs on your local computer and connects to the selected mailbox. It collects data from incoming email messages and adds a new record to your MySQL database for each message. The unique features of Inbox2DB and the flexible collection engine allows you to to integrate external data - sent via email - into your database.

 

 

email to mysql

 

Consistent Data Types

The data included in the email message will be mapped to the data type of the MySQL database automatically, so you don't need to care much about data types. It supports U.S. and European input formats, like e.g. 24/12/2014 and 24.12.2014 as date, $1.99 and 1,99€ as currencies, etc.

In addition to the form data, the message source code and file attachments can also be stored in the database.

See also: How to extract email data and insert the data into a database or excel sheet

Field Relationship

 

 

Test Inbox2DB Email Parser Software

 

Arclab Inbox2DB is an email automation solution and email parser software for your Windows PC to automate your inbox, collect data from incoming messages and insert the information into a database. Download Arclab Inbox2DB and test the software for 14 days without limitations.

 

Download Inbox2DB   Screenshots

Download the MySQL ODBC Connector:

Important: The MySQL ODBC Connector (32bit) must be installed on your computer in order to connect to your MySQL server.

 

You can download the MySQL ODBC Connector (32 bit) here:
http://dev.mysql.com/downloads/connector/odbc/
Inbox2DB is a 32bit-Windows executable, so it's required to install the 32bit version of the ODBC driver as well.

 

 

Setup a new MySQL ODBC Data Connection:

Create a new "Data Connection" in Inbox2DB until you reach "Data Connection Target".

Select "ODBC Data Connection" as "Data Connection Target".

Select your existing MySQL DSN or click on "New" to create a new user (or system) DSN.

Select "MySQL ODBC x.x Unicode Driver".

 

 

MySQL Connector / ODBC Data Source Configuration:

 

MySQL ODBC Connector

  • The "Data Source Name" is the name which identifies the source. You can type in any name here, e.g. "MySqlDB".
    We recommend to avoid spaces and special chars in the "Data Source Name".

  • The "TCP/IP Server" is the server name of your hosted MySQL (web) server.
    Take a look at your (hosted) control panel or ask your web administrator if you don't know what server name you should enter here.

  • Enter your MySQL "User" and "Password" and click on "Test".

  • Select the "Database"(!) from the drop-down menu

 

Important:
Make sure you've selected the "Database" in the MySQL Connector Configuration - otherwise you won't be able to access any database tables!