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
12 use MARC::File::USMARC;
15 my $dbh = C4::Context->dbh;
17 my $sth=$dbh->prepare("select m.biblionumber,b.biblioitemnumber from marc_biblio m left join biblioitems b on b.biblionumber=m.biblionumber ");
20 while (my ($biblionumber,$biblioitemnumber)=$sth->fetchrow ){
21 my $record = GetMarcBiblio($biblionumber);
23 MARCmodbiblionumber($biblionumber,$biblioitemnumber,$record);
27 sub MARCmodbiblionumber{
28 my ($biblionumber,$biblioitemnumber,$record)=@_;
30 my ($tagfield,$biblionumtagsubfield) = &GetMarcFromKohaField("biblio.biblionumber","");
31 my ($tagfield2,$biblioitemtagsubfield) = &GetMarcFromKohaField("biblio.biblioitemnumber","");
34 my @tags = $record->field($tagfield);
38 my $newrec = MARC::Field->new( $tagfield,'','', $biblionumtagsubfield => $biblionumber,$biblioitemtagsubfield=>$biblioitemnumber);
39 $record->append_fields($newrec);
45 &ModBiblioMarc($record,'',$biblionumber);
46 print "$biblionumber \n";