Import Data – Planning Routes by Importing Data from Cloud-Based Storages

For your convenience, Route4Me enables you to effortlessly import data from the most popular cloud-based storage services. Importing files from cloud-based storage services is a quick and easy route data import method that allows you to increase the efficiency and flexibility of your routing operations. You can import files from virtually any device and any location without having to rely on external hardware storages or inputting the data manually. Currently, Route4Me supports data import from Google Drive, Dropbox, Box.net, Xero, and QuickBooks.

 

To plan a new route by importing a file from a particular cloud-based storage service, first, go to “Plan New Route” from the navigation menu.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Next, select “Import Data” from the corresponding window.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

After that, specify the preferred route parameters and then click on the corresponding button to proceed.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Next, select the preferred cloud-based storage service and then click on the “Authorize” button. Currently, Route4Me supports data import from Google Drive, Dropbox, Box.net, Xero, and QuickBooks.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Then, follow further instructions of the selected cloud-based storage service respectively. After reading the terms of service and privacy policy, click on the corresponding button to allow Route4Me to access the data on the selected cloud-based storage service.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

After the authorization process, select the file that you want to import from the corresponding cloud-based storage service. Before importing a spreadsheet with route data, make sure that it corresponds to Route4Me’s spreadsheet guidelines and requirements. Currently, Route4Me supports CSVXLS, and XLSX file formats.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Once you uploaded the spreadsheet, Route4Me processes the imported data and displays it in the corresponding window. For the system to process the data automatically, select the “Auto (attempt detection)” option respectively.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Alternatively, you can manually match column titles to the data contained in the corresponding columns.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Next, click “Continue to Review.”

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

In the “Verify Addresses on Map” window, you can view all imported and processed addresses on the map, as well as check their geocoding statuses. Green colored dots indicate that the corresponding addresses were successfully geocoded with “High Confidence.” Addresses that have yellow colored dots next to them should be reviewed and fixed accordingly.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

Geocoding is the process of giving/assigning latitude and longitude values/coordinates to street addresses for accurate location detection and GPS tracking.

 

To edit a particular address, first, click on it and then select “Edit” respectively.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

After that, make the required modifications in the corresponding field and then click “OK” to apply the changes.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

After reviewing the imported addresses, click “Finish Import” to plan the route.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Once the route is planned, it is optimized and then opened in the Route Editor where you can modify it, as well as added to the Routes List with all your routes.

Import Data - Planning Routes by Importing Data from Cloud-Based Storages

 

Visit Route4Me's Marketplace to Check out Associated Modules:

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