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
- Download spreadsheet from AEM Assets
- Edit and save spreadsheet
- Reupload spreadsheet to AEM Assets
- 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