Skip to main content
Gainsight Inc.

Catch-up on Rules Engine Enhancements

September 2018: 5.19 Release

  • Custom Rule Retirement Plan: With this release, all new rules must be created as Bionic Rules. You cannot create new Custom Rules, but your existing Custom Rules will continue to run and still be editable.

1 Custom Rule Retirement Plan.png

Although Gainsight is developing a utility to migrate Custom Rules to Bionic Rules, Gainsight recommends that Admins begin reviewing their Custom Rules to look for opportunities to combine multiple rules into a single Bionic Rule. For more information, refer Custom Rule Deprecation FAQs.

Please see this series of articles for assistance in creating Bionic Rules. Gainsight also offers a free e-learning course on Bionic Rules. If you are not familiar with Bionic Rules, watch this 2-min. video to learn how they're more powerful than custom rules, but not that different in terms of how to configure them.

  1. New Rule Filters: Gainsight is introducing four new options to filter rules. The new filter options are:
  • Created Date: You can use this option to filter the rules based on the date of their creation. This option provides you with following seven matching criteria to filter the rule:

    • Last Month: This criteria displays all the rules which were created in the last month.
    • Last N days: In this criteria, you can enter a numerical value between 1 and 5000. The rules created from the specified day until today, are displayed. For instance, consider today’s date to be 1 Oct. 2018. if you enter 365, rules created between 2 Oct 2017 to 1 Oct 2018, are displayed.
    • Last Week: This criteria displays all the rules which were created in the last week.
    • This Month: This criteria displays all the rules which were created in the current month.
    • This Week: This criteria displays all the rules which were created in the current Week.
    • Today: This criteria displays all the rules created today; after 12 am and before 11:59 pm.
    • Yesterday: This criteria displays all the rules created yesterday; before 12 am today and after 12 am yesterday.

  Notes:

  • Definition of a Month is 1st of any month to last day of the month. (Ex: 1st Jan to 31st Jan)
  • Definition of a Week is Sunday to Saturday of any week.

32 Created Date.gif

  • Last Updated Date: You can use this option to filter the rules based on the date on which they were last updated. This option provides you with the following seven matching criteria to filter the rule:
    • Last Month: This criteria displays all the rules which were created in the last month.
    • Last Month: This criteria displays all the rules which were updated in the last month.
    • Last N days: In this criteria, you can enter a numerical value between 1 and 5000. The rules which were last updated from the specified day until today, are displayed. For instance, consider today’s date to be 1 Oct. 2018. if you enter 365, rules updated between 2 Oct 2017 to 1 Oct 2018, are displayed.
    • Last Week: This criteria displays all the rules in which the latest  updates were made in the last week.
    • This Month: This criteria displays all the rules which were last updated in the current month.
    • This Week: This criteria displays all the rules which were last updated in the current Week.
    • Today: This criteria displays all the rules updated today; after 12 am and before 11.59 pm.
    • Yesterday: This criteria displays all the rules updated yesterday; before 12 am today and after 12 am yesterday.
  •  Execution Type: You can use this option to filter rules based on their execution schedules. This option provides you with the following three criteria to filter rules:

    • Event: This criteria displays all the rules which have the Schedule type field set to Event, in the Schedule page.
    • Scheduled: This criteria displays all the rules which have the Schedule type field set to either Basic or Advanced, in the Rule Schedule page.  
    • None: This criteria displays all the rules which have not been scheduled and which are executed manually with the RUN NOW option.
  • Rule Chain: You can use this option to filter rules which are part of rule chains. The matching criteria for this option is dynamic and vary based on the following details:

    • If you have not created any Rule Chain, then you can only view one matching criteria; None. This is because none of your rules are part of any Rule Chain.

33 Rule Chain.gif

  • When you create Rule chains, you can find the names of your rule chain, appearing as matching criteria. You can select the required Rule Chain and rules which are part of the selected Chain are displayed. If you have created a Rule chain, but not added any rules to it, the Rule Chain is not displayed as a matching criteria.

34 Rule Chain is not displayed as a matching criteria.gif

  • If all of your rules are part of some Rule Chain, the None matching criteria is not displayed.

35 None matching criteria is not displayed.gif

2. Enhancements in the S3 Dataset Task

  • Ability to edit the “S3 File Configuration” section in S3 Dataset task: You can now edit the S3 file configuration section. Previously, this section was not editable once the S3 dataset task was saved. To make changes in the S3 File Configuration:
  1. Click the EDIT button.
  2. You can change the csv/tsv file, switch to another S3 bucket or make any other changes in the S3 File configuration.
  3. Click Load Column Details when you are done with your changes. The fields in the Columns section are automatically updated based on the columns in the new csv/tsv file.
  4. Click SAVE to save changes in the latest S3 File Configuration.

36 Edit S3 Config..gif

