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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbraum@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*