Attachment 36720 Details for Bug 1985 – Bug 1985 - Follow up: Add sample letter to other languages

[patch] Bug 1985 - Follow up: Add sample letter to other languages

Bug-1985---Follow-up-Add-sample-letter-to-other-la.patch (text/plain), 15.25 KB, created by Mark Tompsett on 2015-03-06 16:58:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2015-03-06 16:58:08 UTC

Size: 15.25 KB

patch

obsolete

>From ec55057fc2149cd6ed7a5461757f6374f3aec40c Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Fri, 6 Mar 2015 11:24:26 -0500
>Subject: [PATCH] Bug 1985 - Follow up: Add sample letter to other languages
>
>As per comment #36, the letter COMMENT_CREATED has been added
>to the other languages.
>
>TEST PLAN
>---------
>0) Back up your letters table
>1) In your mysql client after selected your Koha database,
>   Run this:
>
>SET foreign_key_checks = 0;
>truncate letter;
>source installer/data/mysql/de-DE/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/es-ES/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/it-IT/necessari/notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>truncate letter;
>source installer/data/mysql/en/mandatory/sample_notices.sql
>SELECT COUNT(*) FROM letter where code='COMMENT_CREATED';
>
>   -- there should be 9 counts of 1.
>2) Restore your letters table.
>---
> .../data/mysql/de-DE/mandatory/sample_notices.sql  | 25 ++++++++++++++++++++++
> .../data/mysql/es-ES/mandatory/sample_notices.sql  | 24 +++++++++++++++++++++
> .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   | 25 ++++++++++++++++++++++
> installer/data/mysql/it-IT/necessari/notices.sql   | 25 ++++++++++++++++++++++
> .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql  | 25 ++++++++++++++++++++++
> .../data/mysql/pl-PL/mandatory/sample_notices.sql  | 25 ++++++++++++++++++++++
> .../data/mysql/ru-RU/mandatory/sample_notices.sql  | 25 ++++++++++++++++++++++
> .../data/mysql/uk-UA/mandatory/sample_notices.sql  | 25 ++++++++++++++++++++++
> 8 files changed, 199 insertions(+)
>
>diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>index 01ae5d4..938f542 100644
>--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>@@ -108,6 +108,31 @@ Vielen Dank,
> Ihr Bibliotheksteam'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
> VALUES ('members', 'SHARE_INVITE', '', 'Einladung zum Teilen einer Liste', '0', 'Teilen der Liste <<listname>>', 'Lieber Benutzer,
> 
>diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>index b105f58..e6dd5a5 100644
>--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>@@ -116,6 +116,30 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> 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, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
> 
> 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>>.');
> 
>diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>index d66a2d4..b2ba0d5 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -119,6 +119,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> Si vous n''Ãªtes pas Ã  l''origine de cette inscription, vous pouvez ignorer ce message.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> 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>>.');
> 
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
>diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql
>index 626f208..ec2d89d 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -118,6 +118,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> 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, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
> VALUES ('members', 'SHARE_INVITE', '', 'Invito per condividere una lista', '0', 'Condivisione lista <<listname>>', 'Salve,
> 
>diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>index f1e8fb0..479f0fd 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -139,6 +139,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> Dersom du ikke har bedt om Ã¥ bli registret som bruker av biblioteket kan du se bort fra denne engangsmeldingen. ForespÃ¸rselen vil snart gÃ¥ ut pÃ¥ dato.'
> );
> 
>+INSERT INTO  letter (module, code, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> 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,
> 
>diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>index 2281739..8967c09 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -118,6 +118,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> 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, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> 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,
> 
>diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>index a8d3046..008b1e5 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -119,6 +119,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> 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, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> 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)
>diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>index db8976e..f616f1c 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -118,6 +118,31 @@ http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower
> 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, branchcode, name, is_html, title, content, message_transport_type)
>+VALUES ( 'members', 'COMMENT_CREATED', '', 'Comment created notification', '0', 'Comment from <<borrowers.cardnumber>> is waiting for moderation',
>+'Dear moderator,
>+
>+We want to inform you that borrower <<borrowers.cardnumber>> has just created a new comment on <<biblio.title>>, which is biblionumber <<biblio.biblionumber>>.
>+
>+--- BEGIN COMMENT ---
>+<<reviews.review>>
>+--- END COMMENT ---
>+
>+To approve:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=approve&reviewid=<<reviews.reviewid>>
>+
>+To delete:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl?op=delete&reviewid=<<reviews.reviewid>>
>+
>+Or to review all comments:
>+http://<<staffClientBaseURL>>/cgi-bin/koha/reviews/reviewswaiting.pl
>+
>+Check it out!
>+
>+Your library.',
>+'email'
>+);
>+
> 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)
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 1985: 33916 | 33918 | 36065 | 36516 | 36517 | 36521 | 36522 | 36613 | 36614 | 36628 | 36629 | 36643 | 36644 | 36645 | 36677 | 36678 | 36720 | 38908 | 38909 | 38910 | 39062 | 63746 | 63747 | 63748 | 63749 | 63750 | 63751 | 63752 | 63761 | 63762 | 63763 | 74760 | 74761 | 74762 | 74763 | 74764 | 74769 | 74770 | 74771 | 91190 | 91191 | 91192 | 91193 | 91194 | 91195 | 91196 | 91197 | 91198 | 91818 | 91819 | 91820 | 91821 | 91822 | 91823