Xylem WQL-Cond User Manual

Operating manual

Logger WQL-Cond

PC program WQL-Log

Logger for conductivity measurement and PC program to display and evaluate data from the logger

ba75822de01 03/2011

DRAFT: Thursday, 17. March 2011

Note

The latest version of the present operating manual can be found on the Internet under www.WTW.com.

Reproduction in whole - or even in part - is prohibited without the express written permission of WTW GmbH, Weilheim. Printed in Germany.

WQL-Cond Contents

Contents

1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101

1.1 Logger WQL-Cond . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101

1.2 PC program WQL-Log . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102

2 Safety . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105

3 Commissioning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

3.1 Inserting the battery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .107

3.2 Mounting suspension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108

3.3 Installing the WQL-Log program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109

3.3.1 PC requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109

3.3.2 Installation routine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109

3.4 Initial commissioning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115

3.5 Connection types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .118

3.6 Starting the WQL-Log program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119

4 Setting the display . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

4.1 Setting the language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

4.2 Setting the temperature unit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

4.3 Setting the cursor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .122

5 Setting the measuring mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124

6 Calibration in control standard (determining the cell constant) . . . . . . . . . . . . . . 127

6.1 Calibration settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .128

6.2 Calibrating (automatic) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129

6.3 Calibrating (manual) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132

6.4 Viewing the calibration history . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136

6.5 Exporting the calibration history . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138

7 Measuring directly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139

8 Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140

8.1 Typical sequence of a logging job (checklist) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140

8.2 Setting up a logging job - setting parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141

8.3 Setting the parameters and starting the logging job . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144

8.4 Logging job - storing or loading the configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151

8.5 Signal LED and logger key button . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

8.5.1 Signal LED to indicate the operating conditions of the logger . . . . . . . . . . . . 153

8.5.2 Logger key button . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

8.6 Importing data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154

8.7 Overview of the data window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155

8.8 Managing the logging jobs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156

ba75822e01 03/2011

Contents WQL-Cond

9 Working with the database and measurement data . . . . . . . . . . . . . . . . . . . . . . . . 159

9.1 General information on the database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159

9.2 Creating a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160

9.3 Opening a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161

9.4 Backing up a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162

9.5 Restoring a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163

9.6 Erasing a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165

9.7 Querying data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166

9.8 Exporting data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170

10 Info menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .174

10.1 Database information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174

10.2 Device information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175

10.3 Program info . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176

11 Resetting the logger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177

12 Maintenance, cleaning, storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179

12.1 General maintenance instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179

12.2 Exterior cleaning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179

12.3 Battery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180

12.3.1 Battery service life . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180

12.3.2 Ascertaining the battery status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180

12.3.3 Resetting the battery counter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181

12.3.4 Battery replacement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182

12.4 Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183

12.5 Replacement parts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183

13 What to do if... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185

13.1 Calibration and measuring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185

13.2 Communication of the logger and PC program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186

13.3 Communication between PC program and SQL server . . . . . . . . . . . . . . . . . . . . . . . . . 186

14 Technical data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187

14.1 Measurement characteristics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187

14.2 Application characteristics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188

14.3 General data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188

14.4 Electrical data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189

100

ba75822e01 03/2011

WQL-Cond Overview

Control panel

10 11

1 Overview

1.1 Logger WQL-Cond

Structure of the

logger

1 Protective hood 2 Conductivity measuring cell (permanently installed) 3 Voltage electrode (inside, 2x) 4 Current electrode (ring, 2x) 5 Temperature sensor in graphite enclosure 6 Shaft 7 Sleeve 8 Cap 9 Battery compartment with battery 10 Key button 11 Signal LED 12 USB socket

ba75822e01 03/2011

101

Overview WQL-Cond

Recommended

fields of

application

Conductivity measurements in wells, bore holes, rivers, water bodies and other surface water, drinking water, ground water, leachate, waste water.

1.2 PC program WQL-Log

The WQL-Log PC program serves to operate a connected WTW data logger of the WQL series type. The WQL-Log PC program automatically recognizes the logger when it is connected to the USB interface and controls the menus according to the type and measured parameter.

The PC program can carry out the following functions:

z Calibrate the measuring system

z Set up and start a logging job

z Measure directly: The logger is connected to the PC via USB and the PC

program displays the current measured values.

z Read in measurement data of the logging job: Consistent data copying to

a PC-based database.

z Database-supported evaluation of measurement data, export functions

