NFR: Create config file on SharePoint for market sites

[cogniSyb]

Context/Description

We should prepare the rollout of #663 for market repositories. Data currently residing in constants.js needs to go to constants.xlsx in SharePoint. When constants.js isn’t present, data from delayed.js needs to be copied instead.

Acceptance Criteria

Editor AC:

• Can change setting to check if an active campaign is running or OneTrust needs to scan the active scripts
• Can change appearance of search or login button in header
• Can change paths for trucks in Truck Configurator, if applicable
• Can set the locale of the website for the formatting of magazine dates

Non-functional AC:

• The file should be published after creation
• These rows in sheet helix-cookieValues will need to be present in all files:
  • PERFORMANCE_COOKIE
  • FUNCTIONAL_COOKIE
  • TARGETING_COOKIE
  • SOCIAL_COOKIE
  • DATA_DOMAIN_SCRIPT[^1]
  • COOKIE_CHECK[^2]
• These rows in sheet helix-fgrep need to be present in all files:
  • GIT_OWNER
  • GIT_REPO[^3]
  • GLOBAL_SITEMAP_URL
• The value for GIT_REPO in sheet helix-fgrep needs to be the git repository of the market site
• These rows in sheet helix-headerConfig need to be present in all files, and set accordingly[^4]:
  • SEARCH_DISABLED
  • LOGIN_DISABLED
• If a site contains the magazine
  • helix-magazineConfig should be present
  • DATE_LANGUAGE should be set to the locale of the site[^5]

[^1]: The OneTrust ID [^2]: Should be set to FALSE if not present [^3]: Needs to be the git repository name [^4]: For example: https://bahamas.macktrucks.com/ currently contains a link to search and should be disabled [^5]: For example: es-MX for https://www.macktrucks.com.mx/ and en-BS for https://bahamas.macktrucks.com/. See https://simplelocalize.io/data/locales/ to look up locales

Out of scope

• Other adjustments to delayed.js or other files retrieving constants.js. The changes of these files will come when syncing the repositories
• Moving AEM_ASSETS into constants.xlsx; this will be part of videohelper.js
• Repository https://github.com/hlxsites/vg-macktrucks-com-au already contains the file

Note

These repositories contain constants.js:

• [x] https://github.com/hlxsites/vg-macktrucks-bs
• [x] https://github.com/hlxsites/vg-macktrucks-ca
• [x] https://github.com/hlxsites/vg-macktrucks-com-ar
• [x] https://github.com/hlxsites/vg-macktrucks-com-bo
• [x] https://github.com/hlxsites/vg-macktrucks-com-co
• [x] https://github.com/hlxsites/vg-macktrucks-cl
• [x] https://github.com/hlxsites/vg-macktrucks-com-do
• [x] https://github.com/hlxsites/vg-macktrucks-com-ec
• [x] https://github.com/hlxsites/vg-macktrucks-com-emea
• [x] https://github.com/hlxsites/vg-macktrucks-com-gy
• [x] https://github.com/hlxsites/vg-macktrucks-com-museum
• [x] https://github.com/hlxsites/vg-macktrucks-com-ng
• [x] https://github.com/hlxsites/vg-macktrucks-com-ni
• [x] https://github.com/hlxsites/vg-macktrucks-com-pa
• [x] https://github.com/hlxsites/vg-macktrucks-com-pe
• [x] https://github.com/hlxsites/vg-macktrucks-com-ve
• [x] https://github.com/hlxsites/vg-macktrucks-cr
• [x] https://github.com/hlxsites/vg-macktrucks-gt
• [x] https://github.com/hlxsites/vg-macktrucks-hn
• [x] https://github.com/hlxsites/vg-macktrucks-sv
• [x] https://github.com/hlxsites/vg-macktrucks-tt

These repositories have data in delayed.js

• [x] https://github.com/hlxsites/vg-macktrucks-co-nz
• [x] https://github.com/hlxsites/vg-macktrucks-com-mx
• [x] https://github.com/hlxsites/vg-macktrucks-ht

Technical details

1. Copy the file constants.xlsx from vg-macktrucks-com folder in SharePoint to the market site folder
2. Remove rows and sheets of configuration that aren’t necessary
3. Replace values of configuration

Attachment / link to Figma

No response

[Kannan-CM]

Hi @cogniSyb, This is completed from our end.