1. Creating the ZRXP output from the Excel file

Here is one example how to create the ZRXP file directly from Excel. The format of the sample Excel file is given as:

xls1

-Change all invalid entries for parameter measurements to -777
-Create additional column where you will convert day of year format to a regular date. In this case, the formula will be DATE(year, 1, day)
xls2
-Create additional column for a regular time format with formula TIME(hour,0,0)
xls3
-Create additional column by concatenating date, time, and parameter value. Use the following formula:
CONCATENATE(TEXT(date,”yyyymmdd”),TEXT(time,”hhmmss”),” “,parameter) Don’t forget the space between the time stamp and the parameter value
xls4
-Repeat the same operation(s) for the next parameter
xls5
-Select, copy, and paste each parameter column into a separate text file. In each text file, create the WISKI header in the following way: #REXCHANGEParameterName|*|RINVAL-777|*|RSTATEW6|*|
xls6
-Save the file with the ZRXP extension. Make sure you have the unique Exchange number for each file you have created

5. Additional KiDAT Examples: One parameter from CSV

This is a simple example showing how to import only one parameter from the CSV file.
-Open the file and replace all missing values with -777
-Add / change the parameter name if necessary
View image
-Start the KiDAT Dashboard and add a new task
View image
-Specify the task name, input and output folders
View image
-Specify the column separator “,”, exchange number structure (parameter name in the 1st column, 0th row), Date and time location (1st column for each row), date and time format (d/m/yyyy), value location (each column and row), invalid value (-777), first value column (2), last value column (2), first row with the value (1). Row and column indexing starts from 0
View image
-Once you save your task, copy the CSV file to the Input folder and the ZRXP file will be generated in the Output folder if there are no errors encountered during the conversion
View image
-Some more information about the possible errors can be found in the Input\Damaged folder

Adding the Wiski shortcut for all users

If you need to create the shortcut on your computer that all users can see, do the following:
-Right-click on the “All Programs” button on the start menu, and choose “Open All Users” to open up the system-wide Start Menu folder
OpenAllUsers.jpg
-Paste the shortcut to the Programs folder

Client installation steps

-Download the latest wiski client release (wiski-all-7.1.13.3-70.Client_Release.zip or later)
-Create the folder C:\Kisters\wiski7 and unpack wiski files to this location
View image
-Run register.bat in C:\Kisters\wiski7 folder as Administrator
View image
-start wiski.exe and login with the given user/password combination
View image
-Click ignore on the message about the ini file. The file(s) will be created for you
View image
If the wiski explorer window does not start, you might need to reset your computer.
All help files are located in the wiski7 folder. Wiski client help file is wiski_en.chm
If the help file does not open, you might need to do the following:
-Right click on the chm file properties
-Under the Advance button, locate the Unblock button and click on it to unlock the help file
View image

5. Importing additional data into the existing time series

Time series data was already stored for the particular station. We would like to add more data to the existing records. New time series is not being created.
Three scenarios are discussed.
Scenario 1: New records are all different than the existing ones.
When importing the data, choose “Keep existing data, append new data” option when confirming the import
View image
In this case, new data will be added to the existing data, within the interval, or left and right from the interval dates depending on the new time stamps.
Scenario 2: New data contains values with the new time stamps as well as the values with the existing time stamps. In other words, station XYZ already has the value 9.561 recorded on 1/1/2011. However, new data, among other records contains value 9.555 recorded at the same time on 1/1/2011. We want to add new data to the existing time series but to keep the old values for the overlapping time stamps (keep 9.561). For this option, please choose “Keep existing data, append new data” as in the scenario 1.
Scenario 3: We would like to update some of the records in the existing time series. For example, we found that the value 9.561 recorded on 1/1/2011 was wrong and it should be replaced with 9.555 for the same time stamp. All other values in the existing time series are correct and do not need to be replaced. ZRXP file in this case should contain only the values that we want to write to the existing time series by replacing the old values with the same time stamps. Choose “Import data, overwrite all existing data” in this case. Only the data with the same time stamps will be overwritten and all other old records will remain unchanged in the time series.
View image
Important: for Scenario 3, you will not be able to see the changes in the time series data until you close the time series and reopen it again. F5 refresh does not help in this case.

Missing time series values

I was not able to properly import the time series data in cases where comments were available but the values were missing.
SOLVED:
The problem can solved in the KiDAT importer. When the CSV string is parsed, verify that condition value =”” and remark “” is fulfilled. For this case, set the parameter value to be -777. KiDAT will generate the corresponding zrxp file and the value will be translated to “—” (code for missing value) during the wiski time series import.
The VB code example can be similar to this one:
If value = “” And comment = “” Then
missing = missing + 1
ElseIf value = “” And comment “” Then
kidat.zrxpout(station, date_stamp, -777, comment)
Else
kidat.zrxpout(station, date_stamp, value, comment)
End If

