From ed2523b6ebbdd3a34f1bea9984609d9c421b9f34 Mon Sep 17 00:00:00 2001 From: Rafal Kopaczka Date: Tue, 2 Dec 2014 15:24:01 +0100 Subject: [PATCH] [PASSED QA] Bug 13373 - Update Polish web installer sample data files. Part 2/2 - optional files. Changes: - Deleted unnecessary files - Translated description files and some values in sql files To test: - Aplly patch - Run webinstaller on empty database (drop database and create new 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 --- installer/data/mysql/pl-PL/optional/auth_val.sql | 39 +++++++++++++++----- installer/data/mysql/pl-PL/optional/parameters.sql | 9 ++--- .../mysql/pl-PL/optional/patron_categories.txt | 32 ++++++++-------- .../data/mysql/pl-PL/optional/sample_budgets.sql | 11 ------ .../data/mysql/pl-PL/optional/sample_budgets.txt | 1 - .../data/mysql/pl-PL/optional/sample_labels.sql | 21 ----------- .../data/mysql/pl-PL/optional/sample_labels.txt | 9 ----- .../mysql/pl-PL/optional/sample_z3950_servers.sql | 19 +++++++--- .../mysql/pl-PL/optional/sample_z3950_servers.txt | 7 +++- 9 files changed, 68 insertions(+), 80 deletions(-) delete mode 100644 installer/data/mysql/pl-PL/optional/sample_budgets.sql delete mode 100644 installer/data/mysql/pl-PL/optional/sample_budgets.txt delete mode 100644 installer/data/mysql/pl-PL/optional/sample_labels.sql delete mode 100644 installer/data/mysql/pl-PL/optional/sample_labels.txt diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql index ad605c0..6e0b04c 100644 --- a/installer/data/mysql/pl-PL/optional/auth_val.sql +++ b/installer/data/mysql/pl-PL/optional/auth_val.sql @@ -5,13 +5,13 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); -- availability statuses -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost'); -INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For'); -INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Długo przetrzymywany (Zagubiony)'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Zagubiony'); +INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Zagubiony i opłacony'); +INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Zaginiony'); -- damaged status of an item -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Uszkodzony'); -- location qualification for an item, departments are linked by default to items.location INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction'); @@ -22,6 +22,8 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC', INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks'); INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual'); INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center'); -- collection codes for an item INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); @@ -29,15 +31,32 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); -- withdrawn status of an item, linked to items.withdrawn -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Wycofany'); -- loanability status of an item, linked to items.notforloan -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Zamówiony'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nie do wypożyczenia'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Zasób pracowniczy'); -- restricted status of an item, linked to items.restricted -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Ograniczony dostęp'); + +-- manual invoice types +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Opłata za ksero','.25'); + +-- custom borrower notes +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Uwagi do adresu'); + +-- OPAC Suggestions reasons +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author'); + +-- Report groups +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Udostępnianie'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Katalog'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Uzytkownicy'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Gromadzenie'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Konta'); -- SIP2 media types INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other'); diff --git a/installer/data/mysql/pl-PL/optional/parameters.sql b/installer/data/mysql/pl-PL/optional/parameters.sql index 2b7b886..15623e8 100644 --- a/installer/data/mysql/pl-PL/optional/parameters.sql +++ b/installer/data/mysql/pl-PL/optional/parameters.sql @@ -1,6 +1,5 @@ INSERT INTO `currency` (currency, rate, symbol, active) VALUES -('PLN', 1.0, 'zł', 1), -('USD', 2.77, '$', 0), -('GBP', 4.5, '£', 0), -('EUR', 4.1, '€', 0); - +('PLN', 1.0, 'zł', '1'), +('USD', .2988, '$', '0'), +('GBP', .1903, '£', '0'), +('EUR', .2403, '€', '0'); diff --git a/installer/data/mysql/pl-PL/optional/patron_categories.txt b/installer/data/mysql/pl-PL/optional/patron_categories.txt index 9bbd5b6..9b03cc9 100644 --- a/installer/data/mysql/pl-PL/optional/patron_categories.txt +++ b/installer/data/mysql/pl-PL/optional/patron_categories.txt @@ -1,25 +1,25 @@ Przykładowe typy i kategorie czytelników: -Type: Categories: +Typ: Kategoria: -Adult Patron - default patron type - PT - Patron +Dorosły użytkownik - domyślny typ użytkownika + PT - Czytelnik ST - Student BH - Homebound -Child - patron with a guarantor - K - Kid - J - Juvenile - YA - Young Adult +Dziecko - użytkownik z nadzorcą (dorosłym) + K - Dziecko + J - Nastolatek + YA - Młodież -Organization - patron is an institution, not a person - ILL - Inter-library Loan - SC - School - L - Library +Organizacja - konto instytucji, a nie osoby + ILL - Wypożyczalnia międzybiblioteczna + SC - Szkoła + L - Biblioteka -Professional - a member of an organization (organization is guarantor) - T - Teacher - S - Staff - B - Board +Pracownik - członek organizacji (organizacja jest nadzorcą) + T - Nauczyciel + S - Pracownik + B - Zarząd -Types are currently hardcoded, but you can add/edit/delete categories after installation from the administration module. +Typy w chwili obecnej są zdefiniowane na stałe. Kategorie mogą być dodawane/modyfikowane/usuwane po zakończeniu instalacji w module administracyjnym. diff --git a/installer/data/mysql/pl-PL/optional/sample_budgets.sql b/installer/data/mysql/pl-PL/optional/sample_budgets.sql deleted file mode 100644 index a17dd1c..0000000 --- a/installer/data/mysql/pl-PL/optional/sample_budgets.sql +++ /dev/null @@ -1,11 +0,0 @@ -INSERT INTO `aqbudget` VALUES - -('CHILD','2008-01-01','2008-12-31','5000.00',1,''), -('GEN','2008-01-01','2008-12-31','20000.00',2,''), -('REF','2008-01-01','2008-12-31','5000.00',3,''); - -INSERT INTO `aqbookfund` VALUES - -('CHILD','Children\'s Materials',NULL,''), -('GEN','General Stacks',NULL,''), -('REF','Reference Materials',NULL,''); diff --git a/installer/data/mysql/pl-PL/optional/sample_budgets.txt b/installer/data/mysql/pl-PL/optional/sample_budgets.txt deleted file mode 100644 index 4eed6bd..0000000 --- a/installer/data/mysql/pl-PL/optional/sample_budgets.txt +++ /dev/null @@ -1 +0,0 @@ -Przykładowe budżety i fundusze. diff --git a/installer/data/mysql/pl-PL/optional/sample_labels.sql b/installer/data/mysql/pl-PL/optional/sample_labels.sql deleted file mode 100644 index c0fdd13..0000000 --- a/installer/data/mysql/pl-PL/optional/sample_labels.sql +++ /dev/null @@ -1,21 +0,0 @@ --- Label Templates -LOCK TABLES `labels_templates` WRITE; -/*!40000 ALTER TABLE `labels_templates` DISABLE KEYS */; -INSERT INTO `labels_templates` VALUES -(1,0,'Avery 5160 | 1 x 2-5/8', '3 columns, 10 rows of labels', 8.5, 11, 2.63, 1, 0.139, 0, 0.35, 0.23, 3, 10, 0.13, 0, 'INCH'), -(2,0,'Gaylord 8511 Spine Label','Prints only the left-hand column of a Gaylord 8511.', 8.5, 11, 1, 1.25, 0.6, 0.5, 0, 0, 1, 8, 0, 0, 'INCH'), -(3,0,'Avery 5460 vertical', '', 3.625, 5.625, 1.5, 0.75, 0.38, 0.35, 2, 7, 2, 1, 0.25, 0, 'INCH'), -(4,0,'Avery 5460 spine labels', '', 5.625, 3.625, 0.75, 1.5, 0.35, 0.31, 7, 2, 1, 0, 0.25, 0, 'INCH'), -(5,0,'Avery 8163', '2rows x 5 rows', 8.5, 11, 4, 2, 0, 0, 0.5, 0.17, 2, 5, 0.2, 0.01, 'INCH'), -(6,0,'cards', 'Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\" [3x10] : equivalent: Gaylord JD-ML3000', 8.5, 11, 2.75, 1.05, 0, 0, 0.25, 0, 3, 10, 0.2, 0.01, 'INCH'), -(7,0,'Demco WS14942260', '1\" X 1.5\" Spine Label', 8.5, 11, 1.5, 1, 0.236, 0, 0.4, 0.25, 5, 10, 0.0625, 0, 'INCH'); -/*!40000 ALTER TABLE `labels_templates` ENABLE KEYS */; -UNLOCK TABLES; -LOCK TABLES `labels_layouts` WRITE; -/*!40000 ALTER TABLE `labels_layouts` DISABLE KEYS */; -INSERT INTO `labels_layouts` VALUES -(1,'CODE39','BIBBAR', 'biblio and barcode', 0, 'TR',7,0,'L','title, author, itemcallnumber'), -(2,'CODE39','BIB', 'spine', 0, 'TR',3,1,'L','itemcallnumber'), -(3,'CODE39','BARBIB', 'barcode and biblio', 0, 'TR',3,1,'L','title, author, itemcallnumber'); -/*!40000 ALTER TABLE `labels_layouts` ENABLE KEYS */; -UNLOCK TABLES; diff --git a/installer/data/mysql/pl-PL/optional/sample_labels.txt b/installer/data/mysql/pl-PL/optional/sample_labels.txt deleted file mode 100644 index 5b898d3..0000000 --- a/installer/data/mysql/pl-PL/optional/sample_labels.txt +++ /dev/null @@ -1,9 +0,0 @@ -Przykładowe etykiety: - -Avery 5160 | 1 x 2-5/8 -Gaylord 8511 Spine Label -Avery 5460 - vertical -Avery 5460 - spine labels -Avery 8163 - 2rows x 5 rows -cards Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8" [3x10] : equivalent: Gaylord JD-ML3000 -Demco WS14942260 | 1" X 1.5" Spine Label diff --git a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql b/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql index 10684e1..ecbcc71 100644 --- a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql @@ -1,5 +1,14 @@ -INSERT INTO `z3950servers` -(`host`, `port`, `db`, `userid`, `password`, `servername`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES -('193.59.172.100',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,1,'MARC21','UTF8'), -('62.181.1.243',4321,'bilbo','','','BP BEMOWO',2,1,1,'MARC21','UTF8'), -('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',3,0,1,'USMARC','utf8'); +INSERT INTO z3950servers +(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES +('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'), +('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), +('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), +('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), +('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); + +#Insert SRU server +INSERT INTO z3950servers +(host, port, db, servername, syntax, encoding, servertype, sru_fields) +VALUES +('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier'); diff --git a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt b/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt index 47ba7ae..afb8fee 100644 --- a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt +++ b/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt @@ -1,3 +1,6 @@ BIBLIOTEKA NARODOWA -BIBLIOTEKA PUBLICZNA DZIELNICY BEMOWO -LIBRARY OF CONGRESS +BIBLIOTEKA KONGRESU +BIBLIOTEKA KONGRESU FORMALNE (Hasła wzorcowe) +BIBLIOTEKA KONGRESU PRZEDMIOTOWE (Hasła wzorcowe) +COLUMBIA UNIVERSITY +SMITHSONIAN INSTITUTION LIBRARIES -- 1.7.2.5