IMPORTANT

  • If you make changes to an S3 dataset task before Rule execution starts, the rule is executed successfully.
  • If you make changes to the S3 File Configuration section during Rule execution, execution fails at that point. Records which were processed before the changes, remain intact. But no further records are processed after you change the csv/tsv file or S3 bucket. To learn more about how to view successfully ingested records and records which are failed to ingest, refer the enhancement “Partial Success” Execution Status for S3 dataset.
  • If you make changes to the S3 File Configuration section when the rule  execution has just started or is in the execution queue, system displays an error message stating that file not found or Bucket not found, based on the changes made. The rule execution fails.
  • Once you ingest data through S3 dataset, you can create an Action on the Rule to load data. If a csv/tsv file column is part of Rule Action and you wish to delete this column, from the Columns section, the system sends an error message. You must first remove the required column from the Rule Action page and then remove it from the Columns section of the S3 Dataset task.
  • “Partial Success” Execution Status for S3 dataset: During the rule execution using an S3 dataset task, if some records fail to ingest due to any reason, rule is executed partially and status appears as Partial Success in the Execution History.

    In a Partial Success rule, you can find two downloadable files for the S3 dataset. The first download link (grey in colour) contains the file that has records which were successfully ingested. The second download link (red in colour) contains the file that has records which failed to ingest. When you click the red download link, error csv file is downloaded and you can see the list of errors and records that are failed to ingest.

37 “Partial Success” Execution Status for S3 dataset.png

  • Automapping of Data types in column section: In an S3 dataset task after you complete configuration in the S3 File Configuration section, you can now see that the Data types between the csv/tsv headers and output columns are automatically mapped. You can check the mappings of data types and change them as required.

38 Automapping of Data types in column section.png

  • Ability to load Dropdown list items either via labels or GSID from CSV file to an S3 Dataset: If you have dropdown list items in either labels (Ex: Active, Inactive, etc.) or their corresponding GSIDs in a CSV header, system allows you to store these values in the columns of an S3 dataset. You can use these values to match with dropdown list items in MDA (Ex: Company > Status) in the action types: Load to Gainsight objects.

  • Introduction of GSID data type: Previously, the Data Type column in the Columns section contained five data types. Now the sixth Data Type GSID has been introduced. Previously, GSID fields were mapped as String data types. Now these can directly be mapped as fields of GSID Data type.

39 Introduction of GSID data type.png

  • Enhanced Support for Date and DateTime formats: Previously, only a few Date and DateTime formats were supported in an S3 Dataset task. Support has been extended to include many more Date and Datetime formats.

40 Enhanced Support for Date and DateTime formats.png

The list of newly supported Date formats is given below (Click here to expand the list):
yyyy/MM/dd
M-dd-yyyy
M-dd-yyyy
MM-d-yyyy
MM/d/yyyy
MM-d-yy
MM/d/yy
M-d-yy
 
The list of newly supported DateTime formats is given below (Click here to expand the list):
M-d-yy HH:mm
M-d-yyyy HH:mm
HH:mm
M-dd-yy HH:mm
M-dd-yyyy HH:mm
HH:mm
M/d/yy HH:mm
M/d/yyyy HH:mm
M/dd/yy HH:mm
M/dd/yyyy HH:mm
MM-d-yy HH:mm
HH:mm
MM-d-yyyy HH:mm
MM-dd-yy HH:mm
MM-dd-yyyy HH:mm
HH:mm
MM-dd-yyyy HH:mm:ss
MM/d/yy HH:mm
MM/d/yyyy HH:mm
MM/dd/yy HH:mm
MM/dd/yyyy HH:mm
MM/dd/yyyy HH:mm
MM/dd/yyyy HH:mm:ss
yyyy-MM-dd HH-mm-ss
yyyy-MM-dd HH:mm:ss
yyyy-MM-dd HH:mm:ss.S
yyyy-MM-dd HH:mm:ssZ
yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
yyyy-MM-dd'T'HH:mm:ss.SSSZ
yyyy-MM-dd'T'HH:mm:ss.SSS
yyyy-MM-dd'T'HH:mm:ssz
yyyy-MM-dd'T'HH:mm:ssZ
yyyy-MM-dd:HH-mm-ss
 

3. Formula Fields enhancements

  • Rule Date Function in Formula Field: A new function called Rule Date has been added to the Date Formulas. This function returns the Date on which the rule is being executed (Current date). This function does not accept any arguments. This function provides you the capability to directly use the current date as a new column.

41 Rule Date Function in Formula Field.gif

  • community-icon.png Support for negative results in Date Diff function: Date Diff function subtracts the start datetime field value from the end datetime field and it returns the difference in number of days. Previously, even if the end datetime field had a lower value than start datetime field, the result (number of days) was converted to a positive value. Now, the Get Signed Value checkbox is introduced. If you select this checkbox, negative values are not converted to positive values in the result.

42 Support for negative results in Date Diff function.png

For example, if your start datetime value is 5 Jan 2018 and end datetime value is 2 Jan 2018, Date Diff function subtracts start datetime from end datetime. So in this case, the output would be -3 days. Previously, this negative value was converted to a positive value and the output was displayed as 3 days. However, now if you select the Get signed value checkbox, the negative value is returned as -3.  

