Merging Data to Data Historian

You can import historical data into GENESIS using the Data Historian Importer. Typical Data Historian logging uses real-time data subscriptions to capture and store data, but the importer allows users to configure triggered events to import data from other sources, most commonly .csv files.

Plugins

Data Historian Importer uses plugins that interface with a specific data protocol and convert data of that type for inclusion into Data Historian logs. Each plugin includes customization settings for configuring the corresponding type of data ingestion. GENESIS installs Data Historian Importer with plugins to support standard .csv files, Edgecross Output .csv files, and to access data from a MELSEC data logger. Furthermore, you can create your own custom plugins that the Data Historian Importer can use to import data from other formats of your choice.

Data Historian Importer is configured as a combination of a plugin, along with the appropriate plugin-specific settings, and a trigger that specifies when the import is initiated. The imported data can be accessed via the Data Historian interfaces, requested by clients, and used in calculations.

Data Format

Data Historian Importer requires data in a specific format. An individual data sample must be comprised of a tag name, timestamp, value, and quality. Data Historian uses these pieces of information to properly organize and store the data after the import.

To successfully merge historical data into GENESIS from a .csv file, you must perform the following tasks.

• Configure Data Historian Importer and the related settings in Workbench. Learn more
• Create a .csv file containing the desired historical data. Learn more
• Import the data file to Data Historian. Learn more
• (Optional) Set up the reporting options for Data Historian Importer. Learn more