Attachment #107153 for bug #25629

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




        - module: circulation
          code: CHECKIN
          branchcode: ""
          name: "Item check-in (digest)"
          is_html: 0
          title: "Check-ins"
          message_transport_type: email

        - module: circulation
          code: CHECKOUT
          branchcode: ""
          name: "Item check-out (digest)"
          is_html: 0
          title: "Checkouts"
          message_transport_type: email

        - module: circulation
          code: DUE
          branchcode: ""
          name: "Item due reminder"
          is_html: 0
          title: "Item due reminder"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: DUEDGST
          branchcode: ""
          name: "Item due reminder (digest)"
          is_html: 0
          title: "Item due reminder"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: HOLD_SLIP
          branchcode: ""
          name: "Hold slip"
          is_html: 1
          title: "Hold slip"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: ISSUEQSLIP
          branchcode: ""
          name: "Issue quick slip"
          is_html: 1
          title: "Issue quick slip"
          message_transport_type: email
          lang: default
          content:

            - ""
            - "<<today>><br />"
            - ""
            - "<h4>Checked out today</h4>"
            - "<checkedout>"
            - "<p>"
            - "<<biblio.title>> <br />"

        - module: circulation
          code: ISSUESLIP
          branchcode: ""
          name: "Issue slip"
          is_html: 1
          title: "Issue slip"
          message_transport_type: email
          lang: default
          content:

            - ""
            - "<<today>><br />"
            - ""
            - "<h4>Checked out</h4>"
            - "<checkedout>"
            - "<p>"
            - "<<biblio.title>> <br />"

        - module: circulation
          code: ODUE
          branchcode: ""
          name: "Overdue notice"
          is_html: 0
          title: "Item overdue"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: OVERDUES_SLIP
          branchcode: ""
          name: "Overdues slip"
          is_html: 0
          title: "Overdues slip"
          message_transport_type: print
          lang: default
          content:

        - module: circulation
          code: PREDUE
          branchcode: ""
          name: "Advance notice of item due"
          is_html: 0
          title: "Advance notice of item due"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: PREDUEDGST
          branchcode: ""
          name: "Advance notice of item due (digest)"
          is_html: 0
          title: "Advance notice of item due"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: RENEWAL
          branchcode: ""
          name: "Item renewals"
          is_html: 0
          title: "Item renewals"
          message_transport_type: email
          lang: default
          content:

        - module: circulation
          code: TRANSFERSLIP
          branchcode: ""
          name: "Transfer slip"
          is_html: 1
          title: "Transfer slip"
          message_transport_type: email
          lang: default
          content:

        - module: claimacquisition
          code: ACQCLAIM
          branchcode: ""
          name: "Acquisition claim"
          is_html: 0
          title: "Item not received"
          message_transport_type: email
          lang: default
          content:

        - module: members
          code: ACCTDETAILS
          branchcode: ""
          name: "Account details template - DEFAULT"
          is_html: 0
          title: "Your new Koha account details."
          message_transport_type: email

        - module: members
          code: OPAC_REG_VERIFY
          branchcode: ""
          name: "OPAC self-registration verification email"
          is_html: 1
          title: "Verify your account"
          message_transport_type: email
          lang: default
          content:

        - module: reserves
          code: HOLD
          branchcode: ""
          name: "Hold available for pickup"
          is_html: 0
          title: "Hold available for pickup at <<branches.branchname>>"
          message_transport_type: email
          lang: default
          content:

        - module: reserves
          code: HOLD
          branchcode: ""
          name: "Hold available for pickup"
          is_html: 0
          title: "Hold available for pickup (print notice)"
          message_transport_type: print
          lang: default
          content:

            - "<<branches.branchaddress2>>"
            - ""
            - ""
            - "Change service requested"
            - ""
            - ""
            - ""

        - module: reserves
          code: HOLDPLACED
          branchcode: ""
          name: "Hold placed on item"
          is_html: 0
          title: "Hold placed on item"
          message_transport_type: email
          lang: default
          content:

        - module: members
          code: PROBLEM_REPORT
          branchcode: ""
          name: "OPAC problem report"
          is_html: 0
          title: "OPAC problem report"
          message_transport_type: email
          lang: default
          content:





INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
('suggestions','TO_PROCESS','Notification pour le responsable du poste budgétaire', 'Une suggestion est prête à être traitée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> par <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');

INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email');

INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) VALUES
('circulation', 'OVERDUES_SLIP', '', 'Ticket pour les documents en retard', '0', 'Ticket pour les documents en retard', 'Le(s) document(s) est/sont présentement en retard :

<item>"<<biblio.title>>" par <<biblio.author>>, <<items.itemcallnumber>>, Code-barres : <<items.barcode>> Amendes : <<items.fine>></item>
', 'print' );

Lines 23-29 VALUES Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-2 / +2 lines)
23	('suggestions','TO_PROCESS','Avis au propriétaire du poste budgétaire', 'Une suggestion est prête à être traitée','<<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> / <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),	23	('suggestions','TO_PROCESS','Avis au propriétaire du poste budgétaire', 'Une suggestion est prête à être traitée','<<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> / <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
24	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),	24	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
25	('members', 'DISCHARGE', 'Quitus', 'Quitus pour <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Quitus</h1>\r\n\r\nLa librairie <<borrowers.branchcode>> certifies que lecteur suivant :\r\n\r\n <<borrowers.firstname>> <<borrowers.surname>>\r\n Numéro de carte : <<borrowers.cardnumber>>\r\n\r\na bien retourné tous ses documents.', 'email'),	25	('members', 'DISCHARGE', 'Quitus', 'Quitus pour <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Quitus</h1>\r\n\r\nLa librairie <<borrowers.branchcode>> certifies que lecteur suivant :\r\n\r\n <<borrowers.firstname>> <<borrowers.surname>>\r\n Numéro de carte : <<borrowers.cardnumber>>\r\n\r\na bien retourné tous ses documents.', 'email'),
26	('members', 'PROBLEM_REPORT','OPAC Problem Report','OPAC Problem Report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');	26	('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');
27		27
28	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)	28	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
29	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin g approval</h3>	29	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin g approval</h3>
Lines 184-190 VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', ' Link Here
184	('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');	184	('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');
185		185
186	INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )	186	INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
187	VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue:	187	VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues slip', '0', 'Overdues slip', 'The following item(s) is/are currently overdue:
188		188
189	<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>	189	<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
190	', 'print' );	190	', 'print' );

Lines 28-34 biblio.title>>\r\n----\r\nGrazie per aver visitaro <<branches.branchname>>.', 'e Link Here

(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-1 / +1 lines)
28	('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <<borrowers.firstname>> <<borrowers.surname>>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <<suggestions.title>> by <<suggestions.author>>.\n\n Grazie dell\'attenzione,\n\n<<branches.branchname>>', 'email'),	28	('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <<borrowers.firstname>> <<borrowers.surname>>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <<suggestions.title>> by <<suggestions.author>>.\n\n Grazie dell\'attenzione,\n\n<<branches.branchname>>', 'email'),
29	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),	29	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
30	('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Liberatoria</h1>\r\n\r\nLa biblioteca <<borrowers.branchcode>> certifica che il seguente utente :\r\n\r\n <<borrowers.firstname>> <<borrowers.surname>>\r\n Numero tessera : <<borrowers.cardnumber>>\r\n\r\nha restituito tutti i documenti ricevuti.', 'email'),	30	('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Liberatoria</h1>\r\n\r\nLa biblioteca <<borrowers.branchcode>> certifica che il seguente utente :\r\n\r\n <<borrowers.firstname>> <<borrowers.surname>>\r\n Numero tessera : <<borrowers.cardnumber>>\r\n\r\nha restituito tutti i documenti ricevuti.', 'email'),
31	('members', 'PROBLEM_REPORT','OPAC Problem Report','OPAC Problem Report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');	31	('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');
32		32
33	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)	33	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
34	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin g approval</h3>	34	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin g approval</h3>




--
-- Default sample notices for Koha.
-- for Koha.
--
-- Copyright (C) 2011 Magnus Enger Libriotech
--

('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email'),
('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');

INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>

('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');

INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues slip', '0', 'Overdues slip', 'The following item(s) is/are currently overdue:

<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
', 'print' );




