- Koha - lists.katipo.co.nz

Adding an independent branch
by Elaine Bradtke 11 Oct '17

11 Oct '17

We have a sister library with very similar content that would like to be added as an independent branch. I estimate the duplication rate of their material with ours is 95% or better. But most of this material does not have an ISBN number. Their data, in its raw state is quite messy, and needs cleaning up, but much of this work could be avoided by linking to biblio records already in our catalogue. Given that they have a part time professional librarian on a limited contrantract (and I'm only part time on another limited contract) we're trying to work out the most efficient way to add their records as an independent branch. Plan A) I have uploaded their data into our test site, with the item records designated as their branch - If they did the linking and corrections in the test site, could I export only their branch's records (mostly item records, but perhaps some biblios) and import them into our main site? We use the 999c in record matching because so much of our material doesn't have ISBN. Plan B) Upload their data directly to the main site, but mark them all as Hide in OPAC until they can edit them. Simpler, but we're worried how much access we'll have to grant to our biblio records. Because we're keeping the branches very separate, would they be able to add items to our bib records if they are limited to editing records from their own branch? The problem is their cataloguing is done by volunteers and especially after the professional librarian's contract ends, we want to very strictly limit what they can do to our records. What's the best way to add items belonging to another branch if you have to do it manually (because of no ISBN numbers?) Do you use the merge function? I think this will require a lot of experimentation, but I'd love to hear from anyone who's had experience with this process. Thanks! Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 2

Koha Circulation loan days is not calculating properly.
by Ashok Francis 11 Oct '17

11 Oct '17

Dear All, I have defined Circulation and fine rules for my library. Here I have defined 7 loan days for students. But when the circulation time, it is calculating for 8 days suddenly. It was working very well in the beginning but suddenly from last two days it is showing 8 days. I couldn't understand the problem here. Please anyone can suggest me what should I do? Kind Regards, Ashok Francis Librarian New Delhi

2 2

Opac Header Image
by Ashok Francis 11 Oct '17

11 Oct '17

Dear All, I have added header image in opac. It is showing in homepage only. But when I search catalogue, the header image is not showing. Can anyone please help me what I have to do? Here is the link that I followed http://kohageek.blogspot.in/search/label/banner <http://kohageek.blogspot.in/search/label/banner> Kind Regards, W. Ashok Francis, Librarian, New Delhi.

2 2

Koha Developers Meeting Reminder - 11 October 2017 14 UTC
by Nick Clemens 11 Oct '17

11 Oct '17

Hi All, me again :-) our next developers meeting is happening at 14 UTC Agenda is here: https://wiki.koha-community.org/wiki/Development_IRC_meeting_11_October_2017 Time and date conversion here: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… Find us here: The #koha IRC channel (IRC server irc.oftc.net) http://webchat.oftc.net/?channels=koha It's GBSD too, so hopefully you will all be out there, attacking the queue :-) See you all soon

1 0

GBSD now! Global Bug Squashing Day is here!
by Nick Clemens 11 Oct '17

11 Oct '17

Huzzah and hooray! The day you have been waiting for is here, time to get out there and squash some bugs! Checkout the guide to getting involved: https://wiki.koha-community.org/wiki/Getting_involved Checkout the dashboard here: http://dashboard.koha-community.org/ Checkout the developer handbook: https://wiki.koha-community.org/wiki/Developer_handbook Remember, sign-offs and qa aren't the only way you can contribute: You can add to an 'In discussion' bug and move it back into the actions queues: https://bugs.koha-community.org/bugzilla3/buglist.cgi?bug_status=In%20Discu… You can contribute to the manual here (try the easy path first): https://wiki.koha-community.org/wiki/Editing_the_Koha_Manual <https://wiki.koha-community.org/wiki/Editing_the_Koha_Manual> You can submit a cookie recipe (hint: cookies make great bribes): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5158 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5158> Or just browse around the wiki and tidy up the things you find to help out :-) Come find anyone in IRC and ask us your questions, ask us for help, and squash those bugs! -Nick (kidclamp) <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5158>

1 0

Request
by Mike Ward 10 Oct '17

10 Oct '17

Please remove me from this list. Thanks, Mike Ward

2 1

Checkout one item results in multiple items...
by Tim Young 10 Oct '17

10 Oct '17

