From 9902369cffae21566554f7838c202338291fc0f1 Mon Sep 17 00:00:00 2001 From: Rafal Kopaczka Date: Tue, 2 Dec 2014 14:14:23 +0100 Subject: [PATCH] [PASSED QA] Bug 13373 [1/2] - Update Polish web installer sample data files. Part 1/2 - mandatory files. Changes: - Translated user permission and user flags. - Changed untranslated different files from en version - Deleted unnecessary files To test: - Aplly patch - Run webinstaller on empty database (drop database if necessary) - Verify everything works, especially verify you have permission to all modules, eg. Tools, Catalouging etc. - Check spelling and grammar if you can :) Signed-off-by: Chris Signed-off-by: Katrin Fischer Signed-off-by: Kyle M Hall --- .../pl-PL/mandatory/message_transport_types.sql | 1 + .../data/mysql/pl-PL/mandatory/sample_notices.sql | 9 +- .../mysql/pl-PL/mandatory/system_preferences.sql | 20 --- .../mysql/pl-PL/mandatory/system_preferences.txt | 1 - installer/data/mysql/pl-PL/mandatory/userflags.sql | 39 +++--- .../data/mysql/pl-PL/mandatory/userpermissions.sql | 137 ++++++++++---------- 6 files changed, 92 insertions(+), 115 deletions(-) delete mode 100644 installer/data/mysql/pl-PL/mandatory/system_preferences.sql delete mode 100644 installer/data/mysql/pl-PL/mandatory/system_preferences.txt diff --git a/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql b/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql index ba8b958..ed3c4ad 100644 --- a/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql +++ b/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql @@ -2,5 +2,6 @@ INSERT INTO message_transport_types (message_transport_type) values ('email'), +('print'), ('sms'), ('phone'); diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql index 50e0cd5..2281739 100644 --- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -1,7 +1,5 @@ -INSERT INTO letter (module, code, name, title, content, message_transport_type) -VALUES -('circulation','ODUE','Overdue Notice', -'Item Overdue','Dear <> <>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<>\n<>\n<> <>\nPhone: <>\nFax: <>\nEmail: <>\n\nIf you have registered a password with the library, and you have a renewal available, you may renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned.\n\nThe following item(s) is/are currently overdue:\n\n"<>" by <>, <>, Barcode: <> Fine: <>\n\nThank-you for your prompt attention to this matter.\n\n<> Staff\n', 'email'), +INSERT INTO `letter` (module, code, name, title, content, message_transport_type) +VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<>\n<>\n<> <>\nPhone: <>\nFax: <>\nEmail: <>\n\nIf you have registered a password with the library, and you have a renewal available, you may renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned.\n\nThe following item(s) is/are currently overdue:\n\n"<>" by <>, <>, Barcode: <> Fine: <>\n\nThank-you for your prompt attention to this matter.\n\n<> Staff\n', 'email'), ('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> ordered) ($<> each) has not been received.', 'email'), ('serial','RLIST','Routing List','Serial is now available','<> <>,\r\n\r\nThe following issue is now available:\r\n\r\n<>, <> (<>)\r\n\r\nPlease pick it up at your convenience.', 'email'), ('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha account details.','Hello <> <> <>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser: <>\r\nPassword: <>\r\n\r\nIf you have any problems or questions regarding your account, please contact your Koha Administrator.\r\n\r\nThank you,\r\nKoha Administrator\r\nkohaadmin@yoursite.org', 'email'), @@ -9,6 +7,7 @@ VALUES ('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <> items due', 'email'), ('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item Due','Dear <> <>,\r\n\r\nThe following item will be due soon:\r\n\r\n<>, <> (<>)', 'email'), ('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <> items due soon', 'email'), +('circulation','RENEWAL','Item Renewals','Item Renewals','The following items have been renewed:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.', 'email'), ('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup at <>', 'Dear <> <>,\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\nLocation: <>\r\n<>\r\n<>\r\n<>\r\n<> <>', 'email'), ('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup (print notice)', '<>\r\n<>\r\n<>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <> <>\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\n', 'print'), ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following items have been checked in:\r\n----\r\n<>\r\n----\r\nThank you.', 'email'), @@ -119,8 +118,6 @@ http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<>\r\n----\r\nThank you for visiting <>.'); - INSERT INTO letter (module, code, branchcode, name, is_html, title, content) VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, diff --git a/installer/data/mysql/pl-PL/mandatory/system_preferences.sql b/installer/data/mysql/pl-PL/mandatory/system_preferences.sql deleted file mode 100644 index 0a38ef9..0000000 --- a/installer/data/mysql/pl-PL/mandatory/system_preferences.sql +++ /dev/null @@ -1,20 +0,0 @@ --- --- 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 = 'father|mother' where variable = 'borrowerRelationship'; -UPDATE systempreferences SET value = 'Mr|Mrs|Miss|Ms' where variable = 'BorrowersTitles'; diff --git a/installer/data/mysql/pl-PL/mandatory/system_preferences.txt b/installer/data/mysql/pl-PL/mandatory/system_preferences.txt deleted file mode 100644 index 9fe96df..0000000 --- a/installer/data/mysql/pl-PL/mandatory/system_preferences.txt +++ /dev/null @@ -1 +0,0 @@ -Domyślne ustawienia systemu diff --git a/installer/data/mysql/pl-PL/mandatory/userflags.sql b/installer/data/mysql/pl-PL/mandatory/userflags.sql index 55fa157..d0b30cb 100644 --- a/installer/data/mysql/pl-PL/mandatory/userflags.sql +++ b/installer/data/mysql/pl-PL/mandatory/userflags.sql @@ -1,19 +1,20 @@ -INSERT INTO `userflags` VALUES(0,'superlibrarian','Access to all librarian functions',0); -INSERT INTO `userflags` VALUES(1,'circulate','Circulate books',0); -INSERT INTO `userflags` VALUES(2,'catalogue','View Catalog (Librarian Interface)',0); -INSERT INTO `userflags` VALUES(3,'parameters','Set Koha system parameters',0); -INSERT INTO `userflags` VALUES(4,'borrowers','Add or modify borrowers',0); -INSERT INTO `userflags` VALUES(5,'permissions','Set user permissions',0); -INSERT INTO `userflags` VALUES(6,'reserveforothers','Place and modify holds for patrons',0); -INSERT INTO `userflags` VALUES(7,'borrow','Borrow books',1); -INSERT INTO `userflags` VALUES(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0); -INSERT INTO `userflags` VALUES(10,'updatecharges','Update borrower charges',0); -INSERT INTO `userflags` VALUES(11,'acquisition','Acquisition and/or suggestion management',0); -INSERT INTO `userflags` VALUES(12,'management','Set library management parameters',0); -INSERT INTO `userflags` VALUES(13,'tools','Use tools (export, import, barcodes)',0); -INSERT INTO `userflags` VALUES(14,'editauthorities','Allow to edit authorities',0); -INSERT INTO `userflags` VALUES(15,'serials','Allow to manage serials subscriptions',0); -INSERT INTO `userflags` VALUES(16,'reports','Allow to access to the reports module',0); -INSERT INTO `userflags` VALUES(17,'staffaccess','Modify login / permissions for staff users',0); -INSERT INTO `userflags` VALUES(18,'coursereserves','Course Reserves',0); -INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0'); +INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES +(0,'superlibrarian','Dostęp do wszystkich ustawień',0), +(1,'circulate','Wypożyczanie i zwracanie pozycji',0), +(2,'catalogue','Dostęp do interfejsu bibliotekarza. Interfejs bibliotekarza, umożliwia przeglądanie katalogu.',0), +(3,'parameters','Zarządzanie utawieniami systemowymi (Panel administracyjny)',0), +(4,'borrowers','Dodawanie i modyfikowanie użytkowników',0), +(5,'permissions','Ustawianie uprawnień użytkownikom',0), +(6,'reserveforothers','Składanie i modyfikacja zamówień w imieniu użytkowników',0), +(7,'borrow','Wypożyczanie książek',1), +(9,'editcatalogue','Modyfikowanie katalogu (Modyfikacja rekordów bibliograficznych/egzemplarza)',0), +(10,'updatecharges','Zarządzanie należnościami',0), +(11,'acquisition','Gromadzenie oraz/lub zarządzanie propozycjami zakupu',0), +(12,'management','Ustawianie zarządzania biblioteką (wycofane)',0), +(13,'tools','Narzędzia (rozwiń w celu barziej szczegółowego nadawania uprawnień)',0), +(14,'editauthorities','Modyfikacja haseł wzorcowych',0), +(15,'serials','Zarządzanie prenumeratami',0), +(16,'reports','Zezwól na dostęp do modułu raportów',0), +(17,'staffaccess','Pozwolenie na modyfikacje uprawnień innych pracowników',0), +(18,'coursereserves','Kursy',0), +(19, 'plugins', 'Wtyczki Koha', '0'); diff --git a/installer/data/mysql/pl-PL/mandatory/userpermissions.sql b/installer/data/mysql/pl-PL/mandatory/userpermissions.sql index 9564a6f..e736763 100644 --- a/installer/data/mysql/pl-PL/mandatory/userpermissions.sql +++ b/installer/data/mysql/pl-PL/mandatory/userpermissions.sql @@ -1,76 +1,75 @@ INSERT INTO permissions (module_bit, code, description) VALUES - ( 1, 'circulate_remaining_permissions', 'Remaining circulation permissions'), - ( 1, 'override_renewals', 'Override blocked renewals'), - ( 1, 'overdues_report', 'Execute overdue items report'), - ( 1, 'force_checkout', 'Force checkout if a limitation exists'), - ( 1, 'manage_restrictions', 'Manage restrictions for accounts'), - ( 3, 'parameters_remaining_permissions', 'Remaining system parameters permissions'), - ( 3, 'manage_circ_rules', 'manage circulation rules'), - ( 6, 'place_holds', 'Place holds for patrons'), - ( 6, 'modify_holds_priority', 'Modify holds priority'), - ( 9, 'edit_catalogue', 'Edit catalogue'), + ( 1, 'circulate_remaining_permissions', 'Pozostałe uprawnienia udostępniania'), + ( 1, 'override_renewals', 'Pozwolenie na ominięcie zablokowanego odnawiania wypożyczeń'), + ( 1, 'overdues_report', 'Uruchamianie raportu o przetrzymanych egzemplarzach'), + ( 1, 'force_checkout', 'Pozwolenie na wypożyczenie, pomimo ograniczeń'), + ( 1, 'manage_restrictions', 'Zarządzanie ograniczeniami dla kont'), + ( 3, 'parameters_remaining_permissions', 'Pozostałe ustawienia systemowe'), + ( 3, 'manage_circ_rules', 'Zarządzanie zasadami wypożyczeń'), + ( 6, 'place_holds', 'Składanie zamówień w imieniu użytkownika'), + ( 6, 'modify_holds_priority', 'Modyfikacja kolejki rezerwacji'), + ( 9, 'edit_catalogue', 'Modyfikowanie katalogu (Modyfikacja rekordów bibliograficznych/egzemplarza)'), ( 9, 'fast_cataloging', 'Szybkie katalogowanie'), - ( 9, 'edit_items', 'Edit Items'), - ( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'), - ( 9, 'delete_all_items', 'Delete all items at once'), - (10, 'writeoff', 'Write off fines and fees'), - (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'), - (11, 'vendors_manage', 'Zarządzanei dostawcami'), + ( 9, 'edit_items', 'Modyfikowanie egzemplarzy'), + ( 9, 'edit_items_restricted', 'Ograniczenie edycji egzemplarzy do pól zdefiniwanych w ustawieniach SubfieldsToAllowForRestrictedEditing (uprawienia edit_item również są wymagane)'), + ( 9, 'delete_all_items', 'Usuwanie wszystkich egzemplarzy naraz'), + (10, 'writeoff', 'Anulowanie należności'), + (10, 'remaining_permissions', 'Pozostałe uprawnienia do zarządzania należnościami'), + (11, 'vendors_manage', 'Zarządzanie dostawcami'), (11, 'contracts_manage', 'Zarządzanie kontraktami'), - (11, 'period_manage', 'Manage periods'), - (11, 'budget_manage', 'Manage budgets'), - (11, 'budget_modify', 'Modify budget (can''t create lines, but can modify existing ones)'), - (11, 'planning_manage', 'Manage budget plannings'), - (11, 'order_manage', 'Manage orders & basket'), - (11, 'order_manage_all', 'Manage all orders and baskets, regardless of restrictions on them'), - (11, 'group_manage', 'Manage orders & basketgroups'), - (11, 'order_receive', 'Manage orders & basket'), - (11, 'budget_add_del', 'Add and delete budgets (but cant modify budgets)'), - (11, 'budget_manage_all', 'Manage all budgets'), - (13, 'edit_news', 'RTworzeniei publikowanie wiadomości w interfejsie bibliotekarza i OPAC'), - (13, 'label_creator', 'Create printable labels and barcodes from catalog and patron data'), - (13, 'edit_calendar', 'Define days when the library is closed'), - (13, 'moderate_comments', 'Moderate patron comments'), - (13, 'edit_notices', 'Define notices'), - (13, 'edit_notice_status_triggers', 'Set notice/status triggers for overdue items'), - (13, 'edit_quotes', 'Edit quotes for quote-of-the-day feature'), + (11, 'period_manage', 'Zarządzanie funduszami'), + (11, 'budget_manage', 'Zarządzanie budżetem'), + (11, 'budget_modify', 'Modyfikowanie budżetu (nie można dodać, ale można modyfikować istniejący)'), + (11, 'planning_manage', 'Zarządzanie planowaniem budżetu'), + (11, 'order_manage', 'Zarządzanie zamówieniami i koszykami'), + (11, 'order_manage_all', 'Zarządzanie zamówieniami i koszykami, niezależnie od ich ustawień'), + (11, 'group_manage', 'Zarządzanie zamówieniami i grupami koszyków'), + (11, 'order_receive', 'Zarządzanie zamówieniami i koszykami'), + (11, 'budget_add_del', 'Dodawanie i usuwanie budżetów (bez modyfikacji)'), + (11, 'budget_manage_all', 'Zarządzanie wszystkimi budżetami'), + (13, 'edit_news', 'Tworzenie i publikowanie wiadomości w interfejsie bibliotekarza i OPAC'), + (13, 'label_creator', 'Tworzenie drukowalnych etykiet i kodów kreskowych z katalogu i danych użytkowników'), + (13, 'edit_calendar', 'Definiowanie dni, w których biblioteka jest nieczynna'), + (13, 'moderate_comments', 'Moderowanie komentarzy użytkowników'), + (13, 'edit_notices', 'Definiowanie powiadomień'), + (13, 'edit_notice_status_triggers', 'Ustawianie wyzwalaczy powiadomień/blokad dla egzemplarzy przetrzymanych'), + (13, 'edit_quotes', 'Modyfikowanie cytatów w funkcji cytat dnia'), (13, 'view_system_logs', 'Przeglądanie logów systemowych'), - (13, 'inventory', 'Perform inventory (stocktaking) of your catalog'), - (13, 'stage_marc_import', 'Stage MARC records into the reservoir'), - (13, 'manage_staged_marc', 'Managed staged MARC records, including completing and reversing imports'), - (13, 'export_catalog', 'Export bibliographic and holdings data'), - (13, 'import_patrons', 'Import patron data'), - (13, 'edit_patrons', 'Perform batch modification of patrons'), - (13, 'delete_anonymize_patrons', 'Delete old borrowers and anonymize circulation history (deletes borrower reading history)'), - (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'), - (13, 'schedule_tasks', 'Schedule tasks to run'), - (13, 'items_batchmod', 'Perform batch modification of items'), - (13, 'items_batchmod_restricted', 'Limit batch item modification to subfields defined in the SubfieldsToAllowForRestrictedBatchmod preference (please note that items_batchmod is still required)'), - (13, 'items_batchdel', 'Perform batch deletion of items'), - (13, 'manage_csv_profiles', 'Manage CSV export profiles'), - (13, 'moderate_tags', 'Moderate patron tags'), - (13, 'marc_modification_templates', 'Manage marc modification templates'), - (16, 'execute_reports', 'Execute SQL reports'), - (13, 'rotating_collections', 'Manage rotating collections'), - (13, 'upload_local_cover_images', 'Upload local cover images'), - (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'), - (13, 'records_batchdel', 'Perform batch deletion of records (bibliographic or authority)'), - (15, 'check_expiration', 'Check the expiration of a serial'), - (15, 'claim_serials', 'Claim missing serials'), - (15, 'create_subscription', 'Create a new subscription'), - (15, 'delete_subscription', 'Delete an existing subscription'), - (15, 'edit_subscription', 'Edit an existing subscription'), - (15, 'receive_serials', 'Serials receiving'), - (15, 'renew_subscription', 'Renew a subscription'), - (15, 'routing', 'Routing'), - (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependantBranches is used)'), - (16, 'execute_reports', 'Execute SQL reports'), - (16, 'create_reports', 'Create SQL Reports'), - (18, 'manage_courses', 'Add, edit and delete courses'), + (13, 'inventory', 'Przeprowadzanie skontrum'), + (13, 'stage_marc_import', 'Import rekordów MARC do rezerwuaru'), + (13, 'manage_staged_marc', 'Zarządzanie zaimportowanymi rekordami, finalizacja importu lub wycofanie rekordów'), + (13, 'export_catalog', 'Eksport rekordów bibliograficznych i egzemplarza'), + (13, 'import_patrons', 'Importowanie czytelników'), + (13, 'edit_patrons', 'Modyfikacja grupowa użytkowników'), + (13, 'delete_anonymize_patrons', 'Usuwanie użytkowników i usuwanie historii wypożyczeń'), + (13, 'batch_upload_patron_images', 'Łasowanie zdjęcia użytkownika, grupowo lub pojedyńczo'), + (13, 'schedule_tasks', 'Planowanie uruchamiania zadań'), + (13, 'items_batchmod', 'Grupowa modyfikacja egzemplarzy'), + (13, 'items_batchmod_restricted', 'Ograniczenie grupowej edycji egzemplarzy do pól zdefiniwanych w ustawieniach SubfieldsToAllowForRestrictedBatchmod (uprawienia items_batchmod również są wymagane)'), + (13, 'items_batchdel', 'Grupowe usuwanie egzemplarzy'), + (13, 'manage_csv_profiles', 'Zarządzanie profilami eksportu do CSV'), + (13, 'moderate_tags', 'Zarządzanie tagami'), + (13, 'rotating_collections', 'Zarządzanie kolekcjami czasowymi'), + (13, 'upload_local_cover_images', 'Ładowanie obrazu okładek'), + (13, 'manage_patron_lists', 'Dodawanie, modyfikacja i usuwanie list użytkowników i ich zawartości'), + (13, 'marc_modification_templates', 'Zarządzanie szablonami modyfikacji marc'), + (13, 'records_batchdel', 'Grupowe usuwanie rekordów (bibliograficznych lub haseł wzorcowych)'), + (15, 'check_expiration', 'Sprawdzanie daty wygaśnięcia prenumeraty'), + (15, 'claim_serials', 'Składanie reklamacji na brakujący numer'), + (15, 'create_subscription', 'Tworzenie nowej prenumeraty'), + (15, 'delete_subscription', 'Usuwanie prenumeraty'), + (15, 'edit_subscription', 'Modyfikacja istniejącej prenumeraty'), + (15, 'receive_serials', 'Odbiór czasopism'), + (15, 'renew_subscription', 'Odnawianie prenumeraty'), + (15, 'routing', 'Zarządanie obiegiem'), + (15, 'superserials', 'Zarządzanie prenumeratą w każdej filii (ma zastosowanie tylko gdy używamy opcji IndependentBranches)'), + (16, 'execute_reports', 'Uruchamianie raportów SQL'), + (16, 'create_reports', 'Tworzenie raportów SQL'), + (18, 'manage_courses', 'Dodawanie, modyfikacja i usuwanie kursów'), (18, 'add_reserves', 'Add course reserves'), (18, 'delete_reserves', 'Remove course reserves'), - (19, 'manage', 'Manage plugins ( install / uninstall )'), - (19, 'tool', 'Use tool plugins'), - (19, 'report', 'Use report plugins'), - (19, 'configure', 'Configure plugins') + (19, 'manage', 'Zarządzanie wtyczkami ( instalacja / deinstalacja )'), + (19, 'tool', 'Użyuwanie wtyczek narzędzi'), + (19, 'report', 'Używanie wtyczek raportów'), + (19, 'configure', 'Konfiguracja wtyczek') ; -- 1.7.2.5