[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/misc missing090field.pl [rel_2_2]
From: |
Pierrick LE GALL |
Subject: |
[Koha-cvs] koha/misc missing090field.pl [rel_2_2] |
Date: |
Fri, 14 Apr 2006 13:18:25 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: rel_2_2
Changes by: Pierrick LE GALL <address@hidden> 06/04/14 13:18:25
Added files:
misc : missing090field.pl
Log message:
bug fixed: missing090field.pl is a rel_2_2 script, ie using rel_2_2
modules
functions, not a HEAD script. It doesn't work in HEAD.
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/misc/missing090field.pl?only_with_tag=rel_2_2&rev=1.1.2.1
Patches:
Index: koha/misc/missing090field.pl
diff -u /dev/null koha/misc/missing090field.pl:1.1.2.1
--- /dev/null Fri Apr 14 13:18:25 2006
+++ koha/misc/missing090field.pl Fri Apr 14 13:18:25 2006
@@ -0,0 +1,50 @@
+#!/usr/bin/perl
+# This script finds and fixes missing 090 fields in Koha for MARC21
+# Written by TG on 01/10/2005
+# Revised by Joshua Ferraro on 03/31/2006
+use strict;
+
+# Koha modules used
+
+use C4::Context;
+use C4::Biblio;
+use MARC::Record;
+use MARC::File::USMARC;
+
+
+my $dbh = C4::Context->dbh;
+
+my $sth=$dbh->prepare("select m.biblionumber,b.biblioitemnumber from
marc_biblio m left join biblioitems b on b.biblionumber=m.biblionumber ");
+ $sth->execute();
+
+while (my ($biblionumber,$biblioitemnumber)=$sth->fetchrow ){
+ my $record = MARCgetbiblio($dbh,$biblionumber);
+
+ MARCmodbiblionumber($biblionumber,$biblioitemnumber,$record);
+
+}
+
+sub MARCmodbiblionumber{
+my ($biblionumber,$biblioitemnumber,$record)address@hidden;
+
+my ($tagfield,$biblionumtagsubfield) =
&MARCfind_marc_from_kohafield($dbh,"biblio.biblionumber","");
+my ($tagfield2,$biblioitemtagsubfield) =
&MARCfind_marc_from_kohafield($dbh,"biblio.biblioitemnumber","");
+
+my $update=0;
+ my @tags = $record->field($tagfield);
+
+if (address@hidden){
+
+my $newrec = MARC::Field->new( $tagfield,'','', $biblionumtagsubfield =>
$biblionumber,$biblioitemtagsubfield=>$biblioitemnumber);
+ $record->append_fields($newrec);
+ $update=1;
+ }
+
+
+if ($update){
+&MARCmodbiblio($dbh,$biblionumber,$record,'',0);
+ print "$biblionumber \n";
+ }
+
+}
+END;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] koha/misc missing090field.pl [rel_2_2],
Pierrick LE GALL <=