- Koha - lists.katipo.co.nz

Click Tracker
by Ma. Victoria H. Silva-Manuel 01 Feb '21

01 Feb '21

Good day. I am using the SQL report below to track clicks from tag 856$u SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', > CONCAT(borrowers.firstname, ' ',borrowers.surname) AS 'Patron', URL FROM > linktracker > > JOIN biblio USING(biblionumber) > > JOIN borrowers USING(borrowernumber) > > WHERE date(timeclicked) BETWEEN '2021-01-01' AND '2021-01-31' > > GROUP BY url > The above report only shows the links clicked by log in users. When I delete the concat, it shows the links clicked by all users but does not show the names of logged in users. Is there a way to create a report that will show links clicked by all users and show the names if the users are logged in? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

koha-US February 2021 Events & Meetings
by Jason Robb 01 Feb '21

01 Feb '21

koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. For Google Calendar users, add our events calendar to your list for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5Zn… *Meetings* Board Meeting - Wednesday, February 3rd @ 8:30a PT / 11:30a ET / 16:30 UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1_15uuYnIfLSQ9v2_rAzPRWl2kRY7yz63FncR_b1… General Meeting - Wednesday, February 10th @ 8:30a PT / 11:30a ET / 16:30 UTC *Special Interest Groups* Cataloging - Thursday, February 4th @ 8:00a PT / 11:00a ET / 16:00 UTC System Administration - Tuesday, February 9th @ 9:00a PT / 12:00p ET / 17:00 UTC User Services - To be determined Acquisitions - Tuesday, February 16th @ 9:00a PT / 12:00p ET / 17:00 UTC Web Development - Thursday, February 18th @ 10:00a PT / 1:00p ET / 18:00 UTC Consortia - Tuesday, February 23rd @ 9:00a PT / 12:00p ET / 17:00 UTC Books & Crafts - Wednesday, February 24th @ 5:00p PT / 8:00p ET / 1:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Koha Community Newsletter: January 2021
by Koha Newsletter 31 Jan '21

31 Jan '21

The Koha Community Newsletter for January 2021 is here: https://koha-community.org/koha-community-newsletter-january-2021/ Many thanks to everyone who submitted articles and news to last month's newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Adding to opac autocomplete search feature
by Yatheesh lis 31 Jan '21

31 Jan '21

Hi Can anyone suggest me how to add opac pulgin autocomplete search. Thank you

2 1

Re: [Koha] Search does not work (Inês M. Ferreira)
by Italo Brasileiro 28 Jan '21

28 Jan '21

Olá, Inês! It can be a problem in "koha to marc mapping". Where did the records come from? How are they inserted into Koha? And which is the record type? The UNIMARC type is defined for your Koha installation, so the records are supposed to be also UNIMARC type. You also can search for more infos about the problem in the logs. Try to perform another rebuild and check the informations at /var/log/Koha/instanceName/ . Desejo-lhe sorte! -- Ítalo Barbosa Brasileiro

2 1

ENC: Help with shelf browser and classification source
by Inês M. Ferreira 26 Jan '21

26 Jan '21

