Student Import Overview

Students may be imported into the MHC GED Online database from a tab-delimited text file.

The columns in the import file must be as follows:

Column 1:         Student First Name       (Required)

Column 2:         Student Last Name       (Required)

Column 3:         Student Login ID          (Required)

Column 4:         Student Password         (Required)

Column 5:         Class ID (Optional: if all of the students in the file are to be assigned to the same class, you may leave the class id blank in the import file, and specify the class on the “Preview/process student import” form; alternatively, if you would rather import the students with no class assignment, you may leave the class blank in the import file, and select “Will assign class later” on the “Preview/process student import” form.)

                        If you do elect to enter class id in the import file, it must exactly

                        match the name of a class which has been added to the MHC GED

                        Online database via the Management menu system.

Column 6:         Institution ID (Optional: if all of the students in the file are to be assigned to the same institution, you may leave the institution id blank in the import file, and specify it on the “Preview/process student import” form.)

                        If you elect to enter the institution id in the import file, it must exactly

                        match the name of an institution which has been added to the MHC GED

                        Online database via the Management menu system.

If you wish, you may download a template to use as a guide for creating the import file, by selecting menu option “Management…Manage users…Import students…Download student import template”. You do not have to use this template, if you would prefer to create your import file using some other program.

Regardless of what program you use to create the import file, the requirements are that the columns in the file match the column specifications described in this document, that a single tab is used to separate each column, that special characters are not used, (such as “@”, “&”, etc.), and that the file is saved as a text file.

Once you’ve created and saved your import file, click “Management…Manage users…Import students… Preview/process student import”. The system will prompt you for information, such as your customer id, the location of the import file, etc.

If the first record of your import file is simply a heading record, and does not actually contain student data, then respond “Y” to the “1st Record Is A Heading” prompt; otherwise, respond “N” to this prompt.

When you click “Preview”, the system will read your import file and check it for errors. If there are serious errors in the file, you will see the message, “Import cancelled due to serious errors.” If some records are importable, and some not, you will be asked if you wish to import the records which do not have errors. If no errors are found, you will be asked to perform the import of the students.

If you choose to perform the import of the students, a list of the students added to the database will be displayed.