- Koha-devel - lists.koha-community.org

How to resync biblioitem.marc, and (modified) biblioitem.marcxml
by pete huerter 08 Apr '11

08 Apr '11

Hi Koha-devel group, I just ran some SQL queries that changed the biblioitems.marcxml blob, but did not change the biblioitems.marc blob. What are the implications of this, and how can I fix this? It seems like I should be able to just do this to 'resync' these two fields: for each biblio, call biblio = GetBiblio call ModBiblio (biblio) Can someone please confirm? (or is there a better way to do this?) (Scroll down for more background info) Thanks, Pete. Background: During the bulk import process some of our biblios were imported with incorrect 952$8 Collection code (should be in CCODE authorised values list), and 952$c Shelving Location Code (should be in LOC authorised values list). E.g. "military o/s", should be "military o_s" which maps to "Military oversized" in the CCODE list. For this discussion let's assume that both 952$8, and 952$c need to be changed from "military o/s" to "military o_s". I thought I was being clever and used SQL directly to replace "miltary o/s" with "military o_s" in 4 places: 1. items.location 2. biblioitems.marcxml : field 952$c 3. items.ccode 4. biblioitems.marcxml : field 952$8 Sample SQL queries: # items.location UPDATE items SET items.location = REPLACE(items.location, 'o/s', 'o_s') WHERE items.location LIKE '%o/s%'; # marcxml blob 952$c UPDATE biblioitems SET marcxml = REPLACE(marcxml, 'rare/box', 'rare_box') WHERE extractvalue(biblioitems.marcxml,'//datafield[@tag="952"]/subfield[@code="c"]') = 'rare/box'; # items.ccode UPDATE items SET items.ccode = REPLACE(items.ccode, 'catalog', 'catalogue') WHERE items.ccode = 'catalog'; # marc blob: 952$8 UPDATE biblioitems SET marcxml = REPLACE(marcxml, 'catalog', 'catalogue') WHERE extractvalue(biblioitems.marcxml,'//datafield[@tag="952"]/subfield[@code="8"]') = 'catalog'; Then I realized that there is a second marc blob (biblioitems.marc) in addition to the marcxml blob (biblioitems.marcxml) - which looks like compiled marc? - that I did not change - yikes! When I look in lib/C4 it looks like GetBiblio (which calls GetBiblioMarc) uses the $marcxml to compose a Biblio $record. Biblio.pm@GetBiblioMarc: $record = eval { MARC::Record::new_from_xml( $marcxml, "utf8", C4::Context->preference('marcflavour') ) }; And it seems that ModBiblio (which calls ModBiblioMarc) compiles the $record into both formats, the marcxml blob, and the us_marc blob (compiled MARC?). Biblio.pm@ModBiblioMarc: $sth = $dbh->prepare("UPDATE biblioitems SET marc=?,marcxml=? WHERE biblionumber=?"); $sth->execute( $record->as_usmarc(), $record->as_xml_record($encoding), $biblionumber ); $sth->finish; There are also the following functions in Record.pm that look promising: Record.pm@{marc2marcxml,marcxml2marc, changeEncoding} It seems that generally biblioitems.marcxml is used more than the biblioitems.marc blob. It seems like I should be able to just, for each biblio, call GetBiblio followed by ModBiblio to 'resync' these two fields. Can someone please confirm?

1 0

(bugzilla)Does Not Apply => remember to change when updated
by Paul Poulain 08 Apr '11

08 Apr '11

Hello all, I'm reviewing all bugs with "does not apply" status. On the first 8, i've found 4 that have an updated patch, that applies. Sometimes there's a comment "pls try this" REMINDER : if you want ppl to signoff the new patch, PLEASE, set again "Please signoff". Otherwise, it will probably stay pending for some weeks, and once someone realize it can be tested again, it will probably not apply again... HTH -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Fwd: [OPEN-ILS-GENERAL] Notice of Change to License for OpenNCIP
by Galen Charlton 08 Apr '11

08 Apr '11