We have started experiencing a recent issue where attempting to check out one item results in multiple of those items (same barcode, checked out multiple times) being checked out to the one patron. This does not happen to every item, nor does it happen to every patron. I am not sure if this error has to do with the problem, but I am seeing errors like: [Tue Oct 10 15:49:58.258993 2017] [cgi:error] [pid 20067] [client 41.89.41.2:23363] AH01215: [Tue Oct 10 15:49:58 2017] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 92, referer: http://opac.scott.ac.ke:8080/cgi-bin/koha/cataloguing/additem.pl?op=editite… showing up in the internet-error.log Any clue how I should begin tracking this down? - Tim

2 2

Koha password recovery doesn't seem to work
by VISINI Giacomo 10 Oct '17

10 Oct '17

Hello, I've been having issues setting up a password recovery in Koha (version 16.11.12.000). I've did all the necessary steps, as explained in the manual. In short this: 1. Go to Administration 2. System Preferences 3. OPAC Preferences 4. Opacresetpassword<http://translate.koha-community.org/manual/16.05/en/html-desktop/#OpacReset…> : Library users are "allowed" to recover their password via email in the OPAC. 5. A notice must be set up in the Notices and Slips section * Go to Tools * Notices and Slips * Verify there is a notice set up called Password_Reset Everything seems to be working fine. I can choose 'Forgot password' in OPAC, then I can enter a login name and/or email address. I receive a link in my mailbox saying: This email has been sent in response to your password recovery request for the account XXX.XXX. You can now create your new password using the following link: /cgi-bin/koha/opac-password-recovery.pl?uniqueKey=$2a$08$DDiNbAFWtNLz80gWHQxUbe<http://cgi-bin/koha/opac-password-recovery.pl?uniqueKey=$2a$08$DDiNbAFWtNLz…> This link will be valid for 2 days from this email's reception, then you must reapply if you do not change your password. Thank you. Unfortunately the link doesn't seem to work. I've tried several times under several accounts. The link is always faulty. The same thing happens when I want to set up a verify-by-email for the self-registering patron (PatronSelfRegistrationVerifyByEmail). All goes well like above, until I click the link sent to me: Hello! Your library account has been created. Please verify your email address by clicking this link to complete the signup process: /cgi-bin/koha/opac-registration-verify.pl?token=1b9cbb3ba7da22d9751aa4b9f15973b1<http://opac-registration-verify.pl/?token=1b9cbb3ba7da22d9751aa4b9f15973b1> If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly. Has anybody experienced this problem? Can anybody give an explanation or a solution? I didn't see any reportings of this exact issue. Many thanks in advance! With kind regards, Giacomo Visini +32(0)3 360 52 41 giacomo.visini(a)divaantwerp.be Gildekamersstraat 9, B-2000 Antwerpen Disclaimer: Op deze e-mail is de wet van 13 juni 2005 over het vertrouwelijke karakter van elektronische communicatie van toepassing. De tekst van het relevante artikel 124 kun je op onze website consulteren. http://www.provincieantwerpen.be/over-deze-website.html

3 2

Creating labels with barcodes not already in the system
by Michael Kuhn 10 Oct '17

10 Oct '17

Hi Using the label creator we want to generate a number of barcodes but it seems the label creator can only create a label batch if the barcodes are already existing in Koha. How can we create a sheet with labels of barcodes (simply consecutive numbers like 74180238 74180239 74180240 etc.) that are not yet existing in Koha? When cataloging, first creating the record and the item, we then just want to pick one of the labels on the sheet and read the barcode number into MARC 952 $p, then sticking the label on the item. How can this be achieved? Any hint is appreciated. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 1

Re: [Koha] Help needed with SQL report
by Elaine Bradtke 09 Oct '17

09 Oct '17