Note

The current version of the WQL-Log PC program and the current firmware for the WQL-Cond logger is available on the Internet on the website of the manufacturer of your meter.

102

ba75822e01 03/2011

WQL-Cond Overview

Logger

Carry out logging jobSet up logging jobLogging

(chapter 6)

Processing the measurement data (chapter 7)

Calibrate in

standard solution

Stop

(e.g. logging job

completed)

(Log)

Measurement dataset 1 Measurement dataset 2 Measurement dataset 3 ...

Measurement dataset 1 Measurement dataset 2 Measurement dataset 3

...

Measurement dataset n

Connect

Calibration record

Current values

(real time)

Parameterize,

send

Read in completed

logging job

PC + WQL-Log

CalibrateCalibrating

(chapter 4)

Measure directlyMeasuring

(chapter 5)

Measure

Stop communication

with WQL-Log

Clear the

logger memory

Measurement data

- Query

- Display

- Export (*.csv)

Save in database

ba75822e01 03/2011

Fig. 1-1 Overview of the communication of the logger and PC program

103

Overview WQL-Cond

104

ba75822e01 03/2011

WQL-Cond Safety

2 Safety

This component operating manual contains special instructions that must be followed during the operation of the logger and PC program.

Always keep this operating manual in the vicinity of the logger and PC program.

Symbols

used

Note

indicates notes that draw your attention to special features.

Note

indicates cross-references to other documents, e.g. application reports.

Warning

indicates instructions that must be followed precisely in order to avoid the possibility of slight injuries or damage to the instrument or the environment.

ba75822e01 03/2011

105

Safety WQL-Cond

106

ba75822e01 03/2011

WQL-Cond Commissioning

3 Commissioning

Note

z Normally, all screw joints of the logger housing can be opened and closed

by hand, without using any tools. If necessary, use a paper towel so you can get a better grip on the parts.

z Insert the battery in a clean and preferably dry environment.

3.1 Inserting the battery

Note

The logger is powered by a 3.6 V lithium battery, size AA, as provided in the scope of the delivery (see chapter 14 T same size such as alkaline manganese batteries do not provide the required operational voltage. Operating time, see section 12.3 B

ECHNICAL DATA). Other batteries of the

ATTERY.

Fig. 3-1 Inserting the battery

ba75822e01 03/2011

107

Commissioning WQL-Cond

1 Unscrew the cap (Pos. 1 in Fig. 3-1).

2 Unscrew the sleeve (Pos. 2).

3 Insert the battery. When doing so, make sure that the battery is

correctly positioned (see label in the battery compartment).

Corrosion

protection

4 Screw the sleeve on the shaft with the shorter

thread. At the rear end of the sleeve there is a thin O-ring inside (Pos. 3). Make sure that this O-ring is evenly positioned in the groove and is not twisted.

5 Screw on the sleeve and cap again. In the screwed condition, no gap

may be visible at the joints.

After the battery was inserted the signal LED lights up for 2 seconds. This means the logger has to be connected with the PC to set the date and time (see section 8.3 S and section 8.5 S

ETTING THE PARAMETERS AND STARTING THE LOGGING JOB

IGNAL LED AND LOGGER KEY BUTTON).

3.2 Mounting suspension

To attach the logger to a rope or chain, a suitable shackle is provided whose bolt fits through the cross hole in the cap. As an alternative, you can screw some different sling gear into the M6 threaded hole at the cap end (e.g. M6 eye bolt).

In water, metal (e.g. zinc-plated) parts of the mounting suspension such as thimbles, shackles or swivel connectors create voltages (chemically caused according to the electrochemical series), which can cause corrosion of the stainless steel of the logger or the above mentioned suspension parts.

Lightning

protection

Electrically conductive ropes or chains harbor the danger of the logger being damaged by lightning.

Recommendation For reasons of corrosion and lightning protection, we recommend to use a

nonconductive suspension, e.g. one with low-wear, resistant polypropylene ropes.

108

ba75822e01 03/2011

WQL-Cond Commissioning

3.3 Installing the WQL-Log program

3.3.1 PC requirements

The WQL-Log software program requires the following system components:

Hardware

requirements

z Computer with Intel or Pentium III 500 MHz processor or higher

(1 GHz or quicker recommended.)

z At least 192 MB RAM (512 MB recommended)

z Hard disk with at least 600 MB available memory

z CD-ROM drive

