How to Export a Report from Rapidlog

Topic:

How to Export a Report from Rapidlog

Instructions:

  1. Open RapidLog, click on “Reports”

  2. Select the report you wish to export (Note – only the reports listed below are able to be exported)

    Violation list
    Driver List
    Overview List
    Dated Recap
    Current Recap
    Violation Summary
    Audit Summary
    Audit Violation List
  3. Click “Export as Text”

  4. From the start menu, open the “Run” Program

  5. Type in “Rl5.ini” to open the Rl5.ini notepad document, click “OK”

  6. From the Rl5.ini text document, copy the text line following the word “Data”

  7. Open File Explorer, paste in what you copied from the Rl5.ini into the text field to take you to the data file of RapidLog.

  8. Click on the folder of the company name where you exported the data from in RapidLog (Labeled TEST in the examples below)

  9. Click on the “Export” folder

  10. Here is your Exported data

Instructions with Images:

Step 1: Open RapidLog, click on “Reports”

Step 2:

  • Select the report you wish to export (Note – only the reports listed below are able to be exported)

    Violation list
    Driver List
    Overview List
    Dated Recap
    Current Recap
    Violation Summary
    Audit Summary
    Audit Violation List


Step 3: Click “Export as Text”

 

Step 4: From the start menu, open the “Run” Program 

Step 5: Type in “Rl5.ini” to open the Rl5.ini notepad document, click “OK”

Step 6: From the Rl5.ini text document, copy the text line following the word “Data”

Step 7: Open File Explorer, paste in what you copied from the Rl5.ini into the text field to take you to the data file of RapidLog. 

Step 8: Click on the folder of the company name where you exported the data from in RapidLog (Labeled TEST in the examples below)

 

Step 9: Click on the “Export” folder

Step 10: Here is your Exported data

How to use RLTxtExporter

Topic:

RlTxtExporter can dump RapidLog data into text files that can be imported into another database.

Instructions:

  1. From your start menu, do a search for “Run”

  2. Type “Rl5.ini” into the text box. Click “OK”. This will bring up the Rl5.ini file in notepad.

  3. In the Rl5.ini notepad text document, copy the file location labeled “Program”

  4. Open File Explorer, paste the file location into the text field.

  5. Open “RlTxtExport.exe”

  6. Click “Settings”

  7. On the “Export Path” text field, click the folder icon on the right

  8. Choose an export path (Meaning the location the files you export will show up on your computer) Click “OK”

  9. Click “Export Company” on the left, then click “Export” on the bottom right.

  10. Your files will export to the desired location.

Instructions with Images:

Step 1: From your start menu, do a search for “Run”

Step 2: Type “Rl5.ini” into the text box. Click “OK”. This will bring up the Rl5.ini file in notepad.

Step 3: In the Rl5.ini notepad text document, copy the file location labeled “Program”

Step 4: Open File Explorer, paste the file location into the text field.

Step 5: Open “RlTxtExport.exe”

Step 6: Click “Settings”

Step 7: On the “Export Path” text field, click the folder icon on the right

Step 8: Choose an export path (Meaning the location the files you export will show up on your computer) Click “OK”

Step 9: Click “Export Company” on the left, then click “Export” on the bottom right.

Step 10: Your files will export to the desired location.

Add Custom Logo to Reports

Topic:

How Do I Add a Custom Logo to My Reports?

Instructions:

  1. Save your logo in a Bitmap format .BMP and name the file LOGO.BMP
    1. Note: Your image size should not exceed 300 x 300 px
  2. Open up your Data directory in Windows Explorer
    1. Note: If you are not sure where your data directory is located you can find that out by looking at your C:\Windows\rl5.ini configuration file
  3. Double click on the folder with your company code
  4. Copy and paste the your LOGO.BMP file in the company directory
  5. This will overwrite the default RapidLog logo
  6. Run a report to make sure everything looks the way you want it to

Customize Smart/Simple Letter Paragraphs

Topic:

How Do I Change the Paragraphs on my Smart or Simple Letters?

Instructions:

  1. Smart Letters and Simple Letters share the same paragraphs so changing the paragraphs in one will change them in the other. So it is best to use Simple Letters to preview your customizations even if you normally use Smart Letters to actually print your driver letters.

  2. To customize the letter paragraphs go to the Reports page and click on Simple Letters to select it. Then in the left side of the page click Advanced. At the bottom click on the Paragraphs tab.

  3. Each paragraph is used in different areas of the letter. You will see in the Violation paragraph that it includes [DriverName] in the beginning. That is the correct way to use the field designators.

  4. There are several special field designators that can be used in the letter paragraphs.

  5. The brackets [] around each entry are required. The designators are replaced by the data values for that field when the letter is printed. You can include any of these field designators in any of the paragraphs. Although they make more sense in some paragraphs than others.

  6. Most of the items relate directly to information assigned on the Drivers page.

  7. After you have made the desired changes to a paragraph you must click the Save button on the page. You can then Preview the letters to see your changes.

Fields:

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