Course Finder CSV Instructions

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

  1. 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.

A CSV template file is available here.

The columns that are required are:

  • Course Code,
  • Start Date,
  • End Date,
  • Term,
  • Delivery,
  • CRN,
  • Status,
  • Course Name,
  • Course Description,
  • Units/Credit hours,
  • Instructor Last Name,
  • Instructor First Name,
  • Campus/College,
  • Meeting Days and Times,
  • Pass/No Pass available?,
  • Class Capacity,
  • Available Seats,
  • Waitlist Capacity,
  • Current Waitlist Length,
  • Meeting Locations,
  • Course Notes
  • ZTC

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.

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”.

Per-Column Formatting

  1. 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.
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.

4. Term

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”.

5. Delivery

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”.

6. CRN

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.

7. Status

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).

Grossmont College
MATH 120 - Quantitative Reasoning
(A screenshot of math course information as taken from the Finish Faster website.)

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. 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. Optional.

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.

22. ZTC

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.