Tag Archives: blwc

BLWC books on display at Davis Family Library

The Bread Loaf Writers’ Conference has ended, but books by the participating faculty, fellows, and special guests are now available for browsing at the Davis Family Library. Please feel free to stop by the Library lobby to borrow and enjoy these wonderful books. Recorded lectures and readings from the Conference are also available via the College’s iTunes U site.

Update from Database Applications & Systems

This will be my last post as the workgroup leader for the DAS workgroup, as we move into the new organizational structure announced by Mike Roy at the last all-LIS staff meeting.  Here are some of the projects and tasks that DAS staff members have been working on during the past month…

Mike Schuster
– Several Revisions to Room Draw SSB forms and lots of testing
– Added new student search dropdown box and removed boxes used by students to enter group member IDs.
– Modified procedures so as each student is selected, several eligibility checks are made.
– Modified message text displayed when students are ineligible.
– Modified WebTailor Infotext for links.
– Added logic to allow the group representative to remove group members when they’ve accidentally selected one.
– Created a database view of instructors to be used by new online catalog web page.
– Modified web directory script to correctly select on leave graduate students during winter term.
– Created database tables that will be used by custom Monterey web admissions applications forms.
– Assisted the registrar’s office with running the Term Student Type Update program(SHRTYPE) and the Learner Curriculum Conversion Program(SOPLCCV).
– After the registrar’s office runs SHRTYPE for a particular term, I create a population selection in Banner and run SOPLCCV with that popsel.
– Reviewed Clearinghouse Self-Service Authentication documentation and sample code.

Liz Whitaker-Freitas
– Supporting Hyperion BI+ for functional & technical users

