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

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Moving the value of the merge code field to the email merge
Post new topic  Reply to topic View previous topic :: View next topic 
Moving the value of the merge code field to the email merge
PostPosted: Thu Jan 29, 2009 2:54 pm Points: 0 Reply with quote
grahamw
n00b
Joined: 29 Jan 2009
Posts: 1
Location: UK




Hi,

We are running 8.02.80208 with a SQL database on Windows Server 2003.
Due to some finger trouble an emal mergecode value has been entered in the incorrect field on the addtional contacts card (the Mailing info merge field).

I'm trying to come up with a SQL Update that will copy the value from the mailing info merge field ( contsupp.rectype = 'C') into the email mergecode field ( contsupp.rectype ='P') of the relevant addtional contact for all the addtional contacts in the database.

Has anyone done anything like this before or got any tips?

Best Regards,

Graham Watts
View user's profile Send private message

PostPosted: Thu Jan 29, 2009 3:05 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




tips:
update to 8.03
take the contsupp.recid of the additional contact (rectype C), find the e-mail record with that recid in it's contsupp.linkacct field and pull the merge code over. 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

PostPosted: Sat Jan 31, 2009 2:01 pm Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




As Doug has mentioned, move into 8.03.80716 immediately in preparation for the move to 8.50.

Why wouldn't you use the paradigm of one contact record per contact, related via the Relationship Tree? It is a much better, quasi Accountcentric solution.

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Sat Jan 31, 2009 2:12 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




It is imparative that you upgrade to 8.03 the release that killed over 125 bugs in your 8.02.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Sat Jan 31, 2009 6:23 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




Here's a list of some of them: http://www.castellcomputers.com/index.php?p=104

_________________
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

Moving the value of the merge code field to the email merge
  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