Bugzilla – Attachment 34613 Details for
Bug 13373
Update Polish web installer sample data files
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13373 - Update Polish web installer sample data files.
Bug-13373---Update-Polish-web-installer-sample-dat.patch (text/plain), 15.04 KB, created by
Chris Cormack
on 2014-12-21 09:45:49 UTC
(
hide
)
Description:
Bug 13373 - Update Polish web installer sample data files.
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2014-12-21 09:45:49 UTC
Size:
15.04 KB
patch
obsolete
>From 1b6fea2810d30d9393f64245ffc3969e11708552 Mon Sep 17 00:00:00 2001 >From: Rafal Kopaczka <rkk0@poczta.onet.pl> >Date: Tue, 2 Dec 2014 15:24:01 +0100 >Subject: [PATCH] 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 <chris@bigballofwax.co.nz> >--- > 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.10.4
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=34613">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13373
:
34065
|
34066
|
34612
|
34613
|
35398
|
35399
|
35400
|
35421
|
35422
|
35423
|
35424
|
35425
|
35426
|
35495
|
35496
|
35497
|
35498
|
35499
|
35500
|
35501
|
35502
|
35503
|
35504