[Koha] Problem with Notices & Slips

[अभिषेक नागर Abhishek Nãgar]

Thanks i was able to do it by using
http://kohageek.blogspot.com/2017/03/borrowers-force-messaging-defaults.html


On Wed, 13 Feb 2019 at 13:00, अभिषेक नागर Abhishek Nãgar <
abhishek at kashipur.in> wrote:

> Hi Katrin,
>
> Thanks for your Help i was able to setup Overdue Notice, was also able to
> import sample Notice, Would like to know how ate these notices triggered eg
> i want to send an email to Patrons to whom Booked were checked out on daily
> basis. how do i do that
>
>
>
> On Wed, 13 Feb 2019 at 12:39, अभिषेक नागर Abhishek Nãgar <
> abhishek at kashipur.in> wrote:
>
>> Hi,
>>
>> Thanks i was able to import and its working now
>>
>> Thanks Again
>>
>>
>>
>> On Wed, 13 Feb 2019 at 12:35, Katrin Fischer <katrin.fischer.83 at web.de>
>> wrote:
>>
>>> Hi,
>>>
>>> sorry, the table is: message_transports
>>>
>>> You will need to add the configuration data missed while installing. The
>>> SQL files for this are part of your installation in
>>> installer/data/mysql/en/mandatory/
>>>
>>> They rarely change, so these are the links to the current versions in
>>> git:
>>>
>>>
>>> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/message_transport_types.sql;h=ed3c4ad13aa2c33e380eccc1f12674b11de9fb99;hb=66f3a72a01ba5238a9bba39a3b9cb659dbb47a42
>>>
>>>
>>> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql;h=a7a6032cc74117ef67cd79270245a77539593dcb;hb=66f3a72a01ba5238a9bba39a3b9cb659dbb47a42
>>>
>>>
>>> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/sample_notices_message_transports.sql;h=5954bafc7b35dce64374f7a1f5c97f2ad2b91755;hb=66f3a72a01ba5238a9bba39a3b9cb659dbb47a42
>>>
>>> Katrin
>>> On 13.02.19 07:54, अभिषेक नागर Abhishek Nãgar wrote:
>>>
>>> Hi Katrin,
>>>
>>> My Database contains Tables message_attributes and
>>> message_transport_types but are empty Table message_transport does not
>>> exist how can i get the Default SQL for creating the tables
>>>
>>> mysql> select * from message_transport_types;
>>> Empty set (0.00 sec)
>>>
>>> mysql> select * from message_transport;
>>> ERROR 1146 (42S02): Table 'koha_library.message_transport' doesn't exist
>>>
>>> mysql> select * from message_attributes;
>>> Empty set (0.00 sec)
>>>
>>>
>>>
>>>
>>> On Wed, 13 Feb 2019 at 12:19, Katrin Fischer <katrin.fischer.83 at web.de>
>>> wrote:
>>>
>>>> Hi Abhishek,
>>>>
>>>> I think you might not be missing the sample notices, but some of the
>>>> mandatory data.
>>>>
>>>> Check your database tables: message_attributes, message_transport and
>>>> message_transport_types. Especially the last one should have 4 entries:
>>>> email, phone, print, sms. But the others need to have data as well.
>>>>
>>>> Katrin
>>>> On 12.02.19 09:12, अभिषेक नागर Abhishek Nãgar wrote:
>>>>
>>>> I am Using Koha 18.11.02.000, Installed it via apt-get
>>>>
>>>> When i try to Add a Notice and click on save i get an alert Please fill
>>>> at least one template. (attached)
>>>> _________________________________________
>>>> Abhishek Nagar
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, 11 Feb 2019 at 11:45, Katrin Fischer <katrin.fischer.83 at web.de>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> you can find examples for a lot of the notices in the wiki:
>>>>> https://wiki.koha-community.org/wiki/Notices_and_Slips_Library
>>>>>
>>>>> If you have access to your database you could also load the sample
>>>>> notices using SQL. The SQL file is part of your Koha installation.
>>>>>
>>>>> But not having the sample notices should not create any problems when
>>>>> using the notices and slips tool. What you describe sounds like there
>>>>> might be another problem.
>>>>>
>>>>> How did you install Koha and which version are you using? What is the
>>>>> error displaying?
>>>>>
>>>>> Katrin
>>>>>
>>>>>
>>>>> On 04.02.19 14:56, अभिषेक नागर Abhishek Nãgar wrote:
>>>>> > Dear All,
>>>>> >
>>>>> > I am relatively new to Koha, installed my first instance was able to
>>>>> import
>>>>> > 40000+ titles from LibSys ane approx 3000 Users.
>>>>> >
>>>>> > Koha installation is working quite well on a 8 Gb RAM VPS
>>>>> Cataloguing,
>>>>> > Circulation and everything thing is working just file. But No default
>>>>> > templates are available under Notices & Slips I would like to enable
>>>>> few
>>>>> > email alerts.
>>>>> >
>>>>> > When I try to add new notice it won't allow me to do and displays
>>>>> error to
>>>>> > select a template while email phone body fields are not visible while
>>>>> > creating Notice.
>>>>> >
>>>>> > Kindly suggest how to import default notices now so that it may work.
>>>>> >
>>>>> > IMO I deselected sample notices while creating instance can I now get
>>>>> > default Notices & Slips
>>>>> >
>>>>> >
>>>>> > Abhishek Nagar
>>>>> > _______________________________________________
>>>>> > Koha mailing list  http://koha-community.org
>>>>> > Koha at lists.katipo.co.nz
>>>>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>> _______________________________________________
>>>>> Koha mailing list  http://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>
>>>>