Record matching for biblios without ISBN or ISSN
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options? -- 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)
Elaine, In your matching rules, use the following settings: Search index: Control-number Score: 1000 Tag: 001 Subfields: [blank] Offset: 0 Length: 0 Normalization Rule: [blank] and that should allow you to match on the 001 field. -Ian On Mon, Oct 31, 2011 at 1:06 PM, Elaine Bradtke <eb@efdss.org> wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options? -- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
If you've kept the default mapping, you should be able to configure a rule to match on the 999c -- that's the Koha biblionumber. Jane Wagner Senior Project Manager LibLime, a division of PTFS Content Management and Library Solutions 11501 Huff Court North Bethesda, MD 20895 (301) 654-8088 x 151 jwagner@liblime.com -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Elaine Bradtke Sent: Monday, October 31, 2011 1:06 PM To: koha@lists.katipo.co.nz Subject: [Koha] Record matching for biblios without ISBN or ISSN Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options? -- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Elaine, Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail. Cheers. Ian On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
AHA! Thanks, I had a feeling there was something I could do. . . just not looking in the right place! Sorry to have bothered you all with such a simple question. Need more coffee. Elaine On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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)
Elaine, No worries, glad to help. Could use some coffee myself, but tomorrow (it's late in Mumbai, where many of us are enjoying KohaCon '11!). Cheers, -Ian On Mon, Oct 31, 2011 at 1:28 PM, Elaine Bradtke <eb@efdss.org> wrote:
AHA! Thanks, I had a feeling there was something I could do. . . just not looking in the right place! Sorry to have bothered you all with such a simple question. Need more coffee. Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
I followed the example here (control number is what I want it to match on) http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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)
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing: Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match. It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit. Cheers. On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on) http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options? -- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297
On 31/10/2011 17:06, Elaine Bradtke wrote: phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
That complicates matters. I may have to rethink things. Thanks for the info. Elaine On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on) http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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)
Elaine, What about your 035 field? Is that filled in with a unique value in your target biblios? -Ian On Mon, Oct 31, 2011 at 2:19 PM, Elaine Bradtke <eb@efdss.org> wrote:
That complicates matters. I may have to rethink things. Thanks for the info. Elaine
On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on)
http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules
But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that
quite a
lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
No, somewhere along the line we went with 001 over 035. Elaine On Mon, Oct 31, 2011 at 6:25 PM, Ian Walls <ian.walls@bywatersolutions.com> wrote:
Elaine,
What about your 035 field? Is that filled in with a unique value in your target biblios?
-Ian
On Mon, Oct 31, 2011 at 2:19 PM, Elaine Bradtke <eb@efdss.org> wrote:
That complicates matters. I may have to rethink things. Thanks for the info. Elaine
On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on)
http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
-- 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)
Elaine, Your easiest option is probably to match on 999$c. If you're exporting then reimporting, it is guaranteed to be present and match uniquely. I believe there's even a bug open about adding that as a default matching rule, since lots of people end up needing it. I can't find said bug, though. If you can't find it either, I suggest you file one, because that rule really should be included in default Koha installations. To use it, follow the instructions for the 001 given earlier in this thread, but change Control-number to biblionumber and field to 999c Regards, Jared 2011/10/31 Ian Walls <ian.walls@bywatersolutions.com>
Elaine,
What about your 035 field? Is that filled in with a unique value in your target biblios?
-Ian
On Mon, Oct 31, 2011 at 2:19 PM, Elaine Bradtke <eb@efdss.org> wrote:
That complicates matters. I may have to rethink things. Thanks for the info. Elaine
On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on)
http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules
But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that
quite a
lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I
can
match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
Will try that. Thanks. On Mon, Oct 31, 2011 at 6:30 PM, Jared Camins-Esakov <jcamins@cpbibliography.com> wrote:
Elaine, Your easiest option is probably to match on 999$c. If you're exporting then reimporting, it is guaranteed to be present and match uniquely. I believe there's even a bug open about adding that as a default matching rule, since lots of people end up needing it. I can't find said bug, though. If you can't find it either, I suggest you file one, because that rule really should be included in default Koha installations. To use it, follow the instructions for the 001 given earlier in this thread, but change Control-number to biblionumber and field to 999c Regards, Jared
2011/10/31 Ian Walls <ian.walls@bywatersolutions.com>
Elaine,
What about your 035 field? Is that filled in with a unique value in your target biblios?
-Ian
On Mon, Oct 31, 2011 at 2:19 PM, Elaine Bradtke <eb@efdss.org> wrote:
That complicates matters. I may have to rethink things. Thanks for the info. Elaine
On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on)
http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote: > > Ours is a rather quirky collection, I know. But an awful lot of it > doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 > fall into this category). I am working on a project to batch change > all the biblios in a particular collection. Selecting them, > downloading them, and editing the MARC records was easy. Now I > would > like to upload them and overwrite the old records. This only seems > possible for the 300 biblios with an ISBN. > We have unique internal control numbers (001). Is there any way I > can > match the records with this field instead? > If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
-- 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)
Hooray! the 999c match worked perfectly. Thank you! Elaine On Mon, Oct 31, 2011 at 6:32 PM, Elaine Bradtke <eb@efdss.org> wrote:
Will try that. Thanks.
On Mon, Oct 31, 2011 at 6:30 PM, Jared Camins-Esakov <jcamins@cpbibliography.com> wrote:
Elaine, Your easiest option is probably to match on 999$c. If you're exporting then reimporting, it is guaranteed to be present and match uniquely. I believe there's even a bug open about adding that as a default matching rule, since lots of people end up needing it. I can't find said bug, though. If you can't find it either, I suggest you file one, because that rule really should be included in default Koha installations. To use it, follow the instructions for the 001 given earlier in this thread, but change Control-number to biblionumber and field to 999c Regards, Jared
2011/10/31 Ian Walls <ian.walls@bywatersolutions.com>
Elaine,
What about your 035 field? Is that filled in with a unique value in your target biblios?
-Ian
On Mon, Oct 31, 2011 at 2:19 PM, Elaine Bradtke <eb@efdss.org> wrote:
That complicates matters. I may have to rethink things. Thanks for the info. Elaine
On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on)
http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote: > > Hi Elaine, > > Yes as long as your unique number is in the 001 you can set up a new > match > rule referring to "Control-number" and match on that. I use that > quite a > lot. I think I posted about it about a year ago. > The Community documentation should be enough to get you going but do > come > back if you need more detail. > > Cheers. > Ian > > On 31/10/2011 17:06, Elaine Bradtke wrote: >> >> Ours is a rather quirky collection, I know. But an awful lot of it >> doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 >> fall into this category). I am working on a project to batch change >> all the biblios in a particular collection. Selecting them, >> downloading them, and editing the MARC records was easy. Now I >> would >> like to upload them and overwrite the old records. This only seems >> possible for the 300 biblios with an ISBN. >> We have unique internal control numbers (001). Is there any way I >> can >> match the records with this field instead? >> If not, what are my other options? > > -- > Ian Bays > Director of Projects > PTFS Europe > mobile: +44 (0) 7774995297 > phone: +44 (0) 800 756 6803 > skype: ian.bays > email: ian.bays@ptfs-europe.com > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
-- 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)
-- 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)
Curiously, when I searched for s-01403 (the control number for one of the biblios in question) in the simple search box, the result was perfect, just that biblio and no others. We're running 3.2 if it makes a difference. Elaine On Mon, Oct 31, 2011 at 6:14 PM, Ian Bays <ian.bays@ptfs-europe.com> wrote:
Hi. The Control-number search term is set up in zebra as word or phrase. You can check what is found from the simple-search box by typing:
Control-number="123456" and searching for that. However if you use hyphens then that is treated as white space so if you have records with: 123-456 and one with 123-678 and one with 123 in the 001 tag then searching for 123 will find them all. This might explain why they do not find a unique match.
It might be possible to change the zebra configuration or add an index to be more literal but that takes it to another level. I hope that explains a bit.
Cheers.
On 31/10/2011 18:01, Elaine Bradtke wrote:
I followed the example here (control number is what I want it to match on) http://manual.koha-community.org/3.2/en/catadmin.html#recordmatchingrules But now I don't get any matches at all. Our control numbers are a combination of letters and numbers with punctuation (sometimes dashes, sometimes full stops). There is no explanation of what offset, length and normalization mean so I am just blindly imitating what's there rather than making an informed choice. Does our punctuation require different settings? Elaine
On Mon, Oct 31, 2011 at 5:22 PM, Ian Bays<ian.bays@ptfs-europe.com> wrote:
Hi Elaine,
Yes as long as your unique number is in the 001 you can set up a new match rule referring to "Control-number" and match on that. I use that quite a lot. I think I posted about it about a year ago. The Community documentation should be enough to get you going but do come back if you need more detail.
Cheers. Ian
On 31/10/2011 17:06, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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)
Elaine, What version of Koha are you using? You might want to look at bug 6113 It worked for us on 3.4 On 1:59 PM, Elaine Bradtke wrote:
Ours is a rather quirky collection, I know. But an awful lot of it doesn't have an ISBN or ISSN (1364 biblios in a collection of 1664 fall into this category). I am working on a project to batch change all the biblios in a particular collection. Selecting them, downloading them, and editing the MARC records was easy. Now I would like to upload them and overwrite the old records. This only seems possible for the 300 biblios with an ISBN. We have unique internal control numbers (001). Is there any way I can match the records with this field instead? If not, what are my other options?
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Fax: 601/576-6824
participants (6)
-
Elaine Bradtke -
Ian Bays -
Ian Walls -
Jared Camins-Esakov -
Linda Culberson -
Wagner, Jane