search

openlectures / ol2

The bleeding-edge build for the openlectures web client and back-end.
http://ol2.herokuapp.com
3 stars 1 forks source link

GDrive Database Format Modifications? #124

Closed kenlimmj closed 11 years ago

kenlimmj commented 11 years ago

Was updating the db by populating the GDrive spreadsheet and realized a couple of things:

  1. We'll have to leave summaries blank for now since there's no content created for that. Hard to say whether Acads might want something like that in the future, so I'm thinking just keep the infrastructure there but hide it from view until it's needed. Alternatively will it be better to take out and re-add when the time comes?
  2. Is it possible to put the Q&A columns inside the checkpoints column. From the database schema POV they're separate (of sorts), but when working with them from the Google Drive side it will be 1 zillion times better if we can paste the Q&A inline with the checkpoint details
  3. Might have to rearrange the order of some columns (especially in the checkpoints sheet) so it's easier to copy-paste updates over from the spreadsheets which lecturers work with. I'm presuming I'll just have to update the element reference in the .rb file?
  4. Possible to split the files by subject? So to say each subject has its own checkpoints/lessons/topics set. Reason for this is that it could get very confusing when the database grows larger. Alternatively if this is not wise then probably can do an autofilter within the spreadsheet to filter the subject_id when working on it. Pros and cons both ways. Your thoughts?
  5. For legibility of the spreadsheet, is there a way to do a look up of the id from the name. So to say when I create a topic, instead of writing subject_id "1" in the file I can write subject "Economics" then let the database do the rest? vlookup equivalent :D. Reason for this is once again so that it's easier to manage and work with.
jethrokuan commented 11 years ago
  1. I'll remove the whole infrastructure. Adds bulk to both the database and the app. 2,4,5. This part you'll need excel skillz then I suppose. In fact I didn't actually need so many separate gdrive spreadsheets, I could have used one spreadsheet with different sheets if you know what I mean, so with the excel skills should be doable.
  2. rearranging is fine we'll do it tomorrow so we don't screw shit up.