Populating Season Manager

Are you referring to the Season Overview in the Season Manager?  If so, there are a couple common causes for this.  The first is that the new season has not been added to the parameters of the Season Overview load job.  The second is that the Display EIS indicator is not checked for the season in question in TR_SEASON.  You should also make sure that your FY periods are set up in TR_BATCH_PERIOD.

 

If the issue does not appear to be one of these things, I would suggest opening a support ticket in TASK.

 

Gregg Stickney Application Support Specialist/Manager Knowledgebase Tessitura Network www.tessituranetwork.com gstickney@tessituranetwork.com +1 (888) 643-5778, ext. 318 (Office) +1 (330) 835-4507 (Fax) +1 (330) 696-0373 (Mobile) +1 (888) 643-5778, ext. 201 (Support Line)

 

 

 

State Theatre in New Brunswick here...We are having an issue with getting our newly formed 2011 season to populate in the season manager. The season is set up and we are selling tickets successfully, but no data for the fiscal year or the season is populating in the season manager. Any thoughts on how to remedy this? Please advise and thanks, dg

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!

Make sure that under the TR_Season table, that Display Eis is checked and look at your EIS_IMP_CHANGED_LOAD_NEW procedure and make sure that the season id is in that. I think you have to run the procedure with a scope = 'f' first then you can change it to 'I'.

 

Now I am assuming you are talking about Season Overview which is under Season manager. If not, forget everything I just said.

 

Marty

 

Dan,

 

Do you have the “Select Date View” radio buttons set properly at the bottom?  (I have to ask – this gets people confused here).

 

 -steve carlock

Information Technology Manager

The Granada

jsc@granadasb.org

(805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

(805) 899-3002 (fax)

(562) 239-7075 (cell)

 

 

 

State Theatre in New Brunswick here...We are having an issue with getting our newly formed 2011 season to populate in the season manager. The season is set up and we are selling tickets successfully, but no data for the fiscal year or the season is populating in the season manager. Any thoughts on how to remedy this? Please advise and thanks, dg

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!

Make sure that tr_season has the Display Eis box checked for the appropriate season and that the season has been added to the job that populates your season manager screen (executing lp_EIS_IMP_CHANGED_LOAD_NEW @scope=’F’ for the seasons you want).

 

Lucie

 

 

State Theatre in New Brunswick here...We are having an issue with getting our newly formed 2011 season to populate in the season manager. The season is set up and we are selling tickets successfully, but no data for the fiscal year or the season is populating in the season manager. Any thoughts on how to remedy this? Please advise and thanks, dg

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!

(What does this say about me – I went with user error right off…..)

 

Just to pile on a little more – here is the code that I stole from someone that I use for my EIS_IMP_CHANGED_LOAD_NEW job so I don’t have to remember to update it every season  (this is the nightly job):

 

declare @seasons varchar(256)

declare @strsize int

select @seasons = ''

select @seasons = @seasons + convert(varchar(3),id) + ',' from tr_season where inactive = 'N' and display_eis = 'Y'

-- select @strsize = len(@seasons) – 1

select @strsize = len(@seasons)

select @strsize = @strsize - 1

select @seasons = substring(@seasons,1,@strsize) + ''

 

exec eis_imp_changed_load_new @scope = 'F',

                @season_str = @seasons,

                @include_resold = 'Y'

 

 -steve carlock

Information Technology Manager

The Granada

jsc@granadasb.org

(805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

(805) 899-3002 (fax)

(562) 239-7075 (cell)

 

 

 

Dan:

1) Check to see that the data's set to show up. If the "Display EIS" column for the season in TR_SEASON isn't checked, then data won't be shown in Season Overview even if it's being calculated.

2) Check to see that the data's getting in there to begin with. Season overview is populated by a stored procedure, EIS_IMP_CHANGED_LOAD_NEW, which accepts a string of season numbers (the ID column from TR_SEASON). If the job that runs this population procedure hasn't been updated with the ID for your 2011 season, then Season Overview isn't being populated. Updating and re-executing that job will fix that problem. 

Hope this helps,

Jonathan

 

Select access order is by event