| *** menesis has quit IRC | 00:51 | |
| *** th1a has quit IRC | 02:09 | |
| *** replaceafill has quit IRC | 02:44 | |
| *** th1a has joined #schooltool | 02:48 | |
| aelkner | th1a, ayt? | 02:54 |
|---|---|---|
| th1a | Hi aelkner. | 02:54 |
| aelkner | hey, be prepared to be happy | 02:54 |
| aelkner | http://69.164.203.135:36660/manage | 02:54 |
| aelkner | i added a Documents sheet to the import/export | 02:55 |
| aelkner | also, i added a Documents column to the Nodes sheet | 02:55 |
| aelkner | so the one xls file i created leads to the entire document you see loaded there | 02:55 |
| aelkner | i'll email it to you | 02:55 |
| th1a | Looks pretty good! | 02:56 |
| aelkner | i found out in the process that from cluster to occupation you have a simple tree | 02:57 |
| aelkner | courses, however, have a number of parents (occupations) | 02:57 |
| th1a | I'd say the nodes index only has to have title and... layer? | 02:57 |
| th1a | Or... | 02:58 |
| aelkner | well, parents is helpful | 02:58 |
| th1a | Hm... | 02:58 |
| aelkner | you can see how the course nodes have multiple parents | 02:58 |
| aelkner | some of them, that is | 02:58 |
| th1a | Well... | 02:58 |
| aelkner | anyway, you should go through the document | 02:58 |
| aelkner | the tree browsing is friendlier that way | 02:59 |
| th1a | Hrm... | 02:59 |
| aelkner | really, the Nodes views are not the way we would want the virginia folks to browse the tree | 03:00 |
| th1a | This just gets into the "don't worry about it too much because the source is fucked" | 03:00 |
| th1a | realm. | 03:00 |
| aelkner | ah, yes, the skillsets are repeated | 03:00 |
| aelkner | the workplace readiness skilllsets | 03:00 |
| aelkner | they always were in the old cando | 03:00 |
| th1a | There just shouldn't be three different Accountants. | 03:00 |
| aelkner | can you post a link | 03:01 |
| th1a | http://69.164.203.135:36660/nodes/occupation-2518 | 03:01 |
| th1a | http://69.164.203.135:36660/nodes/occupation-2507 | 03:01 |
| th1a | http://69.164.203.135:36660/nodes/occupation-2497 | 03:02 |
| th1a | I mean, it is probably them, not you. | 03:02 |
| aelkner | yeah, look at this: | 03:02 |
| aelkner | http://69.164.203.135:36660/nodes/pathway-255/document.html?layer=pathway&document=cte | 03:02 |
| aelkner | you see the diffierent account occupations there | 03:02 |
| aelkner | note how the different occupations there lead to the same courses in some cases | 03:03 |
| aelkner | that's the way they have the verso db designed, that's on purpose | 03:04 |
| th1a | Yes. | 03:04 |
| aelkner | more than one type of occupation requires some of the same courses | 03:04 |
| th1a | OK, so anyhow, let's not get too bogged down in this. | 03:04 |
| aelkner | anyway, our data model allows for multiple parents, so, it's not a problem | 03:04 |
| th1a | It illustrates how difficult the nodes view is to deal with directly. | 03:05 |
| aelkner | indeed, i wouldn't recommend it for the non-power user | 03:05 |
| aelkner | also, those views, though useful for a power user to make a power patch | 03:06 |
| aelkner | are not even finished for that purpose, there are some relationship edit views missing, etc. | 03:06 |
| th1a | OK, it is all rough, but ok. | 03:07 |
| aelkner | i wouldn't include them in a demo, and perhaps we should remove the management overview links | 03:07 |
| th1a | Do we have a teacher in this system? | 03:07 |
| aelkner | it's really the document that you want to look at | 03:07 |
| aelkner | what system? | 03:07 |
| aelkner | the demo instance? | 03:08 |
| th1a | Well... for the demo we have to walk through importing a whole setup. | 03:09 |
| th1a | That's what we have to do now. | 03:09 |
| aelkner | the demo instance is from a fresh db, import the small sample xls and the new verso xls | 03:10 |
| aelkner | did you get the email? | 03:10 |
| th1a | uh... don't see it actually. | 03:11 |
| aelkner | it didn't arrive yet | 03:11 |
| th1a | Apparently not. | 03:12 |
| th1a | Do we need to split up the worksheets into separate files? | 03:12 |
| aelkner | the two xls files i just mentioned are imported by two different imports | 03:13 |
| aelkner | =you see the links in the School tab view? | 03:13 |
| th1a | Do you have the VA cte Software Setup guide handy? | 03:13 |
| aelkner | not handy, no | 03:13 |
| th1a | Well, that's kind of the whole point. | 03:14 |
| th1a | You might need to resend the files or something. | 03:14 |
| aelkner | ok, found it: | 03:16 |
| aelkner | http://cando.cteresource.org/implementation.html | 03:16 |
| aelkner | the links is on the left | 03:16 |
| th1a | Yes. | 03:16 |
| aelkner | so, that document needs to be rewritten, of course | 03:17 |
| th1a | Well, the point is as little as possible. | 03:18 |
| th1a | We 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 |
| th1a | But we should be able to set up SchoolTool importing individual sheets, right? | 03:18 |
| aelkner | the sample_data.xls (or sample_small_data.xls) has all the sheets, but one | 03:20 |
| aelkner | could break it up into separate files if one wanted to | 03:20 |
| th1a | Yes... so can we split them apart. | 03:20 |
| th1a | One wants to. | 03:20 |
| aelkner | so one will do so when one so wants | 03:21 |
| aelkner | anyway, what do you want to do next? | 03:22 |
| th1a | Um... that? | 03:22 |
| th1a | That is what we're doing. | 03:22 |
| aelkner | i'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 |
| th1a | Yes. | 03:24 |
| th1a | I'll do years/terms. | 03:24 |
| aelkner | ok | 03:24 |
| th1a | And Persons. | 03:24 |
| aelkner | i'll do the rest | 03:24 |
| th1a | OK. (we're doing this now) | 03:24 |
| th1a | You need to do copy/move sheet, btw. | 03:24 |
| aelkner | you're using sample_data_small.xls from the schooltool/export source directory, right? | 03:25 |
| th1a | y | 03:25 |
| aelkner | you can just make multiple copies and remove the sheets, too, but whatever gets it done | 03:26 |
| th1a | OK, I sent you mine. | 03:30 |
| th1a | How are you coming? | 03:37 |
| aelkner | sending you mine... | 03:38 |
| th1a | Well, you might as well be the one to do this now. | 03:38 |
| th1a | At this point, we've already done 4. import competencies. | 03:38 |
| th1a | Right? | 03:39 |
| th1a | How long does that take to process, btw? | 03:39 |
| aelkner | importing verso_skills.xls? | 03:41 |
| th1a | Yes. | 03:41 |
| aelkner | that took about two-three minutes | 03:41 |
| aelkner | i sent the other files | 03:41 |
| th1a | OK, so David can do that tomorrow. | 03:42 |
| th1a | I think you should be the one to step through it, so if something gaks you'll see it. | 03:42 |
| th1a | Also, then I should be certain that you know what I'm talking about. | 03:42 |
| aelkner | i should wipe my demo instance Data.fs to start the demo, right? | 03:43 |
| th1a | Well, if it only has the competencies, then that's fine. | 03:43 |
| th1a | We can do that step out of order. | 03:43 |
| aelkner | however you prefer | 03:46 |
| aelkner | did you get my email? | 03:46 |
| th1a | Well... if that's the only thing in the database. | 03:46 |
| aelkner | how about the older email? | 03:46 |
| th1a | No... presumably you're sending them to my gmail? | 03:46 |
| th1a | I don't think I need it regardless. | 03:47 |
| aelkner | crap, i sent it to your schooltool email, it's what came up first in the gmail list | 03:47 |
| th1a | OK, so I guess you should go ahead and do the years/terms sheet. | 03:47 |
| th1a | I should get the schooltool mail but it might be hung up in lithuania. | 03:48 |
| aelkner | i don't follow | 03:48 |
| *** highvoltage has quit IRC | 03:48 | |
| th1a | I think it goes through a pov server. | 03:48 |
| aelkner | i already loaded everyting into my demo instance | 03:48 |
| aelkner | what are you saying i need to do with years/terms | 03:49 |
| th1a | You did it one sheet at a time? | 03:49 |
| aelkner | why would do that, just because we support that doesn't mean i would do it | 03:49 |
| th1a | because that is the purpose of tomorrows demo. | 03:49 |
| aelkner | if you want, i can wipte the instance and start over using the small files | 03:49 |
| th1a | Yes, then you should do that. | 03:49 |
| aelkner | ok, i'll do that now | 03:49 |
| aelkner | i sent the files to your gmail account | 03:53 |
| th1a | I got them. | 03:55 |
| th1a | OK, so you should be able to do years/terms first since there is no reason to do that manually atm. | 03:55 |
| th1a | Or Welsh can do it manually if he wants. | 03:55 |
| th1a | Then students... courses... sections... competencies... | 03:58 |
| aelkner | i just ran each of the eight xls files we created, then the verso_skills, everything worked | 03:59 |
| aelkner | you have to run them in the right order, of course | 04:00 |
| aelkner | i tred doing the sections before the timetables, for instance, can't do that | 04:00 |
| th1a | OK. | 04:00 |
| aelkner | so i can wipe the db again, you have all the files | 04:01 |
| th1a | So I guess the other thing we need to have ready is to associate some comps with a course. | 04:01 |
| aelkner | you want to drive tomorrow from the fresh db, coaching david? | 04:01 |
| aelkner | we can do that manually anytime | 04:01 |
| th1a | Well, we'll need to send him the spreadsheets. | 04:01 |
| aelkner | or we could create a CourseSkills sheet | 04:01 |
| aelkner | but the courses in the sample data don't match the cte courses | 04:02 |
| th1a | Probably you should create a CourseSkills sheet that includes at least one course. | 04:02 |
| th1a | Just change one of the sample courses to be a CTE course. | 04:02 |
| aelkner | i mean, there is english, we could pretend they match | 04:02 |
| th1a | CHange the course name in the sheet. | 04:02 |
| th1a | Right? | 04:02 |
| aelkner | no, it's not that, we're talking about create a CourseSkills sheet with one line in it | 04:03 |
| aelkner | it can use a sample course and match it to any skillsets from the verso_skills | 04:03 |
| th1a | Yes. | 04:03 |
| th1a | I'm just saying you can change the sample English course to a sample "Auto Body" course, right? | 04:04 |
| aelkner | i'd rather not, then i have to track down all the failures in the dependent sections sheets | 04:04 |
| th1a | All that works by title? | 04:05 |
| aelkner | no id | 04:05 |
| th1a | So change the title to Auto Body (or whatever) and leave the id the same. | 04:05 |
| th1a | That's all I'm saying. | 04:05 |
| aelkner | ok, yes, we could change any course title if we wnt to | 04:06 |
| th1a | Might as well. | 04:06 |
| th1a | OK, 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 |
| th1a | So you just need to add/edit the sheets to do that. | 04:09 |
| aelkner | yeah, i'll send you an email with a new smaple_data_courses.xls and a course_skills.xsl | 04:11 |
| th1a | OK. | 04:11 |
| th1a | So we can pick this up in 11 hours and 49 minutes? | 04:11 |
| * th1a would like to go watch the basketball game. | 04:15 | |
| th1a | All righty. Catch you tomorrow morning at 9:00 aelkner. | 04:17 |
| aelkner | so it's pam, right? | 04:17 |
| aelkner | 9am | 04:17 |
| th1a | Yes. | 04:17 |
| aelkner | ok, cya then | 04:17 |
| th1a | Thanks. | 04:17 |
| *** th1a has quit IRC | 05:22 | |
| *** aks has joined #schooltool | 06:24 | |
| *** aks has quit IRC | 09:49 | |
| *** aks has joined #schooltool | 10:50 | |
| *** aks has joined #schooltool | 10:50 | |
| *** menesis has joined #schooltool | 11:26 | |
| *** menesis has quit IRC | 14:13 | |
| *** aks has quit IRC | 14:16 | |
| *** menesis has joined #schooltool | 14:51 | |
| *** th1a has joined #schooltool | 15:13 | |
| *** replaceafill has joined #schooltool | 15:57 | |
| aelkner | replaceafill, can you post me a link where course skills work in the gradebook? | 16:02 |
| replaceafill | http://69.164.203.135:6662/schoolyears/2011-2012/2012-spring/sections/math_a_2012-spring_teacher001_000/skills/carpentry/gradebook | 16:03 |
| th1a | hi replaceafill, aelkner, yvl, menesis. | 16:03 |
| yvl | good morning | 16:03 |
| menesis | hi | 16:03 |
| th1a | menesis: Could you see if something is up with my schooltool.org mail? | 16:03 |
| th1a | It doesn't seem to be getting to me. | 16:03 |
| replaceafill | good morning/afternoon | 16:03 |
| menesis | th1a: looking | 16:04 |
| aelkner | replaceafill, can't use the link you posted, doesn't accept teacher001 | 16:05 |
| replaceafill | aelkner, it should | 16:05 |
| replaceafill | that's what i just tried | 16:05 |
| menesis | * postfix is not running | 16:07 |
| aelkner | neverm ind, it works | 16:07 |
| menesis | th1a: mail server has stopped since May 22 | 16:07 |
| th1a | I started a hangout. | 16:07 |
| th1a | menesis: That might explain my lack of mail. | 16:07 |
| th1a | Good thing aelkner tried to use that last night. | 16:07 |
| menesis | th1a: don't worry, you will get lots of error mail to root@schooltool shortly | 16:08 |
| menesis | >:-D | 16:08 |
| th1a | OK, got the first failed hangout attempt out of the way quickly... will try again in a bit. | 16:09 |
| th1a | Yeah, teacher001 isn't working for me. | 16:10 |
| aelkner | just try the link again after you have entered the credentials | 16:11 |
| aelkner | i think there's a problem with the redirect after the login | 16:11 |
| th1a | Oh yeah. Thanks. | 16:12 |
| replaceafill | i think it loses the gradebook part of the url | 16:12 |
| replaceafill | bad traverser setup maybe | 16:12 |
| th1a | OK, here's how this is going to go down. | 16:13 |
| th1a | We're going to do a hangout with David. | 16:14 |
| aelkner | replaceafill, can you tell me why the gradebook looks like this on my instance? | 16:14 |
| aelkner | http://69.164.203.135:36660/schoolyears/2011-2012/2012-spring/sections/art_a_2012-spring_teacher004_000/activities/Worksheet/gradebook/index.html# | 16:14 |
| th1a | We want him to go through the setup steps himself on an empty server instance. | 16:14 |
| aelkner | i assigned a skillset to the course, but it doesn't come up in the gradebook like on your instance | 16:15 |
| replaceafill | aelkner, are you using trunks in your buildout.cfg? | 16:15 |
| aelkner | no i use my checkouts | 16:15 |
| replaceafill | sync your checkouts then | 16:15 |
| th1a | Are you looking at the right gradebook? | 16:15 |
| th1a | One thing we need to use this time for is making sure we've using a fully working and up-to-date instance. | 16:18 |
| aelkner | i can't get my development instance on my machine to have a working gradebook wither | 16:19 |
| aelkner | i checked schooltool.gradebook, it has the stuff you merge into trunk | 16:19 |
| * replaceafill setups one fresh instance | 16:19 | |
| aelkner | i definitely have you cando trunk merge in my instances | 16:20 |
| th1a | aelkner: Ah, I see what we did wrong last night. | 16:26 |
| th1a | We should be using the "students" sheet, not the "persons" sheet. | 16:26 |
| th1a | Also the new style section import is more like CanDo's right? | 16:27 |
| aelkner | FlatSectionsTable is the new one, yes | 16:27 |
| aelkner | we don't have that in the sample_data.xls or sample_data_small.xls yet | 16:28 |
| replaceafill | aelkner, just created a new instance, only with trunks: http://69.164.203.135:6661/schoolyears/2010-2011/2010-fall/sections/math_a_2010-fall_teacher001_000/activities/Worksheet/gradebook | 16:28 |
| replaceafill | looks fine | 16:28 |
| th1a | Hm... if we export the sections you imported what format do we get? | 16:29 |
| aelkner | the FlatSectionsTable | 16:29 |
| th1a | I guess we can use that then. | 16:29 |
| th1a | Does that sheet need to be called FlatSections? | 16:31 |
| aelkner | FlatSectionsTable, yes | 16:32 |
| th1a | OK, we'll have to fix that... | 16:32 |
| th1a | Hm... can I get a sample students import sheet anywhere? | 16:33 |
| aelkner | i guess we should add one to the sample xls files, too | 16:34 |
| th1a | The immediate question is can we have one ready for welsh in 25 minutes? | 16:35 |
| aelkner | for now you could copy the Persons sheet to Teachers and Students sheets and fix the rows | 16:36 |
| th1a | Since I don't have one maybe you could work on that. | 16:36 |
| aelkner | you have the Persons sheet already, but if you want me to do the edit and email, i'll do it | 16:37 |
| th1a | I don't have the students sheet, so yes please. | 16:37 |
| th1a | OK, so I just forwarded the outline of what we're going over with David. | 16:39 |
| th1a | Should not be surprising. | 16:40 |
| th1a | Of course, we don't have the reports yet. | 16:40 |
| th1a | Do we have the flipping from optional to required thing? | 16:40 |
| * th1a goes to refresh his coffee. | 16:42 | |
| th1a | Do we know where the usable gradebook will be after this importing is done? | 16:45 |
| th1a | Who does he log in as? | 16:45 |
| th1a | teacher001? | 16:45 |
| aelkner | better let replaceafill's instance be for the demo, i haven't worked out why mine doesn't work with gradebbok | 16:46 |
| th1a | Yes, but it is teacher001's section with the assigned skills? | 16:46 |
| aelkner | replaceafill? | 16:47 |
| th1a | In your sample data aelkner? | 16:47 |
| replaceafill | aelkner, i just have imported the small sample data xls to it | 16:48 |
| replaceafill | no skills/layers/nodes imports | 16:48 |
| replaceafill | i can blow the data.fs if you need me to | 16:48 |
| th1a | Art A is taught by teacher004, so I guess that's the right teacher. | 16:48 |
| th1a | replaceafill: Import the skills and check teacher004's cando gradebook. | 16:49 |
| replaceafill | can you send me the xls with the skills please? | 16:49 |
| th1a | Oh, or aelkner can do it himself if you give him the URL. | 16:49 |
| replaceafill | sure | 16:49 |
| th1a | Probably quicker. | 16:49 |
| replaceafill | http://69.164.203.135:6661 | 16:50 |
| th1a | Load the skills aelkner. | 16:50 |
| th1a | So I think we should do this as a hangout with david sharing his screen. | 16:50 |
| th1a | He'll do the imports, we'll walk him through that. | 16:50 |
| th1a | And then show him the gradebook, let him poke around with that. | 16:51 |
| aelkner | ok, loading skills... | 16:51 |
| th1a | replaceafill will have to do the IEP's. | 16:51 |
| th1a | how's that student worksheet coming aelkner? | 16:51 |
| aelkner | i sent you the students and teachers sheets | 16:51 |
| th1a | ok thanks. | 16:52 |
| replaceafill | th1a, i haven't finished the iep yet :( | 16:52 |
| th1a | oh, ok. | 16:52 |
| th1a | You can tell him how it's coming. | 16:52 |
| replaceafill | sure | 16:52 |
| aelkner | ok, skills imported | 16:52 |
| replaceafill | we're using teacher004, right? | 16:52 |
| aelkner | wait still importing... | 16:53 |
| *** ignas has joined #schooltool | 16:55 | |
| th1a | OK, hangout started. | 16:57 |
| aelkner | how do i get to t? | 16:59 |
| th1a | I believe you should have an invitation. | 16:59 |
| th1a | Do you have google chat running? | 16:59 |
| th1a | Anyone get anything... ? | 17:00 |
| aelkner | yes, chat is running | 17:01 |
| yvl | btw guys, will you be needing me in the hangout? | 17:01 |
| th1a | Well, I'd like you there yvl. | 17:02 |
| th1a | yvl: We don't need to SEE you. | 17:10 |
| yvl | :D | 17:10 |
| * yvl was looking for a quiet corner in the office | 17:10 | |
| th1a | Welsh is running late btw. | 17:10 |
| th1a | Probably about 10 minutes. | 17:10 |
| yvl | oh, ok | 17:10 |
| replaceafill | aelkner, http://69.164.203.135:6661/schoolyears/2011-2012/2012-spring/sections/art_a_2012-spring_teacher004_000/skills/8002-2011-4/gradebook | 17:11 |
| yvl | can I leave in roughly 1h, assuming everything runs smoothly? | 17:11 |
| th1a | Sure. | 17:11 |
| *** paulproteus has quit IRC | 20:25 | |
| *** paulproteus has joined #schooltool | 20:33 | |
| *** th1a has quit IRC | 20:35 | |
| *** th1a has joined #schooltool | 20:36 | |
| *** ignas has quit IRC | 21:08 | |
| *** menesis has quit IRC | 22:19 | |
| *** menesis has joined #schooltool | 23:00 | |
Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!