IRC log of #schooltool for Wednesday, 2012-05-30

*** menesis has quit IRC00:51
*** th1a has quit IRC02:09
*** replaceafill has quit IRC02:44
*** th1a has joined #schooltool02:48
aelknerth1a, ayt?02:54
th1aHi aelkner.02:54
aelknerhey, be prepared to be happy02:54
aelkneri added a Documents sheet to the import/export02:55
aelkneralso, i added a Documents column to the Nodes sheet02:55
aelknerso the one xls file i created leads to the entire document you see loaded there02:55
aelkneri'll email it to you02:55
th1aLooks pretty good!02:56
aelkneri found out in the process that from cluster to occupation you have a simple tree02:57
aelknercourses, however, have a number of parents (occupations)02:57
th1aI'd say the nodes index only has to have title and... layer?02:57
aelknerwell, parents is helpful02:58
aelkneryou can see how the course nodes have multiple parents02:58
aelknersome of them, that is02:58
aelkneranyway, you should go through the document02:58
aelknerthe tree browsing is friendlier that way02:59
aelknerreally, the Nodes views are not the way we would want the virginia folks to browse the tree03:00
th1aThis just gets into the "don't worry about it too much because the source is fucked"03:00
aelknerah, yes, the skillsets are repeated03:00
aelknerthe workplace readiness skilllsets03:00
aelknerthey always were in the old cando03:00
th1aThere just shouldn't be three different Accountants.03:00
aelknercan you post a link03:01
th1aI mean, it is probably them, not you.03:02
aelkneryeah, look at this:03:02
aelkneryou see the diffierent account occupations there03:02
aelknernote how the different occupations there lead to the same courses in some cases03:03
aelknerthat's the way they have the verso db designed, that's on purpose03:04
aelknermore than one type of occupation requires some of the same courses03:04
th1aOK, so anyhow, let's not get too bogged down in this.03:04
aelkneranyway, our data model allows for multiple parents, so, it's not a problem03:04
th1aIt illustrates how difficult the nodes view is to deal with directly.03:05
aelknerindeed, i wouldn't recommend it for the non-power user03:05
aelkneralso, those views, though useful for a power user to make a power patch03:06
aelknerare not even finished for that purpose, there are some relationship edit views missing, etc.03:06
th1aOK, it is all rough, but ok.03:07
aelkneri wouldn't include them in a demo, and perhaps we should remove the management overview links03:07
th1aDo we have a teacher in this system?03:07
aelknerit's really the document that you want to look at03:07
aelknerwhat system?03:07
aelknerthe demo instance?03:08
th1aWell... for the demo we have to walk through importing a whole setup.03:09
th1aThat's what we have to do now.03:09
aelknerthe demo instance is from a fresh db, import the small sample xls and the new verso xls03:10
aelknerdid you get the email?03:10
th1auh... don't see it actually.03:11
aelknerit didn't arrive yet03:11
th1aApparently not.03:12
th1aDo we need to split up the worksheets into separate files?03:12
aelknerthe two xls files i just mentioned are imported by two different imports03:13
aelkner=you see the links in the School tab view?03:13
th1aDo you have the VA cte Software Setup guide handy?03:13
aelknernot handy, no03:13
th1aWell, that's kind of the whole point.03:14
th1aYou might need to resend the files or something.03:14
aelknerok, found it:03:16
aelknerthe links is on the left03:16
aelknerso, that document needs to be rewritten, of course03:17
th1aWell, the point is as little as possible.03:18
th1aWe should be able to reproduce the process using the standard SchoolTool imports.03:18
th1a(Which of course do not have exactly the same format)03:18
th1aBut we should be able to set up SchoolTool importing individual sheets, right?03:18
aelknerthe sample_data.xls (or sample_small_data.xls) has all the sheets, but one03:20
aelknercould break it up into separate files if one wanted to03:20
th1aYes... so can we split them apart.03:20
th1aOne wants to.03:20
aelknerso one will do so when one so wants03:21
aelkneranyway, what do you want to do next?03:22
th1aUm... that?03:22
th1aThat is what we're doing.03:22
aelkneri'll guess that you mean, we'll take sample_small_data.xls and split it up into sample_years.xls, sample_terms.zls, etc.03:23
th1aI'll do years/terms.03:24
th1aAnd Persons.03:24
aelkneri'll do the rest03:24
th1aOK.  (we're doing this now)03:24
th1aYou need to do copy/move sheet, btw.03:24
aelkneryou're using sample_data_small.xls from the schooltool/export source directory, right?03:25
aelkneryou can just make multiple copies and remove the sheets, too, but whatever gets it done03:26
th1aOK, I sent you mine.03:30
th1aHow are you coming?03:37
aelknersending you mine...03:38
th1aWell, you might as well be the one to do this now.03:38
th1aAt this point, we've already done 4. import competencies.03:38
th1aHow long does that take to process, btw?03:39
aelknerimporting verso_skills.xls?03:41
aelknerthat took about two-three minutes03:41
aelkneri sent the other files03:41
th1aOK, so David can do that tomorrow.03:42
th1aI think you should be the one to step through it, so if something gaks you'll see it.03:42
th1aAlso, then I should be certain that you know what I'm talking about.03:42
aelkneri should wipe my demo instance Data.fs to start the demo, right?03:43
th1aWell, if it only has the competencies, then that's fine.03:43
th1aWe can do that step out of order.03:43
aelknerhowever you prefer03:46
aelknerdid you get my email?03:46
th1aWell... if that's the only thing in the database.03:46
aelknerhow about the older email?03:46
th1aNo...   presumably you're sending them to my gmail?03:46
th1aI don't think I need it regardless.03:47
aelknercrap, i sent it to your schooltool email, it's what came up first in the gmail list03:47
th1aOK, so I guess you should go ahead and do the years/terms sheet.03:47
th1aI should get the schooltool mail but it might be hung up in lithuania.03:48
aelkneri don't follow03:48
*** highvoltage has quit IRC03:48
th1aI think it goes through a pov server.03:48
aelkneri already loaded everyting into my demo instance03:48
aelknerwhat are you saying i need to do with years/terms03:49
th1aYou did it one sheet at a time?03:49
aelknerwhy would do that, just because we support that doesn't mean i would do it03:49
th1abecause that is the purpose of tomorrows demo.03:49
aelknerif you want, i can wipte the instance and start over using the small files03:49
th1aYes, then you should do that.03:49
aelknerok, i'll do that now03:49
aelkneri sent the files to your gmail account03:53
th1aI got them.03:55
th1aOK, so you should be able to do years/terms first since there is no reason to do that manually atm.03:55
th1aOr Welsh can do it manually if he wants.03:55
th1aThen students... courses... sections... competencies...03:58
aelkneri just ran each of the eight xls files we created, then the verso_skills, everything worked03:59
aelkneryou have to run them in the right order, of course04:00
aelkneri tred doing the sections before the timetables, for instance, can't do that04:00
aelknerso i can wipe the db again, you have all the files04:01
th1aSo I guess the other thing we need to have ready is to associate some comps with a course.04:01
aelkneryou want to drive tomorrow from the fresh db, coaching david?04:01
aelknerwe can do that manually anytime04:01
th1aWell, we'll need to send him the spreadsheets.04:01
aelkneror we could create a CourseSkills sheet04:01
aelknerbut the courses in the sample data don't match the cte courses04:02
th1aProbably you should create a CourseSkills sheet that includes at least one course.04:02
th1aJust change one of the sample courses to be a CTE course.04:02
aelkneri mean, there is english, we could pretend they match04:02
th1aCHange the course name in the sheet.04:02
aelknerno, it's not that, we're talking about create a CourseSkills sheet with one line in it04:03
aelknerit can use a sample course and match it to any skillsets from the verso_skills04:03
th1aI'm just saying you can change the sample English course to a sample "Auto Body" course, right?04:04
aelkneri'd rather not, then i have to track down all the failures in the dependent sections sheets04:04
th1aAll that works by title?04:05
aelknerno id04:05
th1aSo change the title to Auto Body (or whatever) and leave the id the same.04:05
th1aThat's all I'm saying.04:05
aelknerok, yes, we could change any course title if we wnt to04:06
th1aMight as well.04:06
th1aOK, so tomorrow morning we need to also have this import process result in at least one course with associated comps, that can be graded by the teacher.04:09
th1aSo you just need to add/edit the sheets to do that.04:09
aelkneryeah, i'll send you an email with a new smaple_data_courses.xls and a course_skills.xsl04:11
th1aSo we can pick this up in 11 hours and 49 minutes?04:11
* th1a would like to go watch the basketball game.04:15
th1aAll righty.  Catch you tomorrow morning at 9:00 aelkner.04:17
aelknerso it's pam, right?04:17
aelknerok, cya then04:17
*** th1a has quit IRC05:22
*** aks has joined #schooltool06:24
*** aks has quit IRC09:49
*** aks has joined #schooltool10:50
*** aks has joined #schooltool10:50
*** menesis has joined #schooltool11:26
*** menesis has quit IRC14:13
*** aks has quit IRC14:16
*** menesis has joined #schooltool14:51
*** th1a has joined #schooltool15:13
*** replaceafill has joined #schooltool15:57
aelknerreplaceafill, can you post me a link where course skills work in the gradebook?16:02
th1ahi replaceafill, aelkner, yvl, menesis.16:03
yvlgood morning16:03
th1amenesis:  Could you see if something is up with my mail?16:03
th1aIt doesn't seem to be getting to me.16:03
replaceafillgood morning/afternoon16:03
menesisth1a: looking16:04
aelknerreplaceafill, can't use the link you posted, doesn't accept teacher00116:05
replaceafillaelkner, it should16:05
replaceafillthat's what i just tried16:05
menesis * postfix is not running16:07
aelknerneverm ind, it works16:07
menesisth1a: mail server has stopped since May 2216:07
th1aI started a hangout.16:07
th1amenesis:  That might explain my lack of mail.16:07
th1aGood thing aelkner tried to use that last night.16:07
menesisth1a: don't worry, you will get lots of error mail to root@schooltool shortly16:08
th1aOK, got the first failed hangout attempt out of the way quickly... will try again in a bit.16:09
th1aYeah, teacher001 isn't working for me.16:10
aelknerjust try the link again after you have entered the credentials16:11
aelkneri think there's a problem with the redirect after the login16:11
th1aOh yeah.  Thanks.16:12
replaceafilli think it loses the gradebook part of the url16:12
replaceafillbad traverser setup maybe16:12
th1aOK, here's how this is going to go down.16:13
th1aWe're going to do a hangout with David.16:14
aelknerreplaceafill, can you tell me why the gradebook looks like this on my instance?16:14
th1aWe want him to go through the setup steps himself on an empty server instance.16:14
aelkneri assigned a skillset to the course, but it doesn't come up in the gradebook like on your instance16:15
replaceafillaelkner, are you using trunks in your buildout.cfg?16:15
aelknerno i use my checkouts16:15
replaceafillsync your checkouts then16:15
th1aAre you looking at the right gradebook?16:15
th1aOne thing we need to use this time for is making sure we've using a fully working and up-to-date instance.16:18
aelkneri can't get my development instance on my machine to have a working gradebook wither16:19
aelkneri checked schooltool.gradebook, it has the stuff you merge into trunk16:19
* replaceafill setups one fresh instance16:19
aelkneri definitely have you cando trunk merge in my instances16:20
th1aaelkner:  Ah, I see what we did wrong last night.16:26
th1aWe should be using the "students" sheet, not the "persons" sheet.16:26
th1aAlso the new style section import is more like CanDo's right?16:27
aelknerFlatSectionsTable is the new one, yes16:27
aelknerwe don't have that in the sample_data.xls or sample_data_small.xls yet16:28
replaceafillaelkner, just created a new instance, only with trunks:
replaceafilllooks fine16:28
th1aHm... if we export the sections you imported what format do we get?16:29
aelknerthe FlatSectionsTable16:29
th1aI guess we can use that then.16:29
th1aDoes that sheet need to be called FlatSections?16:31
aelknerFlatSectionsTable, yes16:32
th1aOK, we'll have to fix that...16:32
th1aHm... can I get a sample students import sheet anywhere?16:33
aelkneri guess we should add one to the sample xls files, too16:34
th1aThe immediate question is can we have one ready for welsh in 25 minutes?16:35
aelknerfor now you could copy the Persons sheet to Teachers and Students sheets and fix the rows16:36
th1aSince I don't have one maybe you could work on that.16:36
aelkneryou have the Persons sheet already, but if you want me to do the edit and email, i'll do it16:37
th1aI don't have the students sheet, so yes please.16:37
th1aOK, so I just forwarded the outline of what we're going over with David.16:39
th1aShould not be surprising.16:40
th1aOf course, we don't have the reports yet.16:40
th1aDo we have the flipping from optional to required thing?16:40
* th1a goes to refresh his coffee.16:42
th1aDo we know where the usable gradebook will be after this importing is done?16:45
th1aWho does he log in as?16:45
aelknerbetter let replaceafill's instance be for the demo, i haven't worked out why mine doesn't work with gradebbok16:46
th1aYes, but it is teacher001's section with the assigned skills?16:46
th1aIn your sample data aelkner?16:47
replaceafillaelkner, i just have imported the small sample data xls to it16:48
replaceafillno skills/layers/nodes imports16:48
replaceafilli can blow the data.fs if you need me to16:48
th1aArt A is taught by teacher004, so I guess that's the right teacher.16:48
th1areplaceafill:  Import the skills and check teacher004's cando gradebook.16:49
replaceafillcan you send me the xls with the skills please?16:49
th1aOh, or aelkner can do it himself if you give him the URL.16:49
th1aProbably quicker.16:49
th1aLoad the skills aelkner.16:50
th1aSo I think we should do this as a hangout with david sharing his screen.16:50
th1aHe'll do the imports, we'll walk him through that.16:50
th1aAnd then show him the gradebook, let him poke around with that.16:51
aelknerok, loading skills...16:51
th1areplaceafill will have to do the IEP's.16:51
th1ahow's that student worksheet coming aelkner?16:51
aelkneri sent you the students and teachers sheets16:51
th1aok thanks.16:52
replaceafillth1a, i haven't finished the iep yet :(16:52
th1aoh, ok.16:52
th1aYou can tell him how it's coming.16:52
aelknerok, skills imported16:52
replaceafillwe're using teacher004, right?16:52
aelknerwait still importing...16:53
*** ignas has joined #schooltool16:55
th1aOK, hangout started.16:57
aelknerhow do i get to t?16:59
th1aI believe you should have an invitation.16:59
th1aDo you have google chat running?16:59
th1aAnyone get anything... ?17:00
aelkneryes, chat is running17:01
yvlbtw guys, will you be needing me in the hangout?17:01
th1aWell, I'd like you there yvl.17:02
th1ayvl:  We don't need to SEE you.17:10
* yvl was looking for a quiet corner in the office17:10
th1aWelsh is running late btw.17:10
th1aProbably about 10 minutes.17:10
yvloh, ok17:10
yvlcan I leave in roughly 1h, assuming everything runs smoothly?17:11
*** paulproteus has quit IRC20:25
*** paulproteus has joined #schooltool20:33
*** th1a has quit IRC20:35
*** th1a has joined #schooltool20:36
*** ignas has quit IRC21:08
*** menesis has quit IRC22:19
*** menesis has joined #schooltool23:00

Generated by 2.15.1 by Marius Gedminas - find it at!