Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Send an SMS alert using NPrinting

cancel
Showing results for 
Search instead for 
Did you mean: 
richbyard
Contributor III
Contributor III

Send an SMS alert using NPrinting

Last Update:

Aug 4, 2022 6:24:11 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 19, 2017 9:56:19 AM

Attachments

So, how to send KPI results to a user by SMS rather than email so you can get a result like the one below. This could be used for daily or hourly status messages to Senior Execs, for operation direction to the salesforce or the distribution team, or for conditional based alerting when KPI results meet a certain criteria. There are so many use cases here... I've also added an example in Arabic (google translate version) to show right to left language capability in the SMS.

 

SMS Arabic image 2.jpg

 

It's actually reasonably simple but you do require a 3rd party SMS gateway to perform the translation of an email to an SMS. All telco operators offer these services, and a number of other web based operators too, and all work in much the same way as the example here.

 

 

Step 1 - Setup your SMS Gateway provider account

 

I have used TextMagic for this example as it's easy to work with and offers a free trial with some minimal credit for testing.

 

Other services that will work in a similar way (and may be cheaper)

 

 

Step 2 - Setup your NPrinting instance with the user to receive the SMS

 

Your SMS gateway provider will indicate the email format for the mobile number you wish to send the SMS to. For example, with TextMagic the format is 4470851234567@textmagic.com for the telephone number +44 7085 1234567 (a clearly made up number).

 

This is the email address to assign to the user in NPrinting. Note: It is likely that you will have 2 NPrinting user accounts for a single individual if they receive SMS alerts and other reports from NPrinting (hub, newstand, email attachments etc).

 

 

Step 3 - Create your HTML report (or import the one attached along with the example application)

 

The HTML report is very simple. It looks like this in the NPrinting Designer Editor window and is looking at Gauge objects as tables.

Capture.PNG

 

 

Step 4 - Setup your Publish Task

 

Go through the normal setup process.

  • Add the report you have created in step 3 (as HTML output)
  • Assign your users (the SMS user you wish to send to as per step 2)
  • Check that the destination for the user is email
  • In the email section use the tags to embed the report content (and perhaps the users name etc)
  • Add a trigger to schedule the report
  • Save the changes

Capture.PNG

 

 

Step 5 - run the publish task and receive the SMS

 

It's pretty easy eh!

 

 

 

Troubleshooting:

 

  • Ensure that your user is assigned to a role in NPrinting. If no role is assigned the email will not be sent.
  • Ensure the sending email address, as per the email message in step 4, is included in the TextMagic allowed emails
  • Ensure you have some credit left on TextMagic as this will stop things working too...
Labels (1)
Comments
sheikhjk
Explorer
Explorer

how to setup SMS Gateway Panel Please anyone Help me please...

richbyard
Contributor III
Contributor III

Hi, you'll need to check whether this particular gateway service has an email to SMS API service. That is the one that will work with NPrinting. Any other API calls will need to be made from the script using either the web or REST connectors.

venkat1
Creator II
Creator II

will it work for the  qlikview Nprinting?

Version history
Last update:
‎2022-08-04 06:24 AM
Updated by: