Uploading Locations in Bulk

Overview

You may need to create a large number of locations in bulk. To do it, you can upload a list of locations using a CSV or XLS file.

Prerequisites

  • You need to have an account with a Super User or Operations role, or a custom role with rights to upload locations.


Solution

  1. Log in to the Street Smart web portal using your credentials and company ID.
  2. Click on the Locations tab.

    mceclip0.png

  3. Click on the Upload Locations button.

    mceclip1.png

  4. Click Get Template.

    mceclip2.png

    A zipped template in two formats (XLS and CSV) is downloaded.

  5. Extract the downloaded archive and open one of the template files. You can use any spreadsheet program (e.g., Excel, Google Sheets, etc.).

    mceclip4.png

  6. Enter information about locations to the template and save the file on your computer.
    Refer to the Creating Locations article for more information about each field.

    mceclip3.png

  7. Click Choose File and select the file with location information you have created.
  8. Check the Update Existing Records to overwrite information for existing locations with matching names. Otherwise, records for which there is a location with the same name will be skipped.
  9. Click Submit.

    mceclip6.png


Testing

  1. Navigate to Locations > Location Map.

    location.jpg

  2. Zoom in to check that uploaded locations are displayed in the correct places.

    mceclip7.png

    You can also click on a location to review its details:

    mceclip8.png

 

 

Back to top

Comments

0 comments

Article is closed for comments.