Liquid Controls FlightConnect Office - Manual (Page 6)

6
InsTallaTIon & seTup
Text File
manual daTa enTRy
To populate the FlightConnect database manually, data must be
entered into the 10 FlightConnect Edit file tabs. Instructions are in
the FlightConnect Edit section of this manual.
To populate the FlightConnect database manually:
1. Open FlightConnect Edit and click open the ten file tabs. This will create a .501 or .slf file for each file tab in the C:\DMS folder.
2. Type the data into each of the file tabs until the FlightConnect database is created. See Flie Tabs section of this manual.
3. Create a new folder in C:\DMS for the FlightConnect master database.
4. Move the .501 or .slf files into the master database folder.
TexT fIle GeneRaTIon
To populate the FlightConnect database using text files, a
text file, in a comma delimited format, must be generated
and then converted into .501 and .slf files.
Third-party software and company spreadsheets often
contain much of the vital operational data needed to
populate the FlightConnect database. This data must
be configured to match the .txt file examples of each
FlightConnect file in the appendix of this manual. After
the .txt files are generated, they must be loaded into the
FlightConnect database.
To populate the FlightConnect database with text
files:
1. Generate ASCII text files from third-party software. See appendix for file
details.
2. Open FlightConnect Edit and in the Database Management tab select
the check boxes of the individual files to be converted or click Select All to convert all files.
3. Click Read TXT and from the Select Folder for Source TXT Files select the folder that contains the text files and click OK.
The text files will convert into .501 and .slf files and automatically save them in the C:\DMS folder.
4. Create a new folder in C:\DMS for the FlightConnect master database.
5. Move the .501 or .slf files into the master database folder.
dms & lCR 600 daTabase populaTIon
Once the FlightConnect database is populated in the office, the
databases of the DMS or LCR600 units will need to populated.
This is done through DBManager, or via USB (DMS units only).
An IT technician may be needed to
generate the ASCII text files.
In order to populate the master database in FlightConnect
systems using USB memory devices, transfer the .501
and .slf files created by FlightConnect Edit into the DMS
subfolder on the USB device. Take the USB to the DMS
and use the Retrieve Database Updates command on the
DMS to pull all of the database files onto the DMS.
USB FlightConnect Database Updates
The System Definitions (SysDefs.501) file is unique in
that it determines settings on the FlightConnect LCR
600 and DMS interface. Because of this, SysDefs.501
should be populated manually in FlightConnect Edit.
System Definitions
flightConnect database population
After the FlightConnect Office software is installed, the next step is to populate the FlightConnect database with all the
pertinent data from your company’s operations. There are two methods for populating the FlightConnect database.
Data can be keyed in manually, in the file tabs on FlightConnect Office’s user interface, FlightConnect Edit. Or text
files can be generated from your existing third-party accounting or spreadsheet software and imported into the
FlightConnect database. Typically, a combination of both methods is used to populate the database.
The FlightConnect database consists of 10 files:
• ACode.501 (Airport Code)
• AType.501 (Aircraft Type)
• Customer.501
• Fueler.slf • FuelLoc.501 (Fuel Location)
• FuelType.501
• LoadLoc.501 (Load Location) • SysDefs.501 (System Definitions)
• Truck.slf
• TType.501 (Transaction Type)