Thanks everyone! I added the limit by biblio number and this works: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) LEFT JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) WHERE items.biblionumber >= '17920' AND items.biblionumber <= '17959' ORDER BY biblio.copyrightdate asc Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) On Mon, Oct 9, 2017 at 9:42 AM, Jonathan Druart < jonathan.druart(a)bugs.koha-community.org> wrote: > Sorry, I badly pasted the query. > Try: > SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, > ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') > AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) LEFT > JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) ORDER BY > biblio.copyrightdate asc; > > > On Mon, 9 Oct 2017 at 13:10 Elaine Bradtke <eb(a)efdss.org> wrote: > >> this time it says: You have an error in your SQL syntax; check the >> manual that corresponds to your MySQL server version for the right syntax >> to use near 'JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) >> ORDER BY biblio' at line 7 >> I think we're getting closer. >> >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent >> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >> 's Park Road, London NW1 7AY >> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >> Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is for >> the English Folk Dance and Song Society in London, England. If you wish to >> phone me personally, send an e-mail first. I work off site) >> ------------------------------------------------------------ >> -------------- >> Registered Company No. 297142 >> Charity Registered in England and Wales No. 305999 >> ------------------------------------------------------------ >> --------------- >> "Writing about music is like dancing about architecture" >> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> >> On Thu, Oct 5, 2017 at 8:11 AM, Jonathan Druart < >> jonathan.druart(a)bugs.koha-community.org> wrote: >> >>> Since 17196 (17.05) you need to join on biblio_metadata >>> Try the following query: >>> SELECT biblioitems.biblionumber, biblio.title, biblio.copyrightdate, >>> ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') >>> AS text >>> FROM items >>> LEFT JOIN biblioitems on (items.biblioitemnumber= >>> biblioitems.biblioitemnumber) >>> LEFT JOIN biblio on (biblioitems.biblionumber= >>> LEFT JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) >>> ORDER BY biblio.copyrightdate asc; >>> >>> On Thu, 5 Oct 2017 at 11:43 Elaine Bradtke <eb(a)efdss.org> wrote: >>> >>>> It gives the error message: >>>> *The following error was encountered:* >>>> The database returned the following error: >>>> Unknown column 'biblioitems.marcxml' in 'field list' >>>> >>>> Elaine Bradtke >>>> Data Wrangler >>>> VWML >>>> English Folk Dance and Song Society | http://www.efdss.org >>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is >>>> for the English Folk Dance and >>>> Song Society in London, England. If you wish to phone me personally, >>>> send >>>> an e-mail first. I work off site) >>>> ------------------------------------------------------------ >>>> -------------- >>>> Registered Company No. 297142 >>>> Charity Registered in England and Wales No. 305999 >>>> ------------------------------------------------------------ >>>> --------------- >>>> "Writing about music is like dancing about architecture" >>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> >>>> On Thu, Oct 5, 2017 at 3:16 PM, Holger Meissner < >>>> Holger.Meissner(a)hs-gesundheit.de> wrote: >>>> >>>> > Hi Elaine, >>>> > >>>> > how about this: >>>> > >>>> > SELECT >>>> > biblioitems.biblionumber, >>>> > biblio.title, >>>> > ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/ >>>> subfield[@code="c"]') >>>> > AS text >>>> > FROM items >>>> > LEFT JOIN biblioitems on (items.biblioitemnumber= >>>> > biblioitems.biblioitemnumber) >>>> > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) >>>> > WHERE >>>> > items.biblionumber >= '17920' AND items.biblionumber <= '17959' >>>> > ORDER BY text ASC >>>> > >>>> > >>>> > -----Ursprüngliche Nachricht----- >>>> > Von: Koha [mailto:koha-bounces@lists.katipo.co.nz] Im Auftrag von >>>> Elaine >>>> > Bradtke >>>> > Gesendet: Donnerstag, 5. Oktober 2017 15:08 >>>> > An: koha >>>> > Betreff: [Koha] Help needed with SQL report >>>> > >>>> > I need a report that gives bib number, title and 260$c from a set of >>>> > records within a range of biblio numbers. >>>> > >>>> > This is what the wizard gives me: >>>> > SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate >>>> FROM >>>> > items LEFT JOIN biblioitems on >>>> > (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN >>>> biblio on >>>> > (biblioitems.biblionumber=biblio.biblionumber) WHERE >>>> items.biblionumber >>>> > >= '17920' AND items.biblionumber <= '17959' ORDER BY >>>> > >biblio.copyrightdate >>>> > asc >>>> > >>>> > But it's only giving the year (presumably from the 008?) I need the >>>> > actual text of the 260$c field. >>>> > >>>> > Any help would be greatly appreciated. Thanks! >>>> > I looked for a way I could configure the csv output from a list to >>>> give me >>>> > that information, but didn't find it . >>>> > Elaine Bradtke >>>> > Data Wrangler >>>> > VWML >>>> > English Folk Dance and Song Society | http://www.efdss.org Cecil >>>> Sharp >>>> > House, 2 Regent >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> 's Park Road, London NW1 7AY >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> > Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is >>>> for the English Folk Dance and >>>> > Song Society in London, England. If you wish to phone me personally, >>>> send >>>> > an e-mail first. I work off site) >>>> > ------------------------------------------------------------ >>>> -------------- >>>> > Registered Company No. 297142 >>>> > Charity Registered in England and Wales No. 305999 >>>> > ------------------------------------------------------------ >>>> > --------------- >>>> > "Writing about music is like dancing about architecture" >>>> > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> > _______________________________________________ >>>> > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >>>> > https://lists.katipo.co.nz/mailman/listinfo/koha >>>> > >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha(a)lists.katipo.co.nz >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>> >>

1 0