Home : Products : Hach WIMS : Interfaces : Hach WIMS Direct Server-Side Interface to Custom Q14107 SCADA CSV : Documentation : Introduction : Source specifications
Q14113 - INFO: Source specifications

The main specifications for this interface are:

  • Use standard statistics    
  • Allow for multiple subfolders
  • Support narrow and wide formats 
  • Data separated by commas or tabs
  • Data is in chronological order by date and time
  • Date and time can be within the same column or in separate columns, support both
  • Process all files meeting user file name mask (*.csv, *.txt, *.*, and whatever the user may specify)

Testing was conducted to test each detailed specification listed below.

1. In configuration, user selects folder where files/subfolders are located and mask for filename. default mask is '*.CSV', if blank then '*' (one astrick), dropdown options are *.CSV, *.TXT, and *.* - but user can change to anything they wish.

2. Limitations: we cannot process thousand files spanning 10 years of source data. Tested on 30 MB file and on 18 files of more than 1 MB each.

3. Allow user to delete old files and ask for number of days old - if < 7 days then set to 7 days

4. Handle duplicate data points. Compress data to 1 min. even intervals to facilitate filtering on another tag, if multiple values for 1 min, then the last value will be kept - whether wide or narrow format.

5. Handle sub-folders; signal tag will be "FOLDER@@TAG". If using a Filter tag, data for the Filter tag must exist in same folder as Signal tag. If "TAG" is numeric, it denotes a column number, and can only be used when source data files are in Wide format.

6. Ask for date range, if the the requested date range goes past the source date and time - do not process data, but process data upto as close to the end time of the requested range as possible.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 6/4/2013 2:20 PM.
Last Modified on 6/5/2013 2:46 PM.
Last Modified by No Author Name Available!.
Article has been viewed 2310 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article