Has anyone exported a show out of a fixed season order into a new order to switch the facility. What kind of issues did people run into with reporting, or possible double reporting of revenue?
We just got done doing this. We created a dummy season. In that season we created a dummy performance that used the new facility. Export out of the original performance into excel modify the seats to their new locations if the current rows or seats between the new and old facility do not match. Then do the import. We then rolled from the dummy performance into the new subscription.
If you are using price type mapping between the two packages, I would just drop a comp price map onto each price type in the dummy performance.
Another option using the same dummy setup as above, is to manually seat the patrons into the dummy performance instead of doing the export and then do the rollover. I would do this route if there isn't a ton of subscribers.
By doing this in a dummy season and performance, it is easy to separate out that this not real revenue and does not show up under any real season's reports.
Marty Jones
Director of Information Services
Omaha Performing Arts1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nichole MinesSent: Tuesday, May 10, 2011 11:42 AMTo: Martin A. JonesSubject: [Tessitura Ticketing Forum] Import/export and reporting
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!
Hi Marty
I have a related question. We have a run of perfs we want to move from one GA facility to another.
I was going to try using Import/Export but I'm unclear what happens (if anything) to the 'exported' order in the original perf and how payments are handled, so i would be interested to hear from anyone who has tried this scenario.
It feels like we're going to end up with a copy of the original perf but all the original data including payments remains in that perf? And should i be using a dummy payment method in the import set - if you use a 'real' payment method does that generate a posting?
Otherwise is there some other means of cancelling/refunding all orders in a perf and re-creating them in a new facility/perf?
Peter,
When you export, all you are doing is taking a copy of the information from the original performance. The export will not change anything in the original orders or performance.
Now with the import and as long as you are not talking about the new orders being part of a rollover, you would just import into the real performance.
There is no magical way to cancel/refund the original performance. You will have to touch each order and do the return from there.
These are the steps that I would do.
1. Export the original performance to Excel
2. Return the seats in each order and put the money on account
3. Modify the seats in the Excel file to match the new facility.
4. Import the Excel file into the new facility using the on account money payment method
<insert disclaimer here!> I have not done tried a import using On Account payment methods so not positive if this would work or not. Hopefully, someone from Tessitura can vouch for this.
If all of this is for a rollover, then this will change how you would do this and I can go into detail if this is the case.
Hope this helps,
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Peter NelsonSent: Thursday, May 12, 2011 12:23 AMTo: Martin A. JonesSubject: RE: [Tessitura Ticketing Forum] Import/export and reporting
I was going to try using Import/Export works but I'm unclear what happens (if anything) to the 'exported' order in the original perf and how payments are handled so i would be interested to hear from anyone who has tried this scenario.
From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>Sent: 5/10/2011 12:53:01 PM
Actually, there is a magical way to refund the original performance. You can use the Performance Seat Release utility, which will return all seats and put the money on account. So you would run that after you do your export.
I’m not sure about using an On Account payment method in an order import. It probably would work. Ryan, do you see any reason why it wouldn’t work?
Kevin Sheehan
Senior Documentation & Learning Resources Specialist
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Marty JonesSent: Thursday, May 12, 2011 9:42 AMTo: Kevin SheehanSubject: RE: [Tessitura Ticketing Forum] Import/export and reporting
No virus found in this message.Checked by AVG - www.avg.comVersion: 10.0.1375 / Virus Database: 1500/3633 - Release Date: 05/12/11
The Order Import Utility, unfortunately, only takes the following payment types:
Check(3), Cash(5), Adjustment(6), or Other(7)
Unfortunately, as it stands, no on account.
-Ryan
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin SheehanSent: Thursday, May 12, 2011 10:02 AMTo: Ryan CrepsSubject: RE: [Tessitura Ticketing Forum] Import/export and reporting
And that’s why you ask the guy who wrote the code, not the guy who wrote the documentation. J
So you pretty much have to use some sort of dummy/write off payment method. You could use the Performance Seat Release utility to release the seats, but you are going to end up with all that money stuck on account, and the only way to remedy that is manual processing.
Peter, you said you are moving from one GA facility to another. Since they are GA, why do you need to make a move? I’m just wondering if there might be some other way to accomplish your ultimate goal.
I actually tried posting to on account in our test environment and it did work.
Is your On Account payment method using an On Account Payment Type? The utility will fail before importing the file if it is.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nichole MinesSent: Thursday, May 12, 2011 12:22 PMTo: Ryan CrepsSubject: RE: [Tessitura Ticketing Forum] Import/export and reporting
From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>Sent: 5/12/2011 9:18:17 AM
Okay so now I am nervous because the on account payment is an on account payment type and it didnt fail. Our test is a copy of our live, so the setup is exactly the same.
Thanks everyone, all very interesting info.
Marty – its not a rollover scenario so what you described sounds like what we’re dealing with.
Kevin - while they’re both GA seating they are two different Facilities (ie two different theatres at our venue). The original is always GA, the one we’re moving to is a ‘flexible’ space that has a GA block which can be used in lieu of the set seating configs. We black out all seats except the GA when being used like this.
We want to move it so remaining inventory sold (plus the historical data on sales already made) reflects where the performances will actually take place.
Ryan – re the payment method. Still not clear for the imported orders if we used a ‘real’ payment method (such as cash) would those payments be ignored by that days postings?
So if I’m understanding the conversation we could:
1. Export the data from original perf
2. Use the Performance Seat Release utility to refund the orders, and put monies on account
3. Import the orders seated unpaid into the new perf
4. Have Box Office process the new orders manually using the “on Account” payments
Will check with Box Office whether they think this will work …
Peter Nelson
Business Analyst, Information Systems
T 02 9250 7180 M 0401 714 246
Sydney Opera House Bennelong Point
GPO Box 4274 Sydney NSW 2001 AUSTRALIA
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin SheehanSent: Friday, 13 May 2011 00:37To: Peter NelsonSubject: RE: [Tessitura Ticketing Forum] Import/export and reporting
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=====
Hey Ryan,
I'm wondering, is there something special about On Account pmt method types that make them a bad idea/not work in this scenario? I mean, other than that the order import utility was written to exclude that type? is there something else that goes on when an on account payment is made that doesn't happen with other payment methods that the means by which the utility "pays" wouldn't cover, so it had to be excluded? Or is it just to avoid problems if the amount in the import file exceeds the amount the patron actually had on account?
I’ve done the whole performance release and the monies went back to on account just fine.
Nichole Mines
Ticketing Data Manager
1326 5th Ave
Seattle Wa 98101
From: Tessitura Ticketing [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda FreemanSent: Friday, December 09, 2011 11:39 AMTo: Nichole MinesSubject: RE: [Tessitura Ticketing] Import/export and reporting
I wondering, is there something special about On Account pmt method types that make them a bad idea/not work in this scenario? I mean, other than that the utility was written to exclude that type? is there something else that goes on when an on account payment is made that doesn't happen with other payment methods that the means by which the utility "pays" wouldn't cover, so it had to be excluded?
The only real reason is because it was never added as a feature. The entire import is a pretty complex beast. We opted not to include this and other payment options when it was developed because it wasn’t a priority. It’s a great enhancement though.
+Ryan Creps
+Tessitura Network
From: Tessitura Ticketing [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda FreemanSent: Friday, December 09, 2011 2:39 PMTo: Ryan CrepsSubject: RE: [Tessitura Ticketing] Import/export and reporting