Export Route Notes – Download POD Attached to Route Stops
Table of Contents
Route4Me’s Route Optimization Web Platform provides multiple ways for adding notes to your routes which can serve as proof of delivery (POD) and proof of service. Route4Me’s Android and iOS multi stop route planner apps ensure instant data synchronization with the Web Platform and enable you to increase the security of your operations and make POD files instantly available across the devices connected to your account. Notes can contain delivery statuses, descriptive text, images, video and audio files as well as other types of important information. You can export POD files and route notes and can further use the exported files for sharing with your team members, making reports, conducting analysis or audits of your routing operations, and many other activities that can help you in growing and improving your last mile business.
Exporting Route Notes From Your Routes List
To export route notes and POD files from your Routes List, first, go to Routes List from the navigation menu.
The Notes column in your Routes List shows which routes contain attached notes and POD files and the number of the attached notes respectively. You can adjust the header in your Routes List in case it does not display the Notes column.
Next, click on the gear icon next to the route that contains the notes and POD files you want to export.
After that, hover your cursor over Export, and then, select Export Notes as CSV from the list. You can see the descriptions of all export items and how to customize the export file further in this tutorial.
Exporting Multiple Routes’ Notes From Your Routes List
To export multiple routes’ notes from your Routes List:
- First, check the boxes next to the routes that contain the notes you want to export;
- Next, click File in the toolbar, hover your cursor over Download as, and then, select Export Notes as CSV from the list.
You can see the descriptions of all export items and how to customize the export file further in this tutorial.
Exporting Route Notes From the Routes Map
To export route notes from the Routes Map, first, go to Routes Map from the navigation menu.
The Notes column in the Routes Map shows which routes contain attached notes and the number of the attached notes respectively. If the header in the Routes Map does not display the Notes column, right-click on the header and select the corresponding column from the list.
Next, click on the gear icon next to the route that contains the notes you want to export.
After that, hover your cursor over Export, and then, select Export Notes as CSV from the list. You can see the descriptions of all export items and how to customize the export file further in this tutorial.
Exporting Multiple Routes’ Notes From the Routes Map
To export multiple routes’ notes from the Routes Map:
- First, check the boxes next to the routes that contain the notes you want to export;
- Next, click File in the toolbar, hover your cursor over Download as, and then, select Export Notes as CSV from the list.
You can see the descriptions of all export items and how to customize the export file further in this tutorial.
Exporting Route Notes from the Route Editor
To export route notes from the Route Editor, first, go to Routes List from the navigation menu.
Next, click on the route that contains the notes you want to export to open it in the Route Editor.
The stops that contain notes have the corresponding note icon with a number next to their address.
In the Route Editor, first, click File in the toolbar, hover your cursor over Download as, and then, select Export Notes as CSV from the list.
Customizing the Route Notes Export File
Once you select one of the export methods, you can customize the export file for your convenience. When exporting route notes, the Export Route Data window provides the following export sections: Notes, Route, Time, Time Travel Details, Density, Driver, and User.
Check the boxes next to the items that you want to include in the export file. The added items are displayed in the right section of the window. To export the items in a specific order, click on the three dots icon next to the item that you want to move and drag it to the preferred position on the list.
To export the file with selected items, click Export respectively.
Route Notes Export Glossary
Column | Description |
---|---|
Note_Type | The type of the note attached to a stop (note status). |
Note_Attachment_URL | URL of the file (image, video, etc.) that is attached to the note. |
Note_Content | The content of the note (custom text). |
Note_Lat | The latitude coordinates of the location where the note was added to the stop. |
Note_Lng | The longitude coordinates of the location where the note was added to the stop. |
Note_Time | The timestamp that was created upon adding the note to the stop. |
Device_Type | The type of the device that was used for adding the note to the stop (iPhone, Android, Web, etc.). |
Route_Notes | The content of all notes attached to a stop (custom text). |
Route_ID | The unique internal identification number of the route from which the note was exported. |
Route_Name | The name of the route from which the note was exported. |
Route_No | The number of the route from which the note was exported. |
Route_Planned_Time | The total estimated time required for completing the route from which the note was exported. |
Route_Total_Distance | The total distance of the route from which the note was exported. |
Route_Planned_Total_Drive_Time | The total drive time of the route from which the note was exported (computed based on the Route_Planned_Time + Route_Planned_Total_Service_Time + Wait_Time). |
Route_Planned_Total_Service_Time | The total estimated time required for servicing all stops on the route from which the note was exported. |
Route_Addresses_Count | The number of stops/addresses on the route (excluding the departure address) from which the note was exported. |
Scheduled_For | The scheduled time and date of the route’s start. |
Route_Start_Time | The time and date when the route started. |
Stem_In_Time | The time spent on getting from the depot to the first stop on the route from which the note was exported. |
Stem_Out_Time | The time spent on getting to the depot after visiting the last stop on the route from which the note was exported. |
Route_Wait_Time | The total amount of time that a driver spent being inactive (waiting) while driving the route from which the note was exported. |
SPORH | The estimated number of stops visited per one on-road hour. |
TPORH | The estimated number of transactions performed per one on-road hour. |
Vehicle_Alias | The alias/name of the vehicle associated with the route from which the note was exported. |
Vehicle_ID | The unique identification number of the vehicle associated with the route from which the note was exported. |
Member_ID | The identification number of the member assigned to the route from which the note was exported. |
Member_Email | The email address of the member assigned to the route from which the note was exported. |
Member_First_Name | First name of the member assigned to the route from which the note was exported. |
Member_Last_Name | Last name of the member assigned to the route from which the note was exported. |
Visit Route4Me's Marketplace to Check out Associated Modules:
- Routing
Route Management
- Operations
Ultra High Resolution Route Mapping