If you’ve been using GoldMine for a while, and I am sure you have, you probably have a lot of old and outdated data in your database. For example, everyone probably has something of an Account Type field in your system.
Our pick-list is quite current and update to date, but how do you see if there are any outdated entries in the system?
The solution is pretty easy!
First, find the database name of the field you want to review. This can be done with a Right-Click | Properties of the field in question.
Since this is my KEY1 field I can use this SQL Query:
SELECT key1 AS field, COUNT(*) AS COUNT FROM contact1 GROUP BY key1 ORDER BY COUNT(*) DESC
To run this simply go Tools | SQL Query then past in the query and click on Query.
If the field you want to examine does not have a ‘U’ in front of it simply swap out KEY1 for your field name in the query. If the field does begin with a ‘U’ then swap out the field name as well as contact1 for contact2 as you’ll be looking at a user-defined field.
From here you can use filters to find those records that don’t fit and fix as needed.
{ 0 comments }