DateDiff Negative value.png

 

  • Ability to use Rule Date in “end datetime” field of Date Diff function: You can now use the Rule Date (current date) in the end datetime (minuend) field of the Date Diff function. Previously, only the Date and Datetime data type fields in the Show section of the dataset could be used as arguments in Date Diff function. Now you can use Rule Date as the minuend of this function, from which the subtrahend start datetime would be subtracted and the difference is returned in number of days.

    In the image below, Closed Date and Created Date are displayed because they are used in the Show section of the Source dataset; MyCTAs. However, Rule Date is not part of the source dataset. But as a result of this enhancement, Rule Date is displayed in the end datetime field.

43 Ruledate-datediff.gif

4. Pause and Resume capabilities in Rule Schedule:

  • community-icon.png Rule Schedule pause: Previously, if a rule execution fails, the rule moved to the inactive state and any schedule associated with the rule was deleted.

    Now, if a rule becomes inactive due to either:
    • execution failure
    • Abrupt interruption
    • Rule status is changed manually, 

the schedule associated with the rule is not deleted. The schedule is paused. Once you make the rule active again, the schedule associated with the rule also becomes active.

Note: If your Rule schedule type was set to Event, the event is deleted, if the rule execution fails. Rule Schedule is paused only when Schedule type is either Basic or Advanced.

Rule Schedule pause.gif

  • community-icon.png State preservation for cloned rules: Now if you clone an active rule, the cloned rule is also active by default. Similarly when you clone an inactive rule, the cloned rule is also inactive. After a rule is cloned, schedule of the source rule is not applied to the target rule. You must schedule it manually.

    In the below image you can see that the Source Rule Account Rule has a schedule (10/1/2018 12.00am) and is active. However, the cloned rule Copy of Account rule is active, but does not have a schedule.

45 Rule Clone.gif

August 2018: 5.17 Release

  • Custom Rule deprecation plan: After Gainsight's October 2018 release, all new rules must be created as Bionic Rules. Your existing Custom Rules will continue to run and still be editable. Although Gainsight is developing a utility to migrate Custom Rules to Bionic Rules, Gainsight recommends that Admins begin reviewing their Custom Rules to look for opportunities to combine multiple rules into single Bionic Rules. You will have plenty of time for this process which is outlined in this FAQs.

    Please see this series of articles for assistance in creating Bionic Rules. Gainsight also offers a free e-learning course on Bionic Rules.

    If you are not familiar with Bionic Rules, watch this 2-min. video to learn how they're more powerful than custom rules, but not that different in terms of how to configure them!

July 2018: 5.16 Release

  • Community icon for RN.png In Rules > Setup Action > Action type dropdown list, Load to MDA Subject Area is now renamed Load to Gainsight Object.

Load to GS Object.png

  • *Custom Rule deprecation plan*: After Gainsight's October 2018 release, all new rules must be created as Bionic Rules. Your existing custom rules will continue to run and still be editable. Although Gainsight is developing a utility to migrate custom rules to Bionic Rules, we recommend that Admins begin reviewing their custom rules to look for opportunities to combine multiple rules into single Bionic Rules. You'll have plenty of time for this process which is outlined in this FAQ

    Please see this series of articles for assistance in creating Bionic Rules. We also offer a free e-learning course on Bionic Rules. 

    If you aren't familiar with Bionic Rules, watch this 2-min. video to learn how they're more powerful than custom rules, but not that different in terms of how to configure them!

June 2018: 5.15 Release

  1. Community icon.png SFDC.png Load Null Values to Fields using Load to Actions: You can now load null values into any field using the Load to Action types in Bionic Rules. This enhancement is supported in the following action types:
  • Load to Usage
  • Load to Customers
  • Load to SFDC Object
  • Load to MDA Subject Area
  • Load to Company
  • Load to Relationship
  • Load to User
  • Load to Company Person
  • Load to Relationship Person

To see this enhancement:

  1. Navigate to Administration > Bionic Rules > Setup Action page.
  2. Select any Load to Action and click ADD CUSTOM FIELD.
  3. Select Set to Null to ingest null values into the target field.

20-Load Null Values to Fields using Load to Actions.png

 

  1. SFDC.png Delete a Bionic Rule Schedule: You can now delete the existing schedule of any Bionic rule in all of the schedule types (Basic, Advanced, and Event). To delete the schedule of a Bionic rule, click DELETE in the schedule page as shown below:

21-Delete a Bionic Rule Schedule.png

You can now delete the schedule of any Rule chain in the Basic and Event schedule types with the DELETE button:

22-Basic and Event schedule types with the DELETE button.gif

Note: In previous versions, the option to delete a basic rule chain scheduler was available in the bottom right corner of the Schedule page as a Delete icon.

  1. SFDC.png Basic type Rule chain scheduler is now similar to Rule scheduler: You can now see more options in the basic type rule chain scheduler with an enhanced UI and it’s similar to the basic rule scheduler. New options include:
  • Schedule for Yearly
  • Selection of flexible Start Time in Minutes and Timezone

To see this enhancement, navigate to Administration > Bionic Rules > Rule Chain > [Click SCHEDULE] > [Select Schedule type Basic].

23-Basic Rule Chain Scheduler.gif

  • Was this article helpful?