AccuTrack/AccuSQL
Import "Student Registration"

12 September 2013
USED TO LINK STUDENT AND ACTIVITY INFORMATION. IF IMPLEMENTED, STUDENTS ONLY SEE THEIR REGISTERED ACTIVITIES AT SIGN-IN

CSV Mapped Columns:

# Field Name Type (Char Limit)
1 (Activity) Identification varchar(100)
2 Category varchar(100)
3 Activity (Name) varchar(100)
4 (Student) User ID varchar(40)

*Fields highlighted in yellow are required to import.

Explanation:

The (Activity) Identification is a unique ID for the activity. Such as MATH-100, ENGL-110, ESOL-655.

The Category is used to group activities on the sign-in screen as a "top-level domain" certain activities fall under.

The Activity (Name) is the only required field to associate an Activity with the Student.

The User ID is used to uniquely identify the user, it must be unique across all the users in the system, including students, tutors, instructors, and administrators. This will associate the Student with the Activity in each record of the import file.

Example:

Download/View the example file (CSV)

Import Behaviors for this Import

When you run this particular import you have a few "Import Behaviors" that you can apply to the import to get different results than the typical import. Simply place a check in the checkbox for each you want to apply to the import. The import behavior options for this import are the following:

  • Overwrite current registration (recommended) - This allows you to overwrite each student's registration instead of appending it to the classes they already have registered to them. As an example, if a student is registered to classes A, B, C on an initial import and then on the next import is registered to classes A, B, D then they will only have classes A, B, D with this option being checked opposed to having it unchecked where they would have classes A, B, C, D.Note: This option cannot be used if importing current registration in multiple files due to the nature of how it overwrites. Each file imported would overwrite the previous.

BACK to List of Imports