Office Locations

Office locations: https://www.aveva.com/en/about/about-aveva/locations/

Office spreadsheet: /content/dam/aveva/OfficeLocation.xlsx

Template: Office Template

Component: Office Location

Spreadsheet Management of Locations Data

Office location data is stored in an Excel spreadsheet hosted in AEM Assets. 

The Excel spreadsheet is named: OfficeLocation.xlsx.

Code Changes

The sheet format (number and order of columns) is fixed.

Any change in format would require code change (and deployment).

Authoring

Tags

Use AEM Tag paths for the following elements in the spreadsheet:

  • Office Type
  • Region
  • Country
  • City

If a tag type does not exist within the options above, then create it in AEM and publish it.

If, in a row, any tag path (such as region tag, country tag) entered is/are invalid, that tag value would be considered missing.

If any field is not required, the cell/column can be left blank.

To enter multiple values in a cell, please use '$' as separator between the values. For example /content/cq:tags/aveva/attributes/office_type/regional_office$/content/cq:tags/aveva/attributes/office_type/training_center

Office with More Than One Value

One new column (i.e. Additional Country Tag) has to be added (next to Country column) so that another country tag can be added for this exceptional case:

There are 5 locations for Dubai, 4 of which are all the same address.

These cards will get both a UAE Country tag and their own Country tag. For example - 'Country' would be Egypt and 'Additional country' would be UAE. Additional country would be left blank for other offices locations.

Workflow for Editing and Publishing

  1. Download spreadsheet from AEM Assets
  2. Edit and save spreadsheet
  3. Reupload spreadsheet to AEM Assets
  4. Republish Live Copy of this page: 

There should be no need to do the following to get changes to display:

  • Rollout from language-masters to Live Copy
  • Clear Akamai cache
  • Clear Adobe cache