Emailing Driver Letters

Topic:

How Do I Email Letters to Drivers?

Configuration:

To email driver letters you first must set up your mail server settings:

  1. Open your C:\Windows\RL5.ini file and look for the Data=Path
  2. Copy the data directory and navigate to the \RapidLog\Data\Company\settings.ini file
  3. Add a new [Mail] section in the ini file and following fields
    1. Server=(SMTP Server)
    2. Port=(SMTP Server Port)
    3. AuthUser=(SMTP Auth Username)
    4. AuthPassword=(Password)
    5. DefaultFrom=(Valid From email or same as Auth Email)
    6. DefaultReply=(Any reply email)
    7. LetterSubject=(Subject)
    8. LetterBody=(Body must be on a single line, no line breaks)

It should look something like this when you’re done:

[Mail]
Server=smtp.gmail.com
Port=465
AuthUser=user@gmail.com
AuthPassword=gmailpassword
DefaultFrom=user@gmail.com
DefaultReply=user@gmail.com
LetterSubject=Montly Review Letter
LetterBody=Please open the driver letter attachment and review.

Instructions:

  1. Make sure your drivers have a valid email address in their Driver Profile
  2. Go to the Reports Page and Select Simple Letters and select your date range and drivers to include
  3. Click on the Email to Drivers… button on the left

Driver Import – DrSync

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:

DRSyncTemplate.csv

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:

Order
Required
Field Name
Max Char Length
Notes
1
No
Tertiary ID Number
15
*This is required if ID Number is not used
2
Yes
ID Number
15
Must be unique. Alpha and numeric values accepted
3
No
Alternate ID Number
15
4
Yes
Last Name
100
5
Yes
First Name
100
6
No
Middle Initial
15
7
No
Address
100
8
No
City
100
9
No
State
5
10
No
Zip
10
11
No
Phone
22
12
No
Alternate Phone
22
13
Yes
Employee Type
1
F = Full time; P = Part time; I = Inactive ( F is default)
14
No
Group
10
Provides additional sorting of drivers for reports
15
Yes
Terminal Name
40
If NO exact match found, it will add a new terminal. The first 6 characters must be unique to each terminal.
16
No
Driver Manager
40
Matches via the Manager Code on the Company Page under the Driver Managers tab
17
No
Reply Address
1
T = Terminal; R = Region; C = Company (Used in Simple Letters)
18
No
Fuel Card Number
25
19
No
Alt Fuel Card Number
25
20
No
Driver License State and Number
20
21
No
Driver License Notes
20
22
No
Drivers License Expiration
10
MM/DD/YYYY
23
Yes
Hire Date
10
MM/DD/YYYY
24
No
Termination Date
10
MM/DD/YYYY (Leave blank if the driver is active)
25
No
Reserved
0
LEAVE THIS BLANK (“”,)
26
No
Birth Date
10
MM/DD/YYYY
27
No
Expiration Date 1
10
MM/DD/YYYY
28
No
Expiration Date 2
10
MM/DD/YYYY
29
No
Expiration Date 3
10
MM/DD/YYYY
30
No
Expiration Date 4
10
MM/DD/YYYY
31
No
Expiration Date 5
10
MM/DD/YYYY
32
No
Expiration Date 6
10
MM/DD/YYYY
33
No
Expiration Date 7
10
MM/DD/YYYY
34
No
Expiration Date 8
10
MM/DD/YYYY
35
No
Emergency Contact
100
36
No
Emergency Contact Phone
100
37
No
Email
128
38
No
Exclude From GPS Audit
1
Optional. 1 = True; 0 = False (Typically not used)
39
No
Driving Type
1
Optional. R=Over the Road; L = Local; K=Occasional; R is Default

06/21/2018 | Software Update

The following changes, fixes, and modifications are included in the 06/21/2018 Build of RapidLog.

  • Added Omnitracs and Shaw to EobrDownloader.exe
  • Fixed Omnitracs distances to use a day report for distance rather than the calculation from odometers.
  • Shaw should import distance as KM instead of Miles.
  • Fixed Violation Summary and Violation Percentage Summary reports to include 14, 15, and 16 classes
  • Fixed Violation List report options to include 14, 15, and 16 classes
  • Fixed Email of Letters to drivers. Added Port to the options.
  • Fixed the Mandatory 14-day Rest to default to the prior 14 days.
  • Fixed <1-minute violations we now only give a violation if it is >= 1 minute of time in violation.
  • Fixed Overview List export to text file to allow the Detail and Roster options correctly.
  • Added Notes/Remarks on the Log print option for EOBR log printing.
  • Fixed printing violation paragraph for Inactive drivers with Missing logs in Letters.

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

