IRC logs of #tryton for Friday, 2011-02-04

chat.freenode.net #tryton log beginning Fri Feb 4 00:00:02 CET 2011
2011-02-04 00:15 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton
2011-02-04 02:19 -!- FWiesing(~franz@mail.tryton.at) has left #tryton
2011-02-04 02:27 -!- marga(~marga@nereida.gnuservers.com.ar) has joined #tryton
2011-02-04 02:35 -!- pepeu(~manuel@201.155.193.192) has joined #tryton
2011-02-04 02:48 -!- kwmiebach1(~ad@xdsl-78-34-235-127.netcologne.de) has left #tryton
2011-02-04 03:43 -!- johbo_(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton
2011-02-04 04:17 -!- ikks(~ikks@190.158.120.51) has joined #tryton
2011-02-04 05:18 -!- yangoon(~mathiasb@p549F6D40.dip.t-dialin.net) has joined #tryton
2011-02-04 08:38 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton
2011-02-04 08:49 -!- okko(~okko@62.58.29.41) has joined #tryton
2011-02-04 08:53 -!- Lo-lan-do(~roland@mirexpress.internal.placard.fr.eu.org) has joined #tryton
2011-02-04 08:55 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton
2011-02-04 09:00 -!- predatell(~werty@195.189.234.248) has joined #tryton
2011-02-04 09:17 -!- predatell(~werty@195.189.234.248) has left #tryton
2011-02-04 09:17 -!- predatell(~werty@195.189.234.248) has joined #tryton
2011-02-04 09:21 -!- ecarreras(~under@unaffiliated/ecarreras) has joined #tryton
2011-02-04 09:34 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2011-02-04 09:38 <cedk> marc0s: hi, I see that you're going to FOSDEM
2011-02-04 09:38 <cedk> marc0s: bechamel and me are going also
2011-02-04 09:43 <marc0s> cedk: yes!
2011-02-04 09:44 <marc0s> cedk: i'm arriving there this evening, hoping to be there for the beer event :)
2011-02-04 09:44 <cedk> marc0s: we go tomorrow
2011-02-04 09:48 <marc0s> cedk: ok I still have to check the talks i want to attend... there are too many :D
2011-02-04 09:49 <cedk> marc0s: me too
2011-02-04 09:57 -!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton
2011-02-04 10:07 <cedk> marc0s: if you want we can meet eachother ?
2011-02-04 10:07 <marc0s> cedk: sure! sorry just a bit busy at the office :)
2011-02-04 10:07 <cedk> marc0s: I will getmy laptop there so I will connect from time to time here :-)
2011-02-04 10:08 <marc0s> cedk: fine
2011-02-04 10:09 <cedk> marc0s: also I will wear my tryton T-shirt but it will be too cold to see it :-)
2011-02-04 10:09 -!- elbenfreund(~elbenfreu@p54B968C2.dip.t-dialin.net) has joined #tryton
2011-02-04 10:09 <marc0s> cedk: haha :D
2011-02-04 10:09 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton
2011-02-04 10:10 <marc0s> cedk: you'll have to put it over your pullover :P
2011-02-04 10:10 <Lo-lan-do> Or wave it as a flag.
2011-02-04 10:24 -!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton
2011-02-04 10:31 -!- nicoe(~nicoe@2001:6f8:3aa:0:217:f2ff:fef3:4e9) has joined #tryton
2011-02-04 10:52 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton
2011-02-04 11:10 -!- okko(~okko@62.58.29.41) has joined #tryton
2011-02-04 11:51 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton
2011-02-04 11:59 -!- paepke(~paepke@p4FEB4444.dip.t-dialin.net) has joined #tryton
2011-02-04 12:46 <cedk> predatell: I created a russian mailing list
2011-02-04 12:46 <cedk> predatell: http://groups-ru.tryton.org/
2011-02-04 12:46 <cedk> predatell: I subscribe you as manager ?
2011-02-04 12:48 <btQuark> why do i have to create a new numbersequence for every year if there are templates that offer ${year}?
2011-02-04 12:49 <cedk> btQuark: you can reuse the sequence of the previous year
2011-02-04 12:49 <cedk> btQuark: if you want
2011-02-04 12:50 <btQuark> i've tried just selecting and loading the already created sequence anyhow it (1.6) shows me an error message, that i'ld need to create a new sequence for every year
2011-02-04 12:52 -!- heg(~heg@dyn.144-85-221-238.dsl.vtx.ch) has joined #tryton
2011-02-04 12:56 <cedk> btQuark: which sequence and which error message?
2011-02-04 13:01 <btQuark> cedk its the "geschäftsjahre" mask and there the "numbersequences" tab giving me "for different business years of a company you need to create a different number sequence for buchungsfestschreibungen"
2011-02-04 13:01 <btQuark> which is bad when i want to use a year templated number
2011-02-04 13:03 <cedk> btQuark: ok so you said that you can use the same counter but with a different prefix for accounting ?
2011-02-04 13:05 <btQuark> i'ld like to use the same number-sequence as i thought that when i am able to use "${year}-${month}-" as prefix it would build me taxcorrect different continuing number every year
2011-02-04 13:06 <cedk> btQuark: don't understand
2011-02-04 13:07 <btQuark> in my last business support system i had the possibility to create one templated number sequences that would be used everywhere based on the templates
2011-02-04 13:08 <btQuark> so for outgoing bills i'ld use R${year}-${month}-number and get R2011-02-0002 for example
2011-02-04 13:08 <btQuark> or R2008-02-0999
2011-02-04 13:09 <cedk> btQuark: ok but could you have this kind of sequence:
2011-02-04 13:09 <btQuark> which i think is pretty usefull and does not require me to set up mostly duplicated sequences
2011-02-04 13:09 <cedk> 2010-12-0002; 2011-12-0003; 2010-12-0004
2011-02-04 13:09 -!- svaksha(~svaksha@unaffiliated/svaksha) has joined #tryton
2011-02-04 13:09 <cedk> for accounting
2011-02-04 13:10 <btQuark> sure, but it does not allow using such things
2011-02-04 13:10 <cedk> btQuark: as far as I know, it is not allow in many countries
2011-02-04 13:10 <btQuark> o_O
2011-02-04 13:10 <btQuark> nobody ever complained here - its what you see in quite some bills coming in
2011-02-04 13:10 -!- nicoe(~nicoe@2001:6f8:3aa:0:217:f2ff:fef3:4e9) has joined #tryton
2011-02-04 13:11 <btQuark> and even if i was just to use one strict number sequence such as Rxxxx there would be absolutely no reason to create new number sequence every year
2011-02-04 13:12 <cedk> btQuark: in many countries, numbering of invoices must follow a strict sequence per fiscal year
2011-02-04 13:12 <cedk> btQuark: so if you use the same sequence for two fiscal years you get some kind of hole like my previous example
2011-02-04 13:13 <btQuark> hm, i get that point
2011-02-04 13:17 <cedk> btQuark: stop switching name :-)
2011-02-04 13:18 <cedk> btQuark: you must know that you can still create accounting document for the previous year
2011-02-04 13:18 <cedk> btQuark: per example, now you could create an invoice with the numbering of 2010
2011-02-04 13:20 <btQuark> sorry for the noise cdk - i just needed to group some of my nicks to my account name with nickserv, and he only accepts nicks that are active :|
2011-02-04 13:20 <btQuark> cedk hm, i think it get the idea
2011-02-04 13:20 <btQuark> its a little anoying yet understandable
2011-02-04 13:23 <cedk> btQuark: if you can have this kind of series for account move, tell me we will change the code
2011-02-04 13:23 <cedk> btQuark: or we can make a module to remove the constraint
2011-02-04 13:23 <btQuark> cedk that would be a nice idea, i am currently complete in the state of user, so i am not able to do that myself
2011-02-04 13:24 <btQuark> i suppose a "clone numbersequence from x with new name" would be just as good
2011-02-04 13:24 <btQuark> in the selection window some button like "clone with a new name"
2011-02-04 13:24 <yangoon> btQuark: just dupicate the sequence
2011-02-04 13:24 <btQuark> question is: how
2011-02-04 13:25 <btQuark> i just found a "new" button that makes ne recreate it
2011-02-04 13:25 <yangoon> btQuark: look in the menu: form/duplicate
2011-02-04 13:26 <yangoon> btQuark: you can also duplicate all sequences of one year, adjust the name and you are done
2011-02-04 13:26 <btQuark> intresting. i needed to switch to admin-number sequences for that and still need to change the name by going into that
2011-02-04 13:27 <btQuark> interesting
2011-02-04 13:28 <cedk> yangoon, btQuark: I don't think because you will have strange increment
2011-02-04 13:29 <btQuark> why?
2011-02-04 13:29 <yangoon> cedk ?, I use it every day
2011-02-04 13:29 <btQuark> duplicating was possible
2011-02-04 13:30 <btQuark> i do like the consistent and nice presence of keyboard shortcuts :)
2011-02-04 13:30 <btQuark> somehow feels like the comfortable curses interface on our wawi from the 90ies - haven't found such a nice and functional one until now again
2011-02-04 13:31 <btQuark> a pity that it died from embedded code bomb
2011-02-04 13:32 <cedk> yangoon: if you duplicate a sequence, the new sequence will start at the same numbering, so if you use the first one, you could have collision
2011-02-04 13:33 <cedk> yangoon: you must reset the next number
2011-02-04 13:33 <yangoon> cedk: didn't encounter that behavior so far, but have to control
2011-02-04 13:33 <cedk> yangoon: and be sure you get a different prefix
2011-02-04 13:33 <yangoon> cedk: if it is hardcoded, yes
2011-02-04 13:34 <btQuark> thats why i'ld like to use the ${year} prefix
2011-02-04 13:36 <cedk> btQuark: it is a way to not make mistake when duplicating
2011-02-04 13:36 <cedk> btQuark: but you must have a new counter for each year
2011-02-04 13:37 <cedk> btQuark: as I guess you are not allow to have hole in the series
2011-02-04 13:37 <yangoon> cedk: you are right, next number must be reset
2011-02-04 13:37 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton
2011-02-04 13:38 <btQuark> cedk might be
2011-02-04 13:39 <btQuark> the number currently is not that big a problem, as i am just setting everything up
2011-02-04 13:39 <btQuark> anyhow i'ld argue it would be ok to just continue the number sequence with a different year prefix
2011-02-04 13:41 <cedk> btQuark: so you agree on this series: 2010-12-0002; 2011-12-0003; 2010-12-0004
2011-02-04 13:44 <btQuark> hm. ok, strike the month
2011-02-04 13:45 <btQuark> that may look strange
2011-02-04 13:45 <btQuark> i thought of something like 2010-988 2011-989
2011-02-04 13:45 <btQuark> hm.
2011-02-04 13:45 <btQuark> you may have a point there cedk
2011-02-04 13:45 <yangoon> btQuark: it is simply not correct, at least for Germany
2011-02-04 13:46 <btQuark> yangoon yup, looks strange to me now too
2011-02-04 13:48 <cedk> yangoon: so for now, the constraint has meaning for Germany
2011-02-04 13:48 <yangoon> cedk: absolutely
2011-02-04 14:10 <btQuark> now need to understand how to create my desired kontenplan for my test instance
2011-02-04 14:10 <btQuark> i'ld like to start with something way smaller than skr03 to try how tryton fills my accounts
2011-02-04 14:11 <btQuark> and what kind of magic aside from fully handdriven double accounting there is
2011-02-04 14:31 -!- chrue(~chrue@dyndsl-091-096-036-174.ewe-ip-backbone.de) has joined #tryton
2011-02-04 14:50 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-02-04 15:09 -!- paepke(~paepke@p4FEB01C9.dip0.t-ipconnect.de) has joined #tryton
2011-02-04 15:09 -!- pepeu(~manuel@201.155.193.192) has joined #tryton
2011-02-04 15:13 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has left #tryton
2011-02-04 15:14 -!- elbenfreund1(~elbenfreu@p54B968C2.dip.t-dialin.net) has joined #tryton
2011-02-04 15:17 -!- mr_amit(~amit@210.212.179.143) has joined #tryton
2011-02-04 15:22 -!- paepke(~paepke@p4FEB01C9.dip0.t-ipconnect.de) has joined #tryton
2011-02-04 15:23 -!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton
2011-02-04 15:30 -!- paepke(~paepke@p4FEB01C9.dip0.t-ipconnect.de) has left #tryton
2011-02-04 15:48 -!- kwmiebach(~ad@xdsl-87-79-62-230.netcologne.de) has joined #tryton
2011-02-04 15:49 -!- zodman(~andres-va@foresight/developer/zodman) has joined #tryton
2011-02-04 16:11 -!- elbenfreund2(~elbenfreu@p54B963F6.dip.t-dialin.net) has joined #tryton
2011-02-04 16:20 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton
2011-02-04 16:26 -!- SeyZ(~seyz@91.179.193.253) has joined #tryton
2011-02-04 16:27 <SeyZ> hi o/
2011-02-04 16:28 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has left #tryton
2011-02-04 16:47 -!- elbenfreund1(~elbenfreu@p54B956E1.dip.t-dialin.net) has joined #tryton
2011-02-04 17:07 -!- mr_amit(~amit@210.212.179.153) has joined #tryton
2011-02-04 17:19 <btQuark> hm, the accounting module is somewhat strange
2011-02-04 17:19 <btQuark> has quite some more journals than i am used to
2011-02-04 17:20 <btQuark> and editing the name of a konto by doubleklick from the konten-form and then ctrl-l to change the view does not seem to work to much better either
2011-02-04 17:20 <btQuark> plus tryton always remaximizes which is quite anoying when used in the splitscreen-mode of windows 7
2011-02-04 17:22 <btQuark> and shouldn't i normally have one main journal where all entries are, including their accounting record?
2011-02-04 17:22 <btQuark> to be able to reconstruct the single accounts from that journal any given time?
2011-02-04 17:23 <btQuark> and not one expense, earning, storage and cash journal?
2011-02-04 17:23 <btQuark> i mean i might get the cash journal as kassenbuch, but i do not quite get the separation of expense and earnings?
2011-02-04 17:44 <cedk> btQuark: so which journals do you expect to have?
2011-02-04 17:44 <btQuark> i'ld expect one main journal, maybe a cash journal, and thats about it
2011-02-04 17:44 <btQuark> as i am used to be able to reconstruct all accounts from the main journal
2011-02-04 17:44 <cedk> btQuark: I don't understand
2011-02-04 17:45 <btQuark> the main journal contains all records such as date, from account, to account(s), amount(s) and numbers
2011-02-04 17:45 <btQuark> you enter your stuff there first, and after that put into the accounts
2011-02-04 17:46 <cedk> btQuark: what is the utility of having just one journal
2011-02-04 17:48 <cedk> btQuark: better to have any
2011-02-04 17:48 <btQuark> you have one location that keeps the entire timeline of your accounting and are able to reconstruct all accounts...
2011-02-04 17:49 <btQuark> i rather dont get the point of having many...
2011-02-04 17:50 <cedk> btQuark: it is informatic, journal are paper. You can have all account move from the table account_move
2011-02-04 17:50 <cedk> btQuark: there is only one location where the account move are stored
2011-02-04 17:51 <cedk> btQuark: journal is just to show you a subset
2011-02-04 17:57 <btQuark> ah, ok.
2011-02-04 17:57 <cedk> btQuark: by the way, there is the GL report to show you everything
2011-02-04 17:58 -!- FWiesing(~franz@mail.tryton.at) has joined #tryton
2011-02-04 17:59 <btQuark> i have reports -> journal general (allgemein) there
2011-02-04 18:00 <cedk> btQuark: against which software are comparing Tryton accounting?
2011-02-04 18:02 <btQuark> one proprietary product from the dos era, cao faktura (some windows software), and zero for pure double entry accounting
2011-02-04 18:05 <btQuark> http://www.zero-buchhaltung.de/ actually one quite likable accounting-piece of software
2011-02-04 18:05 <btQuark> quite a pity that it is non multi-user capable in terms of concurrent access
2011-02-04 18:14 <udono> btQuark: BTW. Looking the screenshot of http://www.zero-buchhaltung.de/ . In tree (left) are folders called "Eingangsrechnungen", "Ausgangsrechnungen", "Bank", "Kasse". This is the same concept as journals in Tryton.
2011-02-04 18:17 <btQuark> ah, now i get the idea
2011-02-04 18:18 <btQuark> i would probably not have named it a journal as journal is linked to that accounting book used to reconstruct all operations for me
2011-02-04 18:18 <udono> btQuark: as cedk said: journal is just to show you a subset
2011-02-04 18:18 <btQuark> is there a place where i can see the entire journal?
2011-02-04 18:19 <udono> btQuark: (2011-02-04 17:57:44) cedk: btQuark: by the way, there is the GL report to show you everything
2011-02-04 18:20 <btQuark> i'll see if i find such a thing in the translation overview
2011-02-04 18:21 <udono> btQuark: When you are asking in the english channel, it is better to have the english translation in Tryton activated.
2011-02-04 18:22 <btQuark> udono is there a way to switch the language fast?
2011-02-04 18:23 <btQuark> i've got the translations tab from the system administration menu open here
2011-02-04 18:23 <udono> btQuark: http://code.google.com/p/tryton/wiki/UserFAQ#How_to_change_the_language?
2011-02-04 18:23 <btQuark> anyhow it does not match something for gl
2011-02-04 18:24 <udono> btQuark: general ledger
2011-02-04 18:25 <btQuark> ah
2011-02-04 18:26 <btQuark> seems to translate to "kontenblätter"
2011-02-04 18:29 <btQuark> and i wonder how i can output reports on the server side instead of client side
2011-02-04 18:30 <btQuark> the gl report looks nice :)
2011-02-04 18:32 <btQuark> seems like using openoffice is not the worst of all ideas - anyhow i've seen systems that were using latex and the results looked excellent. although it probably is a huge pain to design new reports
2011-02-04 18:33 <btQuark> hm, maybe "jornal allgemein" is more of the gl report
2011-02-04 18:44 <cedk> btQuark: as to de chan
2011-02-04 18:45 <cedk> btQuark: ask to de chan
2011-02-04 18:45 <btQuark> i've tried them, maybe it helps someone who will google for it, when finding the irc logs
2011-02-04 18:53 <btQuark> how much did you divert from openerp6? would it be an idea to use their documentation to understand trytons ideas?
2011-02-04 18:54 <btQuark> http://doc.openerp.com/v6.0/book/index.html#books-link
2011-02-04 18:54 <btQuark> that one actually looks rather complete
2011-02-04 19:00 <btQuark> how can i reactivate an account once it is deactivated? do i need to reinsert it from the template?
2011-02-04 19:01 <cedk> btQuark: make a search with active = False
2011-02-04 19:01 <cedk> btQuark: and then you can check the active box
2011-02-04 19:01 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton
2011-02-04 19:03 <btQuark> ah, i used detailed search and it works fine :)
2011-02-04 19:24 -!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton
2011-02-04 19:37 <plantian> Did anything ever happen with the Better Search Gui ?
2011-02-04 19:40 <cedk> plantian: bechamel is working on it
2011-02-04 19:41 <cedk> plantian: he started to integrate it in the client
2011-02-04 19:43 <plantian> He hasn't responded to the thread since December.
2011-02-04 19:43 <plantian> cedk: Has he worked on it since then ?
2011-02-04 19:52 <cedk> plantian: I think
2011-02-04 20:05 <cedk> bechamel: ping
2011-02-04 20:05 <cedk> plantian: I will see tomorow bechamel at FOSDEM, so we will talk about this
2011-02-04 20:06 <plantian> cedk: okay sounds goods
2011-02-04 20:07 <cedk> plantian: I would like to have this change for 2.0
2011-02-04 20:07 <cedk> plantian: but there is a lot of corner case to fix
2011-02-04 20:10 <cedk> by the way, I got an almost working merge of list and tree
2011-02-04 20:10 <cedk> with DnD and children creation etc.
2011-02-04 20:10 <plantian> cedk: Yeah, it would be nice. I am using what I wrote now but it has no graphical helpers and does not utilize knowledge of tryton models.
2011-02-04 20:11 <cedk> plantian: not sure to understand
2011-02-04 20:13 <cedk> plantian: are you talking about search or tree/list view?
2011-02-04 20:14 <plantian> cedk: Sorry no that was about search, I will just talk to bechamel about it eventually.
2011-02-04 20:16 <cedk> plantian: I already ask him that when he will get something testable to upload it on codereview
2011-02-04 20:21 <plantian> cedk: You mean children creation in place? That will be helpful. And drag and drop to re-order?
2011-02-04 20:21 <plantian> cedk: Like to organize locations or categories ?
2011-02-04 20:22 <cedk> plantian: yes
2011-02-04 20:23 <cedk> plantian: children creation will be with DnD or by editing the children field by switching to form
2011-02-04 20:24 <udono> cedk: I am ready to test ;-)
2011-02-04 20:27 <plantian> cedk: That sounds good. When you say you "merged" list and tree. You mean the flat lists of stuff now will use the same view as trees implementation wise whereas they do not now? I feel you mentioned this a long time ago.
2011-02-04 20:29 <cedk> plantian: yes
2011-02-04 20:29 <cedk> plantian: I will drop in the client all the folder tryton/gui/window/view_tree/
2011-02-04 20:30 <cedk> so there will be non need to define view_type on act_window
2011-02-04 20:32 -!- pepeu(~manuel@201.155.193.192) has joined #tryton
2011-02-04 20:32 <plantian> cedk: Sounds good, so it will be all under form.
2011-02-04 20:34 <cedk> plantian: except board
2011-02-04 20:34 <cedk> I will need to change also the menu
2011-02-04 20:37 <plantian> Yeah I saw board, I also have no idea what that is, but integrating tree into form makes a lot of sense. I'm assuming that is left over from pre-fork. So much stuff has been removed and cleaned up the code has gotten so much better.
2011-02-04 20:41 <cedk> plantian: indeed merging tree and list was a plan of fp (CEO of OpenERP)
2011-02-04 20:41 <cedk> I talked with him 4 years ago about that
2011-02-04 20:41 <cedk> and he said that it was the goal since the begining of TinyERP client
2011-02-04 20:41 <plantian> I think I tried to understand these the first month I started using tryton and was really confused, tree/list/board.
2011-02-04 20:42 <cedk> but it was separated at first because too difficult and they needed tree fast
2011-02-04 20:42 <plantian> cedk: Yeah, it is hard to balance business and design. Was openerp ever able to merge them ?
2011-02-04 20:42 <cedk> now I think OE will never do it because they have now the grappy groupby functionnality
2011-02-04 20:43 <plantian> crappy? or grappy?
2011-02-04 20:44 <cedk> plantian: oops crappy
2011-02-04 20:46 <plantian> Yeah it seems that they continual have too many features.
2011-02-04 20:52 -!- pheller(~pheller@c1fw231.constantcontact.com) has joined #tryton
2011-02-04 20:52 -!- lem0na(~lem0na@95.87.233.210) has joined #tryton
2011-02-04 21:01 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-02-04 21:05 -!- pheller(~pheller@c1fw231.constantcontact.com) has joined #tryton
2011-02-04 21:11 -!- nicoe(~nicoe@56.124-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton
2011-02-04 21:25 <bechamel> plantian: as cedk said I started to integrate the top-down parser in the client
2011-02-04 21:27 <bechamel> plantian: the completion works (with a little bug) and the domains are generated correctly for AND OR > < IN (ex: "State: Open, waiting" creates [('state', 'in', ['open', 'waiting'])]
2011-02-04 21:27 <plantian> bechamel: Did you see my questions/comments/suggestions on list ?
2011-02-04 21:28 <bechamel> plantian: still need work: convert value (ex: [('amount', '=', 1 )] instead [('amount', '=', "1" )], same for boolean and other non-string
2011-02-04 21:28 <bechamel> plantian: let me re-read it
2011-02-04 21:29 <plantian> You must determine record and then column type for that record's column right? How do you do that ?
2011-02-04 21:30 <plantian> bechamel: This is last update I saw -- http://codereview.appspot.com/3536042/
2011-02-04 21:31 <bechamel> plantian: not sure to understand but: the client already now the model we are working on and all the details about the fields
2011-02-04 21:32 <plantian> bechamel: Right, I guess it was hard for me to determine field type for relations, like categories.name for a record that has a many2many with Category called categories.
2011-02-04 21:32 <bechamel> plantian: yes, this is the last code i did upload
2011-02-04 21:34 <bechamel> plantian: yes, for relations I think it will be necessary to trigger an rpc to fetch extra info
2011-02-04 21:38 <plantian> bechamel: It seems there are many assumptions which are made about the text that might cause collisions. Is implicit rec_name still supported?
2011-02-04 21:39 <bechamel> plantian: about "I think this should be quoted if you want to search for the combined string or separate by commas if you want to search by each separate word. " > my goal is that the parser try his best to "guess" stuffs and if he does not the user can add extra quotes or parenthesis
2011-02-04 21:39 <bechamel> plantian: yes
2011-02-04 21:40 <bechamel> plantian: as long as there are no ":" then the query is made against rec_name
2011-02-04 21:40 <plantian> So implicit searches must occur before things such as Name: Julian Paul Assange, or else it becomes ambiguous.
2011-02-04 21:41 <bechamel> plantian: why ? "Name: julian paul assange" seems clear that we must search on the name field, no ?
2011-02-04 21:43 <plantian> What if it was Type: Stockable Hammer , I guess I would expect Hammer to search rec_name. But it must be Hammer Type: Stockable.
2011-02-04 21:44 <bechamel> plantian: no, it will search on "stockable hammer", except if hammer is a field on the current model
2011-02-04 21:46 <bechamel> plantian: actually I'm wrong, there are no problem at all if there are no other ":"
2011-02-04 21:47 <plantian> Ha it is hard to talk about search when I am not sure how search is supposed to work.
2011-02-04 21:47 <bechamel> plantian: the ambiguity appears with "Name: John Total Amount: 10"
2011-02-04 21:48 <bechamel> plantian: in this case if I search for someone who is called "John Total" (and if there is a fiedl "Total Amount") I need to add extra quotes to remove the ambuguity
2011-02-04 21:49 <plantian> Okay, yeah I don't think you understood my prior example but I think it might not come up often.
2011-02-04 21:49 <plantian> bechamel: Do you autocomplete field names?
2011-02-04 21:50 <bechamel> plantian: yes
2011-02-04 21:50 <bechamel> plantian: (I just re-read your example), in this case two solution search for "Hammer Type: Stockable"
2011-02-04 21:51 <bechamel> or "Type:Stockable (Hammer)" or Type:Stockable and Hammer
2011-02-04 21:53 <plantian> bechamel: What do you think about moving the field token to the front of the field names so that autocomplete is easier?
2011-02-04 21:53 <plantian> bechamel: okay about embedded implicit search
2011-02-04 21:54 <bechamel> plantian: you means ":type stockable" ?
2011-02-04 21:54 <plantian> Yes, because then autocomplete can mostly start as soon as : is typed.
2011-02-04 21:55 <plantian> So I can type : and then see a list of all field names.
2011-02-04 21:56 <bechamel> plantian: currently autocomple start as soon as I type the first letter, and the fields name are visible to the user, they are the columns title of the list
2011-02-04 21:57 <plantian> How do you know if it is field or more words for value of prior field ?
2011-02-04 21:59 <bechamel> plantian: I just propose completions, the user choose what he wants
2011-02-04 22:03 <udono> bechamel: plantian: I ask me if it is not more easy to separate a field name in any case. like :Name: John Total :Amount: 10
2011-02-04 22:03 <plantian> bechamel: The examples seem to end a partially typed field name with :.
2011-02-04 22:04 <udono> ... or even :Name: John :Total Amount: 10
2011-02-04 22:04 -!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton
2011-02-04 22:05 <bechamel> plantian, udono: imo it's less user-friendly
2011-02-04 22:05 <plantian> I think if fields start with : though then the autocomplete can fill field name spaces with dashes. Such as :first-name, :last-name.
2011-02-04 22:05 <plantian> There won't be need for additional terminator.
2011-02-04 22:06 <udono> plantian: correct
2011-02-04 22:06 <bechamel> plantian: it's easier to implement, but it will look awkward, especialy to non-power user
2011-02-04 22:08 <bechamel> currently it's also possible to do "last name": gates "first name": bill
2011-02-04 22:08 <plantian> bechamel: I think we can assume users are above regular google users. We might lose power and add complexity by trying to make the syntax too flexible.
2011-02-04 22:09 <plantian> bechamel: Did you see my code ? It doesn't even try autocomplete yet just parsing and making domain.
2011-02-04 22:09 <udono> bechamel: that's good. For me its equal if I use " or :
2011-02-04 22:10 <bechamel> IMO the implicit rec_name will cover 90% of the search, the next 9% will be covered by a unique field:value search, and the last 1% is left for people that know () AND and OR
2011-02-04 22:11 <bechamel> plantian: yes I saw it, but I don't like the in?, ilike?, etc
2011-02-04 22:12 <bechamel> plantian: maybe I'm wrong but it's not possible to parse "wrong but fixable" queries
2011-02-04 22:12 <plantian> It allows for additional operators to be used and extended. Although I think it might be better to move ? to front there as well so operator can be autocompleted based on field.
2011-02-04 22:12 <bechamel> plantian: like "foo and ( bar or" -> implicit )
2011-02-04 22:13 <bechamel> plantian: or 'foo "and bar or' -> implicit " at the end
2011-02-04 22:13 <bechamel> .. with pyparsing
2011-02-04 22:14 <plantian> bechamel: Yeah maybe. That is implementation problem though, I don't think it has to do with syntax.
2011-02-04 22:14 <bechamel> it's more difficult to inderstand if I do not finish my sentence:)
2011-02-04 22:16 <plantian> bechamel: I understand. I also don't quite trust it either but it allows separation of structure from actual interpretation. I think it would be much less complex.
2011-02-04 22:17 <bechamel> this is where top-down parsing is interesting because you have fine control on when a token is consumed, on the construction of the parsing tree, etc
2011-02-04 22:22 <plantian> bechamel: I am not as concerned with the implementation as the usage.
2011-02-04 23:05 -!- kwmiebach1(~ad@xdsl-87-79-167-242.netcologne.de) has joined #tryton
2011-02-04 23:23 <cedk> here is the queue patch repository for DnD tree http://www.b2ck.com/~ced/hg/hgwebdir.cgi/tryton-dnd-tree/
2011-02-04 23:49 -!- JamesPharaoh(~james@36.51.219.87.dynamic.jazztel.es) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!