removing COTR temporarily
authorJames Fournie <jfournie@sitka.bclibraries.ca>
Tue, 13 Sep 2011 18:08:11 +0000 (11:08 -0700)
committerJames Fournie <jfournie@sitka.bclibraries.ca>
Tue, 13 Sep 2011 18:08:11 +0000 (11:08 -0700)
marc_export_custom/bc_eln_media.ini
marc_export_custom/bc_eln_serials.ini
marc_export_custom/sitka-export-no-cotr.sh [new file with mode: 0644]
marc_export_custom/sitka-full-export.sh

index 896a923..7f18416 100644 (file)
@@ -33,3 +33,7 @@ ExcludeEntireOrg=true
 
 [BVAVSA]
 OnlyIncludeLocations=16mm film,CD-ROM,DVD,DVD magazine,Sound Effect\, ExCat CD\,CD accompanying book,sound recording,Special Collections - AV - Library Use Only,Video
+
+[BCREK]
+;fixme
+ExcludeentireOrg=true
index 54e5ae7..c605bc1 100644 (file)
@@ -35,4 +35,5 @@ ExcludeEntireOrg=true
 OnlyIncludeLocations=Magazine,DVD magazine,Special Collections - Magazines - Library Use Only
 
 [BCREK]
-OnlyIncludeCircModifiers=magzine
+ExcludeEntireOrg=true
+;OnlyIncludeCircModifiers=magzine
diff --git a/marc_export_custom/sitka-export-no-cotr.sh b/marc_export_custom/sitka-export-no-cotr.sh
new file mode 100644 (file)
index 0000000..592d897
--- /dev/null
@@ -0,0 +1,20 @@
+#!/bin/bash
+
+cd /srv/openils/bin
+
+DATABASE=evergreen
+FULL_QUERY="select id from biblio.record_entry where not deleted"
+POSTSEC_QUERY="select record FROM asset.call_number where owning_lib = 610 and not deleted and label != '##URI##';"
+#POSTSEC_QUERY="select record FROM asset.call_number where owning_lib in (select id from actor.org_unit_descendants(27)) and not deleted and label != '##URI##';"
+
+# full dump for outlook public libraries
+psql -A -t -c "$FULL_QUERY" $DATABASE\
+|./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --force901 --exclusion_ini sitka_full_outlook.ini 
+
+# media for BC ELN post-secondary libraries
+psql -A -t -c "$POSTSEC_QUERY" $DATABASE\
+|./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --force901 --exclusion_ini bc_eln_media.ini 
+~
+# serials for BC ELN post-secondary libraries
+psql -A -t -c "$POSTSEC_QUERY" $DATABASE\
+|./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --force901 --exclusion_ini bc_eln_serials.ini 
index 5da7744..41e48a0 100644 (file)
@@ -4,7 +4,7 @@ cd /srv/openils/bin
 
 DATABASE=evergreen
 FULL_QUERY="select id from biblio.record_entry where not deleted"
-POSTSEC_QUERY="select * FROM asset.call_number where owning_lib in (select id from actor.org_unit_descendants(27)) and not deleted and label != '##URI##';"
+POSTSEC_QUERY="select record FROM asset.call_number where owning_lib in (select id from actor.org_unit_descendants(27)) and not deleted and label != '##URI##';"
 
 # full dump for outlook public libraries
 psql -A -t -c "$FULL_QUERY" $DATABASE\