Upload faculty data in bulk

In this Article


Use a datasheet template to fill out faculty data in bulk for a faster, more efficient way to add them as constituents to your platform. 

Step 1: Download datasheet template

Step 2: Complete the spreadsheet

  1. Open the template in your favorite spreadsheet software, such as Google Sheets or Microsoft Excel.
  2. The first column of the datasheet is the ImportID. This code can be any combination of letters and numbers, as long as it is unique to the constituent.
  3. The Username and Password columns will be used to generate portal logins for constituents. Usernames must be unique across all roles.
  4. The rest of the columns in the datasheet correspond to profile fields in Constituent Manager. You may delete any columns that you won’t be using. If there are fields in your profile that aren’t included on the datasheet, you can make a new column for them, as long as the header matches the field name in Constituent Manager.
  5. The Location and Department columns will create groups for the constituents in Group Manager, where you can manage the membership later. Be careful that the data in these columns is correct and consistent, so you don’t create two different groups for “Art Department” and “Arts Department.” 
  6. Faculty constituents can be members of up to three Locations and up to three Departments. They can also have up to five titles.
  7. Constituents can have up to four email addresses in their profiles: one each for home, school, work, and a generic email. Copy the email address from one of the other columns into the email_primary column to set this value in the constituent profile.

Step 3: Download and save as .txt file

Important Note:

  • DELETE the instructions column before downloading.
From Excel From Google Sheets

Save As a .txt file from Excel

Select File > Save As > Text (Tab delimited) .txt

Step 4: Upload the datasheet or submit to FS support 

Option A: Follow the instructions in Upload constituent data to Constituent Manager to import the completed datasheet yourself.

Option B: Submit a Request to Finalsite Support. We'll update your site's database to include this information. 

Was this article helpful?
3 out of 8 found this helpful

Comments

0 comments

Please Sign in to leave a comment if you don't see the comment box below.