- Koha - lists.katipo.co.nz

[koha] BULK IMPORT REPORTS
by muiru james 29 Mar '21

29 Mar '21

Hi, Is there a way to add export reports from one system and add them in bulk to a new server? Regards James

3 5

Koha Community Newsletter: March 2021
by Koha Newsletter 28 Mar '21

28 Mar '21

The Koha Community Newsletter for March 2021 is here: https://koha-community.org/koha-community-newsletter-march-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

Re: [Koha] Step by step guide to enable REST API koha 20.11
by Tomas Cohen Arazi 26 Mar '21

26 Mar '21

Those look correct. Have you seen koha-testing-docker? Kind regards El vie, 26 mar 2021 a las 8:44, Javier Legido at Kedu (< javier.legido(a)kedu.coop>) escribió: > Good morning. > > Many thanks for your quick reply Tomas. > > I will do the test with stable debian version just right now, but maybe > you (or someone else) can confirm or discard if the provided steps are > accurate in order to get the REST API up and running. > > Thanks. > > -- > > Javier Legido Martínez > javier.legido(a)kedu.coop > +34 600 840 948 > > Kedu SCCL > https://kedu.coop > info(a)kedu.coop > > On Fri, 26 Mar 2021 at 12:36, Tomas Cohen Arazi <tomascohen(a)gmail.com> > wrote: > >> Hi, we don't support Debian testing (things change often regarding >> dependencies and available packages). >> >> Please use the debian:buster image instead. >> >> Kind regards >> >> El vie., 26 mar. 2021 1:50, Javi Legido <javi(a)legido.com> escribió: >> >>> Hi there. >>> >>> I would like to enable REST API, but so far i got 404 while trying to >>> access: >>> >>> http://mykoha-intra.mydnsname.org/api/v1/.html >>> >>> http://mykoha.myDNSname.org/api/v1/.html >>> >>> I enabled below options: >>> >>> OPACBaseURL => http://mykoha.myDNSname.org >>> OpacPublic >>> RESTBasicAuth >>> RESTOAuth2ClientCredentials >>> RESTPublicAnonymousRequests >>> RESTPublicAPI >>> >>> I see below errors in '/var/log/koha/mykoha/plack.log': >>> >>> 172.17.0.1 - - [26/Mar/2021:04:42:52 +0000] "GET /api/v1/ >>> app.pl/api/v1/.html >>> HTTP/1.1" 404 - "-" "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) >>> Gecko/20100101 Firefox/78.0" >>> >>> Many thanks in advice. >>> >>> Now verbose things, configuration files and step by step ways to >>> reproduce >>> the issue: >>> >>> 1. Configuration files >>> >>> /etc/apache2/sites-enabled/mykoha.conf >>> >>> # Koha instance mykoha Apache config. >>> >>> # OPAC >>> <VirtualHost *:80> >>> <IfVersion >= 2.4> >>> Define instance "mykoha" >>> </IfVersion> >>> Include /etc/koha/apache-shared.conf >>> # Include /etc/koha/apache-shared-disable.conf >>> Include /etc/koha/apache-shared-opac-plack.conf >>> Include /etc/koha/apache-shared-opac.conf >>> >>> ServerName mykoha.myDNSname.org >>> SetEnv KOHA_CONF "/etc/koha/sites/mykoha/koha-conf.xml" >>> AssignUserID mykoha-koha mykoha-koha >>> >>> ErrorLog /var/log/koha/mykoha/opac-error.log >>> # TransferLog /var/log/koha/mykoha/opac-access.log >>> </VirtualHost> >>> >>> # Intranet >>> <VirtualHost *:80> >>> <IfVersion >= 2.4> >>> Define instance "mykoha" >>> </IfVersion> >>> Include /etc/koha/apache-shared.conf >>> # Include /etc/koha/apache-shared-disable.conf >>> Include /etc/koha/apache-shared-intranet-plack.conf >>> Include /etc/koha/apache-shared-intranet.conf >>> >>> ServerName mykoha-intra.myDNSname.org >>> SetEnv KOHA_CONF "/etc/koha/sites/mykoha/koha-conf.xml" >>> AssignUserID mykoha-koha mykoha-koha >>> >>> ErrorLog /var/log/koha/mykoha/intranet-error.log >>> # TransferLog /var/log/koha/mykoha/intranet-access.log >>> </VirtualHost> >>> >>> /etc/koha/apache-shared-opac-plack.conf >>> >>> # Apache configuration settings that are shared for every Koha instance. >>> # This file contains settings for the Plack configuration of the OPAC. >>> # >>> # This file should be included from an instance's >>> # /etc/apache2/site-available file, from within the VirtualHost section >>> # for the OPAC. >>> >>> # Plack is only available out-of-the-box for Apache 2.4.7+ setups >>> <IfVersion >= 2.4.8> >>> <IfModule mod_proxy_http.c> >>> >>> ProxyPreserveHost On >>> >>> RequestHeader set X-FORWARDED-PROTO "https" env=HTTPS >>> >>> # Point the OPAC site to Plack >>> ProxyPass /index.html "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/opac/opac-main.pl" >>> ProxyPassReverse /index.html >>> "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/opac/opac-main.pl" >>> ProxyPass /cgi-bin/koha >>> "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/opac" >>> ProxyPassReverse /cgi-bin/koha >>> "unix:/var/run/koha/${instance}/plack.sock|http://localhost/opac" >>> >>> # Point the /api endpoint to Plack >>> RewriteCond %{REQUEST_URI} !^/api/v[0-1]+/app.pl >>> RewriteRule ^/api/(v[0-9]+)/(.*)$ /api/$1/app.pl/api/$1/$2 >>> [L,PT] >>> >>> ProxyPass /api "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/api" >>> ProxyPassReverse /api "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/api" >>> >>> </IfModule> >>> </IfVersion> >>> >>> /etc/koha/apache-shared-intranet-plack.conf >>> >>> # Apache configuration settings that are shared for every Koha instance. >>> # This file contains settings for the Plack configuration of the >>> intranet. >>> # >>> # This file should be included from an instance's >>> # /etc/apache2/site-available file, from within the VirtualHost section >>> # for the intranet. >>> >>> # Plack is only available out-of-the-box for Apache 2.4.8+ setups >>> <IfVersion >= 2.4.8> >>> <IfModule mod_proxy_http.c> >>> >>> # FIXME: These scripts should be fixed so they >>> # don't break under plack/starman >>> ProxyPass "/cgi-bin/koha/offline_circ/process_koc.pl" "!" >>> ProxyPass "/cgi-bin/koha/tools/background-job-progress.pl" "!" >>> ProxyPass "/cgi-bin/koha/tools/batchMod.pl" "!" >>> ProxyPass "/cgi-bin/koha/tools/export.pl" "!" >>> ProxyPass "/cgi-bin/koha/tools/manage-marc-import.pl" "!" >>> ProxyPass "/cgi-bin/koha/tools/stage-marc-import.pl" "!" >>> ProxyPass "/cgi-bin/koha/tools/upload-cover-image.pl" "!" >>> ProxyPass "/cgi-bin/koha/svc/cataloguing/metasearch" "!" >>> >>> ProxyPreserveHost On >>> >>> RequestHeader set X-FORWARDED-PROTO "https" env=HTTPS >>> >>> # Point the intranet site to Plack >>> ProxyPass /index.html "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/intranet/mainpage.pl" >>> ProxyPassReverse /index.html >>> "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/intranet/mainpage.pl" >>> ProxyPass /cgi-bin/koha >>> "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/intranet" >>> ProxyPassReverse /cgi-bin/koha >>> "unix:/var/run/koha/${instance}/plack.sock|http://localhost/intranet" >>> >>> # Point the /api endpoint to Plack >>> RewriteCond %{REQUEST_URI} !^/api/v[0-1]+/app.pl >>> RewriteRule ^/api/(v[0-9]+)/(.*)$ /api/$1/app.pl/api/$1/$2 >>> [L,PT] >>> >>> ProxyPass /api "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/api" >>> ProxyPassReverse /api "unix:/var/run/koha/${instance}/plack.sock| >>> http://localhost/api" >>> >>> </IfModule> >>> </IfVersion> >>> >>> 2. Step by step way to reproduce the issue >>> >>> docker stop test && docker rm test >>> docker run \ >>> --name test \ >>> --cap-add=SYS_NICE \ >>> --cap-add=DAC_READ_SEARCH \ >>> -p 8080:8080 \ >>> -p 80:80 \ >>> -d debian:testing \ >>> bin/sh -c "while true; do echo hello world; sleep 1; done" >>> docker exec -ti test bash >>> >>> apt-get update && apt-get install -y \ >>> wget \ >>> gnupg >>> >>> wget -q -O- https://debian.koha-community.org/koha/gpg.asc | apt-key >>> add - >>> >>> echo 'deb http://debian.koha-community.org/koha stable main' | tee >>> /etc/apt/sources.list.d/koha.list >>> >>> apt-get update && apt-get install -y \ >>> koha-common \ >>> mariadb-server >>> >>> service mariadb start >>> >>> a2enmod rewrite \ >>> cgi \ >>> headers \ >>> proxy_http \ >>> && a2dissite 000-default >>> >>> service apache2 restart >>> >>> koha-create --create-db mykoha >>> >>> koha-plack --enable mykoha >>> >>> koha-plack --start mykoha >>> >>> service apache2 restart >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

2 1

Batch insert of records
by Javi Legido 26 Mar '21

26 Mar '21

Hi there. We would like to add some records (7k) to our koha 20.11 instance. After reading [1] the manual is not clear to me if this adding operation is currently possible through REST API or any other API. So far we only now how to do it through GUI, but there's any other way to automate the process through API? Thanks in advance. Javier [1] https://koha-community.org/manual/20.11/en/html/webservices.html#versioned-…

2 2

Step by step guide to enable REST API koha 20.11
by Javi Legido 26 Mar '21

26 Mar '21

Hi there. I would like to enable REST API, but so far i got 404 while trying to access: http://mykoha-intra.mydnsname.org/api/v1/.html http://mykoha.myDNSname.org/api/v1/.html I enabled below options: OPACBaseURL => http://mykoha.myDNSname.org OpacPublic RESTBasicAuth RESTOAuth2ClientCredentials RESTPublicAnonymousRequests RESTPublicAPI I see below errors in '/var/log/koha/mykoha/plack.log': 172.17.0.1 - - [26/Mar/2021:04:42:52 +0000] "GET /api/v1/app.pl/api/v1/.html HTTP/1.1" 404 - "-" "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0" Many thanks in advice. Now verbose things, configuration files and step by step ways to reproduce the issue: 1. Configuration files /etc/apache2/sites-enabled/mykoha.conf # Koha instance mykoha Apache config. # OPAC <VirtualHost *:80> <IfVersion >= 2.4> Define instance "mykoha" </IfVersion> Include /etc/koha/apache-shared.conf # Include /etc/koha/apache-shared-disable.conf Include /etc/koha/apache-shared-opac-plack.conf Include /etc/koha/apache-shared-opac.conf ServerName mykoha.myDNSname.org SetEnv KOHA_CONF "/etc/koha/sites/mykoha/koha-conf.xml" AssignUserID mykoha-koha mykoha-koha ErrorLog /var/log/koha/mykoha/opac-error.log # TransferLog /var/log/koha/mykoha/opac-access.log </VirtualHost> # Intranet <VirtualHost *:80> <IfVersion >= 2.4> Define instance "mykoha" </IfVersion> Include /etc/koha/apache-shared.conf # Include /etc/koha/apache-shared-disable.conf Include /etc/koha/apache-shared-intranet-plack.conf Include /etc/koha/apache-shared-intranet.conf ServerName mykoha-intra.myDNSname.org SetEnv KOHA_CONF "/etc/koha/sites/mykoha/koha-conf.xml" AssignUserID mykoha-koha mykoha-koha ErrorLog /var/log/koha/mykoha/intranet-error.log # TransferLog /var/log/koha/mykoha/intranet-access.log </VirtualHost> /etc/koha/apache-shared-opac-plack.conf # Apache configuration settings that are shared for every Koha instance. # This file contains settings for the Plack configuration of the OPAC. # # This file should be included from an instance's # /etc/apache2/site-available file, from within the VirtualHost section # for the OPAC. # Plack is only available out-of-the-box for Apache 2.4.7+ setups <IfVersion >= 2.4.8> <IfModule mod_proxy_http.c> ProxyPreserveHost On RequestHeader set X-FORWARDED-PROTO "https" env=HTTPS # Point the OPAC site to Plack ProxyPass /index.html "unix:/var/run/koha/${instance}/plack.sock| http://localhost/opac/opac-main.pl" ProxyPassReverse /index.html "unix:/var/run/koha/${instance}/plack.sock| http://localhost/opac/opac-main.pl" ProxyPass /cgi-bin/koha "unix:/var/run/koha/${instance}/plack.sock| http://localhost/opac" ProxyPassReverse /cgi-bin/koha "unix:/var/run/koha/${instance}/plack.sock|http://localhost/opac" # Point the /api endpoint to Plack RewriteCond %{REQUEST_URI} !^/api/v[0-1]+/app.pl RewriteRule ^/api/(v[0-9]+)/(.*)$ /api/$1/app.pl/api/$1/$2 [L,PT] ProxyPass /api "unix:/var/run/koha/${instance}/plack.sock| http://localhost/api" ProxyPassReverse /api "unix:/var/run/koha/${instance}/plack.sock| http://localhost/api" </IfModule> </IfVersion> /etc/koha/apache-shared-intranet-plack.conf # Apache configuration settings that are shared for every Koha instance. # This file contains settings for the Plack configuration of the intranet. # # This file should be included from an instance's # /etc/apache2/site-available file, from within the VirtualHost section # for the intranet. # Plack is only available out-of-the-box for Apache 2.4.8+ setups <IfVersion >= 2.4.8> <IfModule mod_proxy_http.c> # FIXME: These scripts should be fixed so they # don't break under plack/starman ProxyPass "/cgi-bin/koha/offline_circ/process_koc.pl" "!" ProxyPass "/cgi-bin/koha/tools/background-job-progress.pl" "!" ProxyPass "/cgi-bin/koha/tools/batchMod.pl" "!" ProxyPass "/cgi-bin/koha/tools/export.pl" "!" ProxyPass "/cgi-bin/koha/tools/manage-marc-import.pl" "!" ProxyPass "/cgi-bin/koha/tools/stage-marc-import.pl" "!" ProxyPass "/cgi-bin/koha/tools/upload-cover-image.pl" "!" ProxyPass "/cgi-bin/koha/svc/cataloguing/metasearch" "!" ProxyPreserveHost On RequestHeader set X-FORWARDED-PROTO "https" env=HTTPS # Point the intranet site to Plack ProxyPass /index.html "unix:/var/run/koha/${instance}/plack.sock| http://localhost/intranet/mainpage.pl" ProxyPassReverse /index.html "unix:/var/run/koha/${instance}/plack.sock| http://localhost/intranet/mainpage.pl" ProxyPass /cgi-bin/koha "unix:/var/run/koha/${instance}/plack.sock| http://localhost/intranet" ProxyPassReverse /cgi-bin/koha "unix:/var/run/koha/${instance}/plack.sock|http://localhost/intranet" # Point the /api endpoint to Plack RewriteCond %{REQUEST_URI} !^/api/v[0-1]+/app.pl RewriteRule ^/api/(v[0-9]+)/(.*)$ /api/$1/app.pl/api/$1/$2 [L,PT] ProxyPass /api "unix:/var/run/koha/${instance}/plack.sock| http://localhost/api" ProxyPassReverse /api "unix:/var/run/koha/${instance}/plack.sock| http://localhost/api" </IfModule> </IfVersion> 2. Step by step way to reproduce the issue docker stop test && docker rm test docker run \ --name test \ --cap-add=SYS_NICE \ --cap-add=DAC_READ_SEARCH \ -p 8080:8080 \ -p 80:80 \ -d debian:testing \ bin/sh -c "while true; do echo hello world; sleep 1; done" docker exec -ti test bash apt-get update && apt-get install -y \ wget \ gnupg wget -q -O- https://debian.koha-community.org/koha/gpg.asc | apt-key add - echo 'deb http://debian.koha-community.org/koha stable main' | tee /etc/apt/sources.list.d/koha.list apt-get update && apt-get install -y \ koha-common \ mariadb-server service mariadb start a2enmod rewrite \ cgi \ headers \ proxy_http \ && a2dissite 000-default service apache2 restart koha-create --create-db mykoha koha-plack --enable mykoha koha-plack --start mykoha service apache2 restart