Ian McBride (Full list at: https://www.yammer.com/users/imcbride)
– Completed MiddMedia plugin for WordPress
– Assisted with completion of RFP for Web Makeover
– Created conference registration form for VCC
– Developed payment form for Print Management
– Modified Athletics Recruiting application to remove Primary Sport
– Designed database sync script for the Course Catalog
– Launched CSO and Judicial Boards sites
– Upgraded Key Survey to version 7.1

Travis Stafford
– Troubleshooting cForms issue
– Testing cForms 10.3
– Two cforms trainings (Chemistry Department, Institutional Planning and Diversity)
– Finished first wave of BLM implementation (is now live) as well as fixed various bugs
– List Manager Configuration for newsletters / MiddCMS Newsletter support
– General support and Heat tickets

Rob Pekor
– Re-aligned parent Donor codes for “Feb” students.
– Removed obsolete region codes related to “CA Mailing”.
– Enhanced existing “pledge installment” view.
– Investigate poor query execution between databases (production and non-production).
– Created table to hold local data for the Harris Online Community project.
– Sent sample dataset to Harris thus enabling them to begin on data mapping on their side of the implementation project.
– Continued to fine tune the web pages for Phonathon segment creation
– Created new indicator for “young Alumni” (alumni for only 1-10 years) for the Banner List Manager project.
– Create stewardship project codes for Athletics (ATHSTW) and the Axinn Center (AXNSTW)
– Rewrote of slow performing fiscal data view for CA

Chris Norris
Staffing
– Transition planning for organizational re-structuring with DAS staff, Area Directors, and workgroup leaders
Project Work
– Reviewed Phoenix BIA summary presentation
– Drafted spec for remote DR web presence
– Revised Banner-ListManager project requirements with DAS staff
– Revised Broadcast Email Newsletter request document
– Configured four new Broadcast Email Newsletter editions with DAS staff
– Completed work on 2008 Summary Web Statistics for Web Makeover project
– Completed work on Stakeholder Reports for Web Makeover project
– Completed work on GSA (Google Search) for MIIS sites
– Began configuration and setup of Google Apps for Education (alpha instance)
Meetings
– Participated in Web Makeover project team meetings
– Met with HR staff regarding OpenHire “internal job site” project
– Met with Brett Wilhelm regarding departure considerations
– Met with members of the web subcommittee of the Sexual Assault Oversight Committee regarding a new web presence
– Participated in College Advancement Operations team meetings
– Participated in Harris online community project team meetings
– Participated in Pay for Print project team meetings
– Participated in MIIS technology team meeting
– Participated in College Data Workshop with IR, Faculty, and other LIS staff
– Conducted final DAS staff check-in meetings
Systems Administration
– Ongoing monitoring and problem resolution of online services
– Configured new GO rewrite rules
– Ongoing tuning of GSA to improve search results
– Renewals of College-owned domain names
– Transferred UWAC domains to College-managed account
Help, Support, Training, Workshops
– Updated Middlebury’s United Way web presence (campaign stats)
– Provided support for Broadcast Email Newsletters, CMS editing, BLWC Submission Manager, HEAT tix, and various ad-hoc help calls
– Conducted a Broadcast Email Newsletter training with Young Alumni staff
– Conducted a Broadcast Email (advanced) workshop for CA staff
Vendor Related Activities
– Participated in Sun-Guard/SCT Banner DBA weekly status calls
– Participated in Velaris Hyperion SysAdmin weekly status calls
– Participated in Google Apps for Education project team call with Google
– Transitioned Hyperion SysAdmin vendor (Velaris) relationship managment to Jeff Rehbach
– Provided IMA (eCommerce) details for Harris online community project

Update from Database Applications & Systems

Submitted by Chris Norris

Here are some of the projects and tasks that DAS staff members have been working on during the past month…

Mike Schuster
– Created a spec for Bookstore Upload / Course Listing Bookstore Links
– Researched problem Off Campus Study was having pushing Admissions applications
– Corrected problems with Bread Loaf, Language School, and Off Campus Study decisions processing reports, reports were broken due to System 9 upgrade
– Created SSB web package to allow residential systems coordinator to delete room draw preferences, reorder preferences, and activate/inactivate room draw applications
– Processed Fall 2008 course response form data
– Updated Feb’s MNET email addresses to “preferred”
– Fixed problem with LS & BLSE Financial Aid online web applications where bad data entry selection of dates in dropdown boxes would cause applications to get an Oracle error
– Modified custom p_assign_boxes database procedure to allow mail boxes to be assigned to students during winter term
– Worked with Liz Whitaker-Freitas and Marcy Smith to develop documents needed by Monterey staff when developing/requesting new reports

Liz Whitaker-Freitas
– Supporting Hyperion BI+ for functional & technical users
– Troubleshooting Admissions Decisions reports
– Coordinating roles to groups migration by Velaris

Ian McBride
– Added service to check GO addresses nightly
– Worked with Adam to develop web service for MiddTube
– Wrote WordPress plugin for MiddTube
– Developed Middlebury theme for WordPress
– Added a service to the Directory to automatically redirect to a user’s homepage
– Added a video icon to CMS home page news items with videos
– Developed home page for the New England Review site in WordPress
– Began investigation into Single Sign On applications
– Continued work with the Platform and Design/IA groups for the Web Makeover
– Finally launched News Portal at http://go.middlebury.edu/news!

Travis Stafford
– Created 7 new alumni event forms
– Tested WordPress CFORMS upgrade
– Upgraded all the WordPress blogs and cforms to the new version of CFORMS (13 blogs / +/- 50 forms)
– Completed porting over all the cat standard ecommunicate forms to CFORMS
– Minor changes the New England Review ecommerce form
– Troubleshot\Fixed issues with the CCAL Fundraising ecommerce form
– Added new functionality to the BLM application to show Counts by indicator flag for Banner-ListManager admins
– Added self service component to the BLM project for subscribing\unsubscribing to Newsletters and List Manager lists
– CFORMs support/training for various departments
– General support and HEAT tickets

Rob Pekor
– Rolled late graduates to Alumni
– Started developing and creating tables to hold Harris Online Directory data
– Started creating scripts to load initial data for Harris Online Directory
– Started very preliminary development of process to send updates to Harris
– Corrected problem with Phonathon SSB data selection page, page would error on multiple individual years selected, problem has been corrected and is now in production
– Created new function to retrieve a list of regions for a particular person
– Corrected problem in AIA relating to updating ask amounts, if an ask amount never existed before for a person, the SSB page would not update the value, problem has been corrected and is now in production
– Created list of people that currently have access to AIA
– Corrected issue with view for the Banner List Manager relating to the indicator for students

Chris Norris
Staffing
– Participated in telephone interview for open DBA position
Projects
– Reviewed Phoenix BIA reports and summary
– Worked on spec for remote DR web presence
– Participated in CA fundraising strategy meeting
– Refined Banner-ListManager project spec with DAS staff
– Completed work with CA and Communications on Organic Garden giving form
– Met with DOC and PS staff regarding new ER web presence
– Met with technical/functional staff regarding eCommerce options for “pay-for-print”
– Met with Communications staff to plan for upcoming Newsletter projects
– Met with Career Services staff to plan for upcoming Newsletter projects
– Participated in various Web Makeover team meetings
– Met with HR staff regarding Web Makeover requirements
– Met with PHC staff regarding Web Makeover requirements
– Met with PS staff regarding Web Makeover requirements
Systems Administration
– Ongoing monitoring and problem resolution of online services
– Resolved service outages for Banner and Hyperion
– Resolved server config issue for GoogleEarth version of campusmap
– Updated TouchNet server config to support additional web servers
– Upgraded SubmissionManager web application for BLWC
– Configured new GO rewrite rules
– Ongoing tuning of GSA to improve search results
– Renewals of College-owned domain names
– Met with SNS staff regarding HSF config options
Help & Support
– Provided support to CFA staff for artsmail Newsletter IA
– Provided support to HR staff for middleader Newsletter buttons
– Reviewed President’s Holiday Card for pre-sending issues for Communications
– Updated Middlebury’s United Way web presence (campaign stats)
– Updated AbroadView.org web presence (footer)
– Provided various support for CMS editing, HEAT tix, and ad-hoc help calls
Vendor Related Activities
– Participated in Sun-Guard/SCT Banner DBA weekly status calls
– Participated in Velaris Hyperion SysAdmin weekly status calls
– Continued contract re-negotiation with Hyperion SysAdmin vendor (Velaris)
– Worked with DavisProjectsforPeace.org external web vendor to grant direct database access
– eCommerce call with alumni online community vendor (Harris) to define IMA requirements
– Coordinated redirect request from MIIS staff with www.MIIS.edu web vendor (NeptuneWeb)

Update from Database Applications & Systems

Submitted by Chris Norris

Here are some of the projects and tasks that DAS staff members have been working on during the past month…

Mike Schuster
– Ran the SYPAEMH process in production to apply Emergency holds for 394 students
– Modified off campus study, field of study database triggers and package to correctly build the first away term for students with multiple curriculum
– Modified SYPCSCC process for applying class codes to prevent it from including winter credits when calculating current credits and also to only copy specific attributes to future terms
– Worked with Jai Shankar to modify the TSRCBIL FormFusion template to print ‘Do Not Remit’ in a few places on student bills when their total is 0 or a negative amount
– Rewrote the LS Apps by Prior College report
– Diagnosed and fixed a problem where custom database procedures were sending email with a timestamp off by 5 hours.
– Modifications to LS & BLSE Financial Aid online web applications
– Expanded the answer box for the college currently attending question on the LS and BLSE Financial Aid applications
– Added error handling in save supplement procedure to check for nonnumeric characters entered as answers to questions looking for numeric answers
– Added text to top of ls_application and blse_application to tell applicant not to use the enter button.  Changed text for “Save” buttons to “Submit” buttons
– Added text to explanations/special circumstances instructions: “Please limit to 300 characters.”
– Added error handling in save_application procedure to alert user if they didn’t enter a ‘.’ or ‘@’ in their email address
– Created a spec for the MIIS web application.
– Modified Faculty Advisee list SSB form to allow users to email all advisees or selected advisees
– Online Room Draw 2009 modifications
– Several modifications to room draw space maintenance SSB form for residential systems coordinator
– Several modifications to room draw SSB forms for student submitted applications
– Planning conversations with Jeff Rehbach, MBS Books, and Bob Jansen about creating a process to upload course information to the Online Bookstore vendor and modifying the course listing pages to include links to the bookstore software

Rob Pekor
– Put final touches on the Phone-a-thon data interface for College Advancement
– Added keyword descriptor to output filename of the segment data produced
– Enhanced and modified Oracle procedures behind a Hyperion Mailing  report
– Corrected issues with the Volunteer web application (Agents-in-Action) for Annual Giving, problems centered around the field length of the home phone number
– Assisted in fixing problem with online donor roll.
– Created multiple data files for various populations (segments) specified by Annual Giving.
– Analyzing and starting to build specifications for the data feed for the Harris online community project
– Put final touches on the Banner/List-Manager (Broadcast Email tool) integration model with Travis
– This required new function to delineate language school and Bread Load of staff, faculty and students
– Set up volunteer data/assignments for Annual Giving
– Enhanced the Agents-In-Action application to allow input of new ask amounts and assignments
– Created new Oracle package/procedures to allow sending files via FTP from database procedures

Travis Stafford
– Banner/List-Manager Integration project
– Defined types and sub-types
– Defined admin model
– Web Forms
– Supported existing Web Forms
– Ongoing migration of new requests to WPcformsII for BLSE, ACE, RCFIA, HR
– Resolved numerous HEAT tickets and provided support for end-users of online services

Liz Whitaker-Freitas
– Hyperion System 9 Upgrade/Migration
– Resolved several post-migration issues
– Responded to unplanned services outages
– Worked with LIS Staff to develop lab images for new HS9 plugin
– Assisted functional/technical leads with publishing, scheduling and provisioning in new environment
– Researched and resolved connectivity issues with existing queries
– Resolved Oracle Client install issues
– Researched causes of failed jobs
– Tested and deployed Patch/SP
– Cleaned up some custom Roles/Groups
– Worked with Velaris on plan for log archiving
– Resolved report issues (Admissions Data Processing Reports, College Advancement Mailing Reports)
– Other Hyperion
– Trained Tech Lead on how to use derived queries and dashboards
– Trained LS on how to publish and maintain ad-hoc reports
– Processed Hyperion security requests
– Resolved Hyperion HEAT tickets
– Prepared list of services currently being performed by Velaris or Midd staff with recommendations for ongoing support
– Ongoing work for the Lockdown project to change reports using saturn or saturn_midd embedded credentials
– FileMakerPro
– Changed views for Athletics FMP application, troubleshooting issues, change nightly schedules to import view data

Ian McBride (was on CTO for a significant portion of this time)
– Participated in the Web Makeover team meetings and work on the Web Redo project
– Installed a test instance of Drupal CMS for this project
– Finalized the soon-to-be-live new News site for Communications
– Moved all non-CMS web applications off the primary CMS server
– Ongoing work to build out site templates for the New England Review in WordPress
– Developed a web service for system monitoring and backup contacts
– Continued work on a web service API for MiddTube

Chris Norris
– Monitoring and Troubleshooting for Online Services
– Identified and resolved Hyperion issues related to SP1 update
– Researched issue related to Banner INB and IE crashes
– Resolved TouchNet Payment Gateway outages and related issues
– Identified and resolved issues related to recent www –> web forms/services migration
– Monitored Online Course Registration (10 days) and resolved related web issues
– Training and Support for End-Users of Online Services
– Conducted a ListManager-Basics workshop for College Advancement staff
– Conducted a ListManager-Advanced workshop for heavy-use broadcast emailers
– Provided ongoing support for CMS editing, resolved HEAT tickets, answered support calls
– Project Specs / Work Definitions
– Refined Banner List Manager Integration project spec with Travis and Rob
– Helped initiate development of Harris Online Community project spec for Communications
– Completed DAS workgroup SWOT analysis for LIS restructuring efforts
– Revised DAS workgroup goals and objectives for upcoming year
– Ongoing Maintenance & Support
– Processed new GO requests
– Updated Middlebury’s United Way web presence
– Coordinated changes to Monterey’s Online Giving Form
– Reviewed Project Phoenix BIA reports, ongoing planning and specification for remote DR web presence
– Tuned GSA Search to improve keyword matching in search results
– New Projects & Tasks
– Configured SubmissionManager web application for Bread Loaf Writer’s Conference
– Participated in the Web Makeover team meetings and worked on related assigned tasks
– Worked with Advancement and Communications on microphilanthropy test for Organic Garden
– Worked with LIS Budget Administrator to help identify areas for cost reductions
– Worked with LIS Licensing to clarify Hyperion software licensing details
– Worked with LIS Policy Advisor to clarify PCI-compliance status
– Worked with Dean of the College and Directory of Public Safety on new Emergency web site specification
– Vendor Related Activities
– Participated in Sun-Guard/SCT Banner DBA weekly status calls
– Participated in Velaris Hyperion SysAdmin weekly status calls
– Initiated contract re-negotiation with Hyperion SysAdmin vendor (Velaris)
– Transitioned DavisUWCScholars.org and DavisProjectsforPeace.org site management duties to external vendor