IRC log of #schooltool for Wednesday, 2012-10-17

*** menesis has quit IRC00:54
*** th1a has quit IRC01:19
*** replaceafill has quit IRC02:23
*** paulproteus has quit IRC06:54
*** paulproteus has joined #schooltool07:01
*** menesis has joined #schooltool08:23
*** khildin has joined #schooltool09:53
*** magespawn has joined #schooltool10:40
*** jelkner has joined #schooltool15:05
*** jelkner has joined #schooltool15:05
*** yvl has joined #schooltool16:17
*** th1a has joined #schooltool16:21
*** th1a has quit IRC16:22
*** replaceafill has joined #schooltool16:24
*** th1a has joined #schooltool16:26
th1ahi menesis, yvl, aelkner, replaceafill.16:30
replaceafillgood morning/afternoon16:31
yvlgood morning16:31
th1aWhile we're waiting for menesis...16:33
th1aWould you like to start aelkner?16:33
aelknerso i got the new version of getscript to work like we discussed16:34
aelknerit uses the skillset titles to match the verso db with the current xls file16:34
aelkneri'll be changing that to use the external id as soon as Lee ads that to the api16:34
aelknerand it uses the external id of the skills to match verso to the skills in the xls file16:35
th1aIsn't the id in now?  Did you get those emails?16:36
aelkneri saw the emails, yes, but he hasn't sent the final email that says it's in place16:36
aelknerhe's 9/10 the way there16:36
th1aI have "Duty areas (what you call skills sets) now have an ID. I was able to write a script to republish just that portion of each framework that changed, speeding up the process considerably."16:37
aelkneri just looked at the api to verify that the id is not there yet16:37
aelknerhis last email says 'I was able to write a script...'16:38
aelknerbut it does't say that he ran it :)16:39
th1aI guess I may not be getting all the emails.16:39
th1aAnyhow, so you'll make one change to your script when he's ready and then send it to them?16:39
aelknerno, what you said is true, that's what he said in his last email16:39
aelknerit's been 23 hours since he last said he wrote the script16:40
aelknershould i wait before asking him when he's going to run it?16:41
th1aYou could tell him you're ready when he is.16:41
aelknerok, will do16:42
aelknerso my next thing to do is to work on the Search that includes the skillsets and skills16:42
th1aWell, actually today you and I have to clean up the import forms and templates to get that into the release.16:43
aelknerah, ok, so after the meeting?16:43
th1aOK, so we'll do that...16:44
th1aThanks aelkner.16:44
replaceafilli worked on the change to the skills gradebook to show multiple term data16:45
replaceafillyou can see it at:16:46
replaceafillthat section spans from MP1 term to MP216:46
replaceafillonly MP1 is graded16:46
replaceafillif you go to MP2 however you'll see the past grades16:46
replaceafillyesterday i made all the existing reports to work the same16:47
replaceafillif you access the Section Summary report or the VA Section Report you'll get the same behaviour16:47
replaceafillalso, if you log in as manager and go to a term, you'll see the Skills Completion Report16:47
replaceafillwhich also works the same :)16:48
replaceafilli'm now in the middle of the two last completion reports16:48
replaceafillthe ones that use tables instead of charts16:48
replaceafillth1a, question16:48
replaceafilli assume we'll do those by term too?16:49
replaceafilland i don't know what titles to use for them16:49
replaceafilli'm referring to the ones dwelsh describes in the google doc btw16:50
th1aI try to pretend they don't exist.16:50
replaceafilli know :D16:50
th1aAsk Welsh.16:50
replaceafillah ok16:50
replaceafillth1a, i'll finish these today, what should i do next?16:51
replaceafilli think my queue gets empty after this...16:51
th1aThat's the last non-report CanDo task, I think.16:51
replaceafillok, i'll send Welsh an email to ask16:51
* replaceafill done16:51
th1aThanks replaceafill.16:54
* yvl managed to get sick16:54
th1aIt's going around...16:54
yvleven cross-Atlantic ;)16:54
yvlbut I did commit the linked section scheduling16:54
yvland missing event handlers for cando16:54
yvlbut that's it16:55
yvlI should be back on Fri16:55
yvlMon, latest16:55
* yvl done.16:56
th1aOK.  It looks like we're not going to be starting reports until next week anyhow (which is fine... this week wasn't really realistic).16:57
yvlglad to hear16:57
th1aI don't suppose you've seen menesis?16:58
* menesis is here16:58
th1aAh, lurking.16:58
menesislike yvl, I have also got a cold16:58
menesisnot too bad16:59
th1aSo as of this moment we haven't pushed any new packages, right?16:59
menesisbut no bugfixes as a result16:59
th1aI'd like to tidy up these import forms before that happens.16:59
menesisI only did some release and bug management16:59
th1a(just the text, nothing functional)16:59
menesisyesterday I've created schooltool.cando and schooltool.virginia projects17:00
menesisset up translations, bugs, everything17:00
th1aYes, I saw that.17:00
* replaceafill thanks menesis for that :)17:00
menesismoved some bugs to those projects17:00
menesisMany left in cando, but there are always some bugs that belong to various other projects17:01
menesisbecause cando is the first in
menesisupdated CHANGES.txt for all projects up to yesterday17:02
menesislooked at a few bugs17:03
menesisbut didn't fix anything I fear17:03
menesisso as I understand replaceafill and aelkner are finishing up their last changes to cando?17:03
menesisand I will be able to release them tomorrow?17:04
aelkneri haven't commited the script to schooltool.virginia17:04
aelknerbut we can deliver that script in email, so i don't think that matters17:05
menesisif it works then commit..17:05
th1aWas it there before?17:05
aelknerit still needs to change when lee changes the apu17:06
aelknerit's been in the package, but they didn't copy it from there17:06
menesisthere is a script in package17:06
aelknerthey wouldn't even know how to get the script out of the package anyway17:06
aelknerthere has to be version control for the script, so yes, it's in schooltool.virginia17:07
menesisso update it to the last version that works?17:07
th1aIt doesn't make much difference either way.17:08
aelknermenesis, you don't need to worry about the script in the package17:08
aelknerwe'll be emailing it to them17:08
menesisdoes anyone plan to do anything on core, gradebook, or journal?17:11
menesiscan I start releasing them tonight?17:11
replaceafillmenesis, i'm only working on schooltool.virginia atm17:12
th1aaelkner and I will be touching core.17:12
aelknernone from me17:12
menesisth1a: but you plan to finish that today?17:13
th1aIt is just changing some text on the pages and maybe adding some inline notes to the spreadsheets.17:14
menesisI see17:15
menesisokay, so tomorrow17:15
menesisyvl: where have you committed „schedule for all terms“?17:17
menesisBug 104726617:17
* menesis done17:18
th1aThanks menesis.17:19
th1aOK gentlemen.  Let's put this one to bed.17:20
th1aI'd say the CanDo re-write has been a success.17:20
th1aThere are still a few loose ends to tie up, but for a complete re-write, things seem to be going smoothly.17:21
yvlmenesis, forgot to push17:21
yvldid that now17:21
th1aThanks guys!17:22
th1aHave a good week/weekend.17:22
* th1a drops the bag of gravel.17:22
replaceafillthanks everybody17:22
menesisyvl ;) thanks17:23
yvlthanks guys17:23
aelknerthanks guys, have a great weekend17:23
aelknerfell better17:23
th1aaelkner:  Shall we jump into this?17:24
aelknersure, you start17:24
th1aWell, maybe we should try a screen sharing hangout so I can just look at your screen.17:24
aelknerok, i'll invite you to one17:25
*** yvl has quit IRC18:01
replaceafillth1a, zyt?18:44
replaceafillcould you write the two missing report descriptions?18:44
replaceafillXXX Report description XXX18:45
th1aWhat's in skills completion?18:45
replaceafillsame as section summary18:45
replaceafillbut by section18:45
replaceafillinstead of by student18:45
th1aDid I write the section summary one?18:45
replaceafilli think so18:45
th1aI suck.18:46
replaceafilli haven't written them :P18:46
th1aI must have had a head injury or something.18:46
th1aActually, I guess I'm having trouble doing better now that I try...18:47
th1ajelkner calling...18:47
replaceafillthere's a bug about this i think18:47
replaceafillmaybe we could squeeze it into the release18:48
th1aok, back18:58
th1aAll right, let me just scan through all these.18:59
th1aMake "Export as XLS" "School Export"19:00
th1aMake "Skill Data" "Skills"19:01
replaceafillremember one thing19:01
replaceafillthe first column it's the same link the user sees19:01
th1a"Skills Export"19:01
replaceafillif you change "Export as XLS" to "School Export" in the reference page, it will change under Reports in School19:02
th1aI know.19:02
th1aMake "Report Sheets" "Report Sheet Data Export"19:03
th1aWe'll just use "Export" in the place of "XLS" ;-)19:03
th1aadd "gradebook" to Printable Worksheet summary.  "The current gradebook worksheet..."19:06
th1a"An overview of each student's achievement of skills within the section."19:07
* replaceafill is jumping from package to package :D19:07
replaceafillthat's for section summary, right?19:08
th1afor Skills Completion: "An overview of each section's aggregate achievement of skills."19:09
th1aI think that's it.19:11
replaceafillva section report?19:12
th1aaelkner: ayt?20:14
aelknerth1a, yes20:20
replaceafillth1a, we can mark this as fix committed, right?
th1areplaceafill, yes20:24
th1aaelkner:  I just want to double check the meaning of some things on the persons sheet.20:24
th1aColumn D is Email and E is phone.  Do these create self contacts and put that info there?20:24
aelknerok, let me look20:26
aelkneryeah, looks like you caught an inconsistency between the labels there20:29
aelknerthe sample data xls file has the correct ones20:29
aelkneri'll have to update it and email you20:29
aelknerone sec20:29
aelkneremail sent20:33
th1aOK, that makes a lot more sense.20:34
aelkneryeah, i'm going to double-check the whole set of sheets right now to save you the trouble20:34
th1aaelkner:  Which things can have rich text descriptions?  Just skills?20:43
aelkneri don't know off hand, i'd need to check20:43
aelknerjust found another thing missing from empty data20:44
aelknerwill have send you another copy after i've double-checked everything20:44
aelknerok, sent you a fixed empty_data.xls20:49
aelknernow about the rich text question, i can check the forms20:49
aelknerth1a, skillsets, skills and nodes have rich text fields on the edit forms20:51
aelknerlabels have no description20:51
th1aOK, in skills, equivalent is a comma separated list?20:52
th1aRequired is?  Bool?20:52
th1aLayers:  Parents is a comma separated list?20:53
aelknerok, skill equivalence is hidden in the ui20:53
aelknerwe haven't even really discussed how we would use that yet anyway20:53
aelknerrequired is bool20:54
th1aDocuments: Hierarchy is a comma separated list but the last two are always skillset and skill (perhaps with different names)?20:54
aelknerretired is hidden20:54
th1aRIght.  So they are bool types in Excel?20:54
th1aIs equivalence parsed as a comma separated list?20:55
aelknerdocument heirarchy is no longer displayed in document view20:55
aelkneronly hierarchy edit relationship view20:55
th1aWell, that's fine, I'm just wondering what goes there.20:55
aelknerah, in the sheet, sorry, i was thinking ui20:55
aelkneryes, comma-seaparated list of ids20:55
aelknerbtw, i should alert you, the logic for importing equivalent skills is faulty20:57
aelkneri didn't know what it would mean, so i just validate the id against the current skillset20:57
aelknerthat really can't be right though, so good that you bring it up20:57
aelknerunfortunately, skill ids are with skillsets which are the skill containers20:58
aelknerwe would need to come up with something that made sense there, but that could be tricky20:58
aelknerwhat would be needed wold be somthing like:20:58
th1aThat's something you and replaceafill have to work out.20:59
th1aCan you file a bug for that?20:59
aelkner(skillset1: skill2), (skillset3, skill1), etc.20:59
replaceafillth1a, schooltool.virginia has two views i'm about to get rid of21:12
replaceafill1. our first attempt of the section summary (chart) report21:12
replaceafilli think we don't need it anymore ;)21:12
replaceafill2. a "by skill" version of the section summary report21:13
replaceafillneither of them are accessible through the UI21:13
replaceafilland both are broken atm21:13
replaceafillimho, getting rid of them makes the code less confusing21:14
replaceafillwe can bring them back when needed21:14
th1aaelkner, everything after password is demographics in the Person form?21:14
th1aaelkner:  At this point does birth date need to be formatted as a date?21:19
th1aJeez... too many questions here.21:21
th1aWhat goes in gender?21:21
aelknerdates are validating using:21:26
aelknerdt = xlrd.xldate_as_tuple(value, self.wb.datemode)21:26
aelknerthat means they have to be valid excel dates21:26
aelknervalidation for gender:21:27
aelknerif data['gender'] not in ['male', 'female']: --> error21:27
aelkneri agree that may not be ideal, but it is the same as what the export outputs21:27
th1aIt is ok as long as I know what to write down.21:28
aelkneryeah, that helps :)21:28
th1aWhat are the valid values for relationship types?21:34
th1aDoes Courses Credits expect an integer?21:39
th1ais Resources in sections a list or one value?21:45
th1aSectionEnrollment is stanzas, correct?21:46
th1aSectionTimetables, too, right?21:47
aelknercourse credits is float21:49
aelknerresources is a list of ids21:50
aelkneryes, enrollment and timetables is repeating pattern or stanzas21:50
aelknerthe section list, the students list in the one case21:50
aelknerthe section list, the timetable selection and the schedule in the timetable case21:51
th1aaelkner:  I'm not sure why skillsets would have an external id.21:51
aelknerwell, we had t there with no reason that we knew of for it, but now we do21:52
aelknerwe need it so that they can update skilllset titles21:52
aelknerright now uses the titles to match the skillsets, but that's never good21:52
aelknerlee understands that supplying the ids helps us do better match21:52
th1aOK, so the problem is we can't actually use these id's, because we already assigned them some other id's?21:53
th1aSo we might as well stuff them in external id's.21:53
aelknerwe have our ids, they have theirs21:53
th1aIf we were starting fresh, we'd just use theirs.21:53
aelknerand yes, the name of the attribute, extern id is actually perfectly named21:53
aelknerwell, we discussed this at the outset, but you balked for good reason21:54
* replaceafill goes to get lunch, bb in ~1h21:54
aelknerwhat if the user is a simple school and doesn't want to have to come up with and id21:54
th1aOK, so in that case, nobody cares what the external id's are because you'll only see them if you're looking at the skillset, and external id's don't need to be meaningful.21:54
aelkneronly to the virginia folks21:54
th1aBut they don't need to be meaningful to humans.21:55
th1aIn VA.21:55
th1aThey were so unconcerned with skillset ID's that they didn't even publish them in the API.21:55
th1aSo it doesn't matter.21:55
th1aJust put what lee is giving you in external id.21:55
th1aOr I guess you're saying you'll need to add some prefixes to make them unique?21:56
aelknerit won't appear on reports perhaps, not exactly certain about that21:56
aelknerbut it will be meaningful to glenda and david21:56
th1aThey don't need to be.21:56
aelknerwell, maybe not exactly, but they understand the need for it21:56
aelknerremember old cando used those global ids everywhere21:57
th1aWE are the ones that need it!21:57
aelknerand david liked it21:57
th1aTHEY didn't ask for skillset id's.21:57
aelknerno, not those, but those are needed for matching21:57
aelkneri could just put the id without the prefix in that field21:57
aelknerand if you'd like, i could send another note telling glenda and david not to other trying to answer21:58
th1aOK.  Thanks.21:58
aelknernot to bother i mean21:58
aelknerok, will do21:58
th1aNo need to muddy the waters.21:58
th1aI have to go pick up Vivian and then I should be able to wrap this up.21:58
aelknerok, i'll be around21:59
*** magespawn has quit IRC22:07
*** magespawn has joined #schooltool22:12
*** jelkner has quit IRC22:14
th1a aelkner can you check the valid values for the relationship field in Contact Relationships.23:04
aelkner        vocabulary=vocabulary([23:06
aelkner            ('parent', _("Parent")),23:06
aelkner            ('step_parent', _("Step-parent")),23:06
aelkner            ('foster_parent', _("Foster parent")),23:06
aelkner            ('guardian', _("Guardian")),23:06
aelkner            ('sibling', _("Sibling")),23:06
aelkner            ]),23:06
aelknerit's the keys on the left that are the valid values23:07
th1aaelkner:  Can a document be a layer parent?23:30
aelknerno, only a node parent23:33
aelknerremember, documents subclass nodes, so they are really special nodes23:33
aelknerobjects have relationships to other objects, like nodes having layers or skillsets23:33
aelknerbut parent/child is only between objects of the same type23:34
aelknerand since documents are in fact also nodes, that is why they are parents of nodes23:34
th1aUnder nodes, Documents is just if the are the immediate children of the document node?23:37
aelknerno, it's the other way around23:41
aelkneroh sorry, yes23:42
aelkneri'll restate:23:42
aelknerif a node is an immediate child of a document, then the document cell will have the id of that document23:42
aelkneris that clear?23:42
th1aThat's what I thought.23:44
th1aOK I sent you the sheets.23:45
th1aTake a look at them.23:45
aelknerok, i guess your questions were for the book because I don't see any of my answers in the sheets23:49
*** khildin has quit IRC23:52
th1aDo you know how to see the comments?23:55
th1aHover over the header cells with the red dots?23:55
aelkneri'm not seeing any red dots23:56
th1aIn the yellow headers?23:56
th1aHover over them?23:56
aelkneryeah, i hover over them, nothing happens23:58
aelknercould it be the version of openoffice i'm using?23:58
th1aI suppose...23:58
th1areplaceafill: ayt?23:59
replaceafillth1a, yes23:59
th1aI sent you these sheets with comments.23:59
th1aSee if you wee them.23:59

Generated by 2.15.1 by Marius Gedminas - find it at!