Gasboy Fleet PLUS User Manual

Page 61

Text mode
Original mode

MDE-5079 Gasboy Fleet PLUS Installation and Implementation Guide to Passport Authorization Server (PAS) · December 2013

Page 5-9

Performing Device Import (Example)

Performing Device Import (Cards, Keys, Tags, or Manual Entries)

Using the CONCATENATE function again, put the two new Rule columns back together and
add a space between them. You will see that you have a rule named “10 gal Unleaded”.

Figure 5-15: Excel Formulas

Once this is all completed, return to your Original EXPORT file, and copy the respective
fields into it for the Card number, Group Rule, and Plate (Vehicle Number).

Go to the FHO software and select Import from the Devices tab.

Figure 5-16: Importing Fleet Management File

fx=LOOKUP(G7,$A$21:$A$22,$B$21:$B$22)

fx=LOOKUP(F2,$A$15:$A$18,$B$15:$B$18)

fx=CONCATENATE(A2,” “,B2)

fx=CONCATENATE(J11,” “,K11)