Populating Season Manager

(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

 

(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