SITKA Public Git / sitka / sitka-tools.git / blame
| Commit | Line | Data |
|---|---|---|
| 11561776 MB |
1 | echo create table with bib ids for records with no items |
| 2 | psql -h 192.168.0.212 -U evergreen -f getbibidswithnoitems.sql | |
| 3 | ||
| 4 | echo output bib ids for regular bibs to file | |
| 5 | psql -h 192.168.0.212 -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 | |
| 6 | ||
| 7 | echo output bib ids for bibs with no items to file | |
| 8 | psql -h 192.168.0.212 -U evergreen -A -t -c 'select distinct record from cotr.non_ebsco_ebibs order by record' > bibids_noitems | |
| 9 | ||
| 10 | echo outputting MARC file for bibs with no items | |
| 11 | cat bibids_noitems | ./marc_export_custom_branches --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 | |
| 12 | ||
| 13 | echo outputting MARC file for regular bibs ... | |
| 14 | cat bibids | ./marc_export_custom_branches --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 -branch BCREK-CRA,BCREK-CRE,BCREK-FER,BCREK-GOL,BCREK-INV,BCREK-KIM,BCREK-GCR --exclusion_ini cotr_ebsco.ini &> cotr_mrc.log | |
| 15 | ||
| 16 | echo add cotr.mrc + cotr_noitems.mrc together to cotr_total.mrc | |
| 17 | cat cotr.mrc cotr_noitems.mrc > cotr_total.mrc | |
| 18 |