z A free USB interface. Only one logger can be connected. If a new logger

is registered, the previous one is logged off.

Software

requirements

z 32-bit

-operating system Windows 7, Windows Vista, Windows XP,

Windows Server 2003 and higher or Windows 2000 Service Pack 4

User rights z Administrator rights are required for the initial installation. Contact your

system administrator if necessary.

Note

The program WQL-Log stores the database files with the stored data in the directory where the SQL server is installed (because of access authorization), i.e. normally on C:\. Make sure that there is enough storage capacity available on the hard disk for this directory. An empty database requires 3 MB storage space, a database with 50,000 datasets requires approx. 7 MB storage space. A database can be max. 4 GB, containing approx. 12.5 million datasets.

3.3.2 Installation routine

Note

The software is continuously developed further. The current version of the WQL-Log program is available for download on the Internet under http:// www.WTW.com.

Note

The following files and/or directories are on the supplied CD-Rom:

z The installation file for the PC program and the database server

z A directory with the installation program for the driver of the USB

interface

z A directory with the operating manual for the logger and the PC program.

ba75822e01 03/2011

109

Commissioning WQL-Cond

1 Insert the enclosed CD-Rom in the corresponding disk drive of the

PC.

Installing the

driver

Installing the PC

program and

database server

2 Open the directory, USB_VCP_driver.

3 Execute the file, CP210xVCPInstaller with a double click.

4 Follow the user guidance (click Install).

5 Confirm the installation with OK. A virtual COM Port has been created

with the installation.

6 Execute the WQLLog_Vxxxx.exe file with a double click (xxxx =

current version number). The installation wizard appears.

110

7 Follow the user guidance (click OK).

ba75822e01 03/2011

WQL-Cond Commissioning

Note

If the SQL server was already installed for another application, the installation of the server is automatically skipped. The program continues with step 15.

8 Check off the checkbox, I accept the licensing terms and conditions.

9Click Next. An information window appears with the components

required for the installation.

10 Click Install. The installation is carried out. Follow the user guidance

(click Next) until the Authentication Mode window appears.

ba75822e01 03/2011

111

Commissioning WQL-Cond

11 Select the Mixed Mode option.

12 In the Enter password field, enter the password WTW!2009.

13 Repeat the password entry WTW!2009 in the Confirm password field.

Note

The password WTW!2009 must be entered twice. If a different password is entered, the PC program is not granted access to the database.

Note

If the SQL server was already installed for another application, you have to change the password for the SQL server first before the WQL-Log program can create a database. To change the password see section

13.3 C

OMMUNICATION BETWEEN PC PROGRAM AND SQL SERVER.

14 Click Next. Then follow the user guidance (the default settings should

not be changed) until the following display appears:

112

ba75822e01 03/2011

WQL-Cond Commissioning

15 Here you can change the location where the PC program should be

stored (click Change... ). When the required location is displayed, click Next.

ba75822e01 03/2011

16 Here you find information on the installation. Click Install.

113

Commissioning WQL-Cond

17 Click Finish to complete the installation.

114

ba75822e01 03/2011

WQL-Cond Commissioning

3.4 Initial commissioning

1 Start the WQL-Log program (the relevant icon is on the desktop).

The Login window appears.

2 If the WQL-Cond logger is connected to the PC via a USB cable and

should communicate with the WQL-Log PC program: Confirm with OK. The WQL-Log program searches for the connection with the logger.

3 Confirm with OK.

During the initial commissioning, the Select database window appears.

ba75822e01 03/2011

115

Commissioning WQL-Cond

4 Confirm the option, Create a new database with OK. The window to

save the newly created database appears.

5 Change the name of the database as necessary.

Click OK. The database is stored and a message appears:

116

6 Confirm with OK. An empty data window appears, as the database is

still empty:

ba75822e01 03/2011

WQL-Cond Commissioning

Note

13.3 C

OMMUNICATION BETWEEN PC PROGRAM AND SQL SERVER.

ba75822e01 03/2011

117

Commissioning WQL-Cond

3.5 Connection types

The PC program WQL-Log works with two types of connection:

z Work with database

(the logger and PC program do not communicate)

z Connected to logger

(the logger and PC program communicate)

Working with the

database

Connected to the

logger

In this type of connection it is only possible to process the measurement data stored in a database and to change the system settings.

When the logger is logged on and connected to the WQL-Log PC program, the program and the logger communicate with each other. The measurement datasets present in the logger can be imported to the database and are thus available for processing.

