Order export /import utility

Kareen,

There is an upcoming  webinar scheduled on this very topic. I share your questions and have already signed up!

Ray

 

 

Hi all,

Just wondering if anyone has used this function yet. We're thinking of moving an entire show in one facility into a new facility. How has it worked for you? Is there anything that I need to consider (ie. unseat patrons, etc.) that I would have to do before starting the process?

Thanks in advance!

--
View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/1781/6283.aspx#6283
--
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!

Kareen,

There is an upcoming  webinar scheduled on this very topic. I share your questions and have already signed up!

Ray

 

 

Hi all,

Just wondering if anyone has used this function yet. We're thinking of moving an entire show in one facility into a new facility. How has it worked for you? Is there anything that I need to consider (ie. unseat patrons, etc.) that I would have to do before starting the process?

Thanks in advance!

--
View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/1781/6283.aspx#6283
--
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!

From what I hear, it’s going to be a great webinar (although I could be slightly biased).  I’m aware of a few licensees that have been testing or are planning to use these utilities.  Hopefully someone will chime in here about their experiences.

 

Glad to hear that you’ve signed up!

 

In advance, for your reading pleasure, there is a 35 page document on Order Import Utility:

http://www.tessituranetwork.com/network/Learning/Documentation/Reports/Ticketing%20Processing/Order%20Import%20Utility.aspx

There are several pages devoted to planning considerations and setup.

 

and if you are so inclined, there is a slightly smaller document on the Order Export Utility:

http://www.tessituranetwork.com/network/Learning/Documentation/Reports/Ticketing%20Processing/Order%20Export%20Utility.aspx

 

And, if you haven’t yet signed up for the webinar…that registration would be here:

http://www.tessituranetwork.com/network/Learning/Webinars/Upcoming%20Webinars/Order%20Import%20and%20Export.aspx?reg=%2fnetwork%2fLearning%2fWebinars%2fUpcoming%2520Webinars.aspx

 

Hope that helps!

-Ryan

 

Hi Kareen

 

We have used the Import side of it a lot already although not specifically for the purpose you describe.

 

We’ve used it for:

1.     Creating guided tours ‘series’ bookings: Managing a single constituent’s requests for multiple tour slots across a 12 month period – used to take many hours per customer; now needs maybe 20-30 minutes spreadsheet setup then runs in 30 seconds.

 

2.     Seating opening nights based on info collected in an Activity. We used to do a single bulk “opening nights” Order, and then hand allocate and envelope.

Now we can seat every constituent in individual orders based on their Activity RSVP status. This means we now have names on collect dockets, printed in alpha order, with seat history saved – it’s a beautiful thing. This again required some spreadsheet action but nothing too difficult.

 

Only little issue we came across is the section in the import. This uses the Short Description from tr_section which we tend to use for generic descriptors such as “Stalls”, “Circle” etc and which are often repeated across multiple sections. This caused the import to fail because it just chose the first instance of this in the table which usually wasn’t the right one.

 

So it meant we had to use the TR_IMPORT_SECTION_MATCHUP table to essentially translate the full section description to the actual section of exactly the same name. Once we identified the issue didn’t take long to do this setup.

 

Good luck with your project …

 

peter nelson business analyst

information systems

pnelson@sydneyoperahouse.com

T+61 2 9250 7180  F+61 2 9251 7821 

 

SYDNEY OPERA HOUSE BENNELONG POINT

GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

SYDNEYOPERAHOUSE.COM

 

 

The thing is we need to do it for this weekend(!) and the webinar is next week. But I'll let you know how it goes!!!

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!

Please consider the environment before printing this email.
=====This message is intended for the addressee(s) named and may contain confidential information.
If you are not the intended recipient, please delete it and notify the sender.
Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====