Import Data – Plan Routes by Importing Data from the Cloud

For your convenience, Route4Me route optimization software enables you to effortlessly import route planning data from the most popular cloud-based storage services. Importing files containing delivery addresses and GPS coordinates 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 route optimization operations. You can import files from virtually any device and any location without having to rely on external hardware storage or inputting the data manually. Currently, the Route4Me Route Planner enables you to plan routes with cloud data files and supports data import from Google Drive, Dropbox, Box.net, Xero, and QuickBooks.

 

To plan routes with cloud data files 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 the Route4Me route planning software 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 planning 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 with customers’ delivery addresses, Route4Me routing software processes the imported routing data and displays it in the corresponding window. For the route optimization 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 shipping addresses were successfully geocoded with High Confidence. The delivery 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 multi-stop 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

 

 

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

About Route4Me

Route4Me has over 34,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.

Leave a Reply

Your email address will not be published. Required fields are marked *