User guide

6
INSTALLATION & SETUP
Text File
MANUAL DATA ENTRY
TopopulatetheFlightConnectdatabasemanually,datamustbe
enteredintothe10FlightConnectEditle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letabs.This will create a .501 or .slf le for each le tab in the C:\DMS folder.
2. Typethedataintoeachofthele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lesintothemasterdatabasefolder.
TEXT FILE GENERATION
TopopulatetheFlightConnectdatabaseusingtextles,a
textle,inacommadelimitedformat,mustbegenerated
andthenconvertedinto.501and.slfles.
Third-partysoftwareandcompanyspreadsheetsoften
containmuchofthevitaloperationaldataneededto
populatetheFlightConnectdatabase.Thisdatamust
beconguredtomatchthe.txtleexamplesofeach
FlightConnectleintheappendixofthismanual.After
the.txtlesaregenerated,theymustbeloadedintothe
FlightConnectdatabase.
To populate the FlightConnect database with text
les:
1. GenerateASCIItextlesfromthird-partysoftware.Seeappendixforle
details.
2. OpenFlightConnect EditandintheDatabase Managementtabselect
thecheckboxesoftheindividuallestobeconvertedorclickSelect Alltoconvertallles.
3. ClickRead TXTandfromtheSelect Folder for Source TXT FilesselectthefolderthatcontainsthetextlesandclickOK.
Thetextleswillconvertinto.501and.slfles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lesintothemasterdatabasefolder.
DMS & LCR 600 DATABASE POPULATION
OncetheFlightConnectdatabaseispopulatedintheofce,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 les.
In order to populate the master database in FlightConnect
systems using USB memory devices, transfer the .501
and .slf les 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 les onto the DMS.
USB FlightConnect Database Updates
The System Denitions (SysDefs.501) le 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 Denitions
FlightConnect Database Population
AftertheFlightConnectOfce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letabsonFlightConnectOfce’suserinterface,FlightConnectEdit.Ortext
les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les:
•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Denitions)
•Truck.slf
•TType.501(TransactionType)