This is example and description of the CSV files created for this interface.

The file names must be the date of it was created in the format MMDDYYYY.csv: where MM is the numerical value month, DD is the day, and YYYY is the year. So for January 21, 2010 the file name is 01212010. Data can span over multiple files, so it is possible that 01202010 would have data in it for the 21st. Here is an example:

Notice if today is January 28, 2010 and I do have a file for today because my script creates these files at 6 AM - then this interface will import this mornings data, up to 6 AM.

The CSV files will look similar to the following:

The $DATE and $TIME must appear as shown - in two separate columns with a leading dollar sign and all capital letters. This must be the very first line in the file.

The third column and continuing to the right will have the tag names.

Starting with the second row is the date, time, and data points for each tag, this must start at the second line. There can be no blank lines within the data. Values can be numeric or text, but the Hach WIMS client variable description must match the data type. Only certain statistics will work with text parameters. These are: First, Last, Mintime, Maxtime, and Count.