Hi, Perhaps it's in 3.2, but in 3.0.x it's not !
Le Tue, 23 Mar 2010 13:36:27 -0400, Chris Nighswonger <[email protected]> a écrit : > 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
