Skip to main content
Gainsight Inc.

Limits and Constraints of Gainsight Data Management

Overview

This document lists various limits and constraints that exist around usage of Gainsight Data Management (GDM) and to help avoid 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. Date

Supported formats 

https://jbarasoftware.jira.com/wiki/display/TRFS/Date+Data+Type

4. Date Time

Supported formats

https://jbarasoftware.jira.com/wiki/display/GQ/Supported+Date+Formats

5. SFDC ID 15 or 18 digit alpha-numeric string (Stored in 18 digits always)
6. Email
  • Presence of @ and '.' after '@',
  • It should not start with any special character
  • It should have at least 1 character before and after '.' and '@'
7. Percentage

Data Entry/Ingestion Format:

  • Number only
  • Number with decimals
  • Number with percentage symbol
Input Output
0.1 10%
10 100%

 

8. Currency
  • List of currencies supported:
    • 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.comgainsightadmin@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)
10. MDA Lookup Support
Source field data type Join field data type
String
  • String
  • SFDCID
  • Email
SFDCID
  • String
  • SFDCID
Email
  • String
  • Email

 

  • Was this article helpful?