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

ContactReview Forum Index » GoldMine 6 » change key 2 value
Post new topic  Reply to topic View previous topic :: View next topic 
change key 2 value
PostPosted: Wed Feb 16, 2011 8:18 pm Points: 0 Reply with quote
fibrolan
Sensei of the GoldMine
Joined: 15 Nov 2006
Posts: 187




Hi,

I am using golsmine 6.7 sql and I have many key 2 categories. I would like to do a global replace on some categories and change them to another category.

can this be done ?

tools and global replace. I cannot find the proper option.

can you please help ?

Fibrolan
View user's profile Send private message

PostPosted: Wed Feb 16, 2011 10:59 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Yes it can be done. If you have Goldbox, it has a great "Global Replace" feature. GoldMine can also do it very well. To start with:
1. Backup your database.
2. Form a group of the contacts whose key2 entries you want to change to another entry. This can be done with SQL Queries, Filters, or tagging records.
3. Activate the group.
4. Select Tools > Global Replace >Replace a field with a value.
5. Step through the next steps to identify the field and the value you want to enter in replacement and verify that your group is activated.

For more help, go to GoldMine's Help then Help Topics then Index. Enter "global replacing" in the index and you will get a lot of good additional information.

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

PostPosted: Thu Feb 17, 2011 10:03 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




In addition to Bob's comments, I have used GoldBox Views to create a tool that makes bringing GoldMine fields into Validated condition easy. Maybe overkill for your situation, but maybe not. Depends on your needs. You can see graphics and discussion at http://www.goldboxbob.com/examples7.html

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

change key 2 value
  ContactReview Forum Index » GoldMine 6
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