From 34a20d5490fad49fbb91d6888b2a99aff45c6efb Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 21 Mar 2014 15:42:54 +0100 Subject: [PATCH] Bug 9032: QA Follow-up: Adding notices to foreign installer files Adds the notices SHARE_INVITE and SHARE_ACCEPT to sample_notices.sql for the foreign language installer files in installer/data/mysql. Signed-off-by: Marcel de Rooy I tested each installer file by deleting all notices from letter, running the file and counting the records. I did so with and without this patch. The results below show that in each case two notices were added as expected. Note that the English file contains 25 notices including the two new ones. BEFORE THIS PATCH: de-DE/mandatory/sample_notices.sql: 23 notices es-ES/mandatory/sample_notices.sql: 18 notices fr-FR/1-Obligatoire/sample_notices.sql: 18 notices it-IT/necessari/notices.sql: 21 notices nb-NO/1-Obligatorisk/sample_notices.sql: 23 notices pl-PL/mandatory/sample_notices.sql: 18 notices ru-RU/mandatory/sample_notices.sql: 18 notices uk-UA/mandatory/sample_notices.sql: 17 notices AFTER THIS PATCH: de-DE/mandatory/sample_notices.sql: 25 notices es-ES/mandatory/sample_notices.sql: 20 notices fr-FR/1-Obligatoire/sample_notices.sql: 20 notices it-IT/necessari/notices.sql: 23 notices nb-NO/1-Obligatorisk/sample_notices.sql: 25 notices pl-PL/mandatory/sample_notices.sql: 20 notices ru-RU/mandatory/sample_notices.sql: 20 notices uk-UA/mandatory/sample_notices.sql: 19 notices Signed-off-by: Jonathan Druart --- .../data/mysql/de-DE/mandatory/sample_notices.sql | 25 ++++++++++++++++++++ .../data/mysql/es-ES/mandatory/sample_notices.sql | 25 ++++++++++++++++++++ .../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, 200 insertions(+) diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql index 0bb581a..ca4758a 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -119,3 +119,28 @@ Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachricht Vielen Dank, Ihr Bibliotheksteam' ); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql index 346133f..e05eb67 100644 --- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql +++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql @@ -17,3 +17,28 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\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 <>\n\nThank you,\n\n<>'), ('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'); INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.'); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); 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 4b786b6..9632bde 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql @@ -19,3 +19,28 @@ VALUES ('suggestions','ORDERED','Suggestion commandée', 'Suggestion commandée','Cher(e) <> <>,\n\nVous avez effectué une demande de suggestion d\'achat sur le docuement <> de <>.\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 <>\n\nMerci,\n\n<>'), ('suggestions','REJECTED','Suggestion rejetée', 'Suggestion d\'achat rejeté','Cher(e) <> <>,\n\nVous avez fait la demande du document <> de <>.\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: <>\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <>.\n\nMerci,\n\n<>'); 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<>\r\n----\r\nMerci, <>.'); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql index afdae5d..a26468c 100644 --- a/installer/data/mysql/it-IT/necessari/notices.sql +++ b/installer/data/mysql/it-IT/necessari/notices.sql @@ -105,3 +105,28 @@ Date due: <>
  • <>
  • <>
  • ', 1); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); 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 6c401a5..e5fbd90 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql @@ -138,3 +138,28 @@ http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql index cd487d4..c0d60e1 100644 --- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -19,3 +19,28 @@ VALUES ('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\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 <>\n\nThank you,\n\n<>'), ('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'); INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.'); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql index 9c1f259..78c776a 100644 --- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql +++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql @@ -17,3 +17,28 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\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 <>\n\nThank you,\n\n<>'), ('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'); INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.'); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql index 8b61186..cf9f850 100644 --- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql +++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql @@ -16,3 +16,28 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\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 <>\n\nThank you,\n\n<>'), ('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'); INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Item Renewal','Renewals','The following items have been renew:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.'); + +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); -- 1.7.10.4