1 / 42

ShelfLister Real-time Voyager Shelf Lists via Wireless PDA

ShelfLister Real-time Voyager Shelf Lists via Wireless PDA. Michael Doran, Systems Librarian. Where do we get Voyager data?. Voyager data sits on the server, but to get at it we need a Voyager client... Acquisitions Cataloging Circulation WebVoyage reports.mdb etc.

vaughn
Download Presentation

ShelfLister Real-time Voyager Shelf Lists via Wireless PDA

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. ShelfListerReal-time Voyager Shelf Lists via Wireless PDA Michael Doran, Systems Librarian

  2. Where do we get Voyager data? • Voyager data sits on the server, but to get at it we need a Voyager client... • Acquisitions • Cataloging • Circulation • WebVoyage • reports.mdb • etc. Michael Doran, Systems Librarian

  3. Where do we go to get Voyager data? To a computer... ...on a desk ... (generally) in an office. Michael Doran, Systems Librarian

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

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

  6. But wouldn’t it be nice... If we could access Voyager data with a wireless-enabled hand-held device? Palm Pocket PC That was the thinking behind ShelfLister... Michael Doran, Systems Librarian

  7. ShelfLister, a mobile Voyager client Beta version • Proof-of-concept mobile client • Server-based web application: • no specialized client software • any operating system • Only requirements: • browser • internet connection • Optimized for use by hand-held devices: • Palm • Pocket PC Michael Doran, Systems Librarian

  8. ShelfLister... • 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 “mark” items Michael Doran, Systems Librarian

  9. Michael Doran, Systems Librarian

  10. Start barcode End barcode Info on • Books that are there • Books that aren’t there Michael Doran, Systems Librarian

  11. Shelf list in call number order • Charge statistics • Item status (code) Michael Doran, Systems Librarian

  12. Michael Doran, Systems Librarian

  13. Michael Doran, Systems Librarian

  14. Start barcode End barcode Michael Doran, Systems Librarian

  15. Michael Doran, Systems Librarian

  16. Gap on the shelf Michael Doran, Systems Librarian

  17. 2nd page 3rd page Michael Doran, Systems Librarian

  18. Michael Doran, Systems Librarian

  19. Michael Doran, Systems Librarian

  20. Michael Doran, Systems Librarian

  21. “Marking” items Categories are configurable Michael Doran, Systems Librarian

  22. Michael Doran, Systems Librarian

  23. Flat file of “marked” records 2004-10-05 14:21:53|187970|212386|199426|31334701154102|Missing|BF 1 .P7 v.101 1994 2004-10-05 14:22:28|187970|212386|199426|31334701154102|Missing|BF 1 .P7 v.101 1994 2004-10-14 19:48:43|953216|1018840|1126370|31334021100751|Circ Review|QA76.73.P22 H64 2001 2004-11-02 10:41:32|947548|1013054|1089337|31334020531782|Send to Annex|QA76.73.P224 H84 2001 2004-11-08 08:18:50|654226|709861|821328|31334005997461|Send to Annex|PR 5686 .H26 1991 2005-1-07 13:42:14|932412|997093|1076695|31334020276149|Send to Annex|QA76.73.P22 D47 2000 2005-2-27 16:26:04|821424|882518|959880|31334019701693|Send to Annex|QA 76.73 .P22 S655 1997 2005-2-27 16:34:04|1033626|1106868|1156207|31334021279738|Cat Review|QA76.73.P22 D89 2003 2005-2-27 16:34:30|932722|997326|1076368|31334020278046|Send to Annex|QA76.73.P22 G84 2000 2005-2-27 16:34:46|994203|1060518|1134441|31334019919311|Send to Annex|QA76.73.P22 P37 1998 2005-3-10 08:35:18|1086561|1224369|1195767|31334020931552|Cat Review|QA76.73.P224 R67 2003 2005-3-10 09:54:58|947548|1013054|1089337|31334020531782|Circ Review|QA76.73.P224 H84 2001 2005-3-10 17:56:29|654226|709861|821328|31334005997461|Send to Annex|PR 5686 .H26 1991 2005-4-02 17:48:26|947035|1012585|1088217|31334020525677|Lost|QA76.73.P224 S39 2001 • File resides on Voyager database server • Download flat file to PC • Import into MS Access Michael Doran, Systems Librarian

  24. Import flat file into MS Access Michael Doran, Systems Librarian

  25. Run a “Make Table” query Michael Doran, Systems Librarian

  26. Export results to a text file Michael Doran, Systems Librarian

  27. Use as input file for “Pick and Scan” For more information, see the online tutorial, Importing "Marked Items" file into MS Access Michael Doran, Systems Librarian

  28. The one-book shelf list Michael Doran, Systems Librarian

  29. 31334020525677 Michael Doran, Systems Librarian

  30. Periodicals Michael Doran, Systems Librarian

  31. Michael Doran, Systems Librarian

  32. Michael Doran, Systems Librarian

  33. Michael Doran, Systems Librarian

  34. Michael Doran, Systems Librarian

  35. Michael Doran, Systems Librarian

  36. Michael Doran, Systems Librarian

  37. Known Issues • HTML forms and back button quirkiness • In some browsers, on some platforms, when you use the navigation ‘back’ button, form data and/or ‘checked’ place holder the form boxes may be blank • MFHDs with multiple pieces, some without an item record • If a holdings record has multiple physical pieces associated with it, any pieces without an item record will not appear on the shelf list Michael Doran, Systems Librarian

  38. Michael Doran, Systems Librarian

  39. Michael Doran, Systems Librarian

  40. Additional Information http://rocky.uta.edu/doran/ Michael Doran, Systems Librarian

  41. Download, install, and configure Michael Doran, Systems Librarian

  42. Requirements • On Voyager database server: • ShelfLister.cgi Perl Perl DBI / DBD::Oracle modules • In Library: • Wireless infrastructure • Clients (Handheld/Tablet/Laptop): • Browser • 802.11 wireless enabled • Barcode scanner-enabled (optional) Handheld device with integrated wireless and bar code data capture. Michael Doran, Systems Librarian

More Related