How To Use Line Address For CSV Import/Export

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.

Example of Line Address
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

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

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.

Default CSV Export
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

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.

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.