- Koha - lists.katipo.co.nz

Ejournal management?
by Carlos Lopez 19 Aug '19

19 Aug '19

Hi everyone Do you deal with ejournal subscription management? Koha will of course keep track of physical subscriptions, but does it also deal with subscriptions where no physical items are received? (that is, can it keep track of costa and renewal costs and dates but not need individual issues to be entered?) With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au

1 0

Opac right sidebar disappeared?
by drojup 18 Aug '19

18 Aug '19

Hi there, I run Koha version: 19.05.00.000 I just noticed that the right sidebar in OPAC has disappeared. Any ideas to bring it back? Regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 3

Hackfest 2019, registration open !!!
by Paul Poulain 16 Aug '19

16 Aug '19

Hello, Once again, BibLibre is happy to invite Koha users and developers for a week of fun, working on Koha for improving it's quality ! *Dates* : September 30th - October 4th. Anyone is welcomed any day: it's not required to come the whole week. But a minimum of 2 consecutive day is needed to be able to do something useful *Location*: 108 rue Breteuil, F-13006 Marseille *Who is invited* : anyone willing to contribute to Koha, you don't need to be a developer to join us ! There is a lot of useful things a librarian can do much better than a developer, like testing, documenting. *How to register* : drop me an email *How much does it cost* : nothing (you'll have to deal with your traveling fees though, and we organize the lunch, with a fee of 15-17€ per day) *Last but not least* => come with your swimsuit, the sea is usually welcoming in September/early October :D -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

1 1

Title/Subtitle List Report
by Ma. Victoria H. Silva-Manuel 16 Aug '19

16 Aug '19

