Registering Users in Courses Using the Registration CSV

After courses and user accounts have all been created, a registration import is the final piece to getting users enrolled in their respective courses with appropriate access.

Generate a Registration Import CSV

Using any standard spreadsheet editing software, you're going to create a CSV with 4 columns that correspond to the fields necessary for registering users into courses. Here's a template to get you started.

Description of fields/columns

The course registration CSV is similar to the standard user creation/update CSV in that it uses the “1” is “yes” “0” is "no" logic for some of the fields. Below are descriptions of each field according to its corresponding column in any application that allows you to edit spreadsheets:

A. Course SyncID - Sync ID for the course (located in column A in the course import CSV)
B. User SyncID - Sync ID for user to be enrolled in the course (located in column A in both the simpla and standard user import CSVs) 
C. 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" 
D. 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.

Preparing the CSV for Export

Once all of the relevant data has been put into the file in the correct format, be sure to remove any of the guides that were being used so that the first cell (A1) has [registration] in it, immediately followed by the data being uploaded as shown in the image above.

The Registration Import can be completed using either the new administration area, or the classic administration area.

Registration Import in the New Administration Area

System level administrators can access the New Administrator tools by logging in and appending "/administration" at the end of their Digication institution URL, for example: http://yourschool.digication.com/administration.

On the Administration home page, select Import (1) from the left-side menu.

2csv.jpg

Select Upload from the expanded Imports menu.

4csv.jpg

Select the Advanced Upload tab (2). Click the Select a file button (3) to locate your CSV on your computer and select the check box for Use Debug Mode (4) to generate a system log for this upload. Select Data (5) and then click the Upload button (6) when you are ready to start the process.

1csvcourse.jpg

After you upload your CSV, you will be taken to your Logs for technical details about the upload and its progress. Each uploaded file will be represented by its own row in the Logs.  The Status column (7), will likely show as “Processing” immediately after you upload.  You may need to refresh the page a few times until the status shows as “Complete.”  You can view the Successful Entries and Error Entries (8) to determine if your import has been successful.

7csv.jpg

Registration Import in the Classic Administration Area

Go to the Administration tab

Once your CSV is correctly formatted and ready to go, you'll want to head over to the "Administration" tab to upload it.

Click on Import

Select "Upload"

Check off "Debug" before selecting and uploading your CSV

The "Logs" Page

After a standard CSV, you'll be brought to the "Logs" page where you'll be able to see how many imports have been attempted and how many entries within those imports have been successful.

Refresh to view your results

After refreshing, you'll be able to view the results of your import once it's complete and then adjust or re-upload accordingly. Keep in mind that for large data imports, you'll have to wait a few moments before this information becomes available.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.