|
|
Available with GENESIS64 Basic SCADA. |
|
|
Available with GENESIS64 Basic SCADA. |
As an extension for the online documentation on this link:
https://docs.iconics.com/V10.97.1/GENESIS64/Help/Apps/WBDT/MergeWorX/MergeWorX_CSV_File_Formats.htm
Another CSV file format that MergeWorX supports is the file format created by a device that supports EdgeCross™ (https://www.edgecross.org/en/).
The CSV file consists of a header row followed by content rows. The first column is the timestamp that is equivalent for all adjacent columns. I.e. you can merge data for many HH tags that will get the same timestamp per row.
Also make sure you use the same column delimiter in your MergeWorX configuration as used in the CSV file.
Keep in mind that MergeWorX is intended for filling gaps or importing sporadic data into HH. Trying to import a year of data for 100 HH tags in one go, i.e. in one file, can take hours to complete. If you need to fill a large period of time, consider creating one file per month or so. 1600 rows of data for 100 tags per file can be handled better than 2 million rows for 100 tags in one file.
The CSV file content is in the form of:
Time,HH_tag1,HH_tag2,HH_tag3
yyyy-MM-dd HH:mm:ss.ffff, value1,vlaue2,value3
This is an example on how the content of the CSV file may look like:
Notice the timestamp is defied in ISO format (yyyy-MM-dd HH:mm:ss) if needed you can include milliseconds (… HH:mm:ss.ffff)
Also notice the HH tags are not enclosed in any quotes.
The column delimiter is a ‘;’.
Here the example in text form for 3 HH tags: (is an extraction of the picture before)
Time;hh:\Configuration\~AC\MT1\V000:Value;hh:\Configuration\~AC\MT1\V001:Value;hh:\Configuration\~AC\MT1\V002:Value
2022-04-01 00:00:00;180,300;238,021;195,449
2022-04-01 00:05:00;196,864;291,472;244,560
2022-04-01 00:10:00;211,606;278,360;266,641
2022-04-01 00:15:00;256,685;275,948;258,729
2022-04-01 00:20:00;245,425;253,772;203,932
2022-04-01 00:25:00;266,646;245,519;209,236
2022-04-01 00:30:00;242,091;212,217;256,435
2022-04-01 00:35:00;255,761;207,686;222,719
2022-04-01 00:40:00;268,762;285,859;249,156
2022-04-01 00:45:00;223,881;208,335;214,146
2022-04-01 00:50:00;196,578;239,150;182,206
2022-04-01 00:55:00;232,698;239,751;197,878