1 / 33

Re-using Metadata from the Voyager Library Catalog – CUL Metadata Working Group – Friday October 19, 2007

Re-using Metadata from the Voyager Library Catalog – CUL Metadata Working Group – Friday October 19, 2007. Tom Trutt E-Reserve & Access Services Specialist Mann Library tit1@cornell.edu. Nick Cappadona Interface Designer Mann Library nac26@cornell.edu. Background.

camdyn
Download Presentation

Re-using Metadata from the Voyager Library Catalog – CUL Metadata Working Group – Friday October 19, 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Re-using Metadata from the Voyager Library Catalog – CUL Metadata Working Group – Friday October 19, 2007 Tom Trutt E-Reserve & Access Services Specialist Mann Library tit1@cornell.edu Nick Cappadona Interface Designer Mann Library nac26@cornell.edu

  2. Background • Problems pulling due date & times for multiple items (Suppressed from OPAC) • Slow response time from the OPAC for reserves searches • Window clutter

  3. Solution 1 • Microsoft Access Database • Used an ODBC connection, via Microsoft Jet • Form Based The Advantages • Allowed access to high use items The Disadvantages • Slow • Yet another open window • Interface issues • Non-intuitive GUI • Not easily customizable

  4. Solution 2 • System tray based program • Written in Visual Basic .NET • Query Voyager’s database directly • OLeDB connection The Advantages • Small footprint • Faster response times • Ability to filter reserves by location • Customizable searches

  5. The Interface Right clicking on the icon will bring up available reports. Runs From The System Tray

  6. Checking Study Room Availability Item Description Current Due Date and Time Overdue Rooms Highlighted In Red Charged Rooms Highlighted In Yellow Free Rooms Are Not Highlighted

  7. Checking Course Reserves Toggles Between Mann Only and All of CUL Course Listing Shows Selected Course Materials

  8. Course Materials Listing Current Status Information, Reserve Location and Owning Location Reserves Item Information Items are color coded as to current charged status

  9. Pull Status by BibID AUTHOR TITLE COPY_NUMBER ITEM_ENUM CHRON CHRAGE_DATE CURRENT_DUE_DATE

  10. In Other Words … Query Query results

  11. Pull Course Listing RESERVE_LIST_ID LAST_NAME FIRST_NAME COURSE_NAME COURSE_NUMBER

  12. An Example Query Query Results

  13. Pull Course Materials ITEM_ENUM DISPLAY_CALL_NO CHRON AUTHOR TITLE LOCATION_DISPLAY_NAME CHARGE_DATE CURRENT_DUE_DATE COPY_NUMBER LOCATION_DISPLAY_NAME

  14. An Example Query Query Results

  15. Meanwhile… • Our Web site was under the knife • Refocused as a research tool • Empowering our patrons • Moonlighting in e-reserves

  16. So what about those patrons? • What if they could check the status of a study room? • Our GPS units and camcorders? • Laptops? • Course Reserves? • And …

  17. Study Rooms

  18. Equipment & Laptops

  19. Course Reserves

  20. Behind the Scenes • SQL + ColdFusion

  21. Tom’s SQL Results are cached for 2 minutes Database connection is predefined in Coldfusion Administrator

  22. Course Reserves: A Slight Twist • SQL + ColdFusion + Javascript + elbow grease

  23. ajaxCFC http://www.robgonda.com/blog/projects/ajaxcfc • ColdFusion framework • Middleman between JavaScript and ColdFusion • Packaged with Direct Web Remoting (DWR) • http://getahead.ltd.uk/dwr • Returns pure JavaScript

  24. Course Reserves • Initial query for course list is handled the same way as equipment and rooms • SQL + ColdFusion  XHTML • Used to populate select field

  25. More on Course Reserves • When a course is selected, a JavaScript function is called path to listener CFC methodName call-back function scriptName argument

  26. The ColdFusion Component (CFC) • Arguments are passed to the CFC methodName Argument (ex. 5309,BIO G 109: Biological Principles,1234)

  27. The ColdFusion Component (CFC) • The selectedReserveID is passed to the secondary query

  28. The ColdFusion Component (CFC) • The selectedCourseID is used to build the link to the e-reserves listing in the library catalog finally, the query results are returned to the page via a JavaScript structure

  29. The Call-Back Function • Resides on the requesting page • Receives the returned results • Incorporates DWR utility functions to alter the page

  30. The Call-Back in Action Determine table heading based on selected course Clear table body with id=“returnedItems” Populate table using DWRUtil.addRows and cellFuncs

  31. The Call-Back in Action

  32. Handy Tools for Circulation and the Web – Endeavor Mid-Atlantic Users Group Meeting 2006 – Hamilton College Tuesday October 3, 2006 Tom Trutt E-Reserve & Access Services Specialist Mann Library tit1@cornell.edu Nick Cappadona Interface Designer Mann Library nac26@cornell.edu

More Related