- Koha - lists.katipo.co.nz

Books Copies MARC21
by Mahmoud 20 Nov '19

20 Nov '19

Hallo all, Second question is I am just importing some books from SRU server after connecting our university's Koha library to the main country's library in Germany which is K10plus. The main point is that Koha is not reading the barcode of the books from the MARC data that comes out in not creating book copies (we have from every book more than one copy with different signature, already in the MARC data). Thank you Best regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 4

Koha User csv export/import
by Mahmoud 20 Nov '19

20 Nov '19

Hallo all, I've just created some users on 1 koha installation and then I exported the patrons as CSV data. I tried importing the patrons into other koha installation but unfortunately it was failing due to some missing fields, how could be that there is missing fields if those patrons were already created in a koha system and all required fields were filled? Note: The 2 Koha installations are of the recent version. Thank you Best Regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 2

delete serial subscription
by Nalisha Tamang 20 Nov '19

20 Nov '19

How do I delete serial subscription as I have made a duplicate and i want to delete the old one and edit the new but it is not happening. especially I want to delete serial subscription of a particular journal. please help me out. thanks and regards, Nalisha

2 4

How to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04
by yasiriqbal1 20 Nov '19

20 Nov '19

Dear All, I am new to Koha. Please help me to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

1 0

SQL for mass auto-generating barcodes for items
by Father Vlasie 19 Nov '19

19 Nov '19

Hello everyone! I wrote an SQL command to generate barcodes for all items in Koha. I did not find a command like this that was already written so I thought I might publish it on this list in case anyone else might find it useful. You will need to find your mysql username and password in your /etc/koha/sites/library/koha-conf.xml ("library" is your Koha instance name). In the commands below replace username with your username, of course, and koha_library with your database name. (You can show all databases in msql by entering: show databases; ) msql -u username -p use koha_library; set @bnum = 524580000000;update items set barcode=(@bnum:=@bnum+1) where barcode is not null; This will set a barcode of 524580000001 for the first book and each subsequent book will be assigned a number that is one higher than the last so the second will be 524580000002 and so on. I am not sure it is necessary but I also did a zebra reindex afterwards. (Again "library" is your Koha instance name.) sudo koha-rebuild-zebra -f -v library Thank you, Father Vlasie IT Director St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A. Website: www.spots.school

1 0

Loan Period
by Ma. Victoria H. Silva-Manuel 19 Nov '19

19 Nov '19

Hi. Our loan period is fixed at 7 hours, even if I changed the "loan period" and "unit" in the "Circulation and Fine Rules". Please help. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Problem with patron cards - no barcode or image
by Rick Conrad 19 Nov '19

19 Nov '19

Hi, I’m trying to create patron cards that have barcodes as well as the library’s logo, but the barcode and the image never seem to show up. Can anybody see what I’m doing wrong? (It seemed like a bug to me, so I filed that here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23654 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23654>.) Thanks for any help! -Rick Conrad PS - In my first version of this email, I included screenshots of my settings so maybe somebody could see what the problem is. Unfortunately that put it over the size limit for the listserv, so it got held for moderation and, as far as I can tell, nobody ever looked at it. So I sent a second version in which I wrote out all the details of my layout settings and template settings with the same goal. That email was rejected by the mailserver as spam…. So… I really want to provide all the details in case someone can help, but it appears to be impossible. The best I can do is humbly ask anyone who might be able to help to follow the link to the bug report where you can find all the details.

2 1

Education meeting summary
by Caroline Cyr-La-Rose 19 Nov '19

19 Nov '19

Hello everyone! We had an interesting meeting today with colleagues who do training or who are interested in Koha education. Here are the main points we talked about : - None of us have used the training resources wiki pages we created last time, but we figured we'd leave them there as reference in case other people are using them. - We talked about how the Documentation Plan might support training and the production of training material. - We would like to be able to easily reuse the manual as training manual; David Nind will do a test with something simple like loans to see if we can export the manual as custom training material - David Nind will also check about how licensing can affect this process. - Ideally, we would like to reformat the manual to make it easily reusable as training material by taking different approaches (such as how-to's for single tasks, reference sections, concept explanations and troubleshooting sections) and also cater to different learning styles by incorporating screenshots, (links to) videos if available, and text. - Also, we would like the docs team to find a way to create permanent links to topics in the manual in order to refer to those topics regardless of the version in blog posts or other materials. - Finally, it was suggested that we incorporate a Glossary in the manual to make searching easier when users are not sure of the terminology. - And lastly, though it is not directly tied to training, we talked about the idea of creating promotional texts or FAQ's for decision makers looking to switch to Koha. The next meeting will take place on April 14 at 19 UTC. Thanks to all those who participated and thanks to ByWater Solutions for hosting the meeting in Zoom! -- 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

Web installer stuck on Mojolicious::Plugin::OpenAPI
by King, Fred 18 Nov '19

18 Nov '19

Esteemed Colleagues, New problem, different Koha system. I’m trying to install Koha 19.05 and the web installer is saying that a required Perl module is missing: Mojolicious::Plugin::OpenAPI Computer: Raspberry Pi 4 with 2GB RAM OS: Current version of Raspbian I’ve tried installing the Mojolicious module (“cpan Mojolicious”, also “curl -L https://cpanmin.us | perl - -M https://cpan.metacpan.org -n Mojolicious” ). When I try ”cpanm -I Mojolicious::Plugin::OpenAPI@1.15” I get “cpanm: command not found.” I’ve looked through the Koha archives but haven’t found anything useful. Does anyone have advice on how to solve this, or at least get around it? I’m giving a talk on installing Koha on a Raspberry Pi next week at the koha-US conference, and I don’t have enough poetry to fill an empty 45 minutes. 😊 Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org A library in the middle of a community is a cross between an emergency exit, a life-raft and a festival. They are cathedrals of the mind; hospitals of the soul; theme parks of the imagination. On a cold rainy island, they are the only sheltered public spaces where you are not a consumer, but a citizen instead. --Caitlin Moran ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

4 5

delete records Pls help me
by takan bhatt 18 Nov '19

18 Nov '19

takan bhatt <takan.bhatt(a)gmail.com> Sat, Nov 9, 5:32 PM (2 days ago) to koha Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be.. I followed following procedure. *udo su* *mysql -uroot -p* *use koha_library;* *SET FOREIGN_KEY_CHECKS=0;* *TRUNCATE items; * *TRUNCATE deleteditems;* *TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio;* *SET FOREIGN_KEY_CHECKS=1;* *quit* However, all the biblio are still in catalogue ? How to overcome this? If not possible then show me how to uninstall KOHA. Rajesh Bhatt Librarian, GRIMS VAPI

5 4