Email parsing + database generation

Create database tables from your stored messages :

 
 E-mails
Customer: Pompatus, Inc.
Customer ID: SM-1234
Transaction ID: REQ11223344
Transaction date: 2003-11-24
Amount: $0.00
Customer: A. De Grate
Customer ID: SM-2345
Transaction ID: REQ44332211
Transaction date: 2003-11-24
Amount: $99,000.00
Customer: Howell Seadog
Customer ID: SM-9876
Transaction ID: REF99887766
Transaction date: 2003-11-24
Amount: $111.00
...
schematic illustration of data transfer from emails to database
 Database
custname  custid  transid  transdate  amt 
Pompatus, Inc. SM-1234 REQ11223344 2003-11-24 0.00
A. De Grate SM-2345 REQ44332211 2003-11-24 99,000.00
Howell Seadog SM-9876 REF99887766 2003-11-24 111.00
...

Here's how :


 * Create your database
  Use a DBMS (Database Management System) such as Microsoft Access to create the "target" database.   Visit the Database + ODBC page for information regarding database creation and configuring the ODBC (Open Database Connectivity) connection.
 
 * Download, install and start Set Machine
  Download the Set Machine self-installing executable (.EXE) file.
  Install Set Machine by running the downloaded .EXE file on your computer.   It is recommended that you accept the defaults by simply pressing "Enter" until the installation has finished.   Be sure to take time to read the license agreement, though!
  Start Set Machine - the installation creates a Start menu entry and icons allowing you to run the program.
 
 * Select the appropriate email parsing template
  The Set Machine installation is accompanied by several sample email parsing configurations.   The best way to create an email parser is to adapt an existing parser that closely matches the desired task.  
EMail-To-Database.pxd is a good starting point for many email formats.   Modify the string sets and action group "NewEMail" as needed.
Contact WWWGrab.com for assistance with email parser configuration.
 
 * Set the input
  The input is specified as one or more message folders.   When the "Run / Message input" (Ctrl+E) command is selected all messages in the specified folders are scanned.   Select the "Input/Output" menu, option "Input: message folders".
 
 * Set the output
  Set Machine can output to database or files.   Specify output file(s) using the "Input/Output" menu, option "Output: streams".   Specify the database using the "Input/Output" menu, option "Database".   Click here for more information on databases.   Consult the program help for information on output destinations.
 
 * Map the input to the output
  Modify the Set Machine string set(s) using the "Definitions" menu, option "String sets".   String sets are also accessible via the "Quick Start" menu.
 
 * Modify other configuration data as necessary
  In order to perform the desired task the sample configurations may require modification beyond changing input, output and string sets.   Consult the program help and the tutorial for more information.
 
 * Run
  There are two run commands, one for files (stream input), one for emails (message input).   Choose appropriately depending on your input source.
 

Obtaining the desired output typically requires a few iterations of three basic steps :

Contact :   WWWGrab.com for assistance with email parser configuration.


Message (email) interface

Set Machine uses MAPI (Messaging Application Programming Interface) to interact with the Windows messaging system.   In order to determine whether or not it has already seen a message, Set Machine marks each message with a time stamp.   This enables Set Machine to run in "New messages only" mode.   Apart from this time stamp, Set Machine's access to the messaging system is read-only.




Copyright © 2002-2008 WWWGrab.com.   All Rights Reserved.