- Koha - lists.katipo.co.nz

Connecting to an outside database for borrower info
by Elaine Bradtke 05 May '21

05 May '21

Members of our Society have the ability to borrow items from the library. I am given a quarterly update of the membership list that I convert into a file that will upload to Koha. My colleagues were wondering if there was a way to avoid this process and connect directly to the membership database (Spektrix). It's new, and I don't have access to it, so I don't know anything about it. It seems to me that this won't work because the loan information is stored in Koha. Has anyone tried to connect to an outside database for borrowers? I'm imagining this would involve a complicated interface. Elaine Bradtke VWML <https://www.vwml.org> English Folk Dance and Song Society <https://www.efdss.org> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

1 0

Re: [Koha] Version 20.11.05 translation of the pt-BR language went backwards.
by Jonathan Druart 04 May '21

04 May '21

Victor, Please keep your answers on the list. The message is telling you that something is wrong for the translated string. Have a look at pt-BR-staff-prog.po and search for "Trabalho cron", you will notice (at line 3785) that there is a '%' that should be '%s' Note that fixing it won't fix the string, there is a problem with the number of "%s". I will let you count but it seems that there is one extra after "Repor mapeamentos" Regards, Jonathan Le sam. 1 mai 2021 à 16:23, Victor Barroso Oliveira <vbovictor(a)gmail.com> a écrit : > > Ubuntu 20 Koha 20.11.5 > This has already happened in previous updates and I was instructed to follow to fix the problem until a new version was released. > "If you want to patch locally you must edit pt-BR-staff-prog.po and fix > line 6006 #: intranet-tmpl/prog/en/includes/tools-menu.inc:102 (msgstr > must have the same content as msgid) > Then retranslate pt-BR" > > This solution is not resolving. > When we try to update the sudo language koha-translate --update en-BR presents the following message. > > Trabalho cron : Completely confused parametrizing -- msgid: %s %sMotor de pesquisa %s%s %s %s %s %s %s %sAdicionar %sExcluir %sModificar %sEmpr▒stimo %sDevolu▒▒o %sCriar %sCancelar %sResumo %sSuspender %sRenovar %sAlterar senha %sAdicionar mensagem de circula▒▒o %sExcluir mensagem de circula▒▒o %sAlterar o status da solicita▒▒o %sILL aviso enviado ao usu▒rio %sOpera▒▒o %sEditar mapeamentos %sRepor mapeamentos %s%s %s %s %s %s %s %sIntranet %sOPAC %sSIP %sLinha de comando %sREST API %sTrabalho cron % %s %s %s > > Em sáb., 1 de mai. de 2021 às 09:22, Katrin Fischer <katrin.fischer.83(a)web.de> escreveu: >> >> Hi Victor, >> >> please keep this on the mailing list. I am sorry, I am still not sure what the issue is. Can you please give an example? Strings can become untranslated between versions when there are changes, if we have an example, it's easier to understand what might have happened. >> >> Katrin >> >> On 01.05.21 13:59, Victor Barroso Oliveira wrote: >> >> After updating to version 20.11.5, koha did not provide a correct translation for the pt-BR language. The previous version 20.11.4 was presenting a correct translation for this language. >> >> >> Em sáb, 1 de mai de 2021 08:39, Katrin Fischer <katrin.fischer.83(a)web.de> escreveu: >>> >>> Hi Victor, >>> >>> can you explain what you mean by "went backwards"? >>> >>> If there are more untranslated strings this could be due to changes >>> being made between versions. You can see the state of translations on >>> https://translate.koha-community.org/pt_BR/ (you might have to register, >>> but it only requires an email address). >>> >>> Hope this helps, >>> >>> Katrin >>> >>> On 30.04.21 16:02, Victor Barroso Oliveira wrote: >>> > Good morning, >>> > After updating to version 20.11.05 I noticed that the translation of the >>> > pt-BR language went backwards. >>> > Victor >>> > _______________________________________________ >>> > >>> > Koha mailing list http://koha-community.org >>> > Koha(a)lists.katipo.co.nz >>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