Hello once again, Thank you so much for your patience. I've noticed that items.cn_source is not mapped to any field in my database. Should go ahead and map it to 995$2 (UNIMARC)? Are there other relevant mappings I might have missed? Thank you, Inês ________________________________ De: Koha <koha-bounces(a)lists.katipo.co.nz> em nome de Katrin Fischer <katrin.fischer.83(a)web.de> Enviado: segunda-feira, 18 de janeiro de 2021 22:19 Para: koha(a)lists.katipo.co.nz <koha(a)lists.katipo.co.nz> Assunto: Re: [Koha] Help with shelf browser and classification source items.cn_sort Hi Inês, for what we discussed in this thread earlier 942$2 is not important, but the same field in the item record is: 952$2 which corresponds to items.cn_source in your database. Hope this helps, Katrin On 18.01.21 10:03, Inês M. Ferreira wrote: > Good morning, > > Still on the topic of switching Koha to UDC -- is 942$2 the only field that needs to be changed? Are there any other ones that are related to the classification source? > > I have already switched DefaultClassificationSource. > > Thank you in advance, > > Inês F. > > ________________________________ > De: Katrin Fischer <katrin.fischer.83(a)web.de> > Enviado: sexta-feira, 1 de janeiro de 2021 17:53 > Para: Inês M. Ferreira <ines.m.ferreira(a)live.com.pt>; koha(a)lists.katipo.co.nz <koha(a)lists.katipo.co.nz> > Assunto: Re: [Koha] Help with shelf browser and classification source > > > Hi, > > there are several options, depending a bit on how many items you have. You can use the batch item edit tool or you could change the field in the database using SQL. SQL would probably be a good option in this case, but should always be used very carefully. > > In any case you should run the script to make sure that the cn_sort is recalculated with for your new classification scheme. > > Katrin > > On 30.12.20 00:51, Inês M. Ferreira wrote: > Thank you very much for your reply. > > I do have one question. How do I bulk edit all items to the right code? > > Regards, > Inês > ________________________________ > From: Koha <koha-bounces(a)lists.katipo.co.nz><mailto:koha-bounces@lists.katipo.co.nz> on behalf of Katrin Fischer <katrin.fischer.83(a)web.de><mailto:katrin.fischer.83@web.de> > Sent: Tuesday, December 29, 2020 11:42:41 PM > To: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> <koha(a)lists.katipo.co.nz><mailto:koha@lists.katipo.co.nz> > Subject: Re: [Koha] Help with shelf browser and classification source > > Hi Ines, > > I think once your search is fixed, the shelf browser might be working > again. You can also check the various shelf browser prefs to make sure > that your new locations are taken into account. > > For the classification source: The DefaultClassificationSource > preference will change the default on your item framework. It will not > change your existing items. I'd set it now to make sure new items get > catalogued with UDC right from the start. > > The classification source used for an item determines how the cn_sort > feld (sorting form of the callnumber) is generated and stored in the > database. So once you have bulk edited all your items to the right code, > you will probably also want to run misc > <https://git.koha-community.org/Koha-community/Koha/src/branch/master/misc>/maintenance > <https://git.koha-community.org/Koha-community/Koha/src/branch/master/misc/m…>/touch_all_items.pl > to regenerate the sorting form. > > Hope this helps, > > Katrin > > On 28.12.20 17:06, Inês M. Ferreira wrote: >> Good morning, >> >> (I tried to send this email before, but I think something went wrong. If it did send, apologies for the duplicate.) >> >> I am responsible for a small private library and we have recently installed Koha (20.05.04.000, using UNIMARC and UDC). I am having some issues with the shelf browser and the classification source. >> >> The shelf browser does not appear. When clicking on the link, only a link to "close the shelf browser" does. >> >> I have just finished assigning shelving locations (995$e) to all items (due to previously having periodicals show alongside books), and for this purpose I have created 3 locations: geral (general), referência (reference), periódicos (periodicals). Before assigning the locations, the shelf browser would sometimes appear; now it never does (only the link to close it, as mentioned above). What could be the problem? >> >> I’m not sure if this is relevant and could be impacting the shelf browser, but our search doesn’t work -- it always shows no results (our IT team is working on it). >> >> A second issue (that might be related) is that although I am trying to work with UDC, I think Koha is still defaulting to Dewey. I have only found out about the setting DefaultClassificationSource a few days ago, and it is set as Dewey (I didn’t change it because I would rather change everything, including all 1000+ items, at once). On the administration menu > classification sources, I only have UDC as ‘in use’. What do I need to do to make sure all of Koha is using UDC? >> >> I am very new to Koha, so any help is appreciated! Thank you. >> >> Kindest regards, >> >> Inês F. >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Coverflow not working koha 20.05
by MAMCET Library 26 Jan '21

26 Jan '21

Hi I have did all the setup and everything seems to be ok also but coverflow does not load on the OPAC page of Koha, Please suggest. I am using ubuntu MATE 20.4 LTS and Koha 20.05.

4 3

Koha 19.11.14 released
by Victor Grousset/tuxayo 23 Jan '21

23 Jan '21

Hello! The Koha Community is happy to announce the release of Koha 19.11.14 The full release notes can be found at: https://koha-community.org/koha-19-11-14-released/ Debian packages will be available shortly. Thanks to everyone involved :) Cheers, -- Victor Grousset/tuxayo

1 0

CHAT: Another Adventure of Fred and the Avenging Chicken
by King, Fred 22 Jan '21

22 Jan '21

Esteemed Colleagues, Yes, the conference took place last August, but I've been preoccupied. So now, as a ray of silliness after some rather odd months, may I present MLA 2020: Fred and the Avenging Chicken Spend a Week in the Basement http://avengingchicken.online/mla2020 I regret to add that there won't be Adventures at the koha-US and KohaCon International conferences. By the time I finished my presentations, I was too worn out to photograph Adventures. Also, as I noted in the site, I used up all my jokes unless I wanted to do something like the Angriest Dog in the World. Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org If it's raining, it isn't cold. --New Englander ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

2 1

Release of Koha 20.11.02
by Fridolin SOMERS 22 Jan '21

22 Jan '21

Hello everyone 🤗 The Koha community is proud to announce the release of Koha 20.11.02. It is a maintenance release including 10 enhancements, 50 bugfixes. Contains 5 critical bugfixes especially : Bug 27509 - cn_sort value is lost when editing an item without changing cn_source or itemcallnumber The full release notes are available here: https://koha-community.org/koha-20-11-02-released/ Debian packages should be available in a few days. Best regards 🐌 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0