All Purchasers List

Rob,

Have you looked at the Order Export Utility?  This report has the information you listed below but provides perf code instead of perf name along with a myriad of other information.  If you were to run this report with a list saved from order search you may be able to pull the information you are looking for.

Be well,

Jean

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Rob Munday
Sent: Tuesday, August 09, 2011 1:32 AM
To: jeanr@sjrep.com
Subject: [Tessitura Next Generation Forum] All Purchasers List

Working for a ticketing agency that sells for external events, one of the most regular tasks I have to perform is pulling a list of all purchasers for that event. This list will always have to contain:

1. Order No
2. Constituent name
3. Constituent address
4. Performance Name
5. Number of Seats
6. Price Type (preferably the name instead of the code)

Currently, I am performing an extraction, saving the results to a list and using a custom output set to export the results as an excel file. However, the file usually contains the complete ticketing history of the constituents that have booked for this event, instead of just their bookings for this particular event.

I am obviously doing something wrong, as I feel in Tessitura this should be a pretty standard operation to perform, but as I'm fairly new to the system I am unsure of the best way to do this.

If anyone can offer any advice on the best way to perform a task like this, it would be most MOST appreciated.

thanks in advance.

Rob

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Rob,

Have you looked at the Order Export Utility?  This report has the information you listed below but provides perf code instead of perf name along with a myriad of other information.  If you were to run this report with a list saved from order search you may be able to pull the information you are looking for.

Be well,

Jean

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Rob Munday
Sent: Tuesday, August 09, 2011 1:32 AM
To: jeanr@sjrep.com
Subject: [Tessitura Next Generation Forum] All Purchasers List

Working for a ticketing agency that sells for external events, one of the most regular tasks I have to perform is pulling a list of all purchasers for that event. This list will always have to contain:

1. Order No
2. Constituent name
3. Constituent address
4. Performance Name
5. Number of Seats
6. Price Type (preferably the name instead of the code)

Currently, I am performing an extraction, saving the results to a list and using a custom output set to export the results as an excel file. However, the file usually contains the complete ticketing history of the constituents that have booked for this event, instead of just their bookings for this particular event.

I am obviously doing something wrong, as I feel in Tessitura this should be a pretty standard operation to perform, but as I'm fairly new to the system I am unsure of the best way to do this.

If anyone can offer any advice on the best way to perform a task like this, it would be most MOST appreciated.

thanks in advance.

Rob

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!