Release Notes 1.9.0 – Boomerang

Release Notes 1.9.0

Date: August 03, 2013
This release: 1.9.0
Last release: 1.8.1

Important Note

You must completely uninstall any previous version of Boomerang binary components before installing this distribution. The existing Boomerang database will be automatically updated by the setup application.
Unless you are upgrading from a previous version, you must obtain an appropriate license from Fuel9 Inc. in order to begin using the product. Please refer to our on-line documentation on how to register your copy of Boomerang and receive license for it.

New features

Twilio integration

Twilio is an enterprise cloud-based SMS appliance solution. Find more information about Twilio on http://www.twilio.com/sms.
Current implementation of the Boomerang Twilio adapter supports both inbound and outbound SMS flow and requires a separate account with Twilio.

Enhancements / Fixes

=====================
1) HTML alternative parts for inbound e-mail messages will now be saved to IN_EMAIL_CONTENT table along with other attachements. HTML body alternatives will use “body.htm” name.

2) New Boomerang settings to support SMS:

+------------------------------+---------------------------------------------------+
| Setting                      | Description                                       |
+------------------------------+---------------------------------------------------+
| threads_out_sms              | (int), concurrent outbound workers limit,         |
|                              |        default -1 = automatically allocated       |
| db_interval_sms              | (int), SMS job polling interval, sec              |
| db_timeout_sms               | (int), wait interval if system error occurs, sec  |
| retry_times_sms              | (int), number of times to retry SMS job if errors |
| retry_period_sms             | (int), retry time increment, sec                  |
| sms_provider                 | (int), SMS services provider, 0 = Twilio          |
+------------------------------+---------------------------------------------------+

New Boomerang settings to support Twilio:

+------------------------------+---------------------------------------------------+
| Setting                      | Description                                       |
+------------------------------+---------------------------------------------------+
| twilio_account               | (string), Twilio account, required                |
| twilio_secret                | (string), Twilio secret, required                 |
| twilio_default_from          | (string), Twilio default from phone number        |
| twilio_user                  | (string), Twilio proxy user                       |
| twilio_password              | (string), Twilio proxy password                   |
| twilio_proxy_port            | (int), Twilio proxy port                          |
| twilio_status_interval       | (int), Twilio job status polling interval, min    |
|                              |        (default is 1 min)                         |
+------------------------------+---------------------------------------------------+

3) New database objects to support SMS feature.

Tables

[IN_SMS] is a repository for all inbound SMS communication.
[OUT_SMS] is a repository for all outbound SMS communication.

Stored Procedures

[sp_Resubmit_Sms] is a user-defined method to re-submit an existing SMS job.
[sp_After_Sms_Job] is a user-defined callback fired after an outbound SMS job finishes.
[sp_On_Sms_In] is a user-defined callback fired after a new inbound SMS message has been received.
[sp_On_Sms_Status] is a user-defined callback fired when a status of an outbound SMS job has been changed.

New table columns

+--------------------+-----------------+-----------------+---------------------------------------+
| Table              | Column          | Type            | Description                           |
+--------------------+-----------------+-----------------+---------------------------------------+
| IN_SMS             | rKey            | uniqueidentifier| Unique Boomerang key                  |
| IN_SMS             | Created_On      | datetime        | Received local timestamp              |
| IN_SMS             | ID              | varchar(50)     | Service provider remote ID            |
| IN_SMS             | From            | varchar(50)     | Sender phone number                   |
| IN_SMS             | To              | varchar(50)     | Receiver phone number                 |
| IN_SMS             | Text            | nvarchar(160)   | SMS message                           |
| IN_SMS             | Processed_On    | datetime        | Service provider acceptance timestamp |
| IN_SMS             | Price           | float           | Service provider message cost         |
| OUT_SMS            | gKey            | uniqueidentifier| Unique Boomerang event key            |
| OUT_SMS            | jKey            | uniqueidentifier| Unique Boomerang job key              |
| OUT_SMS            | ID              | varchar(50)     | Service provider remote ID            |
| OUT_SMS            | From            | varchar(50)     | Sender phone number                   |
| OUT_SMS            | To              | varchar(50)     | Receiver phone number                 |
| OUT_SMS            | Text            | nvarchar(160)   | SMS message                           |
| OUT_SMS            | Processed_On    | datetime        | Service provider acceptance timestamp |
| OUT_SMS            | Price           | float           | Service provider message cost         |
+--------------------+-----------------+-----------------+---------------------------------------+

For more information on data changes please refer to Fuel9 web site.