Investor Relations Data Upload Instructions

Modified on Mon, 31 Jul 2023 at 11:26 AM

In this article, we cover the best process for importing your investor relations data using the Data Loader, including some best practices to prepare your data prior to the import process. The Data Loader mappings required for these uploads are attached at the bottom of this article, we recommend downloading them into an easily accessible folder prior to proceeding with the data uploads.

TABLE OF CONTENTS

Helpful Tips Prior to Using Data Loader
Step 1: Creating Funds in FundPanel
Step 2: Importing Investor Accounts
Step 3: Importing the Investment Vehicles
Step 4: Importing Capital Commitments
Step 5: Importing Contacts
Step 6: Importing Contact Roles

Helpful Tips Prior to Using Data Loader

Before proceeding with the data uploads, these tips will help you to process the data correctly at each step:

Place an apostrophe ( ' ) before leading zeroes so that they do not get removed during import (common with Tax IDs)

External IDs are exact copies of the primary column's value*. An Investment Vehicle's "External ID - Entity" is just an exact copy and paste of the Investment Vehicle into the external ID column so that you have an easy way of mapping to this record in the future without having to export the Salesforce IDs of the object's records. *As of August 2022, the External ID for Contacts in Step 3 is now the Email field instead.

Record Types are unique to each org and will require you to obtain them from the Salesforce org for each org's data imports.

Prior to making changes to a client's data spreadsheets, make sure they get uploaded to the 'Client Implementations' folder on Box. Create a new folder for the Fund (with the same name as the Fund), and within that folder create a 'Provided by Client folder'. Place all original spreadsheets received from the client within this folder. Additionally, create a 'Fundpanel Workpapers' folder within this Fund folder and upload and place all CSVs you prepare within this folder.

Prior to logging into the client's org through the Data Loader, you will need to add your IP Address in the 'Network Access' section of the Salesforce org. This is so you are not asked for a security token upon login.

Step 1: Creating Funds in FundPanel

1. Log into FundPanel.

2. Navigate to the Funds tab and select 'New'

3. Enter the fields from the Excel template for each Fund

Please Note: The Bank Account # is the twelve digit number. The Bank Routing Number (ABA Number in the database) is the nine digit code.

Step 2: Importing Investor Accounts

1. Navigate to the Investor tab in FundPanel and select 'New'

2. Select Investor as the Record Type and press Continue

3. Copy from the URL what comes after 'RecordType=' and before '&ent'

This should be the 15 characters before

4. Save your excel as a CSV

5. Login to the FundPanel Data Loader by clicking 'Insert'

OAuth - enter the Client username and password (stored in LastPass)
Allow the Data Loader to access and manage basic information and data
Press Next
Please Note: Be sure to check you are logged in to the correct client within the Data Loader. If the DataLoader is open for an extended period of time, it may periodically log out from the client's database.

6. Select Account (Account) as the object and find the completed Step 2 CSV file containing the file data

7. Press Next

8. A box will appear displaying the number of records your upload will contain. Check this number against your spreadsheet as it can sometimes be incorrect if the DataLoader is not interpreting your data correctly.

9. Choose the existing mapping 'Investor Relations Investor Mapping.sdl' (attached below)

10. Press Next

12. Press Finish

Step 3: Importing the Investment Vehicles

1. Press Upsert in the Data Loader

2. Choose Account (Account)

3. Choose your step 2 Accounts Load CSV file

4. Press Next and select OK

5. The Matching field here should = Id

6. Press Next

7. The matching fields here should be:

Aduro Parent = aduro_External_Id_c
Aduro_Parent_Account_r = aduro_External_Id_c
Aduro_Wire_Instructions_Submitted_By_Contact_r = aduro_External_Id_c

8. Press Next

9. Choose the existing mapping "Investor Relations Investment Vehicle Mapping.sdl" file (attached below)

10. Press Next, then Finish and OK

Step 4: Importing Capital Commitments

An important step for preparing the Commitment CSV is navigating to the Fund within Salesforce and obtaining the ID in the URL - it will be the last string of letters and numbers after the /

1. Choose Upsert in the Data Loader

2. Select the Capital Commitments object

3. Locate your CSV file 'Step 4 - Commitments Load'

4. Press Next and OK

5. Set the mapping aduro_Capital_Commitment_c = Id