OptoNews: Latest groov code samples available now

Posted by Jean Femia on Oct 3, 2017 3:07:22 PM

Excel spreadsheet using groov Data Stores APIWhat if your operators could enter machine data on their phones and that data automatically appeared in a Microsoft® Excel® spreadsheet? 

What if production or usage data from your spreadsheet was automatically updated in your supervisor's groov mobile operator interface?

Could be pretty handy, right?

Well, we've got a couple of code samples to show you how to make it happen. 

One's really simple and easy; the other gets into more detail. Both use a groov Data Store and groov's RESTful API to move the data.

Simple: Logging groov data to Microsoft Excel

If you just want to move data from groov to Excel, this is the sample for you. Here's what you need:

The sample includes an Excel workbook that gets and logs groov data, a groov project with a pre-built Data Store, and instructions.

To use this sample, you should already be familiar with groov. If you run across anything you don't understand, check the groov Build & View User's Guide for help.

More detailed: Sharing groov data with Microsoft Excel

This sample is a little more complex, as it moves data in both directions. It uses Visual Basic for Applications® (VBA) to read and write to groov Data Stores via the RESTful API. It's a great example for anyone who wants to build their own custom applications with groov and Excel, because it explains the underlying code. 

For this sample you'll need the same things as the simple sample:

Included are an Excel workbook and worksheets. When you provide the address and API Key for your groov, the Visual Basic code will read the groov Data Stores and populate drop-down lists so you can select specific tags you want to use. 

Instructions show you how to use the sample and its underlying code in your own applications.

See all the code samples

We're building a library of code samples to help with your applications. Be sure to check out the samples in these locations:

Opto 22 Developer site - Code Samples: Includes samples for using both the groov and SNAP PAC controller RESTful APIs, and for using Node-RED with groov and PACs. You'll also find Raspberry Pi samples (a Pi with our industrial digital I/O can be an inexpensive option for prototypes and for locations that don't require industrially hardened equipment).

OptoForum - Code Samples & Tips: Here you'll find samples and tips for all Opto 22 products. 

See developer code samples

Exchange data between an Excel spreadsheet and a groov mobile operator interface

Topics: groov, Internet of Things, IoT, optonews, Integrators, API, REST API, REST, mobile, IIoT, Industrial Internet of Things

Written by Jean Femia

Jean Femia writes about technical subjects and has focused on automation and control systems for more than 15 years. She likes learning about technology and taking corners in her Honda S2000.
Find me on:

    Subscribe to Email Updates

    Recent Posts

    Posts by Topic

    see all