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

Incorrect "Progress" when importing MARC records in koha-testing-docker
by David Cook 23 Jan '23

23 Jan '23

Hi folks, Is anyone else having an incorrect value in "Progress" when importing MARC records in koha-testing-docker? I just uploaded 440 records but it says "Progress: 2680 / 440". -- As an aside, the MARCXML I'm using is the product of some MARCXML editing code I've written in just over 100 lines of HTML and Javascript. It does import jQuery for convenience, but everything else runs 100% locally. You upload it to the browser locally, use Javascript to make the modifications, and then download the MARCXML from your local browser. At some point, I want to write some PowerShell scripts to edit MARCXML as well, but I figure this is a bit more user-friendly. Right now, I've hard-coded the changes, but a person could make a nice UI to make it more flexible. The goal is to allow complex editing of MARCXML in environments where you can't install and run your own programming language interpreters or MarcEdit. I figure PowerShell is sometimes locked down in corporate environments, but browsers are often available and it has an embedded Javascript interpreter. Maybe some corporate environments block opening local HTML documents. I don't know. Anyway, It was a fun little experiment. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

1 0

Adding "web pages" via Koha Plugins
by David Cook 23 Jan '23

23 Jan '23

Hi all, What do folk think about adding "web pages" via Koha Plugins? At the moment, we can inject REST API routes and serve static files, but we don't really have a way of creating web pages on the OPAC (or the Staff Interface) that can be interacted with by a user without plugin permissions. At the moment, there are a few options for providing this functionality. You could create a custom page via opac-page.pl and inject Javascript using "opac_js", but that involves some manual work from staff users. Alternatively, you could serve a HTML page from a REST API endpoint, but that's a corruption of the REST API. I suppose a Koha plugin could insert a page into the "additional_contents" table, although there doesn't seem to be a robust machine friendly way of detecting if the page was added by a plugin. Plus it could only be referenced using an integer ID rather than a plugin namespace or shortcode. Maybe the answer would be to add a column to the "additional_contents" table? Something like "source"? (Although it would need to be more than "plugin" so that different plugins aren't stepping on each other.) But I think it would be useful to be able to add a Perl-backed page via a Koha plugin in any case. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

1 0

Error for "self_checkout" when trying to update borrower via "koha-mysql"
by David Cook 17 Jan '23

17 Jan '23

Hi all, Has anyone else seen the following error when trying to update via "koha-mysql" in koha-testing-docker? I can update borrowers via the Web UI but not via koha-mysql. I have no idea where this "self_checkout" value is coming from as well. -- koha-mysql kohadev Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 54 Server version: 10.5.17-MariaDB-1:10.5.17+maria~ubu2004 mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [koha_kohadev]> update borrowers set dateexpiry = '2031-04-04' where cardnumber = 1; ERROR 1292 (22007): Truncated incorrect DECIMAL value: 'self_checkout' David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

3 3

"Trident support team" unsubscribed
by Paul Poulain 16 Jan '23

16 Jan '23

Hello, We just removed "Trident support team" from subscribers to this list in order to avoid this continuous spamming. Sorry for the inconvenience. Happy day ! -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

1 0

New request created with ID: ##19317## from koha-devel-request@lists.koha-community.org
by Trident Support Team 16 Jan '23

16 Jan '23

1 0

New request created with ID: ##19288## from koha-devel-request@lists.koha-community.org
by Trident Support Team 16 Jan '23

16 Jan '23

1 0

New request created with ID: ##19267## from koha-devel-request@lists.koha-community.org
by Trident Support Team 16 Jan '23

16 Jan '23

1 0

New request created with ID: ##19242## from koha-devel-request@lists.koha-community.org
by Trident Support Team 16 Jan '23

16 Jan '23

1 0

New request created with ID: ##19218## from koha-devel-request@lists.koha-community.org
by Trident Support Team 16 Jan '23

16 Jan '23

1 0

New request created with ID: ##19193## from koha-devel-request@lists.koha-community.org
by Trident Support Team 16 Jan '23

16 Jan '23

1 0