# Tenant Branding Master

## Overview

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](https://docs.google.com/spreadsheets/d/1V9_DkR0WKm7CtZ4Rfcy-3yNtaPj5zL7VKXXvGjXquWs/edit?gid=2052883679#gid=2052883679)

***

## Data Table

<table><thead><tr><th width="70.12890625">S. No.</th><th>Banner URL</th><th>Logo URL</th><th>Logo URL (White)</th><th>State Logo</th></tr></thead><tbody><tr><td>1</td><td><a href="https://en.wikipedia.org/wiki/logo">https://en.wikipedia.org/wiki/logo</a></td><td><a href="https://en.wikipedia.org/wiki/logo">https://en.wikipedia.org/wiki/logo</a></td><td><a href="https://en.wikipedia.org/wiki/logo">https://en.wikipedia.org/wiki/logo</a></td><td><a href="https://en.wikipedia.org/wiki/logo">https://en.wikipedia.org/wiki/logo</a></td></tr></tbody></table>

{% hint style="info" %} <mark style="color:$primary;">**Note:**</mark> <mark style="color:$primary;"></mark><mark style="color:$primary;">This is a sample row only. Actual URLs must comply with the validation rules described below.</mark>
{% endhint %}

***

## Data Definition

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

***

## 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](http://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

<table><thead><tr><th width="214.296875">Validation Type</th><th>Description</th></tr></thead><tbody><tr><td>URL Format Validation</td><td>Ensures values begin with http:// or https:// and follow proper URL structure.</td></tr><tr><td>Character Restriction</td><td>Prevents unsupported characters or incomplete URL formats.</td></tr><tr><td>Input Sanitization</td><td>Blocks entries such as raw text, file names, or relative paths.</td></tr></tbody></table>

***

### 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](http://www.example.com))

Mandatory fields are validated again during MDMS/API ingestion.

***

### Validation Row Mapping

<table><thead><tr><th width="187.28125">Column Name</th><th>Excel Validation Applied</th></tr></thead><tbody><tr><td>Banner URL</td><td>Must be a full URL starting with http:// or https://</td></tr><tr><td>Logo URL</td><td>Must be a valid URL; malformed URLs not permitted</td></tr><tr><td>Logo URL (White)</td><td>Must follow the same strict URL validation as Logo URL</td></tr><tr><td>State Logo</td><td>Must be a full, valid URL (optional field)</td></tr></tbody></table>

***

## 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> |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.digit.org/complaints-management/complaints-resolution-v2.10/deploy/configure/master-data/master-data-templates/tenant-branding-master.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.