- Koha - lists.katipo.co.nz

Re: [Koha] Koha :: users' expiration date
by Katrin Fischer 08 Oct '20

08 Oct '20

Hi Jose, the dateexpiry would be enough, but you can change the updated_on if you want to track your change. Instead of doing the change in the database, you could also use the patron batch editing tool available in the GUI. Hope this helps, Katrin On 08.10.20 19:42, Jose Ricardo Quaglio wrote: > Hi, > > > > I need to change the users' expiration date. > > > > Evaluating the database, it is necessary to change the dateexpiry and > updated_on fields. > > > > Is there another field or table? > > > > I intend to make the change directly in the database. > > > > thank you, > > > > Jose Ricardo Quaglio > > > > Public Library of São Bernardo do Campo São Paulo - Brazil > > https://bibliotecapublica.saobernardo.sp.gov.br/ > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Koha :: users' expiration date
by Jose Ricardo Quaglio 08 Oct '20

08 Oct '20

Hi, I need to change the users' expiration date. Evaluating the database, it is necessary to change the dateexpiry and updated_on fields. Is there another field or table? I intend to make the change directly in the database. thank you, Jose Ricardo Quaglio Public Library of São Bernardo do Campo São Paulo - Brazil https://bibliotecapublica.saobernardo.sp.gov.br/

1 0

Re: [Koha] Patrons report errors
by John Fawcett 07 Oct '20

07 Oct '20

Solomon for Koha the categories in the borrowers table need to be defined in the categories table. In particular the report wants to read the description of the category from the categories table to use it as a column heading. Koha enforces this for records added or deleted through the GUI. As a work around you can add the missing categories (if they are correct) via the administration menu. As a long term solution, it depends on whether you want to be able to define new categories in the ERP or not. If not, then the solution can be to implement an integration from Koha to ERP to export the allowed categories and validate new borrower data to ensure they have a valid category. Potentially you oculd add a check to the ERP-Koha borrower integration to ensure that borrowers without valid categories are rejected. If instead you want to be able to define new categories in the ERP system, the solution could be to capture the relevant data (including description) of the category in the ERP and pass it via a new integration to Koha prior to importing the borrowers. Hope that helps John On 07/10/2020 10:09, Solomon Mutai wrote: > Yes, it does. From our ERP > > On Wed, Oct 7, 2020 at 1:46 AM John Fawcett <john(a)voipsupport.it > <mailto:john@voipsupport.it>> wrote: > > On 06/10/2020 14:10, Solomon Mutai wrote: > > Hi, > > > > I am new to Koha and was trying to check on patrons reports. We > seem to > > have no problems with catalging reports though. We have > installed Koha > > 20.05 on Ubuntu lts 20.04. > > > > The error we get is: > > Software error: > > > > Can't call method "description" on an undefined value at > > /usr/share/koha/intranet/cgi-bin/reports/borrowers_stats.pl > <http://borrowers_stats.pl> line 323. > > _______________________________________________ > > > > 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 > > Hi Solomon > > could be a data issue. Does your borrowers table contain a > category code > which isn't defined in the categories table? > > John >

1 0

koha-US October 2020 Meetings & Events
by Jason Robb 06 Oct '20

06 Oct '20

koha-US online meetings and events are free and open to all. See our calendar for a full list of events with links: http://koha-us.org/calendar/ *Meetings* Board Meeting - Thursday, October 8th @ 10:00a PT / 1:00p ET / 5:00p UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1114icWyZ_HuNlPjoUjd4Xd5jS4gt_SpdHdINUA7… General Meeting - Wednesday, October 14th @ 8:30a PT / 11:30a ET / 3:30p UTC *Special Interest Groups* System Administration - Tuesday, October 13th @ 9:00a PT / 12:00p ET / 4:00p UTC Web Development - Thursday, October 15th @ 10:00a PT / 1:00p ET / 5:00p UTC User Services - Monday, October 19th @ 12:00p PT / 3:00p ET / 7:00p UTC Acquisitions - Tuesday, October 20th @ 9:00a PT / 12:00p ET / 4:00p UTC Consortia - Monday, October 26th @ 9:00a PT / 12:00p ET / 4:00p UTC Books & Crafts - Wednesday, October 28th @ 5:00p PT / 8:00p ET / 12:00a UTC Cataloging - Thursday, November 5th @ 8:00a PT / 11:00a ET / 3:00p UTC Special interest groups are open to all, and strive to encourage discussion on specific modules and areas of Koha. Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topics that interest you! Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Request to be listed on your site as a Koha Support provider
by Edu Galleria 06 Oct '20

