Community
Contact us | Act.com
turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Reply

Housekeeping-Identifying unused Drop Down Lists

mbudzyn
Tuned Listener
mbudzyn
Posts: 10
Country: United States

Housekeeping-Identifying unused Drop Down Lists

‎09-22-2009 05:35 AM

Greetings all,

 

Does anyone know of a way to identify a drop-down list that is not being used in any fields?

 

We had migrated a bunch of Act 6 databases, with custom fields and drop downs over into ACT 2009 Preimuim. We then sliced/diced and purged fields and layouts, etc. Now we have a lot of drop down lists--some of which are getting used--but most are not.

 

I want to remove the unused ones, but don't have a way to identify which aren't linked. Any help, suggestions, or places to look?

 

Thanks!

Report Inappropriate Content
Message 1 of 2 (1,531 Views)
Reply
0 Kudos
Moderator
Moderator
dlunceford
Posts: 4,395
Country: USA

Re: Housekeeping-Identifying unused Drop Down Lists

‎09-24-2009 12:44 PM

You can run the Field List to CSV report and look at the picklist column.  This will show all lists that are currently being used.

 

On the server, follow the steps below.

- Go to Start and select Run

- Type actdiag and click Ok

- Select Databse > Database List

- Select your database.

- Go to Actions >  Database Structure > Field List to CSV file.

 

Report Inappropriate Content
Message 2 of 2 (1,485 Views)
Reply
0 Kudos