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
- Open CMD and change directory to your the RapidLog Program directory:
- cd “C:\Program Files (x86)\RapidLog”
- 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:
- DrSync.exe RLCOMPANY “C:\temp\driver.csv” ID
- After you execute the command you should see the letters I or U echoed. I stands for Imported U stands for Updated.
- 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.
- 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.
- After you have run the import open RapidLog and go to the Drivers page to verify the data that was imported looks good.
