Liquid Controls EZConnect Office - Manual (Page 24)

24
operaTIon
Read CSV Browser
Write CSV Browser
FCEdit Database Tab
fCedit
FCEdit is FleetConnect Office’s user interface. There
are seven tabs at the top of FleetConnect Office window.
The Database tab in FCEdit provides commands for
converting, reading, or writing CSV files, selecting
a database, and validating records that have been
changed in the field. The remaining tabs at the top of
the FleetConnect Office window are interfaces for each
FleetConnect database file. In these tabs, the records of
the file can be viewed, edited, added, or deleted from the
database.
fCedit - database Tab
The Database tab serves as the home to many important
FCEdit commands, Read CSV, Write CSV, Begin
Validation, and Select Database. Messages concerning
the progress of these commands are reported in the
white status window at the bottom of the tab. The Clear
Display button clears the status window.
read Csv and WrITe Csv buTTons
Read CSV converts .csv files in the FleetConnect
database into .502 files. Write CSV converts .502
files into .csv files. The check boxes, to the right of
the buttons, determine which FleetConnect files are
converted. The Select All button checks each box.
The Clear All button unchecks each checked box. The
Success, Errors, and Totals of each file conversion are
displayed in the columns on the right side of the window.
To use read Csv and Write Csv:
1. Open FCEdit and click the Database tab.
2. Under CSV Files, select the check boxes of the individual
files for conversion or click Select All to convert all files.
3. Click Read CSV, to convert .csv files to .502 files, or
Write CSV, to convert .502 files to .csv files.
4. When the Select Folder for Source CSV Files (for Read
CSV) or the Select Folder for Target CSV Files (for
Write CSV) window opens, select a folder where the .csv
files (for Read CSV) or the .502 files (for Write CSV) will
be placed.
5. Click OK. The files generated will be placed in the
C:\DMS folder.
dMs i1000 fleeTConneCT daTabase updaTes
In order to update the FleetConnect database on the
DMS i1000s in the field, transfer the .502 files created by
the Read CSV to the DMS i1000s via USB memory stick
or wireless transmission. Use the Retrieve Database
Updates command on the DMS i1000 to pull all of the
database files onto the DMS i1000.
FleetConnect Read (FCRead) Icon