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
Sites On 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 ( | )
Sites On Fields, in order:
First Name
Last Name
Email Address - Limited to 255 characters
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
Sites Off User Type:
Standard: Default user type used by the CivicPlus CMS application
LDAP: User type when integrated with an LDAP system
Sites Off 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 ( | )
Sites Off Fields, in order:
First Name
Last Name
Username
Password should be at least 5 characters long
Email Address (limited to 255 characters)
Groups (user should be added to)
Instructions
Navigate to Modules and on the Site Tools tab, select User Administration:
Select Import Users:
Select Choose File and select the file on your computer:
Note:
View a template in the Files section of this article.
Select Import File:
View Successful Import prompt:
