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

(-)a/installer/data/mysql/db_revs/251200014.pl (-3 / +27 lines)
Lines 34-39 return { Link Here
34
                WHERE BINARY type='integer'
34
                WHERE BINARY type='integer'
35
            }
35
            }
36
        );
36
        );
37
        $dbh->do(
38
            q{
39
                UPDATE systempreferences
40
                SET type='Free'
41
                WHERE BINARY type='free'
42
            }
43
        );
37
44
38
        my $new_explanations = {
45
        my $new_explanations = {
39
            AcquisitionsDefaultEmailAddress => q{Default email address that acquisition notices are sent from},
46
            AcquisitionsDefaultEmailAddress => q{Default email address that acquisition notices are sent from},
Lines 51-59 return { Link Here
51
            EnableBooking              => q{If enabled, activate every functionalities related with Bookings module},
58
            EnableBooking              => q{If enabled, activate every functionalities related with Bookings module},
52
            HoldCancellationRequestSIP => q{Option to set holds cancelled via SIP as cancellation requests},
59
            HoldCancellationRequestSIP => q{Option to set holds cancelled via SIP as cancellation requests},
53
            HoldRatioDefault           => q{Default value for the hold ratio report},
60
            HoldRatioDefault           => q{Default value for the hold ratio report},
61
            'ILS-DI:AuthorizedIPs'     => q{Restricts usage of ILS-DI to some IPs},
54
            ILLModule                  => q{If ON, enables the interlibrary loans module.},
62
            ILLModule                  => q{If ON, enables the interlibrary loans module.},
55
            OPACLoginLabelTextContent  => q{Control the text displayed on the login form},
63
            LibrisKey                  =>
56
            OpacHiddenItems            =>
64
                q{This key must be obtained at http://api.libris.kb.se/. It is unique for the IP of the server.},
65
            LibrisURL                 => q{This is the base URL for the Libris spellchecking API.},
66
            OPACLoginLabelTextContent => q{Control the text displayed on the login form},
67
            OpacHiddenItems           =>
57
                q{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.},
68
                q{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.},
58
            OPACShowLibraries =>
69
            OPACShowLibraries =>
59
                q{If enabled, a "Libraries" link appears in the OPAC pointing to a page with library information},
70
                q{If enabled, a "Libraries" link appears in the OPAC pointing to a page with library information},
Lines 62-67 return { Link Here
62
            OPACVirtualCard        => q{If ON, the patron virtual library card tab in the OPAC will be enabled},
73
            OPACVirtualCard        => q{If ON, the patron virtual library card tab in the OPAC will be enabled},
63
            OPACVirtualCardBarcode =>
74
            OPACVirtualCardBarcode =>
64
                q{Specify the type of barcode to be used in the patron virtual library card tab in the OPAC},
75
                q{Specify the type of barcode to be used in the patron virtual library card tab in the OPAC},
76
            OrderPdfFormat                          => q{Controls what script is used for printing (basketgroups)},
65
            PatronSelfRegistrationEmailMustBeUnique =>
77
            PatronSelfRegistrationEmailMustBeUnique =>
66
                q{If set, the field borrowers.email will be considered as a unique field on self-registering},
78
                q{If set, the field borrowers.email will be considered as a unique field on self-registering},
67
            PatronSelfRegistrationPrefillForm =>
79
            PatronSelfRegistrationPrefillForm =>
Lines 75-80 return { Link Here
75
                q{Separate current branch holdings and holdings from libraries in the same library groups},
87
                q{Separate current branch holdings and holdings from libraries in the same library groups},
76
            ShowHeadingUse =>
88
            ShowHeadingUse =>
77
                q{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},
89
                q{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},
90
            SubfieldsToAllowForRestrictedBatchmod =>
91
                q{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},
92
            SubfieldsToAllowForRestrictedEditing =>
93
                q{Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j},
78
            SuggestionsLog               => q{If ON, log purchase suggestion changes},
94
            SuggestionsLog               => q{If ON, log purchase suggestion changes},
79
            SuspendHoldsIntranet         => q{Allow holds to be suspended from the intranet.},
95
            SuspendHoldsIntranet         => q{Allow holds to be suspended from the intranet.},
80
            SuspendHoldsOpac             => q{Allow holds to be suspended from the OPAC.},
96
            SuspendHoldsOpac             => q{Allow holds to be suspended from the OPAC.},
Lines 116-122 return { Link Here
116
            q{
132
            q{
117
                UPDATE systempreferences
133
                UPDATE systempreferences
118
                SET options=NULL
134
                SET options=NULL
119
                WHERE type="YesNo";
135
                WHERE type="YesNo" OR type="Free";
120
            }
136
            }
121
        );
137
        );
122
138
Lines 151-155 return { Link Here
151
                WHERE variable="OPACLoginLabelTextContent";
167
                WHERE variable="OPACLoginLabelTextContent";
152
            }
168
            }
153
        );
169
        );
170
171
        $dbh->do(
172
            q{
173
                UPDATE systempreferences
174
                SET type='Choice', options='PHOTOCOPY|SCAN'
175
                WHERE variable="ArticleRequestsSupportedFormats";
176
            }
177
        );
154
    },
178
    },
155
};
179
};
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-79 / +78 lines)
Lines 17-28 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
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 ON, 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'),
26
('AgeRestrictionOverride','0',NULL,'Allow staff to check out an item with age restriction.','YesNo'),
26
('AgeRestrictionOverride','0',NULL,'Allow staff to check out an item with age restriction.','YesNo'),
27
('AggressiveMatchOnISBN','0', NULL,'If enabled, attempt to match aggressively by trying all variations of the ISBNs in the imported record as a phrase in the ISBN fields of already cataloged records when matching on ISBN with the record import tool','YesNo'),
27
('AggressiveMatchOnISBN','0', NULL,'If enabled, attempt to match aggressively by trying all variations of the ISBNs in the imported record as a phrase in the ISBN fields of already cataloged records when matching on ISBN with the record import tool','YesNo'),
28
('AggressiveMatchOnISSN','0', NULL,'If enabled, attempt to match aggressively by trying all variations of the ISSNs in the imported record as a phrase in the ISSN fields of already cataloged records when matching on ISSN with the record import tool','YesNo'),
28
('AggressiveMatchOnISSN','0', NULL,'If enabled, attempt to match aggressively by trying all variations of the ISSNs in the imported record as a phrase in the ISSN fields of already cataloged records when matching on ISSN with the record import tool','YesNo'),
Lines 53-64 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
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'),
56
('alphabet','A B C D E F G H I J K L M N O P Q R S T U V W X Y Z',NULL,'Alphabet than can be expanded into browse links, e.g. on Home > Patrons','free'),
56
('alphabet','A B C D E F G H I J K L M N O P Q R S T U V W X Y Z',NULL,'Alphabet than can be expanded into browse links, e.g. on Home > Patrons','Free'),
57
('AlternateHoldingsField','',NULL,'The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).','free'),
57
('AlternateHoldingsField','',NULL,'The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).','Free'),
58
('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','free'),
58
('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','Free'),
59
('AlwaysLoadCheckoutsTable','0',NULL,'Option to always load the checkout table','YesNo'),
59
('AlwaysLoadCheckoutsTable','0',NULL,'Option to always load the checkout table','YesNo'),
60
('AlwaysShowHoldingsTableFilters','0',NULL,'Option to always show filters when loading the holdings table','YesNo'),
60
('AlwaysShowHoldingsTableFilters','0',NULL,'Option to always show filters when loading the holdings table','YesNo'),
61
('AmazonAssocTag','',NULL,'See:  http://aws.amazon.com','free'),
61
('AmazonAssocTag','',NULL,'See:  http://aws.amazon.com','Free'),
62
('AmazonCoverImages','0',NULL,'Display Cover Images in staff interface from Amazon Web Services','YesNo'),
62
('AmazonCoverImages','0',NULL,'Display Cover Images in staff interface from Amazon Web Services','YesNo'),
63
('AmazonLocale','US','US|CA|DE|FR|IN|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
63
('AmazonLocale','US','US|CA|DE|FR|IN|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
64
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
64
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
Lines 71-77 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
71
('ArticleRequestsMandatoryFieldsItemOnly', '', NULL, 'Comma delimited list of required fields for bibs where article requests rule = \'item_only\'', 'multiple'),
71
('ArticleRequestsMandatoryFieldsItemOnly', '', NULL, 'Comma delimited list of required fields for bibs where article requests rule = \'item_only\'', 'multiple'),
72
('ArticleRequestsMandatoryFieldsRecordOnly', '', NULL, 'Comma delimited list of required fields for bibs where article requests rule = \'bib_only\'', 'multiple'),
72
('ArticleRequestsMandatoryFieldsRecordOnly', '', NULL, 'Comma delimited list of required fields for bibs where article requests rule = \'bib_only\'', 'multiple'),
73
('ArticleRequestsOpacHostRedirection', '0', NULL, 'Enables redirection from child to host when requesting articles on the Opac', 'YesNo'),
73
('ArticleRequestsOpacHostRedirection', '0', NULL, 'Enables redirection from child to host when requesting articles on the Opac', 'YesNo'),
74
('ArticleRequestsSupportedFormats', 'PHOTOCOPY', 'PHOTOCOPY|SCAN', 'List supported formats between vertical bars', 'free'),
74
('ArticleRequestsSupportedFormats', 'PHOTOCOPY', 'PHOTOCOPY|SCAN', 'List supported formats between vertical bars', 'Choice'),
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'),
Lines 79-85 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
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'),
82
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
82
('AuthoritySeparator','--',NULL,'Used to separate a list of authorities in a display. Usually --','Free'),
83
('AuthorityXSLTDetailsDisplay','',NULL,'Enable XSL stylesheet control over authority details page display on intranet','Free'),
83
('AuthorityXSLTDetailsDisplay','',NULL,'Enable XSL stylesheet control over authority details page display on intranet','Free'),
84
('AuthorityXSLTOpacDetailsDisplay','',NULL,'Enable XSL stylesheet control over authority details page in the OPAC','Free'),
84
('AuthorityXSLTOpacDetailsDisplay','',NULL,'Enable XSL stylesheet control over authority details page in the OPAC','Free'),
85
('AuthorityXSLTOpacResultsDisplay','',NULL,'Enable XSL stylesheet control over authority results page in the OPAC','Free'),
85
('AuthorityXSLTOpacResultsDisplay','',NULL,'Enable XSL stylesheet control over authority results page in the OPAC','Free'),
Lines 107-114 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
107
('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'),
107
('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'),
108
('AutoReturnCheckedOutItems', '0', NULL, 'If disabled, librarian must confirm return of checked out item when checking out to another.', 'YesNo'),
108
('AutoReturnCheckedOutItems', '0', NULL, 'If disabled, librarian must confirm return of checked out item when checking out to another.', 'YesNo'),
109
('AutoSelfCheckAllowed','0',NULL,'For corporate and special libraries which want web-based self-check available from any PC without the need for a manual staff login. Most libraries will want to leave this turned off. If on, requires self-check ID and password to be entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.','YesNo'),
109
('AutoSelfCheckAllowed','0',NULL,'For corporate and special libraries which want web-based self-check available from any PC without the need for a manual staff login. Most libraries will want to leave this turned off. If on, requires self-check ID and password to be entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.','YesNo'),
110
('AutoSelfCheckID','',NULL,'Staff ID with circulation rights to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','free'),
110
('AutoSelfCheckID','',NULL,'Staff ID with circulation rights to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','Free'),
111
('AutoSelfCheckPass','',NULL,'Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','free'),
111
('AutoSelfCheckPass','',NULL,'Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','Free'),
112
('AutoShareWithMana','subscription',NULL,'defines datas automatically shared with mana','multiple'),
112
('AutoShareWithMana','subscription',NULL,'defines datas automatically shared with mana','multiple'),
113
('AutoSwitchPatron', '0', NULL, 'Auto switch to patron', 'YesNo'),
113
('AutoSwitchPatron', '0', NULL, 'Auto switch to patron', 'YesNo'),
114
('Babeltheque','0',NULL,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','YesNo'),
114
('Babeltheque','0',NULL,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','YesNo'),
Lines 128-139 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
128
('BlockExpiredPatronOpacActions','','hold,renew,ill_request','Specific actions expired patrons of this category are blocked from performing. OPAC actions blocked based on the patron category take priority over this preference.','multiple'),
128
('BlockExpiredPatronOpacActions','','hold,renew,ill_request','Specific actions expired patrons of this category are blocked from performing. OPAC actions blocked based on the patron category take priority over this preference.','multiple'),
129
('BlockReturnOfLostItems','0',NULL,'If enabled, items that are marked as lost cannot be returned.','YesNo'),
129
('BlockReturnOfLostItems','0',NULL,'If enabled, items that are marked as lost cannot be returned.','YesNo'),
130
('BlockReturnOfWithdrawnItems','1',NULL,'If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
130
('BlockReturnOfWithdrawnItems','1',NULL,'If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
131
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','free'),
131
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','Free'),
132
('borrowerRelationship','father|mother',NULL,'Define valid relationships between a guarantor & a guarantee (separated by | or ,)','free'),
132
('borrowerRelationship','father|mother',NULL,'Define valid relationships between a guarantor & a guarantee (separated by | or ,)','Free'),
133
('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'),
133
('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
('BorrowersLog','1',NULL,'If ON, log edit/create/delete actions on patron data','YesNo'),
134
('BorrowersLog','1',NULL,'If ON, log edit/create/delete actions on patron data','YesNo'),
135
('BorrowersTitles','Mr|Mrs|Miss|Ms',NULL,'Define appropriate Titles for patrons','free'),
135
('BorrowersTitles','Mr|Mrs|Miss|Ms',NULL,'Define appropriate Titles for patrons','Free'),
136
('BorrowerUnwantedField','',NULL,'Name the fields you don\'t need to store for a patron\'s account','free'),
136
('BorrowerUnwantedField','',NULL,'Name the fields you don\'t need to store for a patron\'s account','Free'),
137
('BranchTransferLimitsType','ccode','itemtype|ccode','When using branch transfer limits, choose whether to limit by itemtype or collection code.','Choice'),
137
('BranchTransferLimitsType','ccode','itemtype|ccode','When using branch transfer limits, choose whether to limit by itemtype or collection code.','Choice'),
138
('BrowseResultSelection','0',NULL,'Enable/Disable browsing search results fromt the bibliographic record detail page in staff interface','YesNo'),
138
('BrowseResultSelection','0',NULL,'Enable/Disable browsing search results fromt the bibliographic record detail page in staff interface','YesNo'),
139
('BundleLostValue','5',NULL,'Sets the LOST AV value that represents "Missing from bundle" as a lost value','Free'),
139
('BundleLostValue','5',NULL,'Sets the LOST AV value that represents "Missing from bundle" as a lost value','Free'),
Lines 152-163 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
152
('casServerUrl','https://localhost:8443/cas',NULL,'URL of the cas server','Free'),
152
('casServerUrl','https://localhost:8443/cas',NULL,'URL of the cas server','Free'),
153
('casServerVersion','2', '2|3','Version of the CAS server Koha will connect to.','Choice'),
153
('casServerVersion','2', '2|3','Version of the CAS server Koha will connect to.','Choice'),
154
('CatalogConcerns', '0', NULL, 'Allow users to report catalog concerns', 'YesNo'),
154
('CatalogConcerns', '0', NULL, 'Allow users to report catalog concerns', 'YesNo'),
155
('CatalogerEmails', '', NULL, 'Notify these catalogers by email when a catalog concern is submitted', 'free'),
155
('CatalogerEmails', '', NULL, 'Notify these catalogers by email when a catalog concern is submitted', 'Free'),
156
('CatalogModuleRelink','0',NULL,'If OFF the linker will never replace the authids that are set in the cataloging module.','YesNo'),
156
('CatalogModuleRelink','0',NULL,'If OFF the linker will never replace the authids that are set in the cataloging module.','YesNo'),
157
('CataloguingLog','1',NULL,'If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'),
157
('CataloguingLog','1',NULL,'If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'),
158
('ChargeFinesOnClosedDays','0',NULL,'Charge fines on days the library is closed.','YesNo'),
158
('ChargeFinesOnClosedDays','0',NULL,'Charge fines on days the library is closed.','YesNo'),
159
('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'),
159
('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
('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'),
160
('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
('ChildNeedsGuarantor','0',NULL,'If ON, a child patron must have a guarantor when adding the patron.','YesNo'),
161
('ChildNeedsGuarantor','0',NULL,'If ON, a child patron must have a guarantor when adding the patron.','YesNo'),
162
('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'),
162
('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
('CircConfirmItemParts', '0', NULL, 'Require staff to confirm that all parts of an item are present at checkin/checkout.', 'YesNo'),
163
('CircConfirmItemParts', '0', NULL, 'Require staff to confirm that all parts of an item are present at checkin/checkout.', 'YesNo'),
Lines 191-197 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
191
('CurbsidePickup', '0', NULL, 'Enable curbside pickup', 'YesNo'),
191
('CurbsidePickup', '0', NULL, 'Enable curbside pickup', 'YesNo'),
192
('CurrencyFormat','US','US|FR|CH','Determines the display format of currencies. eg: \'36000\' is displayed as \'360 000,00\'  in \'FR\' or \'360,000.00\'  in \'US\'.','Choice'),
192
('CurrencyFormat','US','US|FR|CH','Determines the display format of currencies. eg: \'36000\' is displayed as \'360 000,00\'  in \'FR\' or \'360,000.00\'  in \'US\'.','Choice'),
193
('CustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed in the staff interface. CustomCoverImagesURL must be defined.','YesNo'),
193
('CustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed in the staff interface. CustomCoverImagesURL must be defined.','YesNo'),
194
('CustomCoverImagesURL','',NULL,'Define an URL serving book cover images, using the following patterns: %issn%, %isbn%, FIXME ADD MORE (use it with CustomCoverImages and/or OPACCustomCoverImages)','free'),
194
('CustomCoverImagesURL','',NULL,'Define an URL serving book cover images, using the following patterns: %issn%, %isbn%, FIXME ADD MORE (use it with CustomCoverImages and/or OPACCustomCoverImages)','Free'),
195
('dateformat','us','metric|us|iso|dmydot','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)','Choice'),
195
('dateformat','us','metric|us|iso|dmydot','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)','Choice'),
196
('DebugLevel','2','0|1|2','Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','Choice'),
196
('DebugLevel','2','0|1|2','Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','Choice'),
197
('decreaseLoanHighHolds','0',NULL,'Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue','YesNo'),
197
('decreaseLoanHighHolds','0',NULL,'Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue','YesNo'),
Lines 213-219 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
213
('DefaultLongOverduePatronCategories', '', NULL, 'Set the patron categories that will be listed when longoverdue cronjob is executed', 'choice'),
213
('DefaultLongOverduePatronCategories', '', NULL, 'Set the patron categories that will be listed when longoverdue cronjob is executed', 'choice'),
214
('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost statuses by default in longoverdue.pl', 'Free'),
214
('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost statuses by default in longoverdue.pl', 'Free'),
215
('DefaultLongOverdueSkipPatronCategories', '', NULL, 'Set the patron categories that will not be listed when longoverdue cronjob is executed', 'choice'),
215
('DefaultLongOverdueSkipPatronCategories', '', NULL, 'Set the patron categories that will not be listed when longoverdue cronjob is executed', 'choice'),
216
('DefaultPatronSearchFields','firstname|preferred_name|middle_name|surname|othernames|cardnumber|userid',NULL,'Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname|surname|othernames|cardnumber|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','free'),
216
('DefaultPatronSearchFields','firstname|preferred_name|middle_name|surname|othernames|cardnumber|userid',NULL,'Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname|surname|othernames|cardnumber|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page.','Free'),
217
('DefaultPatronSearchMethod','starts_with','starts_with|contains','Choose which search method to use by default when searching with PatronAutoComplete','Choice'),
217
('DefaultPatronSearchMethod','starts_with','starts_with|contains','Choose which search method to use by default when searching with PatronAutoComplete','Choice'),
218
('DefaultSaveRecordFileID','biblionumber','biblionumber|controlnumber','Defines whether the advanced cataloging editor will use the bibliographic record number or control number field to populate the name of the save file','Choice'),
218
('DefaultSaveRecordFileID','biblionumber','biblionumber|controlnumber','Defines whether the advanced cataloging editor will use the bibliographic record number or control number field to populate the name of the save file','Choice'),
219
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
219
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
Lines 244-252 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
244
('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL),
244
('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL),
245
('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL),
245
('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL),
246
('ElasticsearchMARCFormat', 'base64ISO2709', 'base64ISO2709|ARRAY', 'Elasticsearch MARC format. ISO2709 format is recommended as it is faster and takes less space, whereas array is searchable.', 'Choice'),
246
('ElasticsearchMARCFormat', 'base64ISO2709', 'base64ISO2709|ARRAY', 'Elasticsearch MARC format. ISO2709 format is recommended as it is faster and takes less space, whereas array is searchable.', 'Choice'),
247
('ElasticsearchPreventAutoTruncate', 'barcode|control-number|control-number-identifier|date-of-acquisition|date-of-publication|date-time-last-modified|identifier-standard|isbn|issn|itype|lc-card-number|number-local-acquisition|other-control-number|record-control-number', NULL, 'List of searchfields (separated by | or ,) that should not be autotruncated by Elasticsearch even if QueryAutoTruncate is set to Yes', 'free'),
247
('ElasticsearchPreventAutoTruncate', 'barcode|control-number|control-number-identifier|date-of-acquisition|date-of-publication|date-time-last-modified|identifier-standard|isbn|issn|itype|lc-card-number|number-local-acquisition|other-control-number|record-control-number', NULL, 'List of searchfields (separated by | or ,) that should not be autotruncated by Elasticsearch even if QueryAutoTruncate is set to Yes', 'Free'),
248
('EmailAddressForPatronRegistrations', '', NULL, ' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ', 'free'),
248
('EmailAddressForPatronRegistrations', '', NULL, ' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ', 'Free'),
249
('EmailAddressForSuggestions','',NULL,' If you choose EmailAddressForSuggestions you have to enter a valid email address: ','free'),
249
('EmailAddressForSuggestions','',NULL,' If you choose EmailAddressForSuggestions you have to enter a valid email address: ','Free'),
250
('EmailFieldPrecedence','email|emailpro|B_email',NULL,'Ordered list of patron email fields to use when AutoEmailPrimaryAddress is set to first valid','multiple'),
250
('EmailFieldPrecedence','email|emailpro|B_email',NULL,'Ordered list of patron email fields to use when AutoEmailPrimaryAddress is set to first valid','multiple'),
251
('EmailFieldPrimary','','|email|emailpro|B_email|cardnumber|MULTI','Defines the default email address field where patron email notices are sent.','Choice'),
251
('EmailFieldPrimary','','|email|emailpro|B_email|cardnumber|MULTI','Defines the default email address field where patron email notices are sent.','Choice'),
252
('EmailFieldSelection','','email|emailpro|B_email','Selection list of patron email fields to use whern AutoEmailPrimaryAddress is set to selected addresses','multiple'),
252
('EmailFieldSelection','','email|emailpro|B_email','Selection list of patron email fields to use whern AutoEmailPrimaryAddress is set to selected addresses','multiple'),
Lines 268-282 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
268
('EnhancedMessagingPreferences','1',NULL,'If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
268
('EnhancedMessagingPreferences','1',NULL,'If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'),
269
('EnhancedMessagingPreferencesOPAC', '1', NULL, 'If ON, show patrons messaging setting on the OPAC.', 'YesNo'),
269
('EnhancedMessagingPreferencesOPAC', '1', NULL, 'If ON, show patrons messaging setting on the OPAC.', 'YesNo'),
270
('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'),
270
('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'),
271
('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'free'),
271
('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'Free'),
272
('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'free'),
272
('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'Free'),
273
('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'),
273
('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'),
274
('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If ON, reserves max pickup delay takes into accountthe closed days.', 'YesNo'),
274
('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If ON, reserves max pickup delay takes into accountthe closed days.', 'YesNo'),
275
('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'),
275
('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'),
276
('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'),
276
('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'),
277
('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'),
277
('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
('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'),
278
('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
('ExpireReservesMaxPickUpDelayCharge','0',NULL,'If ExpireReservesMaxPickUpDelay is enabled, and this field has a non-zero value, than a borrower whose waiting hold has expired will be charged this amount.','free'),
279
('ExpireReservesMaxPickUpDelayCharge','0',NULL,'If ExpireReservesMaxPickUpDelay is enabled, and this field has a non-zero value, than a borrower whose waiting hold has expired will be charged this amount.','Free'),
280
('ExpireReservesOnHolidays', '1', NULL, 'If false, reserves at a library will not be canceled on days the library is not open.', 'YesNo'),
280
('ExpireReservesOnHolidays', '1', NULL, 'If false, reserves at a library will not be canceled on days the library is not open.', 'YesNo'),
281
('ExportCircHistory', '0', NULL, 'Display the export circulation options', 'YesNo'),
281
('ExportCircHistory', '0', NULL, 'Display the export circulation options', 'YesNo'),
282
('ExportRemoveFields','',NULL,'List of fields for non export in circulation.pl (separated by a space)','Free'),
282
('ExportRemoveFields','',NULL,'List of fields for non export in circulation.pl (separated by a space)','Free'),
Lines 300-307 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
300
('ForcePasswordResetWhenSetByStaff','0',NULL,'Force a staff created patron account to reset its password after its first OPAC login.','YesNo'),
300
('ForcePasswordResetWhenSetByStaff','0',NULL,'Force a staff created patron account to reset its password after its first OPAC login.','YesNo'),
301
('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'),
301
('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
('FutureHoldsBlockRenewals', '0', NULL, 'Allow future holds to block renewals', 'YesNo' ),
302
('FutureHoldsBlockRenewals', '0', NULL, 'Allow future holds to block renewals', 'YesNo' ),
303
('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'),
303
('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
('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'),
304
('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
('GoogleJackets','0',NULL,'if ON, displays jacket covers from Google Books API','YesNo'),
305
('GoogleJackets','0',NULL,'if ON, displays jacket covers from Google Books API','YesNo'),
306
('GoogleOAuth2ClientID', '', NULL, 'Client ID for the web app registered with Google', 'Free'),
306
('GoogleOAuth2ClientID', '', NULL, 'Client ID for the web app registered with Google', 'Free'),
307
('GoogleOAuth2ClientSecret', '', NULL, 'Client Secret for the web app registered with Google', 'Free'),
307
('GoogleOAuth2ClientSecret', '', NULL, 'Client Secret for the web app registered with Google', 'Free'),
Lines 330-336 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
330
('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'),
330
('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
('HouseboundModule','0',NULL,'If ON, enable housebound module functionality.','YesNo'),
331
('HouseboundModule','0',NULL,'If ON, enable housebound module functionality.','YesNo'),
332
('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'),
332
('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'),
333
('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt',NULL,'Media file extensions','free'),
333
('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt',NULL,'Media file extensions','Free'),
334
('HTML5MediaYouTube','0',NULL,'YouTube links as videos','YesNo'),
334
('HTML5MediaYouTube','0',NULL,'YouTube links as videos','YesNo'),
335
('IdRef','0',NULL,'Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
335
('IdRef','0',NULL,'Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
336
('ILLCheckAvailability', '0', NULL, 'If ON, during the ILL request process third party sources will be checked for current availability', 'YesNo'),
336
('ILLCheckAvailability', '0', NULL, 'If ON, during the ILL request process third party sources will be checked for current availability', 'YesNo'),
Lines 343-353 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
343
('ILLModuleUnmediated','0',NULL,'If enabled, try to immediately progress newly placed ILL requests.','YesNo'),
343
('ILLModuleUnmediated','0',NULL,'If enabled, try to immediately progress newly placed ILL requests.','YesNo'),
344
('ILLOpacbackends','',NULL,'ILL backends to enabled for OPAC initiated requests','multiple'),
344
('ILLOpacbackends','',NULL,'ILL backends to enabled for OPAC initiated requests','multiple'),
345
('ILLOpacUnauthenticatedRequest','0',NULL,'Can OPAC users place ILL requests without having to be logged in','YesNo'),
345
('ILLOpacUnauthenticatedRequest','0',NULL,'Can OPAC users place ILL requests without having to be logged in','YesNo'),
346
('ILLPartnerCode','IL',NULL,'Patrons from this patron category will be used as partners to place ILL requests with','free'),
346
('ILLPartnerCode','IL',NULL,'Patrons from this patron category will be used as partners to place ILL requests with','Free'),
347
('ILLRequestsTabs','',NULL,'Add customizable tabs to interlibrary loan requests list','Textarea'),
347
('ILLRequestsTabs','',NULL,'Add customizable tabs to interlibrary loan requests list','Textarea'),
348
('ILLSendStaffNotices', '', NULL, 'Send these ILL notices to staff', 'multiple'),
348
('ILLSendStaffNotices', '', NULL, 'Send these ILL notices to staff', 'multiple'),
349
('ILS-DI','0',NULL,'Enables ILS-DI services at OPAC.','YesNo'),
349
('ILS-DI','0',NULL,'Enables ILS-DI services at OPAC.','YesNo'),
350
('ILS-DI:AuthorizedIPs','','Restricts usage of ILS-DI to some IPs','.','Free'),
350
('ILS-DI:AuthorizedIPs','',NULL,'Restricts usage of ILS-DI to some IPs','Free'),
351
('ImageLimit','5',NULL,'Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
351
('ImageLimit','5',NULL,'Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
352
('IncludeSeeAlsoFromInSearches','0',NULL,'Include see-also-from references in searches.','YesNo'),
352
('IncludeSeeAlsoFromInSearches','0',NULL,'Include see-also-from references in searches.','YesNo'),
353
('IncludeSeeFromInSearches','0',NULL,'Include see-from references in searches.','YesNo'),
353
('IncludeSeeFromInSearches','0',NULL,'Include see-from references in searches.','YesNo'),
Lines 360-374 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
360
('IntranetCatalogSearchPulldown','0', NULL, 'Show a search field pulldown for "Search the catalog" boxes','YesNo'),
360
('IntranetCatalogSearchPulldown','0', NULL, 'Show a search field pulldown for "Search the catalog" boxes','YesNo'),
361
('IntranetCirculationHomeHTML', '', NULL, 'Show the following HTML in a div on the bottom of the reports home page', 'Free'),
361
('IntranetCirculationHomeHTML', '', NULL, 'Show the following HTML in a div on the bottom of the reports home page', 'Free'),
362
('IntranetCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the staff interface', 'YesNo'),
362
('IntranetCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the staff interface', 'YesNo'),
363
('intranetcolorstylesheet','','50','Define the color stylesheet to use in the staff interface','free'),
363
('intranetcolorstylesheet','',NULL,'Define the color stylesheet to use in the staff interface','Free'),
364
('IntranetFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the staff interface','free'),
364
('IntranetFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the staff interface','Free'),
365
('IntranetNav','','70|10','Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface','Textarea'),
365
('IntranetNav','','70|10','Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface','Textarea'),
366
('IntranetNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number staff interface searches','YesNo'),
366
('IntranetNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number staff interface searches','YesNo'),
367
('intranetreadinghistory','1',NULL,'If ON, Checkout history is enabled for all patrons','YesNo'),
367
('intranetreadinghistory','1',NULL,'If ON, Checkout history is enabled for all patrons','YesNo'),
368
('IntranetReadingHistoryHolds', '1', NULL, 'If ON, Holds history is enabled for all patrons','YesNo'),
368
('IntranetReadingHistoryHolds', '1', NULL, 'If ON, Holds history is enabled for all patrons','YesNo'),
369
('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'),
369
('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'),
370
('intranetstylesheet','','50','Enter a complete URL to use an alternate layout stylesheet in Intranet','free'),
370
('intranetstylesheet','',NULL,'Enter a complete URL to use an alternate layout stylesheet in Intranet','Free'),
371
('IntranetUserCSS','',NULL,'Add CSS to be included in the intranet in an embedded <style> tag.','free'),
371
('IntranetUserCSS','',NULL,'Add CSS to be included in the intranet in an embedded <style> tag.','Free'),
372
('IntranetUserJS','','70|10','Custom javascript for inclusion in Intranet','Textarea'),
372
('IntranetUserJS','','70|10','Custom javascript for inclusion in Intranet','Textarea'),
373
('intranet_includes','includes',NULL,'The includes directory you want for specific look of Koha (includes or includes_npl for example)','Free'),
373
('intranet_includes','includes',NULL,'The includes directory you want for specific look of Koha (includes or includes_npl for example)','Free'),
374
('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'),
374
('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'),
Lines 378-402 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
378
('item-level_itypes','1',NULL,'If ON, enables Item-level Itemtype / Issuing Rules','YesNo'),
378
('item-level_itypes','1',NULL,'If ON, enables Item-level Itemtype / Issuing Rules','YesNo'),
379
('itemBarcodeFallbackSearch','0',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
379
('itemBarcodeFallbackSearch','0',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
380
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
380
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
381
('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'),
381
('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
('ItemsDeniedRenewal','',NULL,'This syspref allows to define custom rules for denying renewal of specific items.','Textarea'),
382
('ItemsDeniedRenewal','',NULL,'This syspref allows to define custom rules for denying renewal of specific items.','Textarea'),
383
('JobsNotificationMethod','STOMP','polling|STOMP','Define the preferred job worker notification method','Choice'),
383
('JobsNotificationMethod','STOMP','polling|STOMP','Define the preferred job worker notification method','Choice'),
384
('KohaAdminEmailAddress','root@localhost',NULL,'Define the email address where patron modification requests are sent','free'),
384
('KohaAdminEmailAddress','root@localhost',NULL,'Define the email address where patron modification requests are sent','Free'),
385
('KohaManualBaseURL','https://koha-community.org/manual/',NULL,'Where is the Koha manual/documentation located?','Free'),
385
('KohaManualBaseURL','https://koha-community.org/manual/',NULL,'Where is the Koha manual/documentation located?','Free'),
386
('KohaManualLanguage','en','el|en|ar|cs|de|es|fr|it|pt_BR|tr|zh_TW','What is the language of the online manual you want to use?','Choice'),
386
('KohaManualLanguage','en','el|en|ar|cs|de|es|fr|it|pt_BR|tr|zh_TW','What is the language of the online manual you want to use?','Choice'),
387
('LabelMARCView','standard','standard|economical','Define how a MARC record will display','Choice'),
387
('LabelMARCView','standard','standard|economical','Define how a MARC record will display','Choice'),
388
('LanguageToUseOnMerge','',NULL,'If set, the authority field having the given language code in its $7 subfield will be used in the bibliographic record if it exists, rather than the first field. The code can be in a short, 2 characters long form (example: ba for latin) or in a long, 8 characters long form, with the short form in position 5 and 6 starting from 1 (example: ba0yba0y for latin). A list of available codes can be found here: https://documentation.abes.fr/sudoc/formats/unmb/DonneesCodees/CodesZone104.htm#$d. Please note that this feature is available only for UNIMARC.','Free'),
388
('LanguageToUseOnMerge','',NULL,'If set, the authority field having the given language code in its $7 subfield will be used in the bibliographic record if it exists, rather than the first field. The code can be in a short, 2 characters long form (example: ba for latin) or in a long, 8 characters long form, with the short form in position 5 and 6 starting from 1 (example: ba0yba0y for latin). A list of available codes can be found here: https://documentation.abes.fr/sudoc/formats/unmb/DonneesCodees/CodesZone104.htm#$d. Please note that this feature is available only for UNIMARC.','Free'),
389
('LibraryName','',NULL,'Define the library name as displayed on the OPAC',''),
389
('LibraryName','',NULL,'Define the library name as displayed on the OPAC',''),
390
('LibraryThingForLibrariesEnabled','0',NULL,'Enable or Disable Library Thing for Libraries Features','YesNo'),
390
('LibraryThingForLibrariesEnabled','0',NULL,'Enable or Disable Library Thing for Libraries Features','YesNo'),
391
('LibraryThingForLibrariesID','',NULL,'See:http://librarything.com/forlibraries/','free'),
391
('LibraryThingForLibrariesID','',NULL,'See:http://librarything.com/forlibraries/','Free'),
392
('LibraryThingForLibrariesTabbedView','0',NULL,'Put LibraryThingForLibraries Content in Tabs.','YesNo'),
392
('LibraryThingForLibrariesTabbedView','0',NULL,'Put LibraryThingForLibraries Content in Tabs.','YesNo'),
393
('LibrisKey', '', 'This key must be obtained at http://api.libris.kb.se/. It is unique for the IP of the server.', NULL, 'Free'),
393
('LibrisKey', '', NULL, 'This key must be obtained at http://api.libris.kb.se/. It is unique for the IP of the server.', 'Free'),
394
('LibrisURL', 'http://api.libris.kb.se/bibspell/', 'This it the base URL for the Libris spellchecking API.',NULL,'Free'),
394
('LibrisURL', 'http://api.libris.kb.se/bibspell/', NULL, 'This is the base URL for the Libris spellchecking API.','Free'),
395
('LinkerConsiderDiacritics', '0', NULL, 'Linker should consider diacritics', 'YesNo'),
395
('LinkerConsiderDiacritics', '0', NULL, 'Linker should consider diacritics', 'YesNo'),
396
('LinkerConsiderThesaurus','0',NULL,'If ON the authority linker will only search for 6XX authorities from the same source as the heading','YesNo'),
396
('LinkerConsiderThesaurus','0',NULL,'If ON the authority linker will only search for 6XX authorities from the same source as the heading','YesNo'),
397
('LinkerKeepStale','0',NULL,'If ON the authority linker will keep existing authority links for headings where it is unable to find a match.','YesNo'),
397
('LinkerKeepStale','0',NULL,'If ON the authority linker will keep existing authority links for headings where it is unable to find a match.','YesNo'),
398
('LinkerModule','Default','Default|FirstMatch|LastMatch','Chooses which linker module to use (see documentation).','Choice'),
398
('LinkerModule','Default','Default|FirstMatch|LastMatch','Chooses which linker module to use (see documentation).','Choice'),
399
('LinkerOptions','',NULL,'A pipe-separated list of options for the linker.','free'),
399
('LinkerOptions','',NULL,'A pipe-separated list of options for the linker.','Free'),
400
('LinkerRelink','1',NULL,'If ON the authority linker will relink headings that have previously been linked every time it runs.','YesNo'),
400
('LinkerRelink','1',NULL,'If ON the authority linker will relink headings that have previously been linked every time it runs.','YesNo'),
401
('ListOwnerDesignated', '', NULL, 'Designated list owner at patron deletion', 'Free'),
401
('ListOwnerDesignated', '', NULL, 'Designated list owner at patron deletion', 'Free'),
402
('ListOwnershipUponPatronDeletion', 'delete', 'delete|transfer|transfer_public', 'Defines the action on their public or shared lists when patron is deleted', 'Choice'),
402
('ListOwnershipUponPatronDeletion', 'delete', 'delete|transfer|transfer_public', 'Defines the action on their public or shared lists when patron is deleted', 'Choice'),
Lines 411-417 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
411
('Mana','2',NULL,'request to Mana Webservice. Mana centralize common information between other Koha to facilitate the creation of new subscriptions, vendors, report queries etc... You can search, share, import and comment the content of Mana.','Choice'),
411
('Mana','2',NULL,'request to Mana Webservice. Mana centralize common information between other Koha to facilitate the creation of new subscriptions, vendors, report queries etc... You can search, share, import and comment the content of Mana.','Choice'),
412
('ManaToken','',NULL,'Security token used for authentication on Mana KB service (anti spam)','Textarea'),
412
('ManaToken','',NULL,'Security token used for authentication on Mana KB service (anti spam)','Textarea'),
413
('MARCAuthorityControlField008','|| aca||aabn           | a|a     d',NULL,'Define the contents of MARC21 authority control field 008 position 06-39','Textarea'),
413
('MARCAuthorityControlField008','|| aca||aabn           | a|a     d',NULL,'Define the contents of MARC21 authority control field 008 position 06-39','Textarea'),
414
('MarcFieldDocURL', '', NULL, 'URL used for MARC field documentation. Following substitutions are available: {MARC} = marc flavour, eg. "MARC21" or "UNIMARC". {FIELD} = field number, eg. "000" or "048". {LANG} = user language, eg. "en" or "fi-FI"', 'free'),
414
('MarcFieldDocURL', '', NULL, 'URL used for MARC field documentation. Following substitutions are available: {MARC} = marc flavour, eg. "MARC21" or "UNIMARC". {FIELD} = field number, eg. "000" or "048". {LANG} = user language, eg. "en" or "fi-FI"', 'Free'),
415
('MarcFieldForCreatorId','',NULL,'Where to store the borrowernumber of the record\'s creator','Free'),
415
('MarcFieldForCreatorId','',NULL,'Where to store the borrowernumber of the record\'s creator','Free'),
416
('MarcFieldForCreatorName','',NULL,'Where to store the name of the record\'s creator','Free'),
416
('MarcFieldForCreatorName','',NULL,'Where to store the name of the record\'s creator','Free'),
417
('MarcFieldForModifierId','',NULL,'Where to store the borrowernumber of the record\'s last modifier','Free'),
417
('MarcFieldForModifierId','',NULL,'Where to store the borrowernumber of the record\'s last modifier','Free'),
Lines 419-430 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
419
('MarcFieldsToOrder','',NULL,'Set the mapping values for a new order line created from a MARC record in a staged file. In a YAML format.','textarea'),
419
('MarcFieldsToOrder','',NULL,'Set the mapping values for a new order line created from a MARC record in a staged file. In a YAML format.','textarea'),
420
('MarcItemFieldsToOrder','',NULL,'Set the mapping values for new item records created from a MARC record in a staged file. In a YAML format.','textarea'),
420
('MarcItemFieldsToOrder','',NULL,'Set the mapping values for new item records created from a MARC record in a staged file. In a YAML format.','textarea'),
421
('MarcOrderingAutomation','0',NULL,'Enables automatic order line creation from MARC records','YesNo'),
421
('MarcOrderingAutomation','0',NULL,'Enables automatic order line creation from MARC records','YesNo'),
422
('MARCOrgCode','OSt',NULL,'Define MARC Organization Code for MARC21 records - http://www.loc.gov/marc/organizations/orgshome.html','free'),
422
('MARCOrgCode','OSt',NULL,'Define MARC Organization Code for MARC21 records - http://www.loc.gov/marc/organizations/orgshome.html','Free'),
423
('MARCOverlayRules','0',NULL,'Use the MARC record overlay rules system to decide what actions to take for each field when modifying records.','YesNo'),
423
('MARCOverlayRules','0',NULL,'Use the MARC record overlay rules system to decide what actions to take for each field when modifying records.','YesNo'),
424
('MarkLostItemsAsReturned','batchmod,moredetail,cronjob,additem,pendingreserves,onpayment','claim_returned|batchmod|moredetail|cronjob|additem|pendingreserves|onpayment','Mark items as returned when flagged as lost','multiple'),
424
('MarkLostItemsAsReturned','batchmod,moredetail,cronjob,additem,pendingreserves,onpayment','claim_returned|batchmod|moredetail|cronjob|additem|pendingreserves|onpayment','Mark items as returned when flagged as lost','multiple'),
425
('MaxComponentRecords', '300', NULL,'Max number of component records to display','Integer'),
425
('MaxComponentRecords', '300', NULL,'Max number of component records to display','Integer'),
426
('MaxFine','',NULL,'Maximum fine a patron can have for all late returns at one moment. Single item caps are specified in the circulation rules matrix.','Integer'),
426
('MaxFine','',NULL,'Maximum fine a patron can have for all late returns at one moment. Single item caps are specified in the circulation rules matrix.','Integer'),
427
('maxItemsInSearchResults','20',NULL,'Specify the maximum number of items to display for each result on a page of results','free'),
427
('maxItemsInSearchResults','20',NULL,'Specify the maximum number of items to display for each result on a page of results','Free'),
428
('MaxItemsToDisplayForBatchDel','1000',NULL,'Display up to a given number of items in a single item deletionbatch.','Integer'),
428
('MaxItemsToDisplayForBatchDel','1000',NULL,'Display up to a given number of items in a single item deletionbatch.','Integer'),
429
('MaxItemsToDisplayForBatchMod','1000',NULL,'Display up to a given number of items in a single item modification batch.','Integer'),
429
('MaxItemsToDisplayForBatchMod','1000',NULL,'Display up to a given number of items in a single item modification batch.','Integer'),
430
('MaxItemsToProcessForBatchMod','1000',NULL,'Process up to a given number of items in a single item modification batch.','Integer'),
430
('MaxItemsToProcessForBatchMod','1000',NULL,'Process up to a given number of items in a single item modification batch.','Integer'),
Lines 436-442 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
436
('MaxTotalSuggestions','',NULL,'Number of total suggestions used for time limit with NumberOfSuggestionDays','Free'),
436
('MaxTotalSuggestions','',NULL,'Number of total suggestions used for time limit with NumberOfSuggestionDays','Free'),
437
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
437
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
438
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
438
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
439
('minPasswordLength','8',NULL,'Specify the minimum length of a patron/staff password','free'),
439
('minPasswordLength','8',NULL,'Specify the minimum length of a patron/staff password','Free'),
440
('NewItemsDefaultLocation','',NULL,'If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
440
('NewItemsDefaultLocation','',NULL,'If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
441
('NewsAuthorDisplay','none','none|opac|staff|both','Display the author name for news items.','Choice'),
441
('NewsAuthorDisplay','none','none|opac|staff|both','Display the author name for news items.','Choice'),
442
('noissuescharge','5',NULL,'Define maximum amount withstanding before checkouts are blocked','Integer'),
442
('noissuescharge','5',NULL,'Define maximum amount withstanding before checkouts are blocked','Integer'),
Lines 446-463 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
446
('NoRefundOnLostFinesPaidAge','',NULL,'Do not refund lost item fees if the fee was paid off more than this number of days ago','Integer'),
446
('NoRefundOnLostFinesPaidAge','',NULL,'Do not refund lost item fees if the fee was paid off more than this number of days ago','Integer'),
447
('NoRefundOnLostReturnedItemsAge','',NULL,'Do not refund lost item fees if item is lost for more than this number of days','Integer'),
447
('NoRefundOnLostReturnedItemsAge','',NULL,'Do not refund lost item fees if item is lost for more than this number of days','Integer'),
448
('NoRenewalBeforePrecision','exact_time','date|exact_time','Calculate "No renewal before" based on date only or exact time of due date','Choice'),
448
('NoRenewalBeforePrecision','exact_time','date|exact_time','Calculate "No renewal before" based on date only or exact time of due date','Choice'),
449
('NotesToHide','',NULL,'List of notes fields that should not appear in the title notes/description separator of details','free'),
449
('NotesToHide','',NULL,'List of notes fields that should not appear in the title notes/description separator of details','Free'),
450
('NotHighlightedWords','and|or|not',NULL,'List of words to NOT highlight when OpacHitHighlight is enabled','free'),
450
('NotHighlightedWords','and|or|not',NULL,'List of words to NOT highlight when OpacHitHighlight is enabled','Free'),
451
('NoticeBcc','',NULL,'Email address to bcc outgoing notices sent by email','free'),
451
('NoticeBcc','',NULL,'Email address to bcc outgoing notices sent by email','Free'),
452
('NoticeCSS','',NULL,'Notices CSS url.','free'),
452
('NoticeCSS','',NULL,'Notices CSS url.','Free'),
453
('NoticesLog','0',NULL,'If enabled, log changes to notice templates','YesNo'),
453
('NoticesLog','0',NULL,'If enabled, log changes to notice templates','YesNo'),
454
('NotifyBorrowerDeparture','30',NULL,'Define number of days before expiry where circulation is warned about patron account expiry','Integer'),
454
('NotifyBorrowerDeparture','30',NULL,'Define number of days before expiry where circulation is warned about patron account expiry','Integer'),
455
('NotifyPasswordChange','1',NULL,'Notify patrons whenever their password is changed.','YesNo'),
455
('NotifyPasswordChange','1',NULL,'Notify patrons whenever their password is changed.','YesNo'),
456
('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content.  Requires Novelist Profile and Password','YesNo'),
456
('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content.  Requires Novelist Profile and Password','YesNo'),
457
('NovelistSelectPassword','',NULL,'Novelist select user Password','free'),
457
('NovelistSelectPassword','',NULL,'Novelist select user Password','Free'),
458
('NovelistSelectProfile','',NULL,'Novelist Select user Profile','free'),
458
('NovelistSelectProfile','',NULL,'Novelist Select user Profile','Free'),
459
('NovelistSelectStaffEnabled','0',NULL,'Enable Novelist Select content in the staff interface.  Requires Novelist Profile and Password','YesNo'),
459
('NovelistSelectStaffEnabled','0',NULL,'Enable Novelist Select content in the staff interface.  Requires Novelist Profile and Password','YesNo'),
460
('NovelistSelectStaffProfile','',NULL,'Novelist Select user Profile for staff interface','free'),
460
('NovelistSelectStaffProfile','',NULL,'Novelist Select user Profile for staff interface','Free'),
461
('NovelistSelectStaffView','tab','tab|above|below','Where to display Novelist Select content in the staff interface','Choice'),
461
('NovelistSelectStaffView','tab','tab|above|below','Where to display Novelist Select content in the staff interface','Choice'),
462
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
462
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
463
('NumberOfSuggestionDays','',NULL,'Number of days that will be used to determine the MaxTotalSuggestions limit','Free'),
463
('NumberOfSuggestionDays','',NULL,'Number of days that will be used to determine the MaxTotalSuggestions limit','Free'),
Lines 477-483 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
477
('OnSiteCheckouts','0',NULL,'Enable/Disable the on-site checkouts feature','YesNo'),
477
('OnSiteCheckouts','0',NULL,'Enable/Disable the on-site checkouts feature','YesNo'),
478
('OnSiteCheckoutsForce','0',NULL,'Enable/Disable the on-site for all cases (Even if a user is debarred, etc.)','YesNo'),
478
('OnSiteCheckoutsForce','0',NULL,'Enable/Disable the on-site for all cases (Even if a user is debarred, etc.)','YesNo'),
479
('OPACAcquisitionDetails','0',NULL,'Show the acquisition details at the OPAC','YesNo'),
479
('OPACAcquisitionDetails','0',NULL,'Show the acquisition details at the OPAC','YesNo'),
480
('OpacAdditionalStylesheet','',NULL,'Define an auxiliary stylesheet for OPAC use, to override specified settings from the primary opac.css stylesheet. Enter the filename (if the file is in the server\'s css directory) or a complete URL beginning with http (if the file lives on a remote server).','free'),
480
('OpacAdditionalStylesheet','',NULL,'Define an auxiliary stylesheet for OPAC use, to override specified settings from the primary opac.css stylesheet. Enter the filename (if the file is in the server\'s css directory) or a complete URL beginning with http (if the file lives on a remote server).','Free'),
481
('OpacAddMastheadLibraryPulldown','0',NULL,'Adds a pulldown menu to select the library to search on the opac masthead.','YesNo'),
481
('OpacAddMastheadLibraryPulldown','0',NULL,'Adds a pulldown menu to select the library to search on the opac masthead.','YesNo'),
482
('OpacAdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields are available as limits on the OPAC advanced search page','Choice'),
482
('OpacAdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields are available as limits on the OPAC advanced search page','Choice'),
483
('OpacAdvSearchMoreOptions','pubdate,itemtype,language,subtype,sorting,location','Show search options for the expanded view (More options)','pubdate|itemtype|language|subtype|sorting|location','multiple'),
483
('OpacAdvSearchMoreOptions','pubdate,itemtype,language,subtype,sorting,location','Show search options for the expanded view (More options)','pubdate|itemtype|language|subtype|sorting|location','multiple'),
Lines 508-514 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
508
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
508
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
509
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd',NULL,'Define export options available on OPAC detail page.','multiple'),
509
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd',NULL,'Define export options available on OPAC detail page.','multiple'),
510
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
510
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
511
('OpacFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the OPAC','free'),
511
('OpacFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the OPAC','Free'),
512
('OPACFineNoRenewals','100',NULL,'Fine limit above which user cannot renew books via OPAC','Integer'),
512
('OPACFineNoRenewals','100',NULL,'Fine limit above which user cannot renew books via OPAC','Integer'),
513
('OPACFineNoRenewalsBlockAutoRenew','0',NULL,'Block/Allow auto renewals if the patron owe more than OPACFineNoRenewals','YesNo'),
513
('OPACFineNoRenewalsBlockAutoRenew','0',NULL,'Block/Allow auto renewals if the patron owe more than OPACFineNoRenewals','YesNo'),
514
('OPACFineNoRenewalsIncludeCredits','1',NULL,'If enabled the value specified in OPACFineNoRenewals should include any unapplied account credits in the calculation','YesNo'),
514
('OPACFineNoRenewalsIncludeCredits','1',NULL,'If enabled the value specified in OPACFineNoRenewals should include any unapplied account credits in the calculation','YesNo'),
Lines 529-535 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
529
('OpacLangSelectorMode','both','top|both|footer','Select the location to display the language selector in OPAC','Choice'),
529
('OpacLangSelectorMode','both','top|both|footer','Select the location to display the language selector in OPAC','Choice'),
530
('OPACLanguages','en',NULL,'Set the default language in the OPAC.','Languages'),
530
('OPACLanguages','en',NULL,'Set the default language in the OPAC.','Languages'),
531
('opaclanguagesdisplay','0',NULL,'If ON, enables display of Change Language feature on OPAC','YesNo'),
531
('opaclanguagesdisplay','0',NULL,'If ON, enables display of Change Language feature on OPAC','YesNo'),
532
('opaclayoutstylesheet','opac.css',NULL,'Enter the name of the layout CSS stylesheet to use in the OPAC','free'),
532
('opaclayoutstylesheet','opac.css',NULL,'Enter the name of the layout CSS stylesheet to use in the OPAC','Free'),
533
('OPACLocalCoverImages','0',NULL,'Display local cover images on OPAC search and details pages.','YesNo'),
533
('OPACLocalCoverImages','0',NULL,'Display local cover images on OPAC search and details pages.','YesNo'),
534
('OpacLocationBranchToDisplay','holding','holding|home|both','In the OPAC, under location show which branch for Location in the record details.','Choice'),
534
('OpacLocationBranchToDisplay','holding','holding|home|both','In the OPAC, under location show which branch for Location in the record details.','Choice'),
535
('OpacLocationOnDetail','holding','holding|home|both|column','In the OPAC detail, display the shelving location on its own column or under a library columns.', 'Choice'),
535
('OpacLocationOnDetail','holding','holding|home|both|column','In the OPAC detail, display the shelving location on its own column or under a library columns.', 'Choice'),
Lines 585-597 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
585
('OPACSuggestionMandatoryFields','title',NULL,'Define the mandatory fields for a patron purchase suggestions made via OPAC.','multiple'),
585
('OPACSuggestionMandatoryFields','title',NULL,'Define the mandatory fields for a patron purchase suggestions made via OPAC.','multiple'),
586
('OPACSuggestionUnwantedFields','',NULL,'Define the hidden fields for a patron purchase suggestions made via OPAC.','multiple'),
586
('OPACSuggestionUnwantedFields','',NULL,'Define the hidden fields for a patron purchase suggestions made via OPAC.','multiple'),
587
('OpacSuppression','0',NULL,'Turn ON the OPAC Suppression feature, requires further setup, ask your system administrator for details','YesNo'),
587
('OpacSuppression','0',NULL,'Turn ON the OPAC Suppression feature, requires further setup, ask your system administrator for details','YesNo'),
588
('OpacSuppressionByIPRange','',NULL,'Restrict the suppression to IP adresses outside of the IP range','free'),
588
('OpacSuppressionByIPRange','',NULL,'Restrict the suppression to IP adresses outside of the IP range','Free'),
589
('OpacSuppressionRedirect','1',NULL,'Redirect the opac detail page for suppressed records to an explanatory page (otherwise redirect to 404 error page)','YesNo'),
589
('OpacSuppressionRedirect','1',NULL,'Redirect the opac detail page for suppressed records to an explanatory page (otherwise redirect to 404 error page)','YesNo'),
590
('opacthemes','bootstrap',NULL,'Define the current theme for the OPAC interface.','Themes'),
590
('opacthemes','bootstrap',NULL,'Define the current theme for the OPAC interface.','Themes'),
591
('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'),
591
('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'),
592
('OpacTrustedCheckout', '0', NULL, 'Allow logged in OPAC users to check out to themselves', 'YesNo'),
592
('OpacTrustedCheckout', '0', NULL, 'Allow logged in OPAC users to check out to themselves', 'YesNo'),
593
('OPACURLOpenInNewWindow','0',NULL,'If ON, URLs in the OPAC open in a new window','YesNo'),
593
('OPACURLOpenInNewWindow','0',NULL,'If ON, URLs in the OPAC open in a new window','YesNo'),
594
('OPACUserCSS','',NULL,'Add CSS to be included in the OPAC in an embedded <style> tag.','free'),
594
('OPACUserCSS','',NULL,'Add CSS to be included in the OPAC in an embedded <style> tag.','Free'),
595
('OPACUserJS','','70|10','Define custom javascript for inclusion in OPAC','Textarea'),
595
('OPACUserJS','','70|10','Define custom javascript for inclusion in OPAC','Textarea'),
596
('opacuserlogin','1',NULL,'Enable or disable display of user login features','YesNo'),
596
('opacuserlogin','1',NULL,'Enable or disable display of user login features','YesNo'),
597
('OPACUserSummary', '1', NULL, 'Show the summary of a logged in user\'s checkouts, overdues, holds and fines on the mainpage', 'YesNo'),
597
('OPACUserSummary', '1', NULL, 'Show the summary of a logged in user\'s checkouts, overdues, holds and fines on the mainpage', 'YesNo'),
Lines 606-612 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
606
('OpenURLImageLocation', '', NULL, 'Location of image for OpenURL links', 'Free'),
606
('OpenURLImageLocation', '', NULL, 'Location of image for OpenURL links', 'Free'),
607
('OpenURLResolverURL', '', NULL, 'URL of OpenURL Resolver', 'Free'),
607
('OpenURLResolverURL', '', NULL, 'URL of OpenURL Resolver', 'Free'),
608
('OpenURLText', '', NULL, 'Text of OpenURL links (or image title if OpenURLImageLocation is defined)', 'Free'),
608
('OpenURLText', '', NULL, 'Text of OpenURL links (or image title if OpenURLImageLocation is defined)', 'Free'),
609
('OrderPdfFormat','pdfformat::layout3pages','Controls what script is used for printing (basketgroups)','','free'),
609
('OrderPdfFormat','pdfformat::layout3pages',NULL, 'Controls what script is used for printing (basketgroups)','Free'),
610
('OrderPriceRounding','','|nearest_cent','Local preference for rounding orders before calculations to ensure correct calculations','Choice'),
610
('OrderPriceRounding','','|nearest_cent','Local preference for rounding orders before calculations to ensure correct calculations','Choice'),
611
('OverDriveAuthName','',NULL,'Authentication for OverDrive integration, used as fallback when no OverDrive library authnames are set','Free'),
611
('OverDriveAuthName','',NULL,'Authentication for OverDrive integration, used as fallback when no OverDrive library authnames are set','Free'),
612
('OverDriveCirculation','0',NULL,'Enable client to see their OverDrive account','YesNo'),
612
('OverDriveCirculation','0',NULL,'Enable client to see their OverDrive account','YesNo'),
Lines 628-642 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
628
('PatronQuickAddFields', '', NULL, 'A list of fields separated by "|" to be displayed along with mandatory fields in the patron quick add form if chosen at patron entry', 'Free'),
628
('PatronQuickAddFields', '', NULL, 'A list of fields separated by "|" to be displayed along with mandatory fields in the patron quick add form if chosen at patron entry', 'Free'),
629
('PatronRemovalDelay','',NULL,'Delay for removing anonymized patrons', 'Integer'),
629
('PatronRemovalDelay','',NULL,'Delay for removing anonymized patrons', 'Integer'),
630
('PatronRestrictionTypes','0',NULL,'Specify type of patron restriction being applied', 'YesNo'),
630
('PatronRestrictionTypes','0',NULL,'Specify type of patron restriction being applied', 'YesNo'),
631
('PatronSelfModificationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when a patron is editing their information via the OPAC.','free'),
631
('PatronSelfModificationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when a patron is editing their information via the OPAC.','Free'),
632
('PatronSelfModificationMandatoryField','',NULL,'Define the required fields when a patron is editing their information via the OPAC','free'),
632
('PatronSelfModificationMandatoryField','',NULL,'Define the required fields when a patron is editing their information via the OPAC','Free'),
633
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
633
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
634
('PatronSelfRegistrationAgeRestriction', '', NULL, 'Patron\'s maximum age during self registration. If empty, no age restriction is applied.', 'Integer'),
634
('PatronSelfRegistrationAgeRestriction', '', NULL, 'Patron\'s maximum age during self registration. If empty, no age restriction is applied.', 'Integer'),
635
('PatronSelfRegistrationAlert','0',NULL,'If enabled, an alter will be shown on staff interface home page when there are self-registered patrons.','YesNo'),
635
('PatronSelfRegistrationAlert','0',NULL,'If enabled, an alter will be shown on staff interface home page when there are self-registered patrons.','YesNo'),
636
('PatronSelfRegistrationBorrowerMandatoryField','surname|firstname',NULL,'Choose the mandatory fields for a patron\'s account, when registering via the OPAC.','free'),
636
('PatronSelfRegistrationBorrowerMandatoryField','surname|firstname',NULL,'Choose the mandatory fields for a patron\'s account, when registering via the OPAC.','Free'),
637
('PatronSelfRegistrationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when registering a new patron via the OPAC.','free'),
637
('PatronSelfRegistrationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when registering a new patron via the OPAC.','Free'),
638
('PatronSelfRegistrationConfirmEmail', '0', NULL, 'Require users to confirm their email address by entering it twice.', 'YesNo'),
638
('PatronSelfRegistrationConfirmEmail', '0', NULL, 'Require users to confirm their email address by entering it twice.', 'YesNo'),
639
('PatronSelfRegistrationDefaultCategory','',NULL,'A patron registered via the OPAC will receive a borrower category code set in this system preference.','free'),
639
('PatronSelfRegistrationDefaultCategory','',NULL,'A patron registered via the OPAC will receive a borrower category code set in this system preference.','Free'),
640
('PatronSelfRegistrationEmailMustBeUnique', '0', NULL, 'If set, the field borrowers.email will be considered as a unique field on self-registering', 'YesNo'),
640
('PatronSelfRegistrationEmailMustBeUnique', '0', NULL, 'If set, the field borrowers.email will be considered as a unique field on self-registering', 'YesNo'),
641
('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'),
641
('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'),
642
('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed.','Free'),
642
('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed.','Free'),
Lines 721-728 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
721
('SCOAllowCheckin','0',NULL,'If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),
721
('SCOAllowCheckin','0',NULL,'If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),
722
('SCOBatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch while logged into Self Checkout','Free'),
722
('SCOBatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch while logged into Self Checkout','Free'),
723
('SCOLoadCheckoutsByDefault','1',NULL,'If enabled, load the list of a patrons checkouts when they log in to the Self Checkout','YesNo'),
723
('SCOLoadCheckoutsByDefault','1',NULL,'If enabled, load the list of a patrons checkouts when they log in to the Self Checkout','YesNo'),
724
('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','free'),
724
('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','Free'),
725
('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','free'),
725
('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','Free'),
726
('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo'),
726
('SearchCancelledAndInvalidISBNandISSN','0',NULL,'Enable search for cancelled or invalid forms of ISBN/ISSN when performing ISBN/ISSN search (when using ES)','YesNo'),
727
('SearchEngine','Zebra','Elasticsearch|Zebra','Search Engine','Choice'),
727
('SearchEngine','Zebra','Elasticsearch|Zebra','Search Engine','Choice'),
728
('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'),
728
('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'),
Lines 732-743 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
732
('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'),
732
('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
('SelfCheckInModule', '0', NULL, 'Enable the standalone self-checkin module.', 'YesNo'),
733
('SelfCheckInModule', '0', NULL, 'Enable the standalone self-checkin module.', 'YesNo'),
734
('SelfCheckInTimeout','120',NULL,'Define the number of seconds before the self check-in module times out.','Integer'),
734
('SelfCheckInTimeout','120',NULL,'Define the number of seconds before the self check-in module times out.','Integer'),
735
('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','free'),
735
('SelfCheckInUserCSS','',NULL,'Add CSS to be included in the self check-in module in an embedded <style> tag.','Free'),
736
('SelfCheckInUserJS','',NULL,'Define custom javascript for inclusion in the self check-in module.','free'),
736
('SelfCheckInUserJS','',NULL,'Define custom javascript for inclusion in the self check-in module.','Free'),
737
('SelfCheckoutByLogin','1',NULL,'Have patrons login into the web-based self checkout system with their username/password or their cardnumber','YesNo'),
737
('SelfCheckoutByLogin','1',NULL,'Have patrons login into the web-based self checkout system with their username/password or their cardnumber','YesNo'),
738
('SelfCheckReceiptPrompt','1',NULL,'If ON, print receipt dialog pops up when self checkout is finished','YesNo'),
738
('SelfCheckReceiptPrompt','1',NULL,'If ON, print receipt dialog pops up when self checkout is finished','YesNo'),
739
('SelfCheckTimeout','120',NULL,'Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
739
('SelfCheckTimeout','120',NULL,'Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
740
('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','free'),
740
('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','Free'),
741
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
741
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
742
('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'),
742
('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'),
743
('SeparateHoldingsByGroup','0',NULL,'Separate current branch holdings and holdings from libraries in the same library groups','YesNo'),
743
('SeparateHoldingsByGroup','0',NULL,'Separate current branch holdings and holdings from libraries in the same library groups','YesNo'),
Lines 759-779 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
759
('ShowReviewer','full','none|full|first|surname|firstandinitial|username','Choose how a commenter\'s identity is presented alongside comments in the OPAC','Choice'),
759
('ShowReviewer','full','none|full|first|surname|firstandinitial|username','Choose how a commenter\'s identity is presented alongside comments in the OPAC','Choice'),
760
('ShowReviewerPhoto','1',NULL,'If ON, photo of reviewer will be shown beside comments in OPAC','YesNo'),
760
('ShowReviewerPhoto','1',NULL,'If ON, photo of reviewer will be shown beside comments in OPAC','YesNo'),
761
('SIP2AddOpacMessagesToScreenMessage','1',NULL,'If enabled, patron OPAC messages will be included in the SIP2 screen message','YesNo'),
761
('SIP2AddOpacMessagesToScreenMessage','1',NULL,'If enabled, patron OPAC messages will be included in the SIP2 screen message','YesNo'),
762
('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'),
762
('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
('SkipHoldTrapOnNotForLoanValue','',NULL,'If set, Koha will never trap items for hold with this notforloan value','Integer'),
763
('SkipHoldTrapOnNotForLoanValue','',NULL,'If set, Koha will never trap items for hold with this notforloan value','Integer'),
764
('SlipCSS','',NULL,'Slips CSS url.','free'),
764
('SlipCSS','',NULL,'Slips CSS url.','Free'),
765
('SMSSendAdditionalOptions', '', NULL, 'Additional SMS::Send parameters used to send SMS messages', 'free'),
765
('SMSSendAdditionalOptions', '', NULL, 'Additional SMS::Send parameters used to send SMS messages', 'Free'),
766
('SMSSendDriver','',NULL,'Sets which SMS::Send driver is used to send SMS messages.','free'),
766
('SMSSendDriver','',NULL,'Sets which SMS::Send driver is used to send SMS messages.','Free'),
767
('SMSSendMaxChar', '', NULL, 'Add a limit for the number of characters in SMS messages', 'Integer'),
767
('SMSSendMaxChar', '', NULL, 'Add a limit for the number of characters in SMS messages', 'Integer'),
768
('SMSSendPassword', '', NULL, 'Password used to send SMS messages', 'free'),
768
('SMSSendPassword', '', NULL, 'Password used to send SMS messages', 'Free'),
769
('SMSSendUsername', '', NULL, 'Username/Login used to send SMS messages', 'free'),
769
('SMSSendUsername', '', NULL, 'Username/Login used to send SMS messages', 'Free'),
770
('SocialNetworks','','facebook|linkedin|email','Enable/Disable social networks links in opac detail pages','Choice'),
770
('SocialNetworks','','facebook|linkedin|email','Enable/Disable social networks links in opac detail pages','Choice'),
771
('SpecifyDueDate','1',NULL,'Define whether to display "Specify Due Date" form in Circulation','YesNo'),
771
('SpecifyDueDate','1',NULL,'Define whether to display "Specify Due Date" form in Circulation','YesNo'),
772
('SpecifyReturnDate','1',NULL,'Define whether to display "Specify Return Date" form in Circulation','YesNo'),
772
('SpecifyReturnDate','1',NULL,'Define whether to display "Specify Return Date" form in Circulation','YesNo'),
773
('SpineLabelAutoPrint','0',NULL,'If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
773
('SpineLabelAutoPrint','0',NULL,'If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
774
('SpineLabelFormat','<itemcallnumber><copynumber>','30|10','This preference defines the format for the quick spine label printer. Just list the fields you would like to see in the order you would like to see them, surrounded by <>, for example <itemcallnumber>.','Textarea'),
774
('SpineLabelFormat','<itemcallnumber><copynumber>','30|10','This preference defines the format for the quick spine label printer. Just list the fields you would like to see in the order you would like to see them, surrounded by <>, for example <itemcallnumber>.','Textarea'),
775
('SpineLabelShowPrintOnBibDetails','0',NULL,'If turned on, a "Print label" link will appear for each item on the bib details page in the staff interface.','YesNo'),
775
('SpineLabelShowPrintOnBibDetails','0',NULL,'If turned on, a "Print label" link will appear for each item on the bib details page in the staff interface.','YesNo'),
776
('staffClientBaseURL','',NULL,'Specify the base URL of the staff interface starting with http:// or https://. Do not include a trailing slash in the URL. (This must be filled in correctly for CAS, svc, and load_testing to work.)','free'),
776
('staffClientBaseURL','',NULL,'Specify the base URL of the staff interface starting with http:// or https://. Do not include a trailing slash in the URL. (This must be filled in correctly for CAS, svc, and load_testing to work.)','Free'),
777
('StaffHighlightedWords','1',NULL,'Highlight search terms on staff interface','YesNo'),
777
('StaffHighlightedWords','1',NULL,'Highlight search terms on staff interface','YesNo'),
778
('StaffInterfaceLanguages','en',NULL,'Set the default language in the staff interface.','Languages'),
778
('StaffInterfaceLanguages','en',NULL,'Set the default language in the staff interface.','Languages'),
779
('StaffLangSelectorMode','footer','top|both|footer','Select the location to display the language selector in staff interface','Choice'),
779
('StaffLangSelectorMode','footer','top|both|footer','Select the location to display the language selector in staff interface','Choice'),
Lines 787-794 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
787
('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
787
('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
788
('StoreLastBorrower','0',NULL,'Defines the number of borrowers stored per item in the items_last_borrower table','Integer'),
788
('StoreLastBorrower','0',NULL,'Defines the number of borrowers stored per item in the items_last_borrower table','Integer'),
789
('StripWhitespaceChars','0',NULL,'Strip leading and trailing whitespace characters and inner newlines from input fields when cataloguing bibliographic and authority records.','YesNo'),
789
('StripWhitespaceChars','0',NULL,'Strip leading and trailing whitespace characters and inner newlines from input fields when cataloguing bibliographic and authority records.','YesNo'),
790
('SubfieldsToAllowForRestrictedBatchmod','','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',NULL,'Free'),
790
('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
('SubfieldsToAllowForRestrictedEditing','','Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j',NULL,'Free'),
791
('SubfieldsToAllowForRestrictedEditing','',NULL,'Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j','Free'),
792
('SubfieldsToUseWhenPrefill','',NULL,'Define a list of subfields to use when prefilling items (separated by space)','Free'),
792
('SubfieldsToUseWhenPrefill','',NULL,'Define a list of subfields to use when prefilling items (separated by space)','Free'),
793
('SubscriptionDuplicateDroppedInput','',NULL,'List of fields which must not be rewritten when a subscription is duplicated (Separated by pipe |)','Free'),
793
('SubscriptionDuplicateDroppedInput','',NULL,'List of fields which must not be rewritten when a subscription is duplicated (Separated by pipe |)','Free'),
794
('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'),
794
('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'),
Lines 803-809 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
803
('SwitchOnSiteCheckouts','0',NULL,'Automatically switch an on-site checkout to a normal checkout','YesNo'),
803
('SwitchOnSiteCheckouts','0',NULL,'Automatically switch an on-site checkout to a normal checkout','YesNo'),
804
('SyndeticsAuthorNotes','0',NULL,'Display Notes about the Author on OPAC from Syndetics','YesNo'),
804
('SyndeticsAuthorNotes','0',NULL,'Display Notes about the Author on OPAC from Syndetics','YesNo'),
805
('SyndeticsAwards','0',NULL,'Display Awards on OPAC from Syndetics','YesNo'),
805
('SyndeticsAwards','0',NULL,'Display Awards on OPAC from Syndetics','YesNo'),
806
('SyndeticsClientCode','0',NULL,'Client Code for using Syndetics Solutions content','free'),
806
('SyndeticsClientCode','0',NULL,'Client Code for using Syndetics Solutions content','Free'),
807
('SyndeticsCoverImages','0',NULL,'Display Cover Images from Syndetics','YesNo'),
807
('SyndeticsCoverImages','0',NULL,'Display Cover Images from Syndetics','YesNo'),
808
('SyndeticsCoverImageSize','MC','MC|LC','Choose the size of the Syndetics Cover Image to display on the OPAC detail page, MC is Medium, LC is Large','Choice'),
808
('SyndeticsCoverImageSize','MC','MC|LC','Choose the size of the Syndetics Cover Image to display on the OPAC detail page, MC is Medium, LC is Large','Choice'),
809
('SyndeticsEditions','0',NULL,'Display Editions from Syndetics','YesNo'),
809
('SyndeticsEditions','0',NULL,'Display Editions from Syndetics','YesNo'),
Lines 854-860 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
854
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
854
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
855
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','Integer'),
855
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','Integer'),
856
('uppercasesurnames','0',NULL,'If ON, surnames are converted to upper case in patron entry form','YesNo'),
856
('uppercasesurnames','0',NULL,'If ON, surnames are converted to upper case in patron entry form','YesNo'),
857
('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','free'),
857
('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','Free'),
858
('UsageStats', '2', NULL, 'Share anonymous usage data on the Hea Koha community website.', 'Integer'),
858
('UsageStats', '2', NULL, 'Share anonymous usage data on the Hea Koha community website.', 'Integer'),
859
('UsageStatsCountry', '', NULL, 'The country where your library is located, to be shown on the Hea Koha community website', 'Choice'),
859
('UsageStatsCountry', '', NULL, 'The country where your library is located, to be shown on the Hea Koha community website', 'Choice'),
860
('UsageStatsGeolocation', '', NULL, 'Geolocation of the main library.', 'Free'),
860
('UsageStatsGeolocation', '', NULL, 'Geolocation of the main library.', 'Free'),
Lines 893-899 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
893
('XSLTDetailsDisplay','default',NULL,'Enable XSL stylesheet control over details page display on intranet','Free'),
893
('XSLTDetailsDisplay','default',NULL,'Enable XSL stylesheet control over details page display on intranet','Free'),
894
('XSLTListsDisplay','default',NULL,'Enable XSLT stylesheet control over lists pages display on intranet','Free'),
894
('XSLTListsDisplay','default',NULL,'Enable XSLT stylesheet control over lists pages display on intranet','Free'),
895
('XSLTResultsDisplay','default',NULL,'Enable XSL stylesheet control over results page display on intranet','Free'),
895
('XSLTResultsDisplay','default',NULL,'Enable XSL stylesheet control over results page display on intranet','Free'),
896
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
896
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','Free'),
897
('z3950NormalizeAuthor','0',NULL,'If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
897
('z3950NormalizeAuthor','0',NULL,'If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
898
('z3950Status','',NULL,'This syspref allows to define custom YAML based rules for marking items unavailable in z3950 results.','Textarea')
898
('z3950Status','',NULL,'This syspref allows to define custom YAML based rules for marking items unavailable in z3950 results.','Textarea')
899
;
899
;
900
- 

Return to bug 41682