IRC log of #schooltool for Monday, 2013-10-28

*** menesis has quit IRC03:00
*** yvl has joined #schooltool09:21
*** menesis has joined #schooltool12:07
*** th1a has joined #schooltool12:26
*** menesis has quit IRC13:24
*** replaceafill has joined #schooltool14:12
*** menesis has joined #schooltool14:19
*** yvl has quit IRC14:19
*** yvl has joined #schooltool14:21
*** khildin has joined #schooltool15:24
th1ahola replaceafill!15:31
replaceafillhola th1a! :)15:31
th1ahi yvl & menesis, too.15:31
replaceafillgood afternoon everyone15:32
th1aHow are you feeling replaceafill?15:34
replaceafillno more pills, able to sit confortably15:34
replaceafillnot 100% back to normal15:35
replaceafillbut on my way15:35
th1aI have one near-term request -- can you set up a regular CanDo instance on the sielibre server?15:36
th1aI have a friend working in a school in California who wants to show her principal.15:36
replaceafillah ok15:36
replaceafillcte skills?15:36
replaceafilland sample data?15:37
replaceafillor are you going to load data for your friend?15:37
th1aI am working on parsing a load of Common Core json into a spread sheet.15:38
th1aTurns out a giant lump of deeply hierarchical json isn't necessarily a joy to work with.15:38
th1aI'm figuring it out though.15:38
replaceafillkk, setting it up15:39
replaceafilli have an issue i need help solving15:39
replaceafillit's related to the custom skills list in the ACC server15:40
replaceafilli need to deprecate 2012 custom nodes/skillsets15:40
replaceafilli thought it was just a matter of exporting the skills15:40
replaceafillmarking the deprecated column for the proper nodes/skillsets/skills15:40
replaceafilland importing back15:41
replaceafillthe problem is that exporting skills breaks when there are more than 64k lines15:41
th1aHow many custom skills are there?15:41
replaceafilllike 15 courses15:42
th1aThere are 64 thousand?15:42
replaceafillthat's cte skills + custom skills15:43
th1aWhen it does all of them.15:43
replaceafillyes, export skills tries to spit them all15:44
replaceafillno way to filter15:44
th1aThis is a little off topic, but I seriously doubt they need to deprecate the custom standards.  Are they really changing many of them?15:44
replaceafilla little bit15:44
replaceafilli did notice some new skills in there15:45
th1aI'm not going to argue with Dave about it, but the right way to do it for future reference is just to update or deprecate the ones that change.15:45
th1aAnyhow, so can you just split it into separate files?15:46
replaceafillyou mean using multiple sheets when there are more than 64k?15:47
th1aWhat else would we do?15:47
replaceafilli was thinking of using a custom script just for this case15:47
replaceafillto get the custom nodes/skillsets/skills only15:48
th1aOr that.15:48
replaceafillbut i also considered your approach15:48
th1aWell, we're probably going to run into this with other CanDo sites.15:49
replaceafillcan i write the custom script just to get dwelsh data going?15:49
replaceafilland then adding the feature to the importer/exporter?15:49
replaceafill(to split sheets)15:50
th1aI mean, maybe just file a bug.  It isn't really a high priority for the real fix.15:50
replaceafillanother quick question15:50
replaceafillah ok15:51
replaceafillhas anyone tried the email server with gmail lately?15:51
replaceafilli tried answering:
th1aI've not.15:51
th1aSo does that not work anymore?15:51
replaceafillah ok, i just did and got a timeout15:51
replaceafilluser says same configuration doesn't work in the new version15:52
replaceafillbut i got a different error:15:52
replaceafillSMTPServerDisconnected: please run connect() first15:52
replaceafillafter 5 minutes or so15:52
replaceafilli wonder if something has changed in python's smtp library15:53
th1aOr gmail, maybe more likely.15:54
replaceafillah, maybe15:54
replaceafillok, that's it from me15:54
replaceafillsome pending stuff in my queue15:54
replaceafillset up the social skills instance15:55
replaceafillfor steven15:55
replaceafilland see if evolution works15:55
th1aYeah, need to pick up that thread.15:55
replaceafillwill do15:55
replaceafilllast comment of mine15:55
replaceafillsince i missed my french exams15:55
replaceafill(last week)15:55
replaceafilli've decided to postpone my classes until next year15:56
replaceafillso i'll be around all morning now15:56
replaceafilljust fyi :)15:56
replaceafilland i guess you're 1 hour earlier now ;)15:56
replaceafilli mean15:56
replaceafilllater :P15:56
th1aThat helps a bit too.15:56
* replaceafill done15:57
th1aGreat to have you back, replaceafill.15:57
th1aOh, I need your invoice!15:58
replaceafillah ok, i'll send it later today15:58
th1aThanks replaceafill.16:00
menesisI have little to report, had a Friday off again16:01
menesisadded "SchoolTool versions" vielwet to the Server page16:01
menesisincluding other plugins that don't use autoinclude (cas)16:01
yvlgood morning16:02
menesisalso was browsing through testing code16:02
yvl(and welcome back replaceafill  :) )16:02
replaceafillhi yvl :)16:02
menesisin attempt to avoid of testbrowser dependency on runtime16:03
menesisselenium is not needed, but zope.testbrowser and are.16:03
menesisalso I have quite a few unfinished fixes/cleanup/refactoring in old branches16:04
menesiswas looking at them and if they are still relevant16:05
menesise.g. remove the use of calwidget.js16:05
menesisand use only the Ubuntu font in reports16:07
menesisthere are a few places left  that use Times_New_Roman (Liberation)16:07
menesisbut all this cleanup is unfinished, will do this in a separate branch16:08
* menesis done16:09
th1aOK  Sounds good.16:09
th1aThanks menesis.16:09
th1acan you help with this?
th1ameanwhile... go ahead yvl.16:13
yvlturns out reverting and taking the simpler path was a good idea16:14
yvladded "completed" state to section memberships16:14
menesisth1a: yes, I saw that question16:15
yvlnow working on evolution or rather avoiding of big evolution16:16
yvlI think it should be coupled with performance optimizations of relationships16:16
th1aThat's fine.16:16
yvlsince both temporal relationships and cataloged relationships touch same places16:16
yvlI think I'll have that done until next Mon16:17
yvlthough I'd like to take half Thu off, and that does not leave that much time16:17
th1aOK.  Well, something to shoot for.16:18
yvlafter that it will probably take a lot of time to speed up evolution16:18
yvlbig slow tests are big and slow16:18
yvlall in all it's a steady pace forward16:19
th1aAll right, thanks guys.16:21
th1aHave a good one.  See you Wednesday.16:22
* th1a drops the bag of gravel.16:23
replaceafillthanks everybody16:23
th1areplaceafill:  I don't know if this would be helpful, but I just noticed it:16:52
th1aIf you're working with particularly large Excel files then there are two features of xlrd that16:52
th1ayou should be aware of:16:52
th1a• The on_demand parameter can be passed as True to open_workbook resulting in16:52
th1aworksheets only being loaded into memory when they are requested.16:52
th1a• xlrd.Book objects have an unload_sheet method that will unload worksheet,16:52
th1aspecified by either sheet index or sheet name, from memory.16:52
replaceafillbut the 64k rows limitation is on the xls format, right?16:53
replaceafillnot the library16:53
th1aYeah, it is a different issue.16:54
th1aThanks replaceafill.16:59
replaceafillfor the california demo16:59
replaceafillempty db16:59
*** menesis has quit IRC19:50
*** menesis has joined #schooltool20:53
*** th1a has quit IRC22:57
*** th1a has joined #schooltool22:57
*** menesis has quit IRC23:56

Generated by 2.15.1 by Marius Gedminas - find it at!