2 # This script finds and fixes missing 090 fields in Koha for MARC21
3 # Written by TG on 01/10/2005
4 # Revised by Joshua Ferraro on 03/31/2006
6 #use warnings; FIXME - Bug 2505
8 # find Koha's Perl modules
9 # test carefully before changing this
11 eval { require "$FindBin::Bin/../../kohalib.pl" };
17 use C4::Biblio qw( GetMarcBiblio GetMarcFromKohaField ModBiblioMarc );
18 use MARC::File::USMARC;
21 my $dbh = C4::Context->dbh;
23 my $sth=$dbh->prepare("SELECT biblionumber, biblioitemnumber FROM biblioitems");
27 while (my ($biblionumber,$biblioitemnumber)=$sth->fetchrow ){
28 my $record = GetMarcBiblio({ biblionumber => $biblionumber });
30 print "\r$i" unless $i %100;
31 MARCmodbiblionumber($biblionumber,$biblioitemnumber,$record);
34 sub MARCmodbiblionumber{
35 my ($biblionumber,$biblioitemnumber,$record)=@_;
37 return unless $record;
39 my ($tagfield,$biblionumtagsubfield) = &GetMarcFromKohaField( "biblio.biblionumber" );
40 my ($tagfield2,$biblioitemtagsubfield) = &GetMarcFromKohaField( "biblio.biblioitemnumber" );
43 if (defined $record) {
44 my $tag = $record->field($tagfield);
45 #warn "ICI : ".$record->as_formatted if $record->subfield('090','a') eq '11546';
47 # check that we have biblionumber at the right place, otherwise, update or create the field.
49 unless ($tag && $tag->data() == $biblionumber) {
51 $tag->update($biblionumber);
53 my $newrec = MARC::Field->new( $tagfield, $biblionumber);
54 $record->insert_fields_ordered($newrec);
59 unless ($tag && $tag->subfield($biblionumtagsubfield) == $biblionumber) {
61 $tag->update($tagfield => $biblionumber);
63 my $newrec = MARC::Field->new( $tagfield,'','', $biblionumtagsubfield => $biblionumber,$biblioitemtagsubfield=>$biblioitemnumber);
64 $record->insert_fields_ordered($newrec);
70 warn "problem with :".$biblionumber." , record undefined";
75 &ModBiblioMarc($record,$biblionumber);
76 print "\n modified : $biblionumber \n";