[Koha-patches] [PATCH] (bug #4334) create needed sample datas

[Nahuel ANGELINETTI]

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 <cnighswonger at foundations.edu> 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
> <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
> >