Topic:

How Do I Import a Driver List Into RapidLog?

File Format:

The driver import file must be saved as a CSV file and all fields must be quoted.

If a field is not used designate the field with a double quote “” (See below for all available fields).

Here is an example of what the CSV file should look like:

 

Import File with ID Number, Last Name, First Name, Address, City, State, Zip, Employment Type, and Hire Date:

“”,”1337″,””,”White”,”Walter”,””,”3828 Piermont Dr”,”Albuquerque”,”NM”,”87111″,””,””,”F”,””,””,””,””,””,””,””,””,””,”01/18/2009″,””,””,””,””,””,””,””,””,””,””,””,””,””,””,””,””
“”,”420″,””,”Jesse”,”Pinkman”,””,”9809 Margo St”,”Albuquerque”,”NM”,”87104″,””,””,”P”,””,””,””,””,””,””,””,””,””,”03/14/2011″,””,””,””,””,””,””,””,””,””,””,””,””,””,””,””,””
“”,”911″,””,”Schrader”,”Hank”,””,”4901 Cumbre Del Sur Ct”,”Albuquerque”,”NM”,”87111″,””,””,”F”,””,””,””,””,””,””,””,””,””,”04/09/2015″,””,””,””,””,””,””,””,””,””,””,””,””,””,””,””,””

Download Template:

Instructions:

In this example my RapidLog setup will be like so:

  • RapidLog Program Directory = C:\Program Files (x86)\RapidLog
  • RapidLog Company Code = RLCOMPANY
  • CSV File to Import = driver.csv
  • Directory where the CSV file is saved = C:\temp
  1. Open CMD and change directory to your the RapidLog Program directory:
    1. cd “C:\Program Files (x86)\RapidLog”
  2. Run Driver Sync program (DrSync.exe) against the company and file you want to import and how to match the records. This example shows matching by driver ID:
    1. DrSync.exe RLCOMPANY “C:\temp\driver.csv” ID
  3. After you execute the command you should see the letters I or U echoed. I stands for Imported U stands for Updated.
    1. On a brand new company if you see the letter u that means you have a duplicate driver ID.  Find the duplicate and make the correction to your import file and re-import.
    2. If you are running this file to update existing drivers note that the import will take the information from your driver file and overwrite any existing data.
  4. After you have run the import open RapidLog and go to the Drivers page to verify the data that was imported looks good.

Fields: