From 38f6f5693ad9f1ebea96fffbf5c70b751de0a2fa Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 9 Feb 2026 15:47:17 +0100 Subject: [PATCH] Bug 41800: Adjust syspref's explanation - If ON => If enabled --- .../data/mysql/atomicupdate/bug_41800.pl | 56 +++++ installer/data/mysql/mandatory/sysprefs.sql | 196 +++++++++--------- 2 files changed, 154 insertions(+), 98 deletions(-) create mode 100755 installer/data/mysql/atomicupdate/bug_41800.pl diff --git a/installer/data/mysql/atomicupdate/bug_41800.pl b/installer/data/mysql/atomicupdate/bug_41800.pl new file mode 100755 index 00000000000..5607a70508c --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_41800.pl @@ -0,0 +1,56 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_success say_info); + +return { + bug_number => "41800", + description => "Fix more syspref discrepancies", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + # from updatedatabase.pl 20.12.00.009 + # UseICUStyleQUotes vs UseICUStyleQuotes + $dbh->do( + q{ + UPDATE systempreferences + SET variable="UseICUStyleQuotes" + WHERE BINARY variable="UseICUStyleQUotes" + } + ); + + # from db_revs/211200012.pl + # Syspref was not deleted if no value set + $dbh->do( + q{ + DELETE FROM systempreferences WHERE variable='OpacMoreSearches' + } + ); + + # from db_revs/211200020.pl + # Syspref was not deleted if no value set + $dbh->do( + q{ + DELETE FROM systempreferences WHERE variable='OPACMySummaryNote' + } + ); + + $dbh->do( + q{ + UPDATE systempreferences + SET explanation = REPLACE(explanation, 'If ON, ', 'If enabled, ') + } + ); + my $new_explanations = {}; + for my $variable ( sort { lc($a) cmp lc($b) } keys %$new_explanations ) { + my $explanation = $new_explanations->{$variable}; + $dbh->do( + q{ + UPDATE systempreferences + SET explanation=? + WHERE variable=? + }, undef, $explanation, $variable + ); + } + + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index aac74ecc964..112dc49a104 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -7,19 +7,19 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AcqItemSetSubfieldsWhenReceiptIsCancelled','', NULL,'Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a="bar foo")', 'Free'), ('AcqItemSetSubfieldsWhenReceived','',NULL,'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'), ('AcquisitionDetails', '1', NULL, 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'), -('AcquisitionLog','0',NULL,'If ON, log acquisitions activity','YesNo'), +('AcquisitionLog','0',NULL,'If enabled, log acquisitions activity','YesNo'), ('AcquisitionsDefaultEmailAddress', '', NULL, 'Default email address that acquisition notices are sent from', 'Free'), ('AcquisitionsDefaultReplyTo', '', NULL, 'Default email address used as reply-to for notices sent by the acquisitions module.', 'Free'), ('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: their own only, any within their branch, or all','Choice'), ('AcqWarnOnDuplicateInvoice','0',NULL,'Warn librarians when they try to create a duplicate invoice','YesNo'), ('ActionLogsTraceDepth', '0', NULL, 'Sets the maximum depth of the action logs stack trace', 'Integer'), -('AdditionalContentLog','0',NULL,'If ON, log OPAC news changes','YesNo'), +('AdditionalContentLog','0',NULL,'If enabled, log OPAC news changes','YesNo'), ('AdditionalContentsEditor','tinymce','tinymce|codemirror','Choose tool for editing News.', 'Choice'), ('AdditionalFieldsInZ3950ResultAuthSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of an authority Z39.50 search', 'Free'), ('AdditionalFieldsInZ3950ResultSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950', 'Free'), ('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'), ('AddressFormat','us','us|de|fr','Choose format to display postal addresses', 'Choice'), -('advancedMARCeditor','0',NULL,'If ON, the MARC editor won\'t display field/subfield descriptions','YesNo'), +('advancedMARCeditor','0',NULL,'If enabled, the MARC editor won\'t display field/subfield descriptions','YesNo'), ('AdvancedSearchLanguages','',NULL,'ISO 639-2 codes of languages you wish to see appear as an Advanced search option. Example: eng|fre|ita','Textarea'), ('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'), ('AgeRestrictionMarker','',NULL,'Markers for age restriction indication, e.g. FSK|PEGI|Age|','Free'), @@ -40,16 +40,16 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AllowItemsOnLoanCheckoutSIP','0',NULL,'Do not generate ISSUED_TO_ANOTHER warning when checking out items already checked out to someone else via SIP. This allows self checkouts for those items.','YesNo'), ('AllowMultipleCovers','0',NULL,'Allow multiple cover images to be attached to each bibliographic record.','YesNo'), ('AllowMultipleIssuesOnABiblio','1',NULL,'Allow/Don\'t allow patrons to check out multiple items from one biblio','YesNo'), -('AllowNotForLoanOverride','0',NULL,'If ON, Koha will allow the librarian to loan a not for loan item.','YesNo'), +('AllowNotForLoanOverride','0',NULL,'If enabled, Koha will allow the librarian to loan a not for loan item.','YesNo'), ('AllowPatronToControlAutorenewal','0',NULL,'If enabled, patrons will have a field in their account to choose whether their checkouts are auto renewed or not','YesNo'), ('AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set checkouts to be visible to their guarantor', 'YesNo'), ('AllowPatronToSetFinesVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set fines to be visible to their guarantor', 'YesNo'), ('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'), ('AllowRenewalIfOtherItemsAvailable','0',NULL,'If enabled, allow a patron to renew an item with unfilled holds if other available items can fill that hold.','YesNo'), ('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'), -('AllowRenewalOnHoldOverride','0',NULL,'If ON, allow items on hold to be renewed with a specified due date','YesNo'), +('AllowRenewalOnHoldOverride','0',NULL,'If enabled, allow items on hold to be renewed with a specified due date','YesNo'), ('AllowReturnToBranch','anywhere','anywhere|homebranch|holdingbranch|homeorholdingbranch','Where an item may be returned','Choice'), -('AllowSetAutomaticRenewal','1',NULL,'If ON, allows staff to flag items for automatic renewal on the check out page','YesNo'), +('AllowSetAutomaticRenewal','1',NULL,'If enabled, allows staff to flag items for automatic renewal on the check out page','YesNo'), ('AllowStaffToSetCheckoutsVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s checkouts to be visible to linked patrons from the opac.','YesNo'), ('AllowStaffToSetFinesVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron\'s fines to be visible to linked patrons from the opac.', 'YesNo'), ('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'), @@ -75,7 +75,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AudioAlerts','0',NULL,'Enable circulation sounds during checkin and checkout in the staff interface. Not supported by all web browsers yet.','YesNo'), ('AuthDisplayHierarchy','0',NULL,'Display authority hierarchies','YesNo'), ('AuthFailureLog','0',NULL,'If enabled, log authentication failures','YesNo'), -('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'), +('AuthoritiesLog','1',NULL,'If enabled, log edit/create/delete actions on authorities.','YesNo'), ('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'), ('AuthorityMergeLimit','50',NULL,'Maximum number of biblio records updated immediately when an authority record has been modified.','Integer'), ('AuthorityMergeMode','loose','loose|strict','Authority merge mode','Choice'), @@ -100,9 +100,9 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AutomaticCheckinAutoFill','0',NULL,'Automatically fill the next hold with an automatic check in.','YesNo'), ('AutomaticConfirmTransfer','0',NULL,'Defines whether transfers should be automatically confirmed at checkin if modal dismissed','YesNo'), ('AutomaticEmailReceipts','0',NULL,'Send email receipts for payments and write-offs','YesNo'), -('AutomaticItemReturn','1',NULL,'If ON, Koha will automatically set up a transfer of this item to its homebranch','YesNo'), +('AutomaticItemReturn','1',NULL,'If enabled, Koha will automatically set up a transfer of this item to its homebranch','YesNo'), ('AutomaticRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for automatic renewals ','Choice'), -('autoMemberNum','0',NULL,'If ON, patron number is auto-calculated','YesNo'), +('autoMemberNum','0',NULL,'If enabled, patron number is auto-calculated','YesNo'), ('AutoRemoveOverduesRestrictions','no','no|when_no_overdue|when_no_overdue_causing_debarment', 'Defines if and on what conditions OVERDUES debarments should automatically be lifted when overdue items are returned by the patron.','Choice'), ('AutoRenewalNotices','preferences','cron|preferences|never','How should Koha determine whether to end autorenewal notices','Choice'), ('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'), @@ -132,7 +132,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','Free'), ('borrowerRelationship','father|mother',NULL,'Define valid relationships between a guarantor & a guarantee (separated by | or ,)','Free'), ('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'), -('BorrowersLog','1',NULL,'If ON, log edit/create/delete actions on patron data','YesNo'), +('BorrowersLog','1',NULL,'If enabled, log edit/create/delete actions on patron data','YesNo'), ('BorrowersTitles','Mr|Mrs|Miss|Ms',NULL,'Define appropriate Titles for patrons','Free'), ('BorrowerUnwantedField','',NULL,'Name the fields you don\'t need to store for a patron\'s account','Free'), ('BranchTransferLimitsType','ccode','itemtype|ccode','When using branch transfer limits, choose whether to limit by itemtype or collection code.','Choice'), @@ -147,7 +147,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('CanMarkHoldsToPullAsLost','do_not_allow','do_not_allow|allow|allow_and_notify','Add a button to the "Holds to pull" screen to mark an item as lost and notify the patron.','Choice'), ('canreservefromotherbranches','1',NULL,'With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'), ('CardnumberLength', '', NULL, 'Set a length for card numbers with a maximum of 32 characters.', 'Free'), -('CardnumberLog','1',NULL,'If ON, log edit actions on patron cardnumbers','YesNo'), +('CardnumberLog','1',NULL,'If enabled, log edit actions on patron cardnumbers','YesNo'), ('casAuthentication','0',NULL,'Enable or disable CAS authentication','YesNo'), ('casLogout','0',NULL,'Does a logout from Koha should also log the user out of CAS?','YesNo'), ('casServerUrl','https://localhost:8443/cas',NULL,'URL of the cas server','Free'), @@ -155,11 +155,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('CatalogConcerns', '0', NULL, 'Allow users to report catalog concerns', 'YesNo'), ('CatalogerEmails', '', NULL, 'Notify these catalogers by email when a catalog concern is submitted', 'Free'), ('CatalogModuleRelink','0',NULL,'If OFF the linker will never replace the authids that are set in the cataloging module.','YesNo'), -('CataloguingLog','1',NULL,'If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'), +('CataloguingLog','1',NULL,'If enabled, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.','YesNo'), ('ChargeFinesOnClosedDays','0',NULL,'Charge fines on days the library is closed.','YesNo'), ('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'), ('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'), -('ChildNeedsGuarantor','0',NULL,'If ON, a child patron must have a guarantor when adding the patron.','YesNo'), +('ChildNeedsGuarantor','0',NULL,'If enabled, a child patron must have a guarantor when adding the patron.','YesNo'), ('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'), ('CircConfirmItemParts', '0', NULL, 'Require staff to confirm that all parts of an item are present at checkin/checkout.', 'YesNo'), ('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'), @@ -170,11 +170,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ClaimReturnedLostValue', '', NULL, 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'), ('ClaimReturnedWarningThreshold', '', NULL, 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'), ('ClaimsBccCopy','0',NULL,'Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'), -('ClaimsLog','1',NULL,'If ON, log all notices sent','YesNo'), +('ClaimsLog','1',NULL,'If enabled, log all notices sent','YesNo'), ('CleanUpDatabaseReturnClaims', '', NULL, 'Sets the age of resolved return claims to delete from the database for cleanup_database.pl', 'Integer'), ('CoceHost', '', NULL, 'Coce server URL', 'Free'), ('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'), -('COinSinOPACResults','1',NULL,'If ON, use COinS in OPAC search results page. NOTE: this can slow down search response time significantly','YesNo'), +('COinSinOPACResults','1',NULL,'If enabled, use COinS in OPAC search results page. NOTE: this can slow down search response time significantly','YesNo'), ('CollapseFieldsPatronAddForm','',NULL,'Collapse these fields by default when adding a new patron. These fields can still be expanded.','Multiple'), ('ComponentSortField','title','call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'), ('ComponentSortOrder','asc','asc|dsc|az|za','Specify the default sort order','Choice'), @@ -186,7 +186,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('CookieConsent', '0', NULL, 'Require cookie consent to be displayed', 'YesNo'), ('CookieConsentedJS', '', NULL, 'Add Javascript code that will run if cookie consent is provided (e.g. tracking code).', 'Free'), ('CreateAVFromCataloguing', '1', NULL, 'Ability to create authorized values from the cataloguing module', 'YesNo'), -('CronjobLog','0',NULL,'If ON, log information from cron jobs.','YesNo'), +('CronjobLog','0',NULL,'If enabled, log information from cron jobs.','YesNo'), ('CSVDelimiter',',',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'), ('CumulativeRestrictionPeriods','0',NULL,'Cumulate the restriction periods instead of keeping the highest','YesNo'), ('CurbsidePickup', '0', NULL, 'Enable curbside pickup', 'YesNo'), @@ -226,11 +226,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('DisplayAddHoldGroups','0',NULL,'Display the ability to create hold groups which are fulfilled by one item','YesNo'), ('DisplayClearScreenButton','no','no|issueslip|issueqslip','If set to ON, a clear screen button will appear on the circulation page.','Choice'), ('displayFacetCount','0',NULL,'If enabled, display the number of facet counts','YesNo'), -('DisplayIconsXSLT','1',NULL,'If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages.','YesNo'), +('DisplayIconsXSLT','1',NULL,'If enabled, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages.','YesNo'), ('DisplayLibraryFacets', 'holding', 'home|holding|both', 'Defines which library facets to display.', 'Choice'), ('DisplayMultiItemHolds','0',NULL,'Display the ability to place holds on different items at the same time in staff interface and OPAC','YesNo'), ('DisplayMultiPlaceHold','1',NULL,'Display the ability to place multiple holds or not','YesNo'), -('DisplayOPACiconsXSLT','1',NULL,'If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages in the OPAC.','YesNo'), +('DisplayOPACiconsXSLT','1',NULL,'If enabled, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages in the OPAC.','YesNo'), ('DisplayPublishedDate', '1', NULL, 'Display serial publisheddate on detail pages', 'YesNo'), ('DumpSearchQueryTemplate','0',NULL,'Add the search query being passed to the search engine into the template for debugging','YesNo'), ('DumpTemplateVarsIntranet', '0', NULL, 'If enabled, dump all Template Toolkit variable to a comment in the html source for the staff intranet.', 'YesNo'), @@ -251,7 +251,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('EmailFieldPrecedence','email|emailpro|B_email',NULL,'Ordered list of patron email fields to use when AutoEmailPrimaryAddress is set to first valid','multiple'), ('EmailFieldPrimary','','|email|emailpro|B_email|cardnumber|MULTI','Defines the default email address field where patron email notices are sent.','Choice'), ('EmailFieldSelection','','email|emailpro|B_email','Selection list of patron email fields to use whern AutoEmailPrimaryAddress is set to selected addresses','multiple'), -('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'), +('emailLibrarianWhenHoldIsPlaced','0',NULL,'If enabled, emails the librarian whenever a hold is placed','YesNo'), ('EmailOverduesNoEmail','1',NULL,'Send send overdues of patrons without email address to staff','YesNo'), ('EmailPatronRegistrations', '0', '0|EmailAddressForPatronRegistrations|BranchEmailAddress|KohaAdminEmailAddress', 'Choose email address that new patron registrations will be sent to: ', 'Choice'), ('EmailPatronWhenHoldIsPlaced', '0', NULL, 'Email patron when a hold has been placed for them', 'YesNo'), @@ -266,14 +266,14 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''), ('EnablePointOfSale','0',NULL,'Enable the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)','YesNo'), ('EnableSearchHistory','0',NULL,'Enable or disable search history','YesNo'), -('EnhancedMessagingPreferences','1',NULL,'If ON, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'), -('EnhancedMessagingPreferencesOPAC', '1', NULL, 'If ON, show patrons messaging setting on the OPAC.', 'YesNo'), +('EnhancedMessagingPreferences','1',NULL,'If enabled, allows patrons to select to receive additional messages about items due or nearly due.','YesNo'), +('EnhancedMessagingPreferencesOPAC', '1', NULL, 'If enabled, show patrons messaging setting on the OPAC.', 'YesNo'), ('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'), ('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'Free'), ('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'Free'), ('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'), -('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If ON, reserves max pickup delay takes into accountthe closed days.', 'YesNo'), -('expandedSearchOption','0',NULL,'If ON, set advanced search to be expanded by default','YesNo'), +('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If enabled, reserves max pickup delay takes into accountthe closed days.', 'YesNo'), +('expandedSearchOption','0',NULL,'If enabled, set advanced search to be expanded by default','YesNo'), ('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold.','YesNo'), ('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'), ('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'), @@ -295,11 +295,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('FinePaymentAutoPopup','0',NULL,'If enabled, automatically display a print dialog for a payment receipt when making a payment.','YesNo'), ('finesCalendar','noFinesWhenClosed','ignoreCalendar|noFinesWhenClosed','Specify whether to use the Calendar in calculating duedates and fines','Choice'), ('FinesIncludeGracePeriod','1',NULL,'If enabled, fines calculations will include the grace period.','YesNo'), -('FinesLog','1',NULL,'If ON, log fines','YesNo'), +('FinesLog','1',NULL,'If enabled, log fines','YesNo'), ('finesMode','off','off|production','Choose the fines mode, \'off\' (no charges), \'production\' (accrue overdue fines). Requires accruefines cronjob.','Choice'), ('ForceLibrarySelection','0',NULL,'Force staff to select a library when logging into the staff interface.','YesNo'), ('ForcePasswordResetWhenSetByStaff','0',NULL,'Force a staff created patron account to reset its password after its first OPAC login.','YesNo'), -('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'), +('FRBRizeEditions','0',NULL,'If enabled, Koha will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'), ('FutureHoldsBlockRenewals', '0', NULL, 'Allow future holds to block renewals', 'YesNo' ), ('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'), ('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'), @@ -311,8 +311,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('GoogleOpenIDConnectDefaultBranch', '',NULL,'This branch code will be used to create Google OpenID Connect patrons.','Textarea'), ('GoogleOpenIDConnectDefaultCategory','',NULL,'This category code will be used to create Google OpenID Connect patrons.','Textarea'), ('GoogleOpenIDConnectDomain', '', NULL, 'Restrict Google OpenID Connect to this domain (or subdomains of this domain). Leave blank for all Google domains', 'Free'), -('hide_marc','0',NULL,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'), -('hidelostitems','0',NULL,'If ON, disables display of"lost" items in OPAC.','YesNo'), +('hide_marc','0',NULL,'If enabled, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'), +('hidelostitems','0',NULL,'If enabled, disables display of"lost" items in OPAC.','YesNo'), ('HidePatronName','0',NULL,'If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'), ('HidePersonalPatronDetailOnCirculation', '0', NULL, 'Hide patrons phone number, email address, street address and city in the circulation page','YesNo'), ('HoldCancellationRequestSIP','0',NULL,'Option to set holds cancelled via SIP as cancellation requests','YesNo'), @@ -320,7 +320,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('HoldRatioDefault','3',NULL,'Default value for the hold ratio report','Integer'), ('HoldsAutoFill','0',NULL,'If on, librarian will not be asked if hold should be filled, it will be filled automatically','YesNo'), ('HoldsAutoFillPrintSlip','0',NULL,'If on, hold slip print dialog will be displayed automatically','YesNo'), -('HoldsLog','0',NULL,'If ON, log create/cancel/suspend/resume actions on holds.','YesNo'), +('HoldsLog','0',NULL,'If enabled, log create/cancel/suspend/resume actions on holds.','YesNo'), ('HoldsNeedProcessingSIP', '0', NULL, 'Require staff to check-in before hold is set to waiting state', 'YesNo'), ('HoldsQueueParallelLoopsCount', '1', NULL, 'Number of parallel loops to use when running the holds queue builder', 'Integer'), ('HoldsQueuePrioritizeBranch','homebranch','holdingbranch|homebranch','Decides if holds queue builder patron home library match to home or holding branch','Choice'), @@ -329,17 +329,17 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('HoldsSplitQueueNumbering', 'actual', 'actual|virtual', 'If the holds queue is split, decide if the actual priorities should be displayed', 'Choice'), ('HoldsToPullStartDate','2',NULL,'Set the default start date for the Holds to pull list to this many days ago','Integer'), ('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'), -('HouseboundModule','0',NULL,'If ON, enable housebound module functionality.','YesNo'), +('HouseboundModule','0',NULL,'If enabled, enable housebound module functionality.','YesNo'), ('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'), ('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt',NULL,'Media file extensions','Free'), ('HTML5MediaYouTube','0',NULL,'YouTube links as videos','YesNo'), ('IdRef','0',NULL,'Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'), -('ILLCheckAvailability', '0', NULL, 'If ON, during the ILL request process third party sources will be checked for current availability', 'YesNo'), +('ILLCheckAvailability', '0', NULL, 'If enabled, during the ILL request process third party sources will be checked for current availability', 'YesNo'), ('ILLDefaultStaffEmail', '', NULL, 'Fallback email address for staff ILL notices to be sent to in the absence of a branch address', 'Free'), ('ILLHiddenRequestStatuses', '', NULL, 'ILL statuses that are considered finished and should not be displayed in the ILL module', 'multiple'), -('ILLHistoryCheck', '0', NULL, 'If ON, a verification is performed to check if the ILL request has previously been placed by the same patron. Verification is done using one of the following identifier fields: DOI, Pubmed ID or ISBN', 'YesNo'), -('IllLog', '0', NULL, 'If ON, log information about ILL requests', 'YesNo'), -('ILLModule','0',NULL,'If ON, enables the interlibrary loans module.','YesNo'), +('ILLHistoryCheck', '0', NULL, 'If enabled, a verification is performed to check if the ILL request has previously been placed by the same patron. Verification is done using one of the following identifier fields: DOI, Pubmed ID or ISBN', 'YesNo'), +('IllLog', '0', NULL, 'If enabled, log information about ILL requests', 'YesNo'), +('ILLModule','0',NULL,'If enabled, enables the interlibrary loans module.','YesNo'), ('ILLModuleDisclaimerByType','',NULL,'YAML defining disclaimer settings for each ILL request type','Textarea'), ('ILLModuleUnmediated','0',NULL,'If enabled, try to immediately progress newly placed ILL requests.','YesNo'), ('ILLOpacbackends','',NULL,'ILL backends to enabled for OPAC initiated requests','multiple'), @@ -352,13 +352,13 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ImageLimit','5',NULL,'Limit images stored in the database by the Patron Card image manager to this number.','Integer'), ('IncludeSeeAlsoFromInSearches','0',NULL,'Include see-also-from references in searches.','YesNo'), ('IncludeSeeFromInSearches','0',NULL,'Include see-from references in searches.','YesNo'), -('IndependentBranches','0',NULL,'If ON, increases security between libraries','YesNo'), +('IndependentBranches','0',NULL,'If enabled, increases security between libraries','YesNo'), ('IndependentBranchesPatronModifications','0', NULL, 'Show only modification request for the logged in branch','YesNo'), ('IndependentBranchesTransfers','0', NULL, 'Allow non-superlibrarians to transfer items between libraries','YesNo'), ('intranet_includes','includes',NULL,'The includes directory you want for specific look of Koha (includes or includes_npl for example)','Free'), ('IntranetAddMastheadLibraryPulldown','0', NULL, 'Add a library select pulldown menu on the staff header search','YesNo'), ('IntranetBiblioDefaultView','normal','normal|marc|isbd|labeled_marc','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','Choice'), -('intranetbookbag','1',NULL,'If ON, enables display of Cart feature in the intranet','YesNo'), +('intranetbookbag','1',NULL,'If enabled, enables display of Cart feature in the intranet','YesNo'), ('IntranetCatalogSearchPulldown','0', NULL, 'Show a search field pulldown for "Search the catalog" boxes','YesNo'), ('IntranetCirculationHomeHTML', '', NULL, 'Show the following HTML in a div on the bottom of the reports home page', 'Free'), ('IntranetCoce','0', NULL, 'If on, enables cover retrieval from the configured Coce server in the staff interface', 'YesNo'), @@ -366,17 +366,17 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('IntranetFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the staff interface','Free'), ('IntranetNav','','70|10','Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface','Textarea'), ('IntranetNumbersPreferPhrase','0',NULL,'Control the use of phr operator in callnumber and standard number staff interface searches','YesNo'), -('intranetreadinghistory','1',NULL,'If ON, Checkout history is enabled for all patrons','YesNo'), -('IntranetReadingHistoryHolds', '1', NULL, 'If ON, Holds history is enabled for all patrons','YesNo'), +('intranetreadinghistory','1',NULL,'If enabled, Checkout history is enabled for all patrons','YesNo'), +('IntranetReadingHistoryHolds', '1', NULL, 'If enabled, Holds history is enabled for all patrons','YesNo'), ('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'), ('intranetstylesheet','',NULL,'Enter a complete URL to use an alternate layout stylesheet in Intranet','Free'), ('IntranetUserCSS','',NULL,'Add CSS to be included in the intranet in an embedded