- Koha - lists.katipo.co.nz

Request to be listed as a Koha Support provider
by SYDT - Frank Chou 31 Mar '21

31 Mar '21

Dear All, We are a company located in Taiwan and hope to be listed as a Koha Support provider. Here is our information below: - Company Name: Shou Yang Digital Technology Co., Ltd. - Contact Person: Frank Chou - Contact Email: frank(a)sydt.com.tw - Koha Website (EN): https://www.sydt.com.tw/pro-lm_Koha_en.asp - Koha Website (Traditional Chinese): https://www.sydt.com.tw/pro-lm_Koha.asp - Telephone: +886-2-82280288 ext. 1037 - Categories: Asia, Taiwan Hope we have chances to cooperate with you someday. Best Regards, Frank ---------------------------------------------------------------------------------------------------------- 碩陽數位科技有限公司 Shou Yang Digital Technology Tel: 02-82280288 Fax: 02-82265022 10F. No. 166, Jianyi Rd., Chung Ho Dist., New Taipei City 23511, Taiwan, R.O.C. 23511新北市中和區建一路166號10F http://www.sydt.com.tw

2 1

[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