Liquid Controls DB Manager - Manual (Page 8)

8
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)
If the transaction files are sent wirelessly (Wifi , RF, or cellular) using
the Send Transactions to Office command, DBManager receives
the transaction files (.trn) and notifies the Office Read program that
the files have been received. Transmissions can be setup to be sent
automatically to the office.
offICe read (fIle ConversIon)
The office read software (Delivery Read, FlightConnect Read, or
EZConnect Read) converts the transaction files (.trn) received from
the fueling software into a .csv (text) or .xml file format (Delivery Read
typically converts .trn files into text files with a .dat extension). These
formats can be used for import into most third-party software programs
and spreadsheet applications.
baCk offICe sofTware
Back office software refers to any third-party software used for daily
bookkeeping. After the office read software converts transaction files into
a .csv (text) or .xml file format, the third-party software can import files
into its database.
CONNECT
Delivery
FlightConnect
DB Manager
Compxxx.trn
third-party
accounting software
or spreadsheet
application
LC FuELIng
SoFTwARE
DBMAnAgER
LC READ
SoFTwARE
BACk oFFICE SoFTwARE
Compxxx.trn
CompTran.xml
or CompTran.csv
READ
Delivery
READ
CONNECT
Read
FlightConnect
The DMS can transmit files via a USB memory device. If the transaction files
are sent via USB memory device, when a shift is finished, the fuelers download
the transaction files created during their shift using the Send Transactions to
Office command and return the USB device to the office. DBManager is not
required for USB data transfers. If the files are transferred via a USB memory
device, they must be copied from the USB device and pasted into the C:/DMS
folder. From there, Read.exe can convert them into text or XML files.
USB Memory Stick Data Transmission (DMS only)
InTroduCTIon -
TransaCTIon daTa flow