From 4fda4d60c1fb3b8f644a74326e4876d93abac175 Mon Sep 17 00:00:00 2001 From: Zeno Tajoli Date: Thu, 12 Nov 2015 12:57:05 +0100 Subject: [PATCH] Bug 15178: Update of Italian web installer .sql files for 3.22 - iNot worked on notices.sql becouse there is a bug on it (Bz 15177) - Some change in Italian default system preference settings. To test: - Run the web installer in Italian with all sample files selected - Confirm no error messages are shown http://bugs.koha-community.org/show_bug.cgi?id=15178 Signed-off-by: Frederic Demians Proofreading OK. Web installer OK. Tutto bene, grazie Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- .../data/mysql/it-IT/necessari/auth_val.sql | 18 ++++++++------- .../it-IT/necessari/sample_creator_data.sql | 3 ++- .../it-IT/necessari/sample_itemtypes.sql | 14 ++++++------ .../it-IT/necessari/sample_numberpatterns.sql | 2 +- .../it-IT/necessari/system_preferences.sql | 22 ++++++------------- 5 files changed, 27 insertions(+), 32 deletions(-) diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql index 4c8cfb50b0..15d8a28e5d 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -30,6 +30,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','S INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','CART','Scaffale smistamento'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','PROC','Centro lavorazione'); -- collection codes for an item INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); @@ -85,7 +87,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Utenti'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisizione'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Serials'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Seriali'); -- SIP2 media types INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other'); @@ -101,15 +103,15 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Libro con audiocassette'); -- order cancellation reasons -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'Nessuna ragione fornita'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Fuori mercato'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'In ristampa'); -- Desired formats for requesting new materials -INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); -INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); -INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook'); -INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Libro', 'Libro'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'A caratteri ingranditi', 'A caratteri ingranditi'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'Ebook', 'Ebook'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiolibro', 'Audiolibro'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); SET FOREIGN_KEY_CHECKS=1; diff --git a/installer/data/mysql/it-IT/necessari/sample_creator_data.sql b/installer/data/mysql/it-IT/necessari/sample_creator_data.sql index bb33fc391e..77981efd64 100644 --- a/installer/data/mysql/it-IT/necessari/sample_creator_data.sql +++ b/installer/data/mysql/it-IT/necessari/sample_creator_data.sql @@ -3,7 +3,8 @@ LOCK TABLES `creator_layouts` WRITE; /*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */; -INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES (1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','','Labels'), +INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES +(1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','','Labels'), (2,'CODE39',1,'BAR','Test etic. (BAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','','Labels'), (3,'CODE39',1,'BAR','Test tessere',0,'TR',10,'POINT',0,'L','barcode',' diff --git a/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql b/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql index 93fea976c9..3a931dcfa1 100644 --- a/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql +++ b/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql @@ -1,12 +1,12 @@ SET FOREIGN_KEY_CHECKS=0; -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',5,0,'bridge/book.gif',''); -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',5,0,'bridge/kit.gif',''); -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''); -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',5,0,'bridge/map.gif',''); -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',5,1,'bridge/dvd.gif',''); -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',5,0,'bridge/sound.gif',''); -INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',5,0,'bridge/periodical.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',0,0,'bridge/book.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',0,0,'bridge/kit.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',0,0,'bridge/computer_file.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',0,0,'bridge/map.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',0,1,'bridge/dvd.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',0,0,'bridge/sound.gif',''); +INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',0,0,'bridge/periodical.gif',''); INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'',''); SET FOREIGN_KEY_CHECKS=1; diff --git a/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql b/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql index bc50195ef3..2cd35ce22f 100644 --- a/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql +++ b/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql @@ -9,7 +9,7 @@ VALUES NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), - ('Volume, Number, Issue', 2, 'Volume Numero Copia 1', 'Vol.{X}, Number {Y}, Issue {Z}', + ('Volume, Number, Issue', 2, 'Volume Numero Copia 1', 'Vol.{X}, Num. {Y}, Fasc. {Z}', 'Volume', 1, 48, 99999, 1, NULL, 'Number', 1, 4, 12, 1, NULL, 'Issue', 1, 1, 4, 1, NULL), diff --git a/installer/data/mysql/it-IT/necessari/system_preferences.sql b/installer/data/mysql/it-IT/necessari/system_preferences.sql index 94a00b9a36..ee2329d5bd 100644 --- a/installer/data/mysql/it-IT/necessari/system_preferences.sql +++ b/installer/data/mysql/it-IT/necessari/system_preferences.sql @@ -20,48 +20,40 @@ UPDATE systempreferences SET value = 'cataloguing' WHERE variable = 'AcqCreateIt UPDATE systempreferences SET value = '1' WHERE variable = 'AllowRenewalLimitOverride'; UPDATE systempreferences SET value = 'annual' WHERE variable = 'autoBarcode'; UPDATE systempreferences SET value = 'email' WHERE variable = 'AutoEmailPrimaryAddress'; -UPDATE systempreferences SET value = '1' WHERE variable = 'BiblioAddsAuthorities'; -UPDATE systempreferences SET value = 'city|surname|cardnumber' WHERE variable = 'BorrowerMandatoryField'; +UPDATE systempreferences SET value = '0' WHERE variable = 'BiblioAddsAuthorities'; +UPDATE systempreferences SET value = 'surname|cardnumber' WHERE variable = 'BorrowerMandatoryField'; UPDATE systempreferences SET value = '0' WHERE variable = 'BorrowersLog'; UPDATE systempreferences SET value = 'Sig|Sig.ra|Sig.na' WHERE variable = 'BorrowersTitles'; UPDATE systempreferences SET value = '0' WHERE variable = 'CataloguingLog'; UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurrencyFormat'; UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat'; -UPDATE systempreferences SET value = 'relevance' WHERE variable = 'defaultSortField'; +UPDATE systempreferences SET value = 'title' WHERE variable = 'defaultSortField'; UPDATE systempreferences SET value = 'asc' WHERE variable = 'defaultSortOrder'; UPDATE systempreferences SET value = '0' WHERE variable = 'FinesLog'; -UPDATE systempreferences SET value = '1' WHERE variable = 'FRBRizeEditions'; UPDATE systempreferences SET value = '1' WHERE variable = 'GoogleJackets'; UPDATE systempreferences SET value = '0' WHERE variable = 'IssueLog'; UPDATE systempreferences SET value = 'whitespace' WHERE variable = 'itemBarcodeInputFilter'; UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber'; -UPDATE systempreferences SET value = 'koha@cilea.it' WHERE variable = 'KohaAdminEmailAddress'; +UPDATE systempreferences SET value = 'koha@xxx.it' WHERE variable = 'KohaAdminEmailAddress'; UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language'; UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog'; -UPDATE systempreferences SET value = '0' WHERE variable = 'MARCOrgCode'; -UPDATE systempreferences SET value = '2' WHERE variable = 'maxreserves'; +UPDATE systempreferences SET value = '' WHERE variable = 'MARCOrgCode'; +UPDATE systempreferences SET value = '5' WHERE variable = 'maxreserves'; UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities'; -UPDATE systempreferences SET value = 'relevance' WHERE variable = 'OPACdefaultSortField'; +UPDATE systempreferences SET value = 'title' WHERE variable = 'OPACdefaultSortField'; UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder'; -UPDATE systempreferences SET value = '1' WHERE variable = 'OPACFRBRizeEditions'; UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'opaclanguages'; UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay'; UPDATE systempreferences SET value = '

