Bulk Account Creation allows professionals to create CFNC accounts on behalf of their students. This can be helpful when you are working with classrooms of students, programs, or even an entire grade of students. You can use the provided CSV (.csv) file template and then upload the file in Bulk Account Creation. Once the accounts have been successfully created, students will be able to login using the username and password you set for them. Upon the first login by the student, they will be required to change their password. This article covers how to use the Bulk Account Creation template and how to address potential errors.
Tips:
- Many educators find it helpful to request the assistance of a school data manager or similar technical professional. You can request that they extract data from your student information system in the format of the template that you provide them from Administration > Bulk Account Creation.
- The most common challenge when using Bulk Account Creation is making sure that usernames and email address are unique. If your students have already created CFNC.org accounts, you will not be able to upload a file that duplicates or overwrites a username or email address they have already used.
Steps for Uploading Students
Select the tabs below to view the steps for uploading students.
Click to download the template, look in your downloads folder, and open the file in Excel.
Click image to enlarge
Add your student data according to the template and save it on your computer as a .csv file. See the table below for details on required fields.
| Field | Description |
|---|---|
| username | Username for the student |
| password | Initial 8-character (minimum) password for the student that they will change upon first login |
| firstname | First name of student |
| lastname | Last name of student |
| gradyear | High School graduation year of student |
| Student’s email address | |
| gender | Student’s gender (M = 0, F = 1) |
| dob | Student's date of birth xx/xx/xxxx |
| question | Student’s security question: Enter one of the following options: 1. What is your mother’s maiden name? 2. What is the city your mother was born in? 3. What is the name of your first pet? 4. What is the name of your first elementary school? 5. What is the name of the street you grew up on? 6. What is the first name of your maternal grandmother? 7. What is the first name of your paternal grandmother? 8. What is your childhood nickname? 9. What is your high school mascot? (recommended) |
| answer | Answer to the security question (if you've used the recommend question, it'll be much easier since it will be the same for all). Students can change this later and personalize. |
| role | Select number 1,2,4, or 8 1= middle school student 2= high school student 4= college (postsecondary) student 8= adult learner |
| street | Student’s physical street address |
| city | Student’s physical city |
| state | Student’s physical state |
| zip | Student’s physical zip code |
| county | Student’s physical county |
| country | Student’s physical country |
| mstreet | Student’s mailing street address |
| mcity | Student’s mailing city |
| mstate | Student’s mailing state |
| mzip | Student’s mailing zip code |
| mcounty | Student’s mailing county |
| mcountry | Student’s mailing country |
Click image to enlarge
After you have added your user data to the template and saved the new .csv file to your computer, go back to Bulk Account Creation and drop your file in the space provided. Confirm that you are uploading to the correct school.
CAUTION: Make sure you are uploading with the correct school name selected in ProTools. For instance, in the image below, students will be uploaded and connected to A C Reynolds High. If you administer more than one school, it's possible to upload students to the incorrect school, and you will not be able to undo this action.
Click image to enlarge
Troubleshooting
You many encounter error messages after uploading your file to Bulk Account Creation. Here's a list of potential errors:
- Error: The User name field is required.
- Error: The Email field is required.
- Error: The ConfirmationEmail field is required.
- Error: The FirstName field is required.
- Error: The LastName field is required.
- Error: The PermStreet field is required.
- Error: The PermCity field is required.
- Error: The PermCountry field is required.
- Error: The MailingStreet field is required.
- Error: The MailingCity field is required.
- Error: The MailingCountry field is required.
- Error: The Password field is required.
- Error: The SecurityQuestion field is required.
- Error: The SecurityAnswer field is required.
- Error: Invalid value for Gender
- Error: Invalid value for User Role
- Error: Invalid value for Security Question
- Error: First name must contain only letters, spaces, -, or '
- Error: Last name must contain only letters, spaces, -, or '
- Error: The Password must be at least 8 characters long.
- Error: Email not available
- Error: User name not available
- Error: User name can contain only letters, numbers, or an underscore
- Error: The user name does not meet length requirements.
- Error: Cannot use mycfnc.org email addresses.
- Failed to Create Account.
- Error: File can only be in csv format. An example file can be found by clicking the Download Template button.
- Error: Must select a file to upload.
Please note that not all ProTools users have this feature since access is controlled at the Administration level for each school or organization.