2 2

About the "Display Order" column in Serial module
by teertha chatterjee 26 Mar '21

26 Mar '21

Hi I am trying to setup serial control on koha 19.11.12 The manual says "Display Order" is important for managing the frequencies of issue. I'm unable to understand "What is the exact purpose and functionality of this column?" can someone please help me or point me other documentation that I can go through to clear my question. Thanks in anticipation, Teertha

2 1

To be listed as a Koha Support provider in Malaysia
by Karam Qubsi 25 Mar '21

25 Mar '21

*Dear Koha community, * We would like to be listed as a support provider in Malaysia, *Company Name*: Xentral Methods Sdn Bhd (938808-H) *Contact Person*: Karam Qubsi *Contact email*: karam(a)xentralmethods.com *Website*: https://www.xentralmethods.com *Telephone*: +603-8328 0844 Please find our services page which mention koha-community.org site: https://www.xentralmethods.com/services Please do let us know if we need to provide any further information, *Thank you* *Best Regards* -- *Karam Qubsi,* Xentral Methods ( eSentral) Office: +603-8328 0844

2 2

Regarding query output from sql reports - &
by Suresh Kumar Tejomurtula 24 Mar '21

24 Mar '21

Dear all, When I download a report from koha reports, if any title or any other field having "&" in the field, the CSV will have "&" in the output instead of "&". I generally manually edit the exported data and correct "&" to "&". Is there any way to overcome this issue automatically? - Regards T. Suresh Kumar

