Lines 23-28
use C4::Biblio qw(
Link Here
|
23 |
GetMarcFromKohaField |
23 |
GetMarcFromKohaField |
24 |
ModBiblio |
24 |
ModBiblio |
25 |
ModBiblioMarc |
25 |
ModBiblioMarc |
|
|
26 |
GetFrameworkCode |
27 |
GetMarcBiblio |
26 |
); |
28 |
); |
27 |
use C4::Koha; |
29 |
use C4::Koha; |
28 |
use C4::Charset qw( MarcToUTF8Record SetUTF8Flag ); |
30 |
use C4::Charset qw( MarcToUTF8Record SetUTF8Flag ); |
Lines 38-66
use Time::HiRes qw( gettimeofday );
Link Here
|
38 |
use Getopt::Long qw( GetOptions ); |
40 |
use Getopt::Long qw( GetOptions ); |
39 |
use IO::File; |
41 |
use IO::File; |
40 |
use Pod::Usage qw( pod2usage ); |
42 |
use Pod::Usage qw( pod2usage ); |
|
|
43 |
use List::MoreUtils qw(any); |
41 |
|
44 |
|
42 |
use Koha::Logger; |
45 |
use Koha::Logger; |
43 |
use Koha::Biblios; |
46 |
use Koha::Biblios; |
44 |
use Koha::SearchEngine; |
47 |
use Koha::SearchEngine; |
45 |
use Koha::SearchEngine::Search; |
48 |
use Koha::SearchEngine::Search; |
|
|
49 |
use Koha::Plugins::Handler; |
46 |
|
50 |
|
47 |
use open qw( :std :encoding(UTF-8) ); |
51 |
use open qw( :std :encoding(UTF-8) ); |
48 |
binmode( STDOUT, ":encoding(UTF-8)" ); |
52 |
binmode(STDOUT, ":encoding(UTF-8)"); |
49 |
my ( $input_marc_file, $number, $offset) = ('',0,0); |
53 |
my ($input_marc_file, $number, $offset, $cleanisbn) = ('', 0, 0, 1); |
50 |
my ($version, $delete, $test_parameter, $skip_marc8_conversion, $char_encoding, $verbose, $commit, $fk_off,$format,$biblios,$authorities,$keepids,$match, $isbn_check, $logfile); |
54 |
my $version; |
51 |
my ( $insert, $filters, $update, $all, $yamlfile, $authtypes, $append ); |
55 |
my $delete; |
52 |
my $cleanisbn = 1; |
56 |
my $test_parameter; |
53 |
my ($sourcetag,$sourcesubfield,$idmapfl, $dedup_barcode); |
57 |
my $skip_marc8_conversion; |
|
|
58 |
my $char_encoding; |
59 |
my $verbose; |
60 |
my $commit; |
61 |
my $fk_off; |
62 |
my $format; |
63 |
my $biblios; |
64 |
my $authorities; |
65 |
my $keepids; |
66 |
my $match; |
67 |
my $isbn_check; |
68 |
my $logfile; |
69 |
my $insert; |
70 |
my $filters; |
71 |
my $update; |
72 |
my $all; |
73 |
my $yamlfile; |
74 |
my $authtypes; |
75 |
my $append; |
76 |
my $sourcetag; |
77 |
my $sourcesubfield; |
78 |
my $idmapfl; |
79 |
my $dedup_barcode; |
54 |
my $framework = ''; |
80 |
my $framework = ''; |
55 |
my $localcust; |
81 |
my $localcust; |
56 |
my $marc_mod_template = ''; |
82 |
my $marc_mod_template = ''; |
57 |
my $marc_mod_template_id = -1; |
83 |
my $marc_mod_template_id = -1; |
58 |
|
84 |
$| = 1; |
59 |
$|=1; |
|
|
60 |
|
85 |
|
61 |
GetOptions( |
86 |
GetOptions( |
62 |
'commit:f' => \$commit, |
87 |
'commit:f' => \$commit, |
63 |
'file:s' => \$input_marc_file, |
88 |
'file:s' => \$input_marc_file, |
64 |
'n:f' => \$number, |
89 |
'n:f' => \$number, |
65 |
'o|offset:f' => \$offset, |
90 |
'o|offset:f' => \$offset, |
66 |
'h' => \$version, |
91 |
'h' => \$version, |
Lines 77-98
GetOptions(
Link Here
|
77 |
'b|biblios' => \$biblios, |
102 |
'b|biblios' => \$biblios, |
78 |
'a|authorities' => \$authorities, |
103 |
'a|authorities' => \$authorities, |
79 |
'authtypes:s' => \$authtypes, |
104 |
'authtypes:s' => \$authtypes, |
80 |
'filter=s@' => \$filters, |
105 |
'filter=s@' => \$filters, |
81 |
'insert' => \$insert, |
106 |
'insert' => \$insert, |
82 |
'update' => \$update, |
107 |
'update' => \$update, |
83 |
'all' => \$all, |
108 |
'all' => \$all, |
84 |
'match=s@' => \$match, |
109 |
'match=s@' => \$match, |
85 |
'i|isbn' => \$isbn_check, |
110 |
'i|isbn' => \$isbn_check, |
86 |
'x:s' => \$sourcetag, |
111 |
'x:s' => \$sourcetag, |
87 |
'y:s' => \$sourcesubfield, |
112 |
'y:s' => \$sourcesubfield, |
88 |
'idmap:s' => \$idmapfl, |
113 |
'idmap:s' => \$idmapfl, |
89 |
'cleanisbn!' => \$cleanisbn, |
114 |
'cleanisbn!' => \$cleanisbn, |
90 |
'yaml:s' => \$yamlfile, |
115 |
'yaml:s' => \$yamlfile, |
91 |
'dedupbarcode' => \$dedup_barcode, |
116 |
'dedupbarcode' => \$dedup_barcode, |
92 |
'framework=s' => \$framework, |
117 |
'framework=s' => \$framework, |
93 |
'custom:s' => \$localcust, |
118 |
'custom:s' => \$localcust, |
94 |
'marcmodtemplate:s' => \$marc_mod_template, |
119 |
'marcmodtemplate:s' => \$marc_mod_template, |
95 |
); |
120 |
); |
|
|
121 |
|
96 |
$biblios ||= !$authorities; |
122 |
$biblios ||= !$authorities; |
97 |
$insert ||= !$update; |
123 |
$insert ||= !$update; |
98 |
my $writemode = ($append) ? "a" : "w"; |
124 |
my $writemode = ($append) ? "a" : "w"; |
Lines 104-109
if ($all) {
Link Here
|
104 |
$update = 1; |
130 |
$update = 1; |
105 |
} |
131 |
} |
106 |
|
132 |
|
|
|
133 |
my $using_elastic_search = (C4::Context->preference('SearchEngine') eq 'Elasticsearch'); |
134 |
my $modify_biblio_marc_options = { |
135 |
defer_search_engine_indexing => $using_elastic_search, |
136 |
overlay_context => { source => 'bulkmarcimport' } |
137 |
}; |
138 |
|
139 |
my @search_engine_record_ids; |
140 |
my @search_engine_records; |
141 |
my $indexer; |
142 |
if ($using_elastic_search) { |
143 |
use Koha::SearchEngine::Elasticsearch::Indexer; |
144 |
$indexer = Koha::SearchEngine::Elasticsearch::Indexer->new( |
145 |
{ index => $authorities ? |
146 |
$Koha::SearchEngine::Elasticsearch::AUTHORITIES_INDEX : |
147 |
$Koha::SearchEngine::Elasticsearch::BIBLIOS_INDEX |
148 |
} |
149 |
); |
150 |
} |
151 |
|
107 |
if ($version || ($input_marc_file eq '')) { |
152 |
if ($version || ($input_marc_file eq '')) { |
108 |
pod2usage( -verbose => 2 ); |
153 |
pod2usage( -verbose => 2 ); |
109 |
exit; |
154 |
exit; |
Lines 112-124
if( $update && !( $match || $isbn_check ) ) {
Link Here
|
112 |
warn "Using -update without -match or -isbn seems to be useless.\n"; |
157 |
warn "Using -update without -match or -isbn seems to be useless.\n"; |
113 |
} |
158 |
} |
114 |
|
159 |
|
115 |
if(defined $localcust) { #local customize module |
160 |
if (defined $localcust) { #local customize module |
116 |
if(!-e $localcust) { |
161 |
if (!-e $localcust) { |
117 |
$localcust= $localcust||'LocalChanges'; #default name |
162 |
$localcust = $localcust || 'LocalChanges'; #default name |
118 |
$localcust=~ s/^.*\/([^\/]+)$/$1/; #extract file name only |
163 |
$localcust =~ s/^.*\/([^\/]+)$/$1/; #extract file name only |
119 |
$localcust=~ s/\.pm$//; #remove extension |
164 |
$localcust =~ s/\.pm$//; #remove extension |
120 |
my $fqcust= $FindBin::Bin."/$localcust.pm"; #try migration_tools dir |
165 |
my $fqcust = $FindBin::Bin . "/$localcust.pm"; #try migration_tools dir |
121 |
if(-e $fqcust) { |
166 |
if (-e $fqcust) { |
122 |
$localcust= $fqcust; |
167 |
$localcust= $fqcust; |
123 |
} |
168 |
} |
124 |
else { |
169 |
else { |
Lines 127-133
if(defined $localcust) { #local customize module
Link Here
|
127 |
} |
172 |
} |
128 |
} |
173 |
} |
129 |
require $localcust if $localcust; |
174 |
require $localcust if $localcust; |
130 |
$localcust=\&customize if $localcust; |
175 |
$localcust = \&customize if $localcust; |
131 |
} |
176 |
} |
132 |
|
177 |
|
133 |
if($marc_mod_template ne '') { |
178 |
if($marc_mod_template ne '') { |
Lines 152-219
if($marc_mod_template ne '') {
Link Here
|
152 |
} |
197 |
} |
153 |
|
198 |
|
154 |
my $dbh = C4::Context->dbh; |
199 |
my $dbh = C4::Context->dbh; |
155 |
my $heading_fields=get_heading_fields(); |
200 |
my $heading_fields = get_heading_fields(); |
156 |
|
|
|
157 |
my $idmapfh; |
201 |
my $idmapfh; |
|
|
202 |
|
158 |
if (defined $idmapfl) { |
203 |
if (defined $idmapfl) { |
159 |
open($idmapfh, '>', $idmapfl) or die "cannot open $idmapfl \n"; |
204 |
open($idmapfh, '>', $idmapfl) or die "cannot open $idmapfl \n"; |
160 |
} |
205 |
} |
161 |
|
206 |
|
162 |
if ((not defined $sourcesubfield) && (not defined $sourcetag)){ |
207 |
if ((not defined $sourcesubfield) && (not defined $sourcetag)) { |
163 |
$sourcetag="910"; |
208 |
$sourcetag = "910"; |
164 |
$sourcesubfield="a"; |
209 |
$sourcesubfield = "a"; |
165 |
} |
210 |
} |
166 |
|
211 |
|
167 |
|
|
|
168 |
# Disable logging for the biblios and authorities import operation. It would unnecessarily |
212 |
# Disable logging for the biblios and authorities import operation. It would unnecessarily |
169 |
# slow the import |
213 |
# slow the import |
170 |
$ENV{OVERRIDE_SYSPREF_CataloguingLog} = 0; |
214 |
$ENV{OVERRIDE_SYSPREF_CataloguingLog} = 0; |
171 |
$ENV{OVERRIDE_SYSPREF_AuthoritiesLog} = 0; |
215 |
$ENV{OVERRIDE_SYSPREF_AuthoritiesLog} = 0; |
172 |
|
216 |
|
173 |
if ($fk_off) { |
217 |
if ($fk_off) { |
174 |
$dbh->do("SET FOREIGN_KEY_CHECKS = 0"); |
218 |
$dbh->do("SET FOREIGN_KEY_CHECKS = 0"); |
175 |
} |
219 |
} |
176 |
|
220 |
|
177 |
|
|
|
178 |
if ($delete) { |
221 |
if ($delete) { |
179 |
if ($biblios){ |
222 |
if ($biblios) { |
180 |
print "deleting biblios\n"; |
223 |
print "Deleting biblios\n"; |
181 |
$dbh->do("DELETE FROM biblio"); |
224 |
$dbh->do("DELETE FROM biblio"); |
182 |
$dbh->do("ALTER TABLE biblio AUTO_INCREMENT = 1"); |
225 |
$dbh->do("ALTER TABLE biblio AUTO_INCREMENT = 1"); |
183 |
$dbh->do("DELETE FROM biblioitems"); |
226 |
$dbh->do("DELETE FROM biblioitems"); |
184 |
$dbh->do("ALTER TABLE biblioitems AUTO_INCREMENT = 1"); |
227 |
$dbh->do("ALTER TABLE biblioitems AUTO_INCREMENT = 1"); |
185 |
$dbh->do("DELETE FROM items"); |
228 |
$dbh->do("DELETE FROM items"); |
186 |
$dbh->do("ALTER TABLE items AUTO_INCREMENT = 1"); |
229 |
$dbh->do("ALTER TABLE items AUTO_INCREMENT = 1"); |
187 |
} |
230 |
} |
188 |
else { |
231 |
else { |
189 |
print "deleting authorities\n"; |
232 |
print "Deleting authorities\n"; |
190 |
$dbh->do("truncate auth_header"); |
233 |
$dbh->do("truncate auth_header"); |
191 |
} |
234 |
} |
192 |
$dbh->do("truncate zebraqueue"); |
235 |
$dbh->do("truncate zebraqueue"); |
193 |
} |
236 |
} |
194 |
|
237 |
|
195 |
|
|
|
196 |
|
197 |
if ($test_parameter) { |
238 |
if ($test_parameter) { |
198 |
print "TESTING MODE ONLY\n DOING NOTHING\n===============\n"; |
239 |
print "TESTING MODE ONLY\n DOING NOTHING\n===============\n"; |
199 |
} |
240 |
} |
200 |
|
241 |
|
201 |
my $marcFlavour = C4::Context->preference('marcflavour') || 'MARC21'; |
242 |
my $batch; |
|
|
243 |
my $marc_flavour = C4::Context->preference('marcflavour') || 'MARC21'; |
202 |
|
244 |
|
203 |
# The definition of $searcher must be before MARC::Batch->new |
245 |
# The definition of $searcher must be before MARC::Batch->new |
204 |
my $searcher = Koha::SearchEngine::Search->new( |
246 |
my $searcher = Koha::SearchEngine::Search->new( |
205 |
{ |
247 |
{ |
206 |
index => ( |
248 |
index => ( |
207 |
$authorities |
249 |
$authorities |
208 |
? $Koha::SearchEngine::AUTHORITIES_INDEX |
250 |
? $Koha::SearchEngine::AUTHORITIES_INDEX |
209 |
: $Koha::SearchEngine::BIBLIOS_INDEX |
251 |
: $Koha::SearchEngine::BIBLIOS_INDEX |
210 |
) |
252 |
) |
211 |
} |
253 |
} |
212 |
); |
254 |
); |
213 |
|
255 |
|
214 |
print "Characteristic MARC flavour: $marcFlavour\n" if $verbose; |
256 |
print "Characteristic MARC flavour: $marc_flavour\n" if $verbose; |
215 |
my $starttime = gettimeofday; |
257 |
my $starttime = gettimeofday; |
216 |
my $batch; |
258 |
|
217 |
my $fh = IO::File->new($input_marc_file); # don't let MARC::Batch open the file, as it applies the ':utf8' IO layer |
259 |
my $fh = IO::File->new($input_marc_file); # don't let MARC::Batch open the file, as it applies the ':utf8' IO layer |
218 |
if (defined $format && $format =~ /XML/i) { |
260 |
if (defined $format && $format =~ /XML/i) { |
219 |
# ugly hack follows -- MARC::File::XML, when used by MARC::Batch, |
261 |
# ugly hack follows -- MARC::File::XML, when used by MARC::Batch, |
Lines 226-279
if (defined $format && $format =~ /XML/i) {
Link Here
|
226 |
# extract the records, not using regexes to look |
268 |
# extract the records, not using regexes to look |
227 |
# for <record>.*</record>. |
269 |
# for <record>.*</record>. |
228 |
$MARC::File::XML::_load_args{BinaryEncoding} = 'utf-8'; |
270 |
$MARC::File::XML::_load_args{BinaryEncoding} = 'utf-8'; |
229 |
my $recordformat= ($marcFlavour eq "MARC21"?"USMARC":uc($marcFlavour)); |
271 |
my $recordformat = ($marc_flavour eq "MARC21" ? "USMARC" : uc($marc_flavour)); |
230 |
#UNIMARC Authorities have a different way to manage encoding than UNIMARC biblios. |
272 |
#UNIMARC Authorities have a different way to manage encoding than UNIMARC biblios. |
231 |
$recordformat=$recordformat."AUTH" if ($authorities and $marcFlavour ne "MARC21"); |
273 |
$recordformat = $recordformat . "AUTH" if ($authorities and $marc_flavour ne "MARC21"); |
232 |
$MARC::File::XML::_load_args{RecordFormat} = $recordformat; |
274 |
$MARC::File::XML::_load_args{RecordFormat} = $recordformat; |
233 |
$batch = MARC::Batch->new( 'XML', $fh ); |
275 |
$batch = MARC::Batch->new('XML', $fh); |
234 |
} else { |
276 |
} |
235 |
$batch = MARC::Batch->new( 'USMARC', $fh ); |
277 |
else { |
|
|
278 |
$batch = MARC::Batch->new('USMARC', $fh); |
236 |
} |
279 |
} |
|
|
280 |
|
237 |
$batch->warnings_off(); |
281 |
$batch->warnings_off(); |
238 |
$batch->strict_off(); |
282 |
$batch->strict_off(); |
239 |
my $i=0; |
|
|
240 |
my $commitnum = $commit ? $commit : 50; |
283 |
my $commitnum = $commit ? $commit : 50; |
241 |
my $yamlhash; |
284 |
my $yamlhash; |
242 |
|
285 |
|
243 |
# Skip file offset |
286 |
# Skip file offset |
244 |
if ( $offset ) { |
287 |
if ($offset) { |
245 |
print "Skipping file offset: $offset records\n"; |
288 |
print "Skipping file offset: $offset records\n"; |
246 |
$batch->next() while ($offset--); |
289 |
$batch->next() while ($offset--); |
247 |
} |
290 |
} |
248 |
|
291 |
|
249 |
my ($tagid,$subfieldid); |
292 |
my ($tagid, $subfieldid); |
250 |
if ($authorities){ |
293 |
if ($authorities) { |
251 |
$tagid='001'; |
294 |
$tagid = '001'; |
252 |
} |
295 |
} |
253 |
else { |
296 |
else { |
254 |
( $tagid, $subfieldid ) = |
297 |
($tagid, $subfieldid) = GetMarcFromKohaField("biblio.biblionumber"); |
255 |
GetMarcFromKohaField( "biblio.biblionumber" ); |
298 |
$tagid ||= "001"; |
256 |
$tagid||="001"; |
|
|
257 |
} |
299 |
} |
258 |
|
300 |
|
|
|
301 |
my $sth_isbn; |
259 |
# the SQL query to search on isbn |
302 |
# the SQL query to search on isbn |
260 |
my $sth_isbn = $dbh->prepare("SELECT biblionumber,biblioitemnumber FROM biblioitems WHERE isbn=?"); |
303 |
if ($isbn_check) { |
|
|
304 |
$sth_isbn = $dbh->prepare("SELECT biblionumber, biblioitemnumber FROM biblioitems WHERE isbn=?"); |
305 |
} |
261 |
|
306 |
|
262 |
my $loghandle; |
307 |
my $loghandle; |
263 |
if ($logfile){ |
308 |
if ($logfile) { |
264 |
$loghandle= IO::File->new($logfile, $writemode) ; |
309 |
$loghandle= IO::File->new($logfile, $writemode); |
265 |
print $loghandle "id;operation;status\n"; |
310 |
print $loghandle "id;operation;status\n"; |
266 |
} |
311 |
} |
267 |
|
312 |
|
|
|
313 |
my $record_number = 0; |
268 |
my $logger = Koha::Logger->get; |
314 |
my $logger = Koha::Logger->get; |
269 |
my $schema = Koha::Database->schema; |
315 |
my $schema = Koha::Database->schema; |
270 |
$schema->txn_begin; |
316 |
$schema->txn_begin; |
|
|
317 |
my $marc_records = []; |
271 |
RECORD: while ( ) { |
318 |
RECORD: while ( ) { |
272 |
my $record; |
319 |
my $record; |
273 |
# get records |
320 |
$record_number++; |
|
|
321 |
# get record |
274 |
eval { $record = $batch->next() }; |
322 |
eval { $record = $batch->next() }; |
275 |
if ( $@ ) { |
323 |
if ($@) { |
276 |
print "Bad MARC record $i: $@ skipped\n"; |
324 |
print "Bad MARC record $record_number: $@ skipped\n"; |
277 |
# FIXME - because MARC::Batch->next() combines grabbing the next |
325 |
# FIXME - because MARC::Batch->next() combines grabbing the next |
278 |
# blob and parsing it into one operation, a correctable condition |
326 |
# blob and parsing it into one operation, a correctable condition |
279 |
# such as a MARC-8 record claiming that it's UTF-8 can't be recovered |
327 |
# such as a MARC-8 record claiming that it's UTF-8 can't be recovered |
Lines 282-560
RECORD: while ( ) {
Link Here
|
282 |
# C4::Charset::MarcToUTF8Record) because it doesn't use MARC::Batch. |
330 |
# C4::Charset::MarcToUTF8Record) because it doesn't use MARC::Batch. |
283 |
next; |
331 |
next; |
284 |
} |
332 |
} |
285 |
# skip if we get an empty record (that is MARC valid, but will result in AddBiblio failure |
333 |
if ($record) { |
286 |
last unless ( $record ); |
334 |
# transcode the record to UTF8 if needed & applicable. |
287 |
$i++; |
335 |
if ($record->encoding() eq 'MARC-8' and not $skip_marc8_conversion) { |
288 |
if( ($verbose//1)==1 ) { #no dot for verbose==2 |
336 |
my ($guessed_charset, $charset_errors); |
289 |
print "." . ( $i % 100==0 ? "\n$i" : '' ); |
337 |
($record, $guessed_charset, $charset_errors) = MarcToUTF8Record($record, $marc_flavour . (($authorities and $marc_flavour ne "MARC21") ? 'AUTH' : '')); |
|
|
338 |
if ($guessed_charset eq 'failed') { |
339 |
warn "ERROR: failed to perform character conversion for record $record_number\n"; |
340 |
next RECORD; |
341 |
} |
342 |
} |
343 |
SetUTF8Flag($record); |
344 |
&$localcust($record) if $localcust; |
345 |
push @{$marc_records}, $record; |
346 |
} |
347 |
else { |
348 |
last; |
290 |
} |
349 |
} |
|
|
350 |
} |
291 |
|
351 |
|
292 |
# transcode the record to UTF8 if needed & applicable. |
352 |
$record_number = 0; |
293 |
if ($record->encoding() eq 'MARC-8' and not $skip_marc8_conversion) { |
353 |
my $records_total = @{$marc_records}; |
294 |
# FIXME update condition |
354 |
$schema->txn_begin; |
295 |
my ($guessed_charset, $charset_errors); |
355 |
RECORD: foreach my $record (@{$marc_records}) { |
296 |
($record, $guessed_charset, $charset_errors) = MarcToUTF8Record($record, $marcFlavour.(($authorities and $marcFlavour ne "MARC21")?'AUTH':'')); |
356 |
$record_number++; |
297 |
if ($guessed_charset eq 'failed') { |
357 |
if (($verbose//1) == 1) { #no dot for verbose==2 |
298 |
warn "ERROR: failed to perform character conversion for record $i\n"; |
358 |
print "." . ($record_number % 100 == 0 ? "\n$record_number" : ''); |
299 |
next RECORD; |
|
|
300 |
} |
301 |
} |
359 |
} |
302 |
SetUTF8Flag($record); |
360 |
|
303 |
if($marc_mod_template_id > 0) { |
361 |
if ($marc_mod_template_id > 0) { |
304 |
print "Modifying MARC\n" if $verbose; |
362 |
print "Modifying MARC\n" if $verbose; |
305 |
ModifyRecordWithTemplate( $marc_mod_template_id, $record ); |
363 |
ModifyRecordWithTemplate( $marc_mod_template_id, $record ); |
306 |
} |
364 |
} |
307 |
&$localcust($record) if $localcust; |
365 |
|
308 |
my $isbn; |
|
|
309 |
# remove trailing - in isbn (only for biblios, of course) |
366 |
# remove trailing - in isbn (only for biblios, of course) |
310 |
if( $biblios ) { |
367 |
if ($biblios && ($cleanisbn || $isbn_check)) { |
311 |
my $tag = $marcFlavour eq 'UNIMARC' ? '010' : '020'; |
368 |
my $tag = $marc_flavour eq 'UNIMARC' ? '010' : '020'; |
312 |
my $field = $record->field($tag); |
369 |
my $field = $record->field($tag); |
313 |
$isbn = $field && $field->subfield('a'); |
370 |
my $isbn = $field && $field->subfield('a'); |
314 |
if ( $isbn && $cleanisbn ) { |
371 |
if ($isbn && $cleanisbn) { |
315 |
$isbn =~ s/-//g; |
372 |
$isbn =~ s/-//g; |
316 |
$field->update('a' => $isbn); |
373 |
$field->update('a' => $isbn); |
317 |
} |
374 |
} |
318 |
} |
375 |
} |
319 |
my $id; |
|
|
320 |
# search for duplicates (based on Local-number) |
376 |
# search for duplicates (based on Local-number) |
321 |
my $originalid; |
377 |
my $originalid = GetRecordId($record, $tagid, $subfieldid); |
322 |
$originalid = GetRecordId( $record, $tagid, $subfieldid ); |
378 |
my $matched_record_id = undef; |
323 |
if ($match) { |
379 |
if ($match) { |
324 |
require C4::Search; |
380 |
require C4::Search; |
325 |
my $query = build_query( $match, $record ); |
381 |
my $server = ($authorities ? 'authorityserver' : 'biblioserver'); |
326 |
my $server = ( $authorities ? 'authorityserver' : 'biblioserver' ); |
382 |
my $query = build_query($match, $record); |
327 |
my ( $error, $results, $totalhits ) = $searcher->simple_search_compat( $query, 0, 3, [$server] ); |
383 |
$logger->debug("Bulkmarcimport: $query"); |
|
|
384 |
my ($error, $results, $totalhits) = $searcher->simple_search_compat($query, 0, 3, [$server]); |
328 |
# changed to warn so able to continue with one broken record |
385 |
# changed to warn so able to continue with one broken record |
329 |
if ( defined $error ) { |
386 |
if (defined $error) { |
330 |
warn "unable to search the database for duplicates : $error"; |
387 |
warn "unable to search the database for duplicates : $error"; |
331 |
printlog( { id => $id || $originalid || $match, op => "match", status => "ERROR" } ) if ($logfile); |
388 |
printlog({ id => $originalid , op => "match", status => "ERROR" }) if ($logfile); |
332 |
next RECORD; |
389 |
next RECORD; |
333 |
} |
390 |
} |
334 |
if ( $results && scalar(@$results) == 1 ) { |
391 |
$logger->debug("Bulkmarcimport: $query $server : $totalhits"); |
335 |
my $marcrecord = C4::Search::new_record_from_zebra( $server, $results->[0] ); |
392 |
# sub SimpleSearch could return undefined, but only on error, so |
336 |
SetUTF8Flag($marcrecord); |
393 |
# should not really need to safeguard here, but do so anyway |
337 |
$id = GetRecordId( $marcrecord, $tagid, $subfieldid ); |
394 |
$results //= []; |
338 |
if ( $authorities && $marcFlavour ) { |
395 |
if (@{$results} == 1) { |
339 |
#Skip if authority in database is the same as the on in database |
396 |
my $matched_record = C4::Search::new_record_from_zebra($server, $results->[0]); |
340 |
if ( $marcrecord->field('005') && $record->field('005') && |
397 |
SetUTF8Flag($matched_record); |
341 |
$marcrecord->field('005')->data && $record->field('005')->data && |
398 |
$matched_record_id = GetRecordId($matched_record, $tagid, $subfieldid); |
342 |
$marcrecord->field('005')->data >= $record->field('005')->data ) { |
399 |
|
|
|
400 |
if ($authorities && $marc_flavour) { |
401 |
#Skip if authority in database is the same or newer than the incoming record |
402 |
if (RecordRevisionIsGtOrEq($matched_record, $record)) { |
343 |
if ($yamlfile) { |
403 |
if ($yamlfile) { |
344 |
$yamlhash->{$originalid}->{'authid'} = $id; |
404 |
$yamlhash->{$originalid} = YAMLFileEntry( |
345 |
|
405 |
$matched_record, |
346 |
# we recover all subfields of the heading authorities |
406 |
$matched_record_id, |
347 |
my @subfields; |
407 |
0 |
348 |
foreach my $field ( $marcrecord->field("2..") ) { |
408 |
); |
349 |
push @subfields, map { ( $_->[0] =~ /[a-z]/ ? $_->[1] : () ) } $field->subfields(); |
|
|
350 |
} |
351 |
$yamlhash->{$originalid}->{'subfields'} = \@subfields; |
352 |
$yamlhash->{$originalid}->{'updated'} = 0; |
353 |
} |
409 |
} |
354 |
next; |
410 |
next; |
355 |
} |
411 |
} |
356 |
} |
412 |
} |
357 |
} elsif ( $results && scalar(@$results) > 1 ) { |
|
|
358 |
$logger->debug("more than one match for $query"); |
359 |
} else { |
360 |
$logger->debug("nomatch for $query"); |
361 |
} |
413 |
} |
362 |
} |
414 |
elsif(@{$results} > 1) { |
363 |
if ($keepids && $originalid) { |
415 |
$logger->debug("More than one match for: $query"); |
|
|
416 |
} |
417 |
else { |
418 |
$logger->debug("No match for: $query"); |
419 |
} |
420 |
|
421 |
if ($keepids && $originalid) { |
364 |
my $storeidfield; |
422 |
my $storeidfield; |
365 |
if ( length($keepids) == 3 ) { |
423 |
if (length($keepids) == 3) { |
366 |
$storeidfield = MARC::Field->new( $keepids, $originalid ); |
424 |
$storeidfield = MARC::Field->new($keepids, $originalid); |
367 |
} else { |
425 |
} else { |
368 |
$storeidfield = MARC::Field->new( substr( $keepids, 0, 3 ), "", "", substr( $keepids, 3, 1 ), $originalid ); |
426 |
$storeidfield = MARC::Field->new(substr($keepids, 0, 3), "", "", substr($keepids, 3, 1), $originalid); |
369 |
} |
427 |
} |
370 |
$record->insert_fields_ordered($storeidfield); |
428 |
$record->insert_fields_ordered($storeidfield); |
371 |
$record->delete_field( $record->field($tagid) ); |
429 |
$record->delete_field($record->field($tagid)); |
|
|
430 |
} |
372 |
} |
431 |
} |
|
|
432 |
|
373 |
foreach my $stringfilter (@$filters) { |
433 |
foreach my $stringfilter (@$filters) { |
374 |
if ( length($stringfilter) == 3 ) { |
434 |
if (length($stringfilter) == 3) { |
375 |
foreach my $field ( $record->field($stringfilter) ) { |
435 |
foreach my $field ($record->field($stringfilter)) { |
376 |
$record->delete_field($field); |
436 |
$record->delete_field($field); |
377 |
$logger->debug("removed : ", $field->as_string); |
437 |
$logger->debug("Removed: ", $field->as_string); |
378 |
} |
438 |
} |
379 |
} elsif ($stringfilter =~ /([0-9]{3})([a-z0-9])(.*)/) { |
439 |
} elsif ($stringfilter =~ /([0-9]{3})([a-z0-9])(.*)/) { |
380 |
my $removetag = $1; |
440 |
my $removetag = $1; |
381 |
my $removesubfield = $2; |
441 |
my $removesubfield = $2; |
382 |
my $removematch = $3; |
442 |
my $removematch = $3; |
383 |
if ( ( $removetag > "010" ) && $removesubfield ) { |
443 |
if (($removetag > "010") && $removesubfield) { |
384 |
foreach my $field ( $record->field($removetag) ) { |
444 |
foreach my $field ($record->field($removetag)) { |
385 |
$field->delete_subfield( code => "$removesubfield", match => $removematch ); |
445 |
$field->delete_subfield(code => "$removesubfield", match => $removematch); |
386 |
$logger->debug("Potentially removed : ", $field->subfield($removesubfield)); |
446 |
$logger->debug("Potentially removed: ", $field->subfield($removesubfield)); |
387 |
} |
447 |
} |
388 |
} |
448 |
} |
389 |
} |
449 |
} |
390 |
} |
450 |
} |
391 |
unless ($test_parameter) { |
451 |
unless ($test_parameter) { |
392 |
if ($authorities){ |
452 |
if ($authorities) { |
393 |
my $authtypecode=GuessAuthTypeCode($record, $heading_fields); |
453 |
my $authtypecode = GuessAuthTypeCode($record, $heading_fields); |
394 |
my $authid= ($id?$id:GuessAuthId($record)); |
454 |
my $authid = ($matched_record_id? $matched_record_id : GuessAuthId($record)); |
395 |
if ($authid && GetAuthority($authid) && $update ){ |
455 |
if ($authid && GetAuthority($authid) && $update) { |
396 |
## Authority has an id and is in database : Replace |
456 |
## Authority has an id and is in database : Replace |
397 |
eval { ( $authid ) = ModAuthority($authid,$record, $authtypecode) }; |
457 |
eval { ( $authid ) = ModAuthority($authid, $record, $authtypecode) }; |
398 |
if ($@){ |
458 |
if ($@) { |
399 |
warn "Problem with authority $authid Cannot Modify"; |
459 |
warn "Problem with authority $authid Cannot Modify"; |
400 |
printlog({id=>$originalid||$id||$authid, op=>"edit",status=>"ERROR"}) if ($logfile); |
460 |
printlog({ id => $authid, op => "edit", status => "ERROR" }) if ($logfile); |
|
|
461 |
} |
462 |
else{ |
463 |
printlog({ id=> $authid, op=> "edit", status => "ok"}) if ($logfile); |
401 |
} |
464 |
} |
402 |
else{ |
465 |
} |
403 |
printlog({id=>$originalid||$id||$authid, op=>"edit",status=>"ok"}) if ($logfile); |
466 |
else { |
404 |
} |
|
|
405 |
} |
406 |
else { |
407 |
## True insert in database |
467 |
## True insert in database |
408 |
eval { ( $authid ) = AddAuthority($record,"", $authtypecode) }; |
468 |
eval { ( $authid ) = AddAuthority($record, "", $authtypecode) }; |
409 |
if ($@){ |
469 |
if ($@) { |
410 |
warn "Problem with authority $authid Cannot Add".$@; |
470 |
warn "Problem with authority $originalid Cannot Add ".$@; |
411 |
printlog({id=>$originalid||$id||$authid, op=>"insert",status=>"ERROR"}) if ($logfile); |
471 |
printlog({ id => $originalid, op => "insert", status => "ERROR" }) if ($logfile); |
412 |
} |
472 |
} |
413 |
else{ |
473 |
else { |
414 |
printlog({id=>$originalid||$id||$authid, op=>"insert",status=>"ok"}) if ($logfile); |
474 |
printlog({ id => $authid, op => "insert", status => "ok" }) if ($logfile); |
415 |
} |
475 |
} |
416 |
} |
476 |
|
417 |
if ($yamlfile) { |
|
|
418 |
$yamlhash->{$originalid}->{'authid'} = $authid; |
419 |
my @subfields; |
420 |
foreach my $field ( $record->field("2..") ) { |
421 |
push @subfields, map { ( $_->[0] =~ /[a-z]/ ? $_->[1] : () ) } $field->subfields(); |
422 |
} |
477 |
} |
423 |
$yamlhash->{$originalid}->{'subfields'} = \@subfields; |
478 |
if ($yamlfile) { |
424 |
$yamlhash->{$originalid}->{'updated'} = 1; |
479 |
$yamlhash->{$originalid} = YAMLFileEntry( |
|
|
480 |
$record, |
481 |
$authid, |
482 |
1 #@FIXME: Really always updated? |
483 |
); |
425 |
} |
484 |
} |
426 |
} |
485 |
} |
427 |
else { |
486 |
else { |
428 |
my ( $biblionumber, $biblioitemnumber, $itemnumbers_ref, $errors_ref ); |
487 |
my ($biblioitemnumber, $itemnumbers_ref, $errors_ref, $record_id); |
429 |
$biblionumber = $id; |
|
|
430 |
# check for duplicate, based on ISBN (skip it if we already have found a duplicate with match parameter |
488 |
# check for duplicate, based on ISBN (skip it if we already have found a duplicate with match parameter |
431 |
if (!$biblionumber && $isbn_check && $isbn) { |
489 |
if (!$matched_record_id && $isbn_check && $isbn) { |
432 |
# warn "search ISBN : $isbn"; |
|
|
433 |
$sth_isbn->execute($isbn); |
490 |
$sth_isbn->execute($isbn); |
434 |
($biblionumber,$biblioitemnumber) = $sth_isbn->fetchrow; |
491 |
($matched_record_id, $biblioitemnumber) = $sth_isbn->fetchrow; |
435 |
} |
492 |
} |
436 |
if (defined $idmapfl) { |
493 |
|
437 |
if ($sourcetag < "010"){ |
494 |
if (defined $idmapfl && $matched_record_id) { |
438 |
if ($record->field($sourcetag)){ |
495 |
if ($sourcetag < "010") { |
439 |
my $source = $record->field($sourcetag)->data(); |
496 |
if ($record->field($sourcetag)) { |
440 |
printf($idmapfh "%s|%s\n",$source,$biblionumber); |
497 |
my $source = $record->field($sourcetag)->data(); |
441 |
} |
498 |
printf($idmapfh "%s|%s\n", $source, $matched_record_id); |
442 |
} else { |
499 |
} |
443 |
my $source=$record->subfield($sourcetag,$sourcesubfield); |
500 |
} |
444 |
printf($idmapfh "%s|%s\n",$source,$biblionumber); |
501 |
else { |
445 |
} |
502 |
my $source = $record->subfield($sourcetag, $sourcesubfield); |
446 |
} |
503 |
printf($idmapfh "%s|%s\n", $source, $matched_record_id); |
447 |
# create biblio, unless we already have it ( either match or isbn ) |
504 |
} |
448 |
if ($biblionumber) { |
505 |
} |
|
|
506 |
|
507 |
# create biblio, unless we already have it ( either match or isbn ) |
508 |
if ($matched_record_id) { |
509 |
# TODO: Implement also for authority records! |
449 |
eval{ |
510 |
eval{ |
450 |
$biblioitemnumber = Koha::Biblios->find( $biblionumber )->biblioitem->biblioitemnumber; |
511 |
$biblioitemnumber = Koha::Biblios->find( $matched_record_id )->biblioitem->biblioitemnumber; |
451 |
}; |
512 |
}; |
452 |
if ($update) { |
513 |
if ($update) { |
453 |
eval { ModBiblio( $record, $biblionumber, $framework, { overlay_context => { source => 'bulkmarcimport' } } ) }; |
514 |
my $success; |
|
|
515 |
eval { $success = ModBiblio($record, $matched_record_id, GetFrameworkCode($matched_record_id), $modify_biblio_marc_options) }; |
454 |
if ($@) { |
516 |
if ($@) { |
455 |
warn "ERROR: Edit biblio $biblionumber failed: $@\n"; |
517 |
warn "ERROR: Edit biblio $matched_record_id failed: $@\n"; |
456 |
printlog( { id => $id || $originalid || $biblionumber, op => "update", status => "ERROR" } ) if ($logfile); |
518 |
printlog( { id => $matched_record_id, op => "update", status => "ERROR" } ) if ($logfile); |
457 |
next RECORD; |
519 |
next RECORD; |
458 |
} else { |
|
|
459 |
printlog( { id => $id || $originalid || $biblionumber, op => "update", status => "ok" } ) if ($logfile); |
460 |
} |
520 |
} |
461 |
} else { |
521 |
elsif (!$success) { |
462 |
printlog( { id => $id || $originalid || $biblionumber, op => "insert", status => "warning : already in database" } ) if ($logfile); |
522 |
warn "ERROR: Edit biblio $matched_record_id failed for unkown reason"; |
463 |
} |
523 |
printlog( { id => $matched_record_id, op => "update", status => "ERROR" } ) if ($logfile); |
464 |
} else { |
|
|
465 |
if ($insert) { |
466 |
eval { ( $biblionumber, $biblioitemnumber ) = AddBiblio( $record, $framework, { defer_marc_save => 1 } ) }; |
467 |
if ($@) { |
468 |
warn "ERROR: Adding biblio $biblionumber failed: $@\n"; |
469 |
printlog( { id => $id || $originalid || $biblionumber, op => "insert", status => "ERROR" } ) if ($logfile); |
470 |
next RECORD; |
524 |
next RECORD; |
471 |
} else { |
|
|
472 |
printlog( { id => $id || $originalid || $biblionumber, op => "insert", status => "ok" } ) if ($logfile); |
473 |
} |
525 |
} |
474 |
} else { |
526 |
else { |
475 |
warn "WARNING: Updating record ".($id||$originalid)." failed"; |
527 |
$record_id = $matched_record_id; |
476 |
printlog( { id => $id || $originalid || $biblionumber, op => "update", status => "warning : not in database" } ) if ($logfile); |
528 |
printlog( { id => $record_id, op => "update", status => "ok" } ) if ($logfile); |
|
|
529 |
} |
530 |
} |
531 |
else { |
532 |
printlog( { id => $matched_record_id, op => "update", status => "warning : already in database and option -update not enabled, skipping..." } ) if ($logfile); |
533 |
} |
534 |
} |
535 |
elsif ($insert) { |
536 |
eval { ($record_id, $biblioitemnumber) = AddBiblio($record, $framework, { defer_marc_save => 1 }) }; |
537 |
if ($@) { |
538 |
warn "ERROR: Adding biblio $record_id failed: $@\n"; |
539 |
printlog( { id => $record_id, op => "insert", status => "ERROR" } ) if ($logfile); |
477 |
next RECORD; |
540 |
next RECORD; |
478 |
} |
541 |
} |
|
|
542 |
else { |
543 |
printlog( { id => $record_id, op => "insert", status => "ok" } ) if ($logfile); |
544 |
} |
479 |
} |
545 |
} |
480 |
eval { ( $itemnumbers_ref, $errors_ref ) = AddItemBatchFromMarc( $record, $biblionumber, $biblioitemnumber, '' ); }; |
546 |
else { |
481 |
my $error_adding = $@; |
547 |
warn "WARNING: Updating record ".($originalid)." failed"; |
482 |
# Work on a clone so that if there are real errors, we can maybe |
548 |
printlog( { id => $originalid, op => "insert", status => "warning : not in database and option -insert not enabled, skipping..." } ) if ($logfile); |
483 |
# fix them up later. |
|
|
484 |
my $clone_record = $record->clone(); |
485 |
C4::Biblio::_strip_item_fields($clone_record, ''); |
486 |
# This sets the marc fields if there was an error, and also calls |
487 |
# defer_marc_save. |
488 |
ModBiblioMarc( $clone_record, $biblionumber ); |
489 |
if ( $error_adding ) { |
490 |
warn "ERROR: Adding items to bib $biblionumber failed: $error_adding"; |
491 |
printlog({id=>$id||$originalid||$biblionumber, op=>"insertitem",status=>"ERROR"}) if ($logfile); |
492 |
# if we failed because of an exception, assume that |
493 |
# the MARC columns in biblioitems were not set. |
494 |
next RECORD; |
549 |
next RECORD; |
495 |
} |
550 |
} |
496 |
else{ |
551 |
my $record_has_added_items = 0; |
497 |
printlog({id=>$id||$originalid||$biblionumber, op=>"insertitem",status=>"ok"}) if ($logfile); |
552 |
if ($record_id) { |
498 |
} |
553 |
$yamlhash->{$originalid} = $record_id if $yamlfile; |
499 |
if ($dedup_barcode && grep { exists $_->{error_code} && $_->{error_code} eq 'duplicate_barcode' } @$errors_ref) { |
554 |
# TODO: Add option for skipping items? |
500 |
# Find the record called 'barcode' |
555 |
eval { ($itemnumbers_ref, $errors_ref) = AddItemBatchFromMarc($record, $record_id, $biblioitemnumber, $framework); }; |
501 |
my ($tag, $sub) = C4::Biblio::GetMarcFromKohaField( 'items.barcode' ); |
556 |
$record_has_added_items = @{$itemnumbers_ref}; |
502 |
# Now remove any items that didn't have a duplicate_barcode error, |
557 |
my $error_adding = $@; |
503 |
# erase the barcodes on items that did, and re-add those items. |
558 |
# Work on a clone so that if there are real errors, we can maybe |
504 |
my %dupes; |
559 |
# fix them up later. |
505 |
foreach my $i (0 .. $#{$errors_ref}) { |
560 |
my $clone_record = $record->clone(); |
506 |
my $ref = $errors_ref->[$i]; |
561 |
C4::Biblio::_strip_item_fields($clone_record, $framework); |
507 |
if ($ref && ($ref->{error_code} eq 'duplicate_barcode')) { |
562 |
# This sets the marc fields if there was an error, and also calls |
508 |
$dupes{$ref->{item_sequence}} = 1; |
563 |
# defer_marc_save. |
509 |
# Delete the error message because we're going to |
564 |
ModBiblioMarc($clone_record, $record_id, $modify_biblio_marc_options); |
510 |
# retry this one. |
565 |
if ($error_adding) { |
511 |
delete $errors_ref->[$i]; |
566 |
warn "ERROR: Adding items to bib $record_id failed: $error_adding"; |
512 |
} |
567 |
printlog({ id => $record_id, op => "insert items", status => "ERROR"}) if ($logfile); |
513 |
} |
|
|
514 |
my $seq = 0; |
515 |
foreach my $field ($record->field($tag)) { |
516 |
$seq++; |
517 |
if ($dupes{$seq}) { |
518 |
# Here we remove the barcode |
519 |
$field->delete_subfield(code => $sub); |
520 |
} else { |
521 |
# otherwise we delete the field because we don't want |
522 |
# two of them |
523 |
$record->delete_fields($field); |
524 |
} |
525 |
} |
526 |
# Now re-add the record as before, adding errors to the prev list |
527 |
my $more_errors; |
528 |
eval { ( $itemnumbers_ref, $more_errors ) = AddItemBatchFromMarc( $record, $biblionumber, $biblioitemnumber, '' ); }; |
529 |
if ( $@ ) { |
530 |
warn "ERROR: Adding items to bib $biblionumber failed: $@\n"; |
531 |
printlog({id=>$id||$originalid||$biblionumber, op=>"insertitem",status=>"ERROR"}) if ($logfile); |
532 |
# if we failed because of an exception, assume that |
568 |
# if we failed because of an exception, assume that |
533 |
# the MARC columns in biblioitems were not set. |
569 |
# the MARC columns in biblioitems were not set. |
534 |
ModBiblioMarc( $record, $biblionumber ); |
|
|
535 |
next RECORD; |
570 |
next RECORD; |
536 |
} else { |
|
|
537 |
printlog({id=>$id||$originalid||$biblionumber, op=>"insertitem",status=>"ok"}) if ($logfile); |
538 |
} |
571 |
} |
539 |
push @$errors_ref, @{ $more_errors }; |
572 |
else { |
540 |
} |
573 |
printlog({ id => $record_id, op => "insert items", status => "ok" }) if ($logfile); |
541 |
if ($#{ $errors_ref } > -1) { |
574 |
} |
542 |
report_item_errors($biblionumber, $errors_ref); |
575 |
if ($dedup_barcode && grep { exists $_->{error_code} && $_->{error_code} eq 'duplicate_barcode' } @$errors_ref) { |
|
|
576 |
# Find the record called 'barcode' |
577 |
my ($tag, $sub) = C4::Biblio::GetMarcFromKohaField('items.barcode'); |
578 |
# Now remove any items that didn't have a duplicate_barcode error, |
579 |
# erase the barcodes on items that did, and re-add those items. |
580 |
my %dupes; |
581 |
# FIXME: This could cause array out of bounds because shifting down rest of items on array item delete? |
582 |
foreach my $i (0 .. $#{$errors_ref}) { |
583 |
my $ref = $errors_ref->[$i]; |
584 |
if ($ref && ($ref->{error_code} eq 'duplicate_barcode')) { |
585 |
$dupes{$ref->{item_sequence}} = 1; |
586 |
# Delete the error message because we're going to |
587 |
# retry this one. |
588 |
delete $errors_ref->[$i]; |
589 |
} |
590 |
} |
591 |
my $seq = 0; |
592 |
foreach my $field ($record->field($tag)) { |
593 |
$seq++; |
594 |
if ($dupes{$seq}) { |
595 |
# Here we remove the barcode |
596 |
$field->delete_subfield(code => $sub); |
597 |
} |
598 |
else { |
599 |
# otherwise we delete the field because we don't want |
600 |
# two of them |
601 |
$record->delete_fields($field); |
602 |
} |
603 |
} |
604 |
# Now re-add the record as before, adding errors to the prev list |
605 |
my $more_errors; |
606 |
eval { ($itemnumbers_ref, $more_errors) = AddItemBatchFromMarc($record, $record_id, $biblioitemnumber, ''); }; |
607 |
$record_has_added_items ||= @{$itemnumbers_ref}; |
608 |
if ($@) { |
609 |
warn "ERROR: Adding items to bib $record_id failed: $@\n"; |
610 |
printlog({ id => $record_id, op => "insert items", status => "ERROR" }) if ($logfile); |
611 |
# if we failed because of an exception, assume that |
612 |
# the MARC columns in biblioitems were not set. |
613 |
|
614 |
# @FIXME: Why do we save here without stripping items? Besides, |
615 |
# save with stripped items has already been performed |
616 |
ModBiblioMarc($record, $record_id, $modify_biblio_marc_options); |
617 |
next RECORD; |
618 |
} |
619 |
else { |
620 |
printlog({ id => $record_id, op => "insert", status => "ok" }) if ($logfile); |
621 |
} |
622 |
push @$errors_ref, @{$more_errors}; |
623 |
} |
624 |
if (@{$errors_ref}) { |
625 |
report_item_errors($record_id, $errors_ref); |
626 |
} |
627 |
C4::Biblio::_strip_item_fields($record, $framework); |
628 |
if ($record_has_added_items || $matched_record_id) { |
629 |
# Replace with record from GetMarcBiblio with "$embeditems = 1" |
630 |
$record = GetMarcBiblio({biblionumber => $record_id, embed_items => 1}); |
631 |
} |
632 |
push @search_engine_record_ids, $record_id; |
633 |
push @search_engine_records, $record; |
543 |
} |
634 |
} |
544 |
$yamlhash->{$originalid} = $biblionumber if ($yamlfile); |
|
|
545 |
} |
635 |
} |
546 |
if ( 0 == $i % $commitnum ) { |
636 |
if ($record_number % $commitnum == 0 || $record_number == $records_total) { |
547 |
$schema->txn_commit; |
637 |
$schema->txn_commit; |
548 |
$schema->txn_begin; |
638 |
$schema->txn_begin; |
|
|
639 |
if ($indexer) { |
640 |
$indexer->update_index(\@search_engine_record_ids, \@search_engine_records); |
641 |
@search_engine_record_ids = (); |
642 |
@search_engine_records = (); |
643 |
} |
549 |
} |
644 |
} |
550 |
} |
645 |
} |
551 |
print $record->as_formatted()."\n" if ($verbose//0)==2; |
646 |
print $record->as_formatted() . "\n" if ($verbose//0) == 2; |
552 |
last if $i == $number; |
647 |
last if $record_number == $number; |
553 |
} |
648 |
} |
554 |
$schema->txn_commit; |
649 |
$schema->txn_commit; |
555 |
|
650 |
|
556 |
if ($fk_off) { |
651 |
if ($fk_off) { |
557 |
$dbh->do("SET FOREIGN_KEY_CHECKS = 1"); |
652 |
$dbh->do("SET FOREIGN_KEY_CHECKS = 1"); |
558 |
} |
653 |
} |
559 |
|
654 |
|
560 |
# Restore CataloguingLog and AuthoritiesLog |
655 |
# Restore CataloguingLog and AuthoritiesLog |
Lines 562-572
delete $ENV{OVERRIDE_SYSPREF_CataloguingLog};
Link Here
|
562 |
delete $ENV{OVERRIDE_SYSPREF_AuthoritiesLog}; |
657 |
delete $ENV{OVERRIDE_SYSPREF_AuthoritiesLog}; |
563 |
|
658 |
|
564 |
my $timeneeded = gettimeofday - $starttime; |
659 |
my $timeneeded = gettimeofday - $starttime; |
565 |
print "\n$i MARC records done in $timeneeded seconds\n"; |
660 |
print "\n$record_number MARC records done in $timeneeded seconds\n"; |
566 |
if ($logfile){ |
661 |
if ($logfile) { |
567 |
print $loghandle "file : $input_marc_file\n"; |
662 |
print $loghandle "file : $input_marc_file\n"; |
568 |
print $loghandle "$i MARC records done in $timeneeded seconds\n"; |
663 |
print $loghandle "$record_number MARC records done in $timeneeded seconds\n"; |
569 |
$loghandle->close; |
664 |
$loghandle->close; |
570 |
} |
665 |
} |
571 |
if ($yamlfile) { |
666 |
if ($yamlfile) { |
572 |
open my $yamlfileout, q{>}, "$yamlfile" or die "cannot open $yamlfile \n"; |
667 |
open my $yamlfileout, q{>}, "$yamlfile" or die "cannot open $yamlfile \n"; |
Lines 574-620
if ($yamlfile) {
Link Here
|
574 |
} |
669 |
} |
575 |
exit 0; |
670 |
exit 0; |
576 |
|
671 |
|
577 |
sub GetRecordId{ |
672 |
sub YAMLFileEntry { |
578 |
my $marcrecord=shift; |
673 |
my ($record, $record_id, $updated) = @_; |
579 |
my $tag=shift; |
674 |
|
580 |
my $subfield=shift; |
675 |
my $entry = { |
581 |
my $id; |
676 |
authid => $record_id |
582 |
if ($tag lt "010"){ |
677 |
}; |
583 |
return $marcrecord->field($tag)->data() if $marcrecord->field($tag); |
678 |
|
584 |
} |
679 |
# we recover all subfields of the heading authorities |
585 |
elsif ($subfield){ |
680 |
my @subfields; |
586 |
if ($marcrecord->field($tag)){ |
681 |
foreach my $field ($record->field("2..")) { |
587 |
return $marcrecord->subfield($tag,$subfield); |
682 |
push @subfields, map { ( $_->[0] =~ /[a-z]/ ? $_->[1] : () ) } $field->subfields(); |
588 |
} |
683 |
} |
589 |
} |
684 |
$entry->{'subfields'} = \@subfields; |
590 |
return $id; |
685 |
$entry->{'updated'} = $updated; |
|
|
686 |
|
687 |
return $entry; |
591 |
} |
688 |
} |
592 |
sub build_query { |
689 |
|
593 |
my $match = shift; |
690 |
sub RecordRevisionIsGtOrEq { |
594 |
my $record=shift; |
691 |
my ($record_a, $record_b) = @_; |
595 |
my @searchstrings; |
692 |
return $record_a->field('005') && $record_b->field('005') && |
596 |
foreach my $matchingpoint (@$match){ |
693 |
$record_a->field('005')->data && $record_b->field('005')->data && |
597 |
my $string = build_simplequery($matchingpoint,$record); |
694 |
$record_a->field('005')->data >= $record_b->field('005')->data; |
598 |
push @searchstrings,$string if (length($string)>0); |
695 |
} |
|
|
696 |
|
697 |
sub GetRecordId { |
698 |
my $marcrecord = shift; |
699 |
my $tag = shift; |
700 |
my $subfield = shift; |
701 |
if ($tag lt "010") { |
702 |
return $marcrecord->field($tag)->data() if $marcrecord->field($tag); |
703 |
} |
704 |
elsif ($subfield) { |
705 |
if ($marcrecord->field($tag)) { |
706 |
return $marcrecord->subfield($tag, $subfield); |
599 |
} |
707 |
} |
|
|
708 |
} |
709 |
return undef; |
710 |
} |
711 |
sub build_query { |
712 |
my ($match, $record) = @_; |
713 |
my @searchstrings; |
714 |
|
715 |
foreach my $matchpoint (@$match) { |
716 |
my $query = build_simplequery($matchpoint, $record); |
717 |
push (@searchstrings, $query) if $query; |
718 |
} |
600 |
my $op = 'and'; |
719 |
my $op = 'and'; |
601 |
return join(" $op ",@searchstrings); |
720 |
return join(" $op ", @searchstrings); |
602 |
} |
721 |
} |
603 |
sub build_simplequery { |
722 |
sub build_simplequery { |
604 |
my $element=shift; |
723 |
my ($matchpoint, $record) = @_; |
605 |
my $record=shift; |
724 |
|
606 |
my @searchstrings; |
725 |
my @searchstrings; |
607 |
my ($index,$recorddata)=split /,/,$element; |
726 |
my ($index, $record_data) = split (/,/, $matchpoint); |
608 |
if ($recorddata=~/(\d{3})(.*)/) { |
727 |
if ($record_data =~ /(\d{3})(.*)/) { |
609 |
my ($tag,$subfields) =($1,$2); |
728 |
my ($tag, $subfields) = ($1, $2); |
610 |
foreach my $field ($record->field($tag)){ |
729 |
foreach my $field ($record->field($tag)) { |
611 |
if (length($field->as_string("$subfields"))>0){ |
730 |
if (length($field->as_string("$subfields")) > 0) { |
612 |
push @searchstrings,"$index:\"".$field->as_string("$subfields")."\""; |
731 |
push (@searchstrings, "$index:\"" . $field->as_string("$subfields") . "\""); |
613 |
} |
732 |
} |
614 |
} |
733 |
} |
615 |
} |
734 |
} |
|
|
735 |
else { |
736 |
print "Invalid matchpoint format, invalid marc-field: $matchpoint\n"; |
737 |
} |
616 |
my $op = 'and'; |
738 |
my $op = 'and'; |
617 |
return join(" $op ",@searchstrings); |
739 |
return join(" $op ", @searchstrings); |
618 |
} |
740 |
} |
619 |
sub report_item_errors { |
741 |
sub report_item_errors { |
620 |
my $biblionumber = shift; |
742 |
my $biblionumber = shift; |
Lines 629-648
sub report_item_errors {
Link Here
|
629 |
print $msg, "\n"; |
751 |
print $msg, "\n"; |
630 |
} |
752 |
} |
631 |
} |
753 |
} |
632 |
sub printlog{ |
754 |
sub printlog { |
633 |
my $logelements=shift; |
755 |
my $logelements = shift; |
634 |
print $loghandle join( ";", map { defined $_ ? $_ : "" } @$logelements{qw<id op status>} ), "\n"; |
756 |
print $loghandle join(";", map { defined $_ ? $_ : "" } @$logelements{qw<id op status>}), "\n"; |
635 |
} |
757 |
} |
636 |
sub get_heading_fields{ |
758 |
sub get_heading_fields { |
637 |
my $headingfields; |
759 |
my $headingfields; |
638 |
if ($authtypes){ |
760 |
if ($authtypes) { |
639 |
$headingfields = YAML::XS::LoadFile($authtypes); |
761 |
$headingfields = YAML::XS::LoadFile($authtypes); |
640 |
$headingfields={C4::Context->preference('marcflavour')=>$headingfields}; |
762 |
$headingfields = { C4::Context->preference('marcflavour') => $headingfields }; |
641 |
$logger->debug(Encode::decode_utf8(YAML::XS::Dump($headingfields))); |
763 |
$logger->debug(Encode::decode_utf8(YAML::XS::Dump($headingfields))); |
642 |
} |
764 |
} |
643 |
unless ($headingfields){ |
765 |
unless ($headingfields) { |
644 |
$headingfields=$dbh->selectall_hashref("SELECT auth_tag_to_report, authtypecode from auth_types",'auth_tag_to_report',{Slice=>{}}); |
766 |
$headingfields = $dbh->selectall_hashref("SELECT auth_tag_to_report, authtypecode from auth_types",'auth_tag_to_report',{Slice=>{}}); |
645 |
$headingfields={C4::Context->preference('marcflavour')=>$headingfields}; |
767 |
$headingfields = { C4::Context->preference('marcflavour') => $headingfields }; |
646 |
} |
768 |
} |
647 |
return $headingfields; |
769 |
return $headingfields; |
648 |
} |
770 |
} |
649 |
- |
|
|