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.
Import
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 |
|---|---|---|---|---|---|---|---|
| Dummy | DummyAddress1 | DummyAddress2 | DummyAddress3 | DummyCity | DummyState | DummyPostalCode | DummyCountry |
How to Import Line Address
- Navigate to Calendar > Date
- Click on Import > Import from CSV
- 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
Export
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.
| Name | Address | City | State | Postal Code | Country |
|---|---|---|---|---|---|
| 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
- Navigate to Settings > General.
- Scroll down to the Export Section, and check the option Include Line Address.
- Click Save.
CSV Export After Enabling Line Address Export Feature 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.
