...
- There is one schedule record per row/line of the file;
- The first row/line of the file must have the column names (a header row);
- If you are using a comma-delimited-text file, each field (record value) must separated be separated by a comma;
- If you are using a spreadsheet program such as Microsoft Excel to generate the CSV file, each field must reside in a different column;
- Multiple values within a single field must be separated by a bar. For example, Mon|Wed|Fri to indicate multiple days of the week;
- All fields must contain only UTF-8 ascii ASCII characters.
The column headers and field values are as follows; use UTF-8 ascii ASCII characters only:
Field Name | Description | |||||
Schedule-ID | System Identifier for the schedule. This cell must be empty for new schedules and is only required if you are updating an existing schedule. | |||||
Term-Name | Name of the existing term associated with the schedule. Maximum 50 characters. | |||||
Course-Name | Name or Course ID of the existing course associated with the schedule. | |||||
Section-Name | Name of the existing section associated with the schedule. | |||||
Title | Title to be given to the schedule being created (or updated). Maximum 200 characters. | |||||
Description | Description to be given to the schedule being created (or updated). Maximum 1000 characters. | |||||
Campus-Name | Name of the existing campus associated with the schedule. | |||||
Building-Name | Name of the existing building associated with the schedule. | |||||
Room-Name | Name of the existing room where the scheduled capture is to take place. | |||||
Recurring | Indicates whether the schedule is recurring or not. Valid values: TRUE and FALSE (not case sensitive). | |||||
Start-Date | Date the schedule is to begin. Valid formats include yyyy-mm-dd and mm/dd/yy. | |||||
Start-Time | Start time for the scheduled capture. Enter in 24-hour format: hh:mm:ss | |||||
End-Time OR Duration | Can either be the time the scheduled capture must end OR the duration of the capture. Enter only one as follows:
NOTE: You cannot create a schedule longer than four hours. Any schedules longer than four hours will not be imported. | |||||
End-Date | Required only for recurring schedules. Date of the last day for the schedule. Valid format: yyyy-mm-dd or mm/dd/yy. | |||||
Days-of-Week | Required only for recurring schedules. Days that the scheduled capture must run. Valid values are three-letter day abbreviations: sun, mon, tue, wed, thu, fri, sat, sun. Separate multiple values with a bar. For example, a Monday, Wednesday, Friday schedule is entered as mon|wed|fri.
| |||||
Excluded-Dates | Used for recurring schedules only but not required if not applicable. Specific dates or date range(s) when the schedule should not run. These might include exam dates for a course, school holidays, or spring break. Valid format: yyyymmdd for a single day; yyyymmdd-yyyymmdd for a range. Separate multiple entries with a bar. For example, the entry: 20130218|20130324-20130331|20130506-20130510 would exclude February 18 (for President's Day), March 24-31 (for Spring Break), and May 6-10 (for final exams). | |||||
Status | Indicates the desired status for the schedule being created. Valid values (not case sensitive):
This field is required. For any record where Status is blank, that schedule will not be imported to the system.
| |||||
Presenters | Identifies the presenters for the schedule. Typically this includes the Academic Staff member teaching the course, and possibly one or more Teaching Assistants. Separate multiple values with a bar. Valid formats include:
| |||||
Product-Group | Product Group Name for the schedule. To reduce the possibility of entry error, use one of the following two methods to enter this information:
| |||||
Properties
| Not required, but can be used to specify additional capture properties that are not indicated or are different from those provided through the Product Group defaults. Separate multiple properties/values with a bar. For example: Live=true|echo-initally-unavailable=false|Aspect-ratio-override-channel-1=widescreen It does not matter what order the values are entered into this field. Property values and formats are as follows:
|
...