Also export contains items in 952/995 so records with a lot of items may
be too big
Le 14/02/2025 à 12:46, Thomas Klausner a écrit :
Hi!
On Fri, Feb 14, 2025 at 10:11:18AM +0000, Сычев Игорь Алексеевич wrote:
How do I find these records?
I assume you want to find the IDs of those records in your Koha DB?
This SQL should list the 10 biblios with the largest metadata (i.e. MARC data):
select biblionumber,length(metadata) from biblio_metadata order by 2 desc
limit 10;
But: depending on your setup etc biblio_metadata.metadata might be MARCXML or
USMARC (or maybe something else) (check biblio_metadata.format).
MARCXML doesn't have this size limit, but USMARC does (and this causes the most
funny bugs...)
And MARCXML takes much more space than USMARC (because of all the XML fluff),
so you might get different lengths from the DB. But I would assume that the
longer the MARCXML content is, the longer the USMARC will be.
root@koha:~# /usr/share/koha/bin/export_records.pl --record-type=bibs
--filename=koha-bibs.mrc
Do you need to export as USMARC? It is (IMO) a very horrible format, and
MARCXML (while also horrible) is less so.
Greetings,
domm
--
Fridolin SOMERS <fridolin.som...@biblibre.com>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
