This article will cover two main sections:
Resetting an environment (clear down)
Copying data from one environment to another to mirror each other
1. Resetting an environment (clear down)
During the implementation phase, your FundApps environment will inevitably contain test data. In some instances, you might want to be clear of these test data before the “Go Live.” Clearing the environment sets up the environment to start building up a nice continuous history of data. A clear down consists of deleting all result data generated in the system.
What can be done during a clear down?
There are inter-dependencies in the way data is stored in our databases, therefore it is not always possible to delete specific subsets of data. So what is dependent on what?
Portfolios depend on Aggregation Structures
Transactions depend on Results
So if you want to clear down the aggregation structures you will need to also clear down the portfolios, and similarly, if you want to clear down results you will need to also clear down transactions. Other parts of the system can be cleared down without thinking about dependencies, these are:
Data Overrides
Rule Approvals
Imported Disclosures
As deleting data from any FundApps environment is a risky procedure we will always ensure
that these expectations are aligned with our clients. This can be something that takes a bit of time
and you should expect a period of about three days before the clear down is done. Clear downs can also be scheduled for a future date.
Contacting Support
When contacting support to request a clear down please specify the following:
environment
date range (i.e. whether you want all historical to be cleared or a specific range only)
what should be kept (see above list)
what should be removed (see above list)
FundApps will create a 'FundApps Task' in your environment which you will need to confirm before we can proceed. We will then contact you close to the time of the clear down to notify you that it will be taking place and so that you do not upload any files during that time. Once it has been complete, we will again confirm this in the support ticket.
Finally, we are also able to remove the open tasks in an environment, which is not the same as a clear down. If this is more suitable for your situation then please specify that is required instead.
2. Copying Environments (Staging <-> Production)
Users can copy over data from one environment to another (essentially mirroring environments) in order to test out certain FundApps features/rules.
How to Copy Environments
To create a fully mirrored environment, 3 components need to be replicated:
Portfolio structure which replicates the aggregation structure
Position File which updates your holdings, and
Data Overrides
Users should clear existing portfolios from their target environments IF it contains portfolios different from the environment being copied. Otherwise, uploading a new portfolio file will simply add to any portfolios that are present in the environment. Please follow the steps below:
Export your Portfolios: Portfolios & Entities > Download
Export your Positions file of the correct NAV date: Admin > Previous Uploads > Download the relevant file (Document with green arrow icon)
Export your Data Overrides: Admin > Setup > Data Overrides > Export
Once you have done this, upload each of the above three in your other environment