LSMS Part 2 - Procedure Library Stacks Management System

1. LSMS Part 2 - ProcedureLibrary Stacks Management System Washington Idaho Network January 20 2010 Jan Sung University of Hawaii Nackil Sung Eastern ILL University

2. Equipment X • Computer (Laptop, Netbook, or Desktop) • Barcode scanner • Ethernet code • Long electrical cord (or very powerful battery) • Cart

4. 2nd Life 8

5. 9

6. Software • ODBC • reports.mdb • AA_ShelfLIst • LSMSMacro • LSMS.mdb – the program • Network connection • ready.wav & error.wav (c:\) 2

7. LSMS_Template.mdb

8. LSMS_Template.mdb LSMS feeds LSMS Path automatically! At this level we will take care of Step 1 (Barcode specification) and 2 (ID & password). You need to do this only once.

9. LSMS_Template.mdb: BC Specification Fill the Barcode Length and the Barcode Prefix. Check mark the two boxes on the left. Click Save.

10. LSMS_Template.mdb: ID & x-word The report.mdb should not be running during installation. ID & password: You can leave these blank. Or you can fill only ID. Click Install. Locate where the reports.mdb is.

11. c:\voyager\Access Reports\

12. The report.mdb should not be running during installation.

13. NOTHING HAPPENS Lower your security level

15. Practice – LSMS Template

16. Copy the template to use: KEEP the template as is. Rename Copy and paste

17. Open the copied LSMS (i.e. stacks_N.mdb) The report.mdb should not be running during installation.

18. reports.mdb Location ID = “60” Call Numbers = Between “N” and “P” (Upper Case)

19. Combining locations: 60 OR 47 Ascending – will sort books by location first Not sorted– when books are interfiled

20. Run LSMSMacro (TEST AA_ShelfList) • Generate a sound (BEAP). • Run the query (AA_ShelfList). • 3. Transfer it to LSMS. • 4. Quit report.mdb. LSMS should not be running!!

21. Ready for Shelf-reading / inventory. • Click Start LSMS. • Start / finish the session • with books in good order.

22. Types of problems 1. Scan errors 2. Wrong orders 3. Books with active status 4. Books not found 5. Books without barcodes

23. Scan error Wrong order Found with active status Books not found

24. AA-ShelfList not transferred properly

25. Another Run-time error

26. When ending a session This will trigger to log books not on shelf identified in this session. It will not include books with active status.

27. Book Not On Shelf (1) F11

28. Book Not On Shelf (2)

29. Training Issues Item Enumeration may cause some problems because there is no perfect to way to sort them. 16

31. 32211130947988 18

32. A book found “Charged” on 4/20/07 3:23PM 20

33. it was found where it should be. 21

34. Practice

35. Item not found • First search the book with the barcode. If you were able to locate an item with the barcode, check the call number in the system. • If the barcode does not retrieve any item, search the book with the call number.

36. P Identified as“Item not on shelf” when inventorying P section - I changed its status to “Missing” and “Circulation Review” When inventorying S section,recognized as“Item not found.” 19

37. Extra 1 and 9 missing 9 2 zeros instead of 3 zeros

39. Books-Not-On-Shelf • I separate them into two groups. • One with regular barcodes • One with bogus barcodes such as Nxxxx or TMPxxxx Search them.

40. Books Not On Shelf (BNOS)@Hamilton • Among 43,000 scan in N section • Initial BNOS count 4400 • 1/2 regular BC • (1/3 found, 1/3 not, 1/3 in diff location) • 1/2 N or TMP BC • (1/2+ on shelf w/o bc, etc)

41. TMP, N, or 109 Barcodes

42. all in the shelf-list but not scanned.

43. These analyzed records were not attached to the relevant record.

44. Each one of these was entered as single item under different bib.

45. All added to the relevant physical volumes

46. D7 .B25 II I III IV VI VII VIII X WITHDRAWN!

47. Beacon Lights of History All entered But later all withdrawn X V.9 V.1 – V8V.10 - V.15

49. 5,000 among 40,000 scan