From afd6f560bb2e8e599b6dc33ab06b02a248f0c29f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 28 Jan 2013 12:02:26 -0500 Subject: [PATCH] ACQ MARC upload UI default values SQL Adds a series of org unit settings for configuring the default values to use for the acquisistions MARC upload interface. Signed-off-by: Bill Erickson Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 211 ++++++++++++++++++++ .../upgrade/XXXX.data.acq_po_upload_defaults.sql | 214 +++++++++++++++++++++ 2 files changed, 425 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_po_upload_defaults.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 6e4e460c5b..2ed62c0dd8 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -12150,3 +12150,214 @@ INSERT INTO config.org_unit_setting_type 'integer', 544 ); + +INSERT INTO config.org_unit_setting_type + (name, label, description, grp, datatype, fm_class) +VALUES ( + 'acq.upload.default.create_po', + oils_i18n_gettext( + 'acq.upload.default.create_po', + 'ACQ Upoad Create PO', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.create_po', + 'Create a purchase order by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.activate_po', + oils_i18n_gettext( + 'acq.upload.default.activate_po', + 'ACQ Upoad Activate PO', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.activate_po', + 'Activate the purchase order by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.provider', + oils_i18n_gettext( + 'acq.upload.default.provider', + 'ACQ Upoad Default Provider', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.provider', + 'Default provider to use during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'acqpro' +), ( + 'acq.upload.default.vandelay.match_set', + oils_i18n_gettext( + 'acq.upload.default.vandelay.match_set', + 'ACQ Upoad Default Match Set', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.match_set', + 'Default match set to use during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'vms' +), ( + 'acq.upload.default.vandelay.merge_profile', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_profile', + 'ACQ Upoad Default Merge Profile', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_profile', + 'Default merge profile to use during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'vmp' +), ( + 'acq.upload.default.vandelay.import_non_matching', + oils_i18n_gettext( + 'acq.upload.default.vandelay.import_non_matching', + 'ACQ Upoad Import Non Matching by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.import_non_matching', + 'Import non-matching records by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.merge_on_exact', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_exact', + 'ACQ Upoad Merge on Exact Match by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_exact', + 'Merge records on exact match by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.merge_on_best', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_best', + 'ACQ Upoad Merge on Best Match by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_best', + 'Merge records on best match by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.merge_on_single', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_single', + 'ACQ Upoad Merge on Single Match by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_single', + 'Merge records on single match by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.quality_ratio', + oils_i18n_gettext( + 'acq.upload.default.vandelay.quality_ratio', + 'ACQ Upoad Default Min. Quality Ratio', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.quality_ratio', + 'Default minimum quality ratio used during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'integer', + NULL +), ( + 'acq.upload.default.vandelay.low_quality_fall_thru_profile', + oils_i18n_gettext( + 'acq.upload.default.vandelay.low_quality_fall_thru_profile', + 'ACQ Upoad Default Insufficient Quality Fall-Thru Profile', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.low_quality_fall_thru_profile', + 'Default low-quality fall through profile used during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'vmp' +), ( + 'acq.upload.default.vandelay.load_item_for_imported', + oils_i18n_gettext( + 'acq.upload.default.vandelay.load_item_for_imported', + 'ACQ Upoad Load Items for Imported Records by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.load_item_for_imported', + 'Load items for imported records by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +); + + +>>>>>>> ACQ MARC upload UI default values SQL diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_po_upload_defaults.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_po_upload_defaults.sql new file mode 100644 index 0000000000..a2df99a7fb --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_po_upload_defaults.sql @@ -0,0 +1,214 @@ + +BEGIN; + +-- TODO SET VERSION + +INSERT INTO config.org_unit_setting_type + (name, label, description, grp, datatype, fm_class) VALUES +( + 'acq.upload.default.create_po', + oils_i18n_gettext( + 'acq.upload.default.create_po', + 'ACQ Upoad Create PO', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.create_po', + 'Create a purchase order by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.activate_po', + oils_i18n_gettext( + 'acq.upload.default.activate_po', + 'ACQ Upoad Activate PO', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.activate_po', + 'Activate the purchase order by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.provider', + oils_i18n_gettext( + 'acq.upload.default.provider', + 'ACQ Upoad Default Provider', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.provider', + 'Default provider to use during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'acqpro' +), ( + 'acq.upload.default.vandelay.match_set', + oils_i18n_gettext( + 'acq.upload.default.vandelay.match_set', + 'ACQ Upoad Default Match Set', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.match_set', + 'Default match set to use during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'vms' +), ( + 'acq.upload.default.vandelay.merge_profile', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_profile', + 'ACQ Upoad Default Merge Profile', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_profile', + 'Default merge profile to use during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'vmp' +), ( + 'acq.upload.default.vandelay.import_non_matching', + oils_i18n_gettext( + 'acq.upload.default.vandelay.import_non_matching', + 'ACQ Upoad Import Non Matching by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.import_non_matching', + 'Import non-matching records by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.merge_on_exact', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_exact', + 'ACQ Upoad Merge on Exact Match by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_exact', + 'Merge records on exact match by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.merge_on_best', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_best', + 'ACQ Upoad Merge on Best Match by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_best', + 'Merge records on best match by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.merge_on_single', + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_single', + 'ACQ Upoad Merge on Single Match by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.merge_on_single', + 'Merge records on single match by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +), ( + 'acq.upload.default.vandelay.quality_ratio', + oils_i18n_gettext( + 'acq.upload.default.vandelay.quality_ratio', + 'ACQ Upoad Default Min. Quality Ratio', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.quality_ratio', + 'Default minimum quality ratio used during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'integer', + NULL +), ( + 'acq.upload.default.vandelay.low_quality_fall_thru_profile', + oils_i18n_gettext( + 'acq.upload.default.vandelay.low_quality_fall_thru_profile', + 'ACQ Upoad Default Insufficient Quality Fall-Thru Profile', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.low_quality_fall_thru_profile', + 'Default low-quality fall through profile used during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'link', + 'vmp' +), ( + 'acq.upload.default.vandelay.load_item_for_imported', + oils_i18n_gettext( + 'acq.upload.default.vandelay.load_item_for_imported', + 'ACQ Upoad Load Items for Imported Records by Default', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'acq.upload.default.vandelay.load_item_for_imported', + 'Load items for imported records by default during ACQ file upload', + 'coust', + 'description' + ), + 'acq', + 'bool', + NULL +); + +COMMIT; -- 2.11.0