use marc_export_custom in cotr runscript
[sitka/sitka-tools.git] / marc_export_custom / runscript.sh
CommitLineData
11561776 1echo create table with bib ids for records with no items
952fe555 2psql -h db1.sitka.bclibraries.ca -U evergreen -f getbibidswithnoitems.sql
11561776
MB
3
4echo output bib ids for regular bibs to file
952fe555 5psql -h db1.sitka.bclibraries.ca -U evergreen -A -t -c 'select distinct record from asset.call_number where deleted is false and owning_lib between 39 and 46 order by record' > bibids
11561776
MB
6
7echo output bib ids for bibs with no items to file
952fe555 8psql -h db1.sitka.bclibraries.ca -U evergreen -A -t -c 'select distinct record from cotr.non_ebsco_ebibs order by record' > bibids_noitems
11561776
MB
9
10echo outputting MARC file for bibs with no items
6c35692d 11cat bibids_noitems | ./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --output-file cotr_noitems.mrc --timeout 300 --force901 --encoding UTF-8 --location SITKA --collapse_to_depth 2 &> cotr_noitems_mrc.log
11561776
MB
12
13echo outputting MARC file for regular bibs ...
6c35692d 14cat bibids | ./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --output-file cotr.mrc --timeout 300 --force901 --encoding UTF-8 --items --location SITKA --collapse_to_depth 2 --onlyholdings --exclusion_ini cotr_ebsco.ini &> cotr_mrc.log
11561776
MB
15
16echo add cotr.mrc + cotr_noitems.mrc together to cotr_total.mrc
17cat cotr.mrc cotr_noitems.mrc > cotr_total.mrc
18