Skip to main content
Gainsight Inc.

Data Operation

Gainsight Standard Edition
This article supports Gainsight Standard Edition. This Edition is built on Gainsight's state of the art Matrix Data Architecture (MDA) platform, and is designed for customer success professionals for driving revenue, increasing retention, and scaling operations. To learn more about Gainsight Standard Edition, click here.

If you are using Gainsight Salesforce Edition, which is built on Salesforce and customer business data is stored in SFDC, you can find supporting documentation here.

 

Overview

Data operation is an Administration page that helps Admins view, edit, and delete the existing records in the MDA standard object Company. Admins can also add new records in this standard object through this page. It is a channel through which Admins can insert or update data in the mentioned standard object similar to the existing connectors, S3 Connector and Gainsight Bulk API.

Data Operation Screen

Data Operation Screen.png

  1. Navigate to Administration > Data Operation.
  2. Select the MDA standard object Company.

Admins can see the following options in the Data Operation page:

  1. Standard Objects: Select the MDA standard object Company to view or edit the existing records and add new records.
  2. Total record count: Displays the total number of records existing in the object you have selected.
  3. Delete: Click this to delete the records you have selected on this page. For more information on this option, see Deleting the existing records in an object.
  4. Refresh: If you click this button, it reloads the page and displays the exact number of records available now.
  5. Manage Columns: This option helps you filter and display the records in the object as per your requirement. If you click this button, you can see all the fields available in the object to add fields, operators, and values based on your requirements. To apply the filters:
  1. Select a field in the object.
  2. Select an operator, greater or equal, greater than, less or equal, less than, etc.
  3. You can select the checkbox to include the null records while applying the filters.
  4. Click + ADD FILTER to add multiple filters. You can add operators like AND and OR between the filters while applying the filters. Applying filters will fetch the users list as per the requirement.
  5. Click the Delete button to remove the already applied filters.
  6. Click APPLY to apply the added filters, then the records are displayed as per the selected filters.
  7. When you click the Refresh button, the applied filters are removed and all records are shown in the Data Operation page.

Apply and Add Filter.png

  1. Filter Results: You can select the fields in the object that you want to display in the Data Operation screen. You can Check All, Uncheck All, or Apply the selected fields.

Select Fields (Search).png

7. + RECORD: This option helps you add new records in the object. For more information, refer the Adding a new record section.

Adding a new record

To add a new record to the MDA standard object:

  1. Select the MDA standard object Company.
  2. Click + RECORD. Add screen appears.
  3. Enter values in the standard and custom fields. You cannot enter values into the system fields.

Note: Entering a value in the Name field is mandatory.

Add a New Record.gif

Viewing and Editing the existing records in an object

To view or edit the information in an existing record in an object:

  1. Select the MDA standard object Company.
  2. Click the View or Edit button in a specific record. View or Edit screen appears.
  3. In the View screen, you can view all of the system, standard, and custom fields in the object.
  4. In the Edit screen, you can edit values in the standard and custom fields but you can only view the values in the system fields in the object.
  5. To edit values in the standard or custom fields of a record, make the required changes in the Edit screen and click Update.

Edit existing records.gif

  1. To identify the system fields in an object:

    a. Navigate to Administration > Data Management > [Select any standard object mentioned above].
    b. You can identify the system fields that have Data Editability value is No.

Data Editability.png

Deleting the existing records in an object

To delete an existing record in an object:

  1. Navigate to Administration > Data Operation.
  2. Select the MDA standard object Company.
  3. Select the checkboxes of the records that you wish to delete.

Select Checkboxes.png

  1. Click the Delete record button in the page header.

Delete Records.png

  1. The following message will display after you click the Delete record button.

Confirm Delete Message.png

  1. Click hyperlink in the message to see object graph on the Company object. For more information on the Object Graph, refer Gainsight Data Management.

CAUTION: There is no way to recover the deleted record(s), so be sure before deleting the Company records.

  1. Click CONFIRM to complete deleting the selected records.


 

  • Was this article helpful?