Community
Showing results for 
Search instead for 
Do you mean 
Reply

Fields - List of All

Accepted Solution Solved
New Member
Posts: 2
Country: USA
Accepted Solution

Fields - List of All

I'm attempting to reorganize my data and make sure that I have all of the appropriate fields that I would need.  How do you print a list of all fields associated with your database?  I have exported a contact to a text delimited file, but of course, that gives you a column header.  It obviously spreads across many pages.  There must be an easier way.

Accepted Solutions
Solution
Accepted by topic author Beach4obx
‎09-25-2015 03:20 AM
Moderator
Posts: 4,395
Country: USA

Re: Fields - List of All

To be more specific, follow the steps below to access a couple field list reports.

 

- Go to Start and select Run.

- Type actdiag and click Ok.

- Select Database -> Database list

- Find your database name and click to highlight

- Right click the name and go to Database Structure.

 

You will see number of field reports.  What you're looking for should be the Fields Summary or Field Usage Analysis Report.

 

 

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Fields - List of All

ACTDiag
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Solution
Accepted by topic author Beach4obx
‎09-25-2015 03:20 AM
Moderator
Posts: 4,395
Country: USA

Re: Fields - List of All

To be more specific, follow the steps below to access a couple field list reports.

 

- Go to Start and select Run.

- Type actdiag and click Ok.

- Select Database -> Database list

- Find your database name and click to highlight

- Right click the name and go to Database Structure.

 

You will see number of field reports.  What you're looking for should be the Fields Summary or Field Usage Analysis Report.

 

 

Nickel Contributor
Posts: 220
Country: USA

Re: Fields - List of All

open ACTDiag.  Go to  Start|Run and type in "actdiag"

 

In ACTDia open the database list. Highight your database and right click

 

On the menu that opens, select Database Structure|Fields list to CSV File

 

On my machine this opens excel with a chart of all the fields and their attributes. Im using ACT V11.0.0.367

 

It might be a little different in earlier versions but its in there.

 

 

 

Matt Pulsts
Your Intown Handyman
Atlanta, GA