- Koha-devel - lists.koha-community.org

Deleting entries from language_descriptions
by dcook＠prosentient.com.au 26 Apr '21

26 Apr '21

Hi all, I was looking at how to add languages to the Languages drop down in the OPAC advanced search and went down an unpleasant C4::Languages rabbithole But looking at language_descriptions, Im wondering if perhaps we could delete the following data, as I imagine its very outdated and unused: MySQL [koha_kohadev]> select * from language_descriptions; +----------+----------+------+---------------------------------------+-----+ | subtag | type | lang | description | id | +----------+----------+------+---------------------------------------+-----+ | opac | i | en | OPAC | 1 | | opac | i | fr | OPAC | 2 | | opac | i | de | OPAC | 3 | | intranet | i | en | Staff Client | 4 | | intranet | i | fr | Client personnel | 5 | | intranet | i | de | Dienstoberfläche | 6 | | prog | t | en | Prog | 7 | | prog | t | fr | Prog | 8 | | prog | t | de | Prog | 9 | At the moment, it looks like adding a language requires manual SQL queries to language_subtag_registry, language_descriptions, and language_rfc4646_to_iso639. Its a shame there is no native interface for updating it. I imagine a plugin could work out well for it, although I think for the library in mind theyll probably just do a manual insert, as its not worth the development cost David Cook Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

2 2

bulkmarcimport.pl ... re-import/update existing records
by David Schmidt 25 Apr '21

25 Apr '21

Hello koha folks, ### I hope this is the correct list for this kind of email ### We are currently exporting about 500k recods from a dabis system into a new koha installation. the export file (MARCXML) goes through some transformations using catmandu. I imported the first 25k records using this command: ``` bulkmarcimport.pl -M MARCXML -file tmp/marc_001.xml ``` after inspecting the records some of the catmandu fixes had to be updated and now im trying to update the existing koha records with the new marc_002.xml file. ``` bulkmarcimport.pl -M MARCXML -update -isbn -file tmp/marc_002.xml ``` this gives me alot of these errors: ``` WARNING: Updating record failed at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 470, <GEN24> line 190. ..Use of uninitialized value $originalid in concatenation (.) or string at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 470, <GEN24> line 194. WARNING: Updating record failed at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 470, <GEN24> line 194. ``` I also tried using -match but I havent figured out how the parameters for -match are supposed to look like ``` bulkmarcimport.pl -m MARCXML -update -match="001" -file tmp/marc_002.xml ``` ``` .Use of uninitialized value $recorddata in pattern match (m//) at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 603, <GEN24> line 2. unable to search the database for duplicates : No query entered at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 323, <GEN24> line 2. ``` help or pointers are appreciated. cheers david

2 1

Time to translate: string freeze to prepare April release
by Fridolin SOMERS 22 Apr '21

22 Apr '21

Hi, String freeze is into effect. The 20.11.x maintenance branch is preparing for 20.11.05 release. The release is scheduled for around the 26rd. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Happy translating 🌎🌍🌏 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 1

Packaging idea (for decoupling systems, Docker, etc)
by dcook＠prosentient.com.au 21 Apr '21

21 Apr '21

Hey all, What do people think about creating a "koha-libs" package which just contains Koha's libraries (ie C4/, Koha/, etc)? I'm not as familiar with DEB packaging as I am with RPM packaging, but I recently did it with a RPM-based project I manage. It allowed me to easily create other services with the same dependencies. I created these other services in other Docker containers, and I was able to use my core application libraries without having to install the entire application in every container. I share the application configuration file between them and that's it. It's not a perfect solution. Really what I want is app-service1, app-service2, app-service3, and app-common with app-common containing the shared libraries. But I like it as an intermediate step. And I would be lying if it didn't have pros and cons. One con is updating a library in app-libs, when I need a change in app-service1, and then making sure that all my deployments have the right updated library. More overhead than just having a monolithic application. On the other hand, if I want to make a change just to app-service1, I can just update it without having to affect any other parts of the application. That added overhead also gives incentive for writing cleaner testable code which does the right thing in the first place. Anyway, just food for thought. David Cook Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

