Home : WIMS DATA XML File Format, Revision 3
Q13154 - INFO: WIMS DATA XML File Format, Revision 3

Also see the set up article

The WIMS Data XML file format is referred to as OPSDATAXML.
It was designed to provide an open storage mechanism for data from data acquisition systems (such as SCADA, LIMS, etc).
The data inside of OPSDATAXML files can be stored in raw or summary contexts.

There are three main XML trees to each file:

1. <SPEC> - This is the specification of the file. It contains information on how the file was built such as:

FIELD

DESCRIPTION VALUE
revision [attribute] The revision of the file format "3"
collector [attribute] The identifier of collector or utility that generated the current file

"0" when using software produced by third parties;
otherwise unique identifier of collector software within HACH IIM software inventory (example "13199")

context [attribute] The context of the data is either raw or summary "raw"/"summary"
encrypted [attribute] Whether the <data> tree was encrypted or not.
If True, 128-bit AES encryption algorithm was used.
"false"/"true"
compressed [attribute] Whether the <data> tree was compressed or not.
If True, Zip compression algorithm was used and <data> was encoded using base-64  encoding.
"false"/"true"
content Link to this knowledge base article web page link

Example:

2. <DATA> - This is the actual data from the source system. If encryption and/or compression is true, only this section will be encrypted and/or compressed. It contains the actual information such as:

FIELD RAW DESCRIPTION RAW EXAMPLE VALUE SUMMARY DESCRIPTION SUMMARY EXAMPLE VALUE
s Begin Server data [blank] Begin Server data [blank]
s_id Source Server Name ANALOG Source Server Name OPSWWTUTOR
s_d Server Description Source Server Server Description Hach WIMS Facility
t Begin Tag data [blank] Begin Tag data [blank]
t_id Tag Name 1.FLOW OPS VarID 21
t_d Tag Description Tag Name Tag Description Variable ID
r Beginning of a record [blank] Beginning of a record [blank]
d  UTC date & time 2011-01-27TO6:56:00Z UTC date & time 2011-01-27TO6:56:00Z
v Raw value 40569.9972222 Summary value (avg, sum, ...) 40570
x Data Storage Extension [blank] Data Storage Extension <collectedby>Joe Poyner</collectedby>

Notes:

1. Qualifiers are typically: "<" - less than, "<=" - less than or equal to, ">" - greater than, ">=" - greater than or equal to, "=" - equal to, and "<>" - not equal to

2. Units are typical for SCADA & LIMS systems and include but not limited to: MGD, mg/l, lbs, Deg F, Deg C, lbs/day, MG, gal, SU, No/100ml, inches, ft, days, gpm, ppm, ppb, tons, Number, Fraction, %, #BOD/D/#ML, #/MG, col/100ml, ntu

3. Approval levels start with zero (0) and go negative. Typically 0 means final approval, and then -1024 is the next level below that, -2048 is the third level down and so on.

Examples:

   

                  Raw data example                                                    Summary data example

 

3. <TRACE> - A set of 0 or more trace records <r> that, in chronological order, contain information about which application touched the file. Required fields :

FIELD DESCRIPTION EXAMPLE VALUE
audituser Who or what program wrote the data VIA_ODA2X
audittimestamp UTC date time stamp 2008-02-12T17:30:29Z
apptitle Title of application writting data OPC DA to OPS XML
appexename Executable name of application OPCDA2OPSXML
appversion Version of application 1.0.2
apppath Path of application .host\.....\OPCDA2OPSXML
workstation Name of computer app is running on LT035-VMT10549
netuser Logon name of user running app ops
ip IP address of computer 10.66.6.172
winversion Windows OS version and build Windows NT 5.1.2600

Example of trace:

 

Multiple tags will have the following hierarchy (notice in the example, no data found for "6.FLOW"):

 

 


NOTE : For information about how to encrypt / compress / decrypt / decompress data of this format, contact OPS Systems.

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 8/26/2010 2:41 PM.
Last Modified on 8/6/2014 12:53 PM.
Last Modified by No Author Name Available!.
Article has been viewed 5218 times.
Rated 8 out of 10 based on 4 votes.
Print Article
Email Article