View | Details | Raw Unified | Return to bug 41800
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_41800.pl (+56 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "41800",
6
    description => "Fix more syspref discrepancies",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        # from updatedatabase.pl 20.12.00.009
12
        # UseICUStyleQUotes vs UseICUStyleQuotes
13
        $dbh->do(
14
            q{
15
                UPDATE systempreferences
16
                SET variable="UseICUStyleQuotes"
17
                WHERE BINARY variable="UseICUStyleQUotes"
18
            }
19
        );
20
21
        # from db_revs/211200012.pl
22
        # Syspref was not deleted if no value set
23
        $dbh->do(
24
            q{
25
            DELETE FROM systempreferences WHERE variable='OpacMoreSearches'
26
        }
27
        );
28
29
        # from db_revs/211200020.pl
30
        # Syspref was not deleted if no value set
31
        $dbh->do(
32
            q{
33
            DELETE FROM systempreferences WHERE variable='OPACMySummaryNote'
34
        }
35
        );
36
37
        $dbh->do(
38
            q{
39
                UPDATE systempreferences
40
                SET explanation = REPLACE(explanation, 'If ON, ', 'If enabled, ')
41
            }
42
        );
43
        my $new_explanations = {};
44
        for my $variable ( sort { lc($a) cmp lc($b) } keys %$new_explanations ) {
45
            my $explanation = $new_explanations->{$variable};
46
            $dbh->do(
47
                q{
48
                    UPDATE systempreferences
49
                    SET explanation=?
50
                    WHERE variable=?
51
                }, undef, $explanation, $variable
52
            );
53
        }
54
55
    },