3 4

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

Election of the 21.11 team will be during the general IRC meeting, 12 May 2021 at 14 UTC
by Victor Grousset/tuxayo 14 Apr '21

14 Apr '21

Sign up there :) https://wiki.koha-community.org/wiki/Roles_for_21.11 Future meeting page: https://wiki.koha-community.org/wiki/General_IRC_meeting_12_May_2021 Cheers, -- Victor Grousset/tuxayo

1 0

Fwd: FW: Librarian Supervisor- systems librarian position
by Edward Veal 14 Apr '21

14 Apr '21

*From:* Spencer Smith *Sent:* Tuesday, April 13, 2021 8:22 PM *To:* partners at bywater <partners(a)bywatersolutions.com> *Subject:* Librarian Supervisor- systems librarian position McKinney is hiring a librarian supervisor to fill a vacancy created by a recent promotion. The right candidate will lead a team responsible for library systems and technology, as well as serve as assistant branch manager at an active and busy library. We are looking for someone to continue to move us forward through continued innovation and experimentation. The candidate should understand the importance of relationships and continue to grow relationships with city IT and the Koha community. The library has been with Bywater running Koha since 2016. We currently use Envisionware for pc and print management and have a variety of automated technologies from multiple vendors (Bibliotheca, FE Technologies, Lyngsoe, and in house solutions). https://www.governmentjobs.com/careers/cityofmckinney/jobs/3047674/libraria… Please share with anyone who might be interested. Thank you, Spencer Smith Director of Libraries City of McKinney Get Outlook for Android <https://aka.ms/ghei36> The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized review, use, disclosure, duplication, distribution, or the taking of any action in reliance on this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return email and destroy all electronic and paper copies of the original message and any attachments immediately. Please note that neither City of McKinney nor the sender accepts any responsibility for viruses and it is your responsibility to scan attachments (if any). Thank You. -- *Edward Veal* email: edward.m.veal(a)gmail.com Cell: 806-445-6867

1 0

Not receiving Bugzilla CC emails?
by dcook＠prosentient.com.au 14 Apr '21

14 Apr '21

Hi all (and Chris), I might be mistaken but I don't think that I'm receiving Bugzilla CC emails. My last CC email seems to have been on 2021-04-06. I'm getting emails via koha-devel and koha-bugs but no direct emails. It looks like the Bugzilla upgrade was on 2021-04-07 and there were some mail issues then too but they were resolved? Are other people getting direct emails from Bugzilla? David Cook Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

2 3

koha-testing-docker / master broken?
by dcook＠prosentient.com.au 13 Apr '21

13 Apr '21

I was upgrading my koha-testing-docker: "We are upgrading from Koha 20.12.00.003 to 20.12.00.029" But it's failing with this error: [Tue Apr 13 00:19:38 2021] updatedatabase.pl: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'TaxRates' for key 'PRIMARY' [for Statement "UPDATE systempreferences set variable="TaxRates" WHERE variable="gist""] at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. [Tue Apr 13 00:19:38 2021] updatedatabase.pl: DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x55deb3ffd678), "DBI Exception: DBD::mysql::db do failed: Duplicate entry 'Tax"...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113 [Tue Apr 13 00:19:38 2021] updatedatabase.pl: DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH( 0x55deb376ea38), "DBI Exception: DBD::mysql::db do failed: Duplicate entry 'Tax"...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501 [Tue Apr 13 00:19:38 2021] updatedatabase.pl: DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Duplicate entry 'TaxRates' for key "..., DBI::db=HASH(0x55deb509a688), undef) called at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 23442 I'm going to try pulling new images and such but FYI. David Cook Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

2 2

Call for news - Newsletter April 2021
by Michael Kuhn 13 Apr '21

13 Apr '21

Hi I'm collecting news for the April 2021 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * News items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. 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 to be announced are fine, e. g. Kohacon. * For past events, one month back is the cut-off. 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! Michael Kuhn Editor, Koha Community Newsletter -- 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 0