RapidLog Standard Checkpoint Format

Topic:

How do I need to format my Checkpoint Data to Import into RapidLog?

Layout:

This will be for importing checkpoint information into RapidLog using the RapidLog Checkpoints (CSV v1) option.

You will format the CSV file in the following way:

Date, Time, Reserved, Type, Location, DriverId, FuelCard, Reserved

  • Date: (MM/DD/YYYY format)
  • Time: (2:00 pm or 14:00)
  • Type: (ACCIDENT, DELIVERY, FUEL, INSPECTION, PICKUP, or TOLL)
  • DriverID: (RapidLog Primary ID if matching record by driver ID)
  • FuelCard: (Fuel card number in RapidLog if matching record by Fuel Card Number)
  • Reserved: (Leave these fields blank “”)

Matching by ID Example:

“05/23/2018″,”14:00″,””, “TOLL”,”Scranton, PA”,”123456″,””,””
“05/23/2018″,”15:12″,””, “TOLL”,”Madison, WI”,”789101″,””,””
“05/23/2018″,”16:45″,””, “TOLL”,”Fort Collins, CO”,”538796″,””,””
“05/23/2018″,”17:00″,””, “TOLL”,”Portland, OR”,”472685″,””,””

Matching by Fuel Card Example:

“05/23/2018″,”14:00″,””, “FUEL”,”Scranton, PA”,””,”1953456875″,””
“05/23/2018″,”15:12″,””, “FUEL”,”Madison, WI”,””,”1953468535″,””
“05/23/2018″,”16:45″,””, “FUEL”,”Fort Collins, CO”,””,”1953467853″,””
“05/23/2018″,”17:00″,””, “FUEL”,”Portland, OR”,””,”1953468236″,””