Re: [Koha] Creating Lists of Item Numbers

[Charles Kelley]

Hello, all!

In a recent exchange, on 14 Oct 2019, at 07:31 AM, Mark Alexander wrote:

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
>

You're right! I found the section and I'll be studying it later today.

In our latest exchange, on 14 Oct 2019, at 10:05 AM, Eric Phetteplace
wrote:


> 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.
>

This really helped. I was able to add the missing shelving location.
All is good. Between Eric's SQL statements and Mark's reference to the
report sections of the documentation, I'll be in good stead, I think.

Thanks, too, for suggesting the NULL data check as well as the empty
string check. So often one can miss checking both, especially given the
structure and storage of SQL databases. I had forgotten about that.

Thanks to you both!

-- 
-- Charles.

Charles Kelley, MLS
Data Analyst (Library and Information Services)
SAIC
Reston, VA, USA

1-301-741-7122 [US cell]
011-81-80-4714-5490 [JPN cell]

mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]

linkedin.com/in/cmkelleymls 
Meeting Your Information Needs. Virtually.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Creating Lists of Item Numbers

[Eric Phetteplace]

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)

ephettepl...@cca.edu | o 510.594.3660

5212 Broadway | Oakland, CA | 94618

:(){ :|: & };:


On Mon, Oct 14, 2019 at 4:31 AM Mark Alexander  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
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Creating Lists of Item Numbers

[Mark Alexander]

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

[Koha] Creating Lists of Item Numbers

[Charles Kelley]

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]

mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]

linkedin.com/in/cmkelleymls 
Meeting Your Information Needs. Virtually.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha