Import Courses with a CSV/XLS File (Enterprise)

Follow

Importing Courses

The second tab in the Import area enables you to import courses into your school.

Note: Schoology is optimized to process imports and exports (auto or manual) most quickly between the hours of 7pm to 6am Eastern Time (ET) from Monday to Sunday. Imports or exports that are run outside of this window will be slower to complete. Schoology strongly recommends performing or scheduling all imports, exports, and bulk deletions during this time frame, including manual imports as well as scheduled auto-imports, for optimal performance.

Step 1 — Select file

The XLS or CSV file for import must contain at least the following columns:

  • Course Name
  • Course Code
  • Section Name
  • Section Code or Section School Code 
  • Grading Period

Please read the following article for best practices with these fields: What's the difference between Section Code and Section School Code?

School

If there is more than one school in your Schoology account (For example, Schoology District, Schoology High School, and Schoology Middle School), you’ll see a field for the School, into which you may import users. If you do not see this field in your import area, you can ignore this section.

The school designated in this field associates courses in your file to the selected school. Alternatively, you may add a School column in your file to associate courses to a particular school by selecting Use Import File.

Grading Period(s)

If you have selected Select Periods in the Grading Period(s) area of this screen, the grading periods listed are the grading periods you’ve created through School Management: Grade Settings. Check the box next to a grading period to associate all the courses in the file to all of the selected grading periods.

select_periods.png

Alternately, select Use Import File to map values in your CSV file to the Grading Periods you have created in Schoology through School Management: Grade Settings

Use_import_file_courses.png

A note about Grading Periods and Sub-Periods

If you have sub-periods within any of your grading periods, you only need to map your CSV file to the main grading period(s). For example, mapping your file to the year-long period automatically associates the course with all sub-periods such as semesters and quarters. 

So, if your school's grading periods include semester-long grading periods, with sub-periods for each quarter, like this:

Semesters_with_subperiods.png

Include only the semester periods in your import file:

courses_import_file.png

Then, map the file to the year-long grading period in the Import screen:

subperiods_included_in_mapping.png

When you run the import, the courses will associate with the semester-long grading periods and the quarter sub-periods:

resulting_grading_periods.png

Select File

Select the XLS or CSV file that contains the course information for import.

Update existing records

Selecting this option locates existing course sections by Course Code and Section Code/Section School Code, and updates new information from the XLS or CSV file. Importing an empty column does not remove information from Schoology. For example, importing a file with no course description does not remove existing course descriptions from Schoology.

Note: To update the grading period(s) for a section, that section must have a Section School Code. For sections using Section Code, you must update grading periods manually from the Course Listing page or the course itself.

Step 2 — Match Columns

  1. In the second step of the import process, match the information listed in each column to create courses in Schoology.
  2. Match each Schoology Field to a column in the XLS or CSV file.
  3. Once you've matched each field to the appropriate column, click Preview.

match_columns_course_import.png

Step 3 — Preview/Confirm

New courses and sections display under Created Courses and any courses you're updating display under Updated Courses. Adjust courses under the Errors heading according to their error message. Click Run to complete the import process when all information appears correct.

Preview_courses_import.png


Comments

0 comments

Article is closed for comments.

Powered by Zendesk