Editing a biblio record
We are "experimenting" in preparation for importing some 16,000 *book* entries from Excel spreadsheets into Koha (Koha 3.00.06 on Ubuntu Server 10.10) using MarcEdit. I have run into a snag editing a MARC biblio record using <http://koha-admin/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=xxx>. We unfortunately got the "Title" of the Author (Sir Max Aitken) (100$c) into 700$a as a co-author. I can add|correct 100$c without difficulty, but cannot in any way delete or modify 700$a - I can highlight it with the mouse, but the keyboard is totally unresponsive. Any suggestions warmly welcomed - thanks. Paul
I suspect authority issues, (is the field grayed out?) You can edit all of your frameworks to "unlink" MARC fields to authority types, or if have acces to the database, you could execute: UPDATE marc_subfield_structure SET authtypecode = NULL WHERE authtype IS NOT NULL; A bit drastic but it will get rid of all links to authorities in the frameworks. (With thanks to Bernardo Gonzalez Kriegel) --- On Fri, 11/26/10, Paul <paul.a@aandc.org> wrote: From: Paul <paul.a@aandc.org> Subject: [Koha] Editing a biblio record To: "koha" <koha@lists.katipo.co.nz> Received: Friday, November 26, 2010, 5:40 PM We are "experimenting" in preparation for importing some 16,000 *book* entries from Excel spreadsheets into Koha (Koha 3.00.06 on Ubuntu Server 10.10) using MarcEdit. I have run into a snag editing a MARC biblio record using <http://koha-admin/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=xxx>. We unfortunately got the "Title" of the Author (Sir Max Aitken) (100$c) into 700$a as a co-author. I can add|correct 100$c without difficulty, but cannot in any way delete or modify 700$a - I can highlight it with the mouse, but the keyboard is totally unresponsive. Any suggestions warmly welcomed - thanks. Paul _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Marty and Paul, That seems a bit extreme. Very, even. I would suggest a better option would be to click the three dots next to your erroneous 700s, search for an authority (any authority... unfortunately you have to do a search before you can clear a link) and then click the "clear" hyperlink to remove the authority link. This will allow you to continue using authorities and remove the unwanted 700 fields. The reason you're unable to edit the 700$a is that you have BiblioAddsAuthorities set to "don't allow," but even if you set it to "allow," you'll still be unable to remove the data from subfield 700$9. See the manual for a little more information about this system preference: http://koha-community.org/documentation/3-2-manual/?ch=c19#AEN207 Regards, Jared 2010/11/26 Marty <ontariowolf64@yahoo.com>
I suspect authority issues, (is the field grayed out?) You can edit all of your frameworks to "unlink" MARC fields to authority types, or if have acces to the database, you could execute:
UPDATE marc_subfield_structure SET authtypecode = NULL WHERE authtype IS NOT NULL;
A bit drastic but it will get rid of all links to authorities in the frameworks.
(With thanks to Bernardo Gonzalez Kriegel)
--- On *Fri, 11/26/10, Paul <paul.a@aandc.org>* wrote:
From: Paul <paul.a@aandc.org> Subject: [Koha] Editing a biblio record To: "koha" <koha@lists.katipo.co.nz> Received: Friday, November 26, 2010, 5:40 PM
We are "experimenting" in preparation for importing some 16,000 *book* entries from Excel spreadsheets into Koha (Koha 3.00.06 on Ubuntu Server 10.10) using MarcEdit.
I have run into a snag editing a MARC biblio record using <http://koha-admin/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=xxx>.
We unfortunately got the "Title" of the Author (Sir Max Aitken) (100$c) into 700$a as a co-author.
I can add|correct 100$c without difficulty, but cannot in any way delete or
modify 700$a - I can highlight it with the mouse, but the keyboard is totally unresponsive.
Any suggestions warmly welcomed - thanks. Paul
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <http://mc/compose?to=Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jared Camins-Esakov Freelance bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
At 03:59 PM 11/26/2010 -0800, Marty wrote:
I suspect authority issues, (is the field grayed out?)
No - not at all, as I said below, I can highlight it - just not do anything with it. 700$a looks exactly like 100$a which I can edit, delete, etc at will - and you'd think that the authority would treat them the same, or maybe even give higher priority to the "primary" author. For the record, all other 700 fields are fully editable. I'll fiddle with your suggestion tomorrow - but as you say, it is a bit drastic and SQL can be a tad touchy. Thanks - Paul
You can edit all of your frameworks to "unlink" MARC fields to authority types, or if have acces to the database, you could execute:
UPDATE marc_subfield_structure SET authtypecode = NULL WHERE authtype IS NOT NULL;
A bit drastic but it will get rid of all links to authorities in the frameworks.
(With thanks to Bernardo Gonzalez Kriegel)
--- On Fri, 11/26/10, Paul <paul.a@aandc.org> wrote:
From: Paul <paul.a@aandc.org> Subject: [Koha] Editing a biblio record To: "koha" <koha@lists.katipo.co.nz> Received: Friday, November 26, 2010, 5:40 PM
We are "experimenting" in preparation for importing some 16,000 *book* entries from Excel spreadsheets into Koha (Koha 3.00.06 on Ubuntu Server 10.10) using MarcEdit.
I have run into a snag editing a MARC biblio record using <<http://koha-admin/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=xxx>http://koha-admin/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=xxx>.
We unfortunately got the "Title" of the Author (Sir Max Aitken) (100$c) into 700$a as a co-author.
I can add|correct 100$c without difficulty, but cannot in any way delete or modify 700$a - I can highlight it with the mouse, but the keyboard is totally unresponsive.
Any suggestions warmly welcomed - thanks. Paul
_______________________________________________ Koha mailing list <http://koha-community.org>http://koha-community.org Koha@lists.katipo.co.nz <http://lists.katipo.co.nz/mailman/listinfo/koha>http://lists.katipo.co.nz/mailman/listinfo/koha
--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>
participants (3)
-
Jared Camins-Esakov -
Marty -
Paul