Uploading Lookup Tables

Follow

Updated:

This article describes the process of adding a new value to a profile field using an upload file. Depending on how you have configured your NetDocuments repository, you may have profile attributes such as Client, Matter, Account, Doc Type, Author, etc. For the purposes of this article we will describe how to add a new Client or Matter to your NetDocuments Repository but you can follow the same instructions for any of your custom attributes.  

Uploading a lookup table is typically done when initially creating a profile attribute, or adding a large number of values at once. To save time when editing or adding only a few values at a time, you can edit the lookup table online.

Learn more about Editing Lookup Tables

To Upload a Lookup Table

First, you will need to be logged in as a Repository Administrator or someone who has been delegated the appropriate rights.

After you sign in to NetDocuments, select your name in the upper-right corner > Admin Profile Attributes:

profile_at.jpg

You should then see a list of all Profile Attributes that you have in your repository. Hover over Matter and select the Download Table button. (In this example, the Client table will contain a list of all clients. The Matter table will contain both clients and matters.)

matter.jpg

This will download a .csv spreadsheet containing a list of all Client and Matters that you currently have in NetDocuments. Save this file to your Desktop or to a location on your PC that you can get to easily and open it. By default, the file opens in Excel but you can also open it in Notepad if you need to.  

Note: Use caution when using .csv files in Excel, especially if your table has leading zeroes in it.

image3

Here you can add the new client and/or matter to the list, then save, and close the .csv file. You will now need to upload this list to your NetDocuments Repository. 

Back in NetDocuments, select the desired attribute to edit it. Select the Upload Table button in the upper-right corner of the page

upload

Note: Most Administrators will keep a small .csv table on their Desktop that contains the last 10 or 20 recently added C/M. In other words, you don’t have to save the complete table, only the updates. This can also be a time-saver as it does not require you to download the whole table.

On this page, select Choose File to locate the .csv file that you saved: 

upload

Select the Update option, and click Submit. When finished, you receive an email to the email address listed letting you know if the upload completed successfully or if it failed. After you get the email confirmation the new profile value will be available in your repository. The Delete and Replace options can be used if needed.

Lookup tables that are uploaded to a parent attribute will not update the child attribute values. 
Lookup tables uploaded to a child attribute will update the parent attribute values. This is because a child attribute knows its parent (using the attribute ID), but a parent attribute does not know its child attributes. 

Typically, an Administrator will complete this process in less than one minute. Many firms, (those that have to manually update their C/M tables) do this update once or twice a day.

If you have any questions about this process or if you run into issues please submit a Support Request at support.netdocuments.com.

Back to Top

Was this article helpful?
3 out of 3 found this helpful
Powered by Zendesk