- Koha - lists.katipo.co.nz

Btach Modification for Barcode
by Himanshu Aggarwal 19 Apr '21

19 Apr '21

I have extra 00s in almost 100 records. How can I modify it in a simplest manner.

3 3

How to hide Subfield in OPAC
by Ketut Gunawan 19 Apr '21

19 Apr '21

Dear all, I am new to Koha so I need helps. I have a subfield 856$u containing PDF files in hundred of records. I want to hide it in OPAC so that public visitors cannot see "Online resources: Click here to access online", but for those who log in (students) can see and click such a link. I have tried to read the manual and search the forum, but I can find it. Any help would be much appreciated. Best Regards, K. Gunawan SocPolSci Faculty, Mulawarman University Indonesia

3 4

weird report behaviour or just bad SQL?
by Carlos Lopez 19 Apr '21

19 Apr '21

Hi folks I have a report that lists items with a location of "DISPLAY": SELECT itemnumber, barcode, ccode, itemcallnumber, datelastseen FROM items WHERE location = "DISPLAY" ORDER BY ccode, itemcallnumber At the moment it brings up 18 items. itemnumber barcode ccode itemcallnumber datelastseen 270404 33865001661351 BP47 P659 H461 2021-04-07 270195 33865001666699 DK39 (34) P265 2021-03-11 269921 33865001662516 DL38 S617 2021-03-22 270241 33865001667093 KH48 F1 XL21 2021-03-12 270374 33865001661237 MM22 F778 2021-03-29 270371 33865001661112 MW61.64 S951 2021-03-29 270104 33865001662771 MW68 D976 A 2021-03-02 270293 National Catholic reporter 2021-03-15 270181 33865001665170 RC66 C559 2021-04-07 267602 33865001664009 RK56 E928 2021-03-30 270281 33865001666749 SA6 P984 2021-03-12 270432 33865001665212 SD80.91 K49 2021-04-14 270283 33865001666806 SM31 M191 2021-03-15 270426 33865001667325 WD78 H582 2021-04-09 270071 33865001662987 WW10 W456 2021-04-13 270225 33865001667101 XY28 H973 2021-03-15 270397 33865001667390 XY28 T814 2021-04-01 237930 33865001656583 JESUIT TE G573 2021-03-04 If I modify it to only bring up items with itemcallnumber beginning with A to M SELECT itemnumber, barcode, ccode, itemcallnumber, datelastseen FROM items WHERE location = "DISPLAY" AND itemcallnumber LIKE "[A-M]%" ORDER BY ccode, itemcallnumber I expect to get the top 7 results from the list above, but instead I get zero results. Is it that the Reports area on Koha restricts normal SQL functionality, or am I doing something wrong? 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<mailto:library@dml.vic.edu.au> | library.dmlibrary.org.au

2 1

Koha Item Number File Creation
by Charles Kelley 19 Apr '21

19 Apr '21

Hello, all! I have been watching a video on batch item modifications < https://www.youtube.com/watch?v=USp2ucBh7gY>. According to the video there are three ways to identify the target items: (1) scan or type each barcode number into the textbox; (2) identify the compiled file of compiled barcodes of the targeted items; and (3) use the file of compiled item numbers. I have sought information for compiling item record files, but I have been unsuccessful. How are such files compiled? Many thanks, everyone. P. S. The video is most helpful. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

3 3

Error during Koha 20.11 installation
by Pocholo Fermin 18 Apr '21

18 Apr '21

Hi there, I'm trying to setup Koha 20.11 on my Ubuntu 20.04 LTS server. I followed the steps in Koha on ubuntu - packages page (https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Appendix_A:_…) I installed MySQL server instead of MariaDB. I can visit the administration website to continue with the Koha web installer. I can login with the given username and password. The succeeding setup steps are fine. But when I get to the step "Now we're ready to create the database tables and fill them with some default data."...I am getting the following error and cannot further proceed with the setup. The following error occurred while importing the database structure: [Sun Apr 18 15:05:07 2021] install.pl: DBD::mysql::st execute failed: Cannot drop table 'auth_types' referenced by a foreign key constraint 'auth_subfield_structure_ibfk_1' on table 'auth_subfield_structure'. at /usr/share/perl5/DBIx/RunSQL.pm line 279, <$args{...}> line 1. [Sun Apr 18 15:05:07 2021] install.pl: Something went wrong loading file /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql ([SQL ERROR]: [Sun Apr 18 15:05:07 2021] install.pl: -- [Sun Apr 18 15:05:07 2021] install.pl: -- Table structure for table `auth_types` [Sun Apr 18 15:05:07 2021] install.pl: -- [Sun Apr 18 15:05:07 2021] install.pl: [Sun Apr 18 15:05:07 2021] install.pl: DROP TABLE IF EXISTS `auth_types` [Sun Apr 18 15:05:07 2021] install.pl: ) at /usr/share/koha/lib/C4/Installer.pm line 564. Please contact your system administrator Any idea how I can resolve this? Thank you very much for your assistance. Best regards, Pocholo Pocholo Fermin | Head of Information Technology | Secondary School Butuka Academy | p: P. O. Box 2007 Vision City Waigani NCD a: Sec 128 Lot 18 Pari Road Kila Kila, National Capital District, PG p: +675 340 2836 | Ext 8000 | m: +675 7834 8984 | w: www.butukaacademy.ac.pg<https://www.butukaacademy.ac.pg> Breach of Confidentiality This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.

