Page Comparison

Is Excel alike dealing with sensorEDGE's aggregated IO-Link sensor data - as the real-time processing platform e.g. 'Streamsheets' is offering supporting it - possible?

Yes this is possible since the sensorEDGE solution is providing the IO-Link-sensor data on MQTT over an Internet hosted MQTT broker.

STEP 1:

For a simple test sign up for a trial playground account under https://cedalo.com/pro-streamsheets/trial-signup/ and confirm your email address.

Image RemovedImage Added

STEP 2:

You will be receiving another email including your personal cloud hosted Streamsheets Pro URL and username and password. Use the given credentials to login.

STEP 3:

Create a new Streamsheets App in your workspace by clicking the "+" in the top right corner. Give the app a name. Using a template is not necessary.

Image RemovedImage Added

STEP 4:

Create a new connection of type MQTT by clicking the icon  and the "+" and then on "MQTT"

Image RemovedImage Added

STEP 5:

a. Watch your personal "sensorEDGE data service credentials" page in on your www.sensoredge.io account.

Image RemovedImage Added

b. Copy and paste the information Username/Password/Endpoint URL from the page into the Streamsheets MQTT "Settings" form. Uncheck the "Validate CA Certificate" checkbox!

Image Modified

d. Watch the MQTT light turning green if there is a connection successfully established

Image Added

d. Click the Streamsheets MQTT "Subscriptions" tab .as next

Image RemovedImage Added

e. Click the "+" and copy and paste the base topic into the Topic row Base Topic value of exactly that sensorEDGE device in your list of sensorEDGE devices you want to subscribe to to receive data . Makr from into the column Topic. Make sure the topic name value ends with a hash "#".

Image Added

STEP 6:

Start your Streamsheets sheet by clicking the play button

Image Added

STEP 7:

Watch the JSON coded payload of the incoming messages in the payload window to the left (update rate depends on your configured sensorEDGE data update rate)

Image Added

STEP 8:

a. Draw a line chart on your sheet using the icon Image Added

Image Added

b. From the payload window drag and drop any value you want to monitor to your sheet. The example shows the object "Temperature" and its value right next to it.

Image Added