You can configure the logger according to your requirements and set up a logging job. When the logging job is started, the connection between the logger and the WQL-Log PC program is cut. The cable connection between the logger and PC does not have to be disconnected for this.

118

ba75822e01 03/2011

WQL-Cond Commissioning

3.6 Starting the WQL-Log program

1 Start the WQL-Log program.

The Login window appears.

2 If necessary, you can change the display language here with the

menu item, Display (see section 4.1 S out which software version of the WQL-Log program is installed with the menu item, Help (see section 10.3 P

ETTING THE LANGUAGE) and find

ROGRAM INFO).

Connection to

logger

3 If the WQL-Cond logger is connected to the PC via a USB cable and

should communicate with the WQL-Log PC program: Confirm with OK. The WQL-Log program searches for the connection with the logger.

4 Confirm with OK. The data window appears.

If there are no data in the database (such as during the initial commissioning), an empty data window appears.

If data are stored in the logger, an overview of the logging jobs appears first (see section 8.8 M

ANAGING THE LOGGING JOBS).

ba75822e01 03/2011

119

Commissioning WQL-Cond

Working with the

database

5 If you want to work with the database:

Select Work with database and confirm with OK. The data window appears with the logger data that was last read in (during the initial commissioning, an empty data window appears).

120

6 To continue, see chapter 9 WORKING WITH THE DATABASE AND

MEASUREMENT DATA.

ba75822e01 03/2011

WQL-Cond Setting the display

4 Setting the display

Under the Display menu item you can set the language and temperature for the WQL-Log PC program and the WQL-Cond logger. You can additionally set whether or not a cursor with a value field with time, date and measured value should appear for each measured parameter in the data window.

4.1 Setting the language

1 In the Display menu, select the menu item, Language.

2 The options Deutsch (German) and Englisch (English) appear.

3 Select the required language with a mouse click.

The setting is immediately active.

4.2 Setting the temperature unit

1 In the Display menu, select the menu item, Temperature unit.

2 The options, ° C (degrees Celsius) and ° F (degrees Fahrenheit)

appear.

3 Select the required temperature unit with a mouse click.

The setting is immediately active.

ba75822e01 03/2011

121

Setting the display WQL-Cond

4.3 Setting the cursor

Note

The Diagram menu item appears only if data are available in the database.

1 In the Display menu, select the menu item, Diagram.

2 The options, Show cursor and Hide cursor appear.

122

3 Select the required option with a mouse click.

After clicking on Accept the setting is immediately active. The data window appears with the cursor and value field. You can change the position of the cursor by moving the data window with the mouse.

ba75822e01 03/2011

WQL-Cond Setting the display

ba75822e01 03/2011

123

Setting the measuring mode WQL-Cond

5 Setting the measuring mode

You can make the following settings in the Device / Set menu (default setting in bold):

Measuring mode z Conductivity

[μS/cm] / [mS/cm]

z Salinity Sal [ ]

z TDS

[mg/l] / [g/l] with adjustable TDS factor in the range 0.40 ... 1.00

z Resistivity

[Ω·cm] / [kΩ·cm] / [MΩ·cm]

Temperature compensation z Nonlinear temperature

compensation (nLF) according to EN

27 888

z Linear temperature compensation (lin)

with adjustable coefficients in the range 0.000 ... 2.000 ... 3.000 %

z No temperature compensation (off)

Reference temperature z 25 °C

z 20°C

TDS factor The factor to calculate the total dissolved solids is set to 1.00 in the factory.

You can adjust this factor to meet your requirements in the range of 0.40 to

1.00. The factor is set in the menu for the parameter, TDS.

Temperature

compensation

-Temperature coefficient

The calculation of the temperature compensation is based on the preset reference temperature, 20 °C or 25 °C. The reference temperature is shown on the display.

The temperature coefficient for the linear temperature compensation is set to

2.000 %/K in the factory. You can adjust this factor to meet your requirements in the range 0.000 ... 3.000 %/K. The factor is set in the menu for the setting of the temperature compensation.

Note

More information on conductivity measurements is given in the WTW conductivity primer.

124

ba75822e01 03/2011

WQL-Cond Setting the measuring mode

Application tips Select the temperature compensations given in the table according to the

respective test sample:

Test sample Temperature compensation Display

Natural water (ground water, surface

nLF according to EN 27 888

nLF

water, drinking water, waste water)