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 biblionumber,timestamp from biblioitems");
20 while (my ($biblionumber,$time)=$sth->fetchrow ){
22 my $record = GetMarcBiblio($biblionumber);
23 #print $record->as_marc;
24 MARCmodrecord($biblionumber,$record,$time);
29 my ($biblionumber,$record,$time)=@_;
30 # warn "AVANT : ".$record->as_formatted;
32 $record->leader(' nac 22 1u 4500');
35 if ($record->subfield(100,"a")) {
36 $string = $record->subfield(100,"a");
37 my $f100 = $record->field(100);
38 $record->delete_field($f100);
40 $string = POSIX::strftime("%Y%m%d", localtime);
42 $string = sprintf("%-*s",35, $string);
44 substr($string,22,6,"frey50");
45 unless ($record->subfield(100,"a")){
46 $record->insert_fields_ordered(MARC::Field->new(100,"","","a"=>"$string"));
48 # warn "APRES : ".$record->as_formatted;
49 # delete all items related fields
50 foreach ($record->field('995')) {
51 $record->delete_field($_);
54 &ModBiblioMarc($record,$biblionumber,'');
55 print "$biblionumber \n";