ELD Integration | Zonar

Topic:

How to Import Zonar ELD Data Into RapidLog.

Zonar:

  • Arguments:
    • /provider (Zonar)
    • /companycode (RLCompany Code)
    • /accountid (Zonar Account ID)
    • /username (Zonar Username)
    • /password (Zonar Password)
    • /daysback (defaults to 1)
    • /from (Date format: yyyy-mm-dd)
    • /to (Date format: yyyy-mm-dd)

  • Advanced Arguments:
    • /debug 1
      • /debug 1 enables the debug files to be saved during the download. The debug files are saved in a set of directories under the folder the EobrDownloader.exe file is running in. \HOSDebug\
    • /ui 1
      • /ui 1 will make the GUI show but it will be loaded with the options specified in the Command Line parameters.
    • /fm 1
      • /fm 1 specifies that it will process the Form and Manner violations. These are only available for some of the downloaders
    • /pause 1
      • /pause 1 will cause the EobrDownloader.exe to pause before closing so the output can be observed after running.

  • C:\Windows\RL5.ini Settings (optional):
    • [Directories]
      EobLogImportRoot=C:\ProgramData\RapidLog\Data (Tip: Match this to your Data= line)
    • Note: if this does not exist the downloads will go to \RapidLog\Data\EobLogImport\CompanyCode

  • Example BAT File for All Companies and Providers (prefered method):
    • “C:\Program Files (x86)\RapidLog\DownloadRunner.exe”
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -NewAudit HC -MI

  • Example BAT File for a Single Company and Provider:
    • “C:\Program Files (x86)\RapidLog\EOBRDownloader.exe” /provider Zonar /companycode MYRLCOMPANY /accountid ZonarAccountid /username ZonarUsername /password ZonarPass /daysback 14
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -NewAudit HC -MI

Instructions:

  1. Add the credentials for the ELD provider on the Company->Configure Download Page in RapidLog.
  2. Edit the Directories section in the C:\Windows\rl5.ini file by adding EobLogImportRoot=Your Data folder.
    • Example: EobLogImportRoot=C:\ProgramData\RapidLog\Data
  3. Open Notepad and setup the download, import and audit.  Save that file as a .bat file.
  4. Open Task Scheduler and schedule the .bat file to run once or twice daily.

ELD Integration | Telogis

Topic:

How to Import Telogis ELD Data Into RapidLog.

Telogis:

  • Arguments:
    • /provider (Telogis)
    • /companycode (RLCompany Code)
    • /password (Telogis Password)
    • /username (Telogis Username)
    • /urlcompany (Telogis Company URL)
    • /from (defaults to now – 1 day)
    • /to (defaults to now)
    • /daysback (defaults to 1)

  • Advanced Arguments:
    • /debug 1
      • /debug 1 enables the debug files to be saved during the download. The debug files are saved in a set of directories under the folder the EobrDownloader.exe file is running in. \HOSDebug\
    • /ui 1
      • /ui 1 will make the GUI show but it will be loaded with the options specified in the Command Line parameters.
    • /fm 1
      • /fm 1 specifies that it will process the Form and Manner violations. These are only available for some of the downloaders
    • /pause 1
      • /pause 1 will cause the EobrDownloader.exe to pause before closing so the output can be observed after running.

  • C:\Windows\RL5.ini Settings (optional):
    • [Directories]
      EobLogImportRoot=C:\ProgramData\RapidLog\Data (Tip: Match this to your Data= line)
    • Note: if this does not exist the downloads will go to \RapidLog\Data\EobLogImport\CompanyCode

  • Example BAT File for All Companies and Providers (prefered method):
    • “C:\Program Files (x86)\RapidLog\DownloadRunner.exe”
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -NewAudit HC -MI

  • Example BAT File for a Single Company and Provider:
    • “C:\Program Files (x86)\RapidLog\EobrDownloader.exe” /provider Telogis /companycode MYRLCOMPANY /password Telogispass /username Telogisusername /urlcompany Telogiscompanyurl /daysback 8
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -NewAudit HC -MI

Instructions:

  1. Add the credentials for the ELD provider on the Company->Configure Download Page in RapidLog.
  2. Edit the Directories section in the C:\Windows\rl5.ini file by adding EobLogImportRoot=Your Data folder.
    • Example: EobLogImportRoot=C:\ProgramData\RapidLog\Data
  3. Open Notepad and setup the download, import and audit.  Save that file as a .bat file.
  4. Open Task Scheduler and schedule the .bat file to run once or twice daily.

ELD Integration | Samsara

Topic:

