| Moving the value of the merge code field to the email merge | |
Posted: Thu Jan 29, 2009 2:54 pm |
Points: 0 |
|
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 |
|
|
|
|
Posted: Thu Jan 29, 2009 3:05 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Sat Jan 31, 2009 2:01 pm |
Points: 0 |
|
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 |
|
|
|
Posted: Sat Jan 31, 2009 2:12 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Sat Jan 31, 2009 6:23 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|