Home › Forums › Developers › General developer's discussion ›

SMS support

Submitted by tanderson on Wed, 12/10/2011 - 12:13
in

I've uploaded an early version of OpenVPMS 1.5-beta-3 with SMS support to:
http://repository.openvpms.org/snapshots/org/openvpms/openvpms-release/1...

Two email-to-SMS gateways are supported out of the box:

To sign up, go to: http://www.smsglobal.com/en-au/solutions/signup_page.php
SMSGlobal allows you to send a small number if test messages for free after you register.  

Clickatell allows you to send a small number of test messages for free after you register but sends a preformatted SMS until you pay $.
To sign up:

After signing up, go to: https://www.clickatell.com/central/manage_products.php and select "SMTP" from the "Add Connection" drop down. Click "Submit and Get API ID". The API ID is needed when configuring OpenVPMS.
 

Other gateways can be added, with some knowledge of the gateway message format requirements and xpath expressions.
 

Configuring SMS

1. reload archetypes to pick up the new SMS configuration archetypes.
2. create an SMS configuration for the SMS provider

To create a configuration for SMSGlobal:

  • go to Administration -> Organisation and select New -> SMS Configuration: SMSGlobal Email2SMS.
  • Populate the Country Prefix and Area Prefix as required (e.g, 61 and 0 for Australia).
  • Enter the From address. This must be the same as that entered in the Email to SMS settings in the Preferences page at https://www.smsglobal.com/mobileworks/preferences.php

To create a configuration for Clickatell:

  • go to Administration -> Organisation and select New -> SMS Configuration: Clickatell SMTP Connection
  • Populate the Country Prefix and Area Prefix as required (e.g, 61 and 0 for Australia).
  • Enter the User and Password. These are the same as those used to sign in to the Clickatell website
  • Enter the API ID. Set this to be that of the API ID obtained as described above.
  • Enter a valid From email address.
  • Optionally enter a Reply To email address. If specified, responses from the gateway will be sent here.

3. link the SMS configuration to the practice:

  • edit the Practice in Administration -> Organisation
  • select the SMS tab
  • select the followed by the SMS configuration created above

4. optionally configure the mail server:

  • edit the Practice Location(s) in Administration -> Organisation
  • enter the Mail Host, Mail Port, Mail Username and Mail Password as required

 

Sending SMS messages

SMS messages can be sent to any customer that has a Phone Number Contact with "Allow SMS" ticked.
SMS messages can be sent by clicking the Send SMS button in the Customer Summary. If a customer has multiple phones, the preferred one will be pre-selected in a dropdown. Alternatively, the Send SMS button in the customer's Phone Number contact can be used to send a message.
For this release, only messages up to 160 characters may be sent.

A description of the implementation can be found in the JIRA:
http://jira.openvpms.org/jira/browse/OVPMS-902?focusedCommentId=12531&pa...
This includes instructions for adding support for other SMS gateways.

A description of the Clickatell SMTP API can be found at http://www.clickatell.com/downloads/smtp/Clickatell_SMTP.pdf

A description of the SMSGlobal SMTP API can be found at http://www.smsglobal.com/docs/Email-2-SMS.pdf

‹ [OpenVPMS Developers] [JIRA] (OVPMS-1104) StackOverflowError when changing clinicians during invoice editing [OpenVPMS Developers] Need for QuickBooks or similar ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: SMS support

Submitted by Matt Young on Wed, 12/10/2011 - 22:08.

Hi Tim,

It works really quickly with SMSglobal and was quite easy to setup. It would be really handy to have a script to look for mobile numbers and set the "Allow SMS" to true for all of them. There are alot of retrospective entries that do not have that option selected. 

Matt Y. 

Re: SMS support

Submitted by tanderson on Thu, 13/10/2011 - 08:28.

Thanks for trying it out. I'll look at providing a script in the next few days.

One aspect of SMSGlobal email gateway is that its not particularly secure. If you know the From email address configured in the SMSGlobal account preferences, you can send SMS messages to anyone. It may be a good idea to use a From email address created solely for the purposes of sending SMS messages.

-Tim

Re: SMS support

Submitted by tanderson on Thu, 13/10/2011 - 19:53.

The following should do it. Note that it will set the sms flag for any phone number beginning with "04" which is the mobile area prefix in Australia.

-Tim

 insert into contact_details (contact_id, name, type, value)
select c.contact_id, "sms", "boolean", "false"
from contacts c
join contact_details d
    on c.contact_id = d.contact_id and c.arch_short_name = "contact.phoneNumber" and d.name = "telephoneNumber"
left join contact_details s
    on c.contact_id = s.contact_id and s.name = "sms"
where s.value is null;

update contacts c, contact_details d, contact_details s
set s.value = "true"
where c.contact_id = d.contact_id and d.name = "telephoneNumber" and d.value like "04%"
    and c.contact_id = s.contact_id and s.name = "sms" and s.value = "false"
    and c.arch_short_name = "contact.phoneNumber";

Re: SMS support

Submitted by Matt Young on Thu, 13/10/2011 - 21:35.

Thanks Tim,

It worked perfectly.

Matt.

Re: SMS support

Submitted by ppvs on Wed, 25/01/2012 - 12:18.

Hi,

I have followed the steps for setup per the newest post from Tony.

I am getting the attached error message so I guess I am missing something? Maybe an implementor??

SMS-0202: Mail server connection failed: Could not connect to SMTP host: localhost, port: 25;
nested exception is:
java.net.ConnectException: Connection refused: connect
 
 

Would it be correct that I would need to add the settings below and where would I find these?

4. optionally configure the mail server:

  • edit the Practice Location(s) in Administration -> Organisation
  • enter the Mail Host, Mail Port, Mail Username and Mail Password as required

Thanks Bernie

Syndicate content