2 3

Release of Koha 20.11.04
by Fridolin SOMERS 24 Mar '21

24 Mar '21

Hello everyone 🤗 The Koha community is proud to announce the release of Koha 20.11.04. It is a maintenance release. The full release notes are available here: https://koha-community.org/koha-20-11-04-released/ Debian packages should be available in a few days. Best regards 🤓 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

Re: [Koha] KOHA software
by Alvaro Cornejo 24 Mar '21

24 Mar '21

Hi Ebobo To copy koha list just send your email to koha(a)lists.katipo.co.nz. This email will arrive to all persons included in that list. About running koha on windows, I guess there was a project about it but not sure. You can ask the mentioned list. Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 23 mars 2021 à 07:27, EBOBO MAXWELL <ebobomaxwwell25(a)gmail.com> a écrit : > Thank you for your response. Please am sorry for bugging you will my > series of questions, please how can I copy everyone as suggested by you > and secondly how can install it on my PC since am only conversant with > windows operating system.. please can you guilde me on how I can use this > as am also a librarian by academic qualification. Thank so much for your > apt reply > > On Mon, 22 Mar 2021, 9:49 pm Alvaro Cornejo, <cornejo.alvaro(a)gmail.com> > wrote: > >> Hi Ebobo >> >> Thanks for your mail. >> >> Actually, the best learning curve is to install koha and start playing >> with it. >> >> On problems, ask this list or check koha documents. >> >> Also, when requesting for help, always copy koha users list so you will >> be able to receive feedback from more people. >> >> Regards, >> >> Alvaro >> >> >> >> |----------------------------------------------------------------------------------------| >> Stay safe / Cuídate/ Reste sécurisé >> *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et >> à mesure. >> *q *Recycle always / Recicla siempre / Recyclez toujours >> P Print only if absolutely necessary / Imprime solo si es necesario / >> Imprimez seulement si nécessaire >> >> >> Le sam. 20 mars 2021 à 13:12, EBOBO MAXWELL <ebobomaxwwell25(a)gmail.com> >> a écrit : >> >>> good day, i subscribed to the mail list of Koha and i saw your >>> complain about an eorror, well i do notnhave solutions to your issue but >>> wanted if you can be of help to me as regards learning how to use Koha >>> since it is an open sources software. can you share with me your learning >>> curve about how you learn to use Koha? thank you for your nice response in >>> anticipation. >>> >>

4 4