« September 2007 | Main | November 2007 »

October 23, 2007

SWRRTLY - Mod

I modified the report SWRRTLY so that it now accepts wildcard '%' for the term code. SWRRTLY is a scheduled section tally report (courses, credit hours,etc) sort of like the web based section tally (SWWXWEB) but you can run it for specific terms.

Posted by soukupm at 5:13 PM | Comments (0)

SPRTELE non-standard update

I did a non-standard update on SPRTELE to remove any "MA" type phones and "R" type phones. The MA phones were used a long time ago for test score loads and usually got removed but somehow these few got left in the table. The "R" type addresses are invalid phone types that somehow got left in the sprtele table (may have been from a load, most of which were over 10 years old). The "R" phones are now "PR" type.

Posted by soukupm at 5:00 PM | Comments (0)

October 15, 2007

New Job Submission: SZRRSTR

I created a new job submission in Banner this week called SZRRSTR. It displays class rosters based on term code/division/deparment/schedule code. For now, it's mainly used to keep track of "By Arrangement" courses but it could be used for keeping track of labs, lectures, etc. The output is student id,name,term,crn,subject,course,title,division,department, credit hours and instructor.

Posted by soukupm at 2:53 PM | Comments (0)

October 5, 2007

Mreport: rewriting statistics version 1

The original report was written over ten years ago and needed some updating and some new categories added that the 1st page report current contains (new freshman, freshman transfers and continuing freshman). Right now, we're currently supporting both versions, the first page report (written in perl: this is the web based report) and the long report (written in ProC). After looking at the code which was a bit hard to read, I figured it probably would be best to rewrite it so it's easier to support in the future. This will take me some time to complete because there's 11 reports in total. But once it's completed, we'll only have to support one version of the report.

Posted by soukupm at 3:33 PM | Comments (0)

October 3, 2007

Banner - Invalid Certificate (expired)

I ran into a problem today where a user was getting an invalid certificate error message in Internet Explorer when trying to run Banner INB. It turned out to be the user's system date had changed back to 2003 so was giving an expired certicate error message when you browse the website. Fixing the system time corrected the error.

Posted by soukupm at 3:25 PM | Comments (0)