Category Archives: Training

Rotronic Monitoring System integration. Pulling data into your systems

Data Integration is Key

Data integration is one of the primary requirements for many of our customers. I have previously discussed how RMS easily supports the integration of external data, but this posts takes a look at how RMS allows you the export data.

https___www.rotronic.com_media_events_images_1495454818_RMS_ML_GW

Of course RMS provides excellent graphing, statics and reporting as part of its core functionality, however here we are discussing the tools that will more likely be used for Machine to Machine (M2M) integration.

m2m

Machine to Machine (M2M) integration is absolutely key as data is increasingly being used for different purposes through businesses. So whilst RMS provides a highly secure and configurable platform for monitoring and alarming there are many weird and wonderful functions that it cannot provide. In this case we need to pull the data out and use it elsewhere.

Getting Data out of RMS

RMS is an SQL based system so we could of course query the SQL directly however there are many limitations with this approach especially security. Also via our RMS cloud platform absolutely no direct SQL access is available to end users.

Instead RMS supports a RESTful API, we’ll use a simple example to go through the basic steps.

RMS GET API

As before I’ll use some Python scripts in this example but if you prefer, POSTMAN is a great tool for testing these types of APIs.

Let’s breakdown the steps.

  1. Request API token using your username and password
  2. Use Token to request specific data
  3. Use data as required

Step 1 – Request a Token.

For security reasons you cannot simply send a request and get whatever data you desire. First you must request a token from RMS. The token is linked to a user account and will only allow the data that is visible by that user to be accessed. When requesting a token you can also specify how long it is valid for. The maximum length is 30 days.

import json
import requests

url = ‘https://rms.rotronic.com/RMS/API/RequestToken.ashx’
headers = {‘Content-Type’ : ‘Application/json’, ‘Expect’ : ‘100-continue’, ‘Connnection’ : ‘Close’, ‘Host’ : ‘rms.rotronic.com’}

UsrID = “1”
User= “Jeremy”
PW = “########”
Exp = “30”

get_payload = {‘UserId’:UsrID,’Username’:User,’Password’:PW,’RequestType’:’ DataHistory’,’ExpirationDays’: Exp}
api_get = requests.post(url, headers=headers, data =json.dumps (get_payload))
token = json.loads(api_get.content)
token = token.get(‘Token’)

The above request with suitable credentials will return something along these lines.

{‘UserId’: 1, ‘RequestType’: ‘DataHistory’, ‘Token’: ‘jUsTaNeXaMpLe_HRwOi8vd3d3LnczLm9yZy8yMDAxLzA0L3htbGRzaWctbW9yZSNobWFjLXNoYTI1NiIsInR5cCI6IkpXVCJ9.eyJVc2VySWQiOjM5MzEsIlJlcXVlc3RUeXBlIjoiRGF0YUhpc3RvcnkiLCJFeHBpcmF0aW9uIjoiMjAxOS0wNC0wM1QxNToyMzoyMC44MTgwODM4WiJ9.rtHHKvrE-7jnMNHUGazso_jUsTaNeXaMpLe’, ‘Status’: ‘OK’}

The API token being the jumble of text above. With the token in hand we can proceed with requesting our data.

Step 2 – Request Data

To request data we need the measuring point ID for the data we need which can be obtained from the RMS interface (every measured parameter has a unique ID within RMS that will not change and cannot be reused). We also define the From and To ranges as well as the number of values we wish to obtain (Count).

import json
import requests

url = ‘https://rms.rotronic.com/RMS/API/DataHistory.ashx’
headers = {‘Content-Type’ : ‘Application/json’, ‘Expect’ : ‘100-continue’, ‘Connnection’ : ‘Close’, ‘Host’ : ‘rms.rotronic.com’}

MPTID = “20”
From = “2019-03-04T08:00:00”
To = “2019-03-04T09:00:00”
Count = “10”
Token = “token from step 1”

post_payload = {‘ID’: MPTID,’From’: From,’To’:To,’Count’:Count,’Order’:’Asc’,’Token’: Token}
api_get = requests.post(url, headers=headers, data =json.dumps (post_payload))
data = json.loads(api_get.content)
print (data)

The above request with suitable details will return something along these lines.

{‘Status’: ‘OK’, ‘ID’: 20, ‘Name’: ‘Humidity-18071604′, ‘Parameter’: ‘Humidity‘, ‘Unit’: ‘%rh‘, ‘Data’: [{‘Time’: ‘2019-03-04T08:00:14+01:00′, ‘Value’: ‘29.45%rh‘}, {‘Time’: ‘2019-03-04T08:05:14+01:00’, ‘Value’: ‘29.80%rh’}, {‘Time’: ‘2019-03-04T08:10:14+01:00’, ‘Value’: ‘29.61%rh’}, {‘Time’: ‘2019-03-04T08:15:14+01:00’, ‘Value’: ‘29.29%rh’}, {‘Time’: ‘2019-03-04T08:20:14+01:00’, ‘Value’: ‘29.80%rh’}]}

Step 3 – Use the data

