search

senior-knights / course-schedulizer

📝 Create semester schedules without stress
https://senior-knights.github.io/course-schedulizer/
MIT License
10 stars 4 forks source link

Sort the CSV export lines in a meaningful manner. #200

Open kvlinden opened 3 years ago

kvlinden commented 3 years ago

We should set a default sort order for the CSV output lines so that they are, by default, easier to understand, edit, transfer, etc.

Suggested sort fields: department, term, section name

A workaround for this would be to sort the CSV in Excel, but this could be a more complicated, multi-field sort that would be better to automate.

das43 commented 2 years ago

I added this. The exported CSV is now sorted by department, then class prefix, then class number, then class section, then term.

Right now it would sort CS112-A and CS112-B if they were offered in both the fall and spring, as: FA CS112-A SP CS112-A FA CS112-B SP CS112-B

And I think if would be better to show all the fall sections then all the spring sections. FA CS112-A FA CS112-B SP CS112-A SP CS112-B

Thoughts on the ordering?

It's an easy fix, but we'll do it after the presentation tomorrow because everything works at the moment and we don't want to risk it.

kvlinden commented 2 years ago

I prefer the second ordering: semester, courseCode, section