Re: [Koha] Adding an independent branch

[Elaine Bradtke]

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 
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("", "
> Search") as Search,
> CONCAT_WS("", " Merge")
> 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  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
>> 
>> 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 

Re: [Koha] Adding an independent branch

[Josef Moravec]

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("", " Search") as Search,
CONCAT_WS("", " Merge") 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  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
> 
> 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

[Koha] Adding an independent branch

[Elaine Bradtke]

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