Hi, Please see this notice from the Georgia Public Library Service regarding relicensing OpenNCIP from the GPL v2 to the GPL v2+. As you can see, I am seeking confirmation from other copyright holders to approve the license change. As we all know, Koha currently embeds a fork of OpenNCIP. To assist with ending that situation so that Koha just uses OpenNCIP as a normal Perl dependency, I also call on any individuals and companies who have contributed patches to Koha's fork to express their willingness to have their code incorporated in a GPL2+ OpenNCIP. Regards, Galen ---------- Forwarded message ---------- From: Galen Charlton <gmc(a)esilibrary.com> Date: Tue, Apr 5, 2011 at 4:04 PM Subject: Re: [OPEN-ILS-GENERAL] Notice of Change to License for OpenNCIP To: Evergreen Discussion Group <open-ils-general(a)list.georgialibraries.org> Cc: Dan Scott <dan(a)coffeecode.net> Hi Elizabeth, On Apr 5, 2011, at 3:57 PM, McKinney, Elizabeth wrote: > Evergreen and other Open Source Community Members, > > The Georgia Public Library Service (GPLS) is the primary copyright holder on OpenNCIP. The source code can be found at the following sites: > > http://sourceforge.net/projects/openncip/ > https://github.com/atz/SIPServer > > As the director of the PINES program, I want to notify you that GPLS is permitting the change of the license of OpenNCIP from the GNU Public License version 2 to the GNU Public License version 2 or later in order to give it the same license that Evergreen uses. This will facilitate easier code sharing between OpenNCIP and Evergreen and thus benefit the Evergreen community. > > Feel free to distribute this notice as needed. Thank you for this. I confirm on behalf of Equinox that we are also willing to relicense any OpenNCIP code that we hold copyright on to the GPL version 2 or later. Based on the change logs, the following individuals may have individual copyright on portions of OpenNCIP. I now call on each of them to either approve the license change, object, or disclaim copyright interest. Joe Atzberger David Fiander Dan Scott If anybody is aware of other individuals with a copyright interest in the OpenNCIP code, please pass this request on to them. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc(a)esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/ -- Galen Charlton gmcharlt(a)gmail.com

2 1

Koha - Bug 6113 enhancement to keep previous ids in bulkmarcimport.pl
by Linda Culberson 08 Apr '11

08 Apr '11

All, I have submitted Bug 6113 to bugzilla for a sponsored enhancement. In communicating with other Koha users, we feel that it would be highly beneficial Koha was enhanced to allow the library to keep its current ids when loading both bibliographic and authority records. Some of us have used our current control numbers in the 76X-78X fields to link records. In our institution, we have also used that number in external databases and on other websites to link additional information back to the related catalog record. The documentation within bulkmarcimport.pl also needs to be amended to better explain the use of the various options (for example: x, y, k, idmap and keepid) since some of us tried to use those to keep our ids without success. Thank you. -- Linda Culberson lculber(a)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 Facsimile: 601/576-6824

1 1

Technical question
by Charl 07 Apr '11

07 Apr '11

?Good day I need advice please. I have converted a Koha installation from 2 to Koha 3. Now there is a "syncronization" problem between the items table and the marc record in bibioitems. To make a long story short, the itemtype appears in the marc record, but not in the items table. Is there a procedure how to syncronize those 2 "fields"? Thanks for any advice!

3 5

Re: [Koha-devel] Technical question
by Mike Hafen 07 Apr '11

07 Apr '11

