Tag Archives: search

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
– 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)
– 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

Google Search Appliance for MIIS

We’ve just added a new Search interface to our Google Search Appliance, this one for the Monterey Institute of International Studies. The frontend uses a custom stylesheet to get the GSA interface to look like the rest of the MIIS site, which updated its design last week. The web applications that Middlebury hosts for MIIS (the Directory and the Online Giving Form) were updated to this new design yesterday. We index content on the following MIIS sites:


The “All” collection includes, well, all of those, while the last four have custom search collections that let you refine your query. I waited to make this post until we’d indexed enough content. We’ve got about 5000 pages indexed currently and I’m betting there will be more by tomorrow. Generally it takes a full day to reindex the content of an institution-level website like Middlebury’s or MIIS’s.

You can get directly to the MIIS search interface by going to this URL:


You can also have a form on your website that lets people search the MIIS site through the GSA. Here’s some basic HTML code that allows you to do this:

<form method=”GET” action=”http://search.middlebury.edu/search”>
<input type=”hidden” name=”site” value=”all” />
<input type=”hidden” name=”client” value=”miis_frontend” />
<input type=”hidden” name=”proxystylesheet” value=”miis_frontend” />
<input type=”hidden” name=”output” value=”xml_no_dtd” />
<input type=”text” name=”q” />


Searching Options and Updates from Library Systems

Submitted by Mike Lynch

Thanks to Ian McBride for making it possible for us to add a Search Midcat box to the top of web pages on the LIS website. We will also be able to add a Search LIS box, but we are still working with Ian to determine exactly what that will search. Jeff Rehbach added the Search Midcat box to http://www.middlebury.edu/academics/lis/lib/. We are also testing a Search Metafind box.

Mike Lynch & Barbara Merz gave a training session to Andy Wentink, Danielle Rougeau, and Kristina Simmons on constructing custom queries in ContentDM. This should allow them to build a web page reflecting their archival organization scheme with search links to ContentDM.

We are experimenting with LibraryFind, an open source application which allows search across multiple sources. Although it’s not ready for public consumption just yet, we are making it available for testing by LIS staff at http://libraryfind.middlebury.edu/record/search. If you click on Advanced Search (http://libraryfind.middlebury.edu/record/advanced_search) you’ll see three choices: Digital & Print Undergraduate Theses, Images & Multimedia, and Middlebury College Abernethy Collections. The first choice searches all of the NITLE Dspace thesis collections, as well as the Special Collections thesis database on Concerto. The second searches 12 different collections, some in ContentDM and some in Concerto. The third searches the Abernethy Collections on ContentDM