migration_tools.name_parse_out_fuller_last_first_middle_and_random_affix2

[migration-tools.git] / mig-bin / mig-loadbibs

diff --git a/mig-bin/mig-loadbibs b/mig-bin/mig-loadbibs
index c200fc6..119a1ec 100755 (executable)
--- a/mig-bin/mig-loadbibs
+++ b/mig-bin/mig-loadbibs
@@ -126,7 +126,9 @@ if ($file_is_xml) {
 } 
 $batch->strict_off();
 
-while ( my $record = $batch->next() ) {
+my $record;
+#while ( my $record = $batch->next() ) {
+while ( eval {$record = $batch->next()} or do { if (!$record and !$@) { last; } else { next; }} ) {
        my $xml = $record->as_xml_record();
     $xml = marc8_to_utf8($xml);
        $i++;
@@ -135,9 +137,9 @@ while ( my $record = $batch->next() ) {
        my @warnings = $batch->warnings();
        my $warning_string;
        if (@warnings) { $warning_string = "'" . join(':',@warnings) . "'"; } else { $warning_string = "'none'"; }
-       my $sql = "INSERT INTO $MIGSCHEMA.biblio_record_entry_legacy (marc,x_source,x_warnings) VALUES ($xml,'$source',$warning_string);";
+       my $sql = "INSERT INTO $MIGSCHEMA.$stage_table (marc,x_source,x_warnings) VALUES ($xml,'$source',$warning_string);";
     my $sth = $dbh->prepare($sql);
-    $sth->execute();
+    eval { $sth->execute() };
        report_progress("Records staged", $i) if 0 != $i % 100;
 }