Big Data Wizard (EN)

Owned by Lango: Language and translation manager
Last updated: Aug 08, 2024Version comment
2 min read

The Big Data Wizard extension is an application that creates a new table in the "Alarms" database that contains full name information of tags and statuses (in text) of these tags, where applicable.

This new table can be used by more efficient methods of exports and other necessary operations that use a large volume of data.

 

Prerequisites

These are the current prerequisites for using the extension:

  • Use of Action.Net 8.1 or higher;

  • Have Enums registered in the project in "Run → Dictionaries → EnumerationSets" with the desired tag states;

  • Have at least one tag registered with some "Enum" in its "Parameters" column; and

  • Have a database configured for the "AlarmHistorian" line in "Edit → Datasets → DBs".

Step-by-step import

Running the importer

The Big Data Wizard extension can be accessed along with the other extensions in the "Run → Extensions → Import" section.

Big Data Wizard extension in "Run → Extensions → Import"

The extension does not present any options to select. The only possible operation is to run the Wizard from the "Create" button.

After running, click "Ok" to close the window.

Big Data Wizard Extension Window

Import result

After the extension is executed, the "TagDicValues" table is created in the "Alarms" table database. This table contains three columns, namely:

  • TagName - Representing the name of the tag;

  • TagValue - Containing the value of the tag to which the state is associated; and

  • TagValueAsString - Containing the Tag State (in text) for the associated TagValue.

 

 

On this page: