Data Wizard

The Data Wizard offers an intuitive workflow for admins to upload Contribution, Distribution and Financial data on the Fund Details Page: Data Uploads Tab. The Data Wizard is also accessible via the Functions: Data page. Click the Upload button to launch the wizard in either pathway. Data is first uploaded with a Pending status before being validated and published.

Key Areas of Data Wizard

Step 1: Select Data Upload Type

Step 2: Upload File

Step 3: Data Mapping

Step 4: Review

Bulk Publish and Bulk Delete

Data Wizard Accuracy Controls

Troubleshooting

Key Areas of Data Wizard

The Data Wizard breaks the process down into logical steps. Each step has the following key areas:

1 - Workflow Steps - Indicate the total number of steps in the workflow and where users are in the process. A green checkmark next to the step indicates that the step is complete.

2 - Status - Indicates the status: Draft, Processing, Pending, Published

3 - Selection Area - As admins move through the workflow, this area allows them to make selections as required.

4 - Upload Details - Provides a live summary of the upload as admins move through the workflow.

5 - Action Buttons - Allows admins to move forward or back through the process or delete the upload, as well as save changes before publishing and revert to pending (Back, Save Changes, Move to Pending, Delete).

Use the Data Wizard

1. Navigate to the Functions menu and select Data.
2. Click Upload to launch the wizard.

3. The Data Wizard is also accessible from the Fund Details Page: Data Uploads Tab.

   

Step 1: Select Data Upload Type

Review the various fields and options available:

1. Select data upload type -
   1. Contributions - data will be uploaded to the Contributions tab in the fund
   2. Distributions - data will be uploaded to the Distributions tab in the fund
   3. Financials - data will be uploaded to the Financials tab in the fund
2. Select the Fund - use the drop-down menu to select the fund
3. Description - by default the date upload date is added; use the field according to your needs
4. +Add Tracking ID (optional) - click to add an optional tracking number

Step 2: Upload File

Contributions, Distributions and Financials data upload files must be in CSV format. Use the Drag and drop feature or click Select CSV to upload the file. Only a single file can be uploaded. Once the file is successfully uploaded, click Continue.

How to Add Manually

To add a file individually, use the Add Manually button. Click the +New Row button to add a new row. In this case, any entered data will be uploaded as is and the signage will not change.

Step 3: Data Mapping

This step allows you to map the portal fields to the columns in the source file to ensure the system is looking at the right column when uploading data. To proceed to the next step, each mandatory field must be matched to one of the columns in the source file. Any non-mandatory field will be skipped and not be included in the upload.

Column Headers

Portal field - standard fields in the portal, listed in the order they appear in the system.

Mandatory (yes/no) - indicates if the field is mandatory or not.

Type - Number, string, date, dollar amount.

Data upload field - the column headers from the source file.

Status - Matched, Not Matched, Manual., The system initially attempts to map portal field names to the column headers such as Investor ID, provided the column headers are labeled correctly.

Step 4: Review

The Review page displays an overview of all uploaded data in a Pending status. Verify the table and ensure all rows are matched before uploading data. You cannot publish this data until all rows have a status of Matched or Manual.

• Yellow banner displays list of the investors and contacts who do not have access to data in the system. Use the hyperlinks to view each investor and contact access on separate browser tabs.
• Use the Download CSV button to download a CSV of the table.
• The Download Report button provides the table and Upload Details summary (pdf format).
• Upload Details section displays the count of investors and contacts that have access to this data.

Data Wizard Accuracy Controls

Sensr Portal has multiple controls to view and verify the data upload before you hit Publish. It is recommended that you use the controls to validate the data.

1. In Step 1: Select Data Upload Type - if there are any pending or draft Financials uploads for the fund; you will not be able to proceed to Step 2 until the pending upload is either published or removed before uploading new data.

   

2. Be sure to review the Upload Details section for Investors and Contacts counts which appear on Step 2: Upload File and onwards. Ensure that the investor and contact counts match investor / contact permissions. Click on the link to navigate to those pages.

   

   
   

3. Step 4: Review a Yellow banner list of investors / contacts who do not have access to the data.

   

4. Use the Download CSV to compare the source file to verify it matches. Or, use the Download Report button to review the PDF summary of the entire data upload, including investor and contact counts.

   

5. Pending view on Step 4: Review allows users to preview the data in various locations in the portal to validate the upload. *Pending data is only visible to admins.

Troubleshooting Guide