Good day, How do I make Koha produce a shelflist of items in the library for inventory purposes? There does not seem to be one under Reports. Thanks, David David R. Miner Voice: (850) 644-8107 Assistant In Information Studies Fax: (850) 644-6253 College of Information E-mail: miner@ci.fsu.edu The Florida State University Tallahassee, FL 32306-2100
David, to produce a shelflist, you want a list of your items in callnumber order, right? So that would depend on where you've stored your call numbers. If you use the items.itemcallnumber field for that, then you could use MySQL commands to produce a shelflist. Something like: mysql> SELECT itemcallnumber, title, barcode FROM items, biblio WHERE items.biblionumber=biblio.biblionumber ORDER BY itemcallnumber; If you aren't using itemcallnumber, then you have to do some trickier joins to wherever you are storing the call numbers. It all depends on how you've set your call number mapping. Stephen David Miner said:
Good day,
How do I make Koha produce a shelflist of items in the library for inventory purposes? There does not seem to be one under Reports.
Thanks,
David
David R. Miner Voice: (850) 644-8107 Assistant In Information Studies Fax: (850) 644-6253 College of Information E-mail: miner@ci.fsu.edu The Florida State University Tallahassee, FL 32306-2100
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (2)
-
David Miner -
Stephen Hedges