INSERT INTO `letter` (module, code, name, title, content, message_transport_type)
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', 'email'),
('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>> (<<biblio.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>', 'email'),
('orderacquisition','ACQORDER','Acquisition order','Order','<<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\nPlease order for the library:\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> each).</order>\r\n\r\nThank you,\n\n<<branches.branchname>>', 'email'),
('serial','SERIAL_ALERT','New serial issue','New serial issue 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.', 'email'),
('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', 'email'),
('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>>)', 'email'),
('circulation','DUEDGST','Item due reminder (digest)','Item due reminder','You have <<count>> items due', 'email'),
('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>>)', 'email'),
('circulation','PREDUEDGST','Advance notice of item due (digest)','Advance notice of item due','You have <<count>> items due soon', 'email'),
('circulation','RENEWAL','Item renewals','Item renewals','The following items have been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.', 'email'),
('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>>', 'email'),
('reserves', 'HOLD', 'Hold available for pickup', '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', 'print'),
('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.', 'email'),
('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 [% branch.branchname %].', 'email'),
('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>>).', 'email'),
('reserves', 'CANCEL_HOLD_ON_LOST', 'Hold has been cancelled', "Hold has been cancelled", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nWe regret to inform you, that the following item can not be provided due to it being missing. Your hold was cancelled.\n\nTitle: [% biblio.title %]\nAuthor: [% biblio.author %]\nCopy: [% item.copynumber %]\nLocation: [% branch.branchname %]", 'email'),
('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>>', 'email'),
('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'),

('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email'),
('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');

INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>

    </ul>
    </p>',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Issue slip','Issue slip', '<h3><<branches.branchname>></h3>
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(<<borrowers.cardnumber>>) <br />

<<today>><br />

<h4>Checked out</h4>
<checkedout>
<p>
<<biblio.title>> <br />

<hr />
</div>
</news>', 1),
('circulation','ISSUEQSLIP','Issue quick slip','Issue quick slip', '<h3><<branches.branchname>></h3>
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(<<borrowers.cardnumber>>) <br />

<<today>><br />

<h4>Checked out today</h4>
<checkedout>
<p>
<<biblio.title>> <br />

Date due: <<issues.date_due>><br />
</p>
</checkedout>', 1),
('circulation','HOLD_SLIP','Hold slip','Hold slip', '<h5>Date: <<today>></h5>

<h3> Transfer to/Hold in <<branches.branchname>></h3>


<pre><<reserves.reservenotes>></pre>
</p>
', 1),
('circulation','TRANSFERSLIP','Transfer slip','Transfer slip', '<h5>Date: <<today>></h5>

<h3>Transfer to <<branches.branchname>></h3>



INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
VALUES (
'members',  'OPAC_REG_VERIFY',  '',  'OPAC self-registration verification email',  '1',  'Verify your account',  'Hello!

Your library account has been created. Please verify your email address by clicking this link to complete the signup process:


('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');

INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues slip', '0', 'Overdues slip', 'The following item(s) is/are currently overdue:

<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
', 'print' );




INSERT INTO `letter` (module, code, name, title, content, message_transport_type)
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', 'email'),
('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>> (<<biblio.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>', 'email'),
('orderacquisition','ACQORDER','Acquisition order','Order','<<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\nPlease order for the library:\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> each).</order>\r\n\r\nThank you,\n\n<<branches.branchname>>', 'email'),
('serial','SERIAL_ALERT','New serial issue','New serial issue 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.', 'email'),
('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', 'email'),
('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>>)', 'email'),
('circulation','DUEDGST','Item due reminder (digest)','Item due reminder','You have <<count>> items due', 'email'),
('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>>)', 'email'),
('circulation','PREDUEDGST','Advance notice of item due (digest)','Advance notice of item due','You have <<count>> items due soon', 'email'),
('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>>', 'email'),
('reserves', 'HOLD', 'Hold available for pickup', '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', 'print'),
('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.', 'email'),
('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 [% branch.branchname %].', 'email'),
('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>>).', 'email'),
('reserves', 'CANCEL_HOLD_ON_LOST', 'Hold has been cancelled', "Hold has been cancelled", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nWe regret to inform you, that the following item can not be provided due to it being missing. Your hold was cancelled.\n\nTitle: [% biblio.title %]\nAuthor: [% biblio.author %]\nCopy: [% item.copynumber %]\nLocation: [% branch.branchname %]", 'email'),
('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>>', 'email'),
('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'),

('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email'),
('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');

INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>

    </ul>
    </p>',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Issue slip','Issue slip', '<h3><<branches.branchname>></h3>
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(<<borrowers.cardnumber>>) <br />

<<today>><br />

<h4>Checked out</h4>
<checkedout>
<p>
<<biblio.title>> <br />

<hr />
</div>
</news>', 1),
('circulation','ISSUEQSLIP','Issue quick slip','Issue quick slip', '<h3><<branches.branchname>></h3>
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(<<borrowers.cardnumber>>) <br />

<<today>><br />

<h4>Checked out today</h4>
<checkedout>
<p>
<<biblio.title>> <br />

Date due: <<issues.date_due>><br />
</p>
</checkedout>', 1),
('circulation','HOLD_SLIP','Hold slip','Hold slip', '<h5>Date: <<today>></h5>

<h3> Transfer to/Hold in <<branches.branchname>></h3>


<pre><<reserves.reservenotes>></pre>
</p>
', 1),
('circulation','TRANSFERSLIP','Transfer slip','Transfer slip', '<h5>Date: <<today>></h5>

<h3>Transfer to <<branches.branchname>></h3>



INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
VALUES (
'members',  'OPAC_REG_VERIFY',  '',  'OPAC self-registration verification email',  '1',  'Verify your account',  'Hello!

Your library account has been created. Please verify your email address by clicking this link to complete the signup process:


If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
);

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>>.');

INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,

('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');

INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues slip', '0', 'Overdues slip', 'The following item(s) is/are currently overdue:

<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
', 'print' );

</table>', 'print', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('pos', 'RECEIPT', '', 'Point of sale receipt', 0, 'Receipt', '[% PROCESS "accounts.inc" %]
<table>

Lines 85-91 INSERT INTO `letter` (module, code, name, title, content, message_transport_type Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +1 lines)
85		85
86	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),	86	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
87		87
88	('members', 'PROBLEM_REPORT','OPAC Problem Report','OPAC Problem Report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email')	88	('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email')
89	;	89	;
90		90
91	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)	91	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)

Lines 642-648 Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials> Link Here

(-)a/t/db_dependent/Letters/TemplateToolkit.t (-3 / +2 lines)
642		642
643	<<today>><br />	643	<<today>><br />
644		644
645	<h4>Checked Out</h4>	645	<h4>Checked out</h4>
646	<checkedout>	646	<checkedout>
647	<p>	647	<p>
648	<<biblio.title>> <br />	648	<<biblio.title>> <br />
Lines 698-704 Checked out to [% borrower.title %] [% borrower.firstname %] [% borrower.initial Link Here
698		698
699	[% today \| \$KohaDates with_hours => 1 %]<br />	699	[% today \| \$KohaDates with_hours => 1 %]<br />
700		700
701	<h4>Checked Out</h4>	701	<h4>Checked out</h4>
702	[% FOREACH checkout IN checkouts %]	702	[% FOREACH checkout IN checkouts %]
703	[%~ SET item = checkout.item %]	703	[%~ SET item = checkout.item %]
704	[%~ SET biblio = checkout.item.biblio %]	704	[%~ SET biblio = checkout.item.biblio %]
705	-

Return to bug 25629

Lines 339-345 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-40 / +40 lines)
339	- module: circulation	339	- module: circulation
340	code: CHECKIN	340	code: CHECKIN
341	branchcode: ""	341	branchcode: ""
342	name: "Item Check-in (Digest)"	342	name: "Item check-in (digest)"
343	is_html: 0	343	is_html: 0
344	title: "Check-ins"	344	title: "Check-ins"
345	message_transport_type: email	345	message_transport_type: email
Lines 354-360 tables: Link Here
354	- module: circulation	354	- module: circulation
355	code: CHECKOUT	355	code: CHECKOUT
356	branchcode: ""	356	branchcode: ""
357	name: "Item Check-out (Digest)"	357	name: "Item check-out (digest)"
358	is_html: 0	358	is_html: 0
359	title: "Checkouts"	359	title: "Checkouts"
360	message_transport_type: email	360	message_transport_type: email
Lines 380-388 tables: Link Here
380	- module: circulation	380	- module: circulation
381	code: DUE	381	code: DUE
382	branchcode: ""	382	branchcode: ""
383	name: "Item Due Reminder"	383	name: "Item due reminder"
384	is_html: 0	384	is_html: 0
385	title: "Item Due Reminder"	385	title: "Item due reminder"
386	message_transport_type: email	386	message_transport_type: email
387	lang: default	387	lang: default
388	content:	388	content:
Lines 395-403 tables: Link Here
395	- module: circulation	395	- module: circulation
396	code: DUEDGST	396	code: DUEDGST
397	branchcode: ""	397	branchcode: ""
398	name: "Item Due Reminder (Digest)"	398	name: "Item due reminder (digest)"
399	is_html: 0	399	is_html: 0
400	title: "Item Due Reminder"	400	title: "Item due reminder"
401	message_transport_type: email	401	message_transport_type: email
402	lang: default	402	lang: default
403	content:	403	content:
Lines 406-414 tables: Link Here
406	- module: circulation	406	- module: circulation
407	code: HOLD_SLIP	407	code: HOLD_SLIP
408	branchcode: ""	408	branchcode: ""
409	name: "Hold Slip"	409	name: "Hold slip"
410	is_html: 1	410	is_html: 1
411	title: "Hold Slip"	411	title: "Hold slip"
412	message_transport_type: email	412	message_transport_type: email
413	lang: default	413	lang: default
414	content:	414	content:
Lines 444-452 tables: Link Here
444	- module: circulation	444	- module: circulation
445	code: ISSUEQSLIP	445	code: ISSUEQSLIP
446	branchcode: ""	446	branchcode: ""
447	name: "Issue Quick Slip"	447	name: "Issue quick slip"
448	is_html: 1	448	is_html: 1
449	title: "Issue Quick Slip"	449	title: "Issue quick slip"
450	message_transport_type: email	450	message_transport_type: email
451	lang: default	451	lang: default
452	content:	452	content:
Lines 456-462 tables: Link Here
456	- ""	456	- ""
457	- "<<today>><br />"	457	- "<<today>><br />"
458	- ""	458	- ""
459	- "<h4>Checked Out Today</h4>"	459	- "<h4>Checked out today</h4>"
460	- "<checkedout>"	460	- "<checkedout>"
461	- "<p>"	461	- "<p>"
462	- "<<biblio.title>> <br />"	462	- "<<biblio.title>> <br />"
Lines 468-476 tables: Link Here
468	- module: circulation	468	- module: circulation
469	code: ISSUESLIP	469	code: ISSUESLIP
470	branchcode: ""	470	branchcode: ""
471	name: "Issue Slip"	471	name: "Issue slip"
472	is_html: 1	472	is_html: 1
473	title: "Issue Slip"	473	title: "Issue slip"
474	message_transport_type: email	474	message_transport_type: email
475	lang: default	475	lang: default
476	content:	476	content:
Lines 480-486 tables: Link Here
480	- ""	480	- ""
481	- "<<today>><br />"	481	- "<<today>><br />"
482	- ""	482	- ""
483	- "<h4>Checked Out</h4>"	483	- "<h4>Checked out</h4>"
484	- "<checkedout>"	484	- "<checkedout>"
485	- "<p>"	485	- "<p>"
486	- "<<biblio.title>> <br />"	486	- "<<biblio.title>> <br />"
Lines 513-521 tables: Link Here
513	- module: circulation	513	- module: circulation
514	code: ODUE	514	code: ODUE
515	branchcode: ""	515	branchcode: ""
516	name: "Overdue Notice"	516	name: "Overdue notice"
517	is_html: 0	517	is_html: 0
518	title: "Item Overdue"	518	title: "Item overdue"
519	message_transport_type: email	519	message_transport_type: email
520	lang: default	520	lang: default
521	content:	521	content:
Lines 544-552 tables: Link Here
544	- module: circulation	544	- module: circulation
545	code: OVERDUES_SLIP	545	code: OVERDUES_SLIP
546	branchcode: ""	546	branchcode: ""
547	name: "Overdues Slip"	547	name: "Overdues slip"
548	is_html: 0	548	is_html: 0
549	title: "OVERDUES_SLIP"	549	title: "Overdues slip"
550	message_transport_type: print	550	message_transport_type: print
551	lang: default	551	lang: default
552	content:	552	content:
Lines 558-566 tables: Link Here
558	- module: circulation	558	- module: circulation
559	code: PREDUE	559	code: PREDUE
560	branchcode: ""	560	branchcode: ""
561	name: "Advance Notice of Item Due"	561	name: "Advance notice of item due"
562	is_html: 0	562	is_html: 0
563	title: "Advance Notice of Item Due"	563	title: "Advance notice of item due"
564	message_transport_type: email	564	message_transport_type: email
565	lang: default	565	lang: default
566	content:	566	content:
Lines 573-581 tables: Link Here
573	- module: circulation	573	- module: circulation
574	code: PREDUEDGST	574	code: PREDUEDGST
575	branchcode: ""	575	branchcode: ""
576	name: "Advance Notice of Item Due (Digest)"	576	name: "Advance notice of item due (digest)"
577	is_html: 0	577	is_html: 0
578	title: "Advance Notice of Item Due"	578	title: "Advance notice of item due"
579	message_transport_type: email	579	message_transport_type: email
580	lang: default	580	lang: default
581	content:	581	content:
Lines 584-592 tables: Link Here
584	- module: circulation	584	- module: circulation
585	code: RENEWAL	585	code: RENEWAL
586	branchcode: ""	586	branchcode: ""
587	name: "Item Renewals"	587	name: "Item renewals"
588	is_html: 0	588	is_html: 0
589	title: "Item Renewals"	589	title: "Item renewals"
590	message_transport_type: email	590	message_transport_type: email
591	lang: default	591	lang: default
592	content:	592	content:
Lines 623-631 tables: Link Here
623	- module: circulation	623	- module: circulation
624	code: TRANSFERSLIP	624	code: TRANSFERSLIP
625	branchcode: ""	625	branchcode: ""
626	name: "Transfer Slip"	626	name: "Transfer slip"
627	is_html: 1	627	is_html: 1
628	title: "Transfer Slip"	628	title: "Transfer slip"
629	message_transport_type: email	629	message_transport_type: email
630	lang: default	630	lang: default
631	content:	631	content:
Lines 644-652 tables: Link Here
644	- module: claimacquisition	644	- module: claimacquisition
645	code: ACQCLAIM	645	code: ACQCLAIM
646	branchcode: ""	646	branchcode: ""
647	name: "Acquisition Claim"	647	name: "Acquisition claim"
648	is_html: 0	648	is_html: 0
649	title: "Item Not Received"	649	title: "Item not received"
650	message_transport_type: email	650	message_transport_type: email
651	lang: default	651	lang: default
652	content:	652	content:
Lines 662-668 tables: Link Here
662	- module: members	662	- module: members
663	code: ACCTDETAILS	663	code: ACCTDETAILS
664	branchcode: ""	664	branchcode: ""
665	name: "Account Details Template - DEFAULT"	665	name: "Account details template - DEFAULT"
666	is_html: 0	666	is_html: 0
667	title: "Your new Koha account details."	667	title: "Your new Koha account details."
668	message_transport_type: email	668	message_transport_type: email
Lines 721-729 tables: Link Here
721	- module: members	721	- module: members
722	code: OPAC_REG_VERIFY	722	code: OPAC_REG_VERIFY
723	branchcode: ""	723	branchcode: ""
724	name: "Opac Self-Registration Verification Email"	724	name: "OPAC self-registration verification email"
725	is_html: 1	725	is_html: 1
726	title: "Verify Your Account"	726	title: "Verify your account"
727	message_transport_type: email	727	message_transport_type: email
728	lang: default	728	lang: default
729	content:	729	content:
Lines 915-923 tables: Link Here
915	- module: reserves	915	- module: reserves
916	code: HOLD	916	code: HOLD
917	branchcode: ""	917	branchcode: ""
918	name: "Hold Available for Pickup"	918	name: "Hold available for pickup"
919	is_html: 0	919	is_html: 0
920	title: "Hold Available for Pickup at <<branches.branchname>>"	920	title: "Hold available for pickup at <<branches.branchname>>"
921	message_transport_type: email	921	message_transport_type: email
922	lang: default	922	lang: default
923	content:	923	content:
Lines 937-945 tables: Link Here
937	- module: reserves	937	- module: reserves
938	code: HOLD	938	code: HOLD
939	branchcode: ""	939	branchcode: ""
940	name: "Hold Available for Pickup"	940	name: "Hold available for pickup"
941	is_html: 0	941	is_html: 0
942	title: "Hold Available for Pickup (print notice)"	942	title: "Hold available for pickup (print notice)"
943	message_transport_type: print	943	message_transport_type: print
944	lang: default	944	lang: default
945	content:	945	content:
Lines 948-954 tables: Link Here
948	- "<<branches.branchaddress2>>"	948	- "<<branches.branchaddress2>>"
949	- ""	949	- ""
950	- ""	950	- ""
951	- "Change Service Requested"	951	- "Change service requested"
952	- ""	952	- ""
953	- ""	953	- ""
954	- ""	954	- ""
Lines 981-989 tables: Link Here
981	- module: reserves	981	- module: reserves
982	code: HOLDPLACED	982	code: HOLDPLACED
983	branchcode: ""	983	branchcode: ""
984	name: "Hold Placed on Item"	984	name: "Hold placed on item"
985	is_html: 0	985	is_html: 0
986	title: "Hold Placed on Item"	986	title: "Hold placed on item"
987	message_transport_type: email	987	message_transport_type: email
988	lang: default	988	lang: default
989	content:	989	content:
Lines 1166-1174 tables: Link Here
1166	- module: members	1166	- module: members
1167	code: PROBLEM_REPORT	1167	code: PROBLEM_REPORT
1168	branchcode: ""	1168	branchcode: ""
1169	name: "OPAC Problem Report"	1169	name: "OPAC problem report"
1170	is_html: 0	1170	is_html: 0
1171	title: "OPAC Problem Report"	1171	title: "OPAC problem report"
1172	message_transport_type: email	1172	message_transport_type: email
1173	lang: default	1173	lang: default
1174	content:	1174	content:

Lines 67-79 INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, m Link Here

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (-2 / +2 lines)
67		67
68	INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES	68	INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
69	('suggestions','TO_PROCESS','Notification pour le responsable du poste budgétaire', 'Une suggestion est prête à être traitée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> par <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),	69	('suggestions','TO_PROCESS','Notification pour le responsable du poste budgétaire', 'Une suggestion est prête à être traitée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> par <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
70	('members', 'PROBLEM_REPORT','OPAC Problem Report','OPAC Problem Report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');	70	('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');
71		71
72	INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES	72	INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
73	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email');	73	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email');
74		74
75	INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) VALUES	75	INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) VALUES
76	('circulation', 'OVERDUES_SLIP', '', 'Ticket pour les documents en retard', '0', 'OVERDUES_SLIP', 'Le(s) document(s) est/sont présentement en retard :	76	('circulation', 'OVERDUES_SLIP', '', 'Ticket pour les documents en retard', '0', 'Ticket pour les documents en retard', 'Le(s) document(s) est/sont présentement en retard :
77		77
78	<item>"<<biblio.title>>" par <<biblio.author>>, <<items.itemcallnumber>>, Code-barres : <<items.barcode>> Amendes : <<items.fine>></item>	78	<item>"<<biblio.title>>" par <<biblio.author>>, <<items.itemcallnumber>>, Code-barres : <<items.barcode>> Amendes : <<items.fine>></item>
79	', 'print' );	79	', 'print' );

Lines 1-6 Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (-4 / +3 lines)
1	--	1	--
2	-- Default classification sources and filing rules	2	-- Default sample notices for Koha.
3	-- for Koha.
4	--	3	--
5	-- Copyright (C) 2011 Magnus Enger Libriotech	4	-- Copyright (C) 2011 Magnus Enger Libriotech
6	--	5	--
Lines 44-50 VALUES ('circulation','ODUE','Purring','Purring på dokument','<<borrowers.first Link Here
44	('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),	43	('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
45	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),	44	('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
46	('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n <<borrowers.firstname>> <<borrowers.surname>>\r\n Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email'),	45	('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n <<borrowers.firstname>> <<borrowers.surname>>\r\n Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email'),
47	('members', 'PROBLEM_REPORT','OPAC Problem Report','OPAC Problem Report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');	46	('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');
48		47
49	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)	48	INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
50	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin g approval</h3>	49	VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin g approval</h3>
Lines 203-209 VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', ' Link Here
203	('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');	202	('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');
204		203
205	INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )	204	INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
206	VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue:	205	VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues slip', '0', 'Overdues slip', 'The following item(s) is/are currently overdue:
207		206
208	<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>	207	<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
209	', 'print' );	208	', 'print' );