[Koha] export_records.pl

[Fridolin SOMERS]

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