- Koha - lists.katipo.co.nz

Koha Community Newsletter: March 2023
by Koha Newsletter 31 Mar '23

31 Mar '23

The Koha Community Newsletter for March 2023 is here: https://koha-community.org/koha-community-newsletter-march-2023/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Customize OPAC search results
by Daniele Piccoli 31 Mar '23

31 Mar '23

Hi all, my first message here. We have been starting tu use Koha in our school for organize our books, it works very well. I'd like to know if it is possible to customize the search results and put a circle with a color side to each book, based on class that it suited for For instance, first class --> BLU, second class --> RED, and so on Do you have any hint? Thanks Daniele

3 3

INSTALLING KOHA SOFTWARE IN MY LIBRARY
by Hillcrest Librarian 30 Mar '23

30 Mar '23

Greetings sir. I am relatively new here and I am not conversant with KOHA library software. Due to the cost of maintaining my library, I chose to migrate to this amazing free software. I do not know the steps to install this software. I will be very glad if you can direct me. Thanks James Livinus Librarian, Hillcrest School, Jos.

4 3

The Terrific Every-Other-Thursday Training Videos | Repurposing Fields | S3E15
by BRANNON, CHRISTOPHER 30 Mar '23

30 Mar '23

Are you wasting perfectly good fields? Do you have empty text boxes doing absolutely nothing? Do you hide your unused fields? Well, stop it! Make use of those fields. Put them to work for you. George is going to show you how to repurpose fields in the library branch data. https://youtu.be/Q_yBZqPn5Hs Christopher Brannon 2023 koha-US President

1 0

In House Use
by Ma. Victoria H. Silva-Manuel 30 Mar '23

30 Mar '23

I am using the SQL report below to generate in house use: > SELECT count(statistics.type), items.itemcallnumber > FROM borrowers LEFT JOIN statistics on > (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on > (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on > (biblioitems.biblioitemnumber = items.biblioitemnumber) > WHERE statistics.type='localuse' AND date(statistics.datetime) BETWEEN > <<Date BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND > statistics.branch=<<Pick your branch|branches>> AND items.location = > <<Location|loc>> > GROUP BY items.itemcallnumber > ORDER BY items.itemcallnumber asc The original SQL only shows the count, I added the call number and filtered it by library and location successfully but I cannot add the title. I am always getting an error. What should I do? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

3 3

Upgrade KOHA 20.05 to KOHA 21.11
by zen zenitram 29 Mar '23

29 Mar '23

good day! I encountered this ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'borrowernumber': used in a foreign key constraint 'issues_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 739 Thank you!

1 0

Click Tracker
by Ma. Victoria H. Silva-Manuel 29 Mar '23

29 Mar '23

I am using this SQL to generate Click Tracker report: SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL > FROM linktracker > JOIN biblio USING(biblionumber) WHERE date(timeclicked) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>> AND > <<and (yyyy-mm-dd)|date>> GROUP BY url I want to add a drop down list for item type. I tried adding items.itype=<<itype|itemtypes>> in WHERE part, but I'm getting the following error when I run the report: The following error was encountered: > The database returned the following error: > Unknown column 'items.itype' in 'where clause' > Please check the log for further details. What should I do? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

3 4

Add time lapse between notices when sending emails.
by Ms. Naveen Ali 29 Mar '23

29 Mar '23

Dear All, When sending advance or overdue notices, the emails are not sent / failed. This happens because the a number a emails are sent per second and univerity mail server has some restrictions. I'd like to add a time lapse of a couple of seconds between emails. Is it possible to do this? With best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi.

3 3

Re: [Koha] Report generation
by zen zenitram 28 Mar '23

28 Mar '23

We need cataloging report thats shows Tag 521 or Tag 526. On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni <ketan404(a)gmail.com> wrote: > What kind of report are you trying to generate ? > You can get many here > https://wiki.koha-community.org/wiki/SQL_Reports_Library > > Ketan > > On Tue, Mar 28, 2023 at 9:47 AM zen zenitram <quickfire28(a)gmail.com> > wrote: > >> Hello >> >> Any one know how to create report in sql, of your collection that has Tag >> 521 and 526 in your output. >> >> Thank you! >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> >

2 1

Report generation
by zen zenitram 28 Mar '23

28 Mar '23

Hello Any one know how to create report in sql, of your collection that has Tag 521 and 526 in your output. Thank you!

2 1