How can we help?

Bulk Uploading Documents - Upload by Filename

There are several ways admins can upload documents to investor profiles in IMS. If unique documents need to be uploaded to a specific group of investors, such as tax documents, admins can utilize the bulk document uploader to save time and improve efficiencies. 

There are 3 methods admins can use when bulk uploading documents; Manual Match, Upload by Filename, and K-1 Matching. To begin, navigate to Documents in the top navigation, then select Personal and Project Documents, then click the drop down arrow in the top right corner of the screen. 

step_1.png

Document Uploader Best Practices 

No matter which upload method you choose to use, there are several universal best practices to help admins get the most of this feature. 

  • Documents uploaded need to be computer generated and in a readable format PDF. The system cannot read documents that are scanned and turned into PDFs. 
  • While the system is processing the documents for matching, users can navigate to another tab within IMS or can begin another batch upload without losing their progress. But, do not refresh the page, log out, or shut the browser completely. 
  • When the batch is finished uploading, the batch name will change from grey to blue and the user will be able to click into the batch. 

Upload by Filename 

This method is recommended for bulk uploading documents that involve multiple entities or projects because this method primarily relies on matching a document to a specific investor, not a project. 

To use this method, select Upload by Filename on the drop down menu. Begin filling in the fields prompted on the screen. *Note - the Project and Entity are not required fields, but if selected, only investors associated with the Project or Entity will be prompted during the match process. 

IMS.png

 

Filename Convention

This form of bulk upload relies on specific naming conventions to quickly and automatically match documents to investors in the IMS CRM. All documents uploaded in a single batch must follow a standard naming convention, including the type of delimiter. The file name must include the investor's IMS Profile ID in the name. 

To download an excel file with IMS Investor Profile ID's, navigate to the CRM, select all investors, and then click Bulk Actions > Export Contacts in Spreadsheet.

Screen_Shot_2019-09-24_at_1.28.07_PM.png

Choosing a Delimiter 

Users must select a delimiter ruleset when creating a batch in this upload method. The delimiter allows IMS to quickly read file names and associate it to an investor in the CRM. Users may choose a filename convention that includes either a Dash, Space, or Underscore for a delimiter either at the beginning or the end of the file. For Example Investor Profile ID_Document Name (123_Investor Name) or Document Name-Investor Profile ID (K1-123). The only required fields are the Investor Profile ID and the delimiter ruleset, all other characters in the document name are optional but including additional details such as the Investor Name and Document Name will be helpful if manual matching is needed. 

Users may also check 'remove unique filename identifier upon upload' which will remove the Investor Profile ID as indicated before or after the delimiter. 

delimiter.png

 

Once you have selected a delimiter ruleset, select the document type and upload the files that you wish to process in this batch. 

filename_2.png

Once the batch has finished uploading, the batch name will change from grey to blue. Select the batch name

filename_4.png

Because of the filename convention with the delimiter, the system will automatically match the document to the associated Investor Profile ID. Navigate to the Matched column to review the document pairings. If any edits need to be made, begin typing in the box of the associated investor to see a preview of contacts in your IMS CRM.

To see a preview of the document, select the blue document name. 

FN_1.png

When you are ready to publish the documents, select 'Publish' in the bottom right corner or from the yellow menu bar. If you chose to 'Notify Investors', investors associated to the document will get an email notification as well. *Note - Users may process the batch in stages and do not have to match all documents in a batch before publishing the batch to investors with assigned documents. 

FN_2.png

To see a status indicator of the batch, navigate back to the batch manager. Here you can see how many documents have been published from the batch and how many are remaining. 

FN_3.png

If documents need to be unpublished for any reason, simply navigate back to the batch list and select the drop down arrow next to the left of the batch name. Select Unpublish All. Users can also download a Document Audit Log or Delete the entire batch from this page. 

FN_5.png

 

 

 

 

 

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