Determining # records in database

Thank you Levi!

Barbara

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
Sent: Thursday, January 23, 2014 11:30 AM
To: Barbara Pinney
Subject: Re: [Tessitura Technical Forum] Determining # records in database

Barbara,

I would suggest running the NCOA Processing utilityin Export mode.  This should produce a summary report that tells you how many addresses are included in the file.  This will give you a much more accurate idea of what your costs will be than you would get if you simply counted the number of accurate constituents or the number of active addresses.  It will also give you a head start when the time comes to actually do the updates.

I'd spend some time reading through the documentation on the NCOA Processing utility before you dive in.  But it should give you the information you are looking for.

- Levi

If you are talking about constituent records you can create a list of all constituent numbers greater than 1.  When you generate the list it can tell you how many constituents you have.  If you have the addresses cleaned you may want to not clean all- exclude constituents that have not bought tickets in the last 5 years, exclude board members and people with higher membership levels. It will save you some money and possible heart ache.

Jason Song

IT Manager

Scottsdale Cultural Council

P 480.425.5340

C 480.529.4653

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Barbara Pinney
Sent: Thursday, January 23, 2014 10:19 AM
To: Jason Song
Subject: [Tessitura Technical Forum] Determining # records in database

I'm investigating address hygiene services and I'm not sure how to determine how many records are in our database.

Any suggestions? I do not know SQL.

Thanks.

Barbara Pinney

Tulsa Arts Management Consortium

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thank you Jason – excellent suggestion about excluding key constituents.

Barbara