- Koha - lists.katipo.co.nz

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

koha-US April 2023 Events & Meetings
by Jennifer Marlatt 27 Mar '23

27 Mar '23

Hello! 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, April 5 @ 8:30a PT / 11:30a ET / 15:30 UTC General Meeting - Wednesday, April 12 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Cataloging - Thursday, April 6 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, April 11@ 8:00a PT / 11:00a ET / 15:00 UTC Acquisitions - Tuesday, April 18 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, April 20 @ 10:00a PT / 1:00p ET / 17:00 UTC Cataloging - Thursday, April 27 @ 1:00p PT / 4:00p ET / 20:00 UTC Circulation - on hiatus Demonstration Instance - on hiatus 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 Jennifer Marlatt koha-US Secretary secretary(a)koha-US.org

1 0

Koha mysql DBMS fix
by Decka David 27 Mar '23

27 Mar '23

Dear Koha Community, Here is a problem that someone here in this community might come across or know to share how to solve this problem; I talked with my ICT administrator to solve this issue to have access to the koha mysql but was unable to do so to fix the DBMS auto increment problem. The issue of the "unknown variable" in the script is; *mysql: [ERROR] unknown variable 'init-file=/var/lib/mysql/init-file_koha_library.sql'* I can do the mysqldump and run the backup on the test server but on the production server, I have no access at all. Looking into the past forum emails, wikis there is not much help. Thanking everyone here in advance for their invaluable insight and pointing me towards solving the problem. Kind regards *Decka David* Matheson Librarian | PNG University of Technology | PMB | Lae, 411 | Morobe Province | PAPUA NEW GUINEA Alternate E: decka.david(a)gmail.com | P: 657 4734353 <%28657%29%20473-4353> | F: 675 4374363

2 2