Liquid Controls DB Manager User Manual

DBManager

Installation and Setup

DB Manager

Liquid ControLs Group

An IDEX Fluid & Metering Business

Operation: EM200-21

TABLE OF CONTENTS

INTRODUCTION

Software License Agreement .............................3

DBManager Overview .........................................4

LC Fueling Systems Overview ............................5

LC Fueling Systems Components ......................5

LC Fueling Systems Data Flow ..........................6

INSTALLATION & SETUP

DBManager Installation & Setup Overview .......10

Software Installation ...........................................11

DBManager Setup ..............................................12

Register File Server Nodes ...................................... 14

Register Application ................................................. 14

Set Master File List .................................................. 15

Set Node List............................................................ 16

LCP Setup ..........................................................17

Ofce User Setup ...............................................19

Be Prepared

• Before using this product, read and understand the instructions.

• Save these instructions for future reference.

• All work must be performed by qualied personnel trained in the proper application, installation, and

maintenance of equipment and/or systems in accordance with all applicable codes and ordinances.

• Failure to follow the instructions set forth in this publication could result in property damage, personal injury,
or death from re and/or explosion, or other hazards that may be associated with this type of equipment.

Be Prepared

Publication Updates and Translations

The most current English versions of all Liquid Controls publications are available on our web site, www.lcmeter.
com. It is the responsibility of the local distributor to provide the most current version of LC manuals, instructions, and

specication sheets in the required language of the country, or the language of the end user to which the products are
shipping. If there are questions about the language of any LC manuals, instructions, or specication sheets, please

contact your local distributor.

2

SOFTWARE LICENSE AGREEMENT - INTRODUCTION

Read this license carefully. You agree that by using the itemized software package, you have

agreed to the software license terms and conditions. This agreement constitutes complete and
entire agreement between you and Liquid Controls with respect to this product.

1. Liquid Controls hereby grants to Licensee a nonexclusive

license to use DBManager (hereinafter referred to as
“Licensed Software”)

2. Under the License granted herein, Licensee may use the
eldized machine readable (executable code) copy of the

Software, including any subsequent updates which may
be provided. Licensee shall not, without Liquid Controls’
prior written consent, (a) rent, lease, lend, sublease or
otherwise transfer the materials hereunder; (b) remove
or obscure proprietary or copyright notices which may
be set forth on the Licensed Software; or (c) alter,
decompile, or disassemble the program.

3. One (1) copy of the Licensed Software, including any

software distributed on disks may be made for backup

purposes only. No other copies may be made or used
without the written consent of Liquid Controls.

4. Title. No title to ownership of any Licensed Software is
transferred to the Licensee.

5. Upgrades. License upgrades may become available for

the Licensed Software. Any cost associated with such
upgrades will solely be determined by Liquid Controls.

6. Warranty. Liquid Controls makes and licensee receives
no warranty express or implied and there are expressly
excluded all warranties of merchantability and tness for

a particular purpose.

7. Limitation of Liability. Licensee shall have the sole

responsibility for adequate protection and backup of

its data in connection with the Licensed Software. In
no event shall Liquid Controls be liable for (a) special,
indirect or consequential damages; (b) any damages

whatsoever resulting from loss of use, data, or prots,
product, inaccurate input or work delays, or any direct

property damage arising out of or in connection with this
agreement or the use or performance of the Licensed
Software.

8. Termination. Liquid Controls may terminate this software
license granted hereunder and require return of the
Licensed Software if Licensee fails to comply with these
license terms and conditions.

9. Licensee acknowledges that it has read this agreement,

understands it, and agrees to be bound by its terms, and

further agrees that this is the complete and exclusive

statement of the agreement between Liquid Controls
and Licensee, which supersedes and merges all prior
proposals, understandings, and all other agreements, oral
or written, between the parties relating to this agreement.

This agreement may not be modied or altered except by
written instrument duly executed by both parties.

10. This Agreement and performance hereunder shall be
construed and interpreted under the laws of the State of
Illinois.

11. If any provision of this agreement is invalid under any

applicable statute or rule of law, it is to that extent to be

deemed omitted.

12. Licensee may not assign or sublicense, without the prior
written consent of Liquid Controls, its rights, duties, or
obligations under this Agreement to any person or entity
in whole or in part.

13. The waiver or failure of Liquid Controls to exercise in any

respect any right provided herein shall not be deemed a
waiver of any further right hereunder.

3

INTRODUCTION - DBMANAGER OVERVIEW

DBManager Overview

DBManager is a software package that supports Liquid Controls’ (LC) Fueling Systems including DMS Delivery,
FlightConnect, and EZConnect. The software package includes three programs: LCP Setup (LCPSetup.exe),
DBManager (DBManager.exe), and Ofce User (OfceUser.exe).

