Follow

Bulk Import Module Overview

The Bulk Import feature allows clients to populate a template for adding and updating funds in bulk.  This feature is not enabled for all clients at this time.  Client User and Administrator user types have access to the Bulk Import.  If this is a feature your organization is interested in, please email support@fundriver.com and let us know! This article explains the details of this new feature. 

An important 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.

ORGANIZE > BULK IMPORT

Bulk Import Tabs

1.) Bulk Import:

If you are using the Non Pooled Funds Module, you will also see a Non Pooled Fund temple 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 organizations individual fields within the Fund Profile.  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 Fund Profile 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 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.

Browse/Upload

This tab is where the user will select the file by browsing their computer and then Upload the file.

2.) File Maintenance:

This tab contains: links to the files that were successfully imported, links to the preimport files, the date the files were uploaded, the import types, the names of the users who uploaded the files, and the upload types. 

> 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

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.

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

2 Comments

  • 1
    Avatar
    Dominique McKinnon

    Hi - Is this something that can be used for division and restriction changes? Is this an add-on feature? I don't see it available on my Fundriver.

  • 0
    Avatar
    Cosley Campbell

    Hi Dominique!

    I took a quick look into your database and I think you could use this feature to update those two fields.  It is an add on feature- just let us know if you'd like to discuss this further and I'll create a ticket.  Thanks for the note :)

    Best,

    Cosley

Please sign in to leave a comment.