Data Overrides
How to create a data override in your FundApps environment
The data overrides functionality is available in FundApps to help clients manage data directly in the UI. It saves time if there is a data issue that needs to be resolved quickly. There are two main ways clients can manage data overrides:
- Directly in the UI
- Via the data overrides CSV file upload (see details below)
Data Override - CSV File Upload
You can upload a file to populate fields that are blank or missing in the input file, or change the value of fields when the input property matches a certain condition. For more information, see more details in the Help Center article here.
Schema
| Column Name | Description | Data type |
|---|---|---|
| IsEnabled | True for enabling the override | Boolean |
| Type | Default is for populating fields that are blank or missing in the input file. Override for changing the value of fields when the input property matches a certain condition. | String(255) |
| ConditionProperty | Property that determines whether the override should be enabled | String(255) |
| ConditionValue | If the ConditionProperty is equal to this Value then override it | String(255) |
| TargetProperty | Property to be overriden, e.g. Delta | String(255) |
| TargetSourceType | ReplaceWithConstant or ReplaceWithAnotherProperty | String(255) |
| TargetSource | Replacement value or replacement property name | Decimal(28,8) |
| TargetCondition | Required if Type is set to override. Override is only enabled when TargetProperty satisfy TargetCondition | Date |
| ActiveFrom | Start date of override, must be in YYYY-MM-DD format | Date |
| ActiveTo | End date of override, must be in YYYY-MM-DD format | Date |
| Note | Reason for override | String |
Note that all strings are case sensitive, e.g. Default would pass validation but default would fail.
Booleans are not case sensitive so both True and true means the same.
Example File
IsEnabled,Type,ConditionProperty,ConditionValue,TargetProperty,TargetSourceType,TargetSource,TargetCondition,ActiveFrom,ActiveTo,Note
True,Default,,,IsListed,ReplaceWithConstant,true,,2010-01-01,,
ExistingId,IsEnabled,Type,ConditionProperty,ConditionValue,TargetProperty,TargetSourceType,TargetSource,TargetCondition,ActiveFrom,ActiveTo,Note
9622dea5-2e68-483a-95cc-ad730121c453,True,Default,,,IsListed,ReplaceWithConstant,true,,2010-01-01,,
Updated 9 months ago