Update MARC export process for Outlook, per RT#42708

[sitka/sitka-tools.git] / marc_export_custom / fetch-shortcodes.sh

diff --git a/marc_export_custom/fetch-shortcodes.sh b/marc_export_custom/fetch-shortcodes.sh
index a9c45da..48380da 100755 (executable)
--- a/marc_export_custom/fetch-shortcodes.sh
+++ b/marc_export_custom/fetch-shortcodes.sh
@@ -1,5 +1,9 @@
 #!/bin/bash 
-psql -Upostgres -U evergreen evergreen -h db1.sitka.bclibraries.ca -o shortcodes.csv \
+SHORTCODES=$1
+if [ -z "${SHORTCODES}" ]; then
+    SHORTCODES="shortcodes.csv"
+fi
+psql -Upostgres -U evergreen evergreen -h prod-pg94-db2-sitka.sitka.bclibraries.ca -o $SHORTCODES \
 -c "COPY (
       SELECT
         a.shortname,a.name,b.shortname AS parent