Advisory Group Data Import

Data managers can use the data import process to import advisory group data.

1. Select Core.

2. Select System tools.

3. Select Data import.

4. Select Create import job.

5. Select the "Advisory Groups" Category.

These Import types appear:

• Advisory Advisories

• Advisory Section

• Advisory Enrollment

For a list of all import fields, requirements, data types, max length data, descriptions, and information on whether or not you can remove data from the field, open the detailed view screen by selecting the following on the import screen: Category > Import type > View file layout help (under File layout help) > Detailed view. A screen similar to the following displays.

Download Sample Import Layout File

You can view and download sample import files.

1. Select Core.

2. Select System tools.

3. Select Data import.

4. Select Create import job.

5. Select the Category and Import type of the information being imported.

6. Select View file layout help.

7. Select Detailed view to view the file layout fields; select Sample file to download a sample import file from which you can work to create your import file.

Advisory Advisories

Use this import to import advisories that will grade and take attendance. Required fields are: course_title, course_code, course_length, level_description, inactive, publish.

Advisory Sections

Scheme 1

Use Scheme 1 only under the advisement of Blackbaud.

Scheme 2

Use Scheme 2 if you have a course code tied to each advisory for which you will create sections. This scheme matches on course code rather than course title. Required fields are: section_identifier, course_title, school_year_label, this_duration, level_description.

Scheme 3

Use Scheme 3 if you have a course title tied to each advisory for which you will be creating sections. This scheme matches on course title rather than course code. Required fields are: section_identifier, school_year_label, this_duration, level_description, course_code.

Advisory Enrollments

Scheme 1

Use Scheme 1 for importing enrollments using the student's first name, last name, and course code. Required fields are: irstname, lastname, grad_year, school_year_label, this_duration, level_description, course_code, section_identifier.

Scheme 2

Use Scheme 2 for importing enrollments using the student's first name, last name, and course title. Required fields are: firstname, lastname, grad_year, course_title, school_year_label, this_duration, level_description, section_identifier.

Scheme 3

Use Scheme 3 for importing enrollments using the student's Host ID and course code. Required fields are: host_id, school_year_label, this_duration, level_description, course_code, section_identifier.

Note: The Host ID is the identification value from an external database.

Scheme 4

Use Scheme 4 for importing enrollments using the student's User ID and course code. Required fields are school_year_label, this_duration, level_description, user_id, course_code, section_identifier.

Note: The User ID is the identification value from the database.

Scheme 5

Use Scheme 5 only under the advisement of Blackbaud.