ShelfLister Real-time Voyager Shelf Lists via Wireless PDA

1. ShelfListerReal-time Voyager Shelf Lists via Wireless PDA Michael Doran, Systems Librarian Ex Libris Southwest Users Group February 6, 2008 – Santa Ana College

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 • Wireless enabled • Barcode scanner-enabled (optional) Handheld device with integrated wireless and bar code data capture. e.g. 802.11b Michael Doran, Systems Librarian

43. Q & A BUT--BUT I’VE TOLD YOU EVERYTHING! Michael Doran, Systems Librarian