forums.frontrange.com Forum Index
Contact | Site Map | Global Sites
forums.frontrange.com
FrontRange Solutions Community Forum
 
FAQFAQ
SearchSearch
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesLog in to check your private messages
Log inLog in

Attention Forum Members

Forums.frontrange.com has been set to “Read Only” status.  You can no longer start new discussions or add/edit existing threads.  Instead, please access FrontRange Connect at www.frontrange.com/community and create your account for the FrontRange virtual community, FrontRange Connect. 

Sign up for an account today.  Participate in this interactive community forum and leverage the new features and functionality by going to www.frontrange.com/community.

FrontRange Connect provides users with a dependable, secure and feature-rich experience. 

Benefits of FrontRange Connect include:

·       Post discussions and provide comments just as you did in the Forum

·       The ability to create interactive Wikis, a shared workspace where you can build a knowledgebase, develop documentation, share ideas and experiences, and more

·       Additional features not found on the Forum including Event Calendaring, ability to schedule Meetings, Private Messaging and more

·       Improved stability and security over FrontRange Forum

·       Get support and resources for all FrontRange products in one location

·       A network of FrontRange experts and fellow FrontRange product users providing thousands of combined years of experience in one place

 

Finding Unused Fields

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    forums.frontrange.com Forum Index -> GoldMine
View previous topic :: View next topic  
Author Message
GoldMineNinja



Joined: 27 Sep 2007
Posts: 2
PostPosted: Thu Sep 27, 2007 4:22 pm    Post subject: Finding Unused Fields Reply with quote
I'm trying to find user defined fields in GoldMine that are not used on any tab.

I'm thinking the Fields5 table will help me with this but it isn't clear what all of the columns in it represent.  Does anyone know of any documentation for this table?

I didn't see it in the Hackers Guide to GoldMine (so we cant remove one potential answer right off Wink

Here's my system info (we run it on SQL Server):

Product = Corporate Edition with GoldSync®
Versions = GoldMine 7.00.60526, Windows NT 5.01.2600 Service Pack 2
Free Disk Space = C: 11,930 MB
Memory (RAM) = 2097 MB
Open Cursors = 13
Tx32 version = 801

FYI, here's the structure of Fields5:

[RECTYPE] [varchar] (1)
[VIEWID] [varchar] (15)
[FLDPOS] [varchar] (3)
[FCOL] [varchar] (3)
[FROW] [varchar] (3)
[LABEL] [varchar] (20)
[LABELSIZE] [smallint]
[EDITSIZE] [smallint]
[USERID] [varchar] (8)
[NTXNO] [smallint]
[FTYPE] [smallint]
[FLDNAME] [varchar] (10)
[EXPR] [text]
[RECID] [varchar] (15)


Thanks in advance for the help.

-Greg
Back to top
View user's profile Send private message
BobTaylor



