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

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Emails did not get copied when doing a Copy/Move Contact
Post new topic  Reply to topic View previous topic :: View next topic 
Emails did not get copied when doing a Copy/Move Contact
PostPosted: Tue Jul 19, 2016 8:38 am Points: 0 Reply with quote
neocrm
GoldMine Apprentice
Joined: 19 Jul 2016
Posts: 13




GMPE - 2014.1.0.468

One contact got deleted by mistake, restore database from backup, I can see all history under the history tab but when trying to do a Copy/Move Records from the restored database to the current database, everything copied except emails, both Email-in and Email-out. Tried restoring from different backups but still no emails. I have checked and confirm there is no filter enabled in the History view. I can see emails in other contact records.
I have also tried to create a transfer set from the backup for that record and retrieve into the current database but still missing all the email histories.

Any suggestions will be very much appreciated.

Neo
View user's profile Send private message

PostPosted: Tue Jul 19, 2016 9:08 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




Responded in other forum, but, basically, how you restore the database and how you copy the contact are very important to the success.

Typically, I just restore the entire database (contact1, contact2, conthist, contsupp, cal, mailbox, etc. etc.) and use an SQL script to pull in all records related to the contact (accountno) from all the relevant tables.

Perhaps important to note is that the mailbox records probably still exist in your database but they're not linked to the contact or history (or cal) items anymore (via linkrecid, accountno, etc.) and re-linking them is a bit of a science.

_________________
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: Tue Jul 19, 2016 10:28 am Points: 0 Reply with quote
neocrm
GoldMine Apprentice
Joined: 19 Jul 2016
Posts: 13




Thanks for the suggestions Doug. I did restore the complete database and then do the copy/move. I did this many times in the past but this is the first time running into issues.
Do you think rebuilding the database will help?
View user's profile Send private message

PostPosted: Tue Jul 19, 2016 10:37 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




rebuilding will do zero good.

copy/move records, as a function of the goldmine sync menu, is only partially useful for this operation because when you delete a contact, it can sometimes leave behind orphaned conthist and mailbox records -- which is why you're having trouble putting those conthist/mailbox records back (they already exist, they're just no-longer linked to the contact.)

I'd suggest doing this stuff on the back-end, from the SQL side.

Personally, I first delete the mailbox record whose RECID is within the scope of those related to the contact in the restored database. Meaning, I issue a query like this before restoring the records:

Code:
delete from conthist where recid in (select recid from gmrestore.dbo.conthist where ACCOUNTNO='98111966439#!W!&TMat')
delete from mailbox where recid in (select recid from gmrestore.dbo.mailbox where ACCOUNTNO='98111966439#!W!&TMat')
go


Obviously, you'd need to edit this to address the correct database name, use the correct accountno, etc.

_________________
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: Tue Jul 19, 2016 11:04 am Points: 0 Reply with quote
neocrm
GoldMine Apprentice
Joined: 19 Jul 2016
Posts: 13




Thanks Doug, will give it a try
View user's profile Send private message

PostPosted: Tue Jul 19, 2016 11:06 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




also, keep in mind that the gmtlog and conttlog tables will retain deletion/change tracking for all types of records and could block the restoration of records via the copy/move feature. You'd also want to clear those logs (with whatever degree of careful-ness is necessary, depending on whether or not you have remote sync sites.)

_________________
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

Emails did not get copied when doing a Copy/Move Contact
  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