Once the excel template has been downloaded, there are tabs and sections for each of the resource types within DiligenceVault that you’re able to manage using the Bulk Upload function
The excel template contains the following tabs/sections:
- Firm Upload - Add unique firms that you would like to backload in DiligenceVault. All firms must have unique contacts with emails
- Fund Upload - Add unique fund that you would like to backload in DiligenceVault. Please ensure associated firm, strategy are listed for each fund
- Contact Upload - Add contacts that you would like to backload in DiligenceVault. All contacts must be associated with a firm from the Firm Upload tab
- Vehicle Upload - Add unique vehicles that you would like to backload in DiligenceVault. All vehicles must have unique products from the Fund Upload tab
- Users - Add your team members who would collaborate with you on the platform
Within each tab, there are columns for each field within that resource type that can be configured, which has also been color coded:
Additional Instructions:
- For strategies, exact match logic will be applied. For any strategy where it doesn’t match with existing ones available on the platform, new ones will not be created.
- For tags, exact match logic will be applied. For any tag where it doesn’t match with existing ones available on the platform, new one will not be created
- For contacts, please ensure emails are valid, First name and email are mandatory fields for contact creation. You can use email as the First name.
- You cannot delete any entity via bulk upload functionality
- DV ACTION - Change the cell value if you want to update the particular record. If selected, then the record will get updated, otherwise the process will skip that record for updating.
Team Members tab explanation and instructions:
- Access Level
- Admin - Admin of the firm with all functionality
- Owner - A user that has ability to view, edit, delete and create new entities and relationships on the platform
- Viewer - A user that can view all entities and relationships in a read only mode
- Contributor - A user that can view, edit, delete content for the assigned entities, Can only be created if you have subscribed to the team permission functionality
- Restricted- A user that can perform operation on the data based on assigned permission, can only be created if you have subscribed to the team permission functionality
- User Role in Team Members tab:
- Supported User roles are - Investment, ODD / Operations, Investor Relations, Compliance / Regulatory, Legal, HR, Risk Management, Executives, Technology / CISO, Others
- Multiple values should be separated by | (Eg: Investment | Legal)
Column Explanation
- Firm Tab
- PRIMARY OWNER - Email id of your team member who exists on DV separated by |
- SECONDARY OWNER - Email id of your team member who exists on DV separated by |
- EMAIL - Associated email (Main Email ID), Only one email ID is allowed.
- Contact Tab
- DILIGENCEVAULT OWNER - Email ID of your team member who exists on DV
- Product Tab
- STRATEGY - Strategy from your firm which exists on DV
- EMAIL - Email ID Associated with the fund
- PRIMARY OWNER - Email id of your team member who exists on DV separated by |
- SECONDARY OWNER - Email id of your team member who exists on DV separated by |
- Vehicle Tab
- CURRENCY - Currency name (3 letters)– Eg: USD
- INCEPTION DATE - MM/DD/YYYY
- PARENT PRODUCT - Product name for the vehicle
- PRIMARY OWNER - Email id of your team member who exists on DV separated by |
- SECONDARY OWNER - Email id of your team member who exists on DV separated by |
- FIRM NAME - Firm's name for which you are adding/ updating vehicle. Product's firm name.
Custom Field Explanation
- use "|" delimiter for multiple values of a field
- For link type custom field ["Link name", "Link value"]
- For Dynamic field type please use ids as a value
- For Dropdown and Checkbox type, if you selects Other then please add other, before the value
- If you leave type empty, we'll default it to asset manager In case your firm is investor
Additional Information:
For further instructions on how to use the Bulk Upload function, please see here.
For further instructions on how to upload the Bulk Upload excel template back into DiligenceVault, please see here.