Joined: 14 Sep 2007
Posts: 1261
Location: Jacksonville, FL
PostPosted: Thu Sep 27, 2007 4:40 pm    Post subject: Reply with quote
The first thing I'd recommend is to get GoldBox's Demo (if you don't have the program) and run the Filled Field Count report for the Contact1 and Contact2 tables.
_________________
Bob Taylor
Bob Taylor Consulting
(904)745-2903
www.goldboxbob.com
Consulting with GoldMine and GoldBox since 1997.
Also see me at http://www.castellcomputers.com/contactreview/phpbb2/
Back to top
View user's profile Send private message Visit poster's website
Kirk



Joined: 13 Sep 2007
Posts: 447
Location: Seattle, WA
PostPosted: Thu Sep 27, 2007 8:06 pm    Post subject: Reply with quote
You could also use GXbrowser or BR7 or a query to look at Fields5 Fldname entries that beging with a U, but Bob's approach shows you which fields are actually being used. It is fairly common for us to see custom fields that haven't actually been used by anyone for years. It's a good reality check on what is working vs. what seemed like a good idea a long time ago.
_________________
My mind's made up ... don't confuse me with the facts.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Chad Smith



Joined: 13 Sep 2007
Posts: 526
Location: Southeast Michigan
PostPosted: Thu Sep 27, 2007 10:33 pm    Post subject: Re: Finding Unused Fields Reply with quote
GoldMineNinja wrote:
I'm trying to find user defined fields in GoldMine that are not used on any tab.

I'm thinking the Fields5 table will help me with this but it isn't clear what all of the columns in it represent.  Does anyone know of any documentation for this table?

I didn't see it in the Hackers Guide to GoldMine (so we cant remove one potential answer right off Wink

Here's my system info (we run it on SQL Server):

Product = Corporate Edition with GoldSync®
Versions = GoldMine 7.00.60526, Windows NT 5.01.2600 Service Pack 2
Free Disk Space = C: 11,930 MB
Memory (RAM) = 2097 MB
Open Cursors = 13
Tx32 version = 801

FYI, here's the structure of Fields5:

[RECTYPE] [varchar] (1)
[VIEWID] [varchar] (15)
[FLDPOS] [varchar] (3)
[FCOL] [varchar] (3)
[FROW] [varchar] (3)
[LABEL] [varchar] (20)
[LABELSIZE] [smallint]
[EDITSIZE] [smallint]
[USERID] [varchar] (8)
[NTXNO] [smallint]
[FTYPE] [smallint]
[FLDNAME] [varchar] (10)
[EXPR] [text]
[RECID] [varchar] (15)


Thanks in advance for the help.

-Greg


This SQL Query will show you fields in contudef that are not used on any tab (Present in Fields5)

select field_name from contudef where field_name like 'U%' and field_Name not in
(select fldname from fields5 where fldname like 'U%')
_________________
Chad Smith, Lead Consultant
Plain English CRM Solutions

The GoldMine Blog -
http://www.TheGoldMineBlog.com

The GoldMine Guide To SQL Queries -
http://www.GoldMineGuideToSQLQueries.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
GoldMineNinja



Joined: 27 Sep 2007
Posts: 2
PostPosted: Fri Sep 28, 2007 2:25 am    Post subject: Re: Finding Unused Fields Reply with quote
Chad Smith wrote:

This SQL Query will show you fields in contudef that are not used on any tab (Present in Fields5)

select field_name from contudef where field_name like 'U%' and field_Name not in
(select fldname from fields5 where fldname like 'U%')


Thanks, Chad!  That looks ideal.  I'm still wondering why I'm seeing userdef fields in fields5 that I don't recognize.  Is there anything that says which tab they're on?

I guess you're saying that the fact that a field appears in fields5 means that it is used in a tab somewhere, right?
Back to top
View user's profile Send private message
Doug_Castell



Joined: 01 Jan 1970
Posts: 1948
Location: Los Angeles, CA
PostPosted: Fri Sep 28, 2007 4:31 am    Post subject: Reply with quote
I echo Bob's suggestion regarding the filled field count tool in the FREE GoldBox Demo.  It's exactly what the doctor ordered.
_________________
Doug Castell

Now in the Contact Review Forums

Visit my GoldMine tips & tricks blog
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Chad Smith



Joined: 13 Sep 2007
Posts: 526
Location: Southeast Michigan
PostPosted: Fri Sep 28, 2007 11:58 am    Post subject: Re: Finding Unused Fields Reply with quote
GoldMineNinja wrote:
Chad Smith wrote:

This SQL Query will show you fields in contudef that are not used on any tab (Present in Fields5)

select field_name from contudef where field_name like 'U%' and field_Name not in
(select fldname from fields5 where fldname like 'U%')


Thanks, Chad!  That looks ideal.  I'm still wondering why I'm seeing userdef fields in fields5 that I don't recognize.  Is there anything that says which tab they're on?

I guess you're saying that the fact that a field appears in fields5 means that it is used in a tab somewhere, right?


It could be used in a tab or the Top 1/2 of the screen.  If you take a look at the full fields5 table, i.e. select * from fields5 and find the field in question - sort by viewid and that'll show you what other fields are on the same tab as well as the view label, etc...
_________________
Chad Smith, Lead Consultant
Plain English CRM Solutions

The GoldMine Blog -
http://www.TheGoldMineBlog.com

The GoldMine Guide To SQL Queries -
http://www.GoldMineGuideToSQLQueries.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
Radu



Joined: 13 Sep 2007
Posts: 219
Location: Bucharest, Romania
PostPosted: Fri Sep 28, 2007 5:50 pm    Post subject: Reply with quote
have a look at this document:
http://etbsolutions.com/library/Goldmine/GMTableDefinitions.pdf
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    forums.frontrange.com Forum Index -> GoldMine All times are GMT
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group