Setting up KanBo Email Notifications on Azure

Following article describes configuration of KanBo email notifications. Only unread notifications are sent by email. Each user can tun it on or off individually and specify sending intervals.


Contact us at support@kanbozone.com to receive most recent KanBo installation package.


Unizip the MailNotificationWebJob.zip to choosen location.




Step 1: Update KanBo.EmailNotifications.exe.config file with your parameters

For detailed information about configuration follow attached readme.txt file.

Copy the connection strings (KanBoSqlConnectionString and KanBoProfilesConnectionString) from the KanBo web.config and put them to the KanBo.EmailNotifications.exe.config into <connectionStrings> section.


They should look like this:

<connectionStrings>
 <add name="job" connectionString="Data Source=job.sqlite" providerName="System.Data.SQLite.EF6" />
 <add name="main" connectionString="Server=tcp:<b>YOUR_AZURE_SQL_SERVER</b>.database.windows.net,1433;Database=<b>YOUR_INSTANCES_DATABASE</b>_instances;User ID=<b>USER@YOUR_AZURE_SQL_SERVER</b>;Password=<b>PASSWORD</b>;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />
 <add name="profiles" connectionString="Server= tcp:<b>YOUR_AZURE_SQL_SERVER</b>.database.windows.net,1433;Database=<b>YOUR_PROFILES_DATABASE</b>_profiles;User ID=<b>USER@YOUR_AZURE_SQL_SERVER</b>;Password=<b>PASSWORD</b>;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />
</connectionStrings>

Then adjust settings in <kanbo> section. For Office 365 / Azure they should be:

<kanbo link="https://<b>YOUR_KANBO_ADDRESS</b>.azurewebsites.net/intranet/{id}" template="template.html" limit="100">
  <sender email="<b>EXISTING_OFFICE_365_USER@YOURDOMAIN</b>.onmicrosoft.com" type="SmtpClient">
    <smtpClient DeliveryMethod="Network" Username="<b>EXISTING_OFFICE_365_USER@YOURDOMAIN</b>.onmicrosoft.com" Password="<b>YOUR_PASSWORD</b>" EnableSsl="True" Host="<b>smtp.office365.com</b>" Port="<b>587</b>" />
  </sender>
</kanbo>

Create zip archive from all files in MailNotificationWebJob including those you have just modified.


You can also use testTO to check configuration. Here is an example:

<kanbo link="https://<b>YOUR_KANBO_ADDRESS</b>.azurewebsites.net/intranet/{id}" template="template.html" limit="100">
  <sender email="<b>EXISTING_OFFICE_365_USER@YOURDOMAIN</b>.onmicrosoft.com" type="SmtpClient" testTo="<b>EMAIL_WHERE_TO_SEND_TEST_MESSAGE@DOMAIN.COM</b>" >
    <smtpClient DeliveryMethod="Network" Username="<b>EXISTING_OFFICE_365_USER@YOURDOMAIN</b>.onmicrosoft.com" Password="<b>YOUR_PASSWORD</b>" EnableSsl="True" Host="<b>smtp.office365.com</b>" Port="<b>587</b>" />
  </sender>
</kanbo>

Step 2: Create a WebJob on Azure

Navigate to your KanBo Azure website (http://manage.windowsazure.com).

Enter your Web Application and select Webjobs from the left pane menu.

Click on +Add button.

Set up KanBo email notifications on Azure


Enter name: KanBoEmailNotifications.

Upload the zip File with MailNotificationsWebJob.

Set type to Continous, set Scale to Single Instance.

Click OK to save your WebJob.

Set up KanBo email notifications on Azure


Click on your Webjob and then, select Start button. As a result, a status of this Webjob will be changed to Running.

Set up KanBo email notifications on Azure


Step 3: Enable Email notifications in KanBo web.config

Open KanBo web.config and find “<add key="KanBoEmailNotifications" value="true" />” and ensure value is set to true and save the web.config.

After that clear your browser cache.


Step 5: Turn email notifications on you KanBo account

Navigate to MySettings by clicking on your user picture.



My Settings section will appear. Enter Notifications and set email notifications. You can disable them or configure them to appear every 15 minutes, 60 minutes or 24 hours.



From now on when you have a new notification in KanBo and you don't read it within KanBo or on your mobile App you will get email summing up all your unread KanBo notifications. Blow you can see an example of an email generated by KanBo.

Set up KanBo email notifications on Azure



Possible errors:

"Something bad happened with AddtoGroup" error in email notifications

It means that these notifications are very old and not compatible with the new version of Kanbo your organization now has and, since the email notifications has been enabled recently, these old notifications are being sent to people which haven't entered KanBo before.

There is a solution to fix it. Please open the Content Database of KanBo in SQL Manager. Then please execute the following script on this database: 

UPDATE NotificationUsers SET WasMailed = 1

It will resen all MailNotification Counters to 0 and you should not be getting any errors with the email notifications.

Email notifications Azure installation o365 Office365

Is this article helpful for you?