IRC logs of #tryton for Friday, 2011-07-01

chat.freenode.net #tryton log beginning Fri Jul 1 00:00:02 CEST 2011
2011-07-01 01:01 -!- bvillasanti(~bruno@190.105.104.81) has joined #tryton
2011-07-01 01:49 -!- sisalp(~dominique@annecy.sisalp.net) has joined #tryton
2011-07-01 01:53 -!- elbenfreund1(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton
2011-07-01 02:02 -!- saxa(~sasa@189.26.255.43) has joined #tryton
2011-07-01 03:03 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-07-01 03:35 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2011-07-01 04:39 -!- alimon(~alimon@187.156.86.12) has joined #tryton
2011-07-01 05:47 -!- bvillasanti(~bruno@190.105.104.81) has left #tryton
2011-07-01 05:49 -!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has joined #tryton
2011-07-01 08:24 -!- vladimirek(~vladimire@adsl-dyn24.78-98-14.t-com.sk) has joined #tryton
2011-07-01 08:24 -!- mhi1(~mhi@pd95b104a.dip0.t-ipconnect.de) has joined #tryton
2011-07-01 08:51 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton
2011-07-01 08:59 -!- elbenfreund(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton
2011-07-01 09:01 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton
2011-07-01 09:48 -!- elbenfreund(~elbenfreu@82.113.99.32) has joined #tryton
2011-07-01 09:53 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2011-07-01 10:14 -!- yangoon(~mathiasb@p54B4FBF8.dip.t-dialin.net) has joined #tryton
2011-07-01 10:18 -!- blast_hardcheese(~blast_har@cpe-98-151-31-186.socal.res.rr.com) has joined #tryton
2011-07-01 10:34 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton
2011-07-01 10:42 -!- okko(~okko@62.58.29.41) has joined #tryton
2011-07-01 11:06 -!- paepke(~paepke@gate.paepke.net) has joined #tryton
2011-07-01 12:13 -!- elbenfreund(~elbenfreu@p54B95E1D.dip.t-dialin.net) has joined #tryton
2011-07-01 13:08 -!- Red15(~red15@unaffiliated/red15) has joined #tryton
2011-07-01 13:08 <Red15> does the search view type not exist in tryton ?
2011-07-01 13:28 -!- ciupicri(~ciupicri@81.180.234.249) has joined #tryton
2011-07-01 13:32 <bechamel> Red15: what do you call search view type ?
2011-07-01 13:32 <Red15> as in openerp, it defines the the top part of the tree view and is used for searching (also grouping but i think that is implemented in tryton)
2011-07-01 13:33 <Red15> instead of having to use select="1" or select="2" on the form view to define which fields can be searched on
2011-07-01 13:36 <bechamel> Red15: there are no grouping feature on the search view, and the select option is defined on the model not on the view
2011-07-01 13:36 <Red15> are you sure ? select on the model usually does index keys in the rdbms
2011-07-01 13:38 <cedk> bechamel: it is defined in the view
2011-07-01 13:38 <bechamel> oh yes sorry
2011-07-01 13:39 <bechamel> cedk: if I put no select on the view is the one defined on the model used as default value ?
2011-07-01 13:39 <cedk> bechamel: I don't think
2011-07-01 13:40 <cedk> anyway all of that will be removed with the new search
2011-07-01 13:40 <cedk> Red15: we don't implement group_by functionnality because it is a buggy design
2011-07-01 13:41 <cedk> Red15: we have much better way to have this kind of feature with the board communication
2011-07-01 13:41 <Red15> i think you underestimate the power this gives to non-technical managers to do rotations on their own
2011-07-01 13:43 <cedk> Red15: it doesn't work, it sum apples and oranges
2011-07-01 13:43 <bechamel> Red15: rotations ?
2011-07-01 13:43 <Red15> cedk, that is for the manager to decide
2011-07-01 13:43 <Red15> bechamel, like excel data pilot
2011-07-01 13:43 <cedk> let just see the sale form, it will sum amount of different currencies
2011-07-01 13:44 <cedk> Red15: it is not a pivot feature
2011-07-01 13:44 <cedk> Red15: it is just sum with grouping
2011-07-01 13:44 <Red15> well that's semantics
2011-07-01 13:45 <Red15> so how does tryton handle this then ?
2011-07-01 13:46 <Red15> (also btw the grouping is not the only nice functionality, the quick-access filters are also useful)
2011-07-01 13:47 <cedk> Red15: handle what?
2011-07-01 13:48 <Red15> cedk, reporting and pivot things
2011-07-01 13:48 <cedk> Red15: what do you mean by reporting?
2011-07-01 13:49 <Red15> well in-client analysis of data
2011-07-01 13:49 <cedk> Red15: and what do you mean by "pivot things"?
2011-07-01 13:49 <bechamel> Red15: when this kind of feature is needed we add and sql view and we plug a python model on top of it
2011-07-01 13:49 <bechamel> but of course it's doable by the end user
2011-07-01 13:50 <Red15> suppose i want to see all sale order grouped by partner country and per month ?
2011-07-01 13:50 <cedk> Red15: create a view for that
2011-07-01 13:50 <cedk> Red15: by the way, this doesn't work in OE
2011-07-01 13:51 <bechamel> .. and because there is an real model under the view, it's possible to define a grap or add action on the agregate records
2011-07-01 13:51 <cedk> also the query for a view can be dynamic depending of the context
2011-07-01 13:53 <Red15> cedk, does work in OE, (maybe apples + oranges, but that is user responsibility to group by currency)
2011-07-01 13:53 <Red15> cedk, context field has been added to openerp search views, which allows the user to change context on the fly
2011-07-01 13:54 <cedk> Red15: did you read the code of the group_by ?
2011-07-01 13:55 <cedk> it is a functionality just for sale. Like the "set default" we removed in the last release because in real life it doesn't work
2011-07-01 13:56 <cedk> Red15: otherwise if you want BI, just plug a BI software on the database
2011-07-01 13:58 <cedk> by the way, I never believe in end-user making queries
2011-07-01 13:59 <cedk> from my experiences, they always do mistakes: SUM wrong type, forget a grouping and just slow down the database
2011-07-01 14:04 <cedk> Red15: about your example in OE, you can not group by currency on sale because there is no currency on sale
2011-07-01 14:04 <Red15> fields.related('pricelist_id','currency_id') and voila
2011-07-01 14:05 <cedk> Red15: I don't think group_by works on function field
2011-07-01 14:05 <Red15> store=True ?
2011-07-01 14:05 <cedk> Red15: :-))))
2011-07-01 14:06 <Red15> or rather the more complex one saying that if pricelist changes the stored value should be recalculated
2011-07-01 14:06 <cedk> Red15: I was sure you will anwser this, this is the worse feature
2011-07-01 14:07 <cedk> duplicate information that is really bad DB design
2011-07-01 14:08 <Red15> but i'm not 100% sure that group_by wouldnt work on functional fields though
2011-07-01 14:08 <Red15> how would you solve this then ? always creating db views ?
2011-07-01 14:10 <cedk> Red15: there is no DB views in Tryton
2011-07-01 14:10 <cedk> Red15: we use dynamic (but controlled) queries
2011-07-01 14:11 <Red15> cant you create views with sqlalchemy etc?
2011-07-01 14:11 <cedk> Red15: you can easily create a Model that will have the same functionnality of the "group_by"
2011-07-01 14:11 <Red15> cedk, as programmer: likely
2011-07-01 14:11 <cedk> Red15: we don't create view, because it can not be migrated easily
2011-07-01 14:11 <Red15> cedk, as end-user: not-quite
2011-07-01 14:11 <Red15> ACTION starting to ponder about flat db's
2011-07-01 14:11 <cedk> Red15: and the Model can be as generic (ex: grouping on any fields, etc.)
2011-07-01 14:12 <cedk> Red15: but with this kind of Model, you can already fix the currency issue etc.
2011-07-01 14:13 <cedk> so the user can still have the possibility to select on what he will group
2011-07-01 14:14 <Red15> but how will you do the actual grouping ?
2011-07-01 14:15 <cedk> Red15: I will do it on the fly depending of what the user has selected
2011-07-01 14:15 <Red15> but visually ?
2011-07-01 14:15 <cedk> Red15: don't understand
2011-07-01 14:18 <cedk> Red15: look at http://hg2.tryton.org/modules/sale_opportunity/file/f4a0a4845ed3/opportunity.py#l425
2011-07-01 14:18 <cedk> ACTION Lunch
2011-07-01 14:44 <cedk> ACTION back
2011-07-01 15:08 <Red15> cedk, am i reading this right are you doing + on select strings ?
2011-07-01 15:08 <Red15> sql injection anyone ?
2011-07-01 15:15 <cedk> Red15: of course not
2011-07-01 15:15 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2011-07-01 15:18 -!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton
2011-07-01 15:24 -!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton
2011-07-01 16:48 -!- heg(~heg@dyn.144-85-181-142.dsl.vtx.ch) has joined #tryton
2011-07-01 17:07 -!- udono(~udono@ip-95-222-129-145.unitymediagroup.de) has joined #tryton
2011-07-01 17:22 -!- Hoy(~andres-va@fixed-203-7-69.iusacell.net) has joined #tryton
2011-07-01 17:39 -!- nicoe(~nicoe@109-93-175-161.dynamic.isp.telekom.rs) has joined #tryton
2011-07-01 17:42 -!- enlightx(~enlightx@217.202.238.206) has joined #tryton
2011-07-01 17:53 -!- chrue(~chrue@dyndsl-091-096-061-196.ewe-ip-backbone.de) has joined #tryton
2011-07-01 18:29 -!- woakas(~woakas@200.106.202.91) has joined #tryton
2011-07-01 18:41 -!- nicoe(~nicoe@cable-178-148-1-63.dynamic.sbb.rs) has joined #tryton
2011-07-01 18:41 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2011-07-01 18:45 -!- nicoe(~nicoe@cable-178-148-1-63.dynamic.sbb.rs) has joined #tryton
2011-07-01 19:05 -!- alimon(~alimon@187.156.86.12) has joined #tryton
2011-07-01 19:20 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton
2011-07-01 19:23 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton
2011-07-01 19:57 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-07-01 20:10 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton
2011-07-01 20:58 -!- enlightx(~enlightx@109.52.211.29) has joined #tryton
2011-07-01 21:10 -!- alimon(~alimon@187.156.86.12) has joined #tryton
2011-07-01 21:24 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-07-01 21:28 -!- helmor(~helmo@46.115.22.86) has joined #tryton
2011-07-01 22:19 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-07-01 22:23 -!- blast_hardcheese(~blast_har@cpe-98-151-31-186.socal.res.rr.com) has joined #tryton
2011-07-01 22:47 -!- rhubner(~rhubner@189.58.55.3.dynamic.adsl.gvt.net.br) has joined #tryton
2011-07-01 23:00 -!- ciupicri(~ciupicri@81.180.234.249) has joined #tryton
2011-07-01 23:51 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2011-07-01 23:59 -!- heg(~heg@dyn.144-85-181-142.dsl.vtx.ch) has left #tryton

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