Benvenuto !!

' WHERE variable = 'OpacMainUserBlock'; UPDATE systempreferences SET value = 'Links importanti qui.' WHERE variable = 'OpacNav'; UPDATE systempreferences SET value = '0' WHERE variable = 'OPACShelfBrowser'; -UPDATE systempreferences SET value = '1' WHERE variable = 'OpacTopissue'; UPDATE systempreferences SET value = '1' WHERE variable = 'OPACURLOpenInNewWindow'; -UPDATE systempreferences SET value = 'jpg' WHERE variable = 'patronimages'; UPDATE systempreferences SET value = '0' WHERE variable = 'QueryFuzzy'; UPDATE systempreferences SET value = '0' WHERE variable = 'QueryStemming'; UPDATE systempreferences SET value = '0' WHERE variable = 'QueryWeightFields'; -UPDATE systempreferences SET value = '0' WHERE variable = 'ReservesNeedReturns'; -UPDATE systempreferences SET value = '1' WHERE variable = 'ReturnBeforeExpiry'; UPDATE systempreferences SET value = '1' WHERE variable = 'TagsModeration'; -UPDATE systempreferences SET value = '1' WHERE variable = 'ThingISBN'; UPDATE systempreferences SET value = '30600' WHERE variable = 'timeout'; UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText'; -UPDATE systempreferences SET value = '1' WHERE variable = 'XISBN'; UPDATE systempreferences SET value = '#200||{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|\r\n#210|. – |{210a}{ : 210c}{, 210d}|\r\n#215|. – |{215a}{ ; 215d}|\r\n#225|. – |{(225a}{ ; 225v)}|\r\n#010|. – |{ISBN 010a}|' WHERE variable = 'ISBD'; -- 2.39.5