LCPSETUP

LCP Setup congures the ofce computer for wireless communications.

• Wireless communication conguration of ofce computers.

• Communication test between ofce computers and the DMS and LCR 600 units.

DBMANAGER

DBManager serves as a le server/database manager, managing the master database of the fueling system on the
ofce computer (multiple fueling systems if required) and maintaining the databases of the units (DMS and/or LCR

600) in the network. It determines what database records have been added, edited, or deleted and ensures that the
databases on each unit (DMS and/or LCR 600) in the network match the master database. DBManager can be set
to automatically update the databases in the network or updates can be made manually. DBManager also provides

a window on the PC where users can verify the data transmissions into and out of the server, and it is capable of

retaining a log le to troubleshoot any wireless transmission issues that may occur.

• Database management for all DMS and LCR 600 in-cab units in a fueling system

• Database update scheduling

OFFICEUSER

Ofce User is a security application that congures user access to the fueling system ofce software including DMS
Delivery Ofce, FlightConnect Ofce, and EZConnect Ofce.

• User, password, and access (to ofce application software databases) setup.

LCP Setup

Ofce UserDBManager (Setup)

4

LC FUELING SYSTEMS - INTRODUCTION

LC Fueling Systems Overview

LC Fueling Systems (Delivery, EZConnect, FlightConnect) are automated data acquisition and management systems

designed for specic fueling applications. They acquire metrological and transaction data on fueling vehicles and
transmit the data to the ofce computers.

Main functions of an LC Fueling System include:

• Delivery and transaction data acquisition

• Database management

• Communication conguration and management

• Delivery and transaction data transfer

Deliver y

FlightConnect

CONNECT

Liquid Controls Positive Displacement Flowmeter Meter

DMS and LectroCount LCR-II

LectroCount LCR 600

LC Fueling System Components

METERING SYSTEM

Typically mounted to the back or side of a delivery

vehicle, the metering system accurately measures,

stops and starts the ow, and preserves the purity of

the metered product. A Liquid Controls metering system
can include the meter, LCR electronic register, strainer,
ETVC (temperature compensation) probe, air eliminator,
and control valve.

LC FUELING SOFTWARE

Delivery, EZConnect, FlightConnect Fueling System

software can run on a DMS in-cab computer, in
conjunction with a LectroCount LCR-II electronic register.
The DMS is an in-cab computer with a heavy-duty lap
pad interface. The LCR-II compiles metrological data

during custody transfers and is Weights & Measures
approved. FlightConnect Fueling System software can
also run on a LectroCount LCR 600 electronic register.
The LCR 600 also compiles metrological data during
custody transfers and is Weights & Measures approved.

DATA TRANSFER

LC fueling systems can transfer data via a serial output

to a device such as a Wi adaptor, RF transceiver, or

cell modem. Cell modems enable long distance wireless
data transmissions between LCR 600s and DMSs in

the eld and computers in the ofce. Cell modems and

service contracts must be purchased separately from a
cellular service provider. RF transceivers are designed

for short, line-of-sight wireless transmissions of data.
Serial Wi adaptors can be adapted to an existing Wi
network within the customer framework. Wi range

is typically very limited, but can be used if the Fueling
System uploads and downloads data from a location that

is Wi -enabled on the users network. Liquid Controls
does not provide Wi adaptors, however your distributor

or IT Professional should be able to recommend one. A

USB Flash Memory Device can also be used to transfer
data between the DMS and computers in the ofce.

Delivery

OFFICE

CONNECT

OFFICE

FlightConnect

Office

LC OFFICE SOFTWARE

Delivery Ofce, EZConnect Ofce, and FlightConnect
Ofce all contain a suite of programs for managing LC

fueling system databases and transferring fueling data

les into third-party software.

5

LC Fueling Systems - Components

DELIVERY VEHICLE

Metering System

• Metering

• Electronic Temperature Compensation

• Valve Control/Air & Vapor Elimination

• Electronic Registration

• Ticket Printing

Vehicle Application Software

• Data Acquisition

• Data Management

• Electronic Registration LCR 600 FlightConnect

• Ticket Printing specialized by application software

• Delivery Stop & Start

Delivery

CONNECT

FlightConnect

DATA TRANSFER

Wireless

RF, Cellular, & Wi

Manual

USB Memory Drive

OFFICE

DBManager

• Data Transfer DMS & LCR 600 to office application software

• Database Management

Office Application Software

• Data Transfer office application software to back office accounting software

• Database Management

FlightConnect

Office

Delivery

OFFICE

CONNECT

OFFICE

BACK OFFICE

DB Manager

Back office ERP or other accounting software

6