Export Route Notes – Download POD Attached to Route Stops

 

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.

Exporting Route Notes

 

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.

Exporting Route Notes

 

Next, click on the gear icon next to the route that contains the notes and POD files you want to export.

Exporting Route Notes

 

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 Route Notes

 

Exporting Multiple Routes’ Notes From Your Routes List

To export multiple routes’ notes from your Routes List:

  1. First, check the boxes next to the routes that contain the notes you want to export;
  2. 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

 

Exporting Route Notes From the Routes Map

To export route notes from the Routes Map, first, go to Routes Map from the navigation menu.

Exporting Route Notes

 

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.

Exporting Route Notes

 

Next, click on the gear icon next to the route that contains the notes you want to export.

Exporting Route Notes

 

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 Route Notes

 

Exporting Multiple Routes’ Notes From the Routes Map

To export multiple routes’ notes from the Routes Map:

  1. First, check the boxes next to the routes that contain the notes you want to export;
  2. 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

 

Exporting Route Notes from the Route Editor

To export route notes from the Route Editor, first, go to Routes List from the navigation menu.

Exporting Route Notes

 

Next, click on the route that contains the notes you want to export to open it in the Route Editor.

Exporting Route Notes

 

The stops that contain notes have the corresponding note icon with a number next to their address.

Exporting Route Notes

 

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.

Exporting Route Notes

 

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.

Exporting Route Notes

 

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.

Exporting Route Notes

 

To export the file with selected items, click Export respectively.

Exporting Route Notes

 

Route Notes Export Glossary

ColumnDescription
 Note_TypeThe type of the note attached to a stop (note status).
 Note_Attachment_URLURL of the file (image, video, etc.) that is attached to the note.
 Note_ContentThe content of the note (custom text).
 Note_LatThe latitude coordinates of the location where the note was added to the stop.
 Note_LngThe longitude coordinates of the location where the note was added to the stop.
 Note_TimeThe timestamp that was created upon adding the note to the stop.
 Device_TypeThe type of the device that was used for adding the note to the stop (iPhone, Android, Web, etc.).
 Route_NotesThe 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_NameThe name of the route from which the note was exported.
Route_NoThe number of the route from which the note was exported.
 Route_Planned_TimeThe total estimated time required for completing the route from which the note was exported.
 Route_Total_DistanceThe total distance of the route from which the note was exported.
 Route_Planned_Total_Drive_TimeThe 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_TimeThe total estimated time required for servicing all stops on the route from which the note was exported.
 Route_Addresses_CountThe number of stops/addresses on the route (excluding the departure address) from which the note was exported.
 Scheduled_ForThe scheduled time and date of the route’s start.
 Route_Start_TimeThe time and date when the route started.
 Stem_In_TimeThe time spent on getting from the depot to the first stop on the route from which the note was exported.
 Stem_Out_TimeThe time spent on getting to the depot after visiting the last stop on the route from which the note was exported.
 Route_Wait_TimeThe total amount of time that a driver spent being inactive (waiting) while driving the route from which the note was exported.
 SPORHThe estimated number of stops visited per one on-road hour.
 TPORHThe estimated number of transactions performed per one on-road hour.
 Vehicle_AliasThe 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_EmailThe email address of the member assigned to the route from which the note was exported.
 Member_First_NameFirst name of the member assigned to the route from which the note was exported.
 Member_Last_NameLast name of the member assigned to the route from which the note was exported.

 

 

Was this article helpful?
Still can't find what you're looking for? Contact us
Route4Me

About Route4Me

Route4Me has over 40,000 customers globally. Route4Me's Android and iPhone mobile apps have been downloaded over 2 million times since 2009. Extremely easy-to-use, Route4Me's apps create optimized routes, synchronize routes to mobile devices, enable communication with drivers and customers, offer turn-by-turn directions, delivery confirmation, and more. Behind the scenes, Route4Me's operational optimization platform combines high-performance algorithms with data science, machine learning, and big data to plan, optimize, and analyze routes of almost any size in real-time.