Hello, all! Please excuse the use of the terminology from my former ILS, Innovative. I cannot find the analog in Koha. My library and I are new to Koha and are just learning it. I have set up a library with libraries, branches, collections, etc. I now find that I have to do a mass change of empty shelving locations to a general shelving one; i.e., 952$c, previously blank, will be filled with the general shelving code. I have watched several versions of the ByWaters Solutions tutorials on YouTube, and I'm stuck. I understand the proper command is Tools -> Batch item modification. I also understand the need to compile the relevant items into a list of item (ID) numbers. Unfortunately, I cannot find in the documentation instructions on how to compile such a list. I also cannot find instructions through a web search. Can someone help me? Is there a tutorial on compiling item lists, bib. record lists, patron lists, etc.? Thank you very much for your help. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
Excerpts from Charles Kelley's message of 2019-10-14 18:18:16 +0900:
Can someone help me? Is there a tutorial on compiling item lists, bib. record lists, patron lists, etc.?
I believe that generating of lists is usually done with reports. See this section of the Koha manual: https://koha-community.org/manual/19.05/en/html/reports.html Also see this page, which shows many sample reports: https://wiki.koha-community.org/wiki/SQL_Reports_Library
In particular, the SQL you will need is likely: SELECT itemnumber FROM items WHERE location IS NULL OR location = '' That will give you a simple list of item IDs that do not have an associated shelving location ("location" in the database's terms). If you're on a modern version of Koha, there will even be a "batch modify" button in the report results which takes you to exactly the Batch item modification tool with all of these items ready to be bulk edited. Best, ERIC PHETTEPLACE Systems Librarian (he/him) ephetteplace@cca.edu | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: On Mon, Oct 14, 2019 at 4:31 AM Mark Alexander <marka@pobox.com> wrote:
Excerpts from Charles Kelley's message of 2019-10-14 18:18:16 +0900:
Can someone help me? Is there a tutorial on compiling item lists,
bib.
record lists, patron lists, etc.?
I believe that generating of lists is usually done with reports. See this section of the Koha manual:
https://koha-community.org/manual/19.05/en/html/reports.html
Also see this page, which shows many sample reports:
https://wiki.koha-community.org/wiki/SQL_Reports_Library _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Charles Kelley -
Eric Phetteplace -
Mark Alexander