This tutorial is about the use of Line Address for CSV import/export in ElasticRoute. Line address is broken down into different address parts. e.g Address 1. Address 2, Address 3, City, State, Postal Code and Country.
If your address format on the CSV file comes in the form of line address, ElasticRoute will combine the various line address inputs (Address 1, Address 2, Address 3, City, State, Postal Code, Country) from your CSV into the Address field for geocoding and locating your stop.
|Name||Address 1||Address 2||Address 3||City||State||Postal Code||Country|
How to Import Line Address
Step 1: Navigate to Calendar > Date
Step 2: Click on Import > Import from CSV
Step 3: Click on Choose file to select the file to upload. Click Upload.
Upon uploading of the CSV, the various line address inputs were combined into DummyAddress1 DummyAddress2 DummyAddress3 DummyCity DummyState DummyPostalCode DummyCountry as per show in the following screenshot.
Screenshot Of Stop
For CSV Export, only the Address field will be exported. The line address fields will not be included in the exported file useless the option to Include Line Address is checked.
|Dummy||DummyAddress1 DummyAddress2 DummyAddress3 DummyCity DummyState DummyPostalCode DummyCountry||DummyCity||DummyState||DummyPostalCode||DummyCountry|
If you wish to export the details of your Line Address information in the CSV, you may follow the steps to set it up.
How To Set Up
Step 1: Navigate to Settings > General.
Step 2: Scroll down to the Export Section, and check the option Include Line Address.
Step 3: Click Save.
|Name||Address||Address 1||Address 2||Address 3||City||State||Postal Code||Country|
|Dummy||DummyAddress1 DummyAddress2 DummyAddress3 DummyCity DummyState DummyPostalCode DummyCountry||DummyAddress1||DummyAddress2||DummyAddress3||DummyCity||DummyState||DummyPostalCode||DummyCountry|
Refer to How To Set Headers For Your CSV Export.