AccuTrack/AccuSQL
Import "Student, Activities, Registration Combined"
| USED TO IMPORT STUDENT DATA, IMPORT CATEGORY/ACTIVITY INFORMATION (I.E. SUBJECTS AND CLASSES), AND REGISTER STUDENTS FOR ACTIVITIES IN ONE IMPORT |
CSV Mapped Columns:
*Fields highlighted in yellow are required to import.
Explanation:
The Category is used to group activities on the sign-in screen like a "top-level domain" certain activities fall under.
The (Activity) Identification is a unique ID for the activity. Such as MATH-100, ENGL-110, ESOL-655.
The Activity (Name) is the only required field to create an activity.
The Activity_Other is optional that can be used to provide additional information about the activity.
The Lab ID was used to provide information about the Local Lab but has been superseded by assigning the Activity to Local Lab via import.
The Class Days are the days of the week the class occurs. Use the first 3 characters of each day separated by something other than your comma or tab delimiters such as "Mon/Wed/Fri" to state the class is meeting on Monday, Wednesday, and Friday. Alternative versions of that info: "Mon-Wed-Fri" or "Mon;Wed;Fri" or "Mon*Wed*Fri" etc.
The From is the actual start time of the class in military time. Such as 13:00 for 1 PM or 10:00 for 10 AM.
The To is the actual end time of the class in military time. Such as 14:00 for 2 PM or 11:00 for 11 AM.
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.
The First Name and Last Name are required. It's usually displayed in the format Last, First. You can also optionally specify the Middle Name
The Comments are optional that can be used to add information about the student you may want to know/see on the Modify Student screen.
The Phone is optional that can be used to create a directory report.
The Cell Phone is optional but highly recommended due to the fact it can be used to send out SMS messages to students as reminders or important center/campus announcements.
The Email is optional but highly recommended. It allows users to log in without remembering their User ID, reset their password, receive messages and notifications, and a lot more things. The email has to be unique across all the users too.
The Address is optional that can be used to create a directory report.
The City is optional that can be used to create a directory report.
The State is optional that can be used to create a directory report.
The ZIP is optional that can be used to create a directory report.
The Card ID is optional. It's only useful if you plan to track attendance by reading physical cards using a card reader or the iAccu for iPod touch/iPhone/iPad.
The Optional Date is optional but can be used to keep graduation date, birth date, or anything you may want to have in the "date/time" format.
The Profile Question #1 may appear as Gender? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #2 may appear as Ethnic background? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #3 may appear as Did you graduate? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #4 may appear as GED? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #5 may appear as Age Group? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #6 may appear as Program? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #7 may appear as Classification? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #8 may appear as Residency? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #9 may appear as Enrollment Status? If it does and you want to change the question click here to learn how to Setup Profile Questions.
The Profile Question #10 may appear as Referred by? If it does and you want to change the question click here to learn how to Setup Profile Questions.
Example:
Download/View the example file (CSV)
Import Behaviors for this Import
When you run this particular import there are not any import behaviors. Import behaviors typically allow you to modify the way the import is run for different results than normal. If you have any ideas for adding an import behavior please submit them to AccuTrack/AccuSQL's User Voice.