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

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

   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

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
Stephen Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 21 Oct 2005 Location: Stoke on Trent Posts: 1389	Post Options Post Reply Quote Stephen Report Post Quote Reply 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

drremer Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 14 Sep 2010 Posts: 1	Post Options Post Reply Quote drremer Report Post Quote Reply 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.

Stephen Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 21 Oct 2005 Location: Stoke on Trent Posts: 1389	Post Options Post Reply Quote Stephen Report Post Quote Reply Posted: 15 Sep 2010 at 9:45am
	Sent items would only be stored if you setup Email2DB to monitor your Sent Items folder. Steve