Hi. I got the SQL report below from wiki.koha-community.org, however it is not working. SELECT concat(b.title, ' ', ExtractValue(( > SELECT marcxml > FROM biblioitems b2 > WHERE b.biblionumber = b2.biblionumber), > '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, > b.author, i.itemcallnumber FROM biblio b LEFT JOIN items i ON > (i.biblionumber=b.biblionumber) > It shows the following error: The following error was encountered: The database returned the following error: Unknown column 'marcxml' in 'field list' Please check the log for further details. Return to previous page Does anyone knows what went wrong? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 2

Altering the frameworkcode of existing records
by Michael Kuhn 15 Aug '19

15 Aug '19

Hi This is Koha 18.11. In our library we exported the standard framework, re-imported it as "RVSK". Then it was edited and more than 2'600 records were added. Only recently it turned out the new framework "RVSK" was edited far too much, only leaving 17 MARC tags but missing many fields, among them mandatory fields like MARC 003, 005, 040$c or 952. Unfortunately all the missing fields were not just hidden but deleted. It would be a lot of manual work to find out and re-create the missing fields. Thus we thought it would be easier to again export the standard framework and re-import it under a new name like "ABC". Then move the 2'600 records from framework "RVSK" to "ABC", delete the mutilated framework "RVSK" and carefully edit the new framework "ABC". I think the following SQL command could do this: UPDATE biblio SET frameworkcode="ABC" WHERE frameworkcode="RVSK" Has anyone done this before? Will this work or would this cause new problems? 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

1 1

Koha Not calculating and charging overdue fines
by muirunyeri 15 Aug '19

15 Aug '19

Hi Carlos, I ran the report which returns a single column with item numbers. It indeed confirms all items are without home branch. However, no batch editing option. Any assistance to solve this is highly appreciated. Thanks Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Carlos Lopez <clopez(a)dml.vic.edu.au> Date: 15/08/2019 02:02 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com>, koha(a)lists.katipo.co.nz Subject: RE: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines Hi Muirunyeri If the homebranch field is empty, you could run a report from this query: SELECT itemnumber FROM items WHERE homebranch is NULL You should even get a little "Batch modify" button at the top of your results. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of muirunyeri Sent: Thursday, 15 August 2019 5:56 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines Sent from my Samsung Galaxy smartphone.-------- Original message --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 14/08/2019 22:54 (GMT+03:00) To: katrin.fischer.83(a)web.de Subject: Re: Re: [Koha] Koha Not calculating and charging overdue fines Hi, I have around 44,000 items that were imported from excel. The homebranch field is blank and this might be the cause if the non-calculating overdue fines. How can i edit items to fill this field (batch)? The homebranch field is not available on the items form. If its hidden, how can I unhide it? You could also give me an SQL code if it'll get the results I need. Warm regards. Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 14/08/2019 22:35 (GMT+03:00) Date:14/08/2019 22:35 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Cc: Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, can you please post to the list? I will answer there! Thanks, Katrin On 14.08.19 19:43, muirunyeri wrote: Hi, Thanks for assisting on my query. I have around 44,000 items. Kindly help me with more info on how to use the batch item editing. I cannot see the field containing home library in the form when using the batch item modification tool. There is however permanent location and current location both holding the name of my library. This two fields are however set and I need the home library field. If its hidden, how can I unhide it? You could also give me the SQL code if it'll get the results I need. Thanks alot. Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 12/08/2019 08:54 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, yes, this is most likely the problem. You need to make sure that in all your items Home library (homebranch) and current location (holdingbranch) are set for Koha to work correctly. Depending on the amount of items you have, there could be different ways to fix this: batch item editing, exporting/reimporting (matching items) or SQL. Make sure you have not hidden those fields from the add item form or have set proper defaults set to prevent the problem in the future. Hope this helps, Katrin On 07.08.19 13:11, muirunyeri wrote: Hi all, The sys prefs are all well set, the calendar and the fine rules. I however observed a very sinister issue which might be causing the overdue fine not calculating. After searching for a book, in normal view under the home library it is blank. This is in like all the books. Could it be the cause? I only have one library under libraries and the fines and circulation polices for all branches are cloned to this library. Regards Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 06/08/2019 19:14 (GMT+03:00) To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi all, I think what Caroline described would work well for a dev (git) or standard (tarball) installation, while things with the packages work a little differently like Michael describes. So it might depend on your installation type on what you should do. For package installations the fines.pl should be scheduled by default to run daily. Have you checked everything else that might prevent fines from calculating? - finesmode systempreference? - Holidays in the calendar? - Circulation rules correct? For example sometimes it's easy to miss that rules for 'all libraries' might have been overwritten by branch specific ones. Hope this helps, Katrin On 06.08.19 17:07, Michael Kuhn wrote: > Hi > > >> I think this' where my solution lies however the cron -l command > >> replies no cron command for my user account. I have 2 accounts > >> showing i.e. the admin account and the koha_instance account. > >> > >> I hope i was supposed to run it thru the main account coz thats where > >> I log in. > >> > >> Or what might I be doing wrong? I believe the cron list should have > >> something. Please advise. > > I'm not sure if this is of any help, but in the Koha 19.05 standard > the script "fines.pl" is executed in file > "/etc/cron.daily/koha-common" as follows: > > koha-foreach --chdir --enabled /usr/share/koha/bin/cronjobs/fines.pl > > Thus not in any user controlled crontab. Also the path is not > "misc/cronjobs/fines.pl". > > Best wishes: Michael _______________________________________________ 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 -- Click here to report this message as spam: https://console.mailguard.com.au/ras/1WjDFG6Rrm/6w1jxU3YIDrNJIQQ56V7oe/0.4

2 1

Fwd:Re: Koha Not calculating and charging overdue fines
by muirunyeri 15 Aug '19

15 Aug '19

Sent from my Samsung Galaxy smartphone.-------- Original message --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 14/08/2019 22:54 (GMT+03:00) To: katrin.fischer.83(a)web.de Subject: Re: Re: [Koha] Koha Not calculating and charging overdue fines Hi, I have around 44,000 items that were imported from excel. The homebranch field is blank and this might be the cause if the non-calculating overdue fines. How can i edit items to fill this field (batch)? The homebranch field is not available on the items form. If its hidden, how can I unhide it? You could also give me an SQL code if it'll get the results I need. Warm regards. Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 14/08/2019 22:35 (GMT+03:00) Date:14/08/2019 22:35 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Cc: Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, can you please post to the list? I will answer there! Thanks, Katrin On 14.08.19 19:43, muirunyeri wrote: Hi, Thanks for assisting on my query. I have around 44,000 items. Kindly help me with more info on how to use the batch item editing. I cannot see the field containing home library in the form when using the batch item modification tool. There is however permanent location and current location both holding the name of my library. This two fields are however set and I need the home library field. If its hidden, how can I unhide it? You could also give me the SQL code if it'll get the results I need. Thanks alot. Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 12/08/2019 08:54 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, yes, this is most likely the problem. You need to make sure that in all your items Home library (homebranch) and current location (holdingbranch) are set for Koha to work correctly. Depending on the amount of items you have, there could be different ways to fix this: batch item editing, exporting/reimporting (matching items) or SQL. Make sure you have not hidden those fields from the add item form or have set proper defaults set to prevent the problem in the future. Hope this helps, Katrin On 07.08.19 13:11, muirunyeri wrote: Hi all, The sys prefs are all well set, the calendar and the fine rules. I however observed a very sinister issue which might be causing the overdue fine not calculating. After searching for a book, in normal view under the home library it is blank. This is in like all the books. Could it be the cause? I only have one library under libraries and the fines and circulation polices for all branches are cloned to this library. Regards Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 06/08/2019 19:14 (GMT+03:00) To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi all, I think what Caroline described would work well for a dev (git) or standard (tarball) installation, while things with the packages work a little differently like Michael describes. So it might depend on your installation type on what you should do. For package installations the fines.pl should be scheduled by default to run daily. Have you checked everything else that might prevent fines from calculating? - finesmode systempreference? - Holidays in the calendar? - Circulation rules correct? For example sometimes it's easy to miss that rules for 'all libraries' might have been overwritten by branch specific ones. Hope this helps, Katrin On 06.08.19 17:07, Michael Kuhn wrote: > Hi > > >> I think this' where my solution lies however the cron -l command > >> replies no cron command for my user account. I have 2 accounts > >> showing i.e. the admin account and the koha_instance account. > >> > >> I hope i was supposed to run it thru the main account coz thats where > >> I log in. > >> > >> Or what might I be doing wrong? I believe the cron list should have > >> something. Please advise. > > I'm not sure if this is of any help, but in the Koha 19.05 standard > the script "fines.pl" is executed in file > "/etc/cron.daily/koha-common" as follows: > > koha-foreach --chdir --enabled /usr/share/koha/bin/cronjobs/fines.pl > > Thus not in any user controlled crontab. Also the path is not > "misc/cronjobs/fines.pl". > > Best wishes: Michael _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Groups of schools using Koha
by Kathryn Tyree 15 Aug '19

15 Aug '19

Hi everyone, I hope you're having a good week so far. I would love to hear about any examples where multiple schools share a Koha instance or some other arrangement to work together using Koha. Many thanks to anyone that could take a moment to share their example. Best wishes, Kathryn Kathryn Tyree // Project and Account Manager - Libraries Catalyst IT Limited DDI // +64 4 803 2414 kathryn(a)catalyst.net.nz

2 1

Call for News: August 2019 Newsletter
by kohanews 14 Aug '19

14 Aug '19

I'm collecting news for the August newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

OAI PMH - VuFind
by Santosh T 13 Aug '19

13 Aug '19

Hi, Can you please help us to know, how to harvest multiple Koha biblio records (Different Database) using OAI PMH in VuFind? With regards Santosh

1 0