1 0

To be listed as a Koha Support provider in Malaysia
by JESSE KAH 18 Apr '21

18 Apr '21

*Dear Koha Community,* Lemonjar has been providing service and support in Malaysia for Koha ILS and other open source platform for couple of years. We would also like to require community to list us for service and service provider for Koha ILS in Malaysia. Our detail as follow: Company Name: *Lemonjar Software Media Sdn. Bhd. (1039463-K)* Contact Person: *Mdm. Jesse Kah Ingland / Mr. Chong* Contact Email: sales(a)lemonjar.com.my / sales(a)edgetech.com.my Website: https://www.lemonjar.com.my Contact Tel: *+603-7859 9226/ +6088-713226* We provide service from implementation, system architecture design for Koha, customization, migration service, Koha Payment Gateway, as well as integration according to needs. Further information on our service on Koha ILS can be found at: https://www.lemonjar.com.my/ Thanks & have a nice day! Best Regards, Jesse Kah Ingland Lemonjar Software Media Sdn. Bhd. -- Managing Director -- Mobile: +6 (016) 8606 826 Tel: +6 (03)7859 9226 (Selangor Office) | +6 (088) 713226 (Sabah office) Fax: +6 (088) 713226 Website: https://www.lemonjar.com.my https://www.edgetech.com.my Other Email: mailto:lemonjarsm@gmail.com / mailto:lemonjar.sales@gmail.com Lemonjar Facebook page: https://www.facebook.com/lemonjarsoftmed/ Edgetech Facebook page: https://www.facebook.com/edgetechengineering/ YouTube page: https://www.youtube.com/channel/UCLV34OjYVdG6KQK_uTC2f3A/featured

3 4

Getting guarantor information in notices
by Caroline Cyr-La-Rose 16 Apr '21

16 Apr '21

Hello dear community! I'm wondering if it's possible to access guarantor information for notices? We recently upgraded our Kohas to 20.05 from 19.05. One of the notices goes like this <<borrowers.firstname>> <<borrowers.surname>><br/> [% IF borrower.guarantorid %] C/O [% borrower.contactfirstname %] [% borrower.contactname %]<br/>[% END %] <<borrowers.address>> <<borrowers.address2>><br/> <<borrowers.city>> (<<borrowers.state>>) <<borrowers.zipcode>> The second line is if the patron has a guarantor, write Care of (C/O) the guarantor's name. This is for Overdues notices sent by mail to patrons. It is not logical for us to send overdue notices to children, so we write Care of the parent. In 20.05, the database structure changed to accommodate multiple guarantors per guarantee. Does anyone know if there is a way to access the guarantor information in notices? I'm not very familiar with TT syntax so I have no idea how to indicate this "borrower" is the guarantee and this other "borrower" is the guarantor... Thank you so much! Caroline -- Caroline Cyr La Rose, M.L.I.S. Librarian | Product Manager Phone: 1-833-465-4276, ext. 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Document Technologies Specialists | www.inLibro.com <http://www.inLibro.com>

1 0

Time to translate: string freeze to prepare Koha 19.11.17 has begun
by Victor Grousset/tuxayo 16 Apr '21

16 Apr '21

Hi, saluton, hola, bonjour, String freeze is into effect as of now for the 19.11.x maintenance branch. The release is scheduled for around the 23th. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Reminder: if you add or change a translation in version 19.11, then you must also copy it to 20.05 and 20.11. Otherwise your work will be lost for future versions. Happy translating, -- Victor Grousset/tuxayo

1 0

2021 koha-US Conference Announcement and Call for Presentations
by Jason Robb 15 Apr '21

15 Apr '21

koha-US is pleased to announce that our 2021 Conference will be held in McKinney, Texas from September 21st-24th (Tuesday-Friday) 2021. We plan to hold a hybrid conference with both in-person and online attendance and participation options. We are currently seeking proposals for presentations. We welcome both in-person and online presenters. For those participating online, we will be considering both live and pre-recorded presentations. Our theme this year is "Fresh Perspectives". All are encouraged to share your knowledge and experiences -- no topic is off limits. Submit your proposals here: *https://forms.gle/JCkDLvDTrUwUx3UE9 <https://forms.gle/JCkDLvDTrUwUx3UE9>* The deadline for submitting proposals is Friday, May 21st, 2021. For more details and the most up-to-date information on our conference, please keep an eye on the conference page at *https://koha-us.org/conference2021/ <https://koha-us.org/conference2021/>* If you have questions please direct them to the koha-US conference committee at conferences(a)koha-us.org. ----- Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Re: [Koha] [KOHA] Authentication and Access
by Charles Kelley 15 Apr '21

15 Apr '21

Hello, all! In our latest exchange, on 14 April 2021 at 08:17, Joel Coehoon wrote: Sort of. Koha is just a web site, but it happens to support SSO via SAML/Shibboleth. > So if your SAML or Shibboleth provider can authenticate the card, Koha > can use that authentication. > > Joel Coehoorn > Director of Information Technology > York College of Nebraska > in response to my writing of 13 April 2021 at 11:30 PM, to wit: My agency's IT department wants to know whether Koha supports personal > identification identification (PIV) cards with certificates? I have been > unsuccessful in finding material online. Does anyone know the answer to > this question or can point me to the proper party? > Many thanks! I'm sure this will help. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0