[Koha] Adding an independent branch

Josef Moravec josef.moravec at gmail.com
Tue Oct 10 07:35:30 NZDT 2017

Hi Elaine,

maybe a report like this could be useful for you, it searches for
candidates to merging and have buttons to merge found records. Candidates
are grouped by author, title, part number and volume title:

SELECT GROUP_CONCAT(bi.isbn) as isbns, b.author,
CONCAT_WS(" ", ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="a"]'), ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="b"]'), ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="p"]'), ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="n"]')) as title_norm,
CONCAT_WS("", ExtractValue(bm.metadata,
'//datafield[@tag="260"]/subfield[@code="c"]'), ExtractValue(bm.metadata,
'//datafield[@tag="264"]/subfield[@code="c"]')) as year_norm,
bi.place, bi.publishercode, b.copyrightdate, COUNT(*) as recordscount ,
CONCAT_WS("", "<a class='btn btn-default btn-xs'
href='/cgi-bin/koha/cataloguing/addbooks.pl?q=", b.title, "' ><i class='fa
fa-search'></i> Search</a>") as Search,
CONCAT_WS("", "<a class='btn btn-default btn-xs'
href='/cgi-bin/koha/cataloguing/merge.pl?biblionumber=" ,
GROUP_CONCAT(b.biblionumber separator "&biblionumber="), "'><i class='fa
fa-compress'></i> Merge</a>") AS Merge
FROM biblio b
JOIN biblioitems bi ON b.biblionumber = bi.biblionumber
JOIN biblio_metadata bm ON b.biblionumber = bm.biblionumber
GROUP BY title_norm, b.author, year_norm, frameworkcode
having recordscount > 1 AND year_norm != ""
order by isbns, b.author


po 9. 10. 2017 v 18:37 odesílatel Elaine Bradtke <eb at efdss.org> napsal:

> We have a sister library with very similar content that would like to be
> added as an independent branch. I estimate the duplication rate of their
> material with ours is 95% or better.  But most of this material does not
> have an ISBN number. Their data, in its raw state is quite messy, and needs
> cleaning up, but much of this work could be avoided by linking to biblio
> records already in our catalogue.
> Given that they have a part time professional librarian on a limited
> contrantract (and I'm only part time on another limited contract) we're
> trying to work out the most efficient way to add their records as an
> independent branch.
> Plan A) I have uploaded their data into our test site, with the item
> records designated as their branch - If they did the linking and
> corrections in the test site, could I export only their branch's records
> (mostly item records, but perhaps some biblios) and import them into our
> main site? We use the 999c in record matching because so much of our
> material doesn't have ISBN.
> Plan B) Upload their data directly to the main site, but mark them all as
> Hide in OPAC until they can edit them. Simpler, but we're worried how much
> access we'll have to grant to our biblio records.
> Because we're keeping the branches very separate, would they be able to add
> items to our bib records if they are limited to editing records from their
> own branch? The problem is their cataloguing is done by volunteers and
> especially after the professional librarian's contract ends,  we want to
> very strictly limit what they can do to our records.
> What's the best way to add items belonging to another branch if you have to
> do it manually (because of no ISBN numbers?) Do you use the merge function?
> I think this will require a lot of experimentation, but I'd love to hear
> from anyone who's had experience with this process.
> Thanks!
> Elaine Bradtke
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g>
> Tel    +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is for
> the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list