Import/export and reporting

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?

Parents
  • 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 Arts
    1200 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 Mines
    Sent: Tuesday, May 10, 2011 11:42 AM
    To: Martin A. Jones
    Subject: [Tessitura Ticketing Forum] Import/export and reporting

     

    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?




    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?



    [edited by: Peter Nelson at 12:19 AM (GMT -6) on 12 May 2011]
Reply
  • 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?



    [edited by: Peter Nelson at 12:19 AM (GMT -6) on 12 May 2011]
Children
No Data