View | Details | Raw Unified | Return to bug 10534
Collapse All | Expand All

(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-36 / +49 lines)
Lines 1-43 Link Here
1
INSERT INTO letter (module, code, name, title, content)
1
INSERT INTO `letter` (module, code, name, title, content)
2
VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.firstname>> <<borrowers.surname>>,\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<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nPhone: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\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<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>\n\nThank-you for your prompt attention to this matter.\n\n<<branches.branchname>> Staff\n'),
2
VALUES ('circulation','ODUE','Avviso per i ritardi','Copia(e) in ritardo','Caro <<borrowers.firstname>> <<borrowers.surname>>,\n\nci risulta che tu abbia dei ritardi nella restituzione dei prestiti. La tua biblioteca non ti darà una multa per questi ritardi ma ti chiede di rinnovare i prestiti o di restituirli il prima possibile. I dati della biblioteca sono: \n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nTel: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nSe la biblioteca ti permette di rinnovare online, usa la tua login e password per fare il rinnovo usando l\'opac. Se una copia è in ritardo da più di 30 giorni, sei obbligato a restituirla.\n\nLa seguente copia(e) è(sono) in ritardo:\n\n<item>"<<biblio.title>>" di <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Multa: <<items.fine>></item>\n\nGrazie per l\'attenzione.\n\nIl team della biblioteca <<branches.branchname>>\n'),
3
('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>'),
3
('claimacquisition','ACQCLAIM','Sollecito al fornitore','Copia(e) non ricevuta(e)','Gentile <<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Il seguente ordine numero <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> ordinati) (€<<aqorders.listprice>> ciascuno) non è arrivato in biblioteca.</order>'),
4
('serial','RLIST','Routing List','Serial is now available','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following issue is now available:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nPlease pick it up at your convenience.'),
4
('serial','RLIST','Routing List','Il fascicolo è ora disponibile','Caro <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nIl seguente fascicolo è ora disponibile:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nLo trovi presso la tua biblioteca.'),
5
('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha account details.','Hello <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser:  <<borrowers.userid>>\r\nPassword: <<borrowers.password>>\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'), 
5
('members','ACCTDETAILS','Template del messaggio che giunge ai nuovi account','Dettagli del tuo nuovo account in Koha.','Caro <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nI dettagli del tuo nuovo account in Koha sono:\r\n\r\nUser:  <<borrowers.userid>>\r\nPassword: <<borrowers.password>>\r\n\r\nSe hai qualche problema contatta la biblioteca.\r\n\r\nGrazie dell\'attenzione.\r\n'),
6
('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'), 
6
('circulation','DUE','Avviso restituzione (copia singola)','Avviso restituzione','Caro <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nquesta copia è ora da restituire:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'),
7
('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <<count>> items due'), 
7
('circulation','DUEDGST','Avviso restituzione (digest)','Avviso restituzione','Hai <<count>> copie da restituire'),
8
('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item Due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item will be due soon:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'), 
8
('circulation','PREDUE','Preavviso per le copie da restituire','Avviso copie in scadenza','Caro <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nil prestito per la seguente copia sta per scadere:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'),
9
('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <<count>> items due soon'),
9
('circulation','PREDUEDGST','Preavviso per le copie da restituire(digest)','Avviso copie in scadenza','Hai <<count>> prestiti che stanno per scadere'),
10
('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup at <<branches.branchname>>', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'),
10
('circulation','RENEWAL','Rinnovi','Rinnovi','le seguenti copie sono state rinnovate:\r\n----\r\n<<biblio.title>>\r\n----\r\nla biblioteca ti ringrazia.'),
11
('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold Available for Pickup (print notice)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> <<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\n'),
11
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro', 'Prenotazione ora disponibile presso <<branches.branchname>>', 'Caro <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nla copia prenotata è a disposizione a partire dal <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia numero: <<items.copynumber>>\r\nla puoi ritirare presso: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'),
12
('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
12
('reserves', 'HOLD_PRINT', 'Prenotazione disponibile per il ritiro(stampa)', 'Prenotazione disponibile per il ritiro (stampa)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nPrenotazione ora disponibile\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> <<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nCaro <<borrowers.firstname>> <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nHai una prenotazione disponibile dal <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nNumero copia: <<items.copynumber>>\r\n'),
13
('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.'),
13
('circulation','CHECKIN','Restituzione (digest)','Restituzioni','Queste copie sono state rese:\r\n----\r\n<<biblio.title>>\r\n----\r\nGrazie.'),
14
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'),
14
('circulation','CHECKOUT','Prestito (digest)','Prestiti','Queste copie sono state prestate:\r\n----\r\n<<biblio.title>>\r\n----\r\nGrazie della visita.'),
15
('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The item will be ordered as soon as possible. You will be notified by mail when the order is completed, and again when the item arrives at the library.\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'),
15
('reserves', 'HOLDPLACED', 'Prenotazione di una copia', 'Prenotazione','Una prenotazione è stata posta sulla seguente copia: <<biblio.title>> (<<biblio.biblionumber>>) dall\'utente <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'),
16
('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'),
16
('suggestions','ACCEPTED','Suggerimento d\'acquisto accettato', 'Suggerimento d\'acquisto accettato','Caro <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito alla biblioteca di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nLa biblioteca ha esaminato oggi il tuo suggerimento. L\'opera verrà ordinata il prima possibile. Sarai avvisato via email quando l\'ordine verrà completato e di nuovo quando l\'opera arriverà in biblioteca.\n\nSe hai dubbi o domande scrivi a <<branches.branchemail>>.\n\nGrazie di tutto.'),
17
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>'),
17
('suggestions','AVAILABLE','Suggerimento d\'acquisto disponibile', 'L\'opera suggerita è in biblioteca','Caro <<borrowers.firstname>> <<borrowers.surname>>,\n\nl\'opera da te suggerita, <<suggestions.title>> di <<suggestions.author>> è giunta in biblioteca.\n\nSe vuoi puoi contattarci a questo email <<branches.branchemail>>.\n\nGrazie dell\'attenzione.'),
18
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>');
18
('suggestions','ORDERED','Suggerimento d\'acquisto ordinato', 'Suggerimento d\'acquisto ordinato','Caro <<borrowers.firstname>> <<borrowers.surname>>,\n\nl\'opera da te suggerita, <<suggestions.title>> di <<suggestions.author>>, è stata ordinata.\n\nVerrai avvisato non appena giungerà in biblioteca.\n\nSe vuoi puoi contattarci all\'indirizzo di email <<branches.branchemail>>\n\nGrazie dell\'attenzione.'),
19
INSERT INTO letter (module, code, name, title, content, is_html)
19
('suggestions','REJECTED','Suggerimento d\'acquisto rifiutato', 'Il suggerimento non è stato accettato','Caro <<borrowers.firstname>> <<borrowers.surname>>,\n\nhai suggerito l\'acquisto dell\'opera: <<suggestions.title>> di <<suggestions.author>>.\n\nLa biblioteca ha esaminato oggi il suggerimento e ha deciso di non procedere all\'acquisto per ora.\n\nLa ragione del rifiuto è: <<suggestions.reason>>\n\nSe vuoi puoi scriverci a questo indirizzo di posta elettronica <<branches.branchemail>>.\n\nGrazie lo stesso dell\'attenzione, lo staff della biblioteca.');
20
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
20
INSERT INTO `letter` (module, code, name, title, content, is_html)
21
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
21
VALUES ('circulation','ISSUESLIP','Ricevuta di prestito','Ricevuta di prestito', '<h3><<branches.branchname>></h3>
22
Prestito a <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
22
(<<borrowers.cardnumber>>) <br />
23
(<<borrowers.cardnumber>>) <br />
23
24
24
<<today>><br />
25
<<today>><br />
25
26
26
<h4>Checked Out</h4>
27
<h4>Prestito</h4>
27
<checkedout>
28
<checkedout>
28
<p>
29
<p>
29
<<biblio.title>> <br />
30
<<biblio.title>> <br />
30
Barcode: <<items.barcode>><br />
31
Barcode: <<items.barcode>><br />
31
Date due: <<issues.date_due>><br />
32
Data di scadenza: <<issues.date_due>><br />
32
</p>
33
</p>
33
</checkedout>
34
</checkedout>
34
35
35
<h4>Overdues</h4>
36
<h4>Scadenze</h4>
36
<overdue>
37
<overdue>
37
<p>
38
<p>
38
<<biblio.title>> <br />
39
<<biblio.title>> <br />
39
Barcode: <<items.barcode>><br />
40
Barcode: <<items.barcode>><br />
40
Date due: <<issues.date_due>><br />
41
Data di scadenza: <<issues.date_due>><br />
41
</p>
42
</p>
42
</overdue>
43
</overdue>
43
44
Lines 52-74 Date due: <<issues.date_due>><br /> Link Here
52
<hr />
53
<hr />
53
</div>
54
</div>
54
</news>', 1),
55
</news>', 1),
55
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
56
('circulation','ISSUEQSLIP','Ricevuta (sintetica)','Ricevuta (sintetica)', '<h3><<branches.branchname>></h3>
56
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
57
Prestito a <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
57
(<<borrowers.cardnumber>>) <br />
58
(<<borrowers.cardnumber>>) <br />
58
59
59
<<today>><br />
60
<<today>><br />
60
61
61
<h4>Checked Out Today</h4>
62
<h4>Prestiti di oggi</h4>
62
<checkedout>
63
<checkedout>
63
<p>
64
<p>
64
<<biblio.title>> <br />
65
<<biblio.title>> <br />
65
Barcode: <<items.barcode>><br />
66
Barcode: <<items.barcode>><br />
66
Date due: <<issues.date_due>><br />
67
Data di scadenza: <<issues.date_due>><br />
67
</p>
68
</p>
68
</checkedout>', 1),
69
</checkedout>', 1),
69
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
70
('circulation','RESERVESLIP','Ricevuta (prenotazione)','Ricevuta (prenotazione)', '<h5>Data: <<today>></h5>
70
71
71
<h3> Transfer to/Hold in <<branches.branchname>></h3>
72
<h3> Trasferisci a/Riserva per <<branches.branchname>></h3>
72
73
73
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
74
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
74
75
Lines 82-88 Date due: <<issues.date_due>><br /> Link Here
82
    <li><<borrowers.email>></li>
83
    <li><<borrowers.email>></li>
83
</ul>
84
</ul>
84
<br />
85
<br />
85
<h3>ITEM ON HOLD</h3>
86
<h3>COPIA PRENOTATA</h3>
86
<h4><<biblio.title>></h4>
87
<h4><<biblio.title>></h4>
87
<h5><<biblio.author>></h5>
88
<h5><<biblio.author>></h5>
88
<ul>
89
<ul>
Lines 90-107 Date due: <<issues.date_due>><br /> Link Here
90
   <li><<items.itemcallnumber>></li>
91
   <li><<items.itemcallnumber>></li>
91
   <li><<reserves.waitingdate>></li>
92
   <li><<reserves.waitingdate>></li>
92
</ul>
93
</ul>
93
<p>Notes:
94
<p>Note:
94
<pre><<reserves.reservenotes>></pre>
95
<pre><<reserves.reservenotes>></pre>
95
</p>
96
</p>
96
', 1),
97
', 1),
97
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
98
('circulation','TRANSFERSLIP','Ricevuta (trasferimento)','Ricevuta (trasferimento)', '<h5>Data: <<today>></h5>
98
99
99
<h3>Transfer to <<branches.branchname>></h3>
100
<h3>Trasferisci a <<branches.branchname>></h3>
100
101
101
<h3>ITEM</h3>
102
<h3>COPIA</h3>
102
<h4><<biblio.title>></h4>
103
<h4><<biblio.title>></h4>
103
<h5><<biblio.author>></h5>
104
<h5><<biblio.author>></h5>
104
<ul>
105
<ul>
105
   <li><<items.barcode>></li>
106
   <li><<items.barcode>></li>
106
   <li><<items.itemcallnumber>></li>
107
   <li><<items.itemcallnumber>></li>
107
</ul>', 1);
108
</ul>', 1);
109
110
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
111
VALUES (
112
'members',  'OPAC_REG_VERIFY',  '',  'Email di verifica dell\'autoregistrazione',  '1',  'Verifica il tuo account',  'Ciao!
113
114
Il tuo account della biblioteca è stato creato. Seleziona questo link per completare il processo di registrazione:
115
116
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
117
118
Se non hai inviato questa richiesta, puoi ignorare questo messaggio.'
119
120
);
(-)a/installer/data/mysql/it-IT/necessari/patron_atributes.sql (+2 lines)
Line 0 Link Here
1
INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `password_allowed`, `staff_searchable`, `authorised_value_category`)
2
VALUES ('SHOW_BCODE',  'Mostra il barcode dell\'utente nella schermata della lista delle copie', 0, 0, 1, 0, 0, 'YES_NO');
(-)a/installer/data/mysql/it-IT/necessari/patron_atributes.txt (+2 lines)
Line 0 Link Here
1
Utile attributo degli utenti:
2
* SHOW_BCODE - Mostra il Barcode dell'utente nella schermata riassuntiva della lista delle copie
(-)a/installer/data/mysql/it-IT/necessari/sample_creator_data.sql (+34 lines)
Line 0 Link Here
1
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
6
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
7
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
8
    <data_source image_name="none" image_source="patronimages" />
9
  </images>
10
  <text>&lt;firstname&gt; &lt;surname&gt;</text>
11
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
12
  <text>Biblioteca: &lt;branchcode&gt;</text>
13
  <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" />
14
  <text>Scade: 31 Dicembre 2014/text>
15
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
16
</opt>
17
','Patroncards');
18
/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
19
UNLOCK TABLES;
20
21
22
LOCK TABLES `creator_templates` WRITE;
23
/*!40000 ALTER TABLE `creator_templates` DISABLE KEYS */;
24
INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 colonne, 10 righe di etichette',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Etichette del dorso | Setup fino a 4 linee di testo',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Etichette del dorso | Setup fino a 5 linee di testo',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','Un template per tessere utente stampate dalla biblioteca',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards');
25
/*!40000 ALTER TABLE `creator_templates` ENABLE KEYS */;
26
UNLOCK TABLES;
27
28
LOCK TABLES `printers_profile` WRITE;
29
/*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */;
30
INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
31
/*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */;
32
UNLOCK TABLES;
33
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
34
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
(-)a/installer/data/mysql/it-IT/necessari/sample_creator_data.txt (+1 lines)
Line 0 Link Here
1
Esempi per la stampa etichette e della tessera utente
(-)a/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql (-12 / +8 lines)
Lines 1-12 Link Here
1
SET FOREIGN_KEY_CHECKS=0;
1
INSERT INTO `itemtypes` VALUES ('BK', 'Libro',5,0,'bridge/book.gif','');
2
2
INSERT INTO `itemtypes` VALUES ('MX', 'Materiale misto',5,0,'bridge/kit.gif','');
3
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',5,0,'bridge/book.gif','');
3
INSERT INTO `itemtypes` VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif','');
4
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',5,0,'bridge/kit.gif','');
4
INSERT INTO `itemtypes` VALUES ('MP', 'Mapppe',5,0,'bridge/map.gif','');
5
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif','');
5
INSERT INTO `itemtypes` VALUES ('VM', 'Audiovisivi',5,1,'bridge/dvd.gif','');
6
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',5,0,'bridge/map.gif','');
6
INSERT INTO `itemtypes` VALUES ('MU', 'Musica',5,0,'bridge/sound.gif','');
7
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',5,1,'bridge/dvd.gif','');
7
INSERT INTO `itemtypes` VALUES ('CR', 'Periodici',5,0,'bridge/periodical.gif','');
8
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',5,0,'bridge/sound.gif','');
8
INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,1,'','');
9
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',5,0,'bridge/periodical.gif','');
10
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');
11
12
SET FOREIGN_KEY_CHECKS=1;
(-)a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql (-6 lines)
Lines 1-5 Link Here
1
SET FOREIGN_KEY_CHECKS=0;
2
3
insert into `message_transports`
1
insert into `message_transports`
4
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
5
values
3
values
Lines 7-23 values Link Here
7
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
10
(3, 'email', 0, 'circulation', 'EVENT'),
11
(4, 'email', 0, 'reserves',    'HOLD'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
12
(1, 'sms',   0, 'circulation', 'DUE'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
13
(1, 'sms',   1, 'circulation', 'DUEDGST'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
14
(2, 'sms',   0, 'circulation', 'PREDUE'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
15
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
16
(3, 'sms',   0, 'circulation', 'EVENT'),
17
(4, 'sms',   0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
18
(5, 'email', 0, 'circulation', 'CHECKIN'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
19
(5, 'sms',   0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
20
(6, 'email', 0, 'circulation', 'CHECKOUT'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
21
(6, 'sms',   0, 'circulation', 'CHECKOUT');
17
(6, 'sms',   0, 'circulation', 'CHECKOUT');
22
23
SET FOREIGN_KEY_CHECKS=1;
(-)a/installer/data/mysql/it-IT/necessari/sample_quotes.sql (+7 lines)
Line 0 Link Here
1
/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
2
INSERT INTO `quotes` VALUES
3
(1,'Muriac','La paura è il principio della saggezza..','0000-00-00 00:00:00'),
4
(2,'Giordano','Come ci si sente stupidi a pensare a tutto il tempo che sprechiamo a desiderare di essere altrove.','0000-00-00 00:00:00'),
5
(3,'Bach', 'Nessun luogo è lontano.','0000-00-00 00:00:00'),
6
(4,'Disney','Per rendere una cosa speciale, devi solo credere che sia speciale non esiste un ingrediente segreto.','0000-00-00 00:00:00');
7
/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
(-)a/installer/data/mysql/it-IT/necessari/sample_quotes.txt (+1 lines)
Line 0 Link Here
1
Esempi di citazioni
(-)a/installer/data/mysql/it-IT/necessari/userpermissions.sql (-6 / +5 lines)
Lines 3-9 SET FOREIGN_KEY_CHECKS=0; Link Here
3
INSERT INTO permissions (module_bit, code, description) VALUES
3
INSERT INTO permissions (module_bit, code, description) VALUES
4
   ( 1, 'circulate_remaining_permissions', 'Permessi rimanenti per la circolazione'),
4
   ( 1, 'circulate_remaining_permissions', 'Permessi rimanenti per la circolazione'),
5
   ( 1, 'override_renewals', 'Sblocca i rinnovi bloccati'),
5
   ( 1, 'override_renewals', 'Sblocca i rinnovi bloccati'),
6
   ( 1, 'overdues_report', 'Execute overdue items report'),
6
   ( 1, 'overdues_report', 'Esegui report dei ritardi'),
7
   ( 3, 'parameters_remaining_permissions', 'Permessi rimanenti'),
7
   ( 3, 'parameters_remaining_permissions', 'Permessi rimanenti'),
8
   ( 3, 'manage_circ_rules', 'Gestisci regole circolazione'),
8
   ( 3, 'manage_circ_rules', 'Gestisci regole circolazione'),
9
   ( 6, 'place_holds', 'Fai prenotazioni per gli utenti'),
9
   ( 6, 'place_holds', 'Fai prenotazioni per gli utenti'),
Lines 55-63 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
55
   (15, 'routing', 'Crea/Manipola liste di distribuzione dei fascicoli ( routing list)'),
55
   (15, 'routing', 'Crea/Manipola liste di distribuzione dei fascicoli ( routing list)'),
56
   (16, 'execute_reports', 'Esegui reports SQL'),
56
   (16, 'execute_reports', 'Esegui reports SQL'),
57
   (16, 'create_reports', 'Crea reports SQL'),
57
   (16, 'create_reports', 'Crea reports SQL'),
58
   (19, 'manage', 'Manage plugins ( install / uninstall )'),
58
   (19, 'manage', 'Gestisci plugin ( installa / cancella )'),
59
   (19, 'tool', 'Use tool plugins'),
59
   (19, 'tool', 'Usa i plugin di tipo Strumento'),
60
   (19, 'report', 'Use report plugins'),
60
   (19, 'report', 'Usa i plugin di tipo Report'),
61
   (19, 'configure', 'Configure plugins')
61
   (19, 'configure', 'Configura i plugin')
62
;
62
;
63
SET FOREIGN_KEY_CHECKS=1;
63
SET FOREIGN_KEY_CHECKS=1;
64
- 

Return to bug 10534