Owner's manual

15
#2 - FleetConnect Ofce Software
Setup
3. POPULATE DATABASE
After you have installed the FleetConnect Ofce 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 Ofce user interface - FCEdit
• Key in data using the DMS i1000 lap pad
• Generate an ASCII text le from a third-party software
While generating an ASCII text le from a third-party
software is the most convenient and the least labor-
intensive, but keying in data using the DMS i1000 or
the ofce PC is very useful for day to day operations.
Instructions for entering data using the FleetConnect
Ofce 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 les containing the
operational data can be generated from most third-party
software.
Once the ASCII les are generated, FCEdit can
incorporate the data into the FleetConnect database.
The appendix of this manual contains examples of each
le and a table that includes a description of each eld in
that le.
To load ASCII text les into the FleetConnect
Ofce database:
1. Generate ASCII text les from third-party software. See
appendix for le 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
les to be converted or click Select All to convert all les.
5. Click Read CSV.
6. From the Select Folder for Source CSV Files select the
folder that contains the ASCII text les then click OK. The
text les will convert into .502 les and automatically save
them into the FleetConnect database.
The button le 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 les.
See page 25 for screenshot.