Import Users

Prev Next

This article will show you how to import users into your site from an existing user spreadsheet.

Who can use this feature?

System Administrator

File Format Rules

For Sites On CivicPlus Organizations

The file must be a text file with a file name extension .TXT or .CSV

Format Rules:

  • Fields must be comma-delimited

  • Each record should be placed on a separate line

  • All fields must be present, even if empty

  • Only the Groups field may be empty

  • Blank lines will be ignored

  • Duplicate entries will be ignored

  • Groups should be in one field and delimited by a pipe ( | )

Fields, in order:

  1. First Name

  2. Last Name

  3. Email Address - Limited to 255 characters

  4. Groups (all groups that users should be added to)

For Sites Off CivicPlus Organizations

The file must be a text file with a file name extension .TXT or .CSV

User Type:

  • Standard: Default user type used by the CivicPlus CMS application

  • LDAP: User type when integrated with an LDAP system

Format Rules:

  • Fields must be comma-delimited

  • Each record should be placed on a separate line

  • All fields must be present, even if empty

  • Only the Groups field may be empty

  • Blank lines will be ignored

  • Duplicate entries will be ignored

  • Groups should be in one field and delimited by a pipe ( | )

Fields, in order:

  1. First Name

  2. Last Name

  3. Username

  4. Password should be at least 5 characters long

  5. Email Address (limited to 255 characters)

  6. Groups (user should be added to)

Instructions

  1. Sign in to your site

  2. Navigate to Modules and on the Site Tools tab, select User AdministrationUser administration selected in menu.

  3. Select Import UsersImport users button.

  4. Select Choose File and select the file on your computer Choose file to upload a file from your computer.

    Note:

    View a template in the Resources section of this article.

  5. Select Import FileImport file button.

  6. View Successful Import prompt Import summary.

Resources