Log groov data to Excel

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)

Log _groov_ data to Excel

Use Access and Excel to get data from groov

If you want to use Microsoft® Access® or Excel® to analyze data in a groov Data Store, these code samples are for you.

Sharing groov data with Access and Sharing groov data with Excel are the newest code samples in our library.

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:

Subscribe and Publish with MQTT Nodes, groov & SNAP PAC

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.

Create a Weather App with groov and Node-RED

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.

Using SNAP PAC REST API with Excel Code Sample

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 0.17.4 released for GROOV-AR1

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.

New Node-RED Example

We’ve posted a new Node-RED example that shows how to read and write to G4 digital I/O.

Read-Write Flow

You can use this example even if you don’t have Opto 22’s Digital I/O Carrier Board for Raspberry Pi® or Digitial I/O for Raspberry Pi Starter Kit (AC/DC) (but who would want to?)

We’ve also redesigned the code sample pages for use with Raspberry Pi—check it out!

Node-RED Examples

Check out our new Node-RED examples:

groov Data Store REST API Released

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.

For more information, see the new groov REST API section. For more on groov, visit groov.com

OptoBlog: Build a Raspberry Pi with Node-RED and Industrial GPIO

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.

RSS Subscribe


See more posts from the News Archive.