Vendor |
[% target.provider.name %]
[% target.provider.addresses.0.street1 %]
[% target.provider.addresses.0.street2 %]
[% target.provider.addresses.0.city %]
[% target.provider.addresses.0.state %]
[% target.provider.addresses.0.country %]
[% target.provider.addresses.0.post_code %]
|
Ship to / Bill to |
[% target.ordering_agency.name %]
[% target.ordering_agency.billing_address.street1 %]
[% target.ordering_agency.billing_address.street2 %]
[% target.ordering_agency.billing_address.city %]
[% target.ordering_agency.billing_address.state %]
[% target.ordering_agency.billing_address.country %]
[% target.ordering_agency.billing_address.post_code %]
|
PO# | ISBN or Item # | Title | Quantity | Unit Price | Line Total | Notes |
---|---|---|---|---|---|---|
[% target.id %] | [% isbn || ident %] | [% PROCESS get_li_attr attr_name = 'title' %] | [% count %] | [% price %] | [% litotal %] |
|
Subtotal | [% subtotal %] |
[% IF ent.phone %] Phone: [% ent.phone %]
[% END %]
[% IF ent.fax_phone %] Fax: [% ent.fax_phone %]
[% END %]
[% IF ent.url %] URL: [% ent.url %]
[% END %]
[% IF ent.email %] E-mail: [% ent.email %] [% END %]
[% blob.fund.code %] ([% blob.fund.year %]): | $[% blob.total %] |
---|
Branch | Barcode | Call Number | Fund | Shelving Location | Recd. | Notes |
---|---|---|---|---|---|---|
[% detail.owning_lib.shortname %] | [% IF copy.barcode %] | [% END %][% IF cn_label %][% cn_label %][% END %] | [% IF detail.fund %][% detail.fund.code %] ([% detail.fund.year %])[% END %] | [% copy.location.name %] | [% IF detail.recv_time %][% detail.recv_time %][% END %] | [% detail.note %] |
Title | Author | Shelving Location | Call Number | Barcode/Part | Patron |
---|---|---|---|---|---|
[% copy_data.title | truncate %] | [% copy_data.author | truncate %] | [% hold.current_copy.location.name %] | [% hold.current_copy.call_number.label %] | [% hold.current_copy.barcode %] [% FOR part IN hold.current_copy.parts %] [% part.part.label %] [% END %] | [% hold.usr.card.barcode %] |
Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqbr IN target %] =-=-= Title of work | [% helpers.get_queued_bib_attr('title',vqbr.attributes) %] Author of work | [% helpers.get_queued_bib_attr('author',vqbr.attributes) %] Language of work | [% helpers.get_queued_bib_attr('language',vqbr.attributes) %] Pagination | [% helpers.get_queued_bib_attr('pagination',vqbr.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vqbr.attributes) %] ISSN | [% helpers.get_queued_bib_attr('issn',vqbr.attributes) %] Price | [% helpers.get_queued_bib_attr('price',vqbr.attributes) %] Accession Number | [% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) %] TCN Value | [% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) %] TCN Source | [% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) %] Internal ID | [% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) %] Publisher | [% helpers.get_queued_bib_attr('publisher',vqbr.attributes) %] Publication Date | [% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) %] Edition | [% helpers.get_queued_bib_attr('edition',vqbr.attributes) %] Item Barcode | [% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) %] Import Error | [% vqbr.import_error %] Error Detail | [% vqbr.error_detail %] Match Count | [% vqbr.matches.size %] [% END %]$$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 39, 'attributes') ,( 39, 'queue') ,( 39, 'matches') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 40, TRUE, 1, 'CSV Output for Queued Bib Records', 'vandelay.queued_bib_record.csv', 'NOOP_True', 'ProcessTemplate', 'queue.owner', 'print-on-demand', $$ [%- USE date -%] "Title of work","Author of work","Language of work","Pagination","ISBN","ISSN","Price","Accession Number","TCN Value","TCN Source","Internal ID","Publisher","Publication Date","Edition","Item Barcode","Import Error","Error Detail","Match Count" [% FOR vqbr IN target %]"[% helpers.get_queued_bib_attr('title',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('author',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('language',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('pagination',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('isbn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('issn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('price',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('publisher',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('edition',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) | replace('"', '""') %]","[% vqbr.import_error | replace('"', '""') %]","[% vqbr.error_detail | replace('"', '""') %]","[% vqbr.matches.size %]" [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 40, 'attributes') ,( 40, 'queue') ,( 40, 'matches') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 41, TRUE, 1, 'Email Output for Queued Bib Records', 'vandelay.queued_bib_record.email', 'NOOP_True', 'SendEmail', 'queue.owner', NULL, $$ [%- USE date -%] [%- SET user = target.0.queue.owner -%] To: [%- params.recipient_email || user.email || 'root@localhost' %] From: [%- params.sender_email || default_sender %] Subject: Bibs from Import Queue Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqbr IN target %] =-=-= Title of work | [% helpers.get_queued_bib_attr('title',vqbr.attributes) %] Author of work | [% helpers.get_queued_bib_attr('author',vqbr.attributes) %] Language of work | [% helpers.get_queued_bib_attr('language',vqbr.attributes) %] Pagination | [% helpers.get_queued_bib_attr('pagination',vqbr.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vqbr.attributes) %] ISSN | [% helpers.get_queued_bib_attr('issn',vqbr.attributes) %] Price | [% helpers.get_queued_bib_attr('price',vqbr.attributes) %] Accession Number | [% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) %] TCN Value | [% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) %] TCN Source | [% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) %] Internal ID | [% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) %] Publisher | [% helpers.get_queued_bib_attr('publisher',vqbr.attributes) %] Publication Date | [% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) %] Edition | [% helpers.get_queued_bib_attr('edition',vqbr.attributes) %] Item Barcode | [% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) %] [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 41, 'attributes') ,( 41, 'queue') ,( 41, 'queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 42, TRUE, 1, 'Print Output for Queued Authority Records', 'vandelay.queued_auth_record.print', 'NOOP_True', 'ProcessTemplate', 'queue.owner', 'print-on-demand', $$ [%- USE date -%]
Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqar IN target %] =-=-= Record Identifier | [% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) %] [% END %]$$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 42, 'attributes') ,( 42, 'queue') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 43, TRUE, 1, 'CSV Output for Queued Authority Records', 'vandelay.queued_auth_record.csv', 'NOOP_True', 'ProcessTemplate', 'queue.owner', 'print-on-demand', $$ [%- USE date -%] "Record Identifier" [% FOR vqar IN target %]"[% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) | replace('"', '""') %]" [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 43, 'attributes') ,( 43, 'queue') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 44, TRUE, 1, 'Email Output for Queued Authority Records', 'vandelay.queued_auth_record.email', 'NOOP_True', 'SendEmail', 'queue.owner', NULL, $$ [%- USE date -%] [%- SET user = target.0.queue.owner -%] To: [%- params.recipient_email || user.email || 'root@localhost' %] From: [%- params.sender_email || default_sender %] Subject: Authorities from Import Queue Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqar IN target %] =-=-= Record Identifier | [% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) %] [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 44, 'attributes') ,( 44, 'queue') ,( 44, 'queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 45, TRUE, 1, 'Print Output for Import Items from Queued Bib Records', 'vandelay.import_items.print', 'NOOP_True', 'ProcessTemplate', 'record.queue.owner', 'print-on-demand', $$ [%- USE date -%]
Queue ID: [% target.0.record.queue.id %] Queue Name: [% target.0.record.queue.name %] Queue Type: [% target.0.record.queue.queue_type %] Complete? [% target.0.record.queue.complete %] [% FOR vii IN target %] =-=-= Import Item ID | [% vii.id %] Title of work | [% helpers.get_queued_bib_attr('title',vii.record.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vii.record.attributes) %] Attribute Definition | [% vii.definition %] Import Error | [% vii.import_error %] Import Error Detail | [% vii.error_detail %] Owning Library | [% vii.owning_lib %] Circulating Library | [% vii.circ_lib %] Call Number | [% vii.call_number %] Copy Number | [% vii.copy_number %] Status | [% vii.status.name %] Shelving Location | [% vii.location.name %] Circulate | [% vii.circulate %] Deposit | [% vii.deposit %] Deposit Amount | [% vii.deposit_amount %] Reference | [% vii.ref %] Holdable | [% vii.holdable %] Price | [% vii.price %] Barcode | [% vii.barcode %] Circulation Modifier | [% vii.circ_modifier %] Circulate As MARC Type | [% vii.circ_as_type %] Alert Message | [% vii.alert_message %] Public Note | [% vii.pub_note %] Private Note | [% vii.priv_note %] OPAC Visible | [% vii.opac_visible %] [% END %]$$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 45, 'record') ,( 45, 'record.attributes') ,( 45, 'record.queue') ,( 45, 'record.queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 46, TRUE, 1, 'CSV Output for Import Items from Queued Bib Records', 'vandelay.import_items.csv', 'NOOP_True', 'ProcessTemplate', 'record.queue.owner', 'print-on-demand', $$ [%- USE date -%] "Import Item ID","Title of work","ISBN","Attribute Definition","Import Error","Import Error Detail","Owning Library","Circulating Library","Call Number","Copy Number","Status","Shelving Location","Circulate","Deposit","Deposit Amount","Reference","Holdable","Price","Barcode","Circulation Modifier","Circulate As MARC Type","Alert Message","Public Note","Private Note","OPAC Visible" [% FOR vii IN target %]"[% vii.id | replace('"', '""') %]","[% helpers.get_queued_bib_attr('title',vii.record.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('isbn',vii.record.attributes) | replace('"', '""') %]","[% vii.definition | replace('"', '""') %]","[% vii.import_error | replace('"', '""') %]","[% vii.error_detail | replace('"', '""') %]","[% vii.owning_lib | replace('"', '""') %]","[% vii.circ_lib | replace('"', '""') %]","[% vii.call_number | replace('"', '""') %]","[% vii.copy_number | replace('"', '""') %]","[% vii.status.name | replace('"', '""') %]","[% vii.location.name | replace('"', '""') %]","[% vii.circulate | replace('"', '""') %]","[% vii.deposit | replace('"', '""') %]","[% vii.deposit_amount | replace('"', '""') %]","[% vii.ref | replace('"', '""') %]","[% vii.holdable | replace('"', '""') %]","[% vii.price | replace('"', '""') %]","[% vii.barcode | replace('"', '""') %]","[% vii.circ_modifier | replace('"', '""') %]","[% vii.circ_as_type | replace('"', '""') %]","[% vii.alert_message | replace('"', '""') %]","[% vii.pub_note | replace('"', '""') %]","[% vii.priv_note | replace('"', '""') %]","[% vii.opac_visible | replace('"', '""') %]" [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 46, 'record') ,( 46, 'record.attributes') ,( 46, 'record.queue') ,( 46, 'record.queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 47, TRUE, 1, 'Email Output for Import Items from Queued Bib Records', 'vandelay.import_items.email', 'NOOP_True', 'SendEmail', 'record.queue.owner', NULL, $$ [%- USE date -%] [%- SET user = target.0.record.queue.owner -%] To: [%- params.recipient_email || user.email || 'root@localhost' %] From: [%- params.sender_email || default_sender %] Subject: Import Items from Import Queue Queue ID: [% target.0.record.queue.id %] Queue Name: [% target.0.record.queue.name %] Queue Type: [% target.0.record.queue.queue_type %] Complete? [% target.0.record.queue.complete %] [% FOR vii IN target %] =-=-= Import Item ID | [% vii.id %] Title of work | [% helpers.get_queued_bib_attr('title',vii.record.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vii.record.attributes) %] Attribute Definition | [% vii.definition %] Import Error | [% vii.import_error %] Import Error Detail | [% vii.error_detail %] Owning Library | [% vii.owning_lib %] Circulating Library | [% vii.circ_lib %] Call Number | [% vii.call_number %] Copy Number | [% vii.copy_number %] Status | [% vii.status.name %] Shelving Location | [% vii.location.name %] Circulate | [% vii.circulate %] Deposit | [% vii.deposit %] Deposit Amount | [% vii.deposit_amount %] Reference | [% vii.ref %] Holdable | [% vii.holdable %] Price | [% vii.price %] Barcode | [% vii.barcode %] Circulation Modifier | [% vii.circ_modifier %] Circulate As MARC Type | [% vii.circ_as_type %] Alert Message | [% vii.alert_message %] Public Note | [% vii.pub_note %] Private Note | [% vii.priv_note %] OPAC Visible | [% vii.opac_visible %] [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 47, 'record') ,( 47, 'record.attributes') ,( 47, 'record.queue') ,( 47, 'record.queue.owner') ; INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'container.biblio_record_entry_bucket.csv', 'cbreb', oils_i18n_gettext( 'container.biblio_record_entry_bucket.csv', 'Produce a CSV file representing a bookbag', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.reactor (module, description) VALUES ( 'ContainerCSV', oils_i18n_gettext( 'ContainerCSV', 'Facilitates produce a CSV file representing a bookbag by introducing an "items" variable into the TT environment, sorted as dictated according to user params', 'atr', 'description' ) ); INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, reactor, validator, template ) VALUES ( 48, TRUE, 1, 'Bookbag CSV', 'container.biblio_record_entry_bucket.csv', 'ContainerCSV', 'NOOP_True', $$ [%- # target is the bookbag itself. The 'items' variable does not need to be in # the environment because a special reactor will take care of filling it in. FOR item IN items; bibxml = helpers.unapi_bre(item.target_biblio_record_entry, {flesh => '{mra}'}); title = ""; FOR part IN bibxml.findnodes('//*[@tag="245"]/*[@code="a" or @code="b"]'); title = title _ part.textContent; END; author = bibxml.findnodes('//*[@tag="100"]/*[@code="a"]').textContent; item_type = bibxml.findnodes('//*[local-name()="attributes"]/*[local-name()="field"][@name="item_type"]').getAttribute('coded-value'); pub_date = ""; FOR pdatum IN bibxml.findnodes('//*[@tag="260"]/*[@code="c"]'); IF pub_date ; pub_date = pub_date _ ", " _ pdatum.textContent; ELSE ; pub_date = pdatum.textContent; END; END; helpers.csv_datum(title) %],[% helpers.csv_datum(author) %],[% helpers.csv_datum(pub_date) %],[% helpers.csv_datum(item_type) %],[% FOR note IN item.notes; helpers.csv_datum(note.note); ","; END; "\n"; END -%] $$ ); SELECT SETVAL('authority.control_set_id_seq'::TEXT, 100); SELECT SETVAL('authority.control_set_authority_field_id_seq'::TEXT, 1000); SELECT SETVAL('authority.control_set_bib_field_id_seq'::TEXT, 1000); INSERT INTO authority.control_set (id, name, description) VALUES ( 1, oils_i18n_gettext('1','LoC','acs','name'), oils_i18n_gettext('1','Library of Congress standard authority record control semantics','acs','description') ); -- Entries that need to respect an NFI INSERT INTO authority.control_set_authority_field (id, control_set, main_entry, tag, sf_list, name, nfi) VALUES (4, 1, NULL, '130', 'adfgklmnoprstvxyz', oils_i18n_gettext('4','Heading -- Uniform Title','acsaf','name'), '2'), (24, 1, 4, '530', 'adfgiklmnoprstvwxyz4', oils_i18n_gettext('24','See Also From Tracing -- Uniform Title','acsaf','name'), '2'), (44, 1, 4, '730', 'adfghklmnoprstvwxyz25', oils_i18n_gettext('44','Established Heading Linking Entry -- Uniform Title','acsaf','name'), '2'), (64, 1, 4, '430', 'adfgiklmnoprstvwxyz4', oils_i18n_gettext('64','See Also Tracing -- Uniform Title','acsaf','name'), '2'); INSERT INTO authority.control_set_authority_field (id, control_set, main_entry, tag, sf_list, name) VALUES -- Main entries (1, 1, NULL, '100', 'abcdefklmnopqrstvxyz', oils_i18n_gettext('1','Heading -- Personal Name','acsaf','name')), (2, 1, NULL, '110', 'abcdefgklmnoprstvxyz', oils_i18n_gettext('2','Heading -- Corporate Name','acsaf','name')), (3, 1, NULL, '111', 'acdefgklnpqstvxyz', oils_i18n_gettext('3','Heading -- Meeting Name','acsaf','name')), (5, 1, NULL, '150', 'abvxyz', oils_i18n_gettext('5','Heading -- Topical Term','acsaf','name')), (6, 1, NULL, '151', 'avxyz', oils_i18n_gettext('6','Heading -- Geographic Name','acsaf','name')), (7, 1, NULL, '155', 'avxyz', oils_i18n_gettext('7','Heading -- Genre/Form Term','acsaf','name')), (8, 1, NULL, '180', 'vxyz', oils_i18n_gettext('8','Heading -- General Subdivision','acsaf','name')), (9, 1, NULL, '181', 'vxyz', oils_i18n_gettext('9','Heading -- Geographic Subdivision','acsaf','name')), (10, 1, NULL, '182', 'vxyz', oils_i18n_gettext('10','Heading -- Chronological Subdivision','acsaf','name')), (11, 1, NULL, '185', 'vxyz', oils_i18n_gettext('11','Heading -- Form Subdivision','acsaf','name')), (12, 1, NULL, '148', 'avxyz', oils_i18n_gettext('12','Heading -- Chronological Term','acsaf','name')), -- See Also From tracings (21, 1, 1, '500', 'abcdefiklmnopqrstvwxyz4', oils_i18n_gettext('21','See Also From Tracing -- Personal Name','acsaf','name')), (22, 1, 2, '510', 'abcdefgiklmnoprstvwxyz4', oils_i18n_gettext('22','See Also From Tracing -- Corporate Name','acsaf','name')), (23, 1, 3, '511', 'acdefgiklnpqstvwxyz4', oils_i18n_gettext('23','See Also From Tracing -- Meeting Name','acsaf','name')), (25, 1, 5, '550', 'abivwxyz4', oils_i18n_gettext('25','See Also From Tracing -- Topical Term','acsaf','name')), (26, 1, 6, '551', 'aivwxyz4', oils_i18n_gettext('26','See Also From Tracing -- Geographic Name','acsaf','name')), (27, 1, 7, '555', 'aivwxyz4', oils_i18n_gettext('27','See Also From Tracing -- Genre/Form Term','acsaf','name')), (28, 1, 8, '580', 'ivwxyz4', oils_i18n_gettext('28','See Also From Tracing -- General Subdivision','acsaf','name')), (29, 1, 9, '581', 'ivwxyz4', oils_i18n_gettext('29','See Also From Tracing -- Geographic Subdivision','acsaf','name')), (30, 1, 10, '582', 'ivwxyz4', oils_i18n_gettext('30','See Also From Tracing -- Chronological Subdivision','acsaf','name')), (31, 1, 11, '585', 'ivwxyz4', oils_i18n_gettext('31','See Also From Tracing -- Form Subdivision','acsaf','name')), (32, 1, 12, '548', 'aivwxyz4', oils_i18n_gettext('32','See Also From Tracing -- Chronological Term','acsaf','name')), -- Linking entries (41, 1, 1, '700', 'abcdefghjklmnopqrstvwxyz25', oils_i18n_gettext('41','Established Heading Linking Entry -- Personal Name','acsaf','name')), (42, 1, 2, '710', 'abcdefghklmnoprstvwxyz25', oils_i18n_gettext('42','Established Heading Linking Entry -- Corporate Name','acsaf','name')), (43, 1, 3, '711', 'acdefghklnpqstvwxyz25', oils_i18n_gettext('43','Established Heading Linking Entry -- Meeting Name','acsaf','name')), (45, 1, 5, '750', 'abvwxyz25', oils_i18n_gettext('45','Established Heading Linking Entry -- Topical Term','acsaf','name')), (46, 1, 6, '751', 'avwxyz25', oils_i18n_gettext('46','Established Heading Linking Entry -- Geographic Name','acsaf','name')), (47, 1, 7, '755', 'avwxyz25', oils_i18n_gettext('47','Established Heading Linking Entry -- Genre/Form Term','acsaf','name')), (48, 1, 8, '780', 'vwxyz25', oils_i18n_gettext('48','Subdivision Linking Entry -- General Subdivision','acsaf','name')), (49, 1, 9, '781', 'vwxyz25', oils_i18n_gettext('49','Subdivision Linking Entry -- Geographic Subdivision','acsaf','name')), (50, 1, 10, '782', 'vwxyz25', oils_i18n_gettext('50','Subdivision Linking Entry -- Chronological Subdivision','acsaf','name')), (51, 1, 11, '785', 'vwxyz25', oils_i18n_gettext('51','Subdivision Linking Entry -- Form Subdivision','acsaf','name')), (52, 1, 12, '748', 'avwxyz25', oils_i18n_gettext('52','Established Heading Linking Entry -- Chronological Term','acsaf','name')), -- See From tracings (61, 1, 1, '400', 'abcdefiklmnopqrstvwxyz4', oils_i18n_gettext('61','See Also Tracing -- Personal Name','acsaf','name')), (62, 1, 2, '410', 'abcdefgiklmnoprstvwxyz4', oils_i18n_gettext('62','See Also Tracing -- Corporate Name','acsaf','name')), (63, 1, 3, '411', 'acdefgiklnpqstvwxyz4', oils_i18n_gettext('63','See Also Tracing -- Meeting Name','acsaf','name')), (65, 1, 5, '450', 'abivwxyz4', oils_i18n_gettext('65','See Also Tracing -- Topical Term','acsaf','name')), (66, 1, 6, '451', 'aivwxyz4', oils_i18n_gettext('66','See Also Tracing -- Geographic Name','acsaf','name')), (67, 1, 7, '455', 'aivwxyz4', oils_i18n_gettext('67','See Also Tracing -- Genre/Form Term','acsaf','name')), (68, 1, 8, '480', 'ivwxyz4', oils_i18n_gettext('68','See Also Tracing -- General Subdivision','acsaf','name')), (69, 1, 9, '481', 'ivwxyz4', oils_i18n_gettext('69','See Also Tracing -- Geographic Subdivision','acsaf','name')), (70, 1, 10, '482', 'ivwxyz4', oils_i18n_gettext('70','See Also Tracing -- Chronological Subdivision','acsaf','name')), (71, 1, 11, '485', 'ivwxyz4', oils_i18n_gettext('71','See Also Tracing -- Form Subdivision','acsaf','name')), (72, 1, 12, '448', 'aivwxyz4', oils_i18n_gettext('72','See Also Tracing -- Chronological Term','acsaf','name')); INSERT INTO authority.browse_axis (code,name,description,sorter) VALUES ('title','Title','Title axis','titlesort'), ('author','Author','Author axis','titlesort'), ('subject','Subject','Subject axis','titlesort'), ('topic','Topic','Topic Subject axis','titlesort'); INSERT INTO authority.browse_axis_authority_field_map (axis,field) VALUES ('author', 1 ), ('author', 2 ), ('author', 3 ), ('title', 4 ), ('topic', 5 ), ('subject', 5 ), ('subject', 6 ), ('subject', 7 ), ('subject', 12); INSERT INTO authority.control_set_bib_field (tag, authority_field) SELECT '100', id FROM authority.control_set_authority_field WHERE tag IN ('100') UNION SELECT '600', id FROM authority.control_set_authority_field WHERE tag IN ('100','180','181','182','185') UNION SELECT '700', id FROM authority.control_set_authority_field WHERE tag IN ('100') UNION SELECT '800', id FROM authority.control_set_authority_field WHERE tag IN ('100') UNION SELECT '110', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '610', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '710', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '810', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '111', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '611', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '711', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '811', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '130', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '240', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '630', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '730', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '830', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '648', id FROM authority.control_set_authority_field WHERE tag IN ('148') UNION SELECT '650', id FROM authority.control_set_authority_field WHERE tag IN ('150','180','181','182','185') UNION SELECT '651', id FROM authority.control_set_authority_field WHERE tag IN ('151','180','181','182','185') UNION SELECT '655', id FROM authority.control_set_authority_field WHERE tag IN ('155','180','181','182','185') ; INSERT INTO authority.thesaurus (code, name, control_set) VALUES ('a', oils_i18n_gettext('a','Library of Congress Subject Headings','at','name'), 1), ('b', oils_i18n_gettext('b','LC subject headings for children''s literature','at','name'), 1), ('c', oils_i18n_gettext('c','Medical Subject Headings','at','name'), 1), ('d', oils_i18n_gettext('d','National Agricultural Library subject authority file','at','name'), 1), ('k', oils_i18n_gettext('k','Canadian Subject Headings','at','name'), 1), ('n', oils_i18n_gettext('n','Not applicable','at','name'), 1), ('r', oils_i18n_gettext('r','Art and Architecture Thesaurus','at','name'), 1), ('s', oils_i18n_gettext('s','Sears List of Subject Headings','at','name'), 1), ('v', oils_i18n_gettext('v','Repertoire de vedettes-matiere','at','name'), 1), ('z', oils_i18n_gettext('z','Other','at','name'), 1), ('|', oils_i18n_gettext('|','No attempt to code','at','name'), NULL); INSERT INTO action_trigger.hook ( key, core_type, description, passive ) VALUES ( 'reservation.available', 'bresv', 'A reservation is available for pickup', false ); INSERT INTO action_trigger.validator ( module, description ) VALUES ( 'ReservationIsAvailable', 'Checked that a reserved resource is available for checkout' ); INSERT INTO container.biblio_record_entry_bucket_type (code, label) VALUES ( 'vandelay_queue', oils_i18n_gettext('vandelay_queue', 'Vandelay Queue', 'cbrebt', 'label') ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype,fm_class) VALUES ( 'opac.default_sms_carrier', 'sms', TRUE, oils_i18n_gettext( 'opac.default_sms_carrier', 'Default SMS/Text Carrier', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_sms_carrier', 'Default SMS/Text Carrier', 'cust', 'description' ), 'link', 'csc' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.default_sms_notify', 'sms', TRUE, oils_i18n_gettext( 'opac.default_sms_notify', 'Default SMS/Text Number', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_sms_notify', 'Default SMS/Text Number', 'cust', 'description' ), 'string' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.default_phone', 'opac', TRUE, oils_i18n_gettext( 'opac.default_phone', 'Default Phone Number', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_phone', 'Default Phone Number', 'cust', 'description' ), 'string' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'ui.grid_columns.circ.hold_pull_list', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.circ.hold_pull_list', 'Hold Pull List', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.circ.hold_pull_list', 'Hold Pull List Saved Column Settings', 'cust', 'description' ), 'string' ), ( 'ui.grid_columns.actor.user.event_log', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.actor.user.event_log', 'User Event Log', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.actor.user.event_log', 'User Event Log Saved Column Settings', 'cust', 'description' ), 'string' ) ; SELECT setval( 'config.sms_carrier_id_seq', 1000 ); INSERT INTO config.sms_carrier VALUES -- Testing ( 1, oils_i18n_gettext( 1, 'Local', 'csc', 'region' ), oils_i18n_gettext( 1, 'Test Carrier', 'csc', 'name' ), 'opensrf+$number@localhost', FALSE ), -- Canada & USA ( 2, oils_i18n_gettext( 2, 'Canada & USA', 'csc', 'region' ), oils_i18n_gettext( 2, 'Rogers Wireless', 'csc', 'name' ), '$number@pcs.rogers.com', TRUE ), ( 3, oils_i18n_gettext( 3, 'Canada & USA', 'csc', 'region' ), oils_i18n_gettext( 3, 'Rogers Wireless (Alternate)', 'csc', 'name' ), '1$number@mms.rogers.com', TRUE ), ( 4, oils_i18n_gettext( 4, 'Canada & USA', 'csc', 'region' ), oils_i18n_gettext( 4, 'Telus Mobility', 'csc', 'name' ), '$number@msg.telus.com', TRUE ), -- Canada ( 5, oils_i18n_gettext( 5, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 5, 'Koodo Mobile', 'csc', 'name' ), '$number@msg.telus.com', TRUE ), ( 6, oils_i18n_gettext( 6, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 6, 'Fido', 'csc', 'name' ), '$number@fido.ca', TRUE ), ( 7, oils_i18n_gettext( 7, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 7, 'Bell Mobility & Solo Mobile', 'csc', 'name' ), '$number@txt.bell.ca', TRUE ), ( 8, oils_i18n_gettext( 8, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 8, 'Bell Mobility & Solo Mobile (Alternate)', 'csc', 'name' ), '$number@txt.bellmobility.ca', TRUE ), ( 9, oils_i18n_gettext( 9, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 9, 'Aliant', 'csc', 'name' ), '$number@sms.wirefree.informe.ca', TRUE ), ( 10, oils_i18n_gettext( 10, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 10, 'PC Telecom', 'csc', 'name' ), '$number@mobiletxt.ca', TRUE ), ( 11, oils_i18n_gettext( 11, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 11, 'SaskTel', 'csc', 'name' ), '$number@sms.sasktel.com', TRUE ), ( 12, oils_i18n_gettext( 12, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 12, 'MTS Mobility', 'csc', 'name' ), '$number@text.mtsmobility.com', TRUE ), ( 13, oils_i18n_gettext( 13, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 13, 'Virgin Mobile', 'csc', 'name' ), '$number@vmobile.ca', TRUE ), -- International ( 14, oils_i18n_gettext( 14, 'International', 'csc', 'region' ), oils_i18n_gettext( 14, 'Iridium', 'csc', 'name' ), '$number@msg.iridium.com', TRUE ), ( 15, oils_i18n_gettext( 15, 'International', 'csc', 'region' ), oils_i18n_gettext( 15, 'Globalstar', 'csc', 'name' ), '$number@msg.globalstarusa.com', TRUE ), ( 16, oils_i18n_gettext( 16, 'International', 'csc', 'region' ), oils_i18n_gettext( 16, 'Bulletin.net', 'csc', 'name' ), '$number@bulletinmessenger.net', -- International Formatted number TRUE ), ( 17, oils_i18n_gettext( 17, 'International', 'csc', 'region' ), oils_i18n_gettext( 17, 'Panacea Mobile', 'csc', 'name' ), '$number@api.panaceamobile.com', TRUE ), -- USA ( 18, oils_i18n_gettext( 18, 'USA', 'csc', 'region' ), oils_i18n_gettext( 18, 'C Beyond', 'csc', 'name' ), '$number@cbeyond.sprintpcs.com', TRUE ), ( 19, oils_i18n_gettext( 19, 'Alaska, USA', 'csc', 'region' ), oils_i18n_gettext( 19, 'General Communications, Inc.', 'csc', 'name' ), '$number@mobile.gci.net', TRUE ), ( 20, oils_i18n_gettext( 20, 'California, USA', 'csc', 'region' ), oils_i18n_gettext( 20, 'Golden State Cellular', 'csc', 'name' ), '$number@gscsms.com', TRUE ), ( 21, oils_i18n_gettext( 21, 'Cincinnati, Ohio, USA', 'csc', 'region' ), oils_i18n_gettext( 21, 'Cincinnati Bell', 'csc', 'name' ), '$number@gocbw.com', TRUE ), ( 22, oils_i18n_gettext( 22, 'Hawaii, USA', 'csc', 'region' ), oils_i18n_gettext( 22, 'Hawaiian Telcom Wireless', 'csc', 'name' ), '$number@hawaii.sprintpcs.com', TRUE ), ( 23, oils_i18n_gettext( 23, 'Midwest, USA', 'csc', 'region' ), oils_i18n_gettext( 23, 'i wireless (T-Mobile)', 'csc', 'name' ), '$number.iws@iwspcs.net', TRUE ), ( 24, oils_i18n_gettext( 24, 'USA', 'csc', 'region' ), oils_i18n_gettext( 24, 'i-wireless (Sprint PCS)', 'csc', 'name' ), '$number@iwirelesshometext.com', TRUE ), ( 25, oils_i18n_gettext( 25, 'USA', 'csc', 'region' ), oils_i18n_gettext( 25, 'MetroPCS', 'csc', 'name' ), '$number@mymetropcs.com', TRUE ), ( 26, oils_i18n_gettext( 26, 'USA', 'csc', 'region' ), oils_i18n_gettext( 26, 'Kajeet', 'csc', 'name' ), '$number@mobile.kajeet.net', TRUE ), ( 27, oils_i18n_gettext( 27, 'USA', 'csc', 'region' ), oils_i18n_gettext( 27, 'Element Mobile', 'csc', 'name' ), '$number@SMS.elementmobile.net', TRUE ), ( 28, oils_i18n_gettext( 28, 'USA', 'csc', 'region' ), oils_i18n_gettext( 28, 'Esendex', 'csc', 'name' ), '$number@echoemail.net', TRUE ), ( 29, oils_i18n_gettext( 29, 'USA', 'csc', 'region' ), oils_i18n_gettext( 29, 'Boost Mobile', 'csc', 'name' ), '$number@myboostmobile.com', TRUE ), ( 30, oils_i18n_gettext( 30, 'USA', 'csc', 'region' ), oils_i18n_gettext( 30, 'BellSouth', 'csc', 'name' ), '$number@bellsouth.com', TRUE ), ( 31, oils_i18n_gettext( 31, 'USA', 'csc', 'region' ), oils_i18n_gettext( 31, 'Bluegrass Cellular', 'csc', 'name' ), '$number@sms.bluecell.com', TRUE ), ( 32, oils_i18n_gettext( 32, 'USA', 'csc', 'region' ), oils_i18n_gettext( 32, 'AT&T Enterprise Paging', 'csc', 'name' ), '$number@page.att.net', TRUE ), ( 33, oils_i18n_gettext( 33, 'USA', 'csc', 'region' ), oils_i18n_gettext( 33, 'AT&T Mobility/Wireless', 'csc', 'name' ), '$number@txt.att.net', TRUE ), ( 34, oils_i18n_gettext( 34, 'USA', 'csc', 'region' ), oils_i18n_gettext( 34, 'AT&T Global Smart Messaging Suite', 'csc', 'name' ), '$number@sms.smartmessagingsuite.com', TRUE ), ( 35, oils_i18n_gettext( 35, 'USA', 'csc', 'region' ), oils_i18n_gettext( 35, 'Alltel (Allied Wireless)', 'csc', 'name' ), '$number@sms.alltelwireless.com', TRUE ), ( 36, oils_i18n_gettext( 36, 'USA', 'csc', 'region' ), oils_i18n_gettext( 36, 'Alaska Communications', 'csc', 'name' ), '$number@msg.acsalaska.com', TRUE ), ( 37, oils_i18n_gettext( 37, 'USA', 'csc', 'region' ), oils_i18n_gettext( 37, 'Ameritech', 'csc', 'name' ), '$number@paging.acswireless.com', TRUE ), ( 38, oils_i18n_gettext( 38, 'USA', 'csc', 'region' ), oils_i18n_gettext( 38, 'Cingular (GoPhone prepaid)', 'csc', 'name' ), '$number@cingulartext.com', TRUE ), ( 39, oils_i18n_gettext( 39, 'USA', 'csc', 'region' ), oils_i18n_gettext( 39, 'Cingular (Postpaid)', 'csc', 'name' ), '$number@cingular.com', TRUE ), ( 40, oils_i18n_gettext( 40, 'USA', 'csc', 'region' ), oils_i18n_gettext( 40, 'Cellular One (Dobson) / O2 / Orange', 'csc', 'name' ), '$number@mobile.celloneusa.com', TRUE ), ( 41, oils_i18n_gettext( 41, 'USA', 'csc', 'region' ), oils_i18n_gettext( 41, 'Cellular South', 'csc', 'name' ), '$number@csouth1.com', TRUE ), ( 42, oils_i18n_gettext( 42, 'USA', 'csc', 'region' ), oils_i18n_gettext( 42, 'Cellcom', 'csc', 'name' ), '$number@cellcom.quiktxt.com', TRUE ), ( 43, oils_i18n_gettext( 43, 'USA', 'csc', 'region' ), oils_i18n_gettext( 43, 'Chariton Valley Wireless', 'csc', 'name' ), '$number@sms.cvalley.net', TRUE ), ( 44, oils_i18n_gettext( 44, 'USA', 'csc', 'region' ), oils_i18n_gettext( 44, 'Cricket', 'csc', 'name' ), '$number@sms.mycricket.com', TRUE ), ( 45, oils_i18n_gettext( 45, 'USA', 'csc', 'region' ), oils_i18n_gettext( 45, 'Cleartalk Wireless', 'csc', 'name' ), '$number@sms.cleartalk.us', TRUE ), ( 46, oils_i18n_gettext( 46, 'USA', 'csc', 'region' ), oils_i18n_gettext( 46, 'Edge Wireless', 'csc', 'name' ), '$number@sms.edgewireless.com', TRUE ), ( 47, oils_i18n_gettext( 47, 'USA', 'csc', 'region' ), oils_i18n_gettext( 47, 'Syringa Wireless', 'csc', 'name' ), '$number@rinasms.com', TRUE ), ( 48, oils_i18n_gettext( 48, 'USA', 'csc', 'region' ), oils_i18n_gettext( 48, 'T-Mobile', 'csc', 'name' ), '$number@tmomail.net', TRUE ), ( 49, oils_i18n_gettext( 49, 'USA', 'csc', 'region' ), oils_i18n_gettext( 49, 'Straight Talk / PagePlus Cellular', 'csc', 'name' ), '$number@vtext.com', TRUE ), ( 50, oils_i18n_gettext( 50, 'USA', 'csc', 'region' ), oils_i18n_gettext( 50, 'South Central Communications', 'csc', 'name' ), '$number@rinasms.com', TRUE ), ( 51, oils_i18n_gettext( 51, 'USA', 'csc', 'region' ), oils_i18n_gettext( 51, 'Simple Mobile', 'csc', 'name' ), '$number@smtext.com', TRUE ), ( 52, oils_i18n_gettext( 52, 'USA', 'csc', 'region' ), oils_i18n_gettext( 52, 'Sprint (PCS)', 'csc', 'name' ), '$number@messaging.sprintpcs.com', TRUE ), ( 53, oils_i18n_gettext( 53, 'USA', 'csc', 'region' ), oils_i18n_gettext( 53, 'Nextel', 'csc', 'name' ), '$number@messaging.nextel.com', TRUE ), ( 54, oils_i18n_gettext( 54, 'USA', 'csc', 'region' ), oils_i18n_gettext( 54, 'Pioneer Cellular', 'csc', 'name' ), '$number@zsend.com', -- nine digit number TRUE ), ( 55, oils_i18n_gettext( 55, 'USA', 'csc', 'region' ), oils_i18n_gettext( 55, 'Qwest Wireless', 'csc', 'name' ), '$number@qwestmp.com', TRUE ), ( 56, oils_i18n_gettext( 56, 'USA', 'csc', 'region' ), oils_i18n_gettext( 56, 'US Cellular', 'csc', 'name' ), '$number@email.uscc.net', TRUE ), ( 57, oils_i18n_gettext( 57, 'USA', 'csc', 'region' ), oils_i18n_gettext( 57, 'Unicel', 'csc', 'name' ), '$number@utext.com', TRUE ), ( 58, oils_i18n_gettext( 58, 'USA', 'csc', 'region' ), oils_i18n_gettext( 58, 'Teleflip', 'csc', 'name' ), '$number@teleflip.com', TRUE ), ( 59, oils_i18n_gettext( 59, 'USA', 'csc', 'region' ), oils_i18n_gettext( 59, 'Virgin Mobile', 'csc', 'name' ), '$number@vmobl.com', TRUE ), ( 60, oils_i18n_gettext( 60, 'USA', 'csc', 'region' ), oils_i18n_gettext( 60, 'Verizon Wireless', 'csc', 'name' ), '$number@vtext.com', TRUE ), ( 61, oils_i18n_gettext( 61, 'USA', 'csc', 'region' ), oils_i18n_gettext( 61, 'USA Mobility', 'csc', 'name' ), '$number@usamobility.net', TRUE ), ( 62, oils_i18n_gettext( 62, 'USA', 'csc', 'region' ), oils_i18n_gettext( 62, 'Viaero', 'csc', 'name' ), '$number@viaerosms.com', TRUE ), ( 63, oils_i18n_gettext( 63, 'USA', 'csc', 'region' ), oils_i18n_gettext( 63, 'TracFone', 'csc', 'name' ), '$number@mmst5.tracfone.com', TRUE ), ( 64, oils_i18n_gettext( 64, 'USA', 'csc', 'region' ), oils_i18n_gettext( 64, 'Centennial Wireless', 'csc', 'name' ), '$number@cwemail.com', TRUE ), -- South Korea and USA ( 65, oils_i18n_gettext( 65, 'South Korea and USA', 'csc', 'region' ), oils_i18n_gettext( 65, 'Helio', 'csc', 'name' ), '$number@myhelio.com', TRUE ) ; INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) SELECT pgt.id, perm.id, aout.depth, TRUE FROM permission.grp_tree pgt, permission.perm_list perm, actor.org_unit_type aout WHERE pgt.name = 'Global Administrator' AND aout.name = 'Consortium' AND perm.code = 'ADMIN_SMS_CARRIER'; INSERT INTO action_trigger.reactor ( module, description ) VALUES ( 'SendSMS', 'Send an SMS text message based on a user-defined template' ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, cleanup_success, delay, delay_field, group_field, template ) VALUES ( true, 1, -- admin 'Hold Ready for Pickup SMS Notification', 'hold.available', 'HoldIsAvailable', 'SendSMS', 'CreateHoldNotification', '00:30:00', 'shelf_time', 'sms_notify', '[%- USE date -%] [%- user = target.0.usr -%] From: [%- params.sender_email || default_sender %] To: [%- params.recipient_email || helpers.get_sms_gateway_email(target.0.sms_carrier,target.0.sms_notify) %] Subject: [% target.size %] hold(s) ready [% FOR hold IN target %][%- bibxml = helpers.xml_doc( hold.current_copy.call_number.record.marc ); title = ""; FOR part IN bibxml.findnodes(''//*[@tag="245"]/*[@code="a"]''); title = title _ part.textContent; END; author = bibxml.findnodes(''//*[@tag="100"]/*[@code="a"]'').textContent; %][% hold.usr.first_given_name %]:[% title %] @ [% hold.pickup_lib.name %] [% END %] ' ); INSERT INTO action_trigger.environment ( event_def, path ) VALUES ( currval('action_trigger.event_definition_id_seq'), 'current_copy.call_number.record.simple_record' ), ( currval('action_trigger.event_definition_id_seq'), 'usr' ), ( currval('action_trigger.event_definition_id_seq'), 'pickup_lib.billing_address' ); INSERT INTO action_trigger.event_params (event_def, param, value) VALUES (currval('action_trigger.event_definition_id_seq'), 'check_sms_notify', 1); INSERT INTO action_trigger.hook( key, core_type, description, passive ) VALUES ( 'acn.format.sms_text', 'acn', oils_i18n_gettext( 'acn.format.sms_text', 'A text message has been requested for a call number.', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, template ) VALUES ( true, 1, -- admin 'SMS Call Number', 'acn.format.sms_text', 'NOOP_True', 'SendSMS', '[%- USE date -%] From: [%- params.sender_email || default_sender %] To: [%- params.recipient_email || helpers.get_sms_gateway_email(user_data.sms_carrier,user_data.sms_notify) %] Subject: Call Number [%- bibxml = helpers.xml_doc( target.record.marc ); title = ""; FOR part IN bibxml.findnodes(''//*[@tag="245"]/*[@code="a" or @code="b"]''); title = title _ part.textContent; END; author = bibxml.findnodes(''//*[@tag="100"]/*[@code="a"]'').textContent; %] Call Number: [% target.label %] Location: [% helpers.get_most_populous_location( target.id ).name %] Library: [% target.owning_lib.name %] [%- IF title %] Title: [% title %] [%- END %] [%- IF author %] Author: [% author %] [%- END %] ' ); INSERT INTO action_trigger.environment ( event_def, path ) VALUES ( currval('action_trigger.event_definition_id_seq'), 'record.simple_record' ), ( currval('action_trigger.event_definition_id_seq'), 'owning_lib.billing_address' ); INSERT INTO vandelay.merge_profile (owner, name, replace_spec) VALUES (1, 'Match-Only Merge', '901c'); INSERT INTO vandelay.merge_profile (owner, name, preserve_spec) VALUES (1, 'Full Overlay', '901c'); -- user activity seed data -- INSERT INTO config.usr_activity_type (id, ewho, ewhat, ehow, egroup, label) VALUES -- authen/authz actions -- note: "opensrf" is the default ingress/ehow (1, NULL, 'login', 'opensrf', 'authen', oils_i18n_gettext(1 , 'Login via opensrf', 'cuat', 'label')) ,(2, NULL, 'login', 'srfsh', 'authen', oils_i18n_gettext(2 , 'Login via srfsh', 'cuat', 'label')) ,(3, NULL, 'login', 'gateway-v1', 'authen', oils_i18n_gettext(3 , 'Login via gateway-v1', 'cuat', 'label')) ,(4, NULL, 'login', 'translator-v1','authen', oils_i18n_gettext(4 , 'Login via translator-v1', 'cuat', 'label')) ,(5, NULL, 'login', 'xmlrpc', 'authen', oils_i18n_gettext(5 , 'Login via xmlrpc', 'cuat', 'label')) ,(6, NULL, 'login', 'remoteauth', 'authen', oils_i18n_gettext(6 , 'Login via remoteauth', 'cuat', 'label')) ,(7, NULL, 'login', 'sip2', 'authen', oils_i18n_gettext(7 , 'SIP2 Proxy Login', 'cuat', 'label')) ,(8, NULL, 'login', 'apache', 'authen', oils_i18n_gettext(8 , 'Login via Apache module', 'cuat', 'label')) ,(9, NULL, 'verify', 'opensrf', 'authz', oils_i18n_gettext(9 , 'Verification via opensrf', 'cuat', 'label')) ,(10, NULL, 'verify', 'srfsh', 'authz', oils_i18n_gettext(10, 'Verification via srfsh', 'cuat', 'label')) ,(11, NULL, 'verify', 'gateway-v1', 'authz', oils_i18n_gettext(11, 'Verification via gateway-v1', 'cuat', 'label')) ,(12, NULL, 'verify', 'translator-v1','authz', oils_i18n_gettext(12, 'Verification via translator-v1', 'cuat', 'label')) ,(13, NULL, 'verify', 'xmlrpc', 'authz', oils_i18n_gettext(13, 'Verification via xmlrpc', 'cuat', 'label')) ,(14, NULL, 'verify', 'remoteauth', 'authz', oils_i18n_gettext(14, 'Verification via remoteauth', 'cuat', 'label')) ,(15, NULL, 'verify', 'sip2', 'authz', oils_i18n_gettext(15, 'SIP2 User Verification', 'cuat', 'label')) -- authen/authz actions w/ known uses of "who" ,(16, 'opac', 'login', 'gateway-v1', 'authen', oils_i18n_gettext(16, 'OPAC Login (jspac)', 'cuat', 'label')) ,(17, 'opac', 'login', 'apache', 'authen', oils_i18n_gettext(17, 'OPAC Login (tpac)', 'cuat', 'label')) ,(18, 'staffclient', 'login', 'gateway-v1', 'authen', oils_i18n_gettext(18, 'Staff Client Login', 'cuat', 'label')) ,(19, 'selfcheck', 'login', 'translator-v1','authen', oils_i18n_gettext(19, 'Self-Check Proxy Login', 'cuat', 'label')) ,(20, 'ums', 'login', 'xmlrpc', 'authen', oils_i18n_gettext(20, 'Unique Mgt Login', 'cuat', 'label')) ,(21, 'authproxy', 'login', 'apache', 'authen', oils_i18n_gettext(21, 'Apache Auth Proxy Login', 'cuat', 'label')) ,(22, 'libraryelf', 'login', 'xmlrpc', 'authz', oils_i18n_gettext(22, 'LibraryElf Login', 'cuat', 'label')) ,(23, 'selfcheck', 'verify', 'translator-v1','authz', oils_i18n_gettext(23, 'Self-Check User Verification', 'cuat', 'label')) ,(24, 'ezproxy', 'verify', 'remoteauth', 'authz', oils_i18n_gettext(24, 'EZProxy Verification', 'cuat', 'label')) -- ... ; -- reserve the first 1000 slots SELECT SETVAL('config.usr_activity_type_id_seq'::TEXT, 1000); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'circ.fines.charge_when_closed', oils_i18n_gettext( 'circ.fines.charge_when_closed', 'Charge fines on overdue circulations when closed', 'coust', 'label' ), oils_i18n_gettext( 'circ.fines.charge_when_closed', 'Normally, fines are not charged when a library is closed. When set to True, fines will be charged during scheduled closings and normal weekly closed days.', 'coust', 'description' ), 'circ', 'bool' ); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'circ.patron.usr_activity_retrieve.max', oils_i18n_gettext( 'circ.patron.usr_activity_retrieve.max', 'Max user activity entries to retrieve (staff client)', 'coust', 'label' ), oils_i18n_gettext( 'circ.patron.usr_activity_retrieve.max', 'Sets the maxinum number of recent user activity entries to retrieve for display in the staff client. 0 means show none, -1 means show all. Default is 1.', 'coust', 'description' ), 'gui', 'integer' ); -- circ export csv export -- INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'circ.format.history.csv', 'circ', oils_i18n_gettext( 'circ.format.history.csv', 'Produce CSV of circulation history', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, reactor, validator, group_field, template) VALUES ( TRUE, 1, 'Circ History CSV', 'circ.format.history.csv', 'ProcessTemplate', 'NOOP_True', 'usr', $$ Title,Author,Call Number,Barcode,Format [%- FOR circ IN target; bibxml = helpers.unapi_bre(circ.target_copy.call_number.record, {flesh => '{mra}'}); title = ""; FOR part IN bibxml.findnodes('//*[@tag="245"]/*[@code="a" or @code="b"]'); title = title _ part.textContent; END; author = bibxml.findnodes('//*[@tag="100"]/*[@code="a"]').textContent; item_type = bibxml.findnodes('//*[local-name()="attributes"]/*[local-name()="field"][@name="item_type"]').getAttribute('coded-value') %] [%- helpers.csv_datum(title) -%], [%- helpers.csv_datum(author) -%], [%- helpers.csv_datum(circ.target_copy.call_number.label) -%], [%- helpers.csv_datum(circ.target_copy.barcode) -%], [%- helpers.csv_datum(item_type) %] [%- END -%] $$ ); INSERT INTO action_trigger.environment (event_def, path) VALUES ( currval('action_trigger.event_definition_id_seq'), 'target_copy.call_number' ); INSERT INTO actor.toolbar(org,label,layout) VALUES ( 1, 'circ', '["circ_checkout","circ_checkin","toolbarseparator.1","search_opac","copy_status","toolbarseparator.2","patron_search","patron_register","toolbarspacer.3","hotkeys_toggle"]' ), ( 1, 'cat', '["circ_checkin","toolbarseparator.1","search_opac","copy_status","toolbarseparator.2","create_marc","authority_manage","retrieve_last_record","toolbarspacer.3","hotkeys_toggle"]' ); INSERT INTO config.global_flag (name, enabled, label) VALUES ( 'opac.org_unit.non_inherited_visibility', FALSE, oils_i18n_gettext( 'opac.org_unit.non_inherited_visibility', 'Org Units Do Not Inherit Visibility', 'cgf', 'label' ) ); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, grp, update_perm ) VALUES ( 'ui.hide_copy_editor_fields', oils_i18n_gettext( 'ui.hide_copy_editor_fields', 'GUI: Hide these fields within the Item Attribute Editor', 'coust', 'label' ), oils_i18n_gettext( 'ui.hide_copy_editor_fields', 'This setting may be best maintained with the dedicated configuration' || ' interface within the Item Attribute Editor. However, here it' || ' shows up as comma separated list of field identifiers to hide.', 'coust', 'description' ), 'array', 'gui', 539 ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'opac.patron.auto_overide_hold_events', 'opac', oils_i18n_gettext( 'opac.patron.auto_overide_hold_events', 'Auto-Override Permitted Hold Blocks (Patrons)', 'coust', 'label' ), oils_i18n_gettext( 'opac.patron.auto_overide_hold_events', 'When a patron places a hold that fails and the patron has the correct permission ' || 'to override the hold, automatically override the hold without presenting a message ' || 'to the patron and requiring that the patron make a decision to override', 'coust', 'description' ), 'bool' ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'opac.patron.temporary_list_warn', 'opac', oils_i18n_gettext( 'opac.patron.temporary_list_warn', 'Warn patrons when adding to a temporary book list', 'coust', 'label' ), oils_i18n_gettext( 'opac.patron.temporary_list_warn', 'Present a warning dialog to the patron when a patron adds a book to a temporary book bag.', 'coust', 'description' ), 'bool' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.temporary_list_no_warn', 'opac', TRUE, oils_i18n_gettext( 'opac.temporary_list_no_warn', 'Opt out of warning when adding a book to a temporary book list', 'cust', 'label' ), oils_i18n_gettext( 'opac.temporary_list_no_warn', 'Opt out of warning when adding a book to a temporary book list', 'cust', 'description' ), 'bool' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.default_list', 'opac', FALSE, oils_i18n_gettext( 'opac.default_list', 'Default list to use when adding to a bookbag', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_list', 'Default list to use when adding to a bookbag', 'cust', 'description' ), 'integer' ); INSERT INTO config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES ( 'circ.staff.max_visible_event_age', 'circ', 'Maximum visible age of User Trigger Events in Staff Interfaces', 'If this is unset, staff can view User Trigger Events regardless of age. When this is set to an interval, it represents the age of the oldest possible User Trigger Event that can be viewed.', 'interval' ); -- kid's opac main search filter INSERT INTO actor.search_filter_group (owner, code, label) VALUES (1, 'kpac_main', 'Kid''s OPAC Search Filter'); INSERT INTO actor.search_query (label, query_text) VALUES ('Children''s Materials', 'audience(a,b,c)'); INSERT INTO actor.search_query (label, query_text) VALUES ('Young Adult Materials', 'audience(j,d)'); INSERT INTO actor.search_query (label, query_text) VALUES ('General/Adult Materials', 'audience(e,f,g, )'); INSERT INTO actor.search_filter_group_entry (grp, query, pos) VALUES ( (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), (SELECT id FROM actor.search_query WHERE label = 'Children''s Materials'), 0 ); INSERT INTO actor.search_filter_group_entry (grp, query, pos) VALUES ( (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), (SELECT id FROM actor.search_query WHERE label = 'Young Adult Materials'), 1 ); INSERT INTO actor.search_filter_group_entry (grp, query, pos) VALUES ( (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), (SELECT id FROM actor.search_query WHERE label = 'General/Adult Materials'), 2 ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'acq.fund.allow_rollover_without_money', 'acq', oils_i18n_gettext( 'acq.fund.allow_rollover_without_money', 'Allow funds to be rolled over without bringing the money along', 'coust', 'label' ), oils_i18n_gettext( 'acq.fund.allow_rollover_without_money', 'Allow funds to be rolled over without bringing the money along. This makes money left in the old fund disappear, modeling its return to some outside entity.', 'coust', 'description' ), 'bool' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'circ.lost.xact_open_on_zero', 'finance', oils_i18n_gettext( 'circ.lost.xact_open_on_zero', 'Leave transaction open when lost balance equals zero', 'coust', 'label' ), oils_i18n_gettext( 'circ.lost.xact_open_on_zero', 'Leave transaction open when lost balance equals zero. This leaves the lost copy on the patron record when it is paid', 'coust', 'description' ), 'bool' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'circ.patron_expires_soon_warning', 'circ', oils_i18n_gettext( 'circ.patron_expires_soon_warning', 'Warn when patron account is about to expire', 'coust', 'label' ), oils_i18n_gettext( 'circ.patron_expires_soon_warning', 'Warn when patron account is about to expire. If set, the staff client displays a warning this many days before the expiry of a patron account. Value is in number of days, for example: 3 for 3 days.', 'coust', 'description' ), 'integer' ); INSERT INTO config.settings_group (name, label) VALUES ( 'url_verify', oils_i18n_gettext( 'url_verify', 'URL Verify', 'csg', 'label' ) ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.url_verification_delay', 'url_verify', oils_i18n_gettext( 'url_verify.url_verification_delay', 'Number of seconds to wait between URL test attempts.', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.url_verification_delay', 'Throttling mechanism for batch URL verification runs. Each running process will wait this number of seconds after a URL test before performing the next.', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.url_verification_max_redirects', 'url_verify', oils_i18n_gettext( 'url_verify.url_verification_max_redirects', 'Maximum redirect lookups', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.url_verification_max_redirects', 'For URLs returning 3XX redirects, this is the maximum number of redirects we will follow before giving up.', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.url_verification_max_wait', 'url_verify', oils_i18n_gettext( 'url_verify.url_verification_max_wait', 'Maximum wait time (in seconds) for a URL to lookup', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.url_verification_max_wait', 'If we exceed the wait time, the URL is marked as a "timeout" and the system moves on to the next URL', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.filter_dialog_interface (key, description) VALUES ( 'url_verify', oils_i18n_gettext( 'url_verify', 'All Link Checker filter dialogs', 'cfdi', 'description' ) ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'ui.grid_columns.url_verify.select_urls', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.url_verify.select_urls', 'Link Checker''s URL Selection interface''s saved columns', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.url_verify.select_urls', 'Link Checker''s URL Selection interface''s saved columns', 'cust', 'description' ), 'string' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'ui.grid_columns.url_verify.review_attempt', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.url_verify.review_attempt', 'Link Checker''s Review Attempt interface''s saved columns', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.url_verify.review_attempt', 'Link Checker''s Review Attempt interface''s saved columns', 'cust', 'description' ), 'string' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.verification_batch_size', 'url_verify', oils_i18n_gettext( 'url_verify.verification_batch_size', 'Number of URLs to test in parallel', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.verification_batch_size', 'URLs are tested in batches. This number defines the size of each batch and it directly relates to the number of back-end processes performing URL verification.', 'coust', 'description' ), '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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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', 'Upload 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 ); INSERT INTO config.ts_config_list(id, name) VALUES ('simple','Non-Stemmed Simple'), ('danish_nostop','Danish Stemmed'), ('dutch_nostop','Dutch Stemmed'), ('english_nostop','English Stemmed'), ('finnish_nostop','Finnish Stemmed'), ('french_nostop','French Stemmed'), ('german_nostop','German Stemmed'), ('hungarian_nostop','Hungarian Stemmed'), ('italian_nostop','Italian Stemmed'), ('norwegian_nostop','Norwegian Stemmed'), ('portuguese_nostop','Portuguese Stemmed'), ('romanian_nostop','Romanian Stemmed'), ('russian_nostop','Russian Stemmed'), ('spanish_nostop','Spanish Stemmed'), ('swedish_nostop','Swedish Stemmed'), ('turkish_nostop','Turkish Stemmed'); INSERT INTO config.metabib_class_ts_map(field_class, ts_config, index_weight, always) VALUES ('keyword','simple','A',true), ('keyword','english_nostop','C',true), ('title','simple','A',true), ('title','english_nostop','C',true), ('author','simple','A',true), ('author','english_nostop','C',true), ('series','simple','A',true), ('series','english_nostop','C',true), ('subject','simple','A',true), ('subject','english_nostop','C',true), ('identifier','simple','A',true); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, fm_class, update_perm, grp ) VALUES ( 'circ.hold_capture_order', oils_i18n_gettext( 'circ.hold_capture_order', 'Best-hold selection sort order', 'coust', 'label' ), oils_i18n_gettext( 'circ.hold_capture_order', 'Defines the sort order of holds when selecting a hold to fill using a given copy at capture time', 'coust', 'description' ), 'link', 'cbho', 543, 'holds' ); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, update_perm, grp ) VALUES ( 'circ.hold_go_home_interval', oils_i18n_gettext( 'circ.hold_go_home_interval', 'Max foreign-circulation time', 'coust', 'label' ), oils_i18n_gettext( 'circ.hold_go_home_interval', 'Time a copy can spend circulating away from its circ lib before returning there to fill a hold (if one exists there)', 'coust', 'description' ), 'interval', 543, 'holds' ); INSERT INTO config.best_hold_order ( name, pprox, aprox, priority, cut, depth, rtime, htime, hprox ) VALUES ( 'Traditional', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, hprox, pprox, aprox, priority, cut, depth, rtime, htime ) VALUES ( 'Traditional with Holds-always-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, htime, hprox, pprox, aprox, priority, cut, depth, rtime ) VALUES ( 'Traditional with Holds-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, priority, cut, rtime, depth, pprox, hprox, aprox, htime ) VALUES ( 'FIFO', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, hprox, priority, cut, rtime, depth, pprox, aprox, htime ) VALUES ( 'FIFO with Holds-always-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, htime, priority, cut, rtime, depth, pprox, aprox, hprox ) VALUES ( 'FIFO with Holds-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO actor.org_unit_setting ( org_unit, name, value ) VALUES ( (SELECT id FROM actor.org_unit WHERE parent_ou IS NULL), 'circ.hold_go_home_interval', '"6 months"' );