Professional Development Course/Session Import File Specifications
This document covers the required columns, optional columns, what type of data that each column will accept, what will cause errors or incomplete imports and how to export and import Professional Development Courses and Sessions.
Best Practice: Always export courses before importing new courses. Add new Courses to the Export. If nothing is changed in the new import nothing will change. Imports only make changes when new data is added.
Required Columns
The following columns need to have data for the import to work correctly. If any of the following columns have empty cells the import will fail.
Title
The Title of the Course. The field accepts letters and numbers up to 100 characters.
AudienceType
The Audience Type of the course must be an exact, case sensitive match to an existing audience type in the organization. The field accepts letters and numbers up to 100 characters.
Best Practice: Copy and paste the Audience Type from the Manage Audience Type page in Teacher Vitae Admin.
DeliveryType
The Delivery Type of the course must be an exact, case sensitive match to an existing Delivery Type in the organization. The field accepts letters and numbers up to 100 characters.
Best Practice: Copy and paste the Delivery Type from the Delivery Type dropdown in Manage course Catalog in Teacher Vitae Admin.
CourseSubjects
The Course Subjects of the course must be an exact, case sensitive match to an existing Course Subjects in the organization. The field accepts letters and numbers up to 100 characters. Multiple Subjects can be added by separating them with a semicolon.
Best Practice: Copy and paste the Course Subjects from the Manage Subjects page in Teacher Vitae Admin.
EducationLevels
The Education Levels of the course must be an exact, case sensitive match to an existing Education Levels in the organization. The field accepts letters and numbers up to 100 characters. Multiple Levels can be added by separating them with a semicolon.
Best Practice: Copy and paste the Education Levels from the Manage Education Levels page in Teacher Vitae Admin.
CreditType
The Credit Type of the course must be an exact, case sensitive match to an existing Credit Type in the organization. The field accepts letters and numbers up to 100 characters.
Best Practice: Copy and paste the Credit Type from the Credit Type dropdown in Manage course Catalog in Teacher Vitae Admin.
Optional Columns
OrgName
District level Name. This is autogenerated with no additional data needed.
MeetsCertificationRequirements
Specified if the course meets certification requirements. Allowable values: true or false (case insensitive)
CourseUniqueIdentifier
This is autogenerated with no additional data needed. However, if the course is offered by an institution using a course guid in a format like 684F9E05-991C-47BB-A73F-A7ECD39E2303 it can be added manually. If CourseUniqueIdentifier is specified, the course will be updated if the course exists, otherwise the course will be added.
Instructor
The Course Instructor. The field accepts letters and numbers up to 100 characters.
Summary
The Course Summary. The field accepts letters and numbers up to 100 characters.
Description
The Course Description. The field accepts letters and numbers up to 100 characters.
CourseNumber
If offered from an institution like a university that has course numbers. This field accepts whole numbers (No Decimals).
Credits
If the Course awards Credits like Courses offered from an institution like a university. This field accepts whole numbers and decimals.
Provider
The institution offering the Course. The field accepts letters and numbers up to 100 characters.
ProviderCourseUri
The institution’s Web Address. The field accepts letters and numbers up to 100 characters in the form of a URI or URL.
ProviderRegistrationUri
The institution’s Registration Web Address. The field accepts letters and numbers up to 100 characters in the form of a URI or URL.
ProviderContentUri
The institution’s Course Content Web Address. The field accepts letters and numbers up to 100 characters in the form of a URI or URL.
CourseImageUri
The institution’s Course Image Web Address. The field accepts letters and numbers up to 100 characters in the form of a URI or URL.
(Note) This field is only for export and does not import to Teacher Vitae. All images need to be imported manually.
Cost
The Cost of the Course if offered by an institution like a university. This field accepts whole numbers and decimals.
MinEnrollments
The Minimum number of Enrollments. This field accepts whole numbers (No Decimals).
MaxEnrollments
The Maximum number of Enrollments. This field accepts whole numbers (No Decimals).
Hours
The length of the Course. This field accepts whole numbers and decimals.
SessionName
The Name of the Course Session. If the session name and start date exists, then a Course Session will be created for the Course. Otherwise the Session will have to be added manually in the Manage Course Catalog of Teacher Vitae. The field accepts letters and numbers up to 100 characters.
StartDate
The Start Date of the Course and Session, if Session name is specified. Format is “MM/DD/YYYY HH:MM:SS.FFF”.
(Note) Time is optional.
EndDate
The End Date of the Course and Session, if Session name is specified. Format is “MM/DD/YYYY HH:MM:SS.FFF”.
(Note) Time is optional.
Notes
Any Course/Session Notes. The field accepts letters and numbers up to 2000 characters.
RegistrationDeadline
The Deadline to Register for the Course and Session, if Session name is specified. Format is “MM/DD/YYYY HH:MM:SS.FFF”.
(Note) Time is optional.
Location
Course session location. The field accepts letters and numbers up to 2000 characters.
Exporting Courses/Sessions
Login to Teacher Vitae
Hover Over More
Click Admin
Hover Over Manage PD+
Click Import / Export Course Catalog
Click Export
The Excel file will be downloaded to your computer.
Importing Courses/Sessions
Login to Teacher Vitae
Hover Over More
Click Admin
Hover Over Manage PD+
Click Import / Export Course Catalog
Click Import
Click Select File
Select the file that you wish to Import.
Click Open
Click Submit Import
The import will start
Check the Status Column
When the Status reaches Completed
Check the Details Column
A successful Import will have:
The correct number Processed(P)
The correct number Inserted(I)
The correct number of Updated(U)
Zero Deleted(D)
Zero Errors(E)
Zero Warnings(W)
And a Status of:
Completed
Import Errors
If the Import errors or does not complete
Click View in the Actions Column
Click Show next to the Import Details
Identify the error and correct it.
Related Articles
11_Create Professional Development Courses
Create the District Offered Professional Development in Teacher Vitae Prerequisites Have all links ready for Course Know Course detail Create Courses Login to Teacher Vitae Hover over More Click Admin Hover over Manage PD+ Click Manage Course Catalog ...Create Professional Development Courses and Sessions
Professional development courses must be created then sessions must be associated to them before they can be accessible and used. Create Professional Development Offerings/Courses First you need to create the District Offered Professional Development ...Admin Professional Development Overview
The Professional Development tool in Teacher Vitae is useful for both the teacher and the administration. It gives the teacher a place to track, store and organize their previous, current and past Professional Development. The administration can use ...Create Professional Development Course Sessions
NOTE: To create course sessions there must first be a course created. If you have not already created a course go back to the beginning of this document and start there. To create a session starting from the home page: Hover over More Click Admin ...Assign Professional Development/Courses Individually
Assign Professional Development/Courses Individually Login to Teacher Vitae Hover over More Manage Course Assignments Select the School Year This defaults to the current year Select the Organization Select the school Click +Add Course Assignment ...