Our Batch Import feature will allow you to import up to 100 user accounts into Conover Online at a time without having to manually add each user. To access this feature, choose the Create Accounts tab.
Select the Batch Import menu option.
Before you can use the Batch Import feature, you must have a file ready that you can use to import your users. If you look at the screen, we show you a sample of how your data should look. You can also download a copy of this data by selecting the Download button.
To import users into Conover Online, you must follow a few rules when creating your file.
- You are limited to 5 columns.
- You are limited to 100 users.
- You must provide at a minimum, the users name and email address.
- The name can be the Full name or broken down by First and Last name.
- The file must be in CSV (comma separated values) format.
- If you are having problems, make sure your file is save as UTF8 format
Here is how a properly formatted file looks in Excel. Remember that you do need to keep the Header row (bold titles) in the file when you import. If you forget this line, your first user will be skipped. Once you have your file formatted properly, save the files as CSV (comma separated values).
Once your file is ready, select the Choose File button and select your file.
For the Separator, leave it as Comma. Select Continue to upload your file.
Once you upload your file, you will see your date in the Preview Window. Use the Show more button to view another 5 rows of data.
Next you will have to map your columns to our fields in the system. If you chose to upload only the user’s Full Name, select the Use only one column for name link. This will change the interface so you can choose only one name column.
Map your name(s), email address, tags and password columns.
If you did not provide a password column, choose No password column. This will bring up the option for you to type in the password that everyone will use. Enter your password.
Next, choose your group. System Admins will be able to choose any group in the system while Admins will only be able to select their own group(s).
If you did not include a TAG column in your CSV file, you can still apply tags to your imported users. Choose any tags that you would like applied to your users. You can pick from the list or enter your own by typing the tag and pressing Enter.
You are now ready to import your data. Please go back and double check all of your settings. Once you import the file there is no way to undo it. Select Continue to begin the data validation process. You will be able to still cancel on the next screen after you verify your data.
The system will ask you to verify your data. This is your last chance to cancel. Make sure the fields are mapped correctly.
Look at the Valid? column. It will let you know if there is a problem with any of your users. You can then make any fixes to your CSV file and start the import process over again. Any user marked as invalid will not be imported into the system.
Select the Import button to import your users. You will receive an email when the import is complete.