Use this screen to configure the connection to your GE Proficy Historian, choose the tags you want to export and choose what sampling modes you want to export into OPSDATAXML files.

• Data Source - this field specifies, in loose terms, the "Database/Datasource server name" where your GE Proficy iHistorian system is configured to store data.
  
• User ID and Password - these fields are only mandatory if the connection to the GE Proficy iHistorian system requires them. These fields should be blank if not used.
  

• Advanced Configuration - these permit adjustment of the command and connection timeout. Currently, these are ignored by the iHistorian OLE DB driver, but are put here to enable future enhancements.

• Connection Timeout in Seconds - how many seconds the program should wait when establishing a connection to the GE Proficy iHistorian server.
• Command Timeout in Seconds - specifies how many seconds the program should wait for a query to complete before aborting the operation.

Buttons:

Test to see if the connection settings are valid and the interface is able to connect to Hach WIMS. Does NOT Apply or Save the settings.

• Minutely Data Point to Collect - The collector exports Proficy Historian data into OPSDATAXML files that in turn get read into Hach WIMS by an interface. The OPSDATAXML file contains 1 hours worth of data for each tag that has been configured to export data. Each tag in the file contains 60 data points; one data point for each minute in an hour. When the collector collects these one minute samples of data, it needs to know which data point in the minutely period to grab (i.e. the first, last, maximum, minimum or average). This setting is applied to all tags; individual tags can not be configured differently (i.e. you can't configure one tag to select the first data point in a minutely period, and another the last data point in a minutely period.


•  Sampling Modes:

(The following is taken directly from GE Proficy Historian Electronic Books from Proficy Historian version 3.1.0.1760)

Sampling Mode is the mode of sampling from the archive. The following is supported sampling modes, their definition, and a sample of the query using the statistic AVERAGE for example:

SAMPLING MODE	DEFINITION	SQL QUERY
AVERAGE.INTERPOLATED	Retrieves evenly spaced interpolated values based on NumberOfSamples and the time frame criteria.	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = INTERPOLATED AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.RAWBYTIME	Retrieves raw archive values based on time frame criteria. NOTE: when selected, ROWCOUNT is set to zero (0) in order to retrieve all records for the Q11924 interface. WARNING: this sampling mode returns values for every second and will take significantly longer to process data.	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = RAWBYTIME AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440  AND RowCount = 0   AND Quality > 0 GROUP BY Quality
AVERAGE.RAWBYNUMBER	Retrieves raw archive values based on the StartTime criteria, the NumberOfSamples, and Direction criteria. Note the EndTime criteria is ignored for this Sampling mode.	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = RAWBYNUMBER AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440  and direction = backward   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED	Retrieves evenly spaced calculated values based on NumberOfSamples, the time frame criteria, and the CalculationMode criteria.	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = AVERAGE AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.LAB	Returns actual collected values without interpolation.	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = LAB AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'   AND Quality > 0 GROUP BY Quality
AVERAGE.TREND	Returns the raw minimum and raw maximum value for each specified interval. Use the Trend sampling mode to maximize performance when retrieving data points for plotting.	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = TREND AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality

• Calculation Mode - The CalculationMode column only applies if the SamplingMode is set to Calculated. It represents the type of calculation to perform on archive data. The following is supported calculation modes:

CALCULATION MODE	SQL QUERY
AVERAGE.CALCULATED.AVERAGE	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = AVERAGE AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.COUNT	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = COUNT AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.MAXIMUM	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = MAXIMUM AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.MINIMUM	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = MINIMUM AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.STANDARDDEVIATION	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = STANDARDDEVIATION AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.TOTAL	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = TOTAL AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.RAWAVERAGE	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = RAWAVERAGE AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.RAWSTANDARDDEVIATION	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = RAWSTANDARDDEVIATION AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.RAWTOTAL	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = RAWTOTAL AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality
AVERAGE.CALCULATED.TIMEGOOD	select Avg(Value) as Value, Quality from ihRawData  WHERE  SamplingMode = CALCULATED AND CalculationMode = TIMEGOOD AND Tagname = 'FIX.COSINE_2A.F_CV'  AND TimeStamp > '05/08/2008 23:59:59'  AND TimeStamp < '05/10/2008 00:00:00'  AND NumberOfSamples = 1440   AND Quality > 0 GROUP BY Quality

• Default Settings:

This interface has default settings depending on the statistic selected.

By default SAMPLINGMODE is set to LAB for all statistics except INVENTORY and RAINGAUGE which use RAWBYTIME.

If SAMPLINGMODE is set to CALCULATED, then the following rule is set by default (but can be changed):

If STATISTIC is,	then CALCULATION MODE is
MINIMUM.Calculated	MINIMUM
MAXIMUM.Calculated	MAXIMUM
COUNT.Calculated, CYCLE.Calculated, TIMELT.Calculated, TIMEGT.Calculated, and TIMEEQ.Calculated	COUNT
[ All Others ].Calculated	AVERAGE

This means if you only specify MINIMUM.CALCULATED then the CALCULATION MODE will be set to MINIMUM.  

•   Tag Picker

All Available Tags - The column on the left lists all the tags available in the Proficy Historian.

Filter Tag List - This is the list of tags that gets exported in OPSDATAXML files that can be read into Hach WIMS client via an interface. You should only add tags to the filter list that you plan on using in Hach WIMS client. The more tags you add the slower the collector will run.