beautypg.com

Reasons for errors – Gasboy TopKAT Operation Manual User Manual

Page 146

background image

Appendix E: Loading TopKAT Files from Microsoft® Excel®

Transferring Vehicle Records from Excel to TopKAT

Page E-6 MDE-4338A TopKAT™ Fuel Management System Operation Manual · February 2009

Reasons for Errors

The system is expecting all of the information to be entered in exact order.

• When you copied your records from Excel, you did not highlight all of the columns.
• You mistakenly copied the header rows.
• You entered fields in your Excel form that exceeded the maximum length or maximum

number.

• One of the records you are transferring already exists in your TopKAT system or on your

list. (Key numbers and vehicle number/department combinations must be unique in the
TopKAT system).

If your list contains all of the records you want in your TopKAT vehicle file, you can first use
the TopKAT clear file command to erase all existing vehicle records so you can start with a
clean download. To do this:

1

Sign back onto the system with the TopKAT password.

2

Do the following in sequence:

Type CL F

Press ENTER.

Type 1

Press ENTER.

Type YES

Press ENTER.

Press ENTER again.