Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » email messagein mailbox table
Post new topic  Reply to topic View previous topic :: View next topic 
email messagein mailbox table
PostPosted: Fri Jul 24, 2015 8:38 am Points: 0 Reply with quote
joebit
GoldMine Journeyman
Joined: 21 Jun 2009
Posts: 32




Can somebody tell me where the email body is stored in the goldmine mailbox table. I'm wanting to delete just the emailbody of certail email blasts that have increased the size of my mailbox table. Is it the field labeled RFC822 or is this a image field??
regards
Joe
View user's profile Send private message

PostPosted: Fri Jul 24, 2015 9:52 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




Yes:
-RFC822 is the field that holds the email bodies.
-It is an image type field.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Jul 24, 2015 3:28 pm Points: 0 Reply with quote
joebit
GoldMine Journeyman
Joined: 21 Jun 2009
Posts: 32




I'm trying to delete just the content of that field without loosing the rest of the links in the email record.
If i run a select query e.g.
SELECT RFC822 FROM SQLGOLDMINE.DBO.MAILBOX MB WHERE ((MB.CREATEON >= '2014-07-24' AND MB.CREATEON <= '2015-07-24') OR (MB.MAILDATE >= '2014-07-24' AND MB.MAILDATE <= '2015-07-24')) AND (MB.MAILREF LIKE '%auction notification & invitation%')
I get all the content of the rfc822 field for the blast relating to "auction notification and invitation"
What would the delete query look like to delete these results.
View user's profile Send private message

PostPosted: Fri Jul 24, 2015 3:40 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




Easy:

Code:
delete from mailbox where...


The problem is, however, mailbox records also have CAN or CONTHIST records associated with them. You'd probably want to delete those first.

So I'd
Code:
delete from conthist where recid in (select linkrecid from mailbox where ...)


and

Code:
delete from cal where recid in (select linkrecid from mailbox where ...)


before

Code:
delete from mailbox where ...


Obviously, this is a somewhat dangerous thing to undertake without a full understanding of the database and data involved. I'd make a full backup of the database (or just the involved tables) before issuing any delete commands.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Jul 24, 2015 4:12 pm Points: 0 Reply with quote
joebit
GoldMine Journeyman
Joined: 21 Jun 2009
Posts: 32




I'm testing these statements on a test server so my production database is not affected.
I was hoping to keep references of the email blast in the history of each person that received it just want to get rid of the bulk building up in the mailbox table and thus my database. I thought that if i kept the rest of the mailbox table in place after deleting the contents of RFC822 i would achieve that.
Moving forward i will not save the template text history when i send out future email blasts.
regards
View user's profile Send private message

PostPosted: Fri Jul 24, 2015 4:26 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




well then, sure, just delete the mailbox records and leave it at that. Should be fine. Wink

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

email messagein mailbox table
  ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin