1 / 61

Unlocking Your ILS Data Mobile access via handheld devices

Unlocking Your ILS Data Mobile access via handheld devices. Michael Doran, Systems Librarian doran@uta.edu. LITA 2009 National Forum Salt Lake City, Utah October 3, 2009. Where do we get our ILS data?. Integrated Library System.

bina
Download Presentation

Unlocking Your ILS Data Mobile access via handheld devices

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. Unlocking Your ILS DataMobile access via handheld devices Michael Doran, Systems Librarian doran@uta.edu LITA 2009 National Forum Salt Lake City, Utah October 3, 2009

  2. Where do we get our ILS data? Integrated Library System • Our ILS data sits on a server, but to get at it we need an ILS client... • Acquisitions • Cataloging • Circulation • OPAC • Reports • etc. Woo-hoo! Got SQL*Plus! This will fix things! SQL> DROP DATABASE xxxdb; Michael Doran, Systems Librarian

  3. ILS data – the gate keepers cataloging client acquisitions client circulation client “data” mobile client OPAC 1 Michael Doran, Systems Librarian

  4. Where do we go to get the ILS data? To a computer... ...on a desk ... and for non-OPAC data, (generally) in an office or behind a counter. Michael Doran, Systems Librarian

  5. Working in the trenches stacks Michael Doran, Systems Librarian

  6. You could carry your PC with you Michael Doran, Systems Librarian

  7. But wouldn’t it be nice... If we could access ILS data with a wireless-enabled hand-held device? Windows Mobile Palm iPhone and iPod Touch any smart phone WiFi or cellular data networks 1 Michael Doran, Systems Librarian

  8. …not only for OPAC access… Innovative Interface’s “AirPAC” catalog Michael Doran, Systems Librarian

  9. …but also for staff Stacks maintenance would be so much easier if I could look up stuff on a handset. Michael Doran, Systems Librarian

  10. A vendor perspective John McCullough, “Redesigning Library Applications for PDAs: ILS Vendor Perspective.” Library Hi Tech, 21:4 (2003), p. 396. “At this time Innovative is releasing a wireless OPAC interface and developing wireless solutions for staff applications” “Offline circulation suggests itself […and…] Inventory of the physical collection is a second area of great interest in PDAs.” “Innovative Interfaces is currently developing a wireless Inventory product which will use a PDA to read barcodes using Bluetooth and populate an HTML form on a Web browser on the device. This form will then submit the barcodes over a wireless connection to the library database server and will return a response to the device indicating item status, whether the item is out of shelf order, and giving the option to dynamically, and from within the stacks, update the item record itself.” 1 Michael Doran, Systems Librarian

  11. 2004 – originally released as Wireless Workstation 2008 – rebranded as Circa Vendor products for staff use Innovative Interface’s “wireless solution for inventory and circulation functions” SirsiDynix’s PocketCirc client “for circulation and inventory functions” • 2004 – Unicorn ILS version • 2009 – Horizon ILS version Note: dates are approximate 1 Michael Doran, Systems Librarian

  12. Back to the future… 2009 2008 2007 2006 2005 2004 2003 Circa & PocketCirc AirPAC Where’s my @#$% handheld app! 7 Michael Doran, Systems Librarian

  13. Waiting for Godot the vendor How long must we wait for a handheld client for our ILS? …or one that doesn’t cost us extra dough? …or one that does what we want? 4 Michael Doran, Systems Librarian

  14. Waiting for Godot the vendor • Vendors are smart and competent • Aware of the growing demand for mobile data access • Have an intimate knowledge of the ILS systems • Have crackerjack programmers • So what’s the hold up? • ILS product life cycle – saturation stage • No good pricing model for mobile clients • Vendor/ILS programming paradigm: • One client/app that does everything • Mobile device programming paradigm: • Many clients/apps that do one thing well Michael Doran, Systems Librarian

  15. Back to the future… Inventory, SQL, Perl, wireless network, PDA, …bingo! 2009 2008 2007 2006 2005 2004 2003 “…developing a wireless Inventory product which will use a PDA to read barcodes … and populate an HTML form on a Web browser … then submit the barcodes over a wireless connection to the library database server and will return a response to the device indicating item status…” 1 Michael Doran, Systems Librarian

  16. ShelfLister 1.0 – released in 2003 • Generates a shelf list • shelf list - a file of bibliographic records arranged in the • same order as the corresponding materials on the shelves • Additionally, includes any or all of... • Item status • Historical charges • Historical browses • Enhanced call number information And allows user to save item information for batch updating ILS Oooohh 1 Michael Doran, Systems Librarian

  17. 2 Michael Doran, Systems Librarian

  18. ShelfLister 1.0 Start barcode End barcode Minimize data entry 4 Michael Doran, Systems Librarian

  19. 2 Michael Doran, Systems Librarian

  20. 2 Michael Doran, Systems Librarian

  21. Use as input file for bulk updating ILS 2 Michael Doran, Systems Librarian

  22. Paging Mr. Godot… All this time, we’ve been waiting for the vendor to provide us with (and charge us extra for) handheld apps. We could have been developing them ourselves. But wait… we still can! 3 Michael Doran, Systems Librarian

  23. Rocket scientists This is not the Library Systems staff at the University of Texas at Arlington. Michael Doran, Systems Librarian

  24. UT Arlington Library Systems staff …before our first cup of coffee in the morning Michael Doran, Systems Librarian

  25. So, if we can do it, you can do it If I just knew what button to push! Michael Doran, Systems Librarian

  26. All it requires is an “open” ILS system They told me I didn’t need to know what was inside. Michael Doran, Systems Librarian

  27. All it requires is an “open” ILS system This presenter really knows how to flog a metaphor. All I see is an empty box… where are the donuts? Did I say “donuts”? I meant data. Michael Doran, Systems Librarian

  28. …and the “Four Knowings” • Know your ILS data • Know the available APIs • Know what you want to do • Know how to (web) program It’s really quite simple! Michael Doran, Systems Librarian

  29. 1) Know your ILS data The leg bone’s connected to the knee bone… • Relational database system • data dictionary – “a list of all the tables in the database and all the fields in the tables” • entity-relationship diagrams – “a graphical representation of database entities and their relationships to each other” • mental model of data • BLOBs and other problems Michael Doran, Systems Librarian

  30. ShelfLister – 1st knowing “Know your ILS data” Voyager ILS Oracle Database It’s all up here, baby! data 2 Michael Doran, Systems Librarian

  31. 2) Know the available APIs Application Programming Interface • Web services (XML, SOAP, RESTful, y.y.) • Aleph : “X-Services” • Voyager : Web Services • Your ILS : ??? • Library protocols • Z39.50 ISO/ANSI/NISO Information Retrieval Protocol • 3M SIP (Standard Interchange Protocol) 2.0 • NCIP (NISO Circulation Interchange Protocol) • DLF’s ILS Discovery Interfaces recommendation • Database connection • e.g. Oracle/MySQL/etc. listener Protocols… boor-ing! 1 Michael Doran, Systems Librarian

  32. APIs – getting around the gate keepers cataloging client acquisitions client circulation client “data” Oracle listener NCIP server web services Z39.50 server OPAC 4 Michael Doran, Systems Librarian

  33. Which API should you use? All I see are zeros and ones! • What data can it read • database connection – everything! • web services, library protocols – eh, not so much • What data can it write • database connection – (effectively) nothing • web services, library protocols – it depends • Mix and match • Response times/latency Michael Doran, Systems Librarian

  34. ShelfLister – 2nd knowing “Know the available APIs” 2009 Voyager ILS 2008 2007 Web services 2006 2005 Voyager ILS 2004 2003 Oracle Database Oracle listener listener data 3 Michael Doran, Systems Librarian

  35. 3) Know what you want to do • Public access • Mobile OPAC? • ???????? • Staff access • Inventory tool? • ??????? • Be ambitious • But not too ambitious (at least the first time) Michael Doran, Systems Librarian

  36. ShelfLister – 3rd knowing “Know what you want to do” Free the data! 2 Michael Doran, Systems Librarian

  37. 4) Know how to (web) program • I.e. server-side, not client-side • Java • C/C++ • Ruby • PHP • Perl • Lisp • bourne shell • whatever… You must code in Perl. It’s the Law. Just kidding! Use whatever you want! 1 Michael Doran, Systems Librarian

  38. ShelfLister – 4th knowing “Know how to (web) program” shelflister.cgi Voyager ILS Oracle Database Perl DBI/DBD::Oracle listener SQL queries form generation, data munging, and formatting output data 3 Michael Doran, Systems Librarian

  39. ShelfLister – 4th knowing “Know how to (web) program” Web programming… heh, that’s not a real iPhone app! • “Most of the folks I know in app development are moving to standardization on web versus device specific development.” • Linda Woods, AT&T Education Advocate • Industry & Mobility Application Solutions • comment at 2009 Handheld Librarian Online Conference 1 Michael Doran, Systems Librarian

  40. You can (and should) do this Getting something to beta would only take me a couple weeks. If that imbecile Doran could do one… How hard could it be? ...and maybe a case of Red Bull. 1 Michael Doran, Systems Librarian

  41. The Tao of mobile web design A mobile web app should do one thing and do it well. A mobile web app must be as simple as possible, but no simpler. • standards compliance • web usability design • minimal user (data) input • design and testing • cross-browser • cross-platform Michael Doran, Systems Librarian

  42. Mobile design - browser compatibility Chrome Internet Explorer Firefox 2 Michael Doran, Systems Librarian

  43. XHTML/HTML/CSS validation • XHTML/HTML • CSS • Accessibility Get right with these before you get to the platform compatibility. 3 Michael Doran, Systems Librarian

  44. iPhone web apps (according to Apple) • Three types content: • compatible with Safari on iPhone • optimized for Safari on iPhone • iPhone web application • W3C standards compliant • no framesets or • unsupported technologies • “Most of the folks I know in app development are moving to standardization on web versus device specific development.” • Linda Woods, AT&T Education Advocate • Industry & Mobility Application Solutions • comment at 2009 Handheld Librarian Online Conference 2 Michael Doran, Systems Librarian

  45. Mobile design – platform compatibility viewport 4 Michael Doran, Systems Librarian

  46. Mobile design – platform compatibility 3 Michael Doran, Systems Librarian

  47. Mobile design – platform compatibility Larger buttons for finger tapping 1 Michael Doran, Systems Librarian

  48. Handheld emulators/simulators Operating System • Generally come with handheld OS SDKs • webOS (Palm) • http://developer.palm.com/ • iPhone (Apple) • http://developer.apple.com/iphone/ • Android (Google & Open Handset Alliance) • http://developer.android.com/ • Web-based simulators (be leery) • Opera Mini Simulator – good • http://www.opera.com/mini/demo/ • TestiPhone.com – absolutely worthless Software Development Kit Michael Doran, Systems Librarian

  49. Handheld emulators/simulators Opera Mini Palm Android iPhone 3 Michael Doran, Systems Librarian

  50. Mobile design – platform compatibility 2 Michael Doran, Systems Librarian

More Related