Overview
Gainsight Data Management is a component of the Gainsight application that enables administrators to create and manage Matrix Data Objects. As an analogy, a Matrix Data Object and its field(s) can be thought of as a database table and its columns.
This document lists various limits and constraints that exist around usage of Gainsight Data Management (GDM) and to help prevent GDM Customers and Support Teams from hitting multiple failure scenarios while performing activities such as data ingestion, object/field creation, etc.
Object and Field Level Limits/Constraints
| Serial No. |
Limit / Constraint |
Value |
| 1. |
Constraints around naming conventions of objects |
Should be unique within a Tenant |
| 2. |
Constraints around naming conventions of fields/columns i.e. Display Name |
Should be unique within an object |
| 3. |
Maximum number of fields/columns allowed in an Object (Either Standard or Custom) |
200 (Recommended) |
| 4. |
Maximum file size while creating a Custom Object using CSV through the option Data File Upload (CSV) |
1 MB |
| 5. |
Maximum number of records that can be displayed per page (applicable to All Objects view, Object specific view & Data view) |
100 per page and 1000 in total |
| 6. |
Decimal Places |
Max number of decimal places is 9 (This parameter is used for display up to number of decimal places in Reporting) |
| 7. |
Maximum number of fields allowed in a formula field in GDM |
26 |
| 8. |
Operators Supported by Basic Formula Builder |
+,-,*,/,(,) |
| 9. |
Maximum file size while using Import Data option for data ingestion |
1 MB |
| 10. |
Field Names |
- A field name for a custom field is the display name appended by __gc and all the special characters will be trimmed (underscore is not trimmed).
- Display name can be alphanumeric but it should not start with a number
- Display name should not contain numbers only.
Example:
| Display Name |
Field Name |
| Customer123 |
Customer123__gc |
| Ernst&Young |
ErnstYoung__gc |
1234 Field name will not be created
- A field name for a standard field is same as the display name
|
Data Type Constraints
The following table highlights the Data Types supported by GDM and constraints around the definition of these data types.
| S. No. |
Data Type |
Constraints |
| 1. |
String |
255 Characters |
| 2. |
Boolean |
0 or 1; true or false |
| 3. |
Number |
A whole number or number with decimal places |
| 4. |
Date |
- Supported formats (Click here to expand the list)
- MM-dd-yyyy
MM/dd/yyyy
yyyy-MM-dd
yyyy/MM/dd
M-dd-yyyy
M/dd/yyyy
MM-d-yyyy
MM/d/yyyy
yyyy-M-dd
yyyy-MM-d
yyyy/M/dd
yyyy/MM/d
M-d-yyyy
M/d/yyyy
MM-dd-yy
MM/dd/yy
yyyy-M-d
yyyy/M/d
yyyyMMdd
M-dd-yy
M/dd/yy
MM-d-yy
MM/d/yy
M-d-yy
M/d/yy
-
|
| 5. |
Date Time |
- Supported formats (Click here to expand the list)
- M/d/yy HH:mm
M-d-yy HH:mm
MM/d/yy HH:mm
MM-d-yy HH:mm
M/dd/yy HH:mm
M-dd-yy HH:mm
MM/dd/yy HH:mm
MM-dd-yy HH:mm
M/d/yyyy HH:mm
M-d-yyyy HH:mm
MM/d/yyyy HH:mm
MM-d-yyyy HH:mm
M/dd/yyyy HH:mm
M-dd-yyyy HH:mm
MM/dd/yyyy HH:mm
MM-dd-yyyy HH:mm
M/d/yyyy HH:mm:ss
M-d-yyyy HH:mm:ss
MM/d/yyyy HH:mm:ss
MM-d-yyyy HH:mm:ss
M/dd/yyyy HH:mm:ss
M-dd-yyyy HH:mm:ss
yyyy/MM/dd HH:mm:ss
yyyy-MM-dd:HH-mm-ss
yyyy-MM-dd HH:mm:ss
yyyy-MM-dd HH-mm-ss
MM/dd/yyyy HH:mm:ss
MM-dd-yyyy HH:mm:ss
yyyy/MM/dd HH:mm:ssZ
yyyy-MM-dd HH:mm:ssZ
yyyy/MM/dd'T'HH:mm:ss
yyyy/MM/dd HH:mm:ss.S
yyyy-MM-dd'T'HH:mm:ss
yyyy-MM-dd HH:mm:ss.S
yyyy/MM/dd'T'HH:mm:ssZ
yyyy/MM/dd HH:mm:ss.SS
yyyy-MM-dd'T'HH:mm:ssZ
yyyy-MM-dd HH:mm:ss.SS
yyyy/MM/dd HH:mm:ss.SSS
yyyy-MM-dd HH:mm:ss.SSS
yyyy/MM/dd'T'HH:mm:ssSSS
yyyy-MM-dd'T'HH:mm:ssSSS
yyyy/MM/dd'T'HH:mm:ss.SSSZ
yyyy-MM-dd'T'HH:mm:ss.SSSZ
yyyy/MM/dd'T'HH:mm:ss.SSS'Z'
yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
-
|
| 6. |
SFDC ID |
15 or 18 digit alpha-numeric string (Stored in 18 digits always) |
| 7. |
Email |
- Presence of @ and '.'
- After '@', It should not start with any special character
- It should have at least 1 character before and after '.' and '@'
|
| 8. |
Rich Text Area |
- A maximum length of 15000 characters for high volume custom objects and 150000 for low volume custom objects can be defined for this field.
- After data is ingested into this field, Admins can increase the maximum length of text in the field (up to the maximum limit) but cannot decrease it.
- A default value cannot be assigned on this field.
- This field does not support MDA Joins and update keys.
|
| 9. |
Percentage |
Data Entry/Ingestion Format:
- Number only
- Number with decimals
- Number with percentage symbol
| Input |
Output |
| 0.1 |
10% |
| 10 |
100% |
|
| 10. |
Currency |
- List of currencies supported (Click here to expand the list)
- United States Dollar (USD)
Indian Rupee (INR)
European Currency (EUR)
Great Britain Pound (GBP)
Australia Dollar (AUD)
Brazil Real (BRL)
Canadian Dollar (CAD)
Switzerland Franc (CHF)
Israel Shekel (ILS)
Mexico Peso (MXN)
New Zealand Dollar (NZD)
Russian Ruble (RUB)
Chinese yuan (RMB)
-
-
- Number format supported: Number / Number with decimals
- Comma separator: Only 1000 separator
- Data Entry/Ingestion Format - 1000$, $1000, 1000, USD 5000, "USD 5,000.8234"
- Data Storage Format :1000
- Data Display Format : $ 1,000, $ 5,000.05896
|
| 9. |
Default Value |
- String: String field can have a default value with alphanumeric characters. Ex: "NA" or "OTHER"
- Number: Number field can have any numerical value as a default value. Ex: 10.00 or 10 or -10
- SFDC Id: SFDC Id can have salesforce Id of 15 digits or 18 digits as a default value. Ex: 003i000000NYZrg or 003i000000NYZrgXYZ
- Email: Email can have a valid email address as a default value. Example: support@gainsight.com, gainsightadmin@yourcompany.com
- Percentage: Following formats are accepted as the default value for a percentage field.
- Number with percentage symbol (10%)
- Number without percentage symbol (0.1)
- Number with decimal values (12.33%)
- Currency: Following formats are accepted as a default value for the currency field:
- Number without currency symbol (100)
- Number with decimal values (99.72)
- Number with currency code (USD1000, 1000USD)
- Number with currency symbol (100$, $100)
- Dropdown List: one default item can be assigned to a dropdown list category. When this category is mapped to any field of dropdown list data type, the field will be assigned with this default value.
- Multi select dropdown list: A maximum of six items can be assigned to a multi select dropdown list category. When this category is mapped to any field of multi select dropdown list data type, the field will be assigned with these default values.
|
| 10. |
MDA Lookup Support |
| Source field data type |
Join field data type |
| String |
|
| SFDCID |
|
| Email |
|
|
