This is excellent! Thank you. One thing that would make it more useful for us. I would like to limit the search by format. We have a lot of sound recordings that are field collections, and look like duplicates, but they are not. Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (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) On Mon, Oct 9, 2017 at 11:35 AM, Josef Moravec <josef.moravec@gmail.com> wrote:
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
Josef
po 9. 10. 2017 v 18:37 odesÃlatel Elaine Bradtke <eb@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
VWML 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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha