AccuTrack/AccuSQL
Import "Student Information"

10 September 2013
USED TO IMPORT STUDENT DATA. IMPORTED PROFILE VALUES AUTOMATICALLY STORED IN THE PROFILE TABLE

CSV Mapped Columns:

# Field Name Type (Char Limit)
1 (Student) User ID varchar(40)
2 (Student) First Name varchar(15)
3 (Student) Middle Name varchar(10)
4 (Student) Last Name
varchar(20)
5 (Student) Comments varchar(50)
6 (Student) Phone varchar(13)
7 (Student) Cell Phone varchar(13)
8 (Student) Email varchar(100)
9 (Student) Address varchar(35)
10 (Student) City varchar(15)
11 (Student) State varchar(2)
12 (Student) ZIP varchar(10)
13 (Student) Card ID varchar(40)
14 (Student) Optional Date DateTime (8)
15 (Student) Profile Question #1 CUSTOM
16 (Student) Profile Question #2 CUSTOM
17 (Student) Profile Question #3 CUSTOM
18 (Student) Profile Question #4 CUSTOM
19 (Student) Profile Question #5 CUSTOM
20 (Student) Profile Question #6 CUSTOM
21 (Student) Profile Question #7 CUSTOM
22 (Student) Profile Question #8 CUSTOM
23 (Student) Profile Question #9 CUSTOM
24 (Student) Profile Question #10 CUSTOM
25 (Student) Password VARCHAR(40)

*Fields highlighted in yellow are required to import.

Explanation:

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. This field uses the xxxxxxxxxx format, so do not add any - our () to the field.

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 obviously optional but can be used to keep graduation date, birth date, or anything you may want to have in the "MM/DD/YYYY" 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.

The Password is optional but is required if you are using Web Gateway for web-based appointments or for students to access their Student Pad.

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:

  • Update student data from import file if the student already exists (recommended) - This allows you to update students instead of skipping them if they already exist.
  • Inactivate students that are not in the import file (recommended) - This allows you to speed up the database interactions by flagging students as inactive if they are not on your current import.

BACK to List of Imports