So we have our data in JSON format from here it’s an easy step to chopping out the specific values and handing them over to some other code, machine or simply displaying them for yourself.

The flexibility of RMS is an important requirement for our customers especially those with existing systems. Using RMS as the central platform ensures precision measurements, secure and reliable data collection and easy access to data. Using our  APIs then allows this data to be utilised in wider business operations.

integration examples

Customer examples using the API include

  • Live temperature data included in packaging labels
  • Automated calibration certificate generation using reference values from RMS
  • Visualisation of RMS data on 3rd party software for building efficiency displays

Conclusion

This article focuses on our RESTful API however we have many other options for integration of data including relay output modules, analogue output modules, direct SQL connection. In addition our RMS-Integrator hardware offers direct communication with devices via MODBUS, SNMP and MySQL.

So the message is simple; if you have requirements RMS can usually deliver what you need. Please contact us and we will be happy to discuss your project be it large or small.

Dr Jeremy Wingate
Rotronic UK

What is the latest monitoring system from Rotronic? A practical answer and a technical answer.

The Rotronic Monitoring System (RMS) has now been officially launched globally for 12 months and in use at some key clients for over two years.

RMS is a modern continuous monitoring system that embraces open architecture and interoperability as well as providing a compliant system for validated applications.

But how is this achieved and what exactly is RMS. There are two ways I find myself answering this…

  • The technical answer – for IT project managers, system integrators and cyber security managers.
  • The practical answer – for end users, project managers and smaller organisations.

What is RMS – The Practical Answer…

The practical answer is more visible via our online demonstration (request guest access here) and via the details on our RMS satellite website.

In short RMS provides a modern and complete monitoring system with a detailed web interface. The system provides users with ease of access to data, reliable and manageable alarms and extensive reporting. Importantly RMS can support existing hardware and interact with other software/hardware platforms.

RMS can be provided as a hosted cloud service or using a traditional licence whereby the client installs the system on their servers (local or cloud).

In summary RMS provides amongst other things…

  • Live interactive charts
  • Full reporting and automated/scheduled report generation
  • Complete event logging in line with GxP requirements
  • Full alarming with logic and time schedules
  • Email, phone, sms, relay and custom protocol alarm outputs
  • Auto back fill and retrospective alarms (ideal for transport logging)
  • Interactive layouts
  • Complete user rights management
  • Compliant to GxP designed around ease of validation

This slideshow requires JavaScript.

Core RMS hardware includes Ethernet, WiFi, industrial wireless and RS485 devices as well as full support for existing Rotronic devices, 3rd party analogue devices and 3rd party digital devices using any of the above interfaces. The below graphic outlines the wide range of options available.

06 RMS Graphic

Contact us for further information or visit our website

What is RMS – The Technical Answer…

Let’s now go a bit deeper. For many organisations once end-users approve of a system the challenge is getting the system approved and installed in line with wider corporate policies and security. So far we have found that in discussions with IT project managers and cyber security managers, RMS has met their requirements – usually much to the surprise of the end users who perhaps initially expect a protracted battle! Typically for larger more secure organisations software is required to be installed within their network rather than using the Rotronic Cloud service. Below we discuss the main elements of this type of RMS installation.

RMS has two core elements.

