Follow

ACP Course Import

Before importing courses, set up your Departments and Programs. After your Departments and Programs of Study are set up, you can build an import file to add/update/delete courses within your ACP Courses Library

Create Import File

Make a copy of the ACP Course Import Template Google Sheet or if you already have courses in your library, "Download Full Library" to generate a file that contains your current course information. 

*Indicates required fields for a course

  1. *Column A - course_number: Enter the Course Number (max 255 characters)
  2. *Column B - course_name: Enter the Course Name (max 255 characters)
  3. Column C - course_description:  Enter the Course Description
  4. Column D - course_type:  Enter the Course Type (max 255 characters)
  5. Column E - credit_type:  Enter the Credit Type (max 255 characters)
  6. Column F - required_course: Enter 0 if the course is not required (no). Enter 1 if the course is required (yes)
  7. *Column G - department: Enter the course's department
    Note: The department will need to match the names of a department in your Departments to be able to import courses.
  8. Column H - employment_type: Enter the Employment Type (max 255 characters)
  9. *Column I - pathway_id: Enter the Pathway ID
    Note: The ACP Course Import Template Google Sheet has a Pathway IDs field that you can use to identify the ID for each primary pathway.
  10. *Column J - program_of_study: Enter the course's program code
    Note: The program code will need to match the code of a program in your Programs to be able to import courses.
  11. Column K - college_credit: Enter 0 if the course doesn't offer college credit (no). Enter 1 if the course does offer college credit (yes)
  12. Column L - certification_available: Enter 0 if the course doesn't offer a certification (no). Enter 1 if the course does offer a certification (yes)
  13. Column M - accrediting_college_credit_institution: If the course offers college credit, enter the name of the accrediting college/university (max 255 characters)
  14. Column N - course_sequence_level: Enter the course sequence level (max 255 characters)
  15. *Column O - suggested_grade_level: Enter the suggested grade levels separated by a comma. For example, 9,10,11,12
  16. Column P - school_year: Enter the school year that the course will next be available
  17. Column Q - isactive: Enter 0 if the course isn't active (no). Enter 1 if the course is active (yes) and should display on your ACP site

After adding your course information in your Google Sheet, under File select Download > Tab-separated values (.tsv, current sheet) to download the file. 

download-tsv-file.jpg

Import Courses

courses-library-upload-file.jpg

From the ACP Courses Library page, select Upload File. 

upload-file.jpg

  1. Choose your .tsv import file
  2. Select if you would like to replace existing course data or update current course information

Select Upload Course File to complete the import.

Video Tutorial

This video tutorial will walk through how to complete the Course Import file for the Academic and Career Planning Guide module in CMS4Schools.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.