How to Automatically Export Data from vNode to CSV

Created by Jose Fabian Solano, Modified on Wed, 3 Jul at 11:14 PM by Jose Fabian Solano

To enable vNode to export data to CSV, the first step is to create a new module called "Data Exporter" within the platform. This module is specifically designed to automatically extract data from vNode and generate CSV files. To begin, navigate to the vNode configuration menu and select "Module". From there, choose to create a new module and select "Data Exporter".

1. **Creating the Agent:**
- First, we proceed to create a new agent within vNode. You can assign it any name you prefer.
- During the initial setup of the agent, you'll be prompted to specify the storage path for the generated file. To facilitate this step, you can use the file explorer to select the desired folder and then copy the path provided by the explorer.

2. **Including Agent Name Options:**
- The next step in configuring the agent is deciding whether to include the agent's name in the generated file. This option can be enabled or disabled based on your preferences.

3. **Compression and File Naming Configuration:**
- Next, you'll select the compression type for the file: ZIP or no compression.
- Specify the desired filename for the generated file and choose the file type you wish to create, whether XML or CSV.

4. **Internal Scan Configuration:**
- In the "Internal Scan" section of the agent, set the scan interval to monitor the status of tags. It's recommended to set a short interval to keep monitoring up-to-date.

5. **File Format Selection:**
- Choose the file format that suits your needs:
- **Relative Path**: Includes only the tag name in the generated file.
- **Absolute Path**: Includes the complete path where the tag is located, including group names.

6. **Specific Settings for CSV Files:**
- For CSV files, select the separator to use among comma, period, slash, or semicolon.
- Also, choose the date format you prefer for the information included in the generated file. This customization allows you to structure and present the exported data from vNode according to your requirements.


Lastly, we need to set up the tag group that will be included in the CSV export. Here's a detailed breakdown of the steps involved:

1. **Create Tag Group:**
- First, define the specific tag group within vNode that you want to export to CSV. This group should contain all the tags whose data you wish to include in the CSV file.

2. **CSV File Naming:**
- Assign a unique and descriptive name for the CSV file that will be generated specifically for this group of data. This name will help identify and distinguish the file.

3. **Execution Period:**
- Specify the execution period, which determines how often the CSV file should be generated. This duration is measured in milliseconds and dictates the frequency at which vNode updates and exports the data to the CSV file.

4. **Method Type Selection:**
- Choose the method type that vNode will use for exporting data. By default, this is set to raw data. This method determines how the data is formatted and processed before being exported to the CSV file.

5. **Group Selection:**
- Select the tag group that you previously defined. This ensures that vNode knows which tags to include in the CSV export.

6. **Create Filter:**
- Create a filter within the selected tag group. This filter specifies the criteria or conditions that vNode will use to determine which internal items (tags) within the group should be included in the CSV export. Filters can be based on tag properties such as data type, quality, or specific tag names.

By following these detailed steps, you can effectively configure vNode to export selected tag data to a CSV file at specified intervals, ensuring that the exported data is organized and meets your specific requirements.



Now, you could go to the directory on Windows and check if the file has been created






Created by JF

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article