How to Import Samsara ELD Data Into RapidLog.

Samsara:

  • Arguments:
    • /provider (Samsara)
    • /companycode (RLCompany Code)
    • /apikey (Samsara API Key)
    • /groupid (Samsara Group ID)
    • /from (defaults to now – 1 day. Date format yyyy-mm-dd )
    • /daysback (defaults to 1)

  • Advanced Arguments:
    • /debug 1
      • /debug 1 enables the debug files to be saved during the download. The debug files are saved in a set of directories under the folder the EobrDownloader.exe file is running in. \HOSDebug\
    • /ui 1
      • /ui 1 will make the GUI show but it will be loaded with the options specified in the Command Line parameters.
    • /fm 1
      • /fm 1 specifies that it will process the Form and Manner violations. These are only available for some of the downloaders
    • /pause 1
      • /pause 1 will cause the EobrDownloader.exe to pause before closing so the output can be observed after running.

  • C:\Windows\RL5.ini Settings (optional):
    • [Directories]
      EobLogImportRoot=C:\ProgramData\RapidLog\Data (Tip: Match this to your Data= line)
    • Note: if this does not exist the downloads will go to \RapidLog\Data\EobLogImport\CompanyCode

  • Example BAT File for All Companies and Providers (prefered method):
    • “C:\Program Files (x86)\RapidLog\DownloadRunner.exe”
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -NewAudit HC -MI

  • Example BAT File for a Single Company and Provider:
    • “C:\Program Files (x86)\RapidLog\EobrDownloader.exe” /provider Samsara /companycode MYRLCOMPANY /apikey Samsaraapikey /groupid Samsaragroupid /daysback 8
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -NewAudit HC -MI

Instructions:

  1. Add the credentials for the ELD provider on the Company->Configure Download Page in RapidLog.
  2. Edit the Directories section in the C:\Windows\rl5.ini file by adding EobLogImportRoot=Your Data folder.
    • Example: EobLogImportRoot=C:\ProgramData\RapidLog\Data
  3. Open Notepad and setup the download, import and audit.  Save that file as a .bat file.
  4. Open Task Scheduler and schedule the .bat file to run once or twice daily.

ELD Integration | Rand McNally – Driver Connect

Topic:

How to Import Rand McNally – Driver Connect ELD Data Into RapidLog.

Rand McNally - Driver Connect:

  • Arguments:
    • /provider (RandMcNallyELD)
    • /companycode (RLCompany Code)
    • /accesstoken (Rand McNally ELD Access Token)
    • /urlcompany (Rand McNally ELD Company ID)
    • /from (defaults to now – 1 day. Use the YYYY-MM-DD format)
    • /daysback (defaults to 1)

  • Advanced Arguments:
    • /debug 1
      • /debug 1 enables the debug files to be saved during the download. The debug files are saved in a set of directories under the folder the EobrDownloader.exe file is running in. \HOSDebug\
    • /ui 1
      • /ui 1 will make the GUI show but it will be loaded with the options specified in the Command Line parameters.
    • /fm 1
      • /fm 1 specifies that it will process the Form and Manner violations. These are only available for some of the downloaders
    • /pause 1
      • /pause 1 will cause the EobrDownloader.exe to pause before closing so the output can be observed after running.

  • C:\Windows\RL5.ini Settings (optional):
    • [Directories]
      EobLogImportRoot=C:\ProgramData\RapidLog\Data (Tip: Match this to your Data= line)
    • Note: if this does not exist the downloads will go to \RapidLog\Data\EobLogImport\CompanyCode

  • Example BAT File for All Companies and Providers (prefered method):
    • “C:\Program Files (x86)\RapidLog\DownloadRunner.exe”
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -NewAudit HC -MI

  • Example BAT File for a Single Company and Provider:
    • “C:\Program Files (x86)\RapidLog\EobrDownloader.exe” /provider RandMcNallyELD /companycode MYRLCOMPANY /accesstoken RandMcNallyELDaccesstoken /urlcompany RandMcNallyELDcompanyid /daysback 14
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -NewAudit HC -MI

Instructions:

  1. Add the credentials for the ELD provider on the Company->Configure Download Page in RapidLog.
  2. Edit the Directories section in the C:\Windows\rl5.ini file by adding EobLogImportRoot=Your Data folder.
    • Example: EobLogImportRoot=C:\ProgramData\RapidLog\Data
  3. Open Notepad and setup the download, import and audit.  Save that file as a .bat file.
  4. Open Task Scheduler and schedule the .bat file to run once or twice daily.

ELD Integration | Rand McNally – Connect

Topic:

How to Import Rand McNally – Connect ELD Data Into RapidLog.

