Overview
This article will show you how to import users into your site from an existing user spreadsheet.
File Format Rules
If your site is on the Platform, then you will have a Product Dropdown available from the CivicPlus logo. If you are NOT on the Platform, this Dropdown will not be available.
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
- First Name
- Last Name
- Email Address - Limited to 255 characters
- Groups (all groups that users should be added to)
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
- First Name
- Last Name
- Username
- Password should be at least five (5) characters long
- Email Address - limited to 255 characters
- Groups (user should be added to)
Instructions
- Navigate to Modules > Site Tools > User Administration
- Select Import Users
- Select Choose File
- Select and Open the file on your computer
- Select Import File
- View Successful Import prompt
Comments
Let us know what was helpful or not helpful about the article.0 comments
Please sign in to leave a comment.