The X2 PCUtility is a suite of Windows-based utilities designed to assist in the operations of the X2 logger. Among other functions, they are used to configure and diagnose the X2 as well as download and process the X2 data. This article covers the POP3 data download and CSV data processing component. The utilities are compatible with Win7 or higher. They are portable and no installation is required. They can also be run directly from an external flash drive or DVD drive.
When data forwarding is enabled on WQData LIVE, the X2 PCUtility is used to download the email messages, process the data, and store it on the host computer in .csv format. The latest version of the X2 PCUtility can be downloaded at the link below.
Table of Contents
By clicking on the X2 icon in the top left a menu dropdown will appear.
From this menu, the utility can be closed or minimized. Additionally, the About dialog can be opened. This shows the current release version.
The first section of the software asks for the device’s UUID (Universal Unique Identifier). This 41 character identifier is used to distinguish between various X2 devices.
Add a New Device
- Click Add
- Enter the UUID
- Click OK
Edit an Existing Device
- Click the down arrow next to Add
- Click Edit
- Make required changes
- Click OK
Remove an Existing Device
- Click the down arrow next to Add
- Click Remove
- Click Yes to confirm removal
Select Data Folder
This is the location where the .csv files will be stored on the local computer.
- Click Browse
- Navigate to the desired folder
- Click Select Folder
Select .csv File Format
The default operation is to save each parameter into a sperate file identified by its unique parameter number. However, depending on the post-processing plan for the data, it may be beneficial to place all parameters into a single .csv data file. If this is the case, a checkmark should be placed in the Combine data from all parameters into a single .csv file box.
Email Server Setup
The email server to which the X2 data messages are being sent must be entered into the program so that the utility can download the data messages for processing. If any of this information is unknown please check with your technical support or server provider. The Password may or may not be saved upon a program exit depending on the particular system’s cryptographic service.
- Note that this email must be the one entered into WQData LIVE’s Data Forwarding box.
The X2 PCUtility periodically checks the email server for new messages to download and process. It is recommended to correlate the frequency of checks with the devices upload frequency to avoid unnecessary network traffic.
Begin: This defines the date and time from which the interval starts
Interval: The frequency with which the utility checks the server for new messages
Next Download: Shows the amount of time until the next download in hh:mm:ss format
Enable Download: When checked, the program will download data based on the interval, and when unchecked, it does nothing
- Data from the X2 logger is stored in the X2’s microSD card locally.
- Data is read from the SD card and sent to the email server at regular intervals using HTTP POST protocol
- Data is transmitted in XML format
- Data is downloaded onto the local PC using the X2 PCUtility
The data flow from logger to PC can be seen at the bottom of the X2 Data Flow article.
Each X2 logger is identified by a UUID (Universal Unique Identifier). The UUID is a 128-bit number followed by a 32-bit NexSens device ID. The two numbers are formatted as hexadecimal digits and separated by an underscore ‘_’. The result is a 41 character string.
Sensors and Parameters
- Each sensor attached to the X2 logger is assigned a unique sensor number SNO (within the logger) starting from 1. The sensor may contain one or more parameters.
- Each parameter is assigned a unique parameter number PNO (within the logger) starting from 1.
There are 2 sensors connected to an X2 logger
- Sensor 1: Sonde with temperature, conductivity, and DO parameters
- Sensor 2: Pressure transducer with pressure, temperature, and level parameters
The resulting sensor and parameter numbers are as follows
- Sonde SNO: 1
- Temperature PNO: 1
- Conductivity PNO: 2
- DO PNO: 3
- Pressure transducer SNO: 2
- Pressure PNO: 4
- Temperature PNO: 5
- Level PNO: 6
The X2 PCUtility checks the user-specified POP3 mailbox at regular interval and, if messages are found, downloads the email message attachments to the XML folder on the PC
- C:\Users\<username>\Appdata\Local\X2 PCUtility\XML\
After each download session, files in the XML folder are scanned and processed. The processed data is stored in .csv files in the user specified DATA folder. The default DATA folder is
- C:\User\<username>\Documents\X2 PCUtility Data\
After the .xml files have been processed, they are moved to the _ Archive folder under the <XML> folder
- C:\Users\<username>\Appdata\Local\X2 PCUtility\XML\_Archive\
The X2 PCUtility configuration is saved in the CFG folder. All configurations are saved in clear readable text except for the POP3 password which is encrypted using Microsoft Crypto API.
- C:\Users\<username>\Appdata\Local\X2 PCUtility\Cfg\
Data is saved in the DATA folder in .csv format.
- <DATA Folder>\<uuid>_DevData_<PNO>.csv
- The timestamp in the .csv data file is in UTC.
By default, data from each parameter is saved in a separate file identified by the parameter number (PNO). If desired, the X2 PCUtility provides an option to save data from all parameters in a single file. In which case, the file is named without the <PNO>.
- <DATA Folder>\<uuid>_DevData.csv
File Name: 0005ffffffffffff4e45323120120014_00100010_DevData_1.csv
“Parameter No”,”UTC Time”,”Data”
Sensor Configuration File
WQDataLIVE provides an option to request the current X2 logger sensor configuration. After the request, on the next X2 to WQDataLIVE communication, the X2 will send its configuration in XML format. The data flow is exactly the same as that of data. The X2 PCUtility automatically downloads, parses, and saves the configuration in DATA folder:
- <DATA Folder>\<uuid>_DevDesc.csv
File Name: 0 005ffffffffffff4e45323120120014_00100010_DevDesc.csv
“Sensor No”,”Sensor NID”,”Parameter No”,”Parameter NID”