[Koha-patches] [PATCH] (bug #4334) create needed sample datas
Chris Nighswonger
cnighswonger at foundations.edu
Tue Mar 23 18:36:27 CET 2010
Hmm... sample notice data in English still appears in the main repo:
http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=installer/data/mysql/en/mandatory/sample_notices.sql;h=ca570adc62a12ca07878cbe7f4398aa050b29289;hb=HEAD
Kind Regards,
Chris
On Tue, Mar 23, 2010 at 11:41 AM, Nahuel ANGELINETTI
<nahuel.angelinetti at biblibre.com> wrote:
> This add samplenotices.sql that disappear, and add in fr-FR:
> * sample_notices_message_attributes.sql
> * sample_notices_message_transports.sql
> ---
> .../data/mysql/en/mandatory/sample_notices.sql | 52 ++++++++++++++++++++
> .../data/mysql/en/mandatory/sample_notices.txt | 1 +
> .../optional/sample_notices_message_transports.sql | 2 +-
> .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 52 ++++++++++++++++++++
> .../mysql/fr-FR/1-Obligatoire/sample_notices.txt | 1 +
> .../sample_notices_message_attributes.sql | 8 +++
> .../sample_notices_message_attributes.txt | 2 +
> .../sample_notices_message_transports.sql | 21 ++++++++
> .../sample_notices_message_transports.txt | 3 +
> 9 files changed, 141 insertions(+), 1 deletions(-)
> create mode 100644 installer/data/mysql/en/mandatory/sample_notices.sql
> create mode 100644 installer/data/mysql/en/mandatory/sample_notices.txt
> create mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
> create mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt
> create mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
> create mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
> create mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
> create mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
>
> diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql
> new file mode 100644
> index 0000000..25be5d7
> --- /dev/null
> +++ b/installer/data/mysql/en/mandatory/sample_notices.sql
> @@ -0,0 +1,52 @@
> +INSERT INTO `letter`
> +(module, code, name, title, content)
> +VALUES
> +('circulation','ODUE','Overdue Notice','Item Overdue','Dear
> +<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nAccording to our current
> +records, you have items that are overdue.Your library does not charge late
> +fines, but please return orrenew them as soon as
> +possible.\r\n\r\n<<branches.branchname>><<branches.branchaddress1>><<branches.branchaddress2>><<branches.branchaddress3>><<branches.branchphone>><<branches.branchfax>><<branches.branchemail>>If
> + you have registered a password with the library, you may use it withyour
> +library card number to 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. The following item is currently overdue:\r\n\r\n<<items.content>>'),
> +('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\nOrdernumber
> + <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered)
> +($<<aqorders.listprice>> each) has not been received.'),
> +('serial','RLIST','Routing List','Serial is now
> +available','<<borrowers.firstname>> <<borrowers.title>>,\r\n\r\nThe following
> +issue is now available:\r\n\r\n<<items.content>>\r\n\r\nPlease pick it up at
> +your convenience.'),
> +('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\nkohaad... at yoursite.org'),
> +('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<<items.content>>'),
> +('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You
> +have <<count>> items due'),
> +('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<<items.content>>'),
> +('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance
> +Notice of Item Due','You have <<count>> items due soon'),
> +('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear
> +<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThis is a reminder of an
> +upcoming library event in which you have expressed interest.'),
> +('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>>'),
> +('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.'),
> +('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following
> +items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you
> +for visiting <<branches.branchname>>.');
> +
> diff --git a/installer/data/mysql/en/mandatory/sample_notices.txt b/installer/data/mysql/en/mandatory/sample_notices.txt
> new file mode 100644
> index 0000000..6f87af8
> --- /dev/null
> +++ b/installer/data/mysql/en/mandatory/sample_notices.txt
> @@ -0,0 +1 @@
> +Sample Notices
> \ No newline at end of file
> diff --git a/installer/data/mysql/en/optional/sample_notices_message_transports.sql b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
> index 594da45..5aa2996 100644
> --- a/installer/data/mysql/en/optional/sample_notices_message_transports.sql
> +++ b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
> @@ -12,7 +12,7 @@ values
> (2, 'sms', 0, 'circulation', 'PREDUE'),
> (2, 'sms', 1, 'circulation', 'PREDUEDGST'),
> (3, 'sms', 0, 'circulation', 'EVENT'),
> -(4, 'sms', 0, 'reserves', 'HOLD');
> +(4, 'sms', 0, 'reserves', 'HOLD'),
> (4, 'sms', 0, 'reserves', 'HOLD'),
> (5, 'email', 0, 'circulation', 'CHECKIN'),
> (5, 'sms', 0, 'circulation', 'CHECKIN'),
> diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
> new file mode 100644
> index 0000000..25be5d7
> --- /dev/null
> +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
> @@ -0,0 +1,52 @@
> +INSERT INTO `letter`
> +(module, code, name, title, content)
> +VALUES
> +('circulation','ODUE','Overdue Notice','Item Overdue','Dear
> +<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nAccording to our current
> +records, you have items that are overdue.Your library does not charge late
> +fines, but please return orrenew them as soon as
> +possible.\r\n\r\n<<branches.branchname>><<branches.branchaddress1>><<branches.branchaddress2>><<branches.branchaddress3>><<branches.branchphone>><<branches.branchfax>><<branches.branchemail>>If
> + you have registered a password with the library, you may use it withyour
> +library card number to 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. The following item is currently overdue:\r\n\r\n<<items.content>>'),
> +('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\nOrdernumber
> + <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered)
> +($<<aqorders.listprice>> each) has not been received.'),
> +('serial','RLIST','Routing List','Serial is now
> +available','<<borrowers.firstname>> <<borrowers.title>>,\r\n\r\nThe following
> +issue is now available:\r\n\r\n<<items.content>>\r\n\r\nPlease pick it up at
> +your convenience.'),
> +('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\nkohaad... at yoursite.org'),
> +('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<<items.content>>'),
> +('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You
> +have <<count>> items due'),
> +('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<<items.content>>'),
> +('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance
> +Notice of Item Due','You have <<count>> items due soon'),
> +('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear
> +<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThis is a reminder of an
> +upcoming library event in which you have expressed interest.'),
> +('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>>'),
> +('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.'),
> +('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following
> +items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you
> +for visiting <<branches.branchname>>.');
> +
> diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt
> new file mode 100644
> index 0000000..6f87af8
> --- /dev/null
> +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt
> @@ -0,0 +1 @@
> +Sample Notices
> \ No newline at end of file
> diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
> new file mode 100644
> index 0000000..8f89ff7
> --- /dev/null
> +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
> @@ -0,0 +1,8 @@
> +insert into `message_attributes`
> +(`message_attribute_id`, message_name, `takes_days`)
> +values
> +(1, 'Item DUE', 0),
> +(2, 'Advance Notice', 1),
> +(3, 'Upcoming Events', 1),
> +(4, 'Hold Filled', 0);
> +
> diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
> new file mode 100644
> index 0000000..770bcac
> --- /dev/null
> +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
> @@ -0,0 +1,2 @@
> +defines default messages for items due, advance notices, and upcoming library events.
> +
> diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
> new file mode 100644
> index 0000000..5aa2996
> --- /dev/null
> +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
> @@ -0,0 +1,21 @@
> +insert into `message_transports`
> +(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
> +values
> +(1, 'email', 0, 'circulation', 'DUE'),
> +(1, 'email', 1, 'circulation', 'DUEDGST'),
> +(2, 'email', 0, 'circulation', 'PREDUE'),
> +(2, 'email', 1, 'circulation', 'PREDUEDGST'),
> +(3, 'email', 0, 'circulation', 'EVENT'),
> +(4, 'email', 0, 'reserves', 'HOLD'),
> +(1, 'sms', 0, 'circulation', 'DUE'),
> +(1, 'sms', 1, 'circulation', 'DUEDGST'),
> +(2, 'sms', 0, 'circulation', 'PREDUE'),
> +(2, 'sms', 1, 'circulation', 'PREDUEDGST'),
> +(3, 'sms', 0, 'circulation', 'EVENT'),
> +(4, 'sms', 0, 'reserves', 'HOLD'),
> +(4, 'sms', 0, 'reserves', 'HOLD'),
> +(5, 'email', 0, 'circulation', 'CHECKIN'),
> +(5, 'sms', 0, 'circulation', 'CHECKIN'),
> +(6, 'email', 0, 'circulation', 'CHECKOUT'),
> +(6, 'sms', 0, 'circulation', 'CHECKOUT');
> +
> diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
> new file mode 100644
> index 0000000..18e3431
> --- /dev/null
> +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
> @@ -0,0 +1,3 @@
> +Defines default message transports for sending item due messages,
> +advance notice messages, and library event messages through email
> +and SMS.
> --
> 1.6.3.3
>
> _______________________________________________
> Koha-patches mailing list
> Koha-patches at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-patches
>
More information about the Koha-patches
mailing list