From 4c82d3b1eb7b806e962c82f363bb87cbb732208e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 26 Jan 2026 14:42:39 +0100 Subject: [PATCH] Bug 41682: More fixes * free => Free * options=NULL where type=Free * fix options and type for ArticleRequestsSupportedFormats * fix more explanation and options --- installer/data/mysql/db_revs/251200014.pl | 30 +++- installer/data/mysql/mandatory/sysprefs.sql | 156 ++++++++++---------- 2 files changed, 105 insertions(+), 81 deletions(-) diff --git a/installer/data/mysql/db_revs/251200014.pl b/installer/data/mysql/db_revs/251200014.pl index 4cb8478985b..2f504031680 100755 --- a/installer/data/mysql/db_revs/251200014.pl +++ b/installer/data/mysql/db_revs/251200014.pl @@ -34,6 +34,13 @@ return { WHERE BINARY type='integer' } ); + $dbh->do( + q{ + UPDATE systempreferences + SET type='Free' + WHERE BINARY type='free' + } + ); my $new_explanations = { AcquisitionsDefaultEmailAddress => q{Default email address that acquisition notices are sent from}, @@ -51,9 +58,13 @@ return { EnableBooking => q{If enabled, activate every functionalities related with Bookings module}, HoldCancellationRequestSIP => q{Option to set holds cancelled via SIP as cancellation requests}, HoldRatioDefault => q{Default value for the hold ratio report}, + 'ILS-DI:AuthorizedIPs' => q{Restricts usage of ILS-DI to some IPs}, ILLModule => q{If ON, enables the interlibrary loans module.}, - OPACLoginLabelTextContent => q{Control the text displayed on the login form}, - OpacHiddenItems => + LibrisKey => + q{This key must be obtained at http://api.libris.kb.se/. It is unique for the IP of the server.}, + LibrisURL => q{This is the base URL for the Libris spellchecking API.}, + OPACLoginLabelTextContent => q{Control the text displayed on the login form}, + OpacHiddenItems => 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.}, OPACShowLibraries => q{If enabled, a "Libraries" link appears in the OPAC pointing to a page with library information}, @@ -62,6 +73,7 @@ return { OPACVirtualCard => q{If ON, the patron virtual library card tab in the OPAC will be enabled}, OPACVirtualCardBarcode => q{Specify the type of barcode to be used in the patron virtual library card tab in the OPAC}, + OrderPdfFormat => q{Controls what script is used for printing (basketgroups)}, PatronSelfRegistrationEmailMustBeUnique => q{If set, the field borrowers.email will be considered as a unique field on self-registering}, PatronSelfRegistrationPrefillForm => @@ -75,6 +87,10 @@ return { q{Separate current branch holdings and holdings from libraries in the same library groups}, ShowHeadingUse => 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}, + SubfieldsToAllowForRestrictedBatchmod => + 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}, + SubfieldsToAllowForRestrictedEditing => + 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}, SuggestionsLog => q{If ON, log purchase suggestion changes}, SuspendHoldsIntranet => q{Allow holds to be suspended from the intranet.}, SuspendHoldsOpac => q{Allow holds to be suspended from the OPAC.}, @@ -116,7 +132,7 @@ return { q{ UPDATE systempreferences SET options=NULL - WHERE type="YesNo"; + WHERE type="YesNo" OR type="Free"; } ); @@ -151,5 +167,13 @@ return { WHERE variable="OPACLoginLabelTextContent"; } ); + + $dbh->do( + q{ + UPDATE systempreferences + SET type='Choice', options='PHOTOCOPY|SCAN' + WHERE variable="ArticleRequestsSupportedFormats"; + } + ); }, }; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index d1a15e58d3c..2476391b835 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -17,12 +17,12 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), +('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'), ('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'), +('AgeRestrictionMarker','',NULL,'Markers for age restriction indication, e.g. FSK|PEGI|Age|','Free'), ('AgeRestrictionOverride','0',NULL,'Allow staff to check out an item with age restriction.','YesNo'), ('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'), ('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'), @@ -53,12 +53,12 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), -('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'), -('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'), -('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','free'), +('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'), +('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'), +('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','Free'), ('AlwaysLoadCheckoutsTable','0',NULL,'Option to always load the checkout table','YesNo'), ('AlwaysShowHoldingsTableFilters','0',NULL,'Option to always show filters when loading the holdings table','YesNo'), -('AmazonAssocTag','',NULL,'See: http://aws.amazon.com','free'), +('AmazonAssocTag','',NULL,'See: http://aws.amazon.com','Free'), ('AmazonCoverImages','0',NULL,'Display Cover Images in staff interface from Amazon Web Services','YesNo'), ('AmazonLocale','US','US|CA|DE|FR|IN|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'), ('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'), @@ -71,7 +71,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ArticleRequestsMandatoryFieldsItemOnly', '', NULL, 'Comma delimited list of required fields for bibs where article requests rule = \'item_only\'', 'multiple'), ('ArticleRequestsMandatoryFieldsRecordOnly', '', NULL, 'Comma delimited list of required fields for bibs where article requests rule = \'bib_only\'', 'multiple'), ('ArticleRequestsOpacHostRedirection', '0', NULL, 'Enables redirection from child to host when requesting articles on the Opac', 'YesNo'), -('ArticleRequestsSupportedFormats', 'PHOTOCOPY', 'PHOTOCOPY|SCAN', 'List supported formats between vertical bars', 'free'), +('ArticleRequestsSupportedFormats', 'PHOTOCOPY', 'PHOTOCOPY|SCAN', 'List supported formats between vertical bars', 'Choice'), ('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'), @@ -79,7 +79,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), -('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'), +('AuthoritySeparator','--',NULL,'Used to separate a list of authorities in a display. Usually --','Free'), ('AuthorityXSLTDetailsDisplay','',NULL,'Enable XSL stylesheet control over authority details page display on intranet','Free'), ('AuthorityXSLTOpacDetailsDisplay','',NULL,'Enable XSL stylesheet control over authority details page in the OPAC','Free'), ('AuthorityXSLTOpacResultsDisplay','',NULL,'Enable XSL stylesheet control over authority results page in the OPAC','Free'), @@ -107,8 +107,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AutoResumeSuspendedHolds','1',NULL,'Allow suspended holds to be automatically resumed by a set date.','YesNo'), ('AutoReturnCheckedOutItems', '0', NULL, 'If disabled, librarian must confirm return of checked out item when checking out to another.', 'YesNo'), ('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'), -('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'), -('AutoSelfCheckPass','',NULL,'Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','free'), +('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'), +('AutoSelfCheckPass','',NULL,'Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','Free'), ('AutoShareWithMana','subscription',NULL,'defines datas automatically shared with mana','multiple'), ('AutoSwitchPatron', '0', NULL, 'Auto switch to patron', 'YesNo'), ('Babeltheque','0',NULL,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','YesNo'), @@ -128,12 +128,12 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), ('BlockReturnOfLostItems','0',NULL,'If enabled, items that are marked as lost cannot be returned.','YesNo'), ('BlockReturnOfWithdrawnItems','1',NULL,'If enabled, items that are marked as withdrawn cannot be returned.','YesNo'), -('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'), +('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'), -('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'), +('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'), ('BrowseResultSelection','0',NULL,'Enable/Disable browsing search results fromt the bibliographic record detail page in staff interface','YesNo'), ('BundleLostValue','5',NULL,'Sets the LOST AV value that represents "Missing from bundle" as a lost value','Free'), @@ -152,12 +152,12 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('casServerUrl','https://localhost:8443/cas',NULL,'URL of the cas server','Free'), ('casServerVersion','2', '2|3','Version of the CAS server Koha will connect to.','Choice'), ('CatalogConcerns', '0', NULL, 'Allow users to report catalog concerns', 'YesNo'), -('CatalogerEmails', '', NULL, 'Notify these catalogers by email when a catalog concern is submitted', 'free'), +('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'), ('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'), +('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'), ('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'), @@ -191,7 +191,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('CurbsidePickup', '0', NULL, 'Enable curbside pickup', 'YesNo'), ('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'), ('CustomCoverImages','0',NULL,'If enabled, the custom cover images will be displayed in the staff interface. CustomCoverImagesURL must be defined.','YesNo'), -('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'), +('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'), ('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'), ('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'), ('decreaseLoanHighHolds','0',NULL,'Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue','YesNo'), @@ -213,7 +213,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('DefaultLongOverduePatronCategories', '', NULL, 'Set the patron categories that will be listed when longoverdue cronjob is executed', 'choice'), ('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost statuses by default in longoverdue.pl', 'Free'), ('DefaultLongOverdueSkipPatronCategories', '', NULL, 'Set the patron categories that will not be listed when longoverdue cronjob is executed', 'choice'), -('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'), +('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'), ('DefaultPatronSearchMethod','starts_with','starts_with|contains','Choose which search method to use by default when searching with PatronAutoComplete','Choice'), ('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'), ('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'), @@ -244,9 +244,9 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL), ('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL), ('ElasticsearchMARCFormat', 'base64ISO2709', 'base64ISO2709|ARRAY', 'Elasticsearch MARC format. ISO2709 format is recommended as it is faster and takes less space, whereas array is searchable.', 'Choice'), -('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'), -('EmailAddressForPatronRegistrations', '', NULL, ' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ', 'free'), -('EmailAddressForSuggestions','',NULL,' If you choose EmailAddressForSuggestions you have to enter a valid email address: ','free'), +('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'), +('EmailAddressForPatronRegistrations', '', NULL, ' If you choose EmailAddressForPatronRegistrations you have to enter a valid email address: ', 'Free'), +('EmailAddressForSuggestions','',NULL,' If you choose EmailAddressForSuggestions you have to enter a valid email address: ','Free'), ('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'), @@ -268,15 +268,15 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), ('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'), -('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'free'), -('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'free'), +('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'), ('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'), -('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'), +('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'), ('ExpireReservesOnHolidays', '1', NULL, 'If false, reserves at a library will not be canceled on days the library is not open.', 'YesNo'), ('ExportCircHistory', '0', NULL, 'Display the export circulation options', 'YesNo'), ('ExportRemoveFields','',NULL,'List of fields for non export in circulation.pl (separated by a space)','Free'), @@ -300,8 +300,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), ('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'), +('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'), ('GoogleJackets','0',NULL,'if ON, displays jacket covers from Google Books API','YesNo'), ('GoogleOAuth2ClientID', '', NULL, 'Client ID for the web app registered with Google', 'Free'), ('GoogleOAuth2ClientSecret', '', NULL, 'Client Secret for the web app registered with Google', 'Free'), @@ -330,7 +330,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), ('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'), +('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'), @@ -343,11 +343,11 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), ('ILLOpacUnauthenticatedRequest','0',NULL,'Can OPAC users place ILL requests without having to be logged in','YesNo'), -('ILLPartnerCode','IL',NULL,'Patrons from this patron category will be used as partners to place ILL requests with','free'), +('ILLPartnerCode','IL',NULL,'Patrons from this patron category will be used as partners to place ILL requests with','Free'), ('ILLRequestsTabs','',NULL,'Add customizable tabs to interlibrary loan requests list','Textarea'), ('ILLSendStaffNotices', '', NULL, 'Send these ILL notices to staff', 'multiple'), ('ILS-DI','0',NULL,'Enables ILS-DI services at OPAC.','YesNo'), -('ILS-DI:AuthorizedIPs','','Restricts usage of ILS-DI to some IPs','.','Free'), +('ILS-DI:AuthorizedIPs','',NULL,'Restricts usage of ILS-DI to some IPs','Free'), ('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'), @@ -360,15 +360,15 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('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'), -('intranetcolorstylesheet','','50','Define the color stylesheet to use in the staff interface','free'), -('IntranetFavicon','',NULL,'Enter a complete URL to an image to replace the default Koha favicon on the staff interface','free'), +('intranetcolorstylesheet','',NULL,'Define the color stylesheet to use in the staff interface','Free'), +('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'), ('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','','50','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