This is why I suggested modifying the touch_all_items script. It uses the C4::Items::ModItem subroutine which changes the database and the marc records stored in the biblioitems table. Editing these directly is difficult at best, and nearly impossible in my opinion. Along with modifying a copy of touch_all_items for your item type conversion, you could also add code to strip the alpha characters from the end of the barcode. Do all the work in one go. You'll have to change the SQL in that script, but you will have to do that anyway to update the item type. On Thu, Apr 7, 2011 at 10:09 AM, Charl <charl(a)prograbiz.com> wrote: > Thank you Mike > > This should help me sort out this issue. > > Another issue that I am trying to sort out: > Alpha characters appear after the barcode in both the marc and item record. > > How should I go about removing those alpha characters as a batch procedure? > The item record is not a problem, but I am not sure how to edit the barcode > in the marc record (biblioitems). > > Thanks again for your help. > > ----- Original Message ----- > > *From:* Mike Hafen <mdhafen(a)tech.washk12.org> > *To:* Charl <charl(a)prograbiz.com> > *Cc:* koha-devel(a)lists.koha-community.org > *Sent:* Thursday, April 07, 2011 5:50 PM > *Subject:* Re: [Koha-devel] Technical question > > The Item Type in Koha 3 has been moved to the items table, with the Item > Type in the biblioitems table being a default for new items. > > It wouldn't be difficult to make a command line script to copy the Item > Type from the biblioitems table to the items table, that may be the best way > to go in this case. It looks like maintenance/touch_all_items.pl would be > a good place to start on such a script. > > 2011/4/6 Charl <charl(a)prograbiz.com> > >> Good day >> >> I need advice please. I have converted a Koha installation from 2 to Koha >> 3. >> Now there is a "syncronization" problem between the items table and the >> marc record in bibioitems. >> >> To make a long story short, the itemtype appears in the marc record, but >> not in the items table. >> Is there a procedure how to syncronize those 2 "fields"? >> >> Thanks for any advice! >> >> >> >> _______________________________________________ >> Koha-devel mailing list >> Koha-devel(a)lists.koha-community.org >> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >> website : http://www.koha-community.org/ >> git : http://git.koha-community.org/ >> bugs : http://bugs.koha-community.org/ >> > > ------------------------------ > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.449 / Virus Database: 271.1.1/3557 - Release Date: 04/07/11 > 10:01:00 > >

1 0

problem with the main template in tools page
by Adnier Rosello Carrazana 07 Apr '11

07 Apr '11

I have this problem in the template "tools-home.tmpl": the content of this template is inside of labels , for example:  <dt><a href="/cgi-bin/koha/tools/koha-news.pl">Noticias</a></dt> <dd>Escriba novedades para el OPAC y la interfaz administrativa</dd>  but this content doesn't show, i don't find where the variables are declared (in this case "CAN_user_tools_edit_news"), if anyone can help me I'll be grateful

3 2

Hackfest - 5579 remove items from marcxml
by Claire Hernandez 07 Apr '11

07 Apr '11

Hi, As I said, I setup an unimarc install here: http://koha.qa.testing.biblibre.com <http://koha.qa.testing.biblibre.com/> http://qa.testing.biblibre.com <http://koha.qa.testing.biblibre.com/> with patches related to 5579 ticket. - The database is the same as http://koha.master.testing.biblibre.com <http://koha.qa.testing.biblibre.com/> - I played the migration script on qa setup (misc/maintenance/remove_items_from_biblioitems.pl) - Rebuild zebra and launch zebra Please, have a look. We found only one bug in "marcxml export" where we would like to see items in export. Matts tries to paitch it this morning. We had a look on - items crud operations - indexing, searching - circulation basis - batch modification - migration scripts without founding mistakes but it can be not exhaustive. These modifications needs to be tested with Marc21 too. Thanks, Claire.

3 4

Sharing bugzilla queries
by Paul Poulain 07 Apr '11

07 Apr '11

Hello world, if you login on bugzilla, then Click on Preferences, then Saved searches, you'll find the queries you've saved, but also some usefull shared queries : Needs signoff, Patch pushed, signed off, Does not apply, Failed QA Just check the checkbox and you'll get a link to this query on the footer of your bugzilla entry. Another hint: if you don't like bugzilla going to your next bug everytime you validate a form, choose what you want on Bugzilla > Preferences > After changing a bug -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

2 1

Warnings about Koha to MARC links
by Owen Leonard 07 Apr '11

07 Apr '11

I have a question about Koha/MARC links On marctagstructure.pl it says "If you change the link between a MARC subfield and a non-MARC field, ask your administrator to run misc/batchRebuildBiblioTables.pl script." On marc_subfields_structure.pl, next to the "link" field, it says "Warning: This value should not change after data has been added to your catalog." Are these not talking about the same thing? Which is correct? I would like to remove the warning from marctagstructure.pl since it pertains directly to subfield editing, but I want to make sure the note on marc_subfields_structure.pl is accurate. Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 1