[Koha] Few general Koha questions

[Heather Braum (NEKLS)]

I can help on #3 -- you can write a custom SQL report through the reports
module that returns all bibs and then has a column that has a link directly
to the item editor...

This should work -- it will return all records that don't have items
attached and include a direct link to the add item editor that opens in a
new tab; every time you rerun the report, any record that has an item
attached will not be returned.

SELECT biblio.biblionumber, CONCAT('<a href=\"/cgi-bin/koha/cataloguing/
additem.pl?biblionumber=',biblio.biblionumber,'\" target="_blank">'"add
item"'</a>') as "add item" FROM biblio LEFT JOIN items USING(biblionumber)
WHERE items.itemnumber IS NULL LIMIT 5000

By the way, that 5000 limit number can be whatever you want it to be -- the
default screen return is 20 rows, although there's dropdown options to set
it up to 1000 rows returned at a time.

Good luck.

On Wed, Dec 2, 2015 at 1:20 PM Aparrish <cspsyntech at gmail.com> wrote:

> Hello all,
>
> Busy configuring a new Koha installation and I'm just going to list a bunch
> of questions I have. I am struggling a bit with the manual and I haven't
> had
> any luck searching the archives. Pick a topic!
>
> 1. When patron self-registration is enabled, there are a number of
> necessary
> fields I can't get to show up, namely, userid, password, and cardnumber
> (The
> project I am working on requires people to fill out their own card number -
> they will be unique.) These fields are however accessible from the same
> patron template when an account is created on the staff side by
> superlibrarian. Any thoughts?
>
> 2. Is there any way, after having imported a batch of records, to
> auto-generate an item for each record in the batch? I do not have time to
> search, by name, for each record in a 5000+ item library and create an item
> for it.
>
> 3. Following on question 2, is there any way to force the staff interface
> to
> just display every record in the catalog so that if I do have to add each
> item manually I can at least do it faster?
>
> Cheers. Thanks for your help.
> Andrew
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Few-general-Koha-questions-tp5863627.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbraum at nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*