| *** Diego has joined #schooltool | 00:04 | |
| Diego | Hello | 00:15 |
|---|---|---|
| Diego | I speak spanish it´s posible talk in my languages | 00:15 |
| replaceafill | hola Diego | 00:20 |
| replaceafill | claro | 00:20 |
| Diego | gracias ya tengo instalado el sistema en la escuela donde trabajo y necesitamos realizar un reporte de matricula con datos del alumno y de su contacto, hay la posibilidad de realizarlo | 00:21 |
| Diego | con alguna herramienta | 00:21 |
| replaceafill | hhmm lamentablemente no existe un reporte asi aun | 00:22 |
| replaceafill | pero es posible exportar los datos de la escuela | 00:22 |
| replaceafill | a un archivo XLS | 00:22 |
| replaceafill | y hay dos hojas que le pueden servir | 00:23 |
| replaceafill | Students, Contacts | 00:23 |
| replaceafill | ah bueno, y una tercera | 00:23 |
| replaceafill | Contact Relationships | 00:24 |
| replaceafill | con las tres podría generar un reporte como el que necesita | 00:24 |
| *** th1a has quit IRC | 00:24 | |
| replaceafill | el archivo XLS lo puede obtener ingresando como administrador y haciendo click en la pestaña Escuela | 00:26 |
| replaceafill | y luego en la opción lateral Reportes -> Exportar como XLS | 00:26 |
| Diego | muchas gracias por la información le agradezco su apoyo | 00:43 |
| replaceafill | con gusto :) | 00:43 |
| *** Diego has left #schooltool | 00:44 | |
| *** menesis has quit IRC | 01:02 | |
| *** replaceafill has quit IRC | 02:39 | |
| *** th1a has joined #schooltool | 03:14 | |
| *** aelkner has quit IRC | 04:58 | |
| *** th1a has quit IRC | 05:00 | |
| *** th1a has joined #schooltool | 05:07 | |
| *** th1a has quit IRC | 05:23 | |
| *** aelkner has joined #schooltool | 05:38 | |
| *** aelkner has quit IRC | 06:34 | |
| *** menesis has joined #schooltool | 11:23 | |
| *** ignas has joined #schooltool | 14:49 | |
| *** aelkner has joined #schooltool | 15:57 | |
| *** aelkner has quit IRC | 16:01 | |
| *** aelkner has joined #schooltool | 16:14 | |
| *** menesis has quit IRC | 16:56 | |
| *** menesis has joined #schooltool | 17:23 | |
| *** th1a has joined #schooltool | 18:23 | |
| *** replaceafill has joined #schooltool | 18:25 | |
| th1a | hi replaceafill. | 18:25 |
| replaceafill | hey th1a | 18:25 |
| replaceafill | th1a, Glenda called you a genius :) | 18:35 |
| th1a | You did the hard part. | 18:35 |
| th1a | aelkner:ayt? | 19:25 |
| aelkner | th1a, yes | 19:41 |
| th1a | Are you helping with these imports? | 19:41 |
| aelkner | i just got back from lunch and see an email from glenda | 19:42 |
| aelkner | i have to read it now | 19:42 |
| th1a | kk | 19:43 |
| th1a | are you helping welsh? | 19:43 |
| th1a | are you guys in the same place? | 19:43 |
| replaceafill | i think i found the issue with the importer | 19:45 |
| replaceafill | the get id cell function | 19:45 |
| replaceafill | checks against str | 19:45 |
| replaceafill | and the value comes as unicode | 19:45 |
| replaceafill | if not isinstance(value, str) and not isinstance(value, unicode): | 19:46 |
| replaceafill | the second condition is true for unicode | 19:46 |
| replaceafill | but the first one is false | 19:46 |
| replaceafill | i think this should use basestring for comparison | 19:46 |
| replaceafill | isinstance(value, basestring) | 19:46 |
| * replaceafill blames excel | 19:47 | |
| replaceafill | :D | 19:47 |
| replaceafill | if i change the usernames in dwelsh spreadsheet to '10000 | 19:47 |
| replaceafill | it works | 19:47 |
| th1a | http://docs.python.org/library/types.html#types.StringTypes ? | 19:53 |
| th1a | isinstance(s, types.StringTypes) ? | 19:54 |
| aelkner | replaceafill, thelogic of the and will work | 19:54 |
| replaceafill | well, not only that, xlrd thinks dwelsh data is float :( | 19:54 |
| aelkner | it's saying that both are false | 19:55 |
| aelkner | that will be true if the type is neither str or unicode | 19:55 |
| replaceafill | i get: | 19:55 |
| replaceafill | 100000.0 for the first username | 19:55 |
| aelkner | that's the float! | 19:55 |
| replaceafill | but that comes from xlrd | 19:56 |
| replaceafill | right? | 19:56 |
| aelkner | yep | 19:56 |
| replaceafill | that's why i blame excel | 19:56 |
| replaceafill | i calc, i do '1000000 | 19:56 |
| replaceafill | to format as string | 19:56 |
| replaceafill | and it works | 19:56 |
| replaceafill | well, aelkner is here :) | 19:56 |
| replaceafill | i'll go back to reports | 19:56 |
| th1a | Does it work consistently when welsh uses the third method here: http://office.microsoft.com/en-us/excel-help/three-ways-to-convert-numbers-to-text-HA001136619.aspx | 19:59 |
| aelkner | replaceafill, yes, ' works somehow in opencalc, too | 19:59 |
| aelkner | th1a, welsh used the Data|Text to Columns function and i believe that will be his instructions to the other users | 20:01 |
| th1a | Well, we need to confirm what is going on. | 20:01 |
| th1a | Can you reproduce that working? | 20:02 |
| aelkner | yes, they have excel here in the lab | 20:02 |
| aelkner | we entered numbers, then used Text to column and it worked | 20:02 |
| aelkner | btw, i sent glenda an email to correct one point about what year the sections importer works for | 20:03 |
| th1a | So the cells appear to have exactly the same format from within Excel as the sheets that don't work? | 20:04 |
| th1a | xlrd sees them as completely different types? | 20:04 |
| aelkner | xlrd sees them as unicode | 20:04 |
| aelkner | if you don't do one of the three method, it gets a float | 20:04 |
| aelkner | btw, if you format the numbers as text using the format cells feature, they appear to be text in that they align left | 20:06 |
| aelkner | but xlrd gets floats | 20:06 |
| menesis | this was a solved problem. | 20:10 |
| menesis | i don't know why you added getIdFromCell method that checks cell type | 20:11 |
| menesis | getTextFoundValid had a solution | 20:11 |
| aelkner | well, not exactly | 20:13 |
| menesis | original bug was https://bugs.launchpad.net/schooltool/+bug/801870 | 20:13 |
| menesis | then https://bugs.launchpad.net/schooltool/+bug/1020841 returned to previous situation (need to force formatting) | 20:14 |
| aelkner | ok, perhaps we could use the same kind of logic | 20:14 |
| menesis | if int(value) == value: value = int(value) | 20:14 |
| menesis | this did not work sometimes? | 20:15 |
| aelkner | yes, that's a bit hacky | 20:15 |
| aelkner | th1a asked me to make sure id cells were actually text | 20:15 |
| aelkner | that's different than the hacky test you just mentioned | 20:15 |
| aelkner | perhaps, if it's too hard to ask users to do text formatting, we could rely on the same logic | 20:16 |
| th1a | Well, the ultimate problem is we might end upwith decimal points added to our id's, etc. | 20:16 |
| menesis | this was old problem that was fixed | 20:16 |
| th1a | Or losing them, I guess. | 20:16 |
| th1a | We also don't know which versions of Excel have this bug. | 20:17 |
| menesis | oh well. yes if you want usernames like 1234.0 then it will lose the .0 | 20:17 |
| aelkner | right | 20:17 |
| aelkner | and i agree that's a dumb id | 20:17 |
| th1a | I mean, if we're starting from the knowledge that Excel is bugged, we might not take this route, at all. | 20:17 |
| aelkner | we could have a rule that disallows that | 20:17 |
| menesis | but in my testing back then it was hard to make a cell that contained a number be formatted as text | 20:18 |
| th1a | It isn't that hard to tell people what they need to do. | 20:18 |
| th1a | I mean, insofar as we seem to have it figured out. | 20:18 |
| aelkner | it wold be nice to have something in the book about it i think | 20:19 |
| th1a | I'd really rather avoid code that silently changes the id of every person being imported. | 20:19 |
| th1a | The whole thing has to be explained in the type error message. | 20:19 |
| th1a | Also, this is not an issue at all if you're using LibreOffice, right? | 20:20 |
| menesis | it is the same | 20:20 |
| menesis | from what I remember | 20:20 |
| th1a | Excel seems to completely lie to you; I don't think LibreOffice does. | 20:20 |
| th1a | Maybe. | 20:21 |
| menesis | I only tested with LibreOffice and had problems | 20:21 |
| menesis | maybe entering '1234 as replaceafill said will treat the value as text | 20:22 |
| aelkner | it does | 20:22 |
| replaceafill | yes | 20:22 |
| aelkner | that has always been my solution | 20:22 |
| aelkner | problem is | 20:22 |
| replaceafill | but that's oo specific, right? | 20:22 |
| th1a | we can recommend that | 20:22 |
| aelkner | when you already have 10000 rows of numbers | 20:22 |
| aelkner | changing them all to have a ' in front of them is difficult in excel | 20:23 |
| menesis | true | 20:23 |
| menesis | and "Change cell formatting" does not work? | 20:23 |
| aelkner | right | 20:23 |
| replaceafill | maybe we could use this: | 20:23 |
| replaceafill | https://secure.simplistix.co.uk/svn/xlrd/trunk/xlrd/doc/xlrd.html#formatting.Format.type-attribute | 20:23 |
| th1a | I would be ok with munging the numbers as id's as long as we have a clear explanation/warning confirmation before it goes ahead. | 20:23 |
| menesis | ok, a question is | 20:24 |
| menesis | was there a problem importing numeric ids in 2.1? | 20:24 |
| *** ignas has quit IRC | 20:25 | |
| menesis | because it should have worked just fine | 20:25 |
| th1a | Unless you had id's with decimal points in them. | 20:25 |
| th1a | Correct? | 20:25 |
| menesis | correct, if you explicitly used "1234.0" with zero after decimal point | 20:26 |
| menesis | 1234.5 would translate to "1234.5" | 20:26 |
| aelkner | yes | 20:27 |
| aelkner | that's in getTextFoundValid, true | 20:27 |
| aelkner | however, if it is 1234.0, then it yields "1234" | 20:27 |
| aelkner | that's a bit unpredictable | 20:27 |
| th1a | I can live with that if we have some kind of warning/cancel. | 20:28 |
| th1a | I suppose that's a giant pain in the ass. | 20:28 |
| *** yvl has quit IRC | 20:28 | |
| aelkner | what would that be like for the user? they get a warning message, the view stays visible rather than redirecting to School tab, and the data is updated on the server? | 20:29 |
| th1a | Modal dialogue. | 20:29 |
| th1a | abort/continue | 20:30 |
| aelkner | modal with xls view still visible? | 20:30 |
| aelkner | and no update until continue is chosen? | 20:30 |
| th1a | yes | 20:31 |
| menesis | is it worth that much coding to support float IDs? we don't generate such IDs | 20:32 |
| aelkner | most dotted ids are first_name.last_name | 20:32 |
| th1a | Probably not. | 20:32 |
| menesis | but government id or some other user entered strings can be | 20:32 |
| menesis | then the getText... methods need to be changed to avoid losing the trailing ".0" | 20:33 |
| th1a | It is obviously an edge case. | 20:33 |
| th1a | The user is assigning the id's here though. | 20:34 |
| th1a | So they *could* try to have one with a trailing .0 | 20:34 |
| th1a | aelkner: Could you double check how this works with LibreOffice, please. | 20:35 |
| aelkner | is that a different app from open office? it's the same word | 20:37 |
| aelkner | i don't find it in synaptic package manager | 20:38 |
| aelkner | i went to the site and tried to download | 20:40 |
| * th1a sighs. | 20:40 | |
| aelkner | it says something about torrent and i accepted | 20:40 |
| th1a | What version of Ubuntu are you using aelkner? | 20:40 |
| th1a | They changed the name, hopefully it hasn't changed that much. | 20:41 |
| aelkner | 10.04 | 20:41 |
| aelkner | lucid | 20:41 |
| th1a | Well, try openoffice then. | 20:42 |
| aelkner | that's what i've been using, what else would i have used? | 20:43 |
| aelkner | and we already know the issues with that | 20:44 |
| aelkner | i've had them for years now, so i'm npt sure what you're asking | 20:44 |
| th1a | Well, you really should update to 12.04 when you get a chance. | 20:44 |
| th1a | Not today. ;-) | 20:44 |
| aelkner | so that i can see if the problem is fixed in that version of open office? | 20:45 |
| aelkner | is that what you're asking? | 20:45 |
| th1a | Yes. Try it on openoffice. | 20:47 |
| aelkner | ok, i'll upgrade my machine some time soon, i was already starting to accept the idea of having to deal with the stupid ui changes, so i might as well go ahead an upgrade | 20:50 |
| aelkner | fact is there is enough room on the left with those big icons to fit all the hotkeys i like to have above at present | 20:50 |
| th1a | You can still use the old ui. | 20:53 |
| menesis | you can use Gnome Classic session | 20:54 |
| menesis | I think you only need to install gnome-panel | 20:54 |
| menesis | and choose gnome session on login | 20:54 |
| menesis | it is not the same as before | 20:55 |
| aelkner | oh, that would be nice | 20:55 |
| menesis | indicators on the right have changed | 20:55 |
| menesis | but it is still gnome panel | 20:55 |
| menesis | I really like Unity, though | 20:55 |
| menesis | how it saves vertical space for maximized apps by having title and menubar in the panel | 20:56 |
| aelkner | i prefer to maximize all apps, so that's good | 20:56 |
| th1a | aelkner: I just sent you a sheet to double check. | 21:03 |
| aelkner | th1a, same error for cells A4-10468 | 21:05 |
| th1a | What about if you just make something from scratch in OO (with a fake student or two)? | 21:06 |
| th1a | OK, I should stop picking this scab. | 21:09 |
| th1a | Just revert to the old behavior of chopping off the .0 or whatever. | 21:09 |
| aelkner | oh, really, that's a big decision | 21:09 |
| aelkner | i could keep the getId calls just in case we want to change something with them later | 21:10 |
| aelkner | but add the int(value) == value logic that chops the .0 | 21:10 |
| aelkner | but you mean get rid of the ids must be text error message, correct? | 21:11 |
| th1a | Yeah. | 21:11 |
| aelkner | that would definitely help the virginia folks with their docs | 21:11 |
| aelkner | ok, will do | 21:12 |
| *** menesis has quit IRC | 21:15 | |
| * th1a goes to cool off. | 21:23 | |
| replaceafill | hhmm, is it me or we can't access ST.local inside $(documen).ready()? | 22:17 |
| *** th1a has quit IRC | 22:17 | |
Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!