Addresses and the Month Array List Criteria

Hi Andrea,

This might be a long way to get what you want, but here’s a possible solution.

Create a basic list of people you would want to send information to and use this list to run the User Defined Format from a List.  Run this report two times, once with mailing date set for Oct and then again for Nov and export each report as its own excel/text file.   You can then filter each file for only those who have an address in the area.  Combine the filtered results into one file and import the customer_no back into Tessitura as a list.  Any duplicates will automatically be eliminated and you will then have a list of those who have indicated that they are in the area for either Oct. or Nov.   (you could also put it into Microsoft Access to clean up the list.)

(This should work if you use the check boxes for months, as I believe that when you put in any mailing date for Oct, it will pull all addresses for October for the Mailing Purpose that is checked in the report.  If you are using a start date for an address, that could pose a problem, if you type in Oct. 1, and the start date is Oct. 15, it would not pull that address.  And if anyone has better insight into the months and dates, please let me know.)

Hope this might help you.

T.C. Brown

Database Administrator

412.392.4834

Greetings!

I'm writing from a Festival Opera Company in FL, meaning a good portion of our patrons are snowbirds and only live here from Jan-March. We recently added a fall production to our schedule and I'm trying to work with List Manager to get a list of our patrons who live here in Oct and Nov. 

Because of our snowbird situation, we've kept our addresses and the usage of Months pretty clean.

Does anybody have any suggestions for a list or report to isolate these patrons who live in FL in the fall?

I'm playing with the "Month Array Jan thru Dec" list criteria and I'm struggling, mostly because I "don't care" about their location Dec-Sept, it can be "Y" or "N" and it doesn't matter as long as Oct and Nov are "Y".

For the record,  I don't have regular access to a DBA, I can only really work with front-end procedures.  

Any suggestions or advice would be very helpful. Thank you for your time!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!