The Bulk Import feature allows clients to populate a template for adding and updating funds in bulk. Client User and Administrator user types have access to the Bulk Import. This article explains the details of this feature. At this time, the Bulk Import function is not compatible with our Workflow Module. See the video below for a quick tutorial. 



Note: Bulk Import allows clients to perform mass imports of fund profile changes or additions with the assumption that the user has completed an internal check on the file.

To access the module, click on the Organize > Bulk Import.
image.png

Bulk Import Tab:

This tab is where you will upload the template that contains the bulk data that you would like to bring into Fundriver.

image_1.png

Note: If you are using the Expendable Funds Module, you will also see an Expendable Fund template here:

Download Template

It is important to use the template on this tab by clicking "Download Template."  The template has a header row with column names that map to your organization's individual fields within the Fund Profile. Do not relabel or rearrange the header row. Please follow the guidelines summarized below in order to minimize any errors when trying to commit your import file.


> When Adding New Funds: Any field that is required to Add/Save within the Fund Profile is required on the template for the Bulk Import.  *Please refer to image at the bottom of this article for identification of required fields.


> When Updating Funds: The GLID field needs to be populated when updating a fund.  The investment pool should NOT be populated since this field CANNOT be updated. (Note: Please refer to the knowledge base if you need help with updating an investment pool for an existing fund).  Any field that is BLANK for a fund, will not get updated.


> There is an option to clear out data within a NON-required field-  This will replace any value with blank.  For example, if you no longer need the Auxiliary ID populated for all existing funds; you can populate all funds with"NULL"in the Auxiliary ID column. This will clear out any data for the funds imported.


NOTE: GLID cannot be updated via the Bulk Import template. GLIDs can be updated one at a time on the Fund Profile screen. If you need to update multiple GLIDs contact support: Support@fundriver.com 


Browse/Upload

When your template to be imported is complete, use the Browse button to select this file to be uploaded. Once the file has been selected, click on Upload to bring that file into Fundriver. 


File Maintenance tab:

This tab contains links to the files that were successfully imported, the date the files were uploaded, the import types and the names of the user who uploaded the file.

image_3.png


> Import File Name - Allows user to view and download all files that were successfully imported. 


> PreImport File - Allows user to download the data as it existed prior to committing the imported file. This will only return data for funds and their corresponding columns that were updated. Note: A user may use this PreImport file as an audit check as well as a roll back option (in the extreme case that a client user should NOT have committed the file to Fundriver)


> Import Date - This is a time stamp for when the file was committed. 


> Import Type - The type of data that was imported.


Error Messages: How to Find and Fix them

To navigate to the error message, scroll to the right using the scroll bar under the records table. The Error Column will provide a brief description of the error for the corresponding field(s). 


The user will have to fix these errors within their import file and upload again. The Bulk Import commits only when all records have No Errors, as it is committing the file in whole.


Required Fields for adding new fund via Bulk Import

Note: if your database isn’t currently using a required field, ‘None’ must be populated in those fields in order for the bulk import template to upload.


image_4.png


Additional Info:

  • If the Upload button does not enable, copy the data to a freshly downloaded bulk import template file:
   image_5.png
  • Bulk Import does not trim data values. For example, fund category spacing needs to match exactly. There can be no extra spaces at the front or back.