Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Sent: Sunday, 14 April 2024 2:49 AM To: Magnus Enger Cc: David Cook ; koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL Yeah, dump it somewhere and we send pull requests to add missing bits El El vie, 12 abr 2024 a la(s) 9:50

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Something else to add to search_for_data_inconsistencies.pl ? I like perl-based solution, and I appreciate centralized ones, even though I suppose what you're testing is not an "inconsistency". Logo inLibro Philippe Blouin Directeur de la technologie T

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Den 12.04.2024 08:24, skrev David Cook: Not yet. At some point I need to get better at sharing Koha plugins more widely. Just dump it to Github or similar, and set the version to 0.0.1. ;-) Release early, release often. Best regards, Magnus ___

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Of Magnus Enger via Koha-devel Sent: Friday, 12 April 2024 4:09 PM To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL Den 12.04.2024 04:13, skrev David Cook via Koha-devel: > I have a RepairRecord plugin, so I might do a vers

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

0899 Online: 02 8005 0595 -Original Message- From: Koha-devel On Behalf Of Magnus Enger via Koha-devel Sent: Friday, 12 April 2024 4:06 PM To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL Hi! Den 12.04.2024 03:36, skrev

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Den 12.04.2024 04:13, skrev David Cook via Koha-devel: I have a RepairRecord plugin, so I might do a version in that first, and if that goes well I could look at upstreaming a patch… Intriguing! :-) Is it available somewhere? Best regards, Magnus

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Hi! Den 12.04.2024 03:36, skrev David Cook via Koha-devel: Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for finding bib records with invalid XML characters: select biblionumber from biblio_metadata where metadata REGEXP

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

+1 Van: Koha-devel namens David Cook via Koha-devel Verzonden: vrijdag 12 april 2024 03:36 Aan: 'Koha-devel' Onderwerp: [Koha-devel] Finding invalid XML characters in Koha data via SQL Hi all, I just wanted to share a (MariaDB) SQL report that I wrote

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Koha-devel On Behalf Of David Cook via Koha-devel Sent: Friday, 12 April 2024 11:36 AM To: 'Koha-devel' Subject: [Koha-devel] Finding invalid XML characters in Koha data

[Koha-devel] Finding invalid XML characters in Koha data via SQL

Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for finding bib records with invalid XML characters: select biblionumber from biblio_metadata where metadata REGEXP '[^\\x{0009}\\x{000A}\\x{000D}\\x{0020}-\\x{D7FF}\\x{E000}-\\x{FFFD}\\x{1000 0}-\\x{10}]+'; Newer