Home : Source Specificiations
Q12864 - INFO: Source Specificiations

System Specifications:
Configure interface and browser to point to a path for source data, when interface runs it will import data from all files ending with ".TXT". No units conversion since no units in source file. No Additional Info needed. Track MDL rules and apply Hach standard: if rule not defined in Hach WIMS, write value and symbol to comments. The user is responsible for maintaining the source data folder, all files are imported irrelevant to what the dates are.

File Specifications:
File name is irrelevant. Source data is text files, fixed length fields.
First character is Rec Type (O, D, E)
O - LIMS Test (25 chars), LIMS Location(17 char), Symbol(2 char), Value(11 char)
D - Date time stamp (YYMMDDHHNN - 10 char)
E - Error, set by interface when data error

D records occur first, then O records follow, the next D record datetime is for the next sequential O records read.
In the old interface the record type was set to E if there was an error in the data. Thats fine just make sure to handle data errors differently than execution errors. Data error, set record type to E but if execution error then return boolean.

(See screen below for description)
Date stamp is Date on D record types with hour and minutes dropped
Match on LIMS Location and LIMS Test from O record types, with spaces removed
Text Value returned to Hach WIMS is MDL Symbol and Value on O record types

This is an example of the variable setup in Hach WIMS for this data point:

The interface will ignore upper and lower case when looking for matching records, and when the MDL Symbol is not recognized by Hach WIMS, the value will be imported to comments.

 

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 2/2/2010 9:45 AM.
Last Modified on 2/3/2010 9:11 AM.
Last Modified by No Author Name Available!.
Article has been viewed 2353 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article