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 $|=1; # flushes output
21 print "Creating/updating field 100 if needed\n";
22 while (my ($biblionumber,$time)=$sth->fetchrow ){
24 print "record : $biblionumber \n";
25 my $record = GetMarcBiblio($biblionumber);
26 print "=> ".$record->as_formatted;
27 MARCmodrecord($biblionumber,$record,$time);
32 my ($biblionumber,$record,$time)=@_;
33 # warn "AVANT : ".$record->as_formatted;
35 $record->leader(' nac 22 1u 4500');
38 if ($record->subfield(100,"a")) {
39 $string = substr($record->subfield(100,"a")." ",0,35);
40 my $f100 = $record->field(100);
41 $record->delete_field($f100);
43 $string = POSIX::strftime("%Y%m%d", localtime);
45 $string = sprintf("%-*s",35, $string);
47 substr($string,22,6,"frey50");
48 unless ($record->subfield(100,"a")){
49 $record->insert_fields_ordered(MARC::Field->new(100,"","","a"=>"$string"));
52 &ModBiblioMarc($record,$biblionumber,'');
53 print "\r$biblionumber" unless ( $biblionumber % 100 );