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

(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (+101 lines)
Lines 16-21 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
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>>', 'email'),
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>>', 'email'),
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>>', 'email'),
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>>', 'email'),
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>>', 'email');
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>>', 'email');
19
INSERT INTO `letter` (module, code, name, title, content, is_html)
20
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
21
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
22
(<<borrowers.cardnumber>>) <br />
23
24
<<today>><br />
25
26
<h4>Checked Out</h4>
27
<checkedout>
28
<p>
29
<<biblio.title>> <br />
30
Barcode: <<items.barcode>><br />
31
Date due: <<issues.date_due>><br />
32
</p>
33
</checkedout>
34
35
<h4>Overdues</h4>
36
<overdue>
37
<p>
38
<<biblio.title>> <br />
39
Barcode: <<items.barcode>><br />
40
Date due: <<issues.date_due>><br />
41
</p>
42
</overdue>
43
44
<hr>
45
46
<h4 style="text-align: center; font-style:italic;">News</h4>
47
<news>
48
<div class="newsitem">
49
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
50
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
51
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
52
<hr />
53
</div>
54
</news>', 1),
55
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
56
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
57
(<<borrowers.cardnumber>>) <br />
58
59
<<today>><br />
60
61
<h4>Checked Out Today</h4>
62
<checkedout>
63
<p>
64
<<biblio.title>> <br />
65
Barcode: <<items.barcode>><br />
66
Date due: <<issues.date_due>><br />
67
</p>
68
</checkedout>', 1),
69
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
70
71
<h3> Transfer to/Hold in <<branches.branchname>></h3>
72
73
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
74
75
<ul>
76
    <li><<borrowers.cardnumber>></li>
77
    <li><<borrowers.phone>></li>
78
    <li> <<borrowers.address>><br />
79
         <<borrowers.address2>><br />
80
         <<borrowers.city >>  <<borrowers.zipcode>>
81
    </li>
82
    <li><<borrowers.email>></li>
83
</ul>
84
<br />
85
<h3>ITEM ON HOLD</h3>
86
<h4><<biblio.title>></h4>
87
<h5><<biblio.author>></h5>
88
<ul>
89
   <li><<items.barcode>></li>
90
   <li><<items.itemcallnumber>></li>
91
   <li><<reserves.waitingdate>></li>
92
</ul>
93
<p>Notes:
94
<pre><<reserves.reservenotes>></pre>
95
</p>
96
', 1),
97
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
98
99
<h3>Transfer to <<branches.branchname>></h3>
100
101
<h3>ITEM</h3>
102
<h4><<biblio.title>></h4>
103
<h5><<biblio.author>></h5>
104
<ul>
105
   <li><<items.barcode>></li>
106
   <li><<items.itemcallnumber>></li>
107
</ul>', 1);
108
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
109
VALUES (
110
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
111
112
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
113
114
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
115
116
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
117
);
118
119
19
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
120
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
20
121
21
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
122
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-1 / +102 lines)
Lines 18-24 VALUES Link Here
18
('suggestions','AVAILABLE','Suggestion disponible', 'Suggestion d\'achat disponible','cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez effectué une suggestion d\'achat pour le docuement  <<suggestions.title>> de <<suggestions.author>>.\n\nNous sommes heureux de vous informer que le document que vous aviez demandé est maintenant disponible dans nos collections.\n\nSi vous avez des questions, merci de nous contacter par courriel à l\'adresse <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
18
('suggestions','AVAILABLE','Suggestion disponible', 'Suggestion d\'achat disponible','cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez effectué une suggestion d\'achat pour le docuement  <<suggestions.title>> de <<suggestions.author>>.\n\nNous sommes heureux de vous informer que le document que vous aviez demandé est maintenant disponible dans nos collections.\n\nSi vous avez des questions, merci de nous contacter par courriel à l\'adresse <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
19
('suggestions','ORDERED','Suggestion commandée', 'Suggestion commandée','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez effectué une demande de suggestion d\'achat sur le docuement <<suggestions.title>> de <<suggestions.author>>.\n\nNous sommes heureux de vous informer que le document que vous avez demandé est maintenant en commande. Le document devrait arriver rapidement dans nos collections.\n\nVous serez averti quand le docuement sera disponible.\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <<branches.branchemail>>\n\nMerci,\n\n<<branches.branchname>>', 'email'),
19
('suggestions','ORDERED','Suggestion commandée', 'Suggestion commandée','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez effectué une demande de suggestion d\'achat sur le docuement <<suggestions.title>> de <<suggestions.author>>.\n\nNous sommes heureux de vous informer que le document que vous avez demandé est maintenant en commande. Le document devrait arriver rapidement dans nos collections.\n\nVous serez averti quand le docuement sera disponible.\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <<branches.branchemail>>\n\nMerci,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','REJECTED','Suggestion rejetée', 'Suggestion d\'achat rejeté','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez fait la demande du document <<suggestions.title>> de <<suggestions.author>>.\n\nla Bibliothèque a examiné votre demande ce jour, et a décidé de ne pas retenir la suggestion pour l\'instant.\n\nLa raison est la suivante: <<suggestions.reason>>\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email');
20
('suggestions','REJECTED','Suggestion rejetée', 'Suggestion d\'achat rejeté','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez fait la demande du document <<suggestions.title>> de <<suggestions.author>>.\n\nla Bibliothèque a examiné votre demande ce jour, et a décidé de ne pas retenir la suggestion pour l\'instant.\n\nLa raison est la suivante: <<suggestions.reason>>\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email');
21
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','Les documents suivants ont été renouvelés\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci, <<branches.branchname>>.');
21
INSERT INTO `letter` (module, code, name, title, content, is_html)
22
VALUES ('circulation','ISSUESLIP','Ticket de de prêt','Ticket de prêt', '<h3><<branches.branchname>></h3>
23
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
24
(<<borrowers.cardnumber>>) <br />
25
26
<<today>><br />
27
28
<h4>Emprunts</h4>
29
<checkedout>
30
<p>
31
<<biblio.title>> <br />
32
Code à barres : <<items.barcode>><br />
33
Retour le : <<issues.date_due>><br />
34
</p>
35
</checkedout>
36
37
<h4>Retards</h4>
38
<overdue>
39
<p>
40
<<biblio.title>> <br />
41
Codes à barres : <<items.barcode>><br />
42
Retour le : <<issues.date_due>><br />
43
</p>
44
</overdue>
45
46
<hr>
47
48
<h4 style="text-align: center; font-style:italic;">Nouvelles</h4>
49
<news>
50
<div class="newsitem">
51
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
52
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
53
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
54
<hr />
55
</div>
56
</news>', 1),
57
('circulation','ISSUEQSLIP','Ticket rapide','Ticket rapide', '<h3><<branches.branchname>></h3>
58
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
59
(<<borrowers.cardnumber>>) <br />
60
61
<<today>><br />
62
63
<h4>Emprunts du jour</h4>
64
<checkedout>
65
<p>
66
<<biblio.title>> <br />
67
Code à barres : <<items.barcode>><br />
68
Retour le : <<issues.date_due>><br />
69
</p>
70
</checkedout>', 1),
71
('circulation','RESERVESLIP','Ticket de réservation','Ticket de réservation', '<h5>Date : <<today>></h5>
72
73
<h3> Transfert vers/Réservé à <<branches.branchname>></h3>
74
75
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
76
77
<ul>
78
    <li><<borrowers.cardnumber>></li>
79
    <li><<borrowers.phone>></li>
80
    <li> <<borrowers.address>><br />
81
         <<borrowers.address2>><br />
82
         <<borrowers.city >>  <<borrowers.zipcode>>
83
    </li>
84
    <li><<borrowers.email>></li>
85
</ul>
86
<br />
87
<h3>RESERVATIONS</h3>
88
<h4><<biblio.title>></h4>
89
<h5><<biblio.author>></h5>
90
<ul>
91
   <li><<items.barcode>></li>
92
   <li><<items.itemcallnumber>></li>
93
   <li><<reserves.waitingdate>></li>
94
</ul>
95
<p>Notes :
96
<pre><<reserves.reservenotes>></pre>
97
</p>
98
', 1),
99
('circulation','TRANSFERSLIP','Ticket de transfer','Ticket de transfert', '<h5>Date : <<today>></h5>
100
101
<h3>Transfert à <<branches.branchname>></h3>
102
103
<h3>Titres</h3>
104
<h4><<biblio.title>></h4>
105
<h5><<biblio.author>></h5>
106
<ul>
107
   <li><<items.barcode>></li>
108
   <li><<items.itemcallnumber>></li>
109
</ul>', 1);
110
111
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
112
VALUES (
113
'members',  'OPAC_REG_VERIFY',  '',  'Vérification de l''email donné à l''auto-inscription OPAC',  '1',  'Vérification de votre compte',  'Bonjour,
114
115
Votre compte de bibliothèque a été créé. Veuillez valider votre adresse email et le processus d''inscription en cliquant sur ce lien:
116
117
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
118
119
Si vous n''êtes pas à l''origine de cette inscription, vous pouvez ignorer ce message.'
120
);
121
122
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Renouvellements','Renouvellements','Les documents suivants ont été renouvelés\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci, <<branches.branchname>>.');
22
123
23
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
124
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
24
VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,
125
VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+12 lines)
Lines 7-12 VALUES ('circulation','ODUE','Avviso per i ritardi','Avviso per i ritardi','Salv Link Here
7
('circulation','DUEDGST','Avviso restituzione (digest)','Avviso restituzione (digest)','Hai <<count>> prestiti da retituire', 'email'),
7
('circulation','DUEDGST','Avviso restituzione (digest)','Avviso restituzione (digest)','Hai <<count>> prestiti da retituire', 'email'),
8
('circulation','PREDUE','Preavviso scadenza prestito','Preavviso scadenza prestito','Salve <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nQuesti prestiti stanno per scadere:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)', 'email'),
8
('circulation','PREDUE','Preavviso scadenza prestito','Preavviso scadenza prestito','Salve <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nQuesti prestiti stanno per scadere:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)', 'email'),
9
('circulation','PREDUEDGST','Preavviso scadenza prestiti (digest)','Preavviso scadenza prestiti (digest)','Hai <<count>> prestiti che scadranno tra poco', 'email'),
9
('circulation','PREDUEDGST','Preavviso scadenza prestiti (digest)','Preavviso scadenza prestiti (digest)','Hai <<count>> prestiti che scadranno tra poco', 'email'),
10
('circulation','RENEWAL','Item Renewals','Item Renewals','The following items have been renewed:\r\n----\r\n<<
11
biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.', 'email'),
10
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro', 'Prenotazione disponibile per il ritiro a <<branches.branchname>>', 'Salve <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nHai una prenotazione disponibili per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n. : <<items.copynumber>>\r\nPresso: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>', 'email'),
12
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro', 'Prenotazione disponibile per il ritiro a <<branches.branchname>>', 'Salve <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nHai una prenotazione disponibili per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n. : <<items.copynumber>>\r\nPresso: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>', 'email'),
11
('reserves', 'HOLD', '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 disponibile per il ritiro\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\nHai una prenotazione disponibili per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n. : <<items.copynumber>>\r\n', 'print'),
13
('reserves', 'HOLD', '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 disponibile per il ritiro\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\nHai una prenotazione disponibili per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n. : <<items.copynumber>>\r\n', 'print'),
12
('circulation','CHECKIN','Restituzione (Digest)','Restituzione','Questi prestiti sono stati restituiti:\r\n----\r\n<<biblio.title>>\r\n----\r\nGrazie.', 'email'),
14
('circulation','CHECKIN','Restituzione (Digest)','Restituzione','Questi prestiti sono stati restituiti:\r\n----\r\n<<biblio.title>>\r\n----\r\nGrazie.', 'email'),
Lines 105-110 Data di scadenza: <<issues.date_due>><br /> Link Here
105
   <li><<items.barcode>></li>
107
   <li><<items.barcode>></li>
106
   <li><<items.itemcallnumber>></li>
108
   <li><<items.itemcallnumber>></li>
107
</ul>', 1);
109
</ul>', 1);
110
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
111
VALUES (
112
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
113
114
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
115
116
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
117
118
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
119
);
108
120
109
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
121
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
110
VALUES ('members', 'SHARE_INVITE', '', 'Invito per condividere una lista', '0', 'Condivisione lista <<listname>>', 'Salve,
122
VALUES ('members', 'SHARE_INVITE', '', 'Invito per condividere una lista', '0', 'Condivisione lista <<listname>>', 'Salve,
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+101 lines)
Lines 18-23 VALUES Link Here
18
('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>>', 'email'),
18
('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>>', 'email'),
19
('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>>', 'email'),
19
('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>>', 'email'),
20
('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>>', 'email');
20
('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>>', 'email');
21
INSERT INTO `letter` (module, code, name, title, content, is_html)
22
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
23
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
24
(<<borrowers.cardnumber>>) <br />
25
26
<<today>><br />
27
28
<h4>Checked Out</h4>
29
<checkedout>
30
<p>
31
<<biblio.title>> <br />
32
Barcode: <<items.barcode>><br />
33
Date due: <<issues.date_due>><br />
34
</p>
35
</checkedout>
36
37
<h4>Overdues</h4>
38
<overdue>
39
<p>
40
<<biblio.title>> <br />
41
Barcode: <<items.barcode>><br />
42
Date due: <<issues.date_due>><br />
43
</p>
44
</overdue>
45
46
<hr>
47
48
<h4 style="text-align: center; font-style:italic;">News</h4>
49
<news>
50
<div class="newsitem">
51
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
52
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
53
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
54
<hr />
55
</div>
56
</news>', 1),
57
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
58
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
59
(<<borrowers.cardnumber>>) <br />
60
61
<<today>><br />
62
63
<h4>Checked Out Today</h4>
64
<checkedout>
65
<p>
66
<<biblio.title>> <br />
67
Barcode: <<items.barcode>><br />
68
Date due: <<issues.date_due>><br />
69
</p>
70
</checkedout>', 1),
71
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
72
73
<h3> Transfer to/Hold in <<branches.branchname>></h3>
74
75
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
76
77
<ul>
78
    <li><<borrowers.cardnumber>></li>
79
    <li><<borrowers.phone>></li>
80
    <li> <<borrowers.address>><br />
81
         <<borrowers.address2>><br />
82
         <<borrowers.city >>  <<borrowers.zipcode>>
83
    </li>
84
    <li><<borrowers.email>></li>
85
</ul>
86
<br />
87
<h3>ITEM ON HOLD</h3>
88
<h4><<biblio.title>></h4>
89
<h5><<biblio.author>></h5>
90
<ul>
91
   <li><<items.barcode>></li>
92
   <li><<items.itemcallnumber>></li>
93
   <li><<reserves.waitingdate>></li>
94
</ul>
95
<p>Notes:
96
<pre><<reserves.reservenotes>></pre>
97
</p>
98
', 1),
99
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
100
101
<h3>Transfer to <<branches.branchname>></h3>
102
103
<h3>ITEM</h3>
104
<h4><<biblio.title>></h4>
105
<h5><<biblio.author>></h5>
106
<ul>
107
   <li><<items.barcode>></li>
108
   <li><<items.itemcallnumber>></li>
109
</ul>', 1);
110
111
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
112
VALUES (
113
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
114
115
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
116
117
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
118
119
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
120
);
121
21
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
122
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
22
123
23
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
124
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+103 lines)
Lines 16-21 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
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>>', 'email'),
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>>', 'email'),
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>>', 'email'),
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>>', 'email'),
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>>', 'email');
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>>', 'email');
19
20
INSERT INTO `letter` (module, code, name, title, content, is_html)
21
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
22
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
23
(<<borrowers.cardnumber>>) <br />
24
25
<<today>><br />
26
27
<h4>Checked Out</h4>
28
<checkedout>
29
<p>
30
<<biblio.title>> <br />
31
Barcode: <<items.barcode>><br />
32
Date due: <<issues.date_due>><br />
33
</p>
34
</checkedout>
35
36
<h4>Overdues</h4>
37
<overdue>
38
<p>
39
<<biblio.title>> <br />
40
Barcode: <<items.barcode>><br />
41
Date due: <<issues.date_due>><br />
42
</p>
43
</overdue>
44
45
<hr>
46
47
<h4 style="text-align: center; font-style:italic;">News</h4>
48
<news>
49
<div class="newsitem">
50
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
51
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
52
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.tim
53
estamp>></p>
54
<hr />
55
</div>
56
</news>', 1),
57
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
58
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
59
(<<borrowers.cardnumber>>) <br />
60
61
<<today>><br />
62
63
<h4>Checked Out Today</h4>
64
<checkedout>
65
<p>
66
<<biblio.title>> <br />
67
Barcode: <<items.barcode>><br />
68
Date due: <<issues.date_due>><br />
69
</p>
70
</checkedout>', 1),
71
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
72
73
<h3> Transfer to/Hold in <<branches.branchname>></h3>
74
75
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
76
77
<ul>
78
    <li><<borrowers.cardnumber>></li>
79
    <li><<borrowers.phone>></li>
80
    <li> <<borrowers.address>><br />
81
         <<borrowers.address2>><br />
82
         <<borrowers.city >>  <<borrowers.zipcode>>
83
    </li>
84
    <li><<borrowers.email>></li>
85
</ul>
86
<br />
87
<h3>ITEM ON HOLD</h3>
88
<h4><<biblio.title>></h4>
89
<h5><<biblio.author>></h5>
90
<ul>
91
   <li><<items.barcode>></li>
92
   <li><<items.itemcallnumber>></li>
93
   <li><<reserves.waitingdate>></li>
94
</ul>
95
<p>Notes:
96
<pre><<reserves.reservenotes>></pre>
97
</p>
98
', 1),
99
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
100
101
<h3>Transfer to <<branches.branchname>></h3>
102
103
<h3>ITEM</h3>
104
<h4><<biblio.title>></h4>
105
<h5><<biblio.author>></h5>
106
<ul>
107
   <li><<items.barcode>></li>
108
   <li><<items.itemcallnumber>></li>
109
</ul>', 1);
110
111
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
112
VALUES (
113
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
114
115
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
116
117
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
118
119
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
120
);
121
19
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
122
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
20
123
21
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
124
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +103 lines)
Lines 15-20 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
15
('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>>'),
15
('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','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>>'),
16
('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','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>>');
17
('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
19
INSERT INTO `letter` (module, code, name, title, content, is_html)
20
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
21
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
22
(<<borrowers.cardnumber>>) <br />
23
24
<<today>><br />
25
26
<h4>Checked Out</h4>
27
<checkedout>
28
<p>
29
<<biblio.title>> <br />
30
Barcode: <<items.barcode>><br />
31
Date due: <<issues.date_due>><br />
32
</p>
33
</checkedout>
34
35
<h4>Overdues</h4>
36
<overdue>
37
<p>
38
<<biblio.title>> <br />
39
Barcode: <<items.barcode>><br />
40
Date due: <<issues.date_due>><br />
41
</p>
42
</overdue>
43
44
<hr>
45
46
<h4 style="text-align: center; font-style:italic;">News</h4>
47
<news>
48
<div class="newsitem">
49
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
50
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
51
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.tim
52
estamp>></p>
53
<hr />
54
</div>
55
</news>', 1),
56
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
57
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
58
(<<borrowers.cardnumber>>) <br />
59
60
<<today>><br />
61
62
<h4>Checked Out Today</h4>
63
<checkedout>
64
<p>
65
<<biblio.title>> <br />
66
Barcode: <<items.barcode>><br />
67
Date due: <<issues.date_due>><br />
68
</p>
69
</checkedout>', 1),
70
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
71
72
<h3> Transfer to/Hold in <<branches.branchname>></h3>
73
74
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
75
76
<ul>
77
    <li><<borrowers.cardnumber>></li>
78
    <li><<borrowers.phone>></li>
79
    <li> <<borrowers.address>><br />
80
         <<borrowers.address2>><br />
81
         <<borrowers.city >>  <<borrowers.zipcode>>
82
    </li>
83
    <li><<borrowers.email>></li>
84
</ul>
85
<br />
86
<h3>ITEM ON HOLD</h3>
87
<h4><<biblio.title>></h4>
88
<h5><<biblio.author>></h5>
89
<ul>
90
   <li><<items.barcode>></li>
91
   <li><<items.itemcallnumber>></li>
92
   <li><<reserves.waitingdate>></li>
93
</ul>
94
<p>Notes:
95
<pre><<reserves.reservenotes>></pre>
96
</p>
97
', 1),
98
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
99
100
<h3>Transfer to <<branches.branchname>></h3>
101
102
<h3>ITEM</h3>
103
<h4><<biblio.title>></h4>
104
<h5><<biblio.author>></h5>
105
<ul>
106
   <li><<items.barcode>></li>
107
   <li><<items.itemcallnumber>></li>
108
</ul>', 1);
109
110
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
111
VALUES (
112
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
113
114
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
115
116
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
117
118
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
119
);
120
18
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
121
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.');
19
122
20
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
123
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
21
- 

Return to bug 13199