Follow

Editing multiple overrides using a CSV file

Editing Multiple Overrides

The most efficient way to edit multiple existing overrides is to export them, make edits to the CSV file and re-import the CSV. The export will be a CSV file containing all current overrides. To export the CSV file go to Admin >Setup > Data Overrides > Export.

 

Once in the CSV, edit the columns under consideration and save the edited CSV file. For example, if you wanted to make an override inactive, simply change the IsEnabled column from TRUE to FALSE in the CSV file. Overrides left with TRUE in the IsEnabled column will remain active, unless the effective date has already passed.

General Considerations

After making edits, 3 things must be done before importing the override CSV file back into Rapptr.  

1) The ExistingId is the unique identifier for each override and should be kept for the existing overrides in a file, even if they are edited and left blank for new overrides. 

2) Do not edit any overrides created by FundApps when uploading the CSV file back into Rapptr. Editing overrides created by FundApps will cause validation to fail as overrides created by FundApps can't be deleted nor edited.

3) Convert the format of all dates into YYYY-MM-DD, as this is how Rapptr recognises dates. The columns affected are: Active From, ActiveTo and LastNavDate. This is required as most Excel software automatically converts date formats when opening CSV files.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.