Rand McNally - Connect:

  • Special Note:
    • You will need a login for the FourKites web service

  • Arguments:
    • /provider (RandMcNally)
    • /companycode (RLCompany Code)
    • /password (Rand McNally Password)
    • /username (Rand McNally Username)
    • /urlcompany (Rand McNally Company URL)
    • /datastore (defaults to PROD)
    • /from (defaults to now – 1 day. Use the YYYY-MM-DD format)
    • /daysback (defaults to 1)

  • Advanced Arguments:
    • /debug 1
      • /debug 1 enables the debug files to be saved during the download. The debug files are saved in a set of directories under the folder the EobrDownloader.exe file is running in. \HOSDebug\
    • /ui 1
      • /ui 1 will make the GUI show but it will be loaded with the options specified in the Command Line parameters.
    • /fm 1
      • /fm 1 specifies that it will process the Form and Manner violations. These are only available for some of the downloaders
    • /pause 1
      • /pause 1 will cause the EobrDownloader.exe to pause before closing so the output can be observed after running.

  • C:\Windows\RL5.ini Settings (optional):
    • [Directories]
      EobLogImportRoot=C:\ProgramData\RapidLog\Data (Tip: Match this to your Data= line)
    • Note: if this does not exist the downloads will go to \RapidLog\Data\EobLogImport\CompanyCode

  • Example BAT File for All Companies and Providers (prefered method):
    • “C:\Program Files (x86)\RapidLog\DownloadRunner.exe”
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -NewAudit HC -MI

  • Example BAT File for a Single Company and Provider:
    • “C:\Program Files (x86)\RapidLog\EobrDownloader.exe” /provider RandMcNally /companycode MYRLCOMPANY /password RandMcNallypass /username RandMcNallyusername /urlcompany RandMcNallycompany /datastore PROD /daysback 8
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -NewAudit HC -MI

Instructions:

  1. Add the credentials for the ELD provider on the Company->Configure Download Page in RapidLog.
  2. Edit the Directories section in the C:\Windows\rl5.ini file by adding EobLogImportRoot=Your Data folder.
    • Example: EobLogImportRoot=C:\ProgramData\RapidLog\Data
  3. Open Notepad and setup the download, import and audit.  Save that file as a .bat file.
  4. Open Task Scheduler and schedule the .bat file to run once or twice daily.

ELD Integration | PeopleNet

Topic:

How to Import PeopleNet ELD Data Into RapidLog.

PeopleNet:

  • Arguments:
    • /provider (PeopleNet)
    • /companycode (RLCompany Code)
    • /password (PeopleNet Password)
    • /urlcompany (PeopleNet Company URL)

  • Advanced Arguments:
    • /debug 1
      • /debug 1 enables the debug files to be saved during the download. The debug files are saved in a set of directories under the folder the EobrDownloader.exe file is running in. \HOSDebug\
    • /ui 1
      • /ui 1 will make the GUI show but it will be loaded with the options specified in the Command Line parameters.
    • /fm 1
      • /fm 1 specifies that it will process the Form and Manner violations. These are only available for some of the downloaders
    • /pause 1
      • /pause 1 will cause the EobrDownloader.exe to pause before closing so the output can be observed after running.

  • C:\Windows\RL5.ini Settings (optional):
    • [Directories]
      EobLogImportRoot=C:\ProgramData\RapidLog\Data (Tip: Match this to your Data= line)
    • Note: if this does not exist the downloads will go to \RapidLog\Data\EobLogImport\CompanyCode

  • Example BAT File for All Companies and Providers (prefered method):
    • “C:\Program Files (x86)\RapidLog\DownloadRunner.exe”
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\ForEachCompany.exe” RapidLog.exe [CompanyCode] -NewAudit HC -MI

  • Example BAT File for a Single Company and Provider:
    • “C:\Program Files (x86)\RapidLog\EobrDownloader.exe” /provider PeopleNet /companycode MYRLCOMPANY /password PeopleNetpass /urlcompany PeopleNetcompany
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -L RapidLogFormat
      “C:\Program Files (x86)\RapidLog\RapidLog.exe” MYRLCOMPANY -NewAudit HC -MI

Instructions:

  1. Add the credentials for the ELD provider on the Company->Configure Download Page in RapidLog.
  2. Edit the Directories section in the C:\Windows\rl5.ini file by adding EobLogImportRoot=Your Data folder.
    • Example: EobLogImportRoot=C:\ProgramData\RapidLog\Data
  3. Open Notepad and setup the download, import and audit.  Save that file as a .bat file.
  4. Open Task Scheduler and schedule the .bat file to run once or twice daily.