« January 2006 | Main | March 2006 »

February 24, 2006

Weekly Update: Registration, Banner 7.2 Testing

I've sent out the registration emails this week but ran into problems early on with the soremal job submission aborting. I eventually figured out which records that were causing the problems and fixed them. I added some new troubleshooting hints to the readme file in web_reg to solve the common problems.

I've been doing Banner 7.2 testing on Dev this week. I moded a few more packages that I didn't already have in my original mod list.
BWCKFRMT
BWCKGENS
BWCKSCHD
BWLKOIDS
BWCKOTRN
BWGKOGAD
BWLKADVR

I also have a new way to identify slow cursors. Registration is working properly now with the mods in and I was able to successfully register a batch of 10 students that I'll be using to test fee assessment with.

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

February 23, 2006

More efficient way to identify slow cursors on banner web

With some help from Jeremy at OUS, I have a new way of identifying slow cursors on banner web so that we can fix them. In the I:\programmers\Banner SIS folder, there's a file called "How to find slow cursors on web.txt" that explains what to do to find these cursors. This will save us many hours (possibly days) of searching for those elusive cursors when we upgrade.

Posted by soukupm at 04:10 PM | Comments (0)

February 17, 2006

Weekly Report

Here's some of the tasks I've been working on this week:
Modified SWFRWUE job submission: This report only displayed vnumber and name. Now it displays vnumber,name,field of study,PR address, LO address, WU address, Academic standing,Overall attempted credit hours, Overall Earned credit hours.

Created new job submission SWBRDT5: Report that displays nonzero balances by detail code and term code.

Created registration groups for Spring term. I'll be sending out registration emails next week.

Modified admissions WUE report: I added two new field, application start date and application end date so that admissions can get a list of students based on the date they were admitted.

Added new fields to SIS BIQuery: I added SATW,SATR,HS_CODE,HS_GRAD_DATE,HS_PERCENTILE to TERM_APPLS.


Posted by soukupm at 03:35 PM | Comments (0)

February 16, 2006

Curriculum: Double Major Problem

While I was rewriting the job submission SWFRWUE for Financial Aid and adding some new columns to the report, I came across a student that had a double major and one minor that was being misreported in my report. I was using the new curriculum code from our research table to fetch the major codes and on this specific person, it fetched their second major. What we want to do is fetch the row where sorlfos_priority_no = 1 for the first major. The second major is incorrectly stored in Banner but for the meantime, it is set to sofrlfos_priority_no = 2.

Posted by soukupm at 03:08 PM | Comments (0)

February 10, 2006

Health Insurance Report

I've been working on a new web based health insurance report to replace the existing one. The old report required that you connect to the object server, run a query, copy and paste to a new document, run another query, save that to another document, transfer both files to a unix/linux/or windows machine with grep then run a perl script that creates a new text file which you import into excel and save. With this new report, you just need to go into banner web, run the report(wou_misc.p_health_insurance) and copy and paste into excel and save.

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

February 09, 2006

Sectall duplicating problem

Sectall is a section tally web app that displays the current enrollment per class based on term and division code. There's two different versions of this app that exist: one on Aero (http://www.wou.edu/facultyinfo) for staff and one on Banner Web for faculty.

It seems that this app has been duplicating classes on both reports. There's a cron that runs in the morning called swwxweb that builds a table for this application. This is where the duplicates were happening. I traced it down to the table slbrdef, which contains the information about buildings/rooms. This table is now using a term code effective so we'll want to select the max(term_code_eff) to get a single row.

Posted by soukupm at 03:59 PM | Comments (0)

February 03, 2006

Weekly Report: Labels, Email Address Update,Faculty Evaluations

This was a busy week for label requests by several departments for enrolled students, medical holds, etc. I have a blog back in June that explains the options for this report. There's also a way to convert these labels to a csv file for people that want a file instead to create their own labels. The program is called lbl_flatfile.pl and instructions on how to use it is in the readme.reports file.

I finished up an email update procedure to streamline the process to update goremal addresses. It's under my schema called student_email.p_email_update_from_reg. It accepts a term parameter and updates all email addresses for all students enrolled that term.

Note to self: There's a web based faculty evaluations that outputs in csv format. It's under my schema called faculty_evaluations.p_fac_eval_select.

Posted by soukupm at 02:42 PM | Comments (0)

February 02, 2006

Unofficial Transcripts

We had a problem printing unofficial transcripts this week and we traced it down to the special print option on job submission. These are special control codes that tell the printer to print in a different mode from its default, such as print in portrait mode, print using a certain font, etc. It seems that some of these codes are incompatible with some printers. So if you an error "ERM-LONGTAB: Table width exceeds containing column width", more than likely the user is using the special print options and it doesn't work with the printer they selected.

Posted by soukupm at 01:31 PM | Comments (0)