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.mora...@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 <e...@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 >> > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha