Tenant Branding Master

Introduction

The Tenant Branding Details sheet captures URL-based resources required for tenant-level branding, including banners, logos, and state emblems. These branding elements appear across citizen-facing and administrative modules, making correct URL formatting essential.

To ensure data quality, strict URL validation rules are applied across all fields.

Tenant Template: Tenant Master

---

Data Table

S. No.	Banner URL	Logo URL	Logo URL (White)	State Logo
1	https://en.wikipedia.org/wiki/logo	https://en.wikipedia.org/wiki/logo	https://en.wikipedia.org/wiki/logo	https://en.wikipedia.org/wiki/logo

Note: This is a sample row only. Actual URLs must comply with the validation rules described below.

---

Procedure

Data Definition

Sr. No.	Column Name	Data Type	Data Size	Mandatory?	Definition / Description
1	Banner URL	Text (URL)	512	Yes	Public-facing banners displayed on landing screens. Must be a valid full URL.
2	Logo URL	Text (URL)	512	Yes	Primary tenant logo used across the application. Strict URL formatting required.
3	Logo URL (White)	Text (URL)	512	Yes	Light-theme version of the tenant logo. Must follow a valid URL structure.
4	State Logo	Text (URL)	512	No	Official country or state emblem associated with the tenant. Must be a valid website URL.

---

Steps to Fill Data

1. Download the Tenant Branding Details template.

2. Review all column headers and their definitions from the Data Definition section.

3. For each row:

   1. Fill Banner URL (mandatory).

   2. Fill Logo URL (mandatory).

   3. Fill Logo URL (White) (mandatory).

   4. Fill State Logo (optional).

4. Ensure every URL begins with:

   1. http://

   2. or https://

5. Do not enter:

   1. Relative paths such as ./logo.png

   2. Filenames such as logo.png

   3. URLs without a protocol, such as www.example.com

6. Once all entries are filled, verify them against the Excel validations.

7. Save and share the sheet for MDMS ingestion.

---

Excel Validation Framework

The sheet uses uniform URL validation rules to maintain correctness and prevent ingestion failures.

Types of Validations Applied

Validation Type	Description
URL Format Validation	Ensures values begin with http:// or https:// and follow proper URL structure.
Character Restriction	Prevents unsupported characters or incomplete URL formats.
Input Sanitization	Blocks entries such as raw text, file names, or relative paths.

---

Excel-Level Validation Rules

1. URL Format Validation

All URL fields must:

• Start with http:// or https://

• Contain no spaces

• Be complete URLs (no relative or partial values)

Validation Type: Custom Formula Applied On: Columns A, B, C, D (Rows 2 to 2000)

2. Rejection of Unsupported Inputs

The sheet rejects:

• Relative paths (./image.png)

• File names (logo.png)

• URLs without protocol (www.example.com)

Mandatory fields are validated again during MDMS/API ingestion.

---

Validation Row Mapping

Column Name	Excel Validation Applied
Banner URL	Must be a full URL starting with http:// or https://
Logo URL	Must be a valid URL; malformed URLs not permitted
Logo URL (White)	Must follow the same strict URL validation as Logo URL
State Logo	Must be a full, valid URL (optional field)

---

Sample Data Row

Banner URL	Logo URL	Logo URL (White)	State Logo
https://en.wikipedia.org/wiki/logo	https://en.wikipedia.org/wiki/logo	https://en.wikipedia.org/wiki/logo	https://en.wikipedia.org/wiki/logo