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″,””