Getting Started with Account Creation and Registration Imports

This is the quickest and easiest way to create user accounts. Below are notes on the fields this import file will contain. Attached file: UPLOAD_SIMPLE.csv

1. AccountID - A permanent unique identifier, such as a school ID number. This field is the same as the User SyncID field in the CSVs described below. 
2. FirstName 
3. LastName 
4. Username - Must also be unique within your school.
5. Email - Must be a valid email address format. For example: name@myschool.edu
6. Password - We recommend a randomized password of at least 8 characters.
7. IsFaculty - Either “yes” or “no.” “No” means the user will be created as a student. 
8. HaveCOPPA -Either “yes” or “no.” Affirms that the student is 13-years old or older, or has a COPPA form on file with the school. 
9. Birthdate - Can be left blank if the HaveCOPPA field is "yes".

Please make sure there are no spaces or returns following the data in any field.

Once the CSV has all of the user data in it: 
- Go to the "Administration" page in Digication and select "Import." 
- From the list of available options select "Upload Simple" 
- Select "Choose File" to find the CSV with the data and then hit "Upload" to import the users.

You'll be notified if any errors occur after the import.

You can also create, and update users using a the full user import CSV described below.

The full user import (Attached File: USER_DATA_IMPORT.csv) has the following columns:

1. SyncID - User email or associate ID number (whichever is used to sync with courses) 
2. First Name 
3. Last Name 
4. Password 
5. Username 
6. Email 
7. Show Image - Always should be “1" 
8. Major - Can be left blank. 
9. Graduation - Can be left blank. 
10. Faculty - 1 is “yes” and 0 is “no,” meaning that it is a student account. 
11. Website - Can be left blank. 
12. Active - Should always be “1” when creating users. When updating users, enter “0” if for those to be deactivated. 
13. Birthdate - Can be left blank. 
14. COPPA - Needs to be “1” for account to be created. Means that users are over the age of 13 and/or have a COPPA form on file. 
15. Update - “1” if the user in the row is being updated and “0” if the user is being created for the first time. 
16. Delete - “0” if the user is being created or updated and “1” if you wish to delete the user.

Each row represents the user being created, updated or deleted. In the file sample provided it’s important to know that the second and third rows appear only as guidelines/examples and must be deleted before the CSV is uploaded into the system. The final CSV should only have [Users] in the first column of the first row with user data following it.

Once the CSV has all of the user data in it: 
- Go to the "Administration" page in Digication and select "Import." 
- From the list of available options select "Upload" 
- Select "Choose File" to find the CSV with the data and then hit "Upload" to import the users. 
*You can also select "Use Debug Mode" to be notified of any errors occur upon uploading.

The course creation CSV (Attached File: COURSE_CREATE.cv) is similar to the user creation CSV in that it uses the “1” is “yes,” “0” is no logic for some of the fields. Here are a description of each:

1. SyncID - Arguably the most important field, this number should be completely unique for each section, semester, and year so that enrollment using the registration CSV runs smoothly. 
2. Course Type - Always should be “COURSE" 
3. Title - Title of the course. 
4. Course Number - Number of the course from your institution’s registration data. 
5. Description - Can be left blank. 
6. Active - Must be “1,” meaning the course is active. 
7. Start Date - Course Start Date 
8. End Date - Course End Date 
9. Gradebook - “1” enables grade book for the course “0” disables the feature. 
10. Attendance - “1” enables the attendance feature for the course “0” disables the feature. 
11. Update - If the course is already created “1” updates whatever information has been changed using the course SyncID. 
12. Delete - Use “0” when creating a course. “1” deletes an already created course. 
13. Discussion - “1” enables the Discussions tab for the course “0” disables the feature. 
14. e-Portfolios - “1” enables the e-Portfolios tab for the course “0” disables the feature. 
15. Assignments - “1” enables the Assignments tab for the course “0” disables the feature. 
16. Standards - “1” enables the Standards tab for the course “0” disables the feature. 
17. Section Number - Section number from your institution’s registration data. 
18. Department Code - Can be left blank.

Optional Fields:
The following optional fields for CSV imports can be added to the course import CSV, but they are not necessary for its successful upload an processing:

• Jumpstart Assignment - "1" creates a 1-step submission assignment within the course and "0" does not.
• Allow Student Signup - "1" allows students the ability to self-enroll into the course and  "0" disables the feature.
• Student Signup Password - For limiting student signups only to those who have a password, one can be indicated here. For courses in which passwords are not needed for signing up, this field can be left blank.

*Please note that these optional fields are not necessary for the uploading.

Just as with the user import, rows 2 and 3 are for reference only. Please delete them both before uploading. The final CSV should only have [course] in the first column of the first row with the course import data following it.

Once the CSV has all of the user data in it: 
- Go to the "Administration" page in Digication and select "Import." 
- From the list of available options select "Upload" 
- Select "Choose File" to find the CSV with the data and then hit "Upload" to import the users. 
*You can also select "Use Debug Mode" to be notified of any errors occur upon uploading.

Once the student and faculty accounts have been created, you’re going to use the course and user SyncIDs to enroll them in the course. The Registration CSV (Attached File: COURSE_REGISTRATION.csv) only has four columns. They are:

1. Course SyncID - Sync ID for the course 
2. User SyncID - Sync ID for user to be enrolled in the course 
3. Faculty - If the user is to be enrolled as faculty then this field should have a “1” and if they are a student is should say “0" 
4. Delete - This should be set to “0” unless this you are running an update in which you are removing users in which case you’ll use a “1” instead.

As with both other CSVs, the data being imported should immediately follow the first row that has [Registration] in it’s first column.

- Go to the "Administration" page in Digication and select "Import." 
- From the list of available options select "Upload" 
- Select "Choose File" to find the CSV with the data and then hit "Upload" to import the users. 
*You can also select "Use Debug Mode" to be notified of any errors occur upon uploading.

• COURSE_CREATE.csv (490 Bytes)
• COURSE_REGISTRATION.csv (107 Bytes)
• COURSE_CREATE_OPT.csv (593 Bytes)
• UPLOAD_SIMPLE.csv (164 Bytes)
• USER_DATA_IMPORT.csv (374 Bytes)