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.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France