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 <[email protected]> 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\[email protected]'), > +('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\[email protected]'), > +('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 > [email protected] > http://lists.koha.org/mailman/listinfo/koha-patches > _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-patches
