Lists

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

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 Ken McSwain
Sent: Wednesday, 8 October 2014 11:08 AM
To: Darrell Jones
Subject: Re: [Tessitura Ticketing Forum] Lists

Hi Darrell

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

• List - IN - TAS
• List - Does Not Have - ( HBT, LTN) 
  • [you can add more than one List to the List criterion by using control-click]

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

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!!

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

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 Ken McSwain
Sent: Wednesday, 8 October 2014 11:08 AM
To: Darrell Jones
Subject: Re: [Tessitura Ticketing Forum] Lists

Hi Darrell

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

• List - IN - TAS
• List - Does Not Have - ( HBT, LTN) 
  • [you can add more than one List to the List criterion by using control-click]

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

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!!

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!