Liquid Controls EZConnect Office - Manual (Page 15)

15
#2 - FleetConnect Office Software
setup
3. populaTe daTabase
After you have installed the FleetConnect Office CD-
ROM, all of your company’s operational data can be
entered into the FleetConnect database. There are three
methods for populating the FleetConnect database:
• Key in data using FleetConnect Office user interface - FCEdit
• Key in data using the DMS i1000 lap pad
• Generate an ASCII text file from a third-party software
While generating an ASCII text file from a third-party
software is the most convenient and the least labor-
intensive, but keying in data using the DMS i1000 or
the office PC is very useful for day to day operations.
Instructions for entering data using the FleetConnect
Office FCEdit user interface begin on page 25.
Instructions for entering data using the DMS i1000 lap
pad are in the FleetConnect Operator's Manual E200-14.
asCII TexT fIles
Third-party software and company spreadsheets often
contain the vital operational data needed to populate the
FleetConnect database. ASCII text files containing the
operational data can be generated from most third-party
software.
Once the ASCII files are generated, FCEdit can
incorporate the data into the FleetConnect database.
The appendix of this manual contains examples of each
file and a table that includes a description of each field in
that file.
To load ASCII text files into the FleetConnect
Office database:
1. Generate ASCII text files from third-party software. See
appendix for file details.
2. From the desktop double-click FCEdit icon.
3. From the FleetConnect Edit window, click the Database
tab.
4. Under CSV Files, select the check boxes of the individual
files to be converted or click Select All to convert all files.
5. Click Read CSV.
6. From the Select Folder for Source CSV Files select the
folder that contains the ASCII text files then click OK. The
text files will convert into .502 files and automatically save
them into the FleetConnect database.
The button file is created by FCEdit when buttons are mapped. It
is not needed to populate the database
Button.csv Not Needed
seTup
ASCII Text File in Notepad
ASCII Text File in Excel
FCEdit Database Window
An IT technician may be needed to
generate the ASCII text files.
See page 25 for screenshot.