460 likes | 547 Views
Wireless Stacks Management. April 30, 2005 Jan Sung & Nackil Sung Eastern Illinois University. wireless?. Hasn’t it always been. We will Cover:. Motivation and Background Systems (Go to Page 38) WSM Process GSU and WSM. Shelf-List in different eras.
E N D
Wireless Stacks Management April 30, 2005 Jan Sung & Nackil Sung Eastern Illinois University
wireless? Hasn’t it always been sung & sung 2005
We will Cover: • Motivation and Background • Systems (Go to Page 38) • WSM Process • GSU and WSM sung & sung - 3 - 2005
Shelf-List in different eras Card Catalog (Late 1880 – c.1980) Early stage of automation – Print shelf-list ILCSO Integrated Library System 1. Print shelf-list 2. Batch file (Collecting Barcodes working on your desk) 3. Real time inventorying (Or near real time) sung & sung - 4 - 2005
History of Inventorying 2005 Sung & Sung hdl.loc.gov/loc.pnp/cph.3c00400c. 1930 - 1950 . . . letters upright with as little slant as possible . . . . . . . take great pains to have all writing in uniform size, blackness of lines, slant, spacing . . . . - Melvil Dewey, 1887 (Library Notes) sung & sung - 5 - 2005
Call Number TA1234 .I52 1925 Author: John Doe Borrower Information John Smith 123456 Due Date: 3/5/1954 Mark books not on the shelf with clips Compare them with check-out Cards sung & sung - 6 - 2005
Generating Print Shelf Lists was quite limited in the past. The Shelf List is not current. sung & sung - 7 - 2005
Collect barcodes using different tools Bring them to the desk Run queries Go back to stacks for corrections sung & sung - 8 - 2005
? Do you run queries on the same day you collect the barcodes? You have to go back to the stacks for corrections. sung & sung - 9 - 2005
Any solutions? Barcodes Scanned Shelf List Active Status List Automatically processed? Out of order Cataloging errors Etc. Find books w/ active status Books not on shelf sung & sung - 10 - 2005
Wireless Stacks Management System ! sung & sung - 11 - 2005
MS Access Database • Shelf List • Active Status List divided into sections to enhance the speed sung & sung - 12 - 2005
Shelf List • Updates daily automatically • Sorted by normalized call # • shelf order or other anomalies sung & sung - 13 - 2005
Active Status List • Updates daily automatically • Use for finding • items with active status Charged Missing In transit Overdue 20+ Categories At Bindery Renewed sung & sung - 14 - 2005
Items not on the shelf Shelf List - Active Status List Items on the Shelf missing Supposed to be on the shelf Scanned List sung & sung - 15 - 2005
Each morning Windows Scheduled Tasks & MS Access Macro Run Queries Activates Update Lists in the WSMS (MS-Access) sung & sung - 16 - 2005
Man on a mission sung & sung - 17 - 2005
When you scan: sung & sung - 19 - 2005
Barcodes scanned Shelf List Active Status List sung & sung - 20 - 2005
Items scanned W = Wrong order N = Item not found S = Scanning error Time of scanning “to the second” Barcodes & Call # sung & sung - 21 - 2005
Results Statistics sung & sung - 22 - 2005
Scanned Barcode x MS Access: Shelf-List Active Status List Voyager Starting May 2005, we do not do Voyager part. Why? Click here. sung & sung - 23 - 2005
Scan the following items. Found “Missing” Out of Order: ND237 .R725 O78 Found “Missing Out of order Was not on the shelf. Found “Charged” Found “Item not found” from a different location: Children’s book center sung & sung - 24 - 2005
WSM_EndUser_2005.avi Shown in EndUser 2005 WSM_onthescreen_NoVoyager.avi Current procedure without a live Voyager Circ Client sung & sung - 26 - 2005
Byproducts sung & sung - 27 - 2005
Cataloging errors 1 sung & sung - 28 - 2005
Cataloging errors 2 NC1135 .C45 C53 NC1135 .D4 D43 NC1135 .C45 N4 ND1135 .C45 N4 Out of order Status“Missing” sung & sung - 29 - 2005
In March, we were doing area. PR PS 3503.O17 K5 1928 “Item Not Found” PS 3537.T3234 S84 no.6 PS 3554.O884 A77 2004 PS 3557 .U82 W5 1983 PS 3557.O326 S7 1995x sung & sung - 30 - 2005
“Renewed” 6 times by a NIU patron Returned 1/10/2005 Returned 12/08/04 Returned 2/9/05 “Missing” as of 2/24/05 sung & sung - 31 - 2005
6 times renewed by a NIU patron 11/6/2003 EIU sent an email to the patron … could not find the book you believe you have returned …. … ask the library at NIU to check their shelves also …. … Other than that, we can only encourage you to check your own shelves again. … sung & sung - 32 - 2005
On 3/21/2005, students brought following items from BTC (children’s section) after a session: sung & sung - 33 - 2005
? In March (2005) a book with a “Missing” status since Sept 2003 • been circulated twice in between Sept 2003 & March 2005 • Four times to correct the status ???? sung & sung - 34 - 2005
Stats as of 5/31/2005 N area • Total scanned: 16,000 • Out of order: 1,640 (9 %) • Item Not Found: 58 (.3 %) (mainly wrong location) • Items w/ status found: 64 • Items not on the shelf: 586 (some found on the shelf – how?) What do these #s mean? sung & sung - 35 - 2005
Challenges Training issue: but people like the procedure because it is interactive and they actually make a difference. Stable Network is always a plus. sung & sung - 36 - 2005
Future Is it? Will publishers put chips in books? sung & sung - 37 - 2005
Systems • MS-Access (WSMS) • Macro Express • Voyager Circulation Client sung & sung - 38 - 2005
Design View 1 sung & sung - 39 - 2005
Design View 2 sung & sung - 40 - 2005
Visual Basic embedded sung & sung - 41 - 2005
Scanning Speed at EIU without a live Voyager sung & sung - - 2005
@ Eastern two students could scan 4,200 items for 5 days when they spent 3 hours a day. If you have 300,000 items to scan • If you scan 3 hours a day • You need 71 days. sung & sung - 43 - 2005
The speed of the project • If it takes 5 (2*) seconds to scan a book • (EIU has barcodes inside books) • You can scan 720 (1,800*) books in an hour. • You need 140 (56*) hours for 100,000 items. • You need 1,400 (560*) hours for 1M items. • You need 140 (56*) days for 1M items, • if you can do it for 10 hours a day. * If barcodes are outside books it will take much less time. sung & sung - 44 - 2005
Books not on the shelf We finally finished N section (16,000+ items scanned). 486 items were recognized as “not on the shelf.” • After checking the shelves and other locations several times where books could have been mislocated, only 17 (0.1% of 17,000 items in this area ) items were not located among 486 items recognized as “not on the shelf.” • Among those items (469) we found later: Just found = 303 2ndbarcode = 89(Another barcodes have been read.) Reserves** = 36 Skipped = 29 (Operators skipped these items.) New books* = 12 (These were in the new book section.) * At EIU new books are shelved in a section called “New Books” for 2-4 weeks but it is not a separate location in the system. Thus, if a new book is shelved here WSM system would not know that it is there. Thus, books in “New Books” will be recognized as “items not on the shelf.” ** Reserves is a temporary location at EIU. Books found with Active Status 66 items found with active status attached: Missing* = 41 Charged = 13 Renewed = 5 Overdue = 2 In Transit = 2 At Bindery= 2 Damaged = 1 (*At the beginning there were 108 books with “Missing” Status in this section.)
www.library.eiu.edu/ download/wsm cfjss2@eiu.edu cfnks@eiu.edu