Bulk Profile Upload

The Bulk Profile Upload tool allows you to add and update user profile information to multiple user in one job. The following fields are currently supported by the Bulk Profile Uploader : 
  • Company 
  • Job Title
  • Work Phone Number
  • Mobile Phone Number 
  • Fax Number
  • Work Address
    • Street Address
    • City
    • State
    • Zip
  • Job Department

 .   Note that all "Upload" tasks require the file size to be under 1MB.

Download the template

Download our current template that can be found here, or download the template from the attached file. The first row contains the following eleven headers:
    •  email
    •  company
    •  jobTitle
    •  workNumber
    •  mobileNumber
    •  faxNumber
    •  workStreet
    •  workCity
    •  workState
    •  workZipCode
    •  jobDepartment

    The following contains important information on configuring your CSV file.

    Important! When editing your template the following headers must be present and in the following order:

    email, company, jobTitle, workNumber, mobileNumber, faxNumber, workStreet, workCity, workState, workZipCode, jobDepartment

    If one of these headers are missing or not in the correct order, data may not upload to profiles correctly. 
    The template should also be in the file format of CSV.

     Important! When editing your template do not add additional commas. A CSV file is a comma separated file. 
     Adding additional commas will cause the upload to fail. 

     Important! Secondary domains are not supported at this time. 

     Important! We highly recommend making and editing your CSV files in Google Docs. Due to a difference in formatting, CSV
     files created and/or edited with the following software will not upload properly:
  • Open Office 

Template Options

You have three options you can enter for any of the fields when populating the template. 

  • If you wish to overwrite a field of a user's profile, then just simply put the new information into the field.

  • If you do not wish to overwrite a field of a user's profile, then leave the cell in the CSV file empty. 

  • If you want to clear that field of a user's profile, then enter clear in the cell in the CSV file. 

Upload CSV File

To get started, click the Bulk Profile Upload link on the Bulk Operations page. 

Click Choose File and navigate to the directory your CSV file is located in.

Select the CSV file and click Open

Verify that you've selected the correct file and click Submit.

Note: Check the box to have the results of the upload saved to a Google Spreadsheet.  
This can help you identify any profile uploads which were unsuccessful, if any.

You will receive an email notification once the process is complete. 

Nathan Dixon,
Jun 20, 2012, 7:32 AM