06 Oct '20

Dear list Admin, I wish to introduce my company Business Galleria. Business Galleria is an education technology solutions provider committed to providing information and communication technology services/solutions of the highest quality that exceed customer’s expectations. Through our Education technology Trade Name (*Edu Galleria), *we have been providing education technology solutions to various academies and organizations locally, and as experts in deploying and providing support for Koha Library Management System, *we are officially requesting to be listed on your site as a Koha Support provider.* We believe that our local presence in the Nigerian/West African demographics will help bring Koha solutions closer to the institutions in need of a robust Library Management Platform such as Koha. Below is our contact information: Company Name: Business Galleria Contact Person: Mark Allen Contact email: elibrary(a)edugalleria.com Website: https://edugalleria.com/ Telephone: +2348176000693 Thank you in anticipation of your response. Regards, Mark Allen

1 0

Patrons report errors
by Solomon Mutai 06 Oct '20

06 Oct '20

Hi, I am new to Koha and was trying to check on patrons reports. We seem to have no problems with catalging reports though. We have installed Koha 20.05 on Ubuntu lts 20.04. The error we get is: Software error: Can't call method "description" on an undefined value at /usr/share/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 323.

1 0

Internal server error
by vinod mishra 06 Oct '20

06 Oct '20

Hello My koha opac and staff client gives Internal server error while opening it. I found server consumes all hardisk space very frequently . My server maintenance team looking this issue but I am worried if there is any Koha related issue, however size of our database is only 1.5GB Koha version 20.05.04, Ubuntu 18.04 and mariadb 10.4 Please suggest

7 15

Making a field into a drop down menu
by John Fawcett 05 Oct '20

05 Oct '20

Hi first of all let me say I'm completely new to Koha and am taking a look at it potentially to use in a school library. So thanks to all the people that have contributed to making the software what it is today. It's been a bit of a learning curve. First off, I tried and abandoned the idea of installing on my existing Centos 8 server and took the easier path of using the packaged install on latest Ubuntu release on a new dedicated server, following this link: https://wiki.koha-community.org/wiki/Debian I did find an issue that stopped me installing mariadb due to incompatible versions, but mysql installed without problems. Needing to use Italian, I did run into some issues in the provided sql which I had to tweak in order to get the install to correctly finish without violating not null constraints (on the 307 record in the marc_subfield_structure). So now I've got an up and running installation which I'm trying out, but one thing which I cannot work out. After adding a Unimarc record, I'm on the editor for adding items. There's a field 995 r "Type of item and material" (or in my version "Tipo della copia e materiale". This is a free input text field, not a drop down menu limited to a list of predefined values. In the Italian translation this field did not have any "authorised_value" in the table marc_subfield_structure. I've modified with the value itemtypes. However for some reason this does not seem to make the field into a drop down menu in the staff GUI. So my question to more experienced users are: after changing the "authorised_value" do I need to run a script or restart something in order to get the free text field to change into a drop down menu? Or is there a different way of doing that? thanks for any help. John

3 5

Mapping Authority & Bibliographic Records
by Ma. Victoria H. Silva-Manuel 05 Oct '20

05 Oct '20

Hi. We are using Cutter-Sanborn and place it in authority 082$b. I wanted to map it to biblio 082$b. Is this possible and how? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Request guidance regarding serial control
by Suresh Kumar Tejomurtula 04 Oct '20

04 Oct '20

Dear all, Need guidance / best practice to the below issue:- I'm using serial control module in Koha. In our organization we have subscriptions to multilingual periodicals with the same title eg: India Today which is being published in Hindi and English. I have created entries for the title with all the respective fields with language in the record entry. But I do not find a way to differentiate the hindi / english titles while receiving them in koha serial module. It would be nice to know how others are overcoming this issue apart from identifying the title using ISSN. There may be some titles where some local publications may not have ISSN number, but the same title gets published in different languages. What i'm doing to overcome this issue is adding language to the title field like - India Today (Hindi). Could you please suggest any other way to overcome it apart from adding language in the title field. Regards Suresh Kumar

1 0