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
11 use C4::Biblio qw( ModBiblioMarc );
13 use MARC::File::USMARC;
16 my $dbh = C4::Context->dbh;
18 my $sth=$dbh->prepare("select biblionumber,timestamp from biblioitems");
21 $|=1; # flushes output
22 print "Creating/updating field 100 if needed\n";
23 while (my ($biblionumber,$time)=$sth->fetchrow ){
25 # print "record : $biblionumber \n";
26 my $biblio = Koha::Biblios->find($biblionumber);
27 my $record = $biblio ? $biblio->metadata->record : undef;
28 # print "=> ".$record->as_formatted;
29 MARCmodrecord($biblionumber,$record,$time) if ($record);
34 my ($biblionumber,$record,$time)=@_;
35 # warn "AVANT : ".$record->as_formatted;
37 $record->leader(' nac 22 1u 4500');
40 if ($record->field(100)) {
41 $string = substr($record->subfield(100,"a")." ",0,35);
42 my $f100 = $record->field(100);
43 $record->delete_field($f100);
45 $string = POSIX::strftime("%Y%m%d", localtime);
47 $string = sprintf("%-*s",35, $string);
49 substr($string,22,6,"frey50");
50 unless ($record->subfield(100,"a")){
51 $record->insert_fields_ordered(MARC::Field->new(100,"","","a"=>"$string"));
54 &ModBiblioMarc($record,$biblionumber);
55 print "\r$biblionumber" unless ( $biblionumber % 100 );