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.

http://www.nexsens.com/download/X2%20PCUtility.exe

Table of Contents

Interface
Data Flow
Identification
Folder Location
Data File
Sensor Configuration File

Interface

Overview

Menu Bar

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.

Data Download

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

  1. Click Add
  2. Enter the UUID
  3. Click OK

Edit an Existing Device

  1. Click the down arrow next to Add
  2. Click Edit

  3. Make required changes
  4. Click OK

Remove an Existing Device

  1. Click the down arrow next to Add
  2. Click Remove

  3. Click Yes to confirm removal

Select Data Folder

This is the location where the .csv files will be stored on the local computer.

  1. Click Browse
  2. Navigate to the desired folder
  3. 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.

Download Schedule

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 Flow

  • 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.

Identification

X2 Device

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.

Example: 0005ffffffffffff4e45323120120014_00100010

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.

Example

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

Folder Location

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 File

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

Sample file

File Name: 0005ffffffffffff4e45323120120014_00100010_DevData_1.csv

Contents
“Parameter No”,”UTC Time”,”Data”
1,2017-02-21 00:35:39,3.35

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

Sample file

File Name: 0 005ffffffffffff4e45323120120014_00100010_DevDesc.csv

Contents
“Device UUID”,”0005ffffffffffff4e45323120120014_00100010″
“Device Name”,”X2-C-VZ3G-10003″
“Sensor No”,”Sensor NID”,”Parameter No”,”Parameter NID”
4,4653061,97,5242885
4,4653061,98,5308421
4,4653061,99,5373957
4,4653061,100,71761920
4,4653061,101,71827456
4,4653061,102,71892992
4,4653061,103,5242885
4,4653061,104,5308421
4,4653061,105,5373957
4,4653061,106,71761920
4,4653061,107,71827456
4,4653061,108,71892992