Liquid Controls DB Manager - Manual (Page 9)

9
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.
offICe edIT
The office edit software (FlightConnect Edit or EZConnect Edit) provides an interface where users can add, delete
and edit records in the fueling system master database. It also allows the user to easily import and export files into
and out of the database. The office edit software also allows users to validate or reject any records added or edited by
the units in the network for the master database.
offICe read
When the office read software (FlightConnect Read, or EZConnect Read) receives a transaction file, it converts any
records added or edited by the fueler into separate edit file (Editxxx.trn). Office read sends the edit file to the office
edit software where it must be validated for the master database or rejected
dms fuelIng sofTware
DMS FlightConnect and EZConnect fueling software allow fuelers to edit or add
records, such as new customers and other parameters, while they are in the field.
These new records are included in the transaction file and sent to the office where
the office read software separates them from the transaction data and send them the
office edit software for validation or rejection.
Compxxx.trn
Compxxx.trn
LC FuELIng
SoFTwARE
DBMAnAgER
LC READ
SoFTwARE
Compxxx.trn
READ
CONNECT
Read
FlightConnect
EDIT
CONNECT
Edit
FlightConnect
with Begin Validation
with Office Edit
DMS/LCR 600 Database Files
ACode.50X
AType.50X
Customer.50X
Dispatch.50X
FuelLoc.50X
FuelType.50X LoadLoc.50X
SysDefs.50X
TType.50X
Fueler.slf
Truck.slf
and others
LC EDIT
SoFTwARE
Master Database Files
ACode.50X
AType.50X
Customer.50X
Dispatch.50X
FuelLoc.50X
FuelType.50X LoadLoc.50X
SysDefs.50X
TType.50X
Fueler.slf
Truck.slf
and others
DB Manager
CONNECT
FlightConnect
Editxxx.trn
Xxxx.50X
updated .50X & .slf files .500 - Delivery files
.501 - FlightConnect files
.502 - EZConnect files
daTabase daTa flow
- InTroduCTIon
The DMS Delivery
Fueling System does not
support database data flow
from the DMS to the office.
LCR 600 FlightConnect does
not support database data flow
from the DMS to the office.