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
- What format and columns are required?
The class information needs to be provided in a comma-separated value file with UTF-8 character encoding, with quoted (“) delimiters for strings containing commas, where each row corresponds to a single section of a course. Note that newline characters within quote delimiters must be escaped.
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?
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 transfromed 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”.
2. Start Date
The start date must be in ISO 8601 format, e.g. YYYY-MM-DD.
3. End Date
See start date.
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.
The status should be “active” or “cancelled”. “Open” is also acceptable and will be treated the same as “active”. “Closed” is also acceptable and will be treated the same as “cancelled”. An empty field will be treated as “active”. This field is case-insensitive.
Note that “closed” classes will not be displayed to students.
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.
14. Meeting Days and Times
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. Optional.
17. Available Seats
The number of seats available / open at the time of the report. Optional.
18. Current Waitlist Length
The number of students currently on the waitlist. Optional.
19. 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.
20. Course Notes
Any additional notes that are desired for this section of the class.
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 Resoruces.
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
Using the form below, you may provide a URL at which we can find updated CSVs instead of sending a file via email.
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.
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.