In anticipation of a quick decisive answer, I need some assistance with lists.
I have made a two lists of constituents, both lists manually tweeked and NOT regenerated - lets say list HBT and list LTN. Both lists are based on our fairly imprecise post codes which is why I have had to edited the lists manually (other Australian users will no doubt understand this). I want to get a list of addresses which does NOT include those on list HBT and list LTN - call that list Rest of TAS. I made a third list with all Tasmanian post code, suppressing (& "not in" & "does not have") HBT & LTN.
I have tried several lists and extractions to arrive at "Rest of TAS", to no avail. The Rest of TAS list, whether it is generated in list manager or by extraction consistently includes constituents from list HBT and list LTN and I'm at my wit's end.
HELP!!
Hi Darrell
I've feel like something similar to this should work:Criteria to pull TAS addressesList DOES NOT HAVE HBT ListList DOES NOT HAVE LTN List
The important thing is keeping the HBT and LTN list criteria separate from eachother.
If that isn't working for you, this could be a quick extraction. Use the HBT and LTN lists as suppressions and then pull the TAS addresses.
Wow. Scratch that. I haven't had my morning caffeine yet...
If you're going the list route, having them as separate DOES NOT HAVE criteria will only exclude people if they are in both lists. So you'd want them to be together instead.
The extraction idea should work pretty good though. That's how I would do it.
Good luck (and apologies for Beth's morning brain jumping in a little too early!)
To make it really explicit, I'd go with four lists
Your HBT and LTN lists
Another list called TAS, perhaps, which is everybody with a Taswegian postcode.
and then your final list, called TASBUSH, maybe, that has two criteria
Making sure that all of the Household stuff is unticked, to keep it Pure.
That's a bit painstakingly inelegant, but it helps if you can check the intermediate steps.
Or Beth's suggestion of using an extraction, of course - that should also work fine, and also let you examine the intermediate results if you need to.
Ken
Lol Beth – caffeine ain’t any help to me with this! I have tried extractions with same result – constituents on the lists that have suppressed are still included in the list generated by the extraction.
DARRELL JONES | Assistant Box Office Coordinator | Tasmanian Symphony Orchestra Pty Ltd
1 Davey Street, Hobart, Tasmania | GPO Box 1450 Hobart, Tasmania
Tel 03 6232 4404 | Email jonesd@tso.com.au | Website www.tso.com.au
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Wednesday, 8 October 2014 2:48 AM To: Darrell Jones Subject: Re: [Tessitura Ticketing Forum] Lists
From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com> Sent: 10/7/2014 11:35:40 AM
I've feel like something similar to this should work: Criteria to pull TAS addresses List DOES NOT HAVE HBT List List DOES NOT HAVE LTN List
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Ken,
Thank you – following your suggestion and noticing a criteria in the HBT & LTN list that I had entirely OVERLOOKED (!!!) I have arrived at a list we can use!!
Many thanks
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ken McSwain Sent: Wednesday, 8 October 2014 11:08 AM To: Darrell Jones Subject: Re: [Tessitura Ticketing Forum] Lists
From: Darrell Jones <bounce-darrelljones8445@tessituranetwork.com> Sent: 10/7/2014 12:54:21 AM
Yes, but that view shows Household and we cannot tell if we need to add titles, if we need to swap A1 and A2.
From what I see when looking at Content view we would need to open every account to see if it requires correction.
Marina Dowling
Office Manager
BIG ARTS
900 Dunlop Road
Sanibel, FL 33957
Phone:(239) 395-0900
Fax: (239) 395-0330
mdowling@bigarts.org
www.bigarts,org
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch Sent: Monday, April 24, 2017 1:33 PM To: Marina Dowling <mdowling@bigarts.org> Subject: Re: [Tessitura Ticketing Forum] Lists
Marina,
You can simply just click on Contents with the list highlighted in List Manager and do the same thing without having to run a report. Both the customer number and name are hyperlinked from the contents to go into the patron file.
Michele
From: Marina Dowling <bounce-marinadowling2925@tessituranetwork.com> Sent: 4/24/2017 1:11:18 PM
I recently created a list of all patrons who purchased tickets with us this season. Report is 117 pages long. Ran the list from Reports & Utlilities - Lables and Letters - User Defind Format..." Looks great on screen. We are then able to double click the patron that needs a correction and save (cleaning up address format). Worked great until page 36...at this point we lose the ability to drill into customer record from screen. Has anyone encountered this problem?