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
7 # find Koha's Perl modules
8 # test carefully before changing this
10 eval { require "$FindBin::Bin/../../kohalib.pl" };
18 use MARC::File::USMARC;
21 my $dbh = C4::Context->dbh;
23 my $sth=$dbh->prepare("select biblionumber,timestamp from biblioitems");
26 $|=1; # flushes output
27 print "Creating/updating field 100 if needed\n";
28 while (my ($biblionumber,$time)=$sth->fetchrow ){
30 # print "record : $biblionumber \n";
31 my $record = GetMarcBiblio($biblionumber);
32 # print "=> ".$record->as_formatted;
33 MARCmodrecord($biblionumber,$record,$time);
38 my ($biblionumber,$record,$time)=@_;
39 # warn "AVANT : ".$record->as_formatted;
41 $record->leader(' nac 22 1u 4500');
44 if ($record->field(100)) {
45 $string = substr($record->subfield(100,"a")." ",0,35);
46 my $f100 = $record->field(100);
47 $record->delete_field($f100);
49 $string = POSIX::strftime("%Y%m%d", localtime);
51 $string = sprintf("%-*s",35, $string);
53 substr($string,22,6,"frey50");
54 unless ($record->subfield(100,"a")){
55 $record->insert_fields_ordered(MARC::Field->new(100,"","","a"=>"$string"));
58 &ModBiblioMarc($record,$biblionumber,'');
59 print "\r$biblionumber" unless ( $biblionumber % 100 );