The CVC-OEI has been working with our vendor for Finish Faster Online, Quottly.com, to improve the accuracy of their inventory of CCC classes. For Summer 2019, you have the opportunity to create and provide a CSV file with your classes that Quottly can use.
General Formatting Information
Any inconsistencies regarding format will prevent the data sheet from being uploaded properly. Moreover, using a campus/college name other than what is designated below will also result in course data not appearing.
- What format and columns are required?
The class information needs to be provided in a comma-separated value file (.CSV) with UTF-8 character encoding, quoted (“) delimiters for strings containing commas, and with each row corresponding to a single section of a course. Note that newline characters within quote delimiters must be escaped.
We have provided a CSV template with the proper headings. Please use the template provided.
Find the acceptable Campus/College name formatting for your school on our College Name reference page.
The columns that are required are:
- Course Code,
- Start Date,
- End Date,
- Course Name,
- Course Description,
- Units/Credit hours,
- Instructor Last Name,
- Instructor First Name,
- Meeting Days and Times,
- Pass/No Pass available?,
- Class Capacity,
- Available Seats,
- Waitlist Capacity,
- Current Waitlist Length,
- Meeting Locations,
- Course Notes
Please do not include additional columns. Please match the names of the columns exactly (i.e. including capitalization)
2. Is a header row required?
Yes, please keep all column headers from the template.
3. Where will these be listed?
The classes you provide will be made available to students on oei.quottly.com, the “Finish Faster Online” project.
Note that Finish Faster Online only includes online classes – if you provide other classes, these may be included on other services, but will not be visible to students on oei.quottly.com.
4. What classes / terms should be included?
Please include any and all online classes that you wish to appear on Quottly. In particular, we have had issues with late start terms (which may be listed differently in your SIS system) not being included in the .csv.
5. How can classes be removed from the site?
To remove classes that have previously been added, you need to include that class (i.e. matching CRN and course code) in a new CSV with a “cancelled” attribute for “status”.
- Course Code
The course code should be a subject prefix (all letters), one to four numbers, and then an optional trailing letter, e.g. MATH100A.
The course code should correspond to how the course code is displayed on ASSIST.org. Leading zeros are acceptable, but will be removed (i.e. MATH0010 will be turned into MATH10). Spaces and punctuation should be removed (e.g. MATH-10 will be transformed to MATH10).
Note that if your school includes extra letters in your internal IDs, these must be removed, e.g. if you specify campus “A” and “B” with “MATHA10” and “MATHB10”, these must be listed as “MATH10”. The only exception is if the courses are designated with these letters on ASSIST.org.
2. Start Date
The start date must be in ISO 8601 format, e.g. YYYY-MM-DD.
We require that there be only a single start date for a class – this can be the date of the first meeting of the class, or, if that is difficult, the first date of the term if it is a full-term class.
3. End Date
The end date must be in ISO 8601 format, e.g. YYYY-MM-DD.
We require that there be only a single end date for a class – this can be the date of the last meeting of the class, or, if that is difficult, the end date of the term if it is a full-term class.
The term should be a year plus one of “Spring”, “Winter”, “Summer”, and “Fall”. This will be matched to abstracted, cross-campus sections based only on (1) the year listed and (2) those four season words. Other words are acceptable, but will be ignored – i.e. “2018 Fall Campus A” will be mapped to “Fall 2018”.
The delivery method should be one of “Traditional”, “Hybrid”, or “Online”.
Other acceptable mappings are: “F2F” (which will be mapped to “Traditional”), “Hybrid Online Course” which will be mapped to “Hybrid”, and “Distance Ed. Internet Delayed”, which will be mapped to “Online”.
The CRN of the course. Note that this must be unique to the course. If two sections of the same course are listed as having the same CRN, they will be merged and treated as a single record.
The CRN may include letters if needed.
Mark this field as “active” or “Open” to indicate that the class is active. Mark this field as “cancelled” or “Closed” if it is no longer available.
Note, if this field is left empty it will default into “active”.
“Closed” and “cancelled” classes will not be displayed to students.
Also, these fields are case-sensitive, so be sure that you have the proper capitalization.
8. Course Name
This should be the name of the course.
Note that because it is common for your SIS system to use an abbreviated name, this course name will only be displayed to students for courses that are new to Quottly’s systems, and have not had catalog information scraped.
That is, if we already have a record for your course in our database (likely with the unabbreviated, catalog name), this field will be ignored.
9. Course Description
The description for the course. This will be displayed as the description on the “course details” page on Quottly (screenshot below).
Note that any HTML will not be rendered as HTML. If you would like to include HTML, please contact: [email protected] .
If this field is left blank, we will use the description we already have in our course catalog, if present.
10. Units / Credit Hours
The number of units or credit hours the course counts for. Note that at this time we cannot support variable-hour courses, and the first value will be displayed. Decimal hours are supported.
11. Instructor Last Name
The last name of the instructor teaching the course. Missing values are acceptable, and will be shown as “TBA” on the website.
12. Instructor First Name
The first name of the instructor teaching the course. Missing values are acceptable, and will be shown as “TBA” on the website.
13. Campus / College
The campus or college (for multi-college districts) teaching the course. IE: Sacramento City College.
You must use the college/campus name listed here or your classes will not appear in the search. Any variants will not work.
14. Meeting Days and Times
For flexible schedule / self-paced online classes leave this field BLANK.
Our ideal format is a comma-separated list of: [day abbreviations] [start time]-[end time], e.g:
(MWF 1:00-2:00, Tr 4:00 – 4:30)
For a course that meets Monday, Wednesday, and Friday 1:00pm to 2:00pm and Thursday 4:00pm to 4:30pm.
“Th”, “R”, and “Tr” are acceptable for “Thursday”. “S” will be mapped to Saturday; “T” will be mapped to Tuesday.
This field may be left blank, and should be left blank for flexible-schedule / self-paced online classes.
The preferred format is ISO 8601, which is 24 hour time.
15. Pass / No Pass
If a “pass/no pass” option is available, set to “1” or “T”. If not, “F” or “0”. Blanks will be counted as no pass/no pass option available.
16. Class Capacity
The number of seats available in the class. Required.
17. Waitlist Capacity
The number of seats available on the wait list. Optional.
18. Available Seats
The number of seats available / open at the time of the report. Required.
19. Current Waitlist Length
The number of students currently on the waitlist. Optional.
20. Meeting Locations
A comma-separated list of meeting locations. This will be displayed as provided to the user. The comma-separations should correspond to the comma-separations in the meeting times field.
21. Course Notes
Any additional notes that are desired for this section of the class. Examples of this include: In person exams and required course meetings, additional fees, mandatory orientations, etc.
This column should have heading “ZTC” and have a “1” or “True” if the section in the listing has Zero Textbook Cost or Open Educational Resources.
Sections with a “1” or “True” will have a Zero Textbook Cost tag added to their display on Quottly.
If this column is not provided, or if any other value is provided, the section will not have a ZTC tag.
Providing an Updatable URL (preferred)
Using the form below, rather than sending a file via email, you may provide a URL at which we can auto-download your updated CSVs.
If you use this option, we will make a request to the URL daily, and if there are any changes to the document (detected via a hash of the file), we will import the updates.
To enable automatic updates via csv files, create a web-accessible URL. Keep the csv file name the same and update it on your preferred schedule. Daily updates work well. Please contact us with your schedule for updates and the URL. Quottly will pick up the file based on your update schedule (daily, weekly) and will process each file within 24 hours.
This must be a download link for a CSV file, not a link to an online view of the file. The same CSV file format must be followed as outlined above. Deviations from the requested format will result in the file being sent back to the college for revision, which may significantly delay implementation.
Search Results Duration
Length of Course Processing
One week after a class has started, it no longer appears in the Finish Faster Online search results.