| *** ignas has joined #schooltool | 00:34 | |
| *** ignas has quit IRC | 01:25 | |
| *** paulproteus has quit IRC | 02:47 | |
| *** paulproteus has joined #schooltool | 02:48 | |
| *** alga_ has quit IRC | 05:04 | |
| *** aks has joined #schooltool | 06:00 | |
| *** aks has quit IRC | 06:02 | |
| *** aks has joined #schooltool | 06:02 | |
| *** aks_ has joined #schooltool | 06:29 | |
| *** aks has quit IRC | 06:29 | |
| *** aks_ is now known as aks | 06:29 | |
| *** mattva01 has quit IRC | 07:57 | |
| *** mattva01 has joined #schooltool | 08:12 | |
| *** yvl has joined #schooltool | 09:36 | |
| *** ignas has joined #schooltool | 12:59 | |
| *** alga has joined #schooltool | 14:05 | |
| *** ignas has quit IRC | 14:31 | |
| *** aks has quit IRC | 15:23 | |
| *** th1a has joined #schooltool | 15:41 | |
| *** ignas has joined #schooltool | 16:04 | |
| *** ignas has quit IRC | 16:09 | |
| *** mattva01 has quit IRC | 16:10 | |
| *** mattva01 has joined #schooltool | 16:10 | |
| th1a | yvl: Just forwarded an email to you. | 16:18 |
|---|---|---|
| *** replaceafill has joined #schooltool | 16:20 | |
| yvl | thanks, I read it | 16:22 |
| th1a | So we need to come up with a date, I guess. | 16:28 |
| * yvl is unavailable May 18-20 | 16:30 | |
| yvl | other dates are fine, I think | 16:31 |
| aelkner | mornng | 16:31 |
| th1a | hi aelkner, yvl, replaceafill. | 16:32 |
| replaceafill | good morning/afternoon | 16:32 |
| th1a | menesis is on vacation. | 16:32 |
| yvl | yes | 16:33 |
| th1a | OK... we're getting more and more news from my side these days... | 16:33 |
| th1a | Also, everyone in the rest of the world likes to start sending me emails and chats Sunday evening, which is a little annoying. | 16:34 |
| th1a | (it is Monday morning for them, ofc) | 16:34 |
| th1a | Got an email from a company in Qatar that is interested in supporting an Arabic translation. | 16:35 |
| th1a | Critical Links is ready to do their version update so I need to get Justas over there. | 16:35 |
| th1a | ignas's company may pick up a small ST contract from Australia. | 16:36 |
| th1a | We may need more SchoolTool developers soon. | 16:36 |
| th1a | Good news for aelkner. | 16:37 |
| th1a | question for aelkner | 16:37 |
| th1a | In the new section import, did we do anything for linked sections? | 16:38 |
| aelkner | great news | 16:38 |
| aelkner | yes, linked sections are handled, more flexibly than in the old sheet | 16:38 |
| aelkner | in that there is a prev id an next id col whereas before there was just a yes or no | 16:39 |
| aelkner | and the id had to match | 16:39 |
| th1a | Oh, yeah. | 16:39 |
| th1a | Thanks for reminding me. | 16:40 |
| th1a | OK aelkner and yvl, questions for each other? | 16:41 |
| aelkner | yvl, you saw my email to the developer list? | 16:41 |
| yvl | yes I did | 16:41 |
| aelkner | comments? | 16:42 |
| yvl | hmm | 16:43 |
| th1a | Do you have some import sheets working aelkner? | 16:43 |
| aelkner | that's what the note said, and one of them has stests | 16:44 |
| yvl | well, first it struck me weird, that you made an importer for school tool app itself | 16:44 |
| yvl | and btw, the model is done, I had no plans to extend it further | 16:45 |
| aelkner | ok, well, then i guess you'll need to explain how it works | 16:45 |
| yvl | kk | 16:45 |
| yvl | well, competencies are stored globaly | 16:45 |
| yvl | document model (nodes) are stored per year | 16:45 |
| yvl | nodes are linked to competencies | 16:46 |
| aelkner | how? | 16:46 |
| yvl | I don't understand the question | 16:46 |
| aelkner | i see nodes have parents and layers, not competencies | 16:46 |
| aelkner | let's keep our vocabulary specific to match our code if we can, for communication sake | 16:47 |
| yvl | I probably should add the NodeSkillSets as a bound relationship property | 16:47 |
| yvl | but yes, via that | 16:47 |
| aelkner | see, told you something was missing :) | 16:48 |
| yvl | it's not missing | 16:48 |
| yvl | bound properties are a convenience function | 16:48 |
| yvl | a helper, if you will | 16:48 |
| yvl | but ok, I'll add it today | 16:48 |
| aelkner | ah, yes, true in theory, but yes, the helpers help the idiot programmer here to understand :) | 16:49 |
| aelkner | especially the unit tests | 16:49 |
| yvl | my sincere apologies | 16:50 |
| aelkner | np | 16:50 |
| yvl | I should have added that to the interface | 16:50 |
| yvl | will do today | 16:50 |
| aelkner | but ayway, you asked why i had teh importer for the app context | 16:50 |
| aelkner | but you have the views for that context on the skillssets and skills | 16:50 |
| aelkner | so doesn't it make sense to have a matching importer to those views? | 16:50 |
| yvl | sorry, for me it does not make sense | 16:51 |
| th1a | What does this mean to the user? | 16:51 |
| th1a | I mean, what are on the different sheets? | 16:52 |
| aelkner | th1a, on sec, 'll give you links | 16:52 |
| aelkner | http://bazaar.launchpad.net/~schooltool-owners/schooltool/schooltool.cando/view/head:/src/schooltool/cando/browser/stests/sample_global_data.xls | 16:53 |
| aelkner | that's for the global data, i.e., app context | 16:53 |
| aelkner | it matches the Skills views that yvl set up for those objects | 16:54 |
| aelkner | do we have a running instance of those views yet? | 16:54 |
| aelkner | i could set ne up now if we need it | 16:54 |
| th1a | Seeing the sheets is fine for me atm. | 16:54 |
| aelkner | i have stests that do though the ui, starting at the Skills link in the School tab | 16:55 |
| aelkner | and checks that the skillset and skills in question get imported | 16:55 |
| th1a | So what's in the other sheet? | 16:56 |
| aelkner | well, layers and noodes are for the year context, but there is no ui for them yet | 16:57 |
| aelkner | here's the sheet, though: | 16:57 |
| aelkner | http://bazaar.launchpad.net/~schooltool-owners/schooltool/schooltool.cando/view/head:/src/schooltool/cando/browser/stests/sample_data.xls | 16:57 |
| aelkner | all i had to go on was the unit tests, but they were very helpful | 16:57 |
| aelkner | only thing missing was the aforementioned link which yvl said he will add soon | 16:58 |
| th1a | Hm. OK. | 16:58 |
| aelkner | nice that the skills ui was already done | 16:59 |
| th1a | And that's by year? | 16:59 |
| replaceafill | manage-skills-overview should not appear if there's no school year imho | 16:59 |
| replaceafill | ooops, yvl ^ | 16:59 |
| replaceafill | :) | 16:59 |
| yvl | why? | 16:59 |
| replaceafill | it's like the other global containers, isn't? | 17:00 |
| replaceafill | like resources | 17:00 |
| yvl | oh, resources are hidden when no school year? | 17:00 |
| replaceafill | yes | 17:00 |
| yvl | my fault then, thanks for noticing | 17:00 |
| aelkner | replaceafill, why sould resources be hidden when no school year? | 17:01 |
| replaceafill | ask th1a :) | 17:01 |
| aelkner | resources and skills are app dependent, not year dependent, but that's th1a's call | 17:02 |
| th1a | Do resources exist outside of years? | 17:02 |
| aelkner | yep | 17:02 |
| replaceafill | and persons ;) | 17:02 |
| aelkner | ah, yes, persons, too, good point | 17:02 |
| replaceafill | and report sheets? | 17:02 |
| aelkner | templates, yes, deployed, no | 17:03 |
| replaceafill | right | 17:03 |
| th1a | I don't know why resources should be hidden then. | 17:04 |
| aelkner | th1a, in theory, there's no reason not to include persons, resources, skills and report sheet templates | 17:04 |
| aelkner | in the School tab when there is no school year | 17:05 |
| aelkner | but you may have had your reason for not showing them, so... | 17:05 |
| replaceafill | th1a, iirc (it should be in the logs somewhere), we did it to give "adding a school year" emphasis | 17:05 |
| th1a | Well, we probably need to rearrange that page soonish. | 17:05 |
| th1a | Yes... there is no reason to encourage people to not do a school year first. | 17:05 |
| aelkner | that was probably your reason :) | 17:05 |
| replaceafill | like "this is the first thing you should do" | 17:05 |
| th1a | But it is pretty much a toss up. | 17:05 |
| th1a | Yes, focus on what you should be doing first. | 17:06 |
| th1a | I guess I should look at this if yvl has written more of the ttw ui. | 17:07 |
| aelkner | for now, i suppose the, manage-skills-overview should work like the others | 17:07 |
| aelkner | until we come up wth a way of showing those four things when there is no year | 17:08 |
| th1a | Not showing them is fine. | 17:08 |
| th1a | OK... moving on. | 17:09 |
| th1a | anything else aelkner? What's your timeframe looking like for finishing this? | 17:09 |
| aelkner | finishing what part exactly? | 17:10 |
| th1a | The whole CanDo import process? | 17:11 |
| aelkner | well, i need to add the link of the yearly data to the global data when yvl adds that helper | 17:12 |
| aelkner | then i need to add stests for the yearly import when yvl has added the ui for that part | 17:12 |
| aelkner | and we should probably have xls export for app and year data as well, right? | 17:13 |
| aelkner | i can start on that right away as i wait for the updates from yvl | 17:13 |
| th1a | So... another week? | 17:14 |
| aelkner | well, the timeframe is not exactly up to me as i am dependent on changes from yvl, but a week is about right | 17:14 |
| th1a | I'm not sure why the levels sheet goes per year. | 17:14 |
| replaceafill | aelkner, the mega importer should take you back to /manage after finishing i think | 17:15 |
| replaceafill | i mean, the skills mega importer :) | 17:15 |
| aelkner | replaceafill, yes, why not | 17:15 |
| * replaceafill is playing with this new stuff btw ;) | 17:16 | |
| aelkner | yvl, can you answer th1a's question, i can't hear it explained too many times myself | 17:16 |
| yvl | it's only logical | 17:17 |
| yvl | :) | 17:17 |
| yvl | but really | 17:17 |
| yvl | one of the things - is that model is defined per year, so it's structure is also done per year | 17:17 |
| yvl | you don't want to make changing of the layers IMPOSSIBLE | 17:17 |
| yvl | EVER | 17:17 |
| aelkner | perhaps the term, model, is too general | 17:17 |
| aelkner | the whole schooltool Data.fs has a model | 17:18 |
| th1a | Do you only get one set of levels/nodes per year? | 17:18 |
| yvl | I mean "document model", as we used in sprint | 17:18 |
| yvl | document model here is "a set of nodes for the year" | 17:18 |
| aelkner | let's not depend on conversations from the sprint, there is no sin in restating more clearly | 17:18 |
| yvl | ok | 17:18 |
| yvl | I just thought you remembered | 17:19 |
| yvl | th1a, can you clarify your question? | 17:19 |
| yvl | you get one container of layers and one container of nodes | 17:20 |
| th1a | I mean, it seems to me that a set of nodes/levels might apply to several years (usually will) and you often will have several separate documents per year. | 17:20 |
| th1a | Separate sets of skills. | 17:21 |
| yvl | the question is not "usually will" | 17:21 |
| yvl | always will | 17:21 |
| th1a | But I guess this just gets back to our standard use of years. | 17:22 |
| yvl | if not always, you must maintain more than one copy, right? | 17:22 |
| th1a | I don't have a strong feeling about this. | 17:22 |
| yvl | and if you have to maintain more than one copy, | 17:22 |
| th1a | It just seemed to me that we were moving away from organizing this by years. | 17:22 |
| yvl | you probably want to do that per-year | 17:22 |
| th1a | I'll shut up. | 17:22 |
| th1a | aelkner: Anything else? | 17:22 |
| aelkner | yes, i had a question about FlatSectionsTables sheet | 17:24 |
| aelkner | remember how you had me export the section cell repeatedly in the report sheets export | 17:25 |
| aelkner | so that if they decided to sort, they would not lose track? | 17:25 |
| aelkner | nice that we got that released and even got a comment about it from Reimi | 17:26 |
| aelkner | anyway, for the flat sections table, i can make sure the first four cols are always filled | 17:26 |
| aelkner | year, courses, term, section can all be filled on every row | 17:27 |
| th1a | Yes. | 17:27 |
| aelkner | but the rest of the cols do not have a sensible reason for always filling | 17:27 |
| aelkner | section title should only appear once | 17:27 |
| th1a | Uh... we don't need to save bits. | 17:28 |
| aelkner | the students, teachers, resources, and timetable data will depend on how many per section | 17:28 |
| aelkner | save bits? how do you mean? | 17:28 |
| th1a | Why not repeat them? | 17:29 |
| aelkner | repeat them | 17:29 |
| aelkner | i don't know what you mean | 17:29 |
| aelkner | perhaps we should do this by phone after the meeting | 17:29 |
| th1a | I don't see what the advantage of blank space is in this case. | 17:30 |
| aelkner | well, it will only hold up the other guys if we go down this road in the chat, so... | 17:31 |
| th1a | I guess just do it the way you want. | 17:31 |
| th1a | OK, moving on... | 17:31 |
| th1a | Thanks aelkner. | 17:31 |
| th1a | yvl? | 17:31 |
| yvl | I'm working on node creation ttw | 17:32 |
| yvl | crude skills/skillsets creation and assignment to courses done | 17:32 |
| yvl | technically, now we can write a skills gradebook prototype | 17:33 |
| yvl | using ISectionsSkills(sectoin) | 17:33 |
| yvl | that collects ICourseSkills for related courses | 17:33 |
| yvl | that contain ICourseSkillset s, that are worksheets | 17:33 |
| yvl | hope it works :D | 17:34 |
| * yvl done | 17:34 | |
| * replaceafill is testing it... | 17:34 | |
| th1a | Thanks yvl. | 17:34 |
| th1a | replaceafill? | 17:34 |
| replaceafill | ok | 17:35 |
| replaceafill | http://69.164.203.135:6662/schoolyears/2011-2012/20112012/sections/13/activities/Sheet3/gradebook | 17:35 |
| replaceafill | teacher007 | 17:35 |
| replaceafill | i made the gradebook tabs "ajaxy" | 17:35 |
| replaceafill | they still unstable, i need to attach some javascript handlers the right way | 17:35 |
| replaceafill | buy click on the tabs | 17:35 |
| replaceafill | and the page should not reload completely | 17:36 |
| th1a | Oh, the grid reloads. | 17:36 |
| replaceafill | yes | 17:36 |
| th1a | I couldn't figure out why you were worrying about the *tabs* loading. ;-) | 17:36 |
| replaceafill | i have a question here though | 17:36 |
| replaceafill | :D | 17:36 |
| replaceafill | we have some options on the sidebar | 17:37 |
| replaceafill | that depends on the worksheet | 17:37 |
| replaceafill | like Add: Activity | 17:37 |
| replaceafill | or Printable Worksheet | 17:37 |
| replaceafill | yvl, i'd like your opinion on this idea: | 17:37 |
| replaceafill | use JS on those links to get the right url from the form action | 17:38 |
| replaceafill | of the grid | 17:38 |
| replaceafill | seems messy though | 17:38 |
| replaceafill | another idea i had was to move the Add: Activity link somewhere inside the grid | 17:39 |
| replaceafill | maybe near the Activity/Points area | 17:39 |
| yvl | or you can return the new rendered sidebar, along with the grid data | 17:39 |
| replaceafill | yvl, ah! | 17:39 |
| replaceafill | refresh the links! | 17:39 |
| replaceafill | i mean, reload | 17:39 |
| yvl | right | 17:39 |
| replaceafill | :| | 17:39 |
| yvl | not exactly clean | 17:39 |
| yvl | but would work :) | 17:40 |
| replaceafill | but cleaner than the JS trickery ;) | 17:40 |
| replaceafill | cool, i'll try that | 17:40 |
| replaceafill | thanks! | 17:40 |
| yvl | I was planning on doing something for that at some point | 17:40 |
| yvl | like, default API to return multiple rendered "blocks" and their html ids | 17:40 |
| yvl | as in - please replace contents with these contents | 17:41 |
| replaceafill | ah, that would be nice | 17:41 |
| replaceafill | ah btw yvl | 17:41 |
| yvl | it would :) | 17:41 |
| replaceafill | is there any advantage on using the ajaxparts machinery | 17:41 |
| replaceafill | instead of a "regular" viewlet | 17:41 |
| yvl | it handles posts | 17:41 |
| yvl | so if you have more than one "ajax" part in the same view | 17:42 |
| yvl | that has a form, or wants to act like a form | 17:42 |
| yvl | it submits to those viewlets instead of the main vie | 17:42 |
| yvl | w | 17:42 |
| replaceafill | right, i followed your table examples for this, which behaves like that | 17:43 |
| yvl | for example, if you have two tables that need ajaxy sorting ;) | 17:43 |
| replaceafill | a viewlet manager with several viewlets registered for it | 17:43 |
| * replaceafill checks his notes | 17:43 | |
| replaceafill | ah | 17:43 |
| replaceafill | yes | 17:43 |
| replaceafill | the navigators | 17:43 |
| replaceafill | right now, the gradebook overview class has this logic | 17:44 |
| replaceafill | for redirecting based on the navigators | 17:44 |
| replaceafill | the left menus for section, term and year | 17:44 |
| replaceafill | i was thinking we could use plain javascript location redirects there | 17:44 |
| replaceafill | instead of doing form submits | 17:44 |
| replaceafill | less hits on the server | 17:44 |
| replaceafill | and i noticed the Jump To menus on the calendar behaves like this | 17:45 |
| replaceafill | we just need to place the logic of the view into the viewlets for creating the navigators | 17:45 |
| yvl | sounds ok to me | 17:46 |
| replaceafill | kk, will change that | 17:46 |
| yvl | or maybe I misunderstood you | 17:46 |
| yvl | nvm | 17:47 |
| replaceafill | i think you coded the Jump To viewlets :) | 17:47 |
| yvl | it's ok :) | 17:47 |
| yvl | nope | 17:47 |
| yvl | ignas did :) | 17:47 |
| replaceafill | ah | 17:47 |
| replaceafill | i think i'm done | 17:47 |
| replaceafill | i should write my notes better :( | 17:47 |
| th1a | OK. | 17:48 |
| replaceafill | don't understand them on monday morning :( | 17:48 |
| th1a | lol | 17:48 |
| yvl | :))) | 17:48 |
| th1a | I think we're all good. | 17:48 |
| th1a | Oh, also, I may visit Vilnius around the end of May. I may be going to Berlin for a Shuttleworth Foundation meeting and probably should swing by. | 17:48 |
| th1a | Although Jennifer reminds me that Poland is big. | 17:49 |
| th1a | Presumably I can get a flight from Berlin to Vilnius. | 17:49 |
| yvl | cool, I hope you get the fligh | 17:50 |
| yvl | t | 17:50 |
| th1a | Anyhow, nothing is definite. | 17:50 |
| yvl | (and yes, getting a flight would be way better than driving) | 17:50 |
| yvl | sure | 17:50 |
| th1a | I'm not going to drive across Poland. | 17:50 |
| th1a | Unless I can rent a tank. | 17:50 |
| th1a | OK, catch you guys Wednesday. | 17:50 |
| yvl | thanks guys! | 17:51 |
| th1a | Thanks! | 17:51 |
| replaceafill | thanks everybody | 17:51 |
| * th1a drops the bag of gravel. | 17:51 | |
| aelkner | thanks guys, cya wed | 17:51 |
| yvl | aelkner, committed - both st trunk and st cando | 18:20 |
| yvl | happy coding! | 18:20 |
| aelkner | thanks! | 18:22 |
| *** replaceafill has quit IRC | 18:52 | |
| *** replaceafill has joined #schooltool | 18:52 | |
| th1a | aelkner: ayt? | 19:15 |
| aelkner | th1a, hey | 22:24 |
| th1a | Joe Ucha has some skills for us to test your importer on. | 22:25 |
| aelkner | should we use my demo instance or create one for him as we did for david ally | 22:26 |
| th1a | I suspect yours would be fine. | 22:27 |
| aelkner | ok, i'll have to update it to have cando, won't take much | 22:27 |
| th1a | I sent you the sheet. | 22:29 |
| aelkner | ok, you know that we will have our standard, directly-mapped import format | 22:30 |
| aelkner | to match our data objects | 22:31 |
| aelkner | others may represent the information in other interesting ways with stuff that we could even ignroe | 22:31 |
| aelkner | one common option will be to convert one xls file to another, a managable, repeatable action | 22:31 |
| aelkner | and the user will have to run their data through a chain of conversion | 22:32 |
| aelkner | in some cases | 22:32 |
| aelkner | certainly, in this case , at first quick glance, it doesn't match our importer | 22:32 |
| th1a | Yes, I know aelkner. | 22:33 |
| aelkner | ok, sorry for the obvious | 22:33 |
| aelkner | just trying to anticipate what we will need | 22:34 |
| aelkner | i'll have to digest the file before writing a converter, again, obviously | 22:35 |
| th1a | Or perhaps just cutting and pasting columns? | 22:36 |
| aelkner | hardly, the cells contain data that needs parsing, ids, descriptions lopped together | 22:39 |
| th1a | OK. | 22:39 |
| aelkner | the dimension of the table is different, with skilllsets as columns | 22:40 |
| aelkner | that could be interesting as an idea for a supported format | 22:40 |
| aelkner | but the parsing needs doing, the skillset ids would have to be chosen by auto chooser | 22:41 |
| aelkner | without explicit ids, reimport could only be supported via title matching | 22:42 |
| th1a | They have local ids. | 22:43 |
| th1a | just make it like 2012-math-1.1 | 22:44 |
| aelkner | row one could be the ids | 22:44 |
| aelkner | if they don't mind adding that row | 22:44 |
| th1a | ... | 22:45 |
| aelkner | then they would have reimport covered for the skillset side of things | 22:45 |
| aelkner | but the skills themselves have ids within the skillset | 22:45 |
| aelkner | it's a process thing that needs to be defined precisely to work | 22:46 |
| aelkner | i have a suggestion | 22:46 |
| th1a | Are you looking at the math skills? | 22:46 |
| * th1a is now actually looking at aelkner's import form. | 22:47 | |
| aelkner | i've been looking at the sheet you sent | 22:48 |
| th1a | The math skills sheet is the relevant worksheet. | 22:48 |
| th1a | Are you looking at that one? | 22:48 |
| aelkner | so column A | 22:48 |
| aelkner | CC Standard... | 22:48 |
| th1a | ? | 22:48 |
| aelkner | that's a skillset title, right? | 22:49 |
| aelkner | oh, sorry | 22:49 |
| th1a | Column A says "Competency Group" | 22:49 |
| aelkner | looking at the wrong sheet, one sec | 22:49 |
| th1a | ok | 22:49 |
| aelkner | i was looking at standards, nothing i was saying made any sense :) | 22:50 |
| th1a | Indeed. | 22:50 |
| aelkner | Math Skills has the info we would need, ids for both skillsets and skills | 22:51 |
| aelkner | interesting using one col for both types of ids | 22:51 |
| aelkner | funny how xls can be used, note use of empty space helps support tree-like structure | 22:52 |
| aelkner | that's what i was gong for with FlatSectionTable, sort of | 22:52 |
| th1a | Yes, sure. | 22:52 |
| aelkner | but the idea of repeating the info back on export rather than repeating the empty cells, it depends | 22:53 |
| aelkner | in the case of the report sheets export, each row was a true record, with all keys set | 22:53 |
| aelkner | like you said, it could be sorted in order, np | 22:53 |
| th1a | We just have to be more careful about what we export. | 22:54 |
| aelkner | but in the case of FlatSectionsTable, lke the Math Skills, structure matters | 22:54 |
| th1a | It is nice to let people import that structure if they want. | 22:54 |
| aelkner | perhaps flat sections table export shold not be supported in the same way | 22:54 |
| aelkner | i can see how you have indicated that not all imports will be end up as exports | 22:55 |
| *** ignas has joined #schooltool | 22:55 | |
| th1a | Anyhow, perhaps you could have a crack at importing these. | 22:56 |
| aelkner | I could write a temporary special Math Skills importer for test purposes | 22:57 |
| th1a | ... | 22:57 |
| aelkner | here's a thought | 22:58 |
| aelkner | keeping in mind how our importers do their job by finding the sheets by name | 22:58 |
| th1a | OK, I'll do it... | 22:58 |
| aelkner | play around with whatever you want to, but don't get married to something that might end up not making sense process-wise | 22:59 |
| aelkner | or, you could let me do it :) | 23:00 |
| aelkner | i was about to suggest that in theory, we could support a two-level tree | 23:01 |
| aelkner | if we had a special mega importer that only accepted a special type of xls | 23:01 |
| aelkner | that had sheet titles that were skillsets at the root level of the tree | 23:02 |
| th1a | How's that? | 23:02 |
| aelkner | and then the sheets would have format matching that of the Math Skills sheet in the example | 23:02 |
| th1a | (I mailed you a sheet) | 23:02 |
| aelkner | i'm looking at the google doc version of the xls, i could download it to make sure | 23:03 |
| aelkner | ok, it's same as i would expect | 23:03 |
| aelkner | it has different sheets that have different format for the data, so what i was about to suggest is not for that file | 23:04 |
| aelkner | i theory the file could have sheets that have only the same format as the Math Skills sheet | 23:04 |
| aelkner | then, each sheet would be at the same level as Math Skills, the root level | 23:04 |
| aelkner | then within each sheet, you would have the sub goups, under them comps (old terminology) | 23:05 |
| aelkner | remember, the old cando has a tree of comp group containing comp group, down to comp | 23:05 |
| th1a | So... would what I just sent you work? | 23:05 |
| aelkner | why the heck are all the sheets in different formats, have you noticed? | 23:06 |
| aelkner | and the parsing would have to be very specific | 23:07 |
| aelkner | really, the best way to handle this file is to not support it in schooltool at all | 23:08 |
| th1a | aelkner, We care not a whit about any other than the math skills. | 23:08 |
| aelkner | a converter, can be a command line python process, could convert it | 23:08 |
| aelkner | into another cls that could be imported by schooltool | 23:08 |
| th1a | aelkner, I think I just did it with copy/paste in 5 minutes. | 23:08 |
| aelkner | can you send me the importable file? | 23:09 |
| th1a | Uh... did you get my sample_global_data file? | 23:10 |
| aelkner | i'm looking at the B2T_math_skills.... xls file from your email, what other file? | 23:11 |
| th1a | ....... | 23:12 |
| aelkner | ah, sorry, had the other email open, didn't see the new one | 23:12 |
| aelkner | ok, so you need a SkillSets sheet | 23:12 |
| aelkner | in there, one row per skill set, it, Title, external id (not in this case), label (not useful) | 23:13 |
| aelkner | then, you need to use the id in the Skills sheet, not the title | 23:13 |
| aelkner | titles are changable by the user, typos, important change or other nature, ids are keys | 23:13 |
| th1a | OK... you can do that too. | 23:14 |
| aelkner | but you see it is not cut and paste | 23:14 |
| aelkner | at least not as a process thing | 23:14 |
| aelkner | anyway, i'm guessing you just want to pretend we wrote the converter and manually edit this file | 23:15 |
| th1a | aelkner, you just need to rearrange your brain cells a bit. | 23:15 |
| aelkner | btw, aren't you choice for the skill titles as long as descriptions? | 23:16 |
| aelkner | what would the description column be for? | 23:16 |
| aelkner | i guess we never really used them? | 23:16 |
| th1a | This is you testing how the vast majority of users will use the default importer. | 23:17 |
| th1a | Not how programmers will write new importers. | 23:17 |
| aelkner | i just looked at the old xml file, comps don't have descriptions | 23:18 |
| aelkner | regarding testing how users use importers, different users want different things | 23:22 |
| th1a | ... | 23:23 |
| aelkner | many assume titles can be used as ids, even though that is not gong to make them happy when they want to change the title | 23:23 |
| th1a | We're providing an xml template so they can cut and paste stuff into it. | 23:23 |
| th1a | If they don't have meaningful id's to start with they aren't going to be that concerned about them. | 23:24 |
| aelkner | the old cando has xml import, the new one hasn't gone there yet | 23:27 |
| th1a | We're using the spreadsheets you're writing. | 23:27 |
| aelkner | i wold think that in virgina's case that once they understand how our import works | 23:28 |
| aelkner | they would programatically create the input file as they did the xml file in the old cando | 23:29 |
| aelkner | now perhaps we will be able to do that from their web site, i realize that | 23:30 |
| aelkner | but in either case, it will be a programmatic conversion into our xls format | 23:31 |
| th1a | The idea is that they will use our xls format. | 23:32 |
| th1a | That's the format. | 23:32 |
| aelkner | i'm focused on getting an import working that is definition sound, repeatable, with matching export | 23:32 |
| aelkner | as far as converting their data, i would recommend waiting until we have our stuff ready | 23:33 |
| aelkner | we still have ui stuff that needs to be used to automate test the imports | 23:33 |
| aelkner | yvl just added a reference of nodes to skillsets, so i need to digest that and update the importer | 23:34 |
| aelkner | but i have the file you gave me for now, so i will keep it in mind | 23:34 |
| aelkner | but let's hold off on any demo, ok th1a? | 23:35 |
| th1a | Well, I don't know, because it isn't really clear that you understand what we're trying to do here at all. | 23:35 |
| th1a | This should be an easy cut and paste and a little manual tweaking conversion. | 23:36 |
| th1a | This is the way most people are supposed to use the system. | 23:36 |
| th1a | This should take about a half hour to finish, right? | 23:37 |
| aelkner | i only know the way one customer has used the old system, that guides my thinking about use cases | 23:38 |
| th1a | This is what I'm trying to break you out of aelkner. | 23:38 |
| th1a | That's the point. | 23:38 |
| aelkner | in their case, they went through the trouble of providing us an xml file, programatically | 23:39 |
| aelkner | that was ideally structured to be importable | 23:39 |
| th1a | Yes, we're not doing that anymore. | 23:39 |
| th1a | We're done with that. | 23:39 |
| th1a | Because NOBODY ELSE COULD CREATE IT. | 23:39 |
| aelkner | ok, i'm listening | 23:39 |
| th1a | That's why we're using a spreadsheet. | 23:39 |
| th1a | So that people can cut/paste and tweak their data manually. | 23:40 |
| th1a | As in this case. | 23:40 |
| aelkner | i think you have a fantasy spreadsheet in mind, one that makes all the right assumptions at the right time | 23:40 |
| th1a | aelkner, I have in mind the spreadsheet that you wrote. | 23:41 |
| th1a | That I took the data from another spreadsheet and cut and pasted into. | 23:41 |
| aelkner | well, not exactly | 23:41 |
| th1a | And as far as I can tell to finish it the skillset id's need to be converted to id's (not hard) and the node/level sheet has to be written. | 23:41 |
| aelkner | what you did would import | 23:41 |
| aelkner | ah | 23:41 |
| th1a | human intervention aelkner. | 23:42 |
| aelkner | but you also need to do the SkillSets sheet | 23:42 |
| th1a | Why don't you have a crack at that yourself. | 23:42 |
| th1a | the skillset id's can just be numbers. | 23:42 |
| aelkner | why don't we talk on the phone because i'm finding what you are saying hard to follow | 23:42 |
| th1a | 1, 2, 3, 4... | 23:42 |
| th1a | OK. | 23:42 |
| aelkner | your home line? | 23:44 |
Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!