Hi folks. When I built out our 0910 season I did not have titles and so set up our 5 productions in the following way:
Title: 0910 PlayMakersProduction:(one for each production)OpusNicholas Nickleby, Part 1Nicholas Nickleby, Part 2, etc.Production Season: (again, one for each production)OpusNicholas Nickleby, Part 1Nicholas Nickleby, Part 2, etc.Performance: set up as expected
Now we want to combine the two parts of Nickleby into one production. I really don't want to rebuild all the Part 2 shows in the Part 1 Production and Production Season, cancel my rollovers and rerun them, etc. as this causes me pain and tears.
Has anyone had to do anything like this? I was thinking we could update T_Prod_Season and replace Part 2's prod_season_no with Part 1's prod_season_no for the 19 affected performances. I think that scared my Tessi IT friend, and I'm not really in the business to do that. Any ideas? Thanks!
Carli WebbPlayMakers Repertory Company
Hi Carli
It's possible to move performances from one season/production to another - we had to do a few in our initial setup because we got it wrong the first time - but it's a database backend thing, and has to be done fairly carefully.
I'd suggest you ask your friendly local Tess Network support person to help you do it.
Ken
you can do something to check out whether you can update the t_prod_season table.
1,copy LIVE database to TEST.
2,in management studio, right click impresario database
go to Tasks ,then go to Genarate Scripts, you can select tables only and save them into ONE file. (there are 900 tables, it will take a while. it took me 40 minutes to get the script file.)
3,in the saved file, you can do search "prod_season_no"
exclude local table:
TW_PROD_SEARCHt_imp_perf_dataT_PERFT_PROD_SEASON
these four tables are only must to be updated.
in our setup also T_INVENTORY has prod_season_no match inv_no show the title of the performance.
local tables also need to be updated if they are in the list.
4,beware of triggers.
Finally, most likely, you can do the update.
t_perf and t_prod_season you can have to mannually update them.
t_imp_perf_data can be update by [EIS_IMP_CHANGED_LOAD_NEW] with a full update parameter. TW_PROD_SEARCHit is link to web API. so it should be auto updated. if you right click the table then "view dependcies" there are four wp_ stored procedures linked. So the work list is: 1,update t_prod_season 2,update t_perf 3,update T_INVENTORY (where prod_season_no=inv_no) 4,run EIS_IMP_CHANGED_LOAD_NEW with full update.( it should be in the SQL Job list) 5,update TW_PROD_SEARCH 6, update local tables if they are the list. Do it in test first. I am 90% sure all these will work. :-):-):-)
[EIS_IMP_CHANGED_LOAD_NEW] with a full update parameter.
TW_PROD_SEARCHit is link to web API. so it should be auto updated.
if you right click the table then "view dependcies"
there are four wp_ stored procedures linked.
So the work list is:
1,update t_prod_season
2,update t_perf
3,update T_INVENTORY (where prod_season_no=inv_no)
4,run EIS_IMP_CHANGED_LOAD_NEW with full update.( it should be in the SQL Job list)
5,update TW_PROD_SEARCH
6, update local tables if they are the list.
Do it in test first.
I am 90% sure all these will work.
:-):-):-)
Thanks Ben, this is awesome and exactly what I needed!!
Carli