AccuTrack/AccuSQL
Import "Student, Activities, Registration Combined"

12 September 2013
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:

# Field Name Type (Char Limit)
1 Category varchar(100)
2 (Activity) Identification varchar(100)
3 Activity (Name) varchar(100)
4 Activity Other varchar(6)
5 Lab ID varchar(10)
6 Class Days varchar(100)
7 From datetime(100)
8 To datetime(100)
9 (Student) User ID varchar(40)
10 (Student) First Name varchar(15)
11 (Student) Middle Name varchar(10)
12 (Student) Last Name varchar(20)
13 (Student) Comments varchar(50)
14 (Student) Phone varchar(13)
15 (Student) Cell Phone varchar(13)
16 (Student) Email varchar(100)
17 (Student) Address varchar(35)
18 (Student) City varchar(15)
19 (Student) State varchar(2)
20 (Student) ZIP varchar(10)
21 (Student) Card ID varchar(40)
22 (Student) Optional Date datetime (8)
23 (Student) Profile Question #1 CUSTOM
24 (Student) Profile Question #2 CUSTOM
25 (Student) Profile Question #3 CUSTOM
26 (Student) Profile Question #4 CUSTOM
27 (Student) Profile Question #5 CUSTOM
28 (Student) Profile Question #6 CUSTOM
29 (Student) Profile Question #7 CUSTOM
30 (Student) Profile Question #8 CUSTOM
31 (Student) Profile Question #9 CUSTOM
32 (Student) Profile Question #10 CUSTOM

*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 activites fall under.

The (Activity) Identification are 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 superceded by assigning the Activity to Local Lab via import.

The Class Days are the days of the week of the class occurs. Using the first 3 characters of each day seperated 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 is 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 annoucements.

The Email is optional, but highly recommended. It allows users to login without remembering their User ID, to reset their password, to 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 obviously optional but can be used to keep graduation date, birthdate, or anything you may want to have 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 P rofile 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 hereto 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 ran for different results that normal. If you have any ideas for adding an import behavior please submit them to AccuTrack/AccuSQL's User Voice.

BACK to List of Imports