(no subject)
by Victor Barroso Oliveira 03 May '21

03 May '21

Good morning, On Ubuntu 20 and Koha 20.11.05. After updating to 20.11.05, Koha is not translating correctly into the pt-BR language. Would it be a bug or dictionary update failure?

1 0

koha-US May 2021 Events & Meetings
by Jason Robb 03 May '21

03 May '21

koha-US online meetings and events are open to all. See our calendar for a full list: http://koha-us.org/calendar/. *Community Challenge* Don't forget! The Spring into Fitness Challenge is taking place throughout the month of May. Learn more here: https://runsignup.com/Race/CA/anywhere/KohaCommunityChallengeSpringintoFitn… *Meetings* Board Meeting - Wednesday, May 5 @ 8:30a PT / 11:30a ET / 15:30 UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1GjSLt0wvYxVzisOvr9thUduddQD1uQghSqo32Ot… General Meeting - Wednesday, May 12 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Circulation - Tuesday, May 4 @ @ 10:00a PT / 1:00p ET / 17:00 UTC Cataloging - Thursday, May 6 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, May 11 @ 8:00a PT / 11:00p ET / 15:00 UTC Acquisitions - Tuesday, May 18 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, May 20 @ 10:00a PT / 1:00p ET / 17:00 UTC Demonstration - Tuesday, May 25 @ 8:00a PT / 11:00a ET / 15:00 UTC Books & Crafts - Wednesday, May 26 @ 5:00p PT / 8:00p ET / 00:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more, view past meetings, and sign up for topic-specific mailing lists. Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Elasticsearch reindex failing for authorities
by Aleisha Amohia 03 May '21

03 May '21

Hi all, We have a site with around 600,000 authority records and have enabled elasticsearch. Reindexing and searching has worked easily for biblios (there are just over 10,000 biblios) but fails for authorities. $ sudo koha-elasticsearch --rebuild -d -a -v <instance> [19024] Checking state of authorities index [19024] Dropping and recreating authorities index [19024] Indexing authorities And then it just hangs there for ages until the server runs out of memory and dies. We're running ES 6.x on Koha 20.05.x. I tried running the script directly and specifying an authid and that worked as expected. $ perl /usr/share/koha/bin/search_tools/rebuild_elasticsearch.pl -a -d -v -ai 2135575 [17684] Checking state of authorities index [17684] Dropping and recreating authorities index [17684] Indexing authorities [17684] Committing final records... [17684] Total 1 records indexed It feels like this is happening because we have too many authority records. Is there a way to fix this? Has anyone come across this before? Thanks! -- *Aleisha Amohia*(she/her)

3 6

Continued koha-common Upgrade Challenges
by skaman.tx＠gmail.com 01 May '21

01 May '21

