Re: [Koha] Authorities lost during upgrade to 3.6.1
On 2012-01-3, at 10:09 AM, Paul wrote: Hoping someone can help, please. We recently upgraded from 3.2 to 3.6.1 and nearly everything went well during import of ~15,000 biblios, but something has happened to the authorities -- only newly catalogued (i.e. using 3.6.1) authorities appear in the staff search from http://koha-admin/cgi-bin/koha/authorities/authorities-home.pl. have you tried rebuilding the zebra 'authorities' indexes/database? PGP.sig Description: This is a digitally signed message part ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC Export problem
We have now upgraded to 3.06.02.000 mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1 Server version: Apache/2.2.16 (Debian) And still have the same problem as outlined below. Any thoughts? Elaine On Wed, Dec 28, 2011 at 6:10 PM, Elaine Bradtke e...@efdss.org wrote: I am trying to export a group of biblios in order to batch edit them. These are biblios without item records (they are actually components, part of a larger bound volume, not physical items by themselves). But when I go through the steps in MARC export and select item type: component, it produces an empty file. If I select all item types, it only exports biblios with item records attached. Which is precisely the opposite of what I'm trying to do. I also tried selecting 'don't export items' to see if that made a difference. It doesn't. Is there any way I can extract these MARC records, or do I have to fix them all one at a time? We're running 3.04.02.000 - have been too busy with a major move in the past six months to upgrade. If this is a problem that has been fixed in a later version that would be useful to know. -- 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) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC Export problem
Elaine, Limit by item type only works for records with items. It does not use the 942$c. I'm not sure there is any way to export only those records. Perhaps your best bet would be to export all records, and then filter out those records that have items? I'd probably convert the export to MARCXML and use a simple XSLT stylesheet for the filtering, but I'm sure MarcEdit has some sort of filtering capability. Regards, Jared On Wed, Jan 4, 2012 at 12:10 PM, Elaine Bradtke e...@efdss.org wrote: We have now upgraded to 3.06.02.000 mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1 Server version: Apache/2.2.16 (Debian) And still have the same problem as outlined below. Any thoughts? Elaine On Wed, Dec 28, 2011 at 6:10 PM, Elaine Bradtke e...@efdss.org wrote: I am trying to export a group of biblios in order to batch edit them. These are biblios without item records (they are actually components, part of a larger bound volume, not physical items by themselves). But when I go through the steps in MARC export and select item type: component, it produces an empty file. If I select all item types, it only exports biblios with item records attached. Which is precisely the opposite of what I'm trying to do. I also tried selecting 'don't export items' to see if that made a difference. It doesn't. Is there any way I can extract these MARC records, or do I have to fix them all one at a time? We're running 3.04.02.000 - have been too busy with a major move in the past six months to upgrade. If this is a problem that has been fixed in a later version that would be useful to know. -- 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) ___ 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) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can bibliographic records be deleted?
Doh! Geesh, how did I miss that. Thanks. :) __ Cecil Hillyard Washoe County Library -Tel: 775-327-8338 or 7750-327-8339 fax: 775-327-8334 -Original Message- From: Chris Cormack [mailto:chr...@catalyst.net.nz] Sent: Wednesday, January 04, 2012 12:08 PM To: Hillyard, Cecil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Can bibliographic records be deleted? * Hillyard, Cecil (chilly...@washoecounty.us) wrote: Is there a way to delete bibliographic records? I have two records. Somehow I managed to add a record twice from manage staged records. One of them needs to be deleted. Do you just merge the two together or is there an easy way to delete a bib with no holdings? Hi Cecil In the staff interface, if you do a catalogue search, and then click on the record. In the edit drop down, there is an option to delete record, it will be greyed out and unselectable if the record has items attached. Otherwise selecting that will delete the record. Hope this helps Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can bibliographic records be deleted?
* Hillyard, Cecil (chilly...@washoecounty.us) wrote: Doh! Geesh, how did I miss that. I'd blame lack of coffee, that's always my go to :-) Chris Thanks. :) __ Cecil Hillyard Washoe County Library -Tel: 775-327-8338 or 7750-327-8339 fax: 775-327-8334 -Original Message- From: Chris Cormack [mailto:chr...@catalyst.net.nz] Sent: Wednesday, January 04, 2012 12:08 PM To: Hillyard, Cecil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Can bibliographic records be deleted? * Hillyard, Cecil (chilly...@washoecounty.us) wrote: Is there a way to delete bibliographic records? I have two records. Somehow I managed to add a record twice from manage staged records. One of them needs to be deleted. Do you just merge the two together or is there an easy way to delete a bib with no holdings? Hi Cecil In the staff interface, if you do a catalogue search, and then click on the record. In the edit drop down, there is an option to delete record, it will be greyed out and unselectable if the record has items attached. Otherwise selecting that will delete the record. Hope this helps Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand signature.asc Description: Digital signature ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC Export problem
2012/1/5 Jared Camins-Esakov jcam...@cpbibliography.com: You can export records without item records, just not by specifying an item type. You have to use a different criterion, or, as I do, export all records and filter out the records I don't care about. I am sure it would be possible to add an option select only records with no items, if someone were interested in sponsoring such a development. Or even to change it, so that if you didn't have itemlevel itemtypes switched on, it filtered via the biblio level itemtype. Or do both :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Authorities lost during upgrade to 3.6.1
At 02:56 AM 1/5/2012 +1300, Mason James wrote: On 2012-01-3, at 10:09 AM, Paul wrote: Hoping someone can help, please. We recently upgraded from 3.2 to 3.6.1 and nearly everything went well during import of ~15,000 biblios, but something has happened to the authorities -- only newly catalogued (i.e. using 3.6.1) authorities appear in the staff search from http://koha-admin/cgi-bin/koha/authorities/authorities-home.pl. have you tried rebuilding the zebra 'authorities' indexes/database? koha@nelson:/usr/share/koha$ KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib ./bin/migration_tools/rebuild_zebra.pl -b -a -r 19:12:09-04/01 zebraidx(9447) [warn] MARC: Bad offsets in data. Skipping rest 19:12:09-04/01 zebraidx(9447) [warn] Record didn't contain match fields in (bib1,Local-number) So -- just the two warns. Can anyone tell me if the skipping rest refers *only* to the one record, or if it aborted the whole re-indexing? I'm guessing it aborted the process, as a quick look shows that none of the missing authorities have magically re-appeared. Also, is the zebraidx(9447) referenced to the Koha biblio # 9447 (nothing appears amiss in it) or if there is some other way of finding which record is giving it indigestion? I have no experience with zebra. Many thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Authorities lost during upgrade to 3.6.1
On 2012-01-5, at 1:56 PM, Chris Cormack wrote: On 5 January 2012 13:53, Paul pau...@aandc.org wrote: At 02:56 AM 1/5/2012 +1300, Mason James wrote: On 2012-01-3, at 10:09 AM, Paul wrote: Hoping someone can help, please. We recently upgraded from 3.2 to 3.6.1 and nearly everything went well during import of ~15,000 biblios, but something has happened to the authorities -- only newly catalogued (i.e. using 3.6.1) authorities appear in the staff search from http://koha-admin/cgi-bin/koha/authorities/authorities-home.pl. have you tried rebuilding the zebra 'authorities' indexes/database? koha@nelson:/usr/share/koha$ KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib ./bin/migration_tools/rebuild_zebra.pl -b -a -r 19:12:09-04/01 zebraidx(9447) [warn] MARC: Bad offsets in data. Skipping rest 19:12:09-04/01 zebraidx(9447) [warn] Record didn't contain match fields in (bib1,Local-number) So -- just the two warns. Can anyone tell me if the skipping rest refers *only* to the one record, or if it aborted the whole re-indexing? its skipping *all* records after. looks like you have a bad bib record I'm guessing it aborted the process, as a quick look shows that none of the missing authorities have magically re-appeared. How about trying it without the -b, just -a to reindex authorities. Id add -v for verbose too yes indeed - there was an small bug with rebuild_zebra.pl script when indexing both bibs and auth records using the xml switch (not sure if its fixed yet?) for best results, use the -x (for xml option) on authority records alone, like this... $ ./bin/migration_tools/rebuild_zebra.pl -a -r -v -x PGP.sig Description: This is a digitally signed message part ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
