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................................
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.
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 Office User (OfficeUser.exe). LCPSetup LCP Setup configures the office computer for wireless communications. • Wireless communication configuration of office computers.
LC Fueling Systems - Introduction LC Fueling Systems Overview LC Fueling Systems (Delivery, EZConnect, FlightConnect) are automated data acquisition and management systems designed for specific fueling applications. They acquire metrological and transaction data on fueling vehicles and transmit the data to the office computers.
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, & Wifi Manual USB Memory Drive OFFICE DBMa
LC Fueling Systems - Data Flow FlightConnect LC Fueling Software DMS/LCR 600 Database Files Delivery CONNECT ACode.50X AType.50X Customer.50X Dispatch.50X FuelLoc.50X FuelType.50X LoadLoc.50X SysDefs.50X TType.50X Fueler.slf Truck.slf and others Compxxx.trn DB Manager DBManager Compxxx.trn updated .50X & .slf files .500 - Delivery files .501 - FlightConnect files .502 - EZConnect files Transaction & Database Files Database Files Compxxx.
Introduction - Transaction Data Flow Transaction Data Flow DMS & LCR 600 Fueling Software (dATA cAPTURE) After each delivery, the LC fueling software compiles the metrological, transaction, customer, driver, and product data into transaction files (.trn). The transaction files are then sent to the office PC either wirelessly (Wifi , RF or cellular), or they are downloaded to a USB memory device (DMS only). db mANAGER (Data Transfer) Delivery FlightConnect LC Fueling Software CONNECT Compxxx.
Database Data Flow - Introduction Database Data Flow dBManager (Database Manager) DBManager serves as a file server/database manager, identifying changes to the master database of the fueling system (multiple fueling systems if required) and maintaining the database of the units (DMS and/or LCR 600) in the network. It determines which master database records have been added, edited, or deleted and adjusts the databases on each unit (DMS and/or LCR 600) in the network to match the master database.
Installation & Setup - Overview DBManager Installation Overview Prerequisites Prior to installation of any LC fueling system office software, ensure that all of the fuel delivery systems hardware components are installed. To complete DBManager setup and Office User setup, the office fueling software (Delivery Office, EZConnect Office, FlightConnect Office) must be installed. DBManager Installation Prerequisites: 1.
Software - Installation Software Installation To install DBManager software, insert the DBManager CD-ROM into your office PC (or click on the the setup. exe file supplied by Liquid Controls). Installation should begin automatically. Follow the DBManager installation wizard directions until installation is complete. If the installation does not begin automatically, use your browser to locate the setup.exe application file on the CD-ROM and click on it to begin the installation.
Setup - DBManager DBManager DBManager is a file server/database manager, managing the master database of the fueling system on the office 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 - setup DBManager Setup Setting up the DBManager is comprised of determining what files need to be sent between the computer and DMS and LCR 600 units in the network, where those files should be sent, and when they should be sent. All settings required for setup are accessed through the DBManager Setup window.
Setup - DBManager Register File Server Nodes Registering the files server nodes in the network entails identifying the node of each DMS and LCR 600 in the fueling system and entering them into DBManager. To register the DMS and LCR 600 units in DBManager: 1. Click the DBManager icon. 2. From the Database Manager window, click Setup. 3. From the Setup Database Manager window, under Registered Filed Server Nodes, click Add. 4.
DBManager - setup Set Master File List Setting the Master File List entails selecting which set of master database files will be checked for additions and edits and scheduling the frequency of the checks. To set the Master File List in DBManager: 1. From the Setup Database Manager window, under Registered Applications, click Set Master File List. 2. From the Master File List window, click Add. 3.
Setup - DBManager Set Node List Setting the node list designates which nodes (DMS and LCR 600) will receive database updates from the selected master database. To set a Node List in DBManager: 1. From the Setup Database Manager window, under Registered Applications, highlight a Registered Application from the list and click Set Node List. A Set Node List button is also available in the Master File List window.
LCP Setup - setup LCP Setup LCP Setup sets up the communication link at your PC or server in the office, configuring the office computer for wireless communication. LCP Setup contains settings for IP configurations (Wifi and cellular) and serial configurations (radio and direct serial cable). For successful data transmission, the settings in LCP Setup must be configured to match the communication settings of the DMSs, LCR 600s, and wireless transmission devices in the LC fueling network.
setup - LCP Setup LCP Setup Test Node: The unique node address for the DMS or LCR 600 which will be tested for communication. This is the node address used by DBManager (Liquid Controls’ database management software for the office computer) to identify the units in the fueling system network. This field value must be unique among units in the network and have a matching Node # in the Registered Files Server Nodes of the DBManager. IP Config: Clicking the button activates IP Configuration settings.
Office User - setup Office User Setup Office User Rights is an optional application used to define users and passwords, and database access via office edit software (EZConnect Edit and FlightConnect Edit). To hide and restrict access, there is no desktop shortcut for Office User. The Office User application is located in the folder where the DBManager software suite was installed (typically C:\ DMS). To set up office user rights: DBManager must be set up before beginning Office User setup. 1.
Liquid Controls 105 Albrecht Drive Lake Bluff, IL 60044 (847) 295-1050 SAMPI Via Amerigo Vespucci 1 55011 Altopascio (Lucca), Italy +39 0583 24751 IDEX Fluid and Metering Pvt. Ltd. Survey No. 256, Alindra Savli GIDC, Manjusar Dist. Vadodara 391 770 Gujarat, India +91 2667 662001 Toptech Systems 1124 Florida Central Parkway Longwood, FL 32750 (407) 332-1774 Nateus Business Park Nieuwe Weg 1-Haven 1053 B-2070 Zwijndrecht (Antwerp), Belguim +32 (0)3 250 60 60 Faure Herman Route de Bonnetable B.P.