4. Setting up the advanced KiDAT importer

You will need to create the advanced importer for any non trivial KiDAT task including the one where you want to import the values as well as the remarks for a station time series data. Simple case – dealing with the import of remarks is explained in more details below.
The format of the csv file will be the following:
_____________________________________
Date,piez,depth (m),field note
10/27/1999,9901,5.325,
10/27/1999,9902,0,dry
10/28/1999,9901,4.695,data suspect
_____________________________________
Similarly to the previous step (3):
-Start the KiDAT Dashboard program
-Choose File / Add New Task
-Choose Advanced Configurable (File Conversion) new task type to handle the import of time series data from a delimited file
-Name the task
-Choose the KiDAT Conversion Folder where the import file will be coming from
-Choose the Destination Folder for the converted files
-Click Next
The source code editor will open. Please try to follow given guidelines and explanations:
View image
View image
The source code for this importer can be found in the attachment: Download file

3. Setting up a simple KiDAT importer

-Start the KiDAT Dashboard program
-Choose File / Add New Task
-Choose Configurable (File Conversion) new task type to handle the import of time series data from a delimited file
-Name the task
-Choose the KiDAT Conversion Folder where the import file will be coming from
-Choose the Destination Folder for the converted files
View image
-Click Next
-Specify the importer configuration
A sample file would be the one with the piezometer time series in the following format:
Date,piez,depth (m),field note
11/14/1980,8013P1,6.785,
……………………
Configuration details:
Column separator is ‘,’ so enter in the corresponding text box.
Exchange number is an identifier assigned to a time series that allows data files to be imported directly into specific time series in wiski.
The exchange number is being read from a Cell (,). In the above case, piezometer name 8013P1 is the identifier of the corresponding time series. In the CSV import file, this identifier is in the first column in each current row. Column and row indexes start from 0. Write Cell(1,) in the Exchange Number structure text box and identifier will be read from the first column every time a line in the file is accessed.
Date and time cell is in the column 0 in each line of the import file. Hence, write Cell(0,) in the Date and Time Location text box. If the date and time are located in two difference cells, enter both cells with a comma between them in the “Date and Time Location” box
A month and day can be represented with one or two digits and the year always contains four digits. Write M/d/yyyy to the Date and Time Format box to support this kind of arrangement.
Look for the time series value in each current column and row of the import file but start and end in the second column and begin in the first row (skip the column names in the row 0). Loop till the end of the file. In other words:
Value Location = Cell(,), First Column = 2, Last Column = 2, First Row = 1, Last Row = “”. These settings tell the filter to go through all the lines in the import file and read the value from the third column (column index = 2).
For all invalid cases, write the code -777 in the corresponding time series.
The sample importer setting are shown in the image below:
View image
Save the importer configuration. While the task is running, copy a raw file to the input folder. Importer will read the file and create the ZRXP file in the previously specified output location. This new file can be used to import the time series data to wiski. The process is explained earlier in this document (View image)

2. KiDAT Update

This program is frequently updated as it contains the functions to read the data from different and always changing file formats. Please check for updates on a regular basis.
The update procedure is the following:
-Run KiDat dashboard application as the Admin user. Here is one way to do it:
View image
-In the KiDAT Dashboard, select Help/About and click Check For Update. KiDAT service has to be running to get this kind of dialog option:
View image
-The latest version number of KiDAT will be shown on the screen. If you have the older version of the software, accept the update option:
View image
Only if you are running the KiDAT as Admin, you will be able to stop this service and install the updates. The messages for the proper installation are shown below:
View image
View image
If applicable, change the privilege level back to normal for the KiDAT Dashboard application by unselecting the “Run this program as an administrator” option in the KiDAT Dashboard Properties / Compatibility tab. For more information please check the description from the beginning of this article (View image).

1. KiDAT Installation

KiDAT is the Data Acquisition tool used for file conversion, web scraping, and scheduled task execution. You will need this module in order to convert your Excel or text files with time series data to the native wiski format – ZRXP files.
The module supports general and custom file conversion techniques. The later involves a scripting language developed from the VB that you can use to create custom wiski importers.
KiDAT installation steps are the following:
-Create C:\Kisters\KiDAT folder and unpack the KiDAT installation file to this location
-Verify that you are running MS .NET Framework 4:
To see which versions are installed, view the %WINDIR%\Microsoft.NET\Framework directory. You should also view the Framework64 directory on a 64-bit computer, which can have 32 or 64-bit versions installed. Each version of the .NET Framework has a directory, and the first two digits of the directory name identify the .NET Framework version.
-If .NET Framework 4 is not installed, download and install one from this location:
http://msdn.microsoft.com/en-us/library/5a4x27ek
-You might need to be logged in as Admin in order to finish the installation
-Start setup.exe file in the KiDAT folder and proceed with the installation
-Once the installation is done, start the KiDAT Dashboard application