Who can use this feature?
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
Feedback About the Article
Let us know what was helpful or not helpful about the article below.2 comments
Hi there.
the import/export is very straight forward and as with every tool on the site - very easy to do.
there are clearly a number of users who are either robots or simply trash.
One important question. I would like to "scrub" our front end users. I haven't done this yet, and would very much like to know if the following is the way to do so.
I have exported my front end users to a CSV file, I then used tools in Excel to Identify users I felt were invalid, out of over 1150 I was able to delete around 60-70 users.
Can I now then IMPORT that scrubbed file right back into the system, after first deleting all of my front end users?
scrubbing the data online is tedious, but can be done.
Eric,
Thanks for the discussion on this topic. I am sure there are others out there that may have considered something similar.
I was able to discuss this with our engineering team as to find potential upsides and challenges with this process. We normally import lists when creating a new site or a new module category that may have front-end only users such as an intranet.
It is not recommended that you delete your front-end users and import the new list. This would cause site visitors to receive an email to confirm their account. This could be viewed as spam. It would also require them to set up a new password and may cause confusion as to why their current password no longer works.
It is suggested that you would delete those unwanted users directly from the CMS.
Please sign in to leave a comment.