Parker Software Ltd Homepage
Forum Home Forum Home > Email2DB Email Parser > FAQ's
  New Posts New Posts RSS Feed: Storing a full copy of emails in an external DB
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Storing a full copy of emails in an external DB - Event Date: 11 Nov 2006 - 11 Nov 2006

 Post Reply Post Reply
Author
Message
Stephen View Drop Down
Admin Group
Admin Group
Avatar

Joined: 21 Oct 2005
Location: Stoke on Trent
Posts: 1415
Post Options Post Options   Quote Stephen Quote  Post ReplyReply Direct Link To This Post Calendar Event: Storing a full copy of emails in an external DB
    Posted: 11 Nov 2006 at 9:59am
Email2DB can already store full copies of emails in its own database (using its built-in database or SQL Server 2005/Express) - this is enabled by setting the 'Store Full Copy Of Checked Email Messages In The Checked Messages Database' option on the account settings.

However, if you want to store a full copy of emails in an external database then create a table with the following fields:

MSG_UID varchar(250)
MSG_From varchar(250)
MSG_To varchar(250)
MSG_Date Datetime
MSG_Subject varchar(1000)
MSG_Headers Text
MSG_MimeText Text

Create the same fields in Email2Db and assign them the built-in field values of the same name. Make the MSG_UID your primary key (or create an Auto Inc). The MSG_MimeText field is the full mimetext of the email including attachments. If you just want the body text then store MSG_Body and/or MSG_HTML.

Note: MySQL text fields have a limit of 32k so large emails will get truncated. This is a limitation of the ODBC driver. SQL Server (Full or Express) does not have a limit.

Steve
Back to Top
drremer View Drop Down
New User
New User


Joined: 14 Sep 2010
Posts: 1
Post Options Post Options   Quote drremer Quote  Post ReplyReply Direct Link To This Post Posted: 14 Sep 2010 at 11:28pm
Is it safe to assume that ONLY received emails are stored in the database?

What if I have a newsletter going out to 500 people? Would each recipient's email sent be stored in the database? That would be 500 of the same email except for the recipient name.

Thanks in advance for clarification on this issue.
Back to Top
Stephen View Drop Down
Admin Group
Admin Group
Avatar

Joined: 21 Oct 2005
Location: Stoke on Trent
Posts: 1415
Post Options Post Options   Quote Stephen Quote  Post ReplyReply Direct Link To This Post Posted: 15 Sep 2010 at 9:45am

Sent items would only be stored if you setup Email2DB to monitor your Sent Items folder.

Steve
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.
These are the forums for Parker Software, developers of Live Chat Software: WhosOn and Email Automation Software: Email2DB.