1. Webservice; This is software aspect of RMS. The webservice provides the interactive webpage to present data for end users and allow system configuration. The webservice also works in the background to interact with hardware and the database. Typically the webpage will be part of the local intranet with an address like rms.yourorganisation.com, optionally the webpage can also be made accessible from the internet outside your organisation (like our cloud service which is available at http://rms.rotronic.com/rms – request guest access to the demo system here). For the clients (end users) no special software or plugins are required just a standard web-browser.

More technically the RMS webservice is built around ASP.Net framework and runs under Windows IIS (internet information services). The webservice therefore requires a Windows Server (2008, 2012 or 2016). The RMS software can be run on a standard PC with IIS enabled but this is not usually advised except for specific applications.

A note on RMS hardware; All Rotronic hardware initiates communication with the webservice via port 80. For cloud applications this means only port 80 must be opened outbound to allow the devices to initiate outbound communications to the server. All gateways have standard IP configurations (DHCP or fixed).

2. SQL Database; The second part of the RMS is its database. All device, configuration, user and measured data is stored within a standard MS-SQL database. The database is accessed by the webservice to store and read data as required. An existing SQL server can be used if available otherwise SQL-Express is free to install.

More technically the RMS database requires Microsoft-SQL Express or higher, the database can be on the same server as the webservice or a separate machine.

As RMS is built around standard server based systems, there is full support for load balancing and failover, as such should a webserver or sql server fail a redundant/spare can take over. This is standard procedure for larger IT systems.

Some other technical points about RMS.

  • Supports LDAP (so you can use windows login and password)
  • No personal data stored outside SQL database (hardware only stores unique serial code, date, time and measured values – as such no private data passes between hardware and software).
  • Webpage data is binary coded and authentication uses AES128 encryption.
  • Key exchange uses diffie-hellman key alogrithm.
  • 3rd party data / device support is possible via RESTful API or direct interaction with SQL database.

An overview of the RMS communication can be seen here.

08 RMS Communication

For many projects clearly we go much deeper but hopefully this provides an overview. Our experience to date has shown that RMS is closely inline with what our clients expect in terms of operations and security. Further developments are always underway, lead by our customers and their requirements.

Please contact us if you wish to discuss a project or gather further information.

Dr Jeremy Wingate
Rotronic UK

Rotronic training course schedule 2016

We are pleased to announce our latest training course schedule for 2016. Courses include in partnership with Dave Ayres from Benrhos Ltd our practical 3 day temperature, humidity and dew point calibration and measurement uncertainty courses. In addition, for those seeking greater depth we are running dedicated courses on measurement uncertainty and ISO 17025 run by Lawrie Cronin and Dave Ayres

Temperature Humidity and Dew Point – Measurement, Calibration and Uncertainty

8th – 10th March :: 12th – 14th July :: 15th – 17th November
– Three day course at Rotronic UK offices and UKAS laboratory
– Practical applied knowledge and best practice
– Max 8 attendees to ensuring tailored content

Measurement Uncertainty for Laboratories and Plant

6th – 7th September
– Two day course at Rotronic UK offices
– Detailed knowledge for laboratory owners or process managers

Setting up and working with ISO17025

8th September
– One day course at Rotronic UK offices
– Ideal for ISO17025 lab managers or those looking to apply

For further information please do not hesitate to contact us.

 

Highlights from the Rotronic ISM 2014

A fantastic view of the Swiss mountains complimented an exciting glimpse of the future at the Rotronic International Sales Meeting 2014 in the Swiss mountain village of Grindelwald.

P1060869

The biennial Rotronic ISM brings together distributors and subsidiaries from the global Rotronic network (or family as it feels when we are all together!).

The week long meeting provides an invaluable opportunity to share experiences, projects, new ideas and product updates along with the showing off latest developments and future trends for the company. Aside from the formal workshops, training courses and meetings is the opportunity to informally explore new ventures and insights from around the world – as well as sharing a beer or two of course.

Italy and China!
Italy and China!

The growing range of new product launches from the Swiss HQ, combined with further developments from the UK’s R&D group based around the HygroGen technology highlights that the outlook for the next two years will be very interesting! (check out our new Hygrogen and AwTherm specific satellite sites www.hygrogen.com)

 

The last day of the meeting ensured everyone forgot about instruments for a while as we made our way out into the mountains. Mixed groups were pitched against each other in a fairly weird and wonderful mix of traditional team alpine games including Alphorn blowing and milk chair shuffling (best not to ask)!! Competition was tight but fun had by all.

Alpine games
Alpine games

It was all wrapped up with a fantastic outdoor bbq and the Rotronic awards – the UK team getting an award for the best CO2 product sales performance over the past two years!

P1060889

The ISM are important to maintain open communication and share knowledge. Combined with a delicate mix of hard work, fun and fantastic enthusiasm from all the those attending ensures that once again the ISM was a great success!

Team UK
Team UK

Several important announcements were made about new products and future developments including…

  • New ATEX Range (launches very soon!) 
  • Heated HygroMet Probe (now available!)
  • Two new videos coming soon (CO2 measurement and humidity overview)! 

In addition we were given a glimpse of the future… Rotronic UK unveiled the latest HygroGen2 features and the HG2’s bigger brother, the HygroGen2-XL.

New toys!
New toys!

Rotronic AG introduced a new ASIC for the Hygroclip probe range improving reliability and quality without affecting compatibility.

Beyond this there were several very exciting new product ranges on the horizon but these are still under wraps for now… watch this space 🙂

Rotronic International Sales Meeting 2014 Grindelwald Photo Gallery

Great to see everyone at the 2014 ISM in Grindelwald!

New training course dates! – Temperature and Humidity Measurement and Calibration Training.

Following the continued success of our training courses we have several new dates for October this year!

These courses are aimed at providing excellent theoretical and practical knowledge useful both for those new to the field or those looking to expand their knowledge.

Details and booking information can be found via the below links.

7th – 8th October 2014 :: Two Day Temperature Measurement and Calibration

9th October 2014 :: One Day Humidity Measurement and Calibration

Courses will be hosted by our partner Benrhos Limited in Wales and delivered by Dave Ayres (Benrhos) and Jeremy Wingate (Rotronic).

These excellent value courses are open to a maximum of 8 delegates ensuring course content can be targeted specifically to your needs.

Details and booking information can be found via the below links.

7th – 8th October 2014 :: Two Day Temperature Measurement and Calibration

9th October 2014 :: One Day Humidity Measurement and Calibration

Key areas covered include;
  • Knowledge that is not available from other sources.
  • Terminology and units.
  • Fundamentals of each parameter.
  • Best practice measurement.
  • Calibration methodologies.
  • How to interpret results and spot common errors.
  • Measurement uncertainty.
  • How to use uncertainty budgets and benefit from them.
  • Common instrument types and their advantages/disadvantages.

Any queries please do not hesitate to contact us.

Dr Jeremy Wingate
Rotronic UK