56
};
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-99 / +98 lines)
Lines 7-25 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
7
('AcqItemSetSubfieldsWhenReceiptIsCancelled','', NULL,'Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a="bar foo")', 'Free'),
7
('AcqItemSetSubfieldsWhenReceiptIsCancelled','', NULL,'Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a="bar foo")', 'Free'),
8
('AcqItemSetSubfieldsWhenReceived','',NULL,'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),
8
('AcqItemSetSubfieldsWhenReceived','',NULL,'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),
9
('AcquisitionDetails', '1', NULL, 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
9
('AcquisitionDetails', '1', NULL, 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
10
('AcquisitionLog','0',NULL,'If ON, log acquisitions activity','YesNo'),
10
('AcquisitionLog','0',NULL,'If enabled, log acquisitions activity','YesNo'),
11
('AcquisitionsDefaultEmailAddress', '', NULL, 'Default email address that acquisition notices are sent from', 'Free'),
11
('AcquisitionsDefaultEmailAddress', '', NULL, 'Default email address that acquisition notices are sent from', 'Free'),
12
('AcquisitionsDefaultReplyTo', '', NULL, 'Default email address used as reply-to for notices sent by the acquisitions module.', 'Free'),
12
('AcquisitionsDefaultReplyTo', '', NULL, 'Default email address used as reply-to for notices sent by the acquisitions module.', 'Free'),
13
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: their own only, any within their branch, or all','Choice'),
13
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: their own only, any within their branch, or all','Choice'),
14
('AcqWarnOnDuplicateInvoice','0',NULL,'Warn librarians when they try to create a duplicate invoice','YesNo'),
14
('AcqWarnOnDuplicateInvoice','0',NULL,'Warn librarians when they try to create a duplicate invoice','YesNo'),
15
('ActionLogsTraceDepth', '0', NULL, 'Sets the maximum depth of the action logs stack trace', 'Integer'),
15
('ActionLogsTraceDepth', '0', NULL, 'Sets the maximum depth of the action logs stack trace', 'Integer'),
16
('AdditionalContentLog','0',NULL,'If ON, log OPAC news changes','YesNo'),
16
('AdditionalContentLog','0',NULL,'If enabled, log OPAC news changes','YesNo'),
17
('AdditionalContentsEditor','tinymce','tinymce|codemirror','Choose tool for editing News.', 'Choice'),
17
('AdditionalContentsEditor','tinymce','tinymce|codemirror','Choose tool for editing News.', 'Choice'),
18
('AdditionalFieldsInZ3950ResultAuthSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of an authority Z39.50 search', 'Free'),
18
('AdditionalFieldsInZ3950ResultAuthSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of an authority Z39.50 search', 'Free'),
19
('AdditionalFieldsInZ3950ResultSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950', 'Free'),
19
('AdditionalFieldsInZ3950ResultSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950', 'Free'),
20
('AddressForFailedOverdueNotices', '', NULL, 'Destination email for failed overdue notices. If left empty then it will fallback to the first defined address in the following list: Library ReplyTo, Library Email, ReplytoDefault and KohaAdminEmailAddress', 'Free'),
20
('AddressForFailedOverdueNotices', '', NULL, 'Destination email for failed overdue notices. If left empty then it will fallback to the first defined address in the following list: Library ReplyTo, Library Email, ReplytoDefault and KohaAdminEmailAddress', 'Free'),
21
('AddressFormat','us','us|de|fr','Choose format to display postal addresses', 'Choice'),
21
('AddressFormat','us','us|de|fr','Choose format to display postal addresses', 'Choice'),
22
('advancedMARCeditor','0',NULL,'If ON, the MARC editor won\'t display field/subfield descriptions','YesNo'),
22
('advancedMARCeditor','0',NULL,'If enabled, the MARC editor won\'t display field/subfield descriptions','YesNo'),
23
('AdvancedSearchLanguages','',NULL,'ISO 639-2 codes of languages you wish to see appear as an Advanced search option. Example: eng|fre|ita','Textarea'),
23
('AdvancedSearchLanguages','',NULL,'ISO 639-2 codes of languages you wish to see appear as an Advanced search option. Example: eng|fre|ita','Textarea'),
24
('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'),
24
('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'),
25
('AgeRestrictionMarker','',NULL,'Markers for age restriction indication, e.g. FSK|PEGI|Age|','Free'),
25
('AgeRestrictionMarker','',NULL,'Markers for age restriction indication, e.g. FSK|PEGI|Age|','Free'),
Lines 40-55 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
40
('AllowItemsOnLoanCheckoutSIP','0',NULL,'Do not generate ISSUED_TO_ANOTHER warning when checking out items already checked out to someone else via SIP. This allows self checkouts for those items.','YesNo'),
40
('AllowItemsOnLoanCheckoutSIP','0',NULL,'Do not generate ISSUED_TO_ANOTHER warning when checking out items already checked out to someone else via SIP. This allows self checkouts for those items.','YesNo'),
41
('AllowMultipleCovers','0',NULL,'Allow multiple cover images to be attached to each bibliographic record.','YesNo'),
41
('AllowMultipleCovers','0',NULL,'Allow multiple cover images to be attached to each bibliographic record.','YesNo'),
42
('AllowMultipleIssuesOnABiblio','1',NULL,'Allow/Don\'t allow patrons to check out multiple items from one biblio','YesNo'),
42
('AllowMultipleIssuesOnABiblio','1',NULL,'Allow/Don\'t allow patrons to check out multiple items from one biblio','YesNo'),
43
('AllowNotForLoanOverride','0',NULL,'If ON, Koha will allow the librarian to loan a not for loan item.','YesNo'),
43
('AllowNotForLoanOverride','0',NULL,'If enabled, Koha will allow the librarian to loan a not for loan item.','YesNo'),
44
('AllowPatronToControlAutorenewal','0',NULL,'If enabled, patrons will have a field in their account to choose whether their checkouts are auto renewed or not','YesNo'),
44
('AllowPatronToControlAutorenewal','0',NULL,'If enabled, patrons will have a field in their account to choose whether their checkouts are auto renewed or not','YesNo'),
45
('AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set checkouts to be visible to their guarantor', 'YesNo'),
45
('AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set checkouts to be visible to their guarantor', 'YesNo'),
46
('AllowPatronToSetFinesVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set fines to be visible to their guarantor', 'YesNo'),
46
('AllowPatronToSetFinesVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set fines to be visible to their guarantor', 'YesNo'),
47
('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'),
47
('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'),
48
('AllowRenewalIfOtherItemsAvailable','0',NULL,'If enabled, allow a patron to renew an item with unfilled holds if other available items can fill that hold.','YesNo'),
48
('AllowRenewalIfOtherItemsAvailable','0',NULL,'If enabled, allow a patron to renew an item with unfilled holds if other available items can fill that hold.','YesNo'),
49
('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'),
49
('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'),
50
('AllowRenewalOnHoldOverride','0',NULL,'If ON, allow items on hold to be renewed with a specified due date','YesNo'),
50
('AllowRenewalOnHoldOverride','0',NULL,'If enabled, allow items on hold to be renewed with a specified due date','YesNo'),
51
('AllowReturnToBranch','anywhere','anywhere|homebranch|holdingbranch|homeorholdingbranch','Where an item may be returned','Choice'),
51
('AllowReturnToBranch','anywhere','anywhere|homebranch|holdingbranch|homeorholdingbranch','Where an item may be returned','Choice'),
52
('AllowSetAutomaticRenewal','1',NULL,'If ON, allows staff to flag items for automatic renewal on the check out page','YesNo'),
52
('AllowSetAutomaticRenewal','1',NULL,'If enabled, allows staff to flag items for automatic renewal on the check out page','YesNo'),
53
('AllowStaffToSetCheckoutsVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s checkouts to be visible to linked patrons from the opac.','YesNo'),
53
('AllowStaffToSetCheckoutsVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s checkouts to be visible to linked patrons from the opac.','YesNo'),
54
('AllowStaffToSetFinesVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s fines to be visible to linked patrons from the opac.', 'YesNo'),
54
('AllowStaffToSetFinesVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s fines to be visible to linked patrons from the opac.', 'YesNo'),
55
('AllowTooManyOverride','1',NULL,'If on, allow staff to override and check out items when the patron has reached the maximum number of allowed checkouts','YesNo'),
55
('AllowTooManyOverride','1',NULL,'If on, allow staff to override and check out items when the patron has reached the maximum number of allowed checkouts','YesNo'),
Lines 75-81 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
75
('AudioAlerts','0',NULL,'Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
75
('AudioAlerts','0',NULL,'Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
76
('AuthDisplayHierarchy','0',NULL,'Display authority hierarchies','YesNo'),
76
('AuthDisplayHierarchy','0',NULL,'Display authority hierarchies','YesNo'),
77
('AuthFailureLog','0',NULL,'If enabled, log authentication failures','YesNo'),
77
('AuthFailureLog','0',NULL,'If enabled, log authentication failures','YesNo'),
78
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
78
('AuthoritiesLog','1',NULL,'If enabled, log edit/create/delete actions on authorities.','YesNo'),
79
('AuthorityControlledIndicators','# PERSO_NAME  100 600 696 700 796 800 896\nmarc21, 100, ind1:auth1\nmarc21, 600, ind1:auth1, ind2:thesaurus\nmarc21, 696, ind1:auth1\nmarc21, 700, ind1:auth1\nmarc21, 796, ind1:auth1\nmarc21, 800, ind1:auth1\nmarc21, 896, ind1:auth1\n# CORPO_NAME  110 610 697 710 797 810 897\nmarc21, 110, ind1:auth1\nmarc21, 610, ind1:auth1, ind2:thesaurus\nmarc21, 697, ind1:auth1\nmarc21, 710, ind1:auth1\nmarc21, 797, ind1:auth1\nmarc21, 810, ind1:auth1\nmarc21, 897, ind1:auth1\n# MEETI_NAME    111 611 698 711 798 811 898\nmarc21, 111, ind1:auth1\nmarc21, 611, ind1:auth1, ind2:thesaurus\nmarc21, 698, ind1:auth1\nmarc21, 711, ind1:auth1\nmarc21, 798, ind1:auth1\nmarc21, 811, ind1:auth1\nmarc21, 898, ind1:auth1\n# UNIF_TITLE        130 440 630 699 730 799 830 899\nmarc21, 130, ind1:auth2\nmarc21, 240, , ind2:auth2\nmarc21, 440, , ind2:auth2\nmarc21, 630, ind1:auth2, ind2:thesaurus\nmarc21, 699, ind1:auth2\nmarc21, 730, ind1:auth2\nmarc21, 799, ind1:auth2\nmarc21, 830, , ind2:auth2\nmarc21, 899, ind1:auth2\n# CHRON_TERM    648 \nmarc21, 648, , ind2:thesaurus\n# TOPIC_TERM      650 654 656 657 658 690\nmarc21, 650, , ind2:thesaurus\n# GEOGR_NAME   651 662 691\nmarc21, 651, , ind2:thesaurus\n# GENRE/FORM    655 \nmarc21, 655, , ind2:thesaurus\n\n# UNIMARC: Always copy the indicators from the authority\nunimarc, *, ind1:auth1, ind2:auth2',NULL,'Authority controlled indicators per biblio field','Free'),
79
('AuthorityControlledIndicators','# PERSO_NAME  100 600 696 700 796 800 896\nmarc21, 100, ind1:auth1\nmarc21, 600, ind1:auth1, ind2:thesaurus\nmarc21, 696, ind1:auth1\nmarc21, 700, ind1:auth1\nmarc21, 796, ind1:auth1\nmarc21, 800, ind1:auth1\nmarc21, 896, ind1:auth1\n# CORPO_NAME  110 610 697 710 797 810 897\nmarc21, 110, ind1:auth1\nmarc21, 610, ind1:auth1, ind2:thesaurus\nmarc21, 697, ind1:auth1\nmarc21, 710, ind1:auth1\nmarc21, 797, ind1:auth1\nmarc21, 810, ind1:auth1\nmarc21, 897, ind1:auth1\n# MEETI_NAME    111 611 698 711 798 811 898\nmarc21, 111, ind1:auth1\nmarc21, 611, ind1:auth1, ind2:thesaurus\nmarc21, 698, ind1:auth1\nmarc21, 711, ind1:auth1\nmarc21, 798, ind1:auth1\nmarc21, 811, ind1:auth1\nmarc21, 898, ind1:auth1\n# UNIF_TITLE        130 440 630 699 730 799 830 899\nmarc21, 130, ind1:auth2\nmarc21, 240, , ind2:auth2\nmarc21, 440, , ind2:auth2\nmarc21, 630, ind1:auth2, ind2:thesaurus\nmarc21, 699, ind1:auth2\nmarc21, 730, ind1:auth2\nmarc21, 799, ind1:auth2\nmarc21, 830, , ind2:auth2\nmarc21, 899, ind1:auth2\n# CHRON_TERM    648 \nmarc21, 648, , ind2:thesaurus\n# TOPIC_TERM      650 654 656 657 658 690\nmarc21, 650, , ind2:thesaurus\n# GEOGR_NAME   651 662 691\nmarc21, 651, , ind2:thesaurus\n# GENRE/FORM    655 \nmarc21, 655, , ind2:thesaurus\n\n# UNIMARC: Always copy the indicators from the authority\nunimarc, *, ind1:auth1, ind2:auth2',NULL,'Authority controlled indicators per biblio field','Free'),
80
('AuthorityMergeLimit','50',NULL,'Maximum number of biblio records updated immediately when an authority record has been modified.','Integer'),
80
('AuthorityMergeLimit','50',NULL,'Maximum number of biblio records updated immediately when an authority record has been modified.','Integer'),
81
('AuthorityMergeMode','loose','loose|strict','Authority merge mode','Choice'),
81
('AuthorityMergeMode','loose','loose|strict','Authority merge mode','Choice'),
Lines 100-108 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
100
('AutomaticCheckinAutoFill','0',NULL,'Automatically fill the next hold with an automatic check in.','YesNo'),
100
('AutomaticCheckinAutoFill','0',NULL,'Automatically fill the next hold with an automatic check in.','YesNo'),
101
('AutomaticConfirmTransfer','0',NULL,'Defines whether transfers should be automatically confirmed at checkin if modal dismissed','YesNo'),
101
('AutomaticConfirmTransfer','0',NULL,'Defines whether transfers should be automatically confirmed at checkin if modal dismissed','YesNo'),
102
('AutomaticEmailReceipts','0',NULL,'Send email receipts for payments and write-offs','YesNo'),
102
('AutomaticEmailReceipts','0',NULL,'Send email receipts for payments and write-offs','YesNo'),
103
('AutomaticItemReturn','1',NULL,'If ON, Koha will automatically set up a transfer of this item to its homebranch','YesNo'),
103
('AutomaticItemReturn','1',NULL,'If enabled, Koha will automatically set up a transfer of this item to its homebranch','YesNo'),
104
('AutomaticRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for automatic renewals ','Choice'),
104
('AutomaticRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for automatic renewals ','Choice'),
105
('autoMemberNum','0',NULL,'If ON, patron number is auto-calculated','YesNo'),
105
('autoMemberNum','0',NULL,'If enabled, patron number is auto-calculated','YesNo'),
106
('AutoRemoveOverduesRestrictions','no','no|when_no_overdue|when_no_overdue_causing_debarment', 'Defines if and on what conditions OVERDUES debarments should automatically be lifted when overdue items are returned by the patron.','Choice'),
106
('AutoRemoveOverduesRestrictions','no','no|when_no_overdue|when_no_overdue_causing_debarment', 'Defines if and on what conditions OVERDUES debarments should automatically be lifted when overdue items are returned by the patron.','Choice'),
107
('AutoRenewalNotices','preferences','cron|preferences|never','How should Koha determine whether to end autorenewal notices','Choice'),
107
('AutoRenewalNotices','preferences','cron|preferences|never','How should Koha determine whether to end autorenewal notices','Choice'),
108
('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'),
108
('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'),
Lines 132-138 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
132
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','Free'),
132
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','Free'),
133
('borrowerRelationship','father|mother',NULL,'Define valid relationships between a guarantor & a guarantee (separated by | or ,)','Free'),
133
('borrowerRelationship','father|mother',NULL,'Define valid relationships between a guarantor & a guarantee (separated by | or ,)','Free'),
134
('BorrowerRenewalPeriodBase','now','dateexpiry|now|combination','Set whether the borrower renewal date should be counted from the dateexpiry, from the current date or by combination: if the dateexpiry is in future use dateexpiry, else use current date ','Choice'),
134
('BorrowerRenewalPeriodBase','now','dateexpiry|now|combination','Set whether the borrower renewal date should be counted from the dateexpiry, from the current date or by combination: if the dateexpiry is in future use dateexpiry, else use current date ','Choice'),
135
('BorrowersLog','1',NULL,'If ON, log edit/create/delete actions on patron data','YesNo'),
135
('BorrowersLog','1',NULL,'If enabled, log edit/create/delete actions on patron data','YesNo'),
136
('BorrowersTitles','Mr|Mrs|Miss|Ms',NULL,'Define appropriate Titles for patrons','Free'),
136
('BorrowersTitles','Mr|Mrs|Miss|Ms',NULL,'Define appropriate Titles for patrons','Free'),
137
('BorrowerUnwantedField','',NULL,'Name the fields you don\'t need to store for a patron\'s account','Free'),
137
('BorrowerUnwantedField','',NULL,'Name the fields you don\'t need to store for a patron\'s account','Free'),
138
('BranchTransferLimitsType','ccode','itemtype|ccode','When using branch transfer limits, choose whether to limit by itemtype or collection code.','Choice'),
138
('BranchTransferLimitsType','ccode','itemtype|ccode','When using branch transfer limits, choose whether to limit by itemtype or collection code.','Choice'),
Lines 147-153 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
147
('CanMarkHoldsToPullAsLost','do_not_allow','do_not_allow|allow|allow_and_notify','Add a button to the "Holds to pull" screen to mark an item as lost and notify the patron.','Choice'),
147
('CanMarkHoldsToPullAsLost','do_not_allow','do_not_allow|allow|allow_and_notify','Add a button to the "Holds to pull" screen to mark an item as lost and notify the patron.','Choice'),
148
('canreservefromotherbranches','1',NULL,'With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),
148
('canreservefromotherbranches','1',NULL,'With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),
149
('CardnumberLength', '', NULL, 'Set a length for card numbers with a maximum of 32 characters.', 'Free'),
149
('CardnumberLength', '', NULL, 'Set a length for card numbers with a maximum of 32 characters.', 'Free'),
150
('CardnumberLog','1',NULL,'If ON, log edit actions on patron cardnumbers','YesNo'),
150
('CardnumberLog','1',NULL,'If enabled, log edit actions on patron cardnumbers','YesNo'),
151
('casAuthentication','0',NULL,'Enable or disable CAS authentication','YesNo'),
151
('casAuthentication','0',NULL,'Enable or disable CAS authentication','YesNo'),
152
('casLogout','0',NULL,'Does a logout from Koha should also log the user out of CAS?','YesNo'),
152
('casLogout','0',NULL,'Does a logout from Koha should also log the user out of CAS?','YesNo'),
153
('casServerUrl','https://localhost:8443/cas',NULL,'URL of the cas server','Free'),
153
('casServerUrl','https://localhost:8443/cas',NULL,'URL of the cas server','Free'),
Lines 155-165 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
155
('CatalogConcerns', '0', NULL, 'Allow users to report catalog concerns', 'YesNo'),
155
('CatalogConcerns', '0', NULL, 'Allow users to report catalog concerns', 'YesNo'),
156
('CatalogerEmails', '', NULL, 'Notify these catalogers by email when a catalog concern is submitted', 'Free'),
156
('CatalogerEmails', '', NULL, 'Notify these catalogers by email when a catalog concern is submitted', 'Free'),
157
('CatalogModuleRelink','0',NULL,'If OFF the linker will never replace the authids that are set in the cataloging module.','YesNo'),
157
('CatalogModuleRelink','0',NULL,'If OFF the linker will never replace the authids that are set in the cataloging module.','YesNo'),
158
('CataloguingLog','1',NULL,'If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'),
158
('CataloguingLog','1',NULL,'If enabled, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'),
159
('ChargeFinesOnClosedDays','0',NULL,'Charge fines on days the library is closed.','YesNo'),
159
('ChargeFinesOnClosedDays','0',NULL,'Charge fines on days the library is closed.','YesNo'),
160
('CheckPrevCheckout','hardno','hardyes|softyes|softno|hardno','By default, for every item checked out, should we warn if the patron has borrowed that item in the past?','Choice'),
160
('CheckPrevCheckout','hardno','hardyes|softyes|softno|hardno','By default, for every item checked out, should we warn if the patron has borrowed that item in the past?','Choice'),
161
('CheckPrevCheckoutDelay','0', NULL,'Maximum number of days that will trigger a warning if the patron has borrowed that item in the past when CheckPrevCheckout is enabled.','Free'),
161
('CheckPrevCheckoutDelay','0', NULL,'Maximum number of days that will trigger a warning if the patron has borrowed that item in the past when CheckPrevCheckout is enabled.','Free'),
162
('ChildNeedsGuarantor','0',NULL,'If ON, a child patron must have a guarantor when adding the patron.','YesNo'),
162
('ChildNeedsGuarantor','0',NULL,'If enabled, a child patron must have a guarantor when adding the patron.','YesNo'),
163
('CircAutoPrintQuickSlip','qslip',NULL,'Choose what should happen when an empty barcode field is submitted in circulation: Display a print quick slip window, Display a print slip window, Do nothing, or Clear the screen.','Choice'),
163
('CircAutoPrintQuickSlip','qslip',NULL,'Choose what should happen when an empty barcode field is submitted in circulation: Display a print quick slip window, Display a print slip window, Do nothing, or Clear the screen.','Choice'),
164
('CircConfirmItemParts', '0', NULL, 'Require staff to confirm that all parts of an item are present at checkin/checkout.', 'YesNo'),
164
('CircConfirmItemParts', '0', NULL, 'Require staff to confirm that all parts of an item are present at checkin/checkout.', 'YesNo'),
165
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
165
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
Lines 170-180 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
170
('ClaimReturnedLostValue', '', NULL, 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),
170
('ClaimReturnedLostValue', '', NULL, 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),
171
('ClaimReturnedWarningThreshold', '', NULL, 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'),
171
('ClaimReturnedWarningThreshold', '', NULL, 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'),
172
('ClaimsBccCopy','0',NULL,'Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
172
('ClaimsBccCopy','0',NULL,'Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
173
('ClaimsLog','1',NULL,'If ON, log all notices sent','YesNo'),
173
('ClaimsLog','1',NULL,'If enabled, log all notices sent','YesNo'),
174
('CleanUpDatabaseReturnClaims', '', NULL, 'Sets the age of resolved return claims to delete from the database for cleanup_database.pl', 'Integer'),
174
('CleanUpDatabaseReturnClaims', '', NULL, 'Sets the age of resolved return claims to delete from the database for cleanup_database.pl', 'Integer'),
175
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
175
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
176
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
176
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
177
('COinSinOPACResults','1',NULL,'If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
177
('COinSinOPACResults','1',NULL,'If enabled, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
178
('CollapseFieldsPatronAddForm','',NULL,'Collapse these fields by default when adding a new patron. These fields can still be expanded.','Multiple'),
178
('CollapseFieldsPatronAddForm','',NULL,'Collapse these fields by default when adding a new patron. These fields can still be expanded.','Multiple'),
179
('ComponentSortField','title','call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
179
('ComponentSortField','title','call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
180
('ComponentSortOrder','asc','asc|dsc|az|za','Specify the default sort order','Choice'),
180
('ComponentSortOrder','asc','asc|dsc|az|za','Specify the default sort order','Choice'),
Lines 186-192 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
186
('CookieConsent', '0', NULL, 'Require cookie consent to be displayed', 'YesNo'),
186
('CookieConsent', '0', NULL, 'Require cookie consent to be displayed', 'YesNo'),
187
('CookieConsentedJS', '', NULL, 'Add Javascript code that will run if cookie consent is provided (e.g. tracking code).', 'Free'),
187
('CookieConsentedJS', '', NULL, 'Add Javascript code that will run if cookie consent is provided (e.g. tracking code).', 'Free'),
188
('CreateAVFromCataloguing', '1', NULL, 'Ability to create authorized values from the cataloguing module', 'YesNo'),
188
('CreateAVFromCataloguing', '1', NULL, 'Ability to create authorized values from the cataloguing module', 'YesNo'),
189
('CronjobLog','0',NULL,'If ON, log information from cron jobs.','YesNo'),
189
('CronjobLog','0',NULL,'If enabled, log information from cron jobs.','YesNo'),
190
('CSVDelimiter',',',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
190
('CSVDelimiter',',',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
191
('CumulativeRestrictionPeriods','0',NULL,'Cumulate the restriction periods instead of keeping the highest','YesNo'),
191
('CumulativeRestrictionPeriods','0',NULL,'Cumulate the restriction periods instead of keeping the highest','YesNo'),
192
('CurbsidePickup', '0', NULL, 'Enable curbside pickup', 'YesNo'),
192
('CurbsidePickup', '0', NULL, 'Enable curbside pickup', 'YesNo'),
Lines 226-236 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
226
('DisplayAddHoldGroups','0',NULL,'Display the ability to create hold groups which are fulfilled by one item','YesNo'),
226
('DisplayAddHoldGroups','0',NULL,'Display the ability to create hold groups which are fulfilled by one item','YesNo'),
227
('DisplayClearScreenButton','no','no|issueslip|issueqslip','If set to ON, a clear screen button will appear on the circulation page.','Choice'),
227
('DisplayClearScreenButton','no','no|issueslip|issueqslip','If set to ON, a clear screen button will appear on the circulation page.','Choice'),
228
('displayFacetCount','0',NULL,'If enabled, display the number of facet counts','YesNo'),
228
('displayFacetCount','0',NULL,'If enabled, display the number of facet counts','YesNo'),
229
('DisplayIconsXSLT','1',NULL,'If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages.','YesNo'),
229
('DisplayIconsXSLT','1',NULL,'If enabled, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages.','YesNo'),
230
('DisplayLibraryFacets', 'holding', 'home|holding|both', 'Defines which library facets to display.', 'Choice'),
230
('DisplayLibraryFacets', 'holding', 'home|holding|both', 'Defines which library facets to display.', 'Choice'),
231
('DisplayMultiItemHolds','0',NULL,'Display the ability to place holds on different items at the same time in staff interface and OPAC','YesNo'),
231
('DisplayMultiItemHolds','0',NULL,'Display the ability to place holds on different items at the same time in staff interface and OPAC','YesNo'),
232
('DisplayMultiPlaceHold','1',NULL,'Display the ability to place multiple holds or not','YesNo'),
232
('DisplayMultiPlaceHold','1',NULL,'Display the ability to place multiple holds or not','YesNo'),
233
('DisplayOPACiconsXSLT','1',NULL,'If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages in the OPAC.','YesNo'),
233
('DisplayOPACiconsXSLT','1',NULL,'If enabled, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages in the OPAC.','YesNo'),
234
('DisplayPublishedDate', '1', NULL, 'Display serial publisheddate on detail pages', 'YesNo'),
234
('DisplayPublishedDate', '1', NULL, 'Display serial publisheddate on detail pages', 'YesNo'),
235
('DumpSearchQueryTemplate','0',NULL,'Add the search query being passed to the search engine into the template for debugging','YesNo'),
235
('DumpSearchQueryTemplate','0',NULL,'Add the search query being passed to the search engine into the template for debugging','YesNo'),
236
('DumpTemplateVarsIntranet', '0', NULL, 'If enabled, dump all Template Toolkit variable to a comment in the html source for the staff intranet.', 'YesNo'),
236
('DumpTemplateVarsIntranet', '0', NULL, 'If enabled, dump all Template Toolkit variable to a comment in the html source for the staff intranet.', 'YesNo'),
Lines 251-257 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
251
('EmailFieldPrecedence','email|emailpro|B_email',NULL,'Ordered list of patron email fields to use when AutoEmailPrimaryAddress is set to first valid','multiple'),
251
('EmailFieldPrecedence','email|emailpro|B_email',NULL,'Ordered list of patron email fields to use when AutoEmailPrimaryAddress is set to first valid','multiple'),
252
('EmailFieldPrimary','','|email|emailpro|B_email|cardnumber|MULTI','Defines the default email address field where patron email notices are sent.','Choice'),
252
('EmailFieldPrimary','','|email|emailpro|B_email|cardnumber|MULTI','Defines the default email address field where patron email notices are sent.','Choice'),
253
('EmailFieldSelection','','email|emailpro|B_email','Selection list of patron email fields to use whern AutoEmailPrimaryAddress is set to selected addresses','multiple'),
253
('EmailFieldSelection','','email|emailpro|B_email','Selection list of patron email fields to use whern AutoEmailPrimaryAddress is set to selected addresses','multiple'),
254
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
254
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If enabled, emails the librarian whenever a hold is placed','YesNo'),
255
('EmailOverduesNoEmail','1',NULL,'Send send overdues of patrons without email address to staff','YesNo'),
255
('EmailOverduesNoEmail','1',NULL,'Send send overdues of patrons without email address to staff','YesNo'),
256
('EmailPatronRegistrations', '0', '0|EmailAddressForPatronRegistrations|BranchEmailAddress|KohaAdminEmailAddress', 'Choose email address that new patron registrations will be sent to: ', 'Choice'),
256
('EmailPatronRegistrations', '0', '0|EmailAddressForPatronRegistrations|BranchEmailAddress|KohaAdminEmailAddress', 'Choose email address that new patron registrations will be sent to: ', 'Choice'),
257
('EmailPatronWhenHoldIsPlaced', '0', NULL, 'Email patron when a hold has been placed for them', 'YesNo'),
257
('EmailPatronWhenHoldIsPlaced', '0', NULL, 'Email patron when a hold has been placed for them', 'YesNo'),
Lines 266-279 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
266
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
266
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
267
('EnablePointOfSale','0',NULL,'Enable the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)','YesNo'),
267
('EnablePointOfSale','0',NULL,'Enable the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)','YesNo'),
268
('EnableSearchHistory','0',NULL,'Enable or disable search history','YesNo'),
268
('EnableSearchHistory','0',NULL,'Enable or disable search history','YesNo'),
269
('EnhancedMessagingPreferences','1',NULL,'If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
269
('EnhancedMessagingPreferences','1',NULL,'If enabled, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
270
('EnhancedMessagingPreferencesOPAC', '1', NULL, 'If ON, show patrons messaging setting on the OPAC.', 'YesNo'),
270
('EnhancedMessagingPreferencesOPAC', '1', NULL, 'If enabled, show patrons messaging setting on the OPAC.', 'YesNo'),
271
('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'),
271
('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'),
272
('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'Free'),
272
('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'Free'),
273
('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'Free'),
273
('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'Free'),
274
('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'),
274
('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'),
275
('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If ON, reserves max pickup delay takes into accountthe closed days.', 'YesNo'),
275
('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If enabled, reserves max pickup delay takes into accountthe closed days.', 'YesNo'),
276
('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'),
276
('expandedSearchOption','0',NULL,'If enabled, set advanced search to be expanded by default','YesNo'),
277
('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'),
277
('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'),
278
('ExpireReservesAutoFillEmail','', NULL,'Send email notification of hold filled from automatically expired/cancelled hold to this address. If not defined, Koha will fallback to the library reply-to address','Free'),
278
('ExpireReservesAutoFillEmail','', NULL,'Send email notification of hold filled from automatically expired/cancelled hold to this address. If not defined, Koha will fallback to the library reply-to address','Free'),
279
('ExpireReservesMaxPickUpDelay','0',NULL,'Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay','YesNo'),
279
('ExpireReservesMaxPickUpDelay','0',NULL,'Enabling this allows holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay','YesNo'),
Lines 295-305 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
295
('FinePaymentAutoPopup','0',NULL,'If enabled, automatically display a print dialog for a payment receipt when making a payment.','YesNo'),
295
('FinePaymentAutoPopup','0',NULL,'If enabled, automatically display a print dialog for a payment receipt when making a payment.','YesNo'),
296
('finesCalendar','noFinesWhenClosed','ignoreCalendar|noFinesWhenClosed','Specify whether to use the Calendar in calculating duedates and fines','Choice'),
296
('finesCalendar','noFinesWhenClosed','ignoreCalendar|noFinesWhenClosed','Specify whether to use the Calendar in calculating duedates and fines','Choice'),
297
('FinesIncludeGracePeriod','1',NULL,'If enabled, fines calculations will include the grace period.','YesNo'),
297
('FinesIncludeGracePeriod','1',NULL,'If enabled, fines calculations will include the grace period.','YesNo'),
298
('FinesLog','1',NULL,'If ON, log fines','YesNo'),
298
('FinesLog','1',NULL,'If enabled, log fines','YesNo'),
299
('finesMode','off','off|production','Choose the fines mode, \'off\' (no charges), \'production\' (accrue overdue fines).  Requires accruefines cronjob.','Choice'),
299
('finesMode','off','off|production','Choose the fines mode, \'off\' (no charges), \'production\' (accrue overdue fines).  Requires accruefines cronjob.','Choice'),
300
('ForceLibrarySelection','0',NULL,'Force staff to select a library when logging into the staff interface.','YesNo'),
300
('ForceLibrarySelection','0',NULL,'Force staff to select a library when logging into the staff interface.','YesNo'),
301
('ForcePasswordResetWhenSetByStaff','0',NULL,'Force a staff created patron account to reset its password after its first OPAC login.','YesNo'),
301
('ForcePasswordResetWhenSetByStaff','0',NULL,'Force a staff created patron account to reset its password after its first OPAC login.','YesNo'),
302
('FRBRizeEditions','0',NULL,'If ON, Koha will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'),
302
('FRBRizeEditions','0',NULL,'If enabled, Koha will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'),
303
('FutureHoldsBlockRenewals', '0', NULL, 'Allow future holds to block renewals', 'YesNo' ),
303
('FutureHoldsBlockRenewals', '0', NULL, 'Allow future holds to block renewals', 'YesNo' ),
304
('GenerateAuthorityField667', 'Machine generated authority record', NULL, 'When BiblioAddsAuthorities and AutoCreateAuthorities are enabled, use this as a default value for the 667$a field of MARC21 records', 'Free'),
304
('GenerateAuthorityField667', 'Machine generated authority record', NULL, 'When BiblioAddsAuthorities and AutoCreateAuthorities are enabled, use this as a default value for the 667$a field of MARC21 records', 'Free'),
305
('GenerateAuthorityField670', 'Work cat.', NULL, 'When BiblioAddsAuthorities and AutoCreateAuthorities are enabled, use this as a default value for the 670$a field of MARC21 records', 'Free'),
305
('GenerateAuthorityField670', 'Work cat.', NULL, 'When BiblioAddsAuthorities and AutoCreateAuthorities are enabled, use this as a default value for the 670$a field of MARC21 records', 'Free'),
Lines 311-318 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
311
('GoogleOpenIDConnectDefaultBranch', '',NULL,'This branch code will be used to create Google OpenID Connect patrons.','Textarea'),
311
('GoogleOpenIDConnectDefaultBranch', '',NULL,'This branch code will be used to create Google OpenID Connect patrons.','Textarea'),
312
('GoogleOpenIDConnectDefaultCategory','',NULL,'This category code will be used to create Google OpenID Connect patrons.','Textarea'),
312
('GoogleOpenIDConnectDefaultCategory','',NULL,'This category code will be used to create Google OpenID Connect patrons.','Textarea'),
313
('GoogleOpenIDConnectDomain', '', NULL, 'Restrict Google OpenID Connect to this domain (or subdomains of this domain). Leave blank for all Google domains', 'Free'),
313
('GoogleOpenIDConnectDomain', '', NULL, 'Restrict Google OpenID Connect to this domain (or subdomains of this domain). Leave blank for all Google domains', 'Free'),
314
('hide_marc','0',NULL,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'),
314
('hide_marc','0',NULL,'If enabled, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'),
315
('hidelostitems','0',NULL,'If ON, disables display of"lost" items in OPAC.','YesNo'),
315
('hidelostitems','0',NULL,'If enabled, disables display of"lost" items in OPAC.','YesNo'),
316
('HidePatronName','0',NULL,'If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'),
316
('HidePatronName','0',NULL,'If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'),
317
('HidePersonalPatronDetailOnCirculation', '0', NULL, 'Hide patrons phone number, email address, street address and city in the circulation page','YesNo'),
317
('HidePersonalPatronDetailOnCirculation', '0', NULL, 'Hide patrons phone number, email address, street address and city in the circulation page','YesNo'),
318
('HoldCancellationRequestSIP','0',NULL,'Option to set holds cancelled via SIP as cancellation requests','YesNo'),
318
('HoldCancellationRequestSIP','0',NULL,'Option to set holds cancelled via SIP as cancellation requests','YesNo'),
Lines 320-326 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
320
('HoldRatioDefault','3',NULL,'Default value for the hold ratio report','Integer'),
320
('HoldRatioDefault','3',NULL,'Default value for the hold ratio report','Integer'),
321
('HoldsAutoFill','0',NULL,'If on, librarian will not be asked if hold should be filled, it will be filled automatically','YesNo'),
321
('HoldsAutoFill','0',NULL,'If on, librarian will not be asked if hold should be filled, it will be filled automatically','YesNo'),
322
('HoldsAutoFillPrintSlip','0',NULL,'If on, hold slip print dialog will be displayed automatically','YesNo'),
322
('HoldsAutoFillPrintSlip','0',NULL,'If on, hold slip print dialog will be displayed automatically','YesNo'),
323
('HoldsLog','0',NULL,'If ON, log create/cancel/suspend/resume actions on holds.','YesNo'),
323
('HoldsLog','0',NULL,'If enabled, log create/cancel/suspend/resume actions on holds.','YesNo'),
324
('HoldsNeedProcessingSIP', '0', NULL, 'Require staff to check-in before hold is set to waiting state', 'YesNo'),
324
('HoldsNeedProcessingSIP', '0', NULL, 'Require staff to check-in before hold is set to waiting state', 'YesNo'),
325
('HoldsQueueParallelLoopsCount', '1', NULL, 'Number of parallel loops to use when running the holds queue builder', 'Integer'),
325
('HoldsQueueParallelLoopsCount', '1', NULL, 'Number of parallel loops to use when running the holds queue builder', 'Integer'),
326
('HoldsQueuePrioritizeBranch','homebranch','holdingbranch|homebranch','Decides if holds queue builder patron home library match to home or holding branch','Choice'),
326
('HoldsQueuePrioritizeBranch','homebranch','holdingbranch|homebranch','Decides if holds queue builder patron home library match to home or holding branch','Choice'),
Lines 329-345 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
329
('HoldsSplitQueueNumbering', 'actual', 'actual|virtual', 'If the holds queue is split, decide if the actual priorities should be displayed', 'Choice'),
329
('HoldsSplitQueueNumbering', 'actual', 'actual|virtual', 'If the holds queue is split, decide if the actual priorities should be displayed', 'Choice'),
330
('HoldsToPullStartDate','2',NULL,'Set the default start date for the Holds to pull list to this many days ago','Integer'),
330
('HoldsToPullStartDate','2',NULL,'Set the default start date for the Holds to pull list to this many days ago','Integer'),
331
('HomeOrHoldingBranch','holdingbranch','holdingbranch|homebranch','Used by Circulation to determine which branch of an item to check with independent branches on, and by search to determine which branch to choose for availability ','Choice'),
331
('HomeOrHoldingBranch','holdingbranch','holdingbranch|homebranch','Used by Circulation to determine which branch of an item to check with independent branches on, and by search to determine which branch to choose for availability ','Choice'),
332
('HouseboundModule','0',NULL,'If ON, enable housebound module functionality.','YesNo'),
332
('HouseboundModule','0',NULL,'If enabled, enable housebound module functionality.','YesNo'),
333
('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'),
333
('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'),
334
('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt',NULL,'Media file extensions','Free'),
334
('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt',NULL,'Media file extensions','Free'),
335
('HTML5MediaYouTube','0',NULL,'YouTube links as videos','YesNo'),
335
('HTML5MediaYouTube','0',NULL,'YouTube links as videos','YesNo'),
336
('IdRef','0',NULL,'Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
336
('IdRef','0',NULL,'Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
337
('ILLCheckAvailability', '0', NULL, 'If ON, during the ILL request process third party sources will be checked for current availability', 'YesNo'),
337
('ILLCheckAvailability', '0', NULL, 'If enabled, during the ILL request process third party sources will be checked for current availability', 'YesNo'),
338
('ILLDefaultStaffEmail', '', NULL, 'Fallback email address for staff ILL notices to be sent to in the absence of a branch address', 'Free'),
338
('ILLDefaultStaffEmail', '', NULL, 'Fallback email address for staff ILL notices to be sent to in the absence of a branch address', 'Free'),
339
('ILLHiddenRequestStatuses', '', NULL, 'ILL statuses that are considered finished and should not be displayed in the ILL module', 'multiple'),
339
('ILLHiddenRequestStatuses', '', NULL, 'ILL statuses that are considered finished and should not be displayed in the ILL module', 'multiple'),
340
('ILLHistoryCheck', '0', NULL, 'If ON, a verification is performed to check if the ILL request has previously been placed by the same patron. Verification is done using one of the following identifier fields: DOI, Pubmed ID or ISBN', 'YesNo'),
340
('ILLHistoryCheck', '0', NULL, 'If enabled, a verification is performed to check if the ILL request has previously been placed by the same patron. Verification is done using one of the following identifier fields: DOI, Pubmed ID or ISBN', 'YesNo'),
341
('IllLog', '0', NULL, 'If ON, log information about ILL requests', 'YesNo'),
341
('IllLog', '0', NULL, 'If enabled, log information about ILL requests', 'YesNo'),
342
('ILLModule','0',NULL,'If ON, enables the interlibrary loans module.','YesNo'),
342
('ILLModule','0',NULL,'If enabled, enables the interlibrary loans module.','YesNo'),
343
('ILLModuleDisclaimerByType','',NULL,'YAML defining disclaimer settings for each ILL request type','Textarea'),
343
('ILLModuleDisclaimerByType','',NULL,'YAML defining disclaimer settings for each ILL request type','Textarea'),
344
('ILLModuleUnmediated','0',NULL,'If enabled, try to immediately progress newly placed ILL requests.','YesNo'),
344
('ILLModuleUnmediated','0',NULL,'If enabled, try to immediately progress newly placed ILL requests.','YesNo'),
345
('ILLOpacbackends','',NULL,'ILL backends to enabled for OPAC initiated requests','multiple'),
345
('ILLOpacbackends','',NULL,'ILL backends to enabled for OPAC initiated requests','multiple'),
Lines 352-364 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
352
('ImageLimit','5',NULL,'Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
352
('ImageLimit','5',NULL,'Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
353
('IncludeSeeAlsoFromInSearches','0',NULL,'Include see-also-from references in searches.','YesNo'),
353
('IncludeSeeAlsoFromInSearches','0',NULL,'Include see-also-from references in searches.','YesNo'),
354
('IncludeSeeFromInSearches','0',NULL,'Include see-from references in searches.','YesNo'),
354
('IncludeSeeFromInSearches','0',NULL,'Include see-from references in searches.','YesNo'),
355
('IndependentBranches','0',NULL,'If ON, increases security between libraries','YesNo'),
355
('IndependentBranches','0',NULL,'If enabled, increases security between libraries','YesNo'),
356
('IndependentBranchesPatronModifications','0', NULL, 'Show only modification request for the logged in branch','YesNo'),
356
('IndependentBranchesPatronModifications','0', NULL, 'Show only modification request for the logged in branch','YesNo'),
357
('IndependentBranchesTransfers','0', NULL, 'Allow non-superlibrarians to transfer items between libraries','YesNo'),
357
('IndependentBranchesTransfers','0', NULL, 'Allow non-superlibrarians to transfer items between libraries','YesNo'),
358
('intranet_includes','includes',NULL,'The includes directory you want for specific look of Koha (includes or includes_npl for example)','Free'),
358
('intranet_includes','includes',NULL,'The includes directory you want for specific look of Koha (includes or includes_npl for example)','Free'),
359
('IntranetAddMastheadLibraryPulldown','0', NULL, 'Add a library select pulldown menu on the staff header search','YesNo'),
359
('IntranetAddMastheadLibraryPulldown','0', NULL, 'Add a library select pulldown menu on the staff header search','YesNo'),
360
('IntranetBiblioDefaultView','normal','normal|marc|isbd|labeled_marc','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','Choice'),
360
('IntranetBiblioDefaultView','normal','normal|marc|isbd|labeled_marc','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','Choice'),
361
('intranetbookbag','1',NULL,'If ON, enables display of Cart feature in the intranet','YesNo'),
361
('intranetbookbag','1',NULL,'If enabled, enables display of Cart feature in the intranet','YesNo'),
362
('IntranetCatalogSearchPulldown','0', NULL, 'Show a search field pulldown for "Search the catalog" boxes','YesNo'),
362
('IntranetCatalogSearchPulldown','0', NULL, 'Show a search field pulldown for "Search the catalog" boxes','YesNo'),
363
('IntranetCirculationHomeHTML', '', NULL, 'Show the following HTML in a div on the bottom of the reports home page', 'Free'),
363
('IntranetCirculationHomeHTML', '', NULL, 'Show the following HTML in a div on the bottom of the reports home page', 'Free'),
364
('IntranetCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the staff interface', 'YesNo'),
364
('IntranetCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the staff interface', 'YesNo'),
Lines 366-382 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
366
('IntranetFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the staff interface','Free'),
366
('IntranetFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the staff interface','Free'),
367
('IntranetNav','','70|10','Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface','Textarea'),
367
('IntranetNav','','70|10','Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface','Textarea'),
368
('IntranetNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number staff interface searches','YesNo'),
368
('IntranetNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number staff interface searches','YesNo'),
369
('intranetreadinghistory','1',NULL,'If ON, Checkout history is enabled for all patrons','YesNo'),
369
('intranetreadinghistory','1',NULL,'If enabled, Checkout history is enabled for all patrons','YesNo'),
370
('IntranetReadingHistoryHolds', '1', NULL, 'If ON, Holds history is enabled for all patrons','YesNo'),
370
('IntranetReadingHistoryHolds', '1', NULL, 'If enabled, Holds history is enabled for all patrons','YesNo'),
371
('IntranetSlipPrinterJS','',NULL,'Use this JavaScript for printing slips. Define at least function printThenClose(). For use e.g. with Firefox PlugIn jsPrintSetup, see http://jsprintsetup.mozdev.org/','Free'),
371
('IntranetSlipPrinterJS','',NULL,'Use this JavaScript for printing slips. Define at least function printThenClose(). For use e.g. with Firefox PlugIn jsPrintSetup, see http://jsprintsetup.mozdev.org/','Free'),
372
('intranetstylesheet','',NULL,'Enter a complete URL to use an alternate layout stylesheet in Intranet','Free'),
372
('intranetstylesheet','',NULL,'Enter a complete URL to use an alternate layout stylesheet in Intranet','Free'),
373
('IntranetUserCSS','',NULL,'Add CSS to be included in the intranet in an embedded <style> tag.','Free'),
373
('IntranetUserCSS','',NULL,'Add CSS to be included in the intranet in an embedded <style> tag.','Free'),
374
('IntranetUserJS','','70|10','Custom javascript for inclusion in Intranet','Textarea'),
374
('IntranetUserJS','','70|10','Custom javascript for inclusion in Intranet','Textarea'),
375
('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','70|10','ISBD','Textarea'),
375
('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','70|10','ISBD','Textarea'),
376
('IssueLog','1',NULL,'If ON, log checkout activity','YesNo'),
376
('IssueLog','1',NULL,'If enabled, log checkout activity','YesNo'),
377
('IssueLostItem','alert','Defines what should be done when an attempt is made to issue an item that has been marked as lost.','alert|confirm|nothing','Choice'),
377
('IssueLostItem','alert','Defines what should be done when an attempt is made to issue an item that has been marked as lost.','alert|confirm|nothing','Choice'),
378
('IssuingInProcess','0',NULL,'If ON, disables fines if the patron is issuing item that accumulate debt','YesNo'),
378
('IssuingInProcess','0',NULL,'If enabled, disables fines if the patron is issuing item that accumulate debt','YesNo'),
379
('item-level_itypes','1',NULL,'If ON, enables Item-level Itemtype / Issuing Rules','YesNo'),
379
('item-level_itypes','1',NULL,'If enabled, enables Item-level Itemtype / Issuing Rules','YesNo'),
380
('itemBarcodeFallbackSearch','0',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
380
('itemBarcodeFallbackSearch','0',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
381
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
381
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
382
('itemcallnumber','',NULL,'The MARC field/subfield that is used to calculate the itemcallnumber (Dewey would be 082ab or 092ab; LOC would be 050ab or 090ab) could be 852hi from an item record','Free'),
382
('itemcallnumber','',NULL,'The MARC field/subfield that is used to calculate the itemcallnumber (Dewey would be 082ab or 092ab; LOC would be 050ab or 090ab) could be 852hi from an item record','Free'),
Lines 402-408 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
402
('ListOwnerDesignated', '', NULL, 'Designated list owner at patron deletion', 'Free'),
402
('ListOwnerDesignated', '', NULL, 'Designated list owner at patron deletion', 'Free'),
403
('ListOwnershipUponPatronDeletion', 'delete', 'delete|transfer|transfer_public', 'Defines the action on their public or shared lists when patron is deleted', 'Choice'),
403
('ListOwnershipUponPatronDeletion', 'delete', 'delete|transfer|transfer_public', 'Defines the action on their public or shared lists when patron is deleted', 'Choice'),
404
('LoadCheckoutsTableDelay','0',NULL,'Delay before auto-loading checkouts table on checkouts screen','Integer'),
404
('LoadCheckoutsTableDelay','0',NULL,'Delay before auto-loading checkouts table on checkouts screen','Integer'),
405
('LoadSearchHistoryToTheFirstLoggedUser', '1', NULL, 'If ON, the next user will automatically get the last searches in their history', 'YesNo'),
405
('LoadSearchHistoryToTheFirstLoggedUser', '1', NULL, 'If enabled, the next user will automatically get the last searches in their history', 'YesNo'),
406
('LocalCoverImages','0',NULL,'Display local cover images on intranet details pages.','YesNo'),
406
('LocalCoverImages','0',NULL,'Display local cover images on intranet details pages.','YesNo'),
407
('LocalHoldsPriority', 'None', 'GiveLibrary|None|GiveLibraryGroup|GiveLibraryAndGroup', 'Enables the LocalHoldsPriority feature', 'Choice'),
407
('LocalHoldsPriority', 'None', 'GiveLibrary|None|GiveLibraryGroup|GiveLibraryAndGroup', 'Enables the LocalHoldsPriority feature', 'Choice'),
408
('LocalHoldsPriorityItemControl', 'holdingbranch', 'holdingbranch|homebranch', 'decides if the feature operates using the item\'s home or holding library.', 'Choice'),
408
('LocalHoldsPriorityItemControl', 'holdingbranch', 'holdingbranch|homebranch', 'decides if the feature operates using the item\'s home or holding library.', 'Choice'),
Lines 444-450 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
444
('noissuescharge','5',NULL,'Define maximum amount withstanding before checkouts are blocked','Integer'),
444
('noissuescharge','5',NULL,'Define maximum amount withstanding before checkouts are blocked','Integer'),
445
('NoIssuesChargeGuarantees','',NULL,'Define maximum amount withstanding before checkouts are blocked','Integer'),
445
('NoIssuesChargeGuarantees','',NULL,'Define maximum amount withstanding before checkouts are blocked','Integer'),
446
('NoIssuesChargeGuarantorsWithGuarantees','',NULL,'Define maximum amount withstanding before checkouts are blocked including guarantors and their other guarantees','Integer'),
446
('NoIssuesChargeGuarantorsWithGuarantees','',NULL,'Define maximum amount withstanding before checkouts are blocked including guarantors and their other guarantees','Integer'),
447
('noItemTypeImages','0',NULL,'If ON, disables itemtype images in the staff interface','YesNo'),
447
('noItemTypeImages','0',NULL,'If enabled, disables itemtype images in the staff interface','YesNo'),
448
('NoRefundOnLostFinesPaidAge','',NULL,'Do not refund lost item fees if the fee was paid off more than this number of days ago','Integer'),
448
('NoRefundOnLostFinesPaidAge','',NULL,'Do not refund lost item fees if the fee was paid off more than this number of days ago','Integer'),
449
('NoRefundOnLostReturnedItemsAge','',NULL,'Do not refund lost item fees if item is lost for more than this number of days','Integer'),
449
('NoRefundOnLostReturnedItemsAge','',NULL,'Do not refund lost item fees if item is lost for more than this number of days','Integer'),
450
('NoRenewalBeforePrecision','exact_time','date|exact_time','Calculate "No renewal before" based on date only or exact time of due date','Choice'),
450
('NoRenewalBeforePrecision','exact_time','date|exact_time','Calculate "No renewal before" based on date only or exact time of due date','Choice'),
Lines 491-506 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
491
('OPACAllowUserToChooseBranch','1',NULL,'Allow the user to choose the branch they want to pickup their hold from','YesNo'),
491
('OPACAllowUserToChooseBranch','1',NULL,'Allow the user to choose the branch they want to pickup their hold from','YesNo'),
492
('OPACAmazonCoverImages','0',NULL,'Display cover images on OPAC from Amazon Web Services','YesNo'),
492
('OPACAmazonCoverImages','0',NULL,'Display cover images on OPAC from Amazon Web Services','YesNo'),
493
('OPACAuthorIdentifiersAndInformation', '', NULL, 'Display author information on the OPAC detail page','multiple_sortable'),
493
('OPACAuthorIdentifiersAndInformation', '', NULL, 'Display author information on the OPAC detail page','multiple_sortable'),
494
('OpacAuthorities','1',NULL,'If ON, enables the search authorities link on OPAC','YesNo'),
494
('OpacAuthorities','1',NULL,'If enabled, enables the search authorities link on OPAC','YesNo'),
495
('OPACBaseURL','',NULL,'Specify the Base URL of the OPAC, e.g., http://opac.mylibrary.com, including the protocol (http:// or https://). Otherwise, the http:// will be added automatically by Koha upon saving.','Free'),
495
('OPACBaseURL','',NULL,'Specify the Base URL of the OPAC, e.g., http://opac.mylibrary.com, including the protocol (http:// or https://). Otherwise, the http:// will be added automatically by Koha upon saving.','Free'),
496
('opacbookbag','1',NULL,'If ON, enables display of Cart feature','YesNo'),
496
('opacbookbag','1',NULL,'If enabled, enables display of Cart feature','YesNo'),
497
('OpacBrowser','0',NULL,'If ON, enables subject authorities browser on OPAC (needs to set misc/cronjob/sbuild_browser_and_cloud.pl)','YesNo'),
497
('OpacBrowser','0',NULL,'If enabled, enables subject authorities browser on OPAC (needs to set misc/cronjob/sbuild_browser_and_cloud.pl)','YesNo'),
498
('OpacBrowseResults','1',NULL,'Disable/enable browsing and paging search results from the OPAC detail page.','YesNo'),
498
('OpacBrowseResults','1',NULL,'Disable/enable browsing and paging search results from the OPAC detail page.','YesNo'),
499
('OpacBrowseSearch', '0',NULL, 'Elasticsearch only: add a page allowing users to \'browse\' all items in the collection','YesNo'),
499
('OpacBrowseSearch', '0',NULL, 'Elasticsearch only: add a page allowing users to \'browse\' all items in the collection','YesNo'),
500
('OpacCatalogConcerns', '0', NULL, 'Allow logged in OPAC users to report catalog concerns', 'YesNo'),
500
('OpacCatalogConcerns', '0', NULL, 'Allow logged in OPAC users to report catalog concerns', 'YesNo'),
501
('OpacCloud','0',NULL,'If ON, enables subject cloud on OPAC','YesNo'),
501
('OpacCloud','0',NULL,'If enabled, enables subject cloud on OPAC','YesNo'),
502
('OpacCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the OPAC', 'YesNo'),
502
('OpacCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the OPAC', 'YesNo'),
503
('OPACComments','1',NULL,'If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
503
('OPACComments','1',NULL,'If enabled, enables patron reviews of bibliographic records in the OPAC','YesNo'),
504
('OPACCustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed at the OPAC. CustomCoverImagesURL must be defined.','YesNo'),
504
('OPACCustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed at the OPAC. CustomCoverImagesURL must be defined.','YesNo'),
505
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
505
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
506
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
506
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
Lines 515-528 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
515
('OPACFineNoRenewalsBlockAutoRenew','0',NULL,'Block/Allow auto renewals if the patron owe more than OPACFineNoRenewals','YesNo'),
515
('OPACFineNoRenewalsBlockAutoRenew','0',NULL,'Block/Allow auto renewals if the patron owe more than OPACFineNoRenewals','YesNo'),
516
('OPACFineNoRenewalsIncludeCredits','1',NULL,'If enabled the value specified in OPACFineNoRenewals should include any unapplied account credits in the calculation','YesNo'),
516
('OPACFineNoRenewalsIncludeCredits','1',NULL,'If enabled the value specified in OPACFineNoRenewals should include any unapplied account credits in the calculation','YesNo'),
517
('OPACFinesTab','1',NULL,'If OFF the patron fines tab in the OPAC is disabled.','YesNo'),
517
('OPACFinesTab','1',NULL,'If OFF the patron fines tab in the OPAC is disabled.','YesNo'),
518
('OPACFRBRizeEditions','0',NULL,'If ON, the OPAC will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'),
518
('OPACFRBRizeEditions','0',NULL,'If enabled, the OPAC will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'),
519
('OpacHiddenItems','',NULL,'This syspref allows to define custom rules for hiding specific items at the OPAC. See https://wiki.koha-community.org/wiki/OpacHiddenItems for more information.','Textarea'),
519
('OpacHiddenItems','',NULL,'This syspref allows to define custom rules for hiding specific items at the OPAC. See https://wiki.koha-community.org/wiki/OpacHiddenItems for more information.','Textarea'),
520
('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by comma, that can see items otherwise hidden by OpacHiddenItems','Textarea'),
520
('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by comma, that can see items otherwise hidden by OpacHiddenItems','Textarea'),
521
('OpacHiddenItemsHidesRecord','1',NULL,'Hide biblio record when all its items are hidden because of OpacHiddenItems','YesNo'),
521
('OpacHiddenItemsHidesRecord','1',NULL,'Hide biblio record when all its items are hidden because of OpacHiddenItems','YesNo'),
522
('OpacHighlightedWords','1',NULL,'If Set, then queried words are higlighted in OPAC','YesNo'),
522
('OpacHighlightedWords','1',NULL,'If Set, then queried words are higlighted in OPAC','YesNo'),
523
('OpacHoldNotes','0',NULL,'Show hold notes on OPAC','YesNo'),
523
('OpacHoldNotes','0',NULL,'Show hold notes on OPAC','YesNo'),
524
('OPACHoldRequests','1',NULL,'If ON, globally enables patron holds on OPAC','YesNo'),
524
('OPACHoldRequests','1',NULL,'If enabled, globally enables patron holds on OPAC','YesNo'),
525
('OPACHoldsHistory','0',NULL,'If ON, enables display of Patron Holds History in OPAC','YesNo'),
525
('OPACHoldsHistory','0',NULL,'If enabled, enables display of Patron Holds History in OPAC','YesNo'),
526
('OPACHoldsIfAvailableAtPickup','1',NULL,'Allow patrons to place a hold at pickup locations (libraries) where the item is available','YesNo'),
526
('OPACHoldsIfAvailableAtPickup','1',NULL,'Allow patrons to place a hold at pickup locations (libraries) where the item is available','YesNo'),
527
('OPACHoldsIfAvailableAtPickupExceptions','',NULL,'List the patron categories not affected by OPACHoldsIfAvailableAtPickup if off','Free'),
527
('OPACHoldsIfAvailableAtPickupExceptions','',NULL,'List the patron categories not affected by OPACHoldsIfAvailableAtPickup if off','Free'),
528
('OPACISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','70|10','OPAC ISBD','Textarea'),
528
('OPACISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|<br/><br/>\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a }|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a }|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a }|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b }|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a }|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a }|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u }|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a }|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z }|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a }|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z }|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: </label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a }|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b }|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a }|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a }|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 }|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|<br/><br/><label>Subjects--Corporate Names: </label>|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|<br/><br/><label>Subjects--Meeting Names: </label>|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|<br/><br/><label>Subjects--Uniform Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological Terms: </label>|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index Terms: </label>|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: </label>|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index Terms--Function: </label>|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index Terms--Curriculum Objective: </label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal Class. No.: </label>|{ 080a }{ 080x }{ / 080b }|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: </label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 088a }|','70|10','OPAC ISBD','Textarea'),
Lines 530-564 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
530
('OpacKohaUrl','1',NULL,'Show \'Powered by Koha\' text on OPAC footer.','Free'),
530
('OpacKohaUrl','1',NULL,'Show \'Powered by Koha\' text on OPAC footer.','Free'),
531
('OpacLangSelectorMode','both','top|both|footer','Select the location to display the language selector in OPAC','Choice'),
531
('OpacLangSelectorMode','both','top|both|footer','Select the location to display the language selector in OPAC','Choice'),
532
('OPACLanguages','en',NULL,'Set the default language in the OPAC.','Languages'),
532
('OPACLanguages','en',NULL,'Set the default language in the OPAC.','Languages'),
533
('opaclanguagesdisplay','0',NULL,'If ON, enables display of Change Language feature on OPAC','YesNo'),
533
('opaclanguagesdisplay','0',NULL,'If enabled, enables display of Change Language feature on OPAC','YesNo'),
534
('opaclayoutstylesheet','opac.css',NULL,'Enter the name of the layout CSS stylesheet to use in the OPAC','Free'),
534
('opaclayoutstylesheet','opac.css',NULL,'Enter the name of the layout CSS stylesheet to use in the OPAC','Free'),
535
('OPACLocalCoverImages','0',NULL,'Display local cover images on OPAC search and details pages.','YesNo'),
535
('OPACLocalCoverImages','0',NULL,'Display local cover images on OPAC search and details pages.','YesNo'),
536
('OpacLocationBranchToDisplay','holding','holding|home|both','In the OPAC, under location show which branch for Location in the record details.','Choice'),
536
('OpacLocationBranchToDisplay','holding','holding|home|both','In the OPAC, under location show which branch for Location in the record details.','Choice'),
537
('OpacLocationOnDetail','holding','holding|home|both|column','In the OPAC detail, display the shelving location on its own column or under a library columns.', 'Choice'),
537
('OpacLocationOnDetail','holding','holding|home|both|column','In the OPAC detail, display the shelving location on its own column or under a library columns.', 'Choice'),
538
('OPACLoginLabelTextContent','cardnumber',NULL,'Control the text displayed on the login form','Free'),
538
('OPACLoginLabelTextContent','cardnumber',NULL,'Control the text displayed on the login form','Free'),
539
('OpacMaintenance','0',NULL,'If ON, enables maintenance warning in OPAC','YesNo'),
539
('OpacMaintenance','0',NULL,'If enabled, enables maintenance warning in OPAC','YesNo'),
540
('OPACMandatoryHoldDates', '', '|start|end|both', 'Define which hold dates are required on OPAC reserve form', 'Choice'),
540
('OPACMandatoryHoldDates', '', '|start|end|both', 'Define which hold dates are required on OPAC reserve form', 'Choice'),
541
('OpacMaxItemsToDisplay','50',NULL,'Max items to display at the OPAC on a biblio detail','Integer'),
541
('OpacMaxItemsToDisplay','50',NULL,'Max items to display at the OPAC on a biblio detail','Integer'),
542
('OpacMetaDescription','',NULL,'This description will show in search engine results (160 characters).','Textarea'),
542
('OpacMetaDescription','',NULL,'This description will show in search engine results (160 characters).','Textarea'),
543
('OpacMetaRobots', 'noindex,nofollow', NULL, 'Improve search engine crawling.', 'Multiple'),
543
('OpacMetaRobots', 'noindex,nofollow', NULL, 'Improve search engine crawling.', 'Multiple'),
544
('OPACMySummaryHTML','','70|10','Enter the HTML that will appear in a column on the \'my summary\' and \'my checkout history\' tabs when a user is logged in to the OPAC. Enter {BIBLIONUMBER}, {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the HTML. Leave blank to disable.','Textarea'),
544
('OPACMySummaryHTML','','70|10','Enter the HTML that will appear in a column on the \'my summary\' and \'my checkout history\' tabs when a user is logged in to the OPAC. Enter {BIBLIONUMBER}, {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the HTML. Leave blank to disable.','Textarea'),
545
('OpacNewsLibrarySelect','0',NULL,'Show selector for branches on OPAC news page','YesNo'),
545
('OpacNewsLibrarySelect','0',NULL,'Show selector for branches on OPAC news page','YesNo'),
546
('OpacNoItemTypeImages','0',NULL,'If ON, disables itemtype images in the OPAC','YesNo'),
546
('OpacNoItemTypeImages','0',NULL,'If enabled, disables itemtype images in the OPAC','YesNo'),
547
('OPACNoResultsFound','','70|10','Display this HTML when no results are found for a search in the OPAC','Textarea'),
547
('OPACNoResultsFound','','70|10','Display this HTML when no results are found for a search in the OPAC','Textarea'),
548
('OPACNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number OPAC searches','YesNo'),
548
('OPACNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number OPAC searches','YesNo'),
549
('OPACnumSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
549
('OPACnumSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
550
('OPACnumSearchResultsDropdown', '0', NULL, 'Enable option list of number of results per page to show in OPAC search results','YesNo'),
550
('OPACnumSearchResultsDropdown', '0', NULL, 'Enable option list of number of results per page to show in OPAC search results','YesNo'),
551
('OPACOpenURLItemTypes', '', NULL, 'Show the OpenURL link only for these item types', 'Free'),
551
('OPACOpenURLItemTypes', '', NULL, 'Show the OpenURL link only for these item types', 'Free'),
552
('OPACOverDrive','0',NULL,'Enable OverDrive integration in the OPAC','YesNo'),
552
('OPACOverDrive','0',NULL,'Enable OverDrive integration in the OPAC','YesNo'),
553
('OpacPasswordChange','1',NULL,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)','YesNo'),
553
('OpacPasswordChange','1',NULL,'If enabled, enables patron-initiated password change in OPAC (disable it when using LDAP auth)','YesNo'),
554
('OPACPatronDetails','1',NULL,'If OFF the patron details tab in the OPAC is disabled.','YesNo'),
554
('OPACPatronDetails','1',NULL,'If OFF the patron details tab in the OPAC is disabled.','YesNo'),
555
('OPACpatronimages','0',NULL,'Enable patron images in the OPAC','YesNo'),
555
('OPACpatronimages','0',NULL,'Enable patron images in the OPAC','YesNo'),
556
('OPACPlayMusicalInscripts','0',NULL,'If displayed musical inscripts, play midi conversion on the OPAC record details page.','YesNo'),
556
('OPACPlayMusicalInscripts','0',NULL,'If displayed musical inscripts, play midi conversion on the OPAC record details page.','YesNo'),
557
('OPACPopupAuthorsSearch','0',NULL,'Display the list of authors when clicking on one author.','YesNo'),
557
('OPACPopupAuthorsSearch','0',NULL,'Display the list of authors when clicking on one author.','YesNo'),
558
('OPACPrivacy','0',NULL,'if ON, allows patrons to define their privacy rules (checkout history)','YesNo'),
558
('OPACPrivacy','0',NULL,'if ON, allows patrons to define their privacy rules (checkout history)','YesNo'),
559
('OpacPublic','1',NULL,'Turn on/off public OPAC','YesNo'),
559
('OpacPublic','1',NULL,'Turn on/off public OPAC','YesNo'),
560
('opacreadinghistory','1',NULL,'If ON, enables display of Patron Circulation History in OPAC','YesNo'),
560
('opacreadinghistory','1',NULL,'If enabled, enables display of Patron Circulation History in OPAC','YesNo'),
561
('OpacRenewalAllowed','1',NULL,'If ON, users can renew their issues directly from their OPAC account','YesNo'),
561
('OpacRenewalAllowed','1',NULL,'If enabled, users can renew their issues directly from their OPAC account','YesNo'),
562
('OpacRenewalBranch','checkoutbranch','itemhomebranch|patronhomebranch|checkoutbranch|none','Choose how the branch for an OPAC renewal is recorded in statistics','Choice'),
562
('OpacRenewalBranch','checkoutbranch','itemhomebranch|patronhomebranch|checkoutbranch|none','Choose how the branch for an OPAC renewal is recorded in statistics','Choice'),
563
('OPACReportProblem', '0', NULL, 'Allow patrons to submit problem reports for OPAC pages to the library or Koha Administrator', 'YesNo'),
563
('OPACReportProblem', '0', NULL, 'Allow patrons to submit problem reports for OPAC pages to the library or Koha Administrator', 'YesNo'),
564
('OpacResetPassword','0',NULL,'Shows the \'Forgot your password?\' link in the OPAC','YesNo'),
564
('OpacResetPassword','0',NULL,'Shows the \'Forgot your password?\' link in the OPAC','YesNo'),
Lines 590-604 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
590
('OpacSuppressionByIPRange','',NULL,'Restrict the suppression to IP adresses outside of the IP range','Free'),
590
('OpacSuppressionByIPRange','',NULL,'Restrict the suppression to IP adresses outside of the IP range','Free'),
591
('OpacSuppressionRedirect','1',NULL,'Redirect the opac detail page for suppressed records to an explanatory page (otherwise redirect to 404 error page)','YesNo'),
591
('OpacSuppressionRedirect','1',NULL,'Redirect the opac detail page for suppressed records to an explanatory page (otherwise redirect to 404 error page)','YesNo'),
592
('opacthemes','bootstrap',NULL,'Define the current theme for the OPAC interface.','Themes'),
592
('opacthemes','bootstrap',NULL,'Define the current theme for the OPAC interface.','Themes'),
593
('OpacTopissue','0',NULL,'If ON, enables the \'most popular items\' link on OPAC. Warning, this is an EXPERIMENTAL feature, turning ON may overload your server','YesNo'),
593
('OpacTopissue','0',NULL,'If enabled, enables the \'most popular items\' link on OPAC. Warning, this is an EXPERIMENTAL feature, turning ON may overload your server','YesNo'),
594
('OpacTrustedCheckout', '0', NULL, 'Allow logged in OPAC users to check out to themselves', 'YesNo'),
594
('OpacTrustedCheckout', '0', NULL, 'Allow logged in OPAC users to check out to themselves', 'YesNo'),
595
('OPACURLOpenInNewWindow','0',NULL,'If ON, URLs in the OPAC open in a new window','YesNo'),
595
('OPACURLOpenInNewWindow','0',NULL,'If enabled, URLs in the OPAC open in a new window','YesNo'),
596
('OPACUserCSS','',NULL,'Add CSS to be included in the OPAC in an embedded <style> tag.','Free'),
596
('OPACUserCSS','',NULL,'Add CSS to be included in the OPAC in an embedded <style> tag.','Free'),
597
('OPACUserJS','','70|10','Define custom javascript for inclusion in OPAC','Textarea'),
597
('OPACUserJS','','70|10','Define custom javascript for inclusion in OPAC','Textarea'),
598
('opacuserlogin','1',NULL,'Enable or disable display of user login features','YesNo'),
598
('opacuserlogin','1',NULL,'Enable or disable display of user login features','YesNo'),
599
('OPACUserSummary', '1', NULL, 'Show the summary of a logged in user\'s checkouts, overdues, holds and fines on the mainpage', 'YesNo'),
599
('OPACUserSummary', '1', NULL, 'Show the summary of a logged in user\'s checkouts, overdues, holds and fines on the mainpage', 'YesNo'),
600
('OPACViewOthersSuggestions','0',NULL,'If ON, allows all suggestions to be displayed in the OPAC','YesNo'),
600
('OPACViewOthersSuggestions','0',NULL,'If enabled, allows all suggestions to be displayed in the OPAC','YesNo'),
601
('OPACVirtualCard','0',NULL,'If ON, the patron virtual library card tab in the OPAC will be enabled','YesNo'),
601
('OPACVirtualCard','0',NULL,'If enabled, the patron virtual library card tab in the OPAC will be enabled','YesNo'),
602
('OPACVirtualCardBarcode','code39','code39|code128|ean13|upca|upce|ean8|itf14|qrcode|matrix2of5|industrial2of5|iata2of5|coop2of5','Specify the type of barcode to be used in the patron virtual library card tab in the OPAC','Choice'),
602
('OPACVirtualCardBarcode','code39','code39|code128|ean13|upca|upce|ean8|itf14|qrcode|matrix2of5|industrial2of5|iata2of5|coop2of5','Specify the type of barcode to be used in the patron virtual library card tab in the OPAC','Choice'),
603
('OPACXSLTDetailsDisplay','default',NULL,'Enable XSL stylesheet control over details page display on OPAC','Free'),
603
('OPACXSLTDetailsDisplay','default',NULL,'Enable XSL stylesheet control over details page display on OPAC','Free'),
604
('OPACXSLTListsDisplay','default',NULL,'Enable XSLT stylesheet control over lists pages display on OPAC','Free'),
604
('OPACXSLTListsDisplay','default',NULL,'Enable XSLT stylesheet control over lists pages display on OPAC','Free'),
Lines 645-652 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
645
('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self-registered','YesNo'),
645
('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self-registered','YesNo'),
646
('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account.','YesNo'),
646
('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account.','YesNo'),
647
('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
647
('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
648
('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),
648
('PhoneNotification','0',NULL,'If enabled, enables generation of phone notifications to be sent by plugins','YesNo'),
649
('PlaceHoldsOnOrdersFromSuggestions','0',NULL,'If ON, enables generation of holds when orders are placed from suggestions','YesNo'),
649
('PlaceHoldsOnOrdersFromSuggestions','0',NULL,'If enabled, enables generation of holds when orders are placed from suggestions','YesNo'),
650
('PrefillGuaranteeField', 'phone,email,streetnumber,address,city,state,zipcode,country', NULL, 'Prefill these fields in guarantee member entry form from guarantor patron record', 'Multiple'),
650
('PrefillGuaranteeField', 'phone,email,streetnumber,address,city,state,zipcode,country', NULL, 'Prefill these fields in guarantee member entry form from guarantor patron record', 'Multiple'),
651
('PrefillItem','0',NULL,'When a new item is added, should it be prefilled with last created item values?','YesNo'),
651
('PrefillItem','0',NULL,'When a new item is added, should it be prefilled with last created item values?','YesNo'),
652
('PreservationModule', '0', NULL, 'Enable the preservation module', 'YesNo'),
652
('PreservationModule', '0', NULL, 'Enable the preservation module', 'YesNo'),
Lines 665-681 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
665
('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the pseudonymized_transactions table','multiple'),
665
('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the pseudonymized_transactions table','multiple'),
666
('PurgeListShareInvitesOlderThan', '14', NULL, 'If not empty, number of days used when deleting unaccepted list share invites', 'Integer'),
666
('PurgeListShareInvitesOlderThan', '14', NULL, 'If not empty, number of days used when deleting unaccepted list share invites', 'Integer'),
667
('PurgeSuggestionsOlderThan', '', NULL, 'If this script is called without the days parameter', 'Integer'),
667
('PurgeSuggestionsOlderThan', '', NULL, 'If this script is called without the days parameter', 'Integer'),
668
('QueryAutoTruncate','1',NULL,'If ON, query truncation is enabled by default','YesNo'),
668
('QueryAutoTruncate','1',NULL,'If enabled, query truncation is enabled by default','YesNo'),
669
('QueryFuzzy','1',NULL,'If ON, enables fuzzy option for searches','YesNo'),
669
('QueryFuzzy','1',NULL,'If enabled, enables fuzzy option for searches','YesNo'),
670
('QueryRegexEscapeOptions', 'escape', 'dont_escape|escape|unescape_escaped', 'Escape option for regexps delimiters in Elasicsearch queries.', 'Choice'),
670
('QueryRegexEscapeOptions', 'escape', 'dont_escape|escape|unescape_escaped', 'Escape option for regexps delimiters in Elasicsearch queries.', 'Choice'),
671
('QueryStemming','1',NULL,'If ON, enables query stemming','YesNo'),
671
('QueryStemming','1',NULL,'If enabled, enables query stemming','YesNo'),
672
('QueryWeightFields','1',NULL,'If ON, enables field weighting','YesNo'),
672
('QueryWeightFields','1',NULL,'If enabled, enables field weighting','YesNo'),
673
('QuoteOfTheDay','','intranet,opac','Enable or disable display of Quote of the Day on the OPAC and staff interface home page','multiple'),
673
('QuoteOfTheDay','','intranet,opac','Enable or disable display of Quote of the Day on the OPAC and staff interface home page','multiple'),
674
('RandomizeHoldsQueueWeight','0',NULL,'if ON, the holds queue in circulation will be randomized, either based on all location codes, or by the location codes specified in StaticHoldsQueueWeight','YesNo'),
674
('RandomizeHoldsQueueWeight','0',NULL,'if ON, the holds queue in circulation will be randomized, either based on all location codes, or by the location codes specified in StaticHoldsQueueWeight','YesNo'),
675
('RealTimeHoldsQueue', '0', NULL, 'Enable updating the holds queue in real time', 'YesNo'),
675
('RealTimeHoldsQueue', '0', NULL, 'Enable updating the holds queue in real time', 'YesNo'),
676
('RecallsLog','1',NULL,'If ON, log create/cancel/expire/fulfill actions on recalls','YesNo'),
676
('RecallsLog','1',NULL,'If enabled, log create/cancel/expire/fulfill actions on recalls','YesNo'),
677
('RecallsMaxPickUpDelay','7',NULL,'Define the maximum time a recall can be awaiting pickup','Integer'),
677
('RecallsMaxPickUpDelay','7',NULL,'Define the maximum time a recall can be awaiting pickup','Integer'),
678
('RecordLocalUseOnReturn','0',NULL,'If ON, statistically record returns of unissued items as local use, instead of return','YesNo'),
678
('RecordLocalUseOnReturn','0',NULL,'If enabled, statistically record returns of unissued items as local use, instead of return','YesNo'),
679
('RecordStaffUserOnCheckout', '0', NULL, 'If enabled, when an item is checked out, the user who checked out the item is recorded', 'YesNo'),
679
('RecordStaffUserOnCheckout', '0', NULL, 'If enabled, when an item is checked out, the user who checked out the item is recorded', 'YesNo'),
680
('RedirectGuaranteeEmail', '0', NULL, 'Enable the ability to redirect guarantee email messages to guarantor.', 'YesNo'),
680
('RedirectGuaranteeEmail', '0', NULL, 'Enable the ability to redirect guarantee email messages to guarantor.', 'YesNo'),
681
('RedirectToSoleResult', '1', NULL, 'When a catalog search via the staff interface or the OPAC returns only one record, redirect to the result.', 'YesNo'),
681
('RedirectToSoleResult', '1', NULL, 'When a catalog search via the staff interface or the OPAC returns only one record, redirect to the result.', 'YesNo'),
Lines 683-703 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
683
('RefundLostOnReturnControl','CheckinLibrary','CheckinLibrary|ItemHomeBranch|ItemHoldingBranch','If a lost item is returned, choose which branch to pick rules for refunding.','Choice'),
683
('RefundLostOnReturnControl','CheckinLibrary','CheckinLibrary|ItemHomeBranch|ItemHoldingBranch','If a lost item is returned, choose which branch to pick rules for refunding.','Choice'),
684
('RenewAccruingItemInOpac','0',NULL,'If enabled, when the fines on an item accruing is paid off in the OPAC via a payment plugin, attempt to renew that item. If the syspref "RenewalPeriodBase" is set to "due date", renewed items may still be overdue','YesNo'),
684
('RenewAccruingItemInOpac','0',NULL,'If enabled, when the fines on an item accruing is paid off in the OPAC via a payment plugin, attempt to renew that item. If the syspref "RenewalPeriodBase" is set to "due date", renewed items may still be overdue','YesNo'),
685
('RenewAccruingItemWhenPaid','0',NULL,'If enabled, when the fines on an item accruing is paid off, attempt to renew that item. If the syspref "RenewalPeriodBase" is set to "due date", renewed items may still be overdue','YesNo'),
685
('RenewAccruingItemWhenPaid','0',NULL,'If enabled, when the fines on an item accruing is paid off, attempt to renew that item. If the syspref "RenewalPeriodBase" is set to "due date", renewed items may still be overdue','YesNo'),
686
('RenewalLog','0',NULL,'If ON, log information about renewals','YesNo'),
686
('RenewalLog','0',NULL,'If enabled, log information about renewals','YesNo'),
687
('RenewalSendNotice','0',NULL,NULL,'YesNo'),
687
('RenewalSendNotice','0',NULL,NULL,'YesNo'),
688
('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'),
688
('RenewSerialAddsSuggestion','0',NULL,'If enabled, adds a new suggestion at serial subscription renewal','YesNo'),
689
('RentalFeesCheckoutConfirmation', '0', NULL, 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'),
689
('RentalFeesCheckoutConfirmation', '0', NULL, 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'),
690
('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'),
690
('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'),
691
('ReportsExportFormatODS','1',NULL,'Show ODS download in Reports','YesNo'),
691
('ReportsExportFormatODS','1',NULL,'Show ODS download in Reports','YesNo'),
692
('ReportsExportLimit','',NULL,'Limit for report downloads','Integer'),
692
('ReportsExportLimit','',NULL,'Limit for report downloads','Integer'),
693
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
693
('ReportsLog','0',NULL,'If enabled, log information about reports.','YesNo'),
694
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
694
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
695
('RequireChoosingExistingAuthority','0',NULL,'Require existing authority selection in controlled fields during cataloging.','YesNo'),
695
('RequireChoosingExistingAuthority','0',NULL,'Require existing authority selection in controlled fields during cataloging.','YesNo'),
696
('RequirePaymentType','0',NULL,'Require staff to select a payment type when a payment is made','YesNo'),
696
('RequirePaymentType','0',NULL,'Require staff to select a payment type when a payment is made','YesNo'),
697
('RequireStrongPassword','1',NULL,'Require a strong login password for staff and patrons','YesNo'),
697
('RequireStrongPassword','1',NULL,'Require a strong login password for staff and patrons','YesNo'),
698
('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights','Choice'),
698
('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights','Choice'),
699
('ReservesMaxPickUpDelay','7',NULL,'Define the Maximum delay to pick up an item on hold','Integer'),
699
('ReservesMaxPickUpDelay','7',NULL,'Define the Maximum delay to pick up an item on hold','Integer'),
700
('ReservesNeedReturns','1',NULL,'If ON, a hold placed on an item available in this library must be checked-in, otherwise, a hold on a specific item, that is in the library & available is considered available','YesNo'),
700
('ReservesNeedReturns','1',NULL,'If enabled, a hold placed on an item available in this library must be checked-in, otherwise, a hold on a specific item, that is in the library & available is considered available','YesNo'),
701
('RESTAPIRenewalBranch','apiuserbranch','itemhomebranch|patronhomebranch|checkoutbranch|apiuserbranch|none','Choose how the branch for an API renewal is recorded in statistics','Choice'),
701
('RESTAPIRenewalBranch','apiuserbranch','itemhomebranch|patronhomebranch|checkoutbranch|apiuserbranch|none','Choose how the branch for an API renewal is recorded in statistics','Choice'),
702
('RESTBasicAuth','0',NULL,'If enabled, Basic authentication is enabled for the REST API.','YesNo'),
702
('RESTBasicAuth','0',NULL,'If enabled, Basic authentication is enabled for the REST API.','YesNo'),
703
('RESTdefaultPageSize','20',NULL,'Default page size for endpoints listing objects','Integer'),
703
('RESTdefaultPageSize','20',NULL,'Default page size for endpoints listing objects','Integer'),
Lines 711-723 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
711
('RestrictPatronsWithFailedNotices', '0', NULL, 'If enabled then when SMS and email notices fail sending at the Koha level then a debarment will be applied to a patrons account', 'YesNo'),
711
('RestrictPatronsWithFailedNotices', '0', NULL, 'If enabled then when SMS and email notices fail sending at the Koha level then a debarment will be applied to a patrons account', 'YesNo'),
712
('RetainCatalogSearchTerms', '1', NULL, 'If enabled, searches entered into the catalog search bar will be retained', 'YesNo'),
712
('RetainCatalogSearchTerms', '1', NULL, 'If enabled, searches entered into the catalog search bar will be retained', 'YesNo'),
713
('RetainPatronsSearchTerms', '1', NULL, 'If enabled, searches entered into the checkout and patrons search bar will be retained', 'YesNo'),
713
('RetainPatronsSearchTerms', '1', NULL, 'If enabled, searches entered into the checkout and patrons search bar will be retained', 'YesNo'),
714
('ReturnBeforeExpiry','0',NULL,'If ON, checkout will be prevented if returndate is after patron card expiry','YesNo'),
714
('ReturnBeforeExpiry','0',NULL,'If enabled, checkout will be prevented if returndate is after patron card expiry','YesNo'),
715
('ReturnLog','1',NULL,'If ON, enables the circulation (returns) log','YesNo'),
715
('ReturnLog','1',NULL,'If enabled, enables the circulation (returns) log','YesNo'),
716
('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'),
716
('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'),
717
('RisExportAdditionalFields', '', NULL, 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),
717
('RisExportAdditionalFields', '', NULL, 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),
718
('RoundFinesAtPayment','0', NULL,'If enabled any fines with fractions of a cent will be rounded to the nearest cent when payments are collected. e.g. 1.004 will be paid off by a 1.00 payment','YesNo'),
718
('RoundFinesAtPayment','0', NULL,'If enabled any fines with fractions of a cent will be rounded to the nearest cent when payments are collected. e.g. 1.004 will be paid off by a 1.00 payment','YesNo'),
719
('RoutingListAddReserves','0',NULL,'If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
719
('RoutingListAddReserves','0',NULL,'If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
720
('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),
720
('RoutingSerials','1',NULL,'If enabled, serials routing is enabled','YesNo'),
721
('SavedSearchFilters', '0', NULL, 'Allow staff with permission to create/edit custom search filters', 'YesNo'),
721
('SavedSearchFilters', '0', NULL, 'Allow staff with permission to create/edit custom search filters', 'YesNo'),
722
('SCOAllowCheckin','0',NULL,'If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),
722
('SCOAllowCheckin','0',NULL,'If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),
723
('SCOBatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch while logged into Self Checkout','Free'),
723
('SCOBatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch while logged into Self Checkout','Free'),
Lines 727-733 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
727
('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo'),
727
('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo'),
728
('SearchEngine','Zebra','Elasticsearch|Zebra','Search Engine','Choice'),
728
('SearchEngine','Zebra','Elasticsearch|Zebra','Search Engine','Choice'),
729
('SearchLimitLibrary', 'homebranch', 'homebranch|holdingbranch|both', 'When limiting search results with a library or library group, use the item\'s home library, or holding library, or both.', 'Choice'),
729
('SearchLimitLibrary', 'homebranch', 'homebranch|holdingbranch|both', 'When limiting search results with a library or library group, use the item\'s home library, or holding library, or both.', 'Choice'),
730
('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),
730
('SearchMyLibraryFirst','0',NULL,'If enabled, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),
731
('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'),
731
('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'),
732
('SearchWithISSNVariations','0',NULL,'If enabled, search on all variations of the ISSN','YesNo'),
732
('SearchWithISSNVariations','0',NULL,'If enabled, search on all variations of the ISSN','YesNo'),
733
('SelfCheckAllowByIPRanges','',NULL,'(Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'),
733
('SelfCheckAllowByIPRanges','',NULL,'(Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'),
Lines 736-742 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
736
('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','Free'),
736
('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','Free'),
737
('SelfCheckInUserJS','',NULL,'Define custom javascript for inclusion in the self check-in module.','Free'),
737
('SelfCheckInUserJS','',NULL,'Define custom javascript for inclusion in the self check-in module.','Free'),
738
('SelfCheckoutByLogin','1',NULL,'Have patrons login into the web-based self checkout system with their username/password or their cardnumber','YesNo'),
738
('SelfCheckoutByLogin','1',NULL,'Have patrons login into the web-based self checkout system with their username/password or their cardnumber','YesNo'),
739
('SelfCheckReceiptPrompt','1',NULL,'If ON, print receipt dialog pops up when self checkout is finished','YesNo'),
739
('SelfCheckReceiptPrompt','1',NULL,'If enabled, print receipt dialog pops up when self checkout is finished','YesNo'),
740
('SelfCheckTimeout','120',NULL,'Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
740
('SelfCheckTimeout','120',NULL,'Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
741
('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','Free'),
741
('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','Free'),
742
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
742
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
Lines 753-764 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
753
('ShowAllCheckins', '0', NULL, 'Show all checkins', 'YesNo'),
753
('ShowAllCheckins', '0', NULL, 'Show all checkins', 'YesNo'),
754
('ShowComponentRecords', 'nowhere', 'nowhere|staff|opac|both','In which record detail pages to show list of the component records, as linked via 773','Choice'),
754
('ShowComponentRecords', 'nowhere', 'nowhere|staff|opac|both','In which record detail pages to show list of the component records, as linked via 773','Choice'),
755
('ShowHeadingUse', '0', NULL, 'Show whether MARC21 authority record contains an established heading that conforms to descriptive cataloguing rules, and can therefore be used as a main/added entry, or subject, or series title', 'YesNo'),
755
('ShowHeadingUse', '0', NULL, 'Show whether MARC21 authority record contains an established heading that conforms to descriptive cataloguing rules, and can therefore be used as a main/added entry, or subject, or series title', 'YesNo'),
756
('showLastPatron','0',NULL,'If ON, enables the last patron feature in the intranet','YesNo'),
756
('showLastPatron','0',NULL,'If enabled, enables the last patron feature in the intranet','YesNo'),
757
('showLastPatronCount', '10', NULL, 'How many patrons should showLastPatron remember', 'Integer'),
757
('showLastPatronCount', '10', NULL, 'How many patrons should showLastPatron remember', 'Integer'),
758
('ShowPatronFirstnameIfDifferentThanPreferredname','0',NULL,'If ON, a patrons firstname will also show in search results if different than their preferred name','YesNo'),
758
('ShowPatronFirstnameIfDifferentThanPreferredname','0',NULL,'If enabled, a patrons firstname will also show in search results if different than their preferred name','YesNo'),
759
('ShowPatronImageInWebBasedSelfCheck','0',NULL,'If ON, displays patron image when a patron uses web-based self-checkout','YesNo'),
759
('ShowPatronImageInWebBasedSelfCheck','0',NULL,'If enabled, displays patron image when a patron uses web-based self-checkout','YesNo'),
760
('ShowReviewer','full','none|full|first|surname|firstandinitial|username','Choose how a commenter\'s identity is presented alongside comments in the OPAC','Choice'),
760
('ShowReviewer','full','none|full|first|surname|firstandinitial|username','Choose how a commenter\'s identity is presented alongside comments in the OPAC','Choice'),
761
('ShowReviewerPhoto','1',NULL,'If ON, photo of reviewer will be shown beside comments in OPAC','YesNo'),
761
('ShowReviewerPhoto','1',NULL,'If enabled, photo of reviewer will be shown beside comments in OPAC','YesNo'),
762
('SIP2AddOpacMessagesToScreenMessage','1',NULL,'If enabled, patron OPAC messages will be included in the SIP2 screen message','YesNo'),
762
('SIP2AddOpacMessagesToScreenMessage','1',NULL,'If enabled, patron OPAC messages will be included in the SIP2 screen message','YesNo'),
763
('SIP2SortBinMapping','',NULL,'Use the following mappings to determine the sort_bin of a returned item. The mapping should be on the form "branchcode:item field:item field value:sort bin number", with one mapping per line.','Free'),
763
('SIP2SortBinMapping','',NULL,'Use the following mappings to determine the sort_bin of a returned item. The mapping should be on the form "branchcode:item field:item field value:sort bin number", with one mapping per line.','Free'),
764
('SkipHoldTrapOnNotForLoanValue','',NULL,'If set, Koha will never trap items for hold with this notforloan value','Integer'),
764
('SkipHoldTrapOnNotForLoanValue','',NULL,'If set, Koha will never trap items for hold with this notforloan value','Integer'),
Lines 779-791 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
779
('StaffInterfaceLanguages','en',NULL,'Set the default language in the staff interface.','Languages'),
779
('StaffInterfaceLanguages','en',NULL,'Set the default language in the staff interface.','Languages'),
780
('StaffLangSelectorMode','footer','top|both|footer','Select the location to display the language selector in staff interface','Choice'),
780
('StaffLangSelectorMode','footer','top|both|footer','Select the location to display the language selector in staff interface','Choice'),
781
('StaffLoginLibraryBasedOnIP', '1',NULL, 'Set the logged in library for the user based on their current IP','YesNo'),
781
('StaffLoginLibraryBasedOnIP', '1',NULL, 'Set the logged in library for the user based on their current IP','YesNo'),
782
('StaffLoginRestrictLibraryByIP','0',NULL,'If ON, IP authentication is enabled, blocking access to the staff interface from unauthorized IP addresses based on branch','YesNo'),
782
('StaffLoginRestrictLibraryByIP','0',NULL,'If enabled, IP authentication is enabled, blocking access to the staff interface from unauthorized IP addresses based on branch','YesNo'),
783
('StaffSearchResultsDisplayBranch','holdingbranch','holdingbranch|homebranch','Controls the display of the home or holding branch for staff search results','Choice'),
783
('StaffSearchResultsDisplayBranch','holdingbranch','holdingbranch|homebranch','Controls the display of the home or holding branch for staff search results','Choice'),
784
('StaffSerialIssueDisplayCount','3',NULL,'Number of serial issues to display per subscription in the staff interface','Integer'),
784
('StaffSerialIssueDisplayCount','3',NULL,'Number of serial issues to display per subscription in the staff interface','Integer'),
785
('staffShibOnly','0',NULL,'If ON enables shibboleth only authentication for the staff client','YesNo'),
785
('staffShibOnly','0',NULL,'If ON enables shibboleth only authentication for the staff client','YesNo'),
786
('StaticHoldsQueueWeight','0',NULL,'Specify a list of library location codes separated by commas -- the list of codes will be traversed and weighted with first values given higher weight for holds fulfillment -- alternatively, if RandomizeHoldsQueueWeight is set, the list will be randomly selective','Integer'),
786
('StaticHoldsQueueWeight','0',NULL,'Specify a list of library location codes separated by commas -- the list of codes will be traversed and weighted with first values given higher weight for holds fulfillment -- alternatively, if RandomizeHoldsQueueWeight is set, the list will be randomly selective','Integer'),
787
('StatisticsFields','location|itype|ccode', NULL, 'Define Fields (from the items table) used for statistics members','Free'),
787
('StatisticsFields','location|itype|ccode', NULL, 'Define Fields (from the items table) used for statistics members','Free'),
788
('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
788
('StockRotation','0',NULL,'If enabled, enables the stock rotation module','YesNo'),
789
('StoreLastBorrower','0',NULL,'Defines the number of borrowers stored per item in the items_last_borrower table','Integer'),
789
('StoreLastBorrower','0',NULL,'Defines the number of borrowers stored per item in the items_last_borrower table','Integer'),
790
('StripWhitespaceChars','0',NULL,'Strip leading and trailing whitespace characters and inner newlines from input fields when cataloguing bibliographic and authority records.','YesNo'),
790
('StripWhitespaceChars','0',NULL,'Strip leading and trailing whitespace characters and inner newlines from input fields when cataloguing bibliographic and authority records.','YesNo'),
791
('SubfieldsToAllowForRestrictedBatchmod','',NULL,'Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j','Free'),
791
('SubfieldsToAllowForRestrictedBatchmod','',NULL,'Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j','Free'),
Lines 793-802 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
793
('SubfieldsToUseWhenPrefill','',NULL,'Define a list of subfields to use when prefilling items (separated by space)','Free'),
793
('SubfieldsToUseWhenPrefill','',NULL,'Define a list of subfields to use when prefilling items (separated by space)','Free'),
794
('SubscriptionDuplicateDroppedInput','',NULL,'List of fields which must not be rewritten when a subscription is duplicated (Separated by pipe |)','Free'),
794
('SubscriptionDuplicateDroppedInput','',NULL,'List of fields which must not be rewritten when a subscription is duplicated (Separated by pipe |)','Free'),
795
('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'),
795
('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'),
796
('SubscriptionLog','1',NULL,'If ON, enables subscriptions log','YesNo'),
796
('SubscriptionLog','1',NULL,'If enabled, enables subscriptions log','YesNo'),
797
('suggestion','1',NULL,'If ON, enables patron suggestions feature in OPAC','YesNo'),
797
('suggestion','1',NULL,'If enabled, enables patron suggestions feature in OPAC','YesNo'),
798
('suggestionPatronCategoryExceptions', '', NULL, 'List the patron categories not affected by suggestion system preference if on', 'Free'),
798
('suggestionPatronCategoryExceptions', '', NULL, 'List the patron categories not affected by suggestion system preference if on', 'Free'),
799
('SuggestionsLog','0',NULL,'If ON, log purchase suggestion changes','YesNo'),
799
('SuggestionsLog','0',NULL,'If enabled, log purchase suggestion changes','YesNo'),
800
('SuspendHoldsIntranet','1',NULL,'Allow holds to be suspended from the intranet.','YesNo'),
800
('SuspendHoldsIntranet','1',NULL,'Allow holds to be suspended from the intranet.','YesNo'),
801
('SuspendHoldsOpac','1',NULL,'Allow holds to be suspended from the OPAC.','YesNo'),
801
('SuspendHoldsOpac','1',NULL,'Allow holds to be suspended from the OPAC.','YesNo'),
802
('SuspensionsCalendar','noSuspensionsWhenClosed','ignoreCalendar|noSuspensionsWhenClosed','Specify whether to use the Calendar in calculating suspension expiration','Choice'),
802
('SuspensionsCalendar','noSuspensionsWhenClosed','ignoreCalendar|noSuspensionsWhenClosed','Specify whether to use the Calendar in calculating suspension expiration','Choice'),
Lines 821-830 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
821
('TagsModeration','0',NULL,'Require tags from patrons to be approved before becoming visible.','YesNo'),
821
('TagsModeration','0',NULL,'Require tags from patrons to be approved before becoming visible.','YesNo'),
822
('TagsShowOnDetail','10',NULL,'Number of tags to display on detail page.  0 is off.','Integer'),
822
('TagsShowOnDetail','10',NULL,'Number of tags to display on detail page.  0 is off.','Integer'),
823
('TagsShowOnList','6',NULL,'Number of tags to display on search results list.  0 is off.','Integer'),
823
('TagsShowOnList','6',NULL,'Number of tags to display on search results list.  0 is off.','Integer'),
824
('TalkingTechItivaPhoneNotification','0',NULL,'If ON, enables Talking Tech I-tiva phone notifications','YesNo'),
824
('TalkingTechItivaPhoneNotification','0',NULL,'If enabled, enables Talking Tech I-tiva phone notifications','YesNo'),
825
('TaxRates','0',NULL,'Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST','Integer'),
825
('TaxRates','0',NULL,'Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST','Integer'),
826
('template','prog',NULL,'Define the preferred staff interface template','Themes'),
826
('template','prog',NULL,'Define the preferred staff interface template','Themes'),
827
('ThingISBN','0',NULL,'Use with FRBRizeEditions. If ON, Koha will use the ThingISBN web service in the Editions tab on the detail pages.','YesNo'),
827
('ThingISBN','0',NULL,'Use with FRBRizeEditions. If enabled, Koha will use the ThingISBN web service in the Editions tab on the detail pages.','YesNo'),
828
('TimeFormat','24hr','12hr|24hr','Defines the global time format for visual output.','Choice'),
828
('TimeFormat','24hr','12hr|24hr','Defines the global time format for visual output.','Choice'),
829
('timeout','1d',NULL,'Inactivity timeout for cookies authentication','Free'),
829
('timeout','1d',NULL,'Inactivity timeout for cookies authentication','Free'),
830
('todaysIssuesDefaultSortOrder','desc','asc|desc','Specify the sort order of Todays Issues on the circulation page','Choice'),
830
('todaysIssuesDefaultSortOrder','desc','asc|desc','Specify the sort order of Todays Issues on the circulation page','Choice'),
Lines 854-860 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
854
('UpdateNotForLoanStatusOnCheckout', '', NULL, 'This is a list of value pairs. When an item is checked out, if its not for loan value matches the value on the left, then the items not for loan value will be updated to the value on the right. \nE.g. \'-1: 0\' will cause an item that was set to \'Ordered\' to now be available for loan. Each pair of values should be on a separate line.', 'Free'),
854
('UpdateNotForLoanStatusOnCheckout', '', NULL, 'This is a list of value pairs. When an item is checked out, if its not for loan value matches the value on the left, then the items not for loan value will be updated to the value on the right. \nE.g. \'-1: 0\' will cause an item that was set to \'Ordered\' to now be available for loan. Each pair of values should be on a separate line.', 'Free'),
855
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
855
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
856
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','Integer'),
856
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','Integer'),
857
('uppercasesurnames','0',NULL,'If ON, surnames are converted to upper case in patron entry form','YesNo'),
857
('uppercasesurnames','0',NULL,'If enabled, surnames are converted to upper case in patron entry form','YesNo'),
858
('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','Free'),
858
('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','Free'),
859
('UsageStats', '2', NULL, 'Share anonymous usage data on the Hea Koha community website.', 'Integer'),
859
('UsageStats', '2', NULL, 'Share anonymous usage data on the Hea Koha community website.', 'Integer'),
860
('UsageStatsCountry', '', NULL, 'The country where your library is located, to be shown on the Hea Koha community website', 'Choice'),
860
('UsageStatsCountry', '', NULL, 'The country where your library is located, to be shown on the Hea Koha community website', 'Choice'),
Lines 868-877 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
868
('UsageStatsPublicID', '', NULL, 'Public ID for Hea website', 'Free'),
868
('UsageStatsPublicID', '', NULL, 'Public ID for Hea website', 'Free'),
869
('UseACQFrameworkForBiblioRecords','0',NULL,'Use the ACQ framework for the catalog details','YesNo'),
869
('UseACQFrameworkForBiblioRecords','0',NULL,'Use the ACQ framework for the catalog details','YesNo'),
870
('UseAuthoritiesForTracings','1',NULL,'Use authority record numbers for subject tracings instead of heading strings.','YesNo'),
870
('UseAuthoritiesForTracings','1',NULL,'Use authority record numbers for subject tracings instead of heading strings.','YesNo'),
871
('UseBranchTransferLimits','0',NULL,'If ON, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'),
871
('UseBranchTransferLimits','0',NULL,'If enabled, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'),
872
('UseCashRegisters','0',NULL,'Use cash registers with the accounting system and assign patron transactions to them.','YesNo'),
872
('UseCashRegisters','0',NULL,'Use cash registers with the accounting system and assign patron transactions to them.','YesNo'),
873
('UseCirculationDesks','0',NULL,'Use circulation desks with circulation.','YesNo'),
873
('UseCirculationDesks','0',NULL,'Use circulation desks with circulation.','YesNo'),
874
('UseControlNumber','0',NULL,'If ON, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','YesNo'),
874
('UseControlNumber','0',NULL,'If enabled, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','YesNo'),
875
('UseCourseReserves','0',NULL,'Enable the course reserves feature.','YesNo'),
875
('UseCourseReserves','0',NULL,'Enable the course reserves feature.','YesNo'),
876
('useDaysMode','Calendar','Calendar|Days|Datedue|Dayweek','Choose the method for calculating due date: select Calendar, Datedue or Dayweek to use the holidays module, and Days to ignore the holidays module','Choice'),
876
('useDaysMode','Calendar','Calendar|Days|Datedue|Dayweek','Choose the method for calculating due date: select Calendar, Datedue or Dayweek to use the holidays module, and Days to ignore the holidays module','Choice'),
877
('useDefaultReplacementCost', '0', NULL, 'default replacement cost defined in item type', 'YesNo'),
877
('useDefaultReplacementCost', '0', NULL, 'default replacement cost defined in item type', 'YesNo'),
Lines 885-900 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
885
('viewISBD','1',NULL,'Allow display of ISBD view of bibiographic records','YesNo'),
885
('viewISBD','1',NULL,'Allow display of ISBD view of bibiographic records','YesNo'),
886
('viewLabeledMARC','0',NULL,'Allow display of labeled MARC view of bibiographic records','YesNo'),
886
('viewLabeledMARC','0',NULL,'Allow display of labeled MARC view of bibiographic records','YesNo'),
887
('viewMARC','1',NULL,'Allow display of MARC view of bibiographic records','YesNo'),
887
('viewMARC','1',NULL,'Allow display of MARC view of bibiographic records','YesNo'),
888
('virtualshelves','1',NULL,'If ON, enables Lists management','YesNo'),
888
('virtualshelves','1',NULL,'If enabled, enables Lists management','YesNo'),
889
('WaitingNotifyAtCheckin','0',NULL,'If ON, notify librarians of waiting holds for the patron whose items they are checking in.','YesNo'),
889
('WaitingNotifyAtCheckin','0',NULL,'If enabled, notify librarians of waiting holds for the patron whose items they are checking in.','YesNo'),
890
('WaitingNotifyAtCheckout','0',NULL,'If ON, notify librarians of waiting holds for the patron whose items they are checking out.','YesNo'),
890
('WaitingNotifyAtCheckout','0',NULL,'If enabled, notify librarians of waiting holds for the patron whose items they are checking out.','YesNo'),
891
('WebBasedSelfCheck','0',NULL,'If ON, enables the web-based self-check system','YesNo'),
891
('WebBasedSelfCheck','0',NULL,'If enabled, enables the web-based self-check system','YesNo'),
892
('WhenLostChargeReplacementFee','1',NULL,'If ON, Charge the replacement price when a patron loses an item.','YesNo'),
892
('WhenLostChargeReplacementFee','1',NULL,'If enabled, Charge the replacement price when a patron loses an item.','YesNo'),
893
('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo'),
893
('WhenLostForgiveFine','0',NULL,'If enabled, Forgives the fines on an item when it is lost.','YesNo'),
894
('XSLTDetailsDisplay','default',NULL,'Enable XSL stylesheet control over details page display on intranet','Free'),
894
('XSLTDetailsDisplay','default',NULL,'Enable XSL stylesheet control over details page display on intranet','Free'),
895
('XSLTListsDisplay','default',NULL,'Enable XSLT stylesheet control over lists pages display on intranet','Free'),
895
('XSLTListsDisplay','default',NULL,'Enable XSLT stylesheet control over lists pages display on intranet','Free'),
896
('XSLTResultsDisplay','default',NULL,'Enable XSL stylesheet control over results page display on intranet','Free'),
896
('XSLTResultsDisplay','default',NULL,'Enable XSL stylesheet control over results page display on intranet','Free'),
897
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','Free'),
897
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','Free'),
898
('z3950NormalizeAuthor','0',NULL,'If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
898
('z3950NormalizeAuthor','0',NULL,'If enabled, Personal Name Authorities will replace authors in biblio.author','YesNo'),
899
('z3950Status','',NULL,'This syspref allows to define custom YAML based rules for marking items unavailable in z3950 results.','Textarea')
899
('z3950Status','',NULL,'This syspref allows to define custom YAML based rules for marking items unavailable in z3950 results.','Textarea')
900
;
900
;
901
- 

Return to bug 41800