Exporting Route Notes

Route4Me’s Web Platform provides multiple ways to effortlessly add notes to your routes as well as to export them. Route4Me’s Android and iOS apps ensure instant data synchronization with the Web Platform and enable you to increase the security of your operations. Notes can contain delivery statuses, descriptive text, images, video and audio files as well as other types of important information. Exported route notes can be used 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 business.

 

Exporting Route Notes From Your Routes List

To export route notes 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 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 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. Learn how to view the notes attached to a particular stop here.

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

You can learn more about exporting route data here.

 

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