How to Log Sparkplug B Data to a CSV or Excel File
In this tutorial, you will learn how to use Open Automation Software to collect data from Sparkplug B Edge of Network Nodes and save it to a CSV file. With this, you can easily view the data using Microsoft Excel. The tutorial will guide you through the process of downloading and installing OAS, setting up a Sparkplug B Host Application interface, configuring tags for the EoN NBIRTH and DBIRTH messages, and logging the Metric values to a CSV or Excel file.
Step 1. Download and Install the Open Automation Software and Start the OAS Service
If you have not already done so, you will need to download and install the OAS platform. Fully functional trial versions of the software are available for Windows, Windows IoT Core, Linux, Raspberry Pi and Docker on our downloads page.
On Windows run the downloaded Setup.exe file to install one or more of the Open Automation Software features. Select the default Typical installation if you are not sure what features to use or the Custom installation if you want to save disk space on the target system. When prompted agree to the End User License Agreement to continue the installation.
For more detailed instructions and video tutorials, visit the installation guide for your system:
Windows Installation | Linux Installation | Raspberry Pi Installation | Dockers Installation
When the installation is finished the OAS Service Control application will appear. Use this application to start the 4 Services. If this is the first time installing the software it will automatically enter Runtime with an example Tag Configuration.
Step 2. Set Up Sparkplug B Host App to Access EoN Node Data.
Select Configure-Drivers.
Enter a meaningful Driver Interface Name that you will refer to this connection and define the properties.
Set the driver to Sparkplug B.
Enter the Host property to the IP Address of the of the host broker or just use localhost for a local broker.
Set the Port property of the host broker to connect to. The default port is 1883 or 8883 for SSL.
Note: The OAS MQTT Broker can be used to host data locally. To use another broker on the default ports on the same computer change the OAS MQTT Broker Port under Configure-Options-MQTT Broker.
Enter the User Name and Password if required.
Set the MQTT Protocol Version to V311 or V500.
Set the Client ID to a unique value, each driver interface must have a specific value different than all other clients connecting to the host.
Set the Mode to Host App for OAS to control the online state of each Edge of Node defined to the shared Host Application ID. Or set to Client App to access EoN Node data without controlling their state.
Set the Host ID to the specific value that the Edge of Nodes will be using as the Host Application ID.
Set the Sparkplug B Version to 2.2 or 3.0.
To automatically add tags for each Metric from the matching Group, Edge of Nodes, and Devices enable the property Add Client Tags Automatically.
When enabled optionally set the Filter Groups, Edge Nodes, and Devices that tags should be added from for each of their Metrics. Leave the Filter fields blank to include all Edge of Nodes publishing data to the broker.
Select the Add Driver button in the left part of the form to add the Driver Interface as an available selection when defining Tags in the next step.
You are now ready to add tags for specific Sparkplug B EoN Node Metric values.
Note: If the Driver Interface property Add Client Tags Automatically was enabled tags will be created for you, you can skip this step to add tags manually.
Select Configure-Tags.
Note: You can add organizational Groups as many levels deep as you prefer and add tags to groups. To do this first add a Group to Tags Group at the root level, then right click on the Group in the right window to add additional Groups or Tags.
Select Add Tag.
Change the Data Source Tag property to Sparkplug B.
Select the correct Driver Interface from the Driver Interface pull down list.
Specify the Client Group ID, Client Edge Node ID, Client Device ID, and Client Metric Name for the Edge of Node Metric value to read and write.
Select the Data Type of the Tag to match the data type of the Metric.
Select Apply Changes and the current value for the Metric should appear with Good Quality.
Select the Save button from the toolbar to save your configuration.
You can view the Getting Started with Sparkplug B Video to familiarize yourself with the above steps to setup OAS as a Sparkplug B Edge of Network Node and a Host Application
- 00:00 – Introduction
- 01:10 – Download OAS
- 01:46 – Quick Start
- 02:08 – Edge of Network Node
- 05:52 – EoN Tags
- 07:04 – Host Application
- 09:20 – SpB Client Tags
- 10:22 – Programatic Interface
- 10:59 – CSV Export / Import
- 12:27 – Multiple Metric Tags
- 13:46 – Modbus
- 16:10 – DCMD Metric Write
- 17:00 – Data Route
- 17:58 – Networking
- 18:17 – Save Configuration
- 18:56 – OAS Platform
Step 3. Configure Data Logging for CSV
- In the OAS Configure Application, select Configure >> Data Logging from the top menu.
- Select localhost or the remote service you wish to log data from with the Select button to the right of the Network Node list.
- A Logging Group screen will appear.
- Give your Logging Group a name that is meaningful to you.
- In the Common tab, you will determine your table format and type of logging you wish to implement.
- In the Tags tab, you will select the tags you wish to log.
- If you want to log to a database such as SQL Server, use the Database tab.
- To log to CSV, use the CVS Logging tab.
- Specify the Path where you would like your file to be created.
- Enter a file name in the File Name field.
- Once you have all of the tabs configured, click Add Group in the left panel to add your logging group to the service.
For more detailed instructions on Configuring Data Logging, visit our Getting Started Data Logging tutorial or watch the video tutorial below:
- 00:00 – Introduction
- 01:30 – Getting Started
- 03:00 – Continuous Logging
- 04:15 – SQL Server
- 06:25 – Save Changes
- 07:00 – Continuous Narrow Logging
- 09:30 – Event Driven
- 11:20 – Handshake Confirmation
- 12:45 – High Speed Logging
- 15:00 – Log to Stored Procedure
- 15:25 – Triggers
- 16:30 – Event Narrow Logging
- 18:00 – Timestamps
- 20:30 – Snapshot Logging
- 21:45 – Specific Time of Day Logging
- 22:50 – Data Change Row Logging
- 25:15 – Data Change Narrow Logging
- 26:45 – Networking
- 31:55 – Store and Forward
- 37:30 – Disable Store and Forward
- 40:15 – Update Records
- 40:50 – Dynamic Server, Database, and Table
- 41:10 – Automatic Deletion
- 41:40 – CSV File Logging
- 45:30 – Programmatic Interface
- 46:45 – CSV Export / Import
- 48:20 – One Click Automation
- 52:20 – Transaction Logging
- 54:25 – System Errors
- 56:00 – Contact Us
- 56:50 – Read Database Data