This fast and easy sample lets you log data from groov to a Microsoft® Excel® worksheet.
If you’re comfortable using groov, you can get set up and start logging sample data to Excel in five minutes or less.
And with the Visual Basic for Applications® (VBA) code in the workbook, you can create your own spreadsheet to log real-time data from your company’s production systems.
Get the download file here: Logging groov data to an Excel Worksheet (http://www.opto22.com/site/downloads/dl_drilldown.aspx?aid=4633)
If you want to use Microsoft® Access® or Excel® to analyze data in a groov Data Store, these code samples are for you.
But these samples are more than “learning activities”—they include a fully-functional Access database file and Excel workbook that you can use practically out-of-the-box.
Just enter your groov Box’s Hostname and API key in the sample file, and immediately you can start accessing the data in your groov Data Stores.
Then, look under the covers at the VBA code in each sample to kickstart writing your own custom applications with Access and Excel.
You can download the code samples and instructions from the Opto 22 Downloads webpage:
- Sharing groov data with Access: http://www.opto22.com/site/downloads/dl_drilldown.aspx?aid=4633
- Sharing groov data with Excel: http://www.opto22.com/site/downloads/dl_drilldown.aspx?aid=4634
Curious to know how to access your industrial data over MQTT?
If so, check out Subscribe and Publish with MQTT Nodes, groov & SNAP PAC, our newest step-by-step OptoTutorial.
In it, you’ll learn how to:
- Use Node-RED to subscribe and publish to an MQTT message stream
- Parse message strings
- Use groov to display data from a message
- Push data from groov and from a SNAP PAC controller to a message stream
For most of the activities, all you need are a groov Box running groov R3.3 or higher, and a few minutes to work through the examples.
The tutorial is available at http://www.opto22.com/site/documents/doc_drilldown.aspx?aid=4632.
Our newest Quick Start Guide—Create a Weather App with groov and Node-RED—will help you quickly develop a fully-functioning weather reporting application with minimal effort. You don’t even need to know groov; this tutorial walks you through each step from beginning to end.
The tutorial’s zip file contains code for a groov page prebuilt with gadgets to display weather data. It also contains code for Node-RED flows that get, package, and send data from the Weather Underground API to groov.
The tutorial’s download file is available at http://www.opto22.com/site/downloads/dl_drilldown.aspx?aid=4629.
A new OptoTutorial—Using the SNAP PAC REST API with Excel— helps you create a macro-enabled Microsoft Excel® worksheet that reads, writes, and charts values from a SNAP PAC R- or S-series controller.
One of the sample workbooks in the tutorial—Opto22_ReadingWritingSamples.xlsm—can be used as a development tool to generate API commands for your own custom code.
The tutorial’s download file is available at http://www.opto22.com/site/downloads/dl_drilldown.aspx?aid=4627.
Node-RED for groov Box (GROOV-AR1) has been updated to include the recently released 0.17.4 version of Node-RED. It includes a better Debug panel, improved JSON editing, changes to Split and Join nodes, the ability to disable a node, and more.
For more information, please see:
To update a groov Box, visit manage.groov.com and download the R4 update for Node-RED. The README there has instructions on how to apply the update.
We’ve posted a new Node-RED example that shows how to read and write to G4 digital I/O.
We’ve also redesigned the code sample pages for use with Raspberry Pi—check it out!
Check out our new Node-RED examples:
- Get WAN IP Address—A one-step method to get a controller’s WAN IP address and write it to a tag in PAC Control
- Using Conditions in a Flow (Switch Node)—An interactive example that uses a switch node to turn a lamp off and on
groov mobile operator interface users can monitor and control all kinds of sensors and equipment in the physical world. Now they can also interact with data from an online service, a database, or another software application.
The data is held in a groov Data Store, and the groov Data Store RESTful API gives you access to it.
Need help building a Node-RED app that uses a headless Raspberry Pi connected to industrial digital I/O?
Check out Benson H’s latest OptoBlog for step-by-step instructions.
See more posts from the News Archive.