« Hey, I'm Outta Here | Main | Comments »
August 4, 2006
I'm Back at the BLOG
Hi. Well, it's been awhile since I've Blogged anything, so thought this would be a good time to get started again.
The sleepy summer days have been replaced with a maniacal pile of work demanding to be accomplished. Some of the projects I'm working on right now include:
A new report for the Mailroom that shows totals for coded mail for either the current month, or the previous month. There is some clever code in there that figures out what "last month" was, no matter what day you ask for the report. I'll put that out in a future blog to see what you think.
A couple SWAMP forms need some minor modifications. A new search item needs to be added the the pre-req history form, and the employee form needs a minor change to put some input into upper case. The employee change came about as a result of modifying the charge-out rate for the physical plant (sorry, rest of campus)....
The bookstore had three point upgrades that needed doing. Last night I did two of them, and there is one more to go. The main upgrade performed last night modified our POS (it's not what you think, it stands for Point of Sale) system to comply with legal requirements for safely handling credit card data. That upgrade has been successfully installed, so we are in full compliance with the regulations for safely handling credit card information. Next week I'll be installing MBS point upgrade 2006.1, which is a series of minor program enhancements and bug fixes.
Dale and I have been working on our Oracle DBA skills on most Thursdays, and this week he helped me code up part of the Mailroom's report for SWAMP. I had the bright idea of showing Dale how SWAMP is put together so he could be a backup for me, and this coding project was a good introduction.
Another project I'm working on is cleanup of SWAMP data. We have some historical data that was migrated to SWAMP from the old FAMIS program that needs cleaning, and also some open PO's and prereq's that have accumulated over time. These don't really cause any problems with the day to day operations, but they could if we don't keep the data up to date - especially with the queries that rely on our historical data.
Posted by rossm at August 4, 2006 2:12 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)