Locations

You can set up a location hierarchy so that locations can be added to records.

To open location settings, open the settings and select Locations from the Project settings section of the menu.

Add locations

You can add locations directly in the settings or update the hierarchy by using the Excel import sheet. The Location field in the record displays the selected location and its parents.

  1. To add a location to the top level of the hierarchy:
    1. At the top of the grid, select Add new row.
    2. Enter the name and then select Done.
  2. To add a child location:
    1. Hover over the parent location and then select (Add) on the row.
    2. Enter the name and select Done.
  3. To copy a location:
    1. To highlight the location, select it, and then select Cancel.
    2. On the navigation toolbar, select (Copy)

      Only the selected location, and not any of its children, is copied. The new location is added under the same parent as the copied one.

    3. Edit the name and select Done.

Edit locations

You can edit locations directly in the settings or update the hierarchy using the Excel import sheet.

You can the edit of the name of a location by selecting it in the hierarchy, make changes, and select Done. The following steps outline how to update the hierarchy using the Excel import sheet.
  1. On the navigation toolbar, select (Import/Export) > Export to Excel.

    The existing locations are downloaded in an Excel file.

  2. Open the Excel file.
  3. In the Level 1 to Level 10 columns, add, edit, or delete the locations.
    Note:
    • If you enter items into different columns of the same row, the item in the right column is added as a child of the item to its left.
    • When you upload the file into ProjectSight, the following items aren't added:
      • Items that are outside of the Level columns. For example, In the settings, an item isn't added for 1 - Item because it's not in a labeled Level column.
      • Items without a defined parent (an item in the next column to the left, either in the same row or the one above). For example, If you add an item in the Level 2 column, there must be an item in the Level 1 column.
      • Duplicate items at the same level. The first item is imported, and the second one is ignored. The comparison isn't case-sensitive.
  4. Save the Excel file.
  5. In ProjectSight, open the location settings.
  6. On the navigation toolbar, select (Import/Export) > Update from Excel.
  7. Select the Excel file to import.

    The hierarchy, which is sorted alphabetically, is updated to match the file.

Delete locations

You can delete locations that are in use. A deleted location remains linked to a record if it was previously selected, but you can't select the deleted location for anything else.

  1. To delete one location, hover over it and select (Remove) on the row.
  2. To delete multiple locations:
    1. To highlight the first location, select it and select Cancel.
    2. For each subsequent location, press Shift while you repeat the previous step.
    3. On the navigation toolbar, select (Remove).