Faculty Dashboard and Banner 8
We recently upgraded our Banner DB to version 8.2. Ever since that upgrade we are having the following issues with our Faculty Dashboard channel:
1) Fall 2010 courses are defaulted into this channel, no matter what we select in the 'From Term'
2) The channel can only display 8 courses, any more and an instructor must link into SSB to get a full listing of their courses.
For instance, if an instructor teaches 5 courses in the Spring, and 5 in the Fall, we do not have a way to display all 5 Spring courses without going into SSB. I've attached a screen shot of the our channel for reference.
Has anyone else experienced this issue?
Same issue here
We have the same issue. The character set changed from Banner 7 to 8. Therefore, less characters fit in the pl/sql varchar2(32000) variable.
The official problem is described in: Defect 1-5FWTVA and defect 1-912j7e. The correction is included in patch p1-912j7e_bwl8030001 which can be applied to Faculty Self-Service 8.3.
We did not want to upgrade to Faculty Self-Service 8.3 only 1 week after upgrading to Banner 8. Therefore, we made these changes to use the "workaround".
The change to implement the workaround is in the bwlcxchn package body.
In bwlcxchn.f_get_dashboard_xml
Look for: ELSIF (clob_length > 32000) THEN
and change to: ELSIF (clob_length > 8191) THEN
Look for: ELSIF (clob_length > 1) AND (clob_length < 30000) THEN
and change to: ELSIF (clob_length > 1) AND (clob_length < 8191) THEN
recompile bwlcxchn body and the workaround is installed. A link will be displayed if the XML string is too long. This is not a solution, but a workaround.
We use same workaround
We'll second that workaround. It's better than the error you get without it, but note that the limit on the "more" link is still pretty small (I think we get up to about a dozen) and, if that limit is exceeded, the user is presented with yet another link that ends up at an SSB page. The problem is this second link is a fairly small line of text, so we've had a lot of calls from faculty insisting that clicking on the *first* more button is still broken because they don't notice they have to click a second link.
Good times.
Chris
Resolved
After working with SunGard support, I've come up with a way to get the correct semester courses to display without future ones getting in the way. The way to do this is to edit the $BANNER_HOME/facweb/dbprocs/bwlcbre1.sql file. The edits are as follows:
Within the following FUNCTIONS:
f_get_dashboard_count
f_get_dashboard_term
f_get_dashboard_subj
You will need to change all of the lines that read:
ssbsect_term_code >= nvl(p_termcutoff, '%')) AND
to:
ssbsect_term_code = nvl(p_termcutoff, '%')) AND
By removing this '>' parameter it allows instructors to select terms from the options within the channel, and they will be able to view all of the courses they are teaching in that semester, so long as they don't teach more than 7-8 courses.
Hope this helps anyone who has experienced this same issue.
Jonathan
crn's in dashboard
Your screenshot of your faculty dashboard includes CRNs. Would you mind sharing how you did that?