From d9f0ff72755e61cefbc7d47c81451fa6b5b3834d Mon Sep 17 00:00:00 2001 From: Lari Taskula Date: Fri, 15 Mar 2019 19:03:52 +0000 Subject: [PATCH] Bug 22471: Add system preferences for Finnish installer To test: 1. Apply all patches in this Bug 2. Create an empty database. Make sure database user has permissions to it and $KOHA_CONF is pointing to the correct database. 3. Add Finnish translation, for help, see: https://wiki.koha-community.org/wiki/Installation_of_additional_languages_for_OPAC_and_INTRANET_staff_client 4. Run web installer and select fi-FI as installer language 5. Select all mandatory and optional default values 6. Finish installation and make sure you get no SQL errors Sponsored-by: Hypernova Oy --- .../fi-FI/mandatory/system_preferences.sql | 43 +++++++++++++++++++ .../fi-FI/mandatory/system_preferences.txt | 1 + 2 files changed, 44 insertions(+) create mode 100644 installer/data/mysql/fi-FI/mandatory/system_preferences.sql create mode 100644 installer/data/mysql/fi-FI/mandatory/system_preferences.txt diff --git a/installer/data/mysql/fi-FI/mandatory/system_preferences.sql b/installer/data/mysql/fi-FI/mandatory/system_preferences.sql new file mode 100644 index 0000000000..835390696e --- /dev/null +++ b/installer/data/mysql/fi-FI/mandatory/system_preferences.sql @@ -0,0 +1,43 @@ +-- +-- System preferences that differ from the global defaults +-- +-- This file is part of Koha. +-- +-- Koha is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along +-- with Koha; if not, write to the Free Software Foundation, Inc., +-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +UPDATE systempreferences SET value = 'takaaja' WHERE variable = 'borrowerRelationship'; +UPDATE systempreferences SET value = '' WHERE variable = 'BorrowersTitles'; +UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat'; +UPDATE systempreferences SET value = 'de' WHERE variable = 'AddressFormat'; +UPDATE systempreferences SET value = 'dmydot' WHERE variable = 'dateformat'; +UPDATE systempreferences SET value = 'z' WHERE variable = 'DefaultClassificationSource'; +UPDATE systempreferences SET value = 'Tervetuloa Kohan asiakaskäyttöliittymään!' WHERE variable = 'OpacMainUserBlock'; +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav'; +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom'; +UPDATE systempreferences SET value = + '
  • Muut kirjastot (WorldCat)
  • +
  • Google Scholar
  • +
  • Verkkokaupat (Bookfinder.com)
  • +
  • Open Library (openlibrary.org)
  • ' + WHERE variable = 'OPACSearchForTitleIn'; +-- Sunday = 0, Monday = 1, etc. +UPDATE systempreferences SET value = '1' WHERE variable = 'CalendarFirstDayOfWeek'; +UPDATE systempreferences SET value = '0.24|0.14|0.10|0.00' WHERE variable = 'gist'; +UPDATE systempreferences SET value = 'Vaihda tämä ilmoitus muokkaamalla järjestelmäasetusta RoutingListNote.' where variable = 'RoutingListNote'; +UPDATE systempreferences SET value = 'barcode' WHERE variable = 'uniqueitemfields'; +UPDATE systempreferences SET value = 'fi-FI,en' WHERE variable = 'language'; +UPDATE systempreferences SET value = 'fi-FI,en' WHERE variable = 'opaclanguages'; +UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay'; +UPDATE systempreferences SET value = 'fin' WHERE variable = 'DefaultLanguageField008'; +UPDATE systempreferences SET value = '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 Å Ä Ö' WHERE variable = 'alphabet'; diff --git a/installer/data/mysql/fi-FI/mandatory/system_preferences.txt b/installer/data/mysql/fi-FI/mandatory/system_preferences.txt new file mode 100644 index 0000000000..4b5a6bf4e8 --- /dev/null +++ b/installer/data/mysql/fi-FI/mandatory/system_preferences.txt @@ -0,0 +1 @@ +Järjestelmäasetukset -- 2.17.1