#!/usr/bin/perl use strict; use warnings; use bytes; use OpenSRF::System; use OpenSRF::EX qw/:try/; use OpenSRF::AppSession; use OpenSRF::Utils::JSON; use OpenSRF::Utils::SettingsClient; use OpenILS::Application::AppUtils; use OpenILS::Utils::Fieldmapper; use MARC::Record; use MARC::File::XML; use UNIVERSAL::require; use Time::HiRes qw/time/; use Getopt::Long; my @formats = qw/USMARC UNIMARC XML BRE/; my ($config,$format,$encoding,$location,$dollarsign,$idl,$help,$holdings) = ('/openils/conf/opensrf_core.xml','USMARC','MARC8','','$'); GetOptions( 'help' => \$help, 'items' => \$holdings, 'location=s' => \$location, 'money=s' => \$dollarsign, 'config=s' => \$config, 'format=s' => \$format, 'xml-idl=s' => \$idl, 'encoding=s' => \$encoding, ); if ($help) { print <<" HELP"; Usage: $0 [options] --help or -h This screen. --config or -c Configuration file [/openils/conf/opensrf_core.xml] --format or -f Output format (USMARC, UNIMARC, XML) [USMARC] --encoding or -e Output Encoding (UTF-8, ISO-8859-?, MARC8) [MARC8] --items or -i Include items (holdings) in the output --xml-idl or -x Location of the IDL XML --location or -l MARC Location Code for holdings from http://www.loc.gov/marc/organizations/orgshome.html Example: cat list_of_ids | $0 > output_file HELP exit; } $format = uc($format); $encoding = uc($encoding); binmode(STDOUT, ':raw') if ($encoding ne 'UTF-8'); binmode(STDOUT, ':utf8') if ($encoding eq 'UTF-8'); if (!grep { uc($format) eq $_ } @formats) { die "Please select a supported format. ". "Right now that means one of [". join('|',@formats). "]\n"; } if ($format ne 'XML') { my $type = 'MARC::File::' . $format; $type->require; } OpenSRF::System->bootstrap_client( config_file => $config ); if (!$idl) { $idl = OpenSRF::Utils::SettingsClient->new->config_value("IDL"); } Fieldmapper->import(IDL => $idl); my $ses = OpenSRF::AppSession->create('open-ils.cstore'); print <
HEADER my %orgs; my %shelves; my $flesh = {}; if ($holdings) { print STDERR "Retrieving Org Units ... "; my $r = $ses->request( 'open-ils.cstore.direct.actor.org_unit.search', { id => { '!=' => undef } } ); while (my $o = $r->recv) { die $r->failed->stringify if ($r->failed); $o = $o->content; last unless ($o); $orgs{$o->id} = $o; } $r->finish; print STDERR "OK\n"; print STDERR "Retrieving Shelving locations ... "; $r = $ses->request( 'open-ils.cstore.direct.asset.copy_location.search', { id => { '!=' => undef } } ); while (my $s = $r->recv) { die $r->failed->stringify if ($r->failed); $s = $s->content; last unless ($s); $shelves{$s->id} = $s; } $r->finish; print STDERR "OK\n"; $flesh = { flesh => 2, flesh_fields => { bre => [ 'call_numbers' ], acn => [ 'copies' ] } }; } my $start = time; my $last_time = time; my %count = (); my $speed = 0; while ( my $i = <> ) { my $bib; try { local $SIG{ALRM} = sub { die "TIMEOUT\n" }; alarm(1); $bib = $ses->request( 'open-ils.cstore.direct.biblio.record_entry.retrieve', $i, $flesh )->gather(1); alarm(0); } otherwise { warn "\n!!!!!! Timed out trying to read record $i\n"; }; alarm(0); $count{bib}++; next unless $bib; if (uc($format) eq 'BRE') { print OpenSRF::Utils::JSON->perl2JSON($bib); stats(); next; } try { my $r = MARC::Record->new_from_xml( $bib->marc, $encoding, $format ); $r->delete_field( $_ ) for ($r->field(901)); $r->append_fields( MARC::Field->new( 901, '', '', a => $bib->tcn_value, b => $bib->tcn_source, c => $bib->id ) ); my $cn_list = $bib->call_numbers; if ($cn_list && @$cn_list) { $count{cn} += @$cn_list; my $cp_list = [ map { @{ $_->copies } } @$cn_list ]; if ($cp_list && @$cp_list) { my %cn_map; push @{$cn_map{$_->call_number}}, $_ for (@$cp_list); for my $cn ( @$cn_list ) { my $cn_map_list = $cn_map{$cn->id}; for my $cp ( @$cn_map_list ) { $count{cp}++; $r->append_fields( MARC::Field->new( 852, '4', '', a => $location, b => $orgs{$cn->owning_lib}->shortname, b => $orgs{$cp->circ_lib}->shortname, c => $shelves{$cp->location}->name, j => $cn->label, ($cp->circ_modifier ? ( g => $cp->circ_modifier ) : ()), p => $cp->barcode, ($cp->price ? ( y => $dollarsign.$cp->price ) : ()), ($cp->copy_number ? ( t => $cp->copy_number ) : ()), ($cp->ref eq 't' ? ( x => 'reference' ) : ()), ($cp->holdable eq 'f' ? ( x => 'unholdable' ) : ()), ($cp->circulate eq 'f' ? ( x => 'noncirculating' ) : ()), ($cp->opac_visible eq 'f' ? ( x => 'hidden' ) : ()), ) ); stats() if (! ($count{cp} % 100 )); } } } } if (uc($format) eq 'XML') { print $r->as_xml_record; } elsif (uc($format) eq 'UNIMARC') { print $r->as_unimarc } elsif (uc($format) eq 'USMARC') { print $r->as_usmarc } $count{did}++; } otherwise { my $e = shift; warn "\n$e\n"; }; stats() if (! ($count{bib} % 50 )); } print "\n" if ($format eq 'XML'); $speed = $count{did} / (time - $start); my $time = time - $start; print STDERR <