Our koha installation is on Debian 10. I have previously engaged the list for upgrade challenges specifically related to the outcome of the Debian package koha-common upgrade scripts. We are stuck at koha-common version 20.05.xx at this point. My latest attempt to upgrade to 20.11.04-1 resulted in the following three error messages. Is there any way to manually alter the correct table(s) to fix the database issues? I'm not sure what the "Failed to enable unit" message means. ---------------------------- Setting up koha-common (20.11.04-1) ... Installing new version of config file /etc/cron.daily/koha-common ... Installing new version of config file /etc/init.d/koha-common ... Installing new version of config file /etc/koha/SIPconfig.xml ... Installing new version of config file /etc/koha/apache-shared-intranet-plack.conf ... Installing new version of config file /etc/koha/apache-shared-intranet.conf ... Installing new version of config file /etc/koha/apache-shared-opac.conf ... Installing new version of config file /etc/koha/koha-conf-site.xml.in ... Installing new version of config file /etc/koha/log4perl-site.conf.in ... Installing new version of config file /etc/koha/plack.psgi ... Installing new version of config file /etc/koha/zebradb/etc/phrases-icu.xml ... Installing new version of config file /etc/koha/zebradb/etc/word-phrase-utf.chr ... Upgrading database schema for [database] ....... Upgrade to 20.06.00.031 done [10:19:38]: Bug 22789 - Add non_priority column on reserves and old_reserves tables DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [for Statement "ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 22709. DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [for Statement "ALTER TABLE `deleteditems` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER new_status`"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 22715. ...... Failed to enable unit: Unit /run/systemd/generator.late/koha-common.service is transient or generated. ---------------------------- NOTE: When I then run "/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -z" in this post-upgrade state I get the following error for each biblio record: DBD::mysql::st execute failed: Unknown column 'me.exclude_from_local_holds_priority' in 'field list' [for Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`, `me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`, `me`.`booksellerid`, `me`.`homebranch`, `me`.`price`, `me`.`replacementprice`, `me`.`replacementpricedate`, `me`.`datelastborrowed`, `me`.`datelastseen`, `me`.`stack`, `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, `me`.`itemlost`, `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`, `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`, `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`, `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`timestamp`, `me`.`location`, `me`.`permanent_location`, `me`.`onloan`, `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`, `me`.`materials`, `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`, `me`.`enumchron`, `me`.`copynumber`, `me`.`stocknumber`, `me`.`new_status`, `me`.`exclude_from_local_holds_priority` FROM `items` `me` WHERE ( `me`.`itemnumber` = ? )" with ParamValues: 0=1] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 686. Any help would be greatly appreciated. I fear we are getting farther and farther behind on koha-common versions since we cannot seem to get past the database schema upgrade errors. Scott Leafe Scriptel Ministries Houston, Texas

6 9

Re: [Koha] Version 20.11.05 translation of the pt-BR language went backwards.
by Katrin Fischer 01 May '21

01 May '21

Hi Victor, please keep this on the mailing list. I am sorry, I am still not sure what the issue is. Can you please give an example? Strings can become untranslated between versions when there are changes, if we have an example, it's easier to understand what might have happened. Katrin On 01.05.21 13:59, Victor Barroso Oliveira wrote: > After updating to version 20.11.5, koha did not provide a correct > translation for the pt-BR language. The previous version 20.11.4 was > presenting a correct translation for this language. > > Em sáb, 1 de mai de 2021 08:39, Katrin Fischer > <katrin.fischer.83(a)web.de <mailto:katrin.fischer.83@web.de>> escreveu: > > Hi Victor, > > can you explain what you mean by "went backwards"? > > If there are more untranslated strings this could be due to changes > being made between versions. You can see the state of translations on > https://translate.koha-community.org/pt_BR/ > <https://translate.koha-community.org/pt_BR/> (you might have to > register, > but it only requires an email address). > > Hope this helps, > > Katrin > > On 30.04.21 16:02, Victor Barroso Oliveira wrote: > > Good morning, > > After updating to version 20.11.05 I noticed that the > translation of the > > pt-BR language went backwards. > > Victor > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > <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 > <https://lists.katipo.co.nz/mailman/listinfo/koha> > _______________________________________________ > > Koha mailing list http://koha-community.org > <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 > <https://lists.katipo.co.nz/mailman/listinfo/koha> >

1 0

Version 20.11.05 translation of the pt-BR language went backwards.
by Victor Barroso Oliveira 01 May '21

01 May '21

Good morning, After updating to version 20.11.05 I noticed that the translation of the pt-BR language went backwards. Victor

2 1

Koha Community Newsletter: April 2021
by Koha Newsletter 01 May '21

01 May '21

The Koha Community Newsletter for April 2021 is here: * https://koha-community.org/koha-community-newsletter-april-2021/ Many thanks to everyone who submitted articles and news to last month's newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Configure Koha for sending messages and notices via SMS.
by Victor Barroso Oliveira 30 Apr '21

30 Apr '21

Good morning, In version 20.11.4 Some colleague in the group has already managed to configure Koha for sending messages and notices via SMS. Koha has this feature but I'm having trouble getting it to work. Thanks, Victo

2 1