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.
Next, select “Import Data” from the corresponding window.
After that, specify the preferred route parameters and then click on the corresponding button to proceed.
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.
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 CSV, XLS, and XLSX file formats.
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.
Alternatively, you can manually match column titles to the data contained in the corresponding columns.
Next, click “Continue to Review.”
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.
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.
After that, make the required modifications in the corresponding field and then click “OK” to apply the changes.
After reviewing the imported addresses, click “Finish Import” to plan the route.