The interface software transfers SCADA data from a narrow format OLEDB source to the Hach WIMS database. Data is read from the database, summarized based on user specifed options, and the summarized results are stored in the Hach WIMS database.
The interface has three basic components: a Collector (Q13072), an Interface (Q13073), and a Browser (Q13074). The
The Collector parses CSV files for tag names, a date/time stamp, and numeric values. Tag names are in columns 170 to 249 (as seen from Excel). The date/time stamp is in column 412, and the numeric values that correspond to the tag names are in columns 413 to 492. This allows for 79 tag names. If the collector encounters a row that does not go out to the value columns, the row is skipped. The first blank line in the CSV file signifies the end of the file.
The data is gathered and imported to a Hach SCADA data table that must have the following format (the table name is configurable to anything valid in MS SQL, here we use DATA):
The Interface is used for importing the numeric values from the Hach SCADA data table. The values are summarized based on the selected statistic and imported into a variable set up specifically for a particular tag name.
The Browser is used when defining and configuring variables in Hach WIMS, and its purpose is to look up tag names in the Hach SCADA data table. In order to do this, CSV files must have already been imported into the data table using the Collector.