Hi all,
We do an annual production of A Christmas Carol, and when I inherited the show building and reporting processes I found that previous employees at our company had added a new title for each individual year as opposed to adding new productions/production seasons under the existing title. This makes cross-year reporting ever so slightly more annoying (instead of filtering by one title I have to filter by eleven). Is there any way to consolidate all of the productions under one title retroactively? I've seen other forum posts about changing the production season of a performance with a SQL process, which I'm willing to do, but it'd be more convenient to move the productions themselves to the same title as opposed to each performance to a new production season under the same title.
Thanks in advance!
Martin,
What you are wanting can be done, and it is basically the same sort of process of moving production seasons, just at a higher level. Tom Brown and I had a forum thread going a while back about this as well where we discussed a number of the issues and thoughts behind such a process; you might have come across that one in your searching.
It will basically involve, as you mentioned, a bit of SQL. The big thing about that is that you will have to recreate the ticket history for all of those events once you move them. I have a document created that has the steps pretty much mapped out as well as most of the SQL needed to accomplish the task, though of course I encourage you to read through it yourself and test it in the TEST database before you deploy it in LIVE. Also you will have to be careful of any lists, extractions, scheduled jobs or scheduled reports, but that seems to be your reason for doing this, so it sounds like you would be on top of that.
Send me an e-mail if interested, jmoskal@thecenterpresents.org.
John