IRC logs of #tryton for Tuesday, 2016-02-16

chat.freenode.net #tryton log beginning Tue Feb 16 00:00:02 CET 2016
-!- udono(~udono@ip-178-202-239-109.hsi09.unitymediagroup.de) has joined #tryton00:51
-!- udono(~udono@ip-178-202-239-8.hsi09.unitymediagroup.de) has joined #tryton01:06
-!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton01:12
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:27
-!- juanfe(~juanfe@181.143.145.58) has joined #tryton01:39
-!- prakashpandey(~prakashpa@c-73-158-39-110.hsd1.ca.comcast.net) has joined #tryton06:50
-!- frispete_(~frispete@p54A91B91.dip0.t-ipconnect.de) has joined #tryton07:40
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton07:57
-!- leio(~leio@gentoo/developer/leio) has joined #tryton07:57
-!- rpit(~rpit@2a02:908:e672:9420:56ee:75ff:fe0d:d3c7) has joined #tryton08:03
-!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton08:12
-!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton08:20
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton08:58
-!- mrichez(~smuxi@mail.saluc.com) has joined #tryton09:06
-!- bechamel(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton09:13
-!- bechamel(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton09:22
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton10:14
-!- kstenger1(~karla@r186-50-23-53.dialup.adsl.anteldata.net.uy) has joined #tryton10:33
-!- nicoe(~nicoe@balisto.wifi.b2ck.com) has joined #tryton11:40
-!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton11:42
-!- fran_(~chatzilla@181.228.26.143) has joined #tryton12:33
-!- nelek_(~nf@62.235.65.181) has joined #tryton13:15
-!- fran_arg(b5e41a8f@gateway/web/freenode/ip.181.228.26.143) has joined #tryton13:18
fran_arghello.13:19
fran_argHow can I drop a fk trough def __register__()13:19
fran_arg?13:19
-!- fran_arg(b5e41a8f@gateway/web/freenode/ip.181.228.26.143) has left #tryton13:30
-!- csotelo(~csotelo@190.232.71.228) has joined #tryton13:33
-!- fran_arg(b5e41a8f@gateway/web/freenode/ip.181.228.26.143) has joined #tryton13:35
-!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton13:53
-!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton14:07
-!- bechamel(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton14:33
-!- bvillasanti1(~bvillasan@138.117.21.56) has joined #tryton14:39
-!- bechamel1(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton15:04
dj_xatraI'm starting my server with "cpord zdr prafd15:11
dj_xatraehm15:11
dj_xatraI'm starting my server with "/usr/local/bin/trytond --config /usr/local/etc/tryton/trytond.conf"15:12
dj_xatraI've set "uri = "postgresql://..." in trytond.conf15:13
dj_xatraBut trytond ignores that setting. It only works when I set TRYTON_DATABASE_URI15:13
dj_xatraHow do I make it read trytond.conf?15:14
cedkdj_xatra: --config is the option15:23
cedkdj_xatra: in verbose mode, trytond tells you which configuration file it reads15:28
pokolidj_xatra: does the user running tytond has permisions to access/read the config file?15:50
dj_xatranm, issue with permissions. sorry for the noise.15:52
-!- abrunacci(~Alejandro@181.229.95.104) has joined #tryton15:54
abrunaccihello everyone15:54
abrunacciI'm getting some troubles with flask-tryton when i want to send parameters to search... For example, if i want to send an order parameter, it works fine, but i can't send a group_by parameter15:57
abrunaccisales = Sales.search([('sale','in',sales)], group=[('shipment_method')])15:58
cedkabrunacci: there is no group_by16:00
abrunaccioh, so i have to do the filter by myself?16:00
cedkabrunacci: http://doc.tryton.org/3.8/trytond/doc/ref/models/models.html?#trytond.model.ModelStorage.search16:01
cedkabrunacci: I don't understand, what do you mean by filter? A domain is a filter16:01
abrunacciyes, i mean, the "group by" by myself16:02
abrunaccisorry16:02
abrunaccithanks @cedk16:02
abrunaccicedk **16:02
abrunacci(idk how this chat works jejeje)16:02
cedkabrunacci: how do you want to have records grouped? What does it mean?16:04
cedkabrunacci: in SQL you can only group if you use aggregate methods16:04
abrunacciin sql you can do ' Select firsName, lastName, Address from people group by firstName'16:05
cedkabrunacci: no you can not16:06
cedkabrunacci: you need an aggregate function for all columns not in "group by"16:08
abrunaccicedk: http://www.postgresql.org/docs/8.0/static/sql-select.html16:09
cedkabrunacci: any way, in Tryton for such need you must create a Model with a query_table16:09
cedkabrunacci: thanks but I know SQL16:09
abrunacciok, I will do that16:10
abrunacciand i make a mistake in that query, it should be: 'Select firsName, lastName, Address from people group by firstName, lastName, Address'16:11
cedkabrunacci: so you want to make a search for records grouped by all the fields?16:12
cedkabrunacci: this will be the exact same result as without grouping because there is the id which is a primary key16:12
-!- nh2(~niklas@2a02:168:6406:0:6874:9293:350:54ca) has joined #tryton17:30
-!- rpit(~rpit@2a02:908:e672:9420:56ee:75ff:fe0d:d3c7) has joined #tryton18:19
-!- nelek(~nf@unaffiliated/nelek) has joined #tryton18:52
-!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton19:00
-!- uranus(~uranus@ool-4a5824d5.dyn.optonline.net) has joined #tryton19:36
-!- leio(~leio@gentoo/developer/leio) has joined #tryton20:33
-!- JosDzG(~Thunderbi@189.148.200.33) has joined #tryton21:15
-!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton21:22
-!- nh2(~niklas@2a02:168:6406:0:6874:9293:350:54ca) has joined #tryton21:22
-!- hectorh30(~hectorh30@190.149.223.38) has joined #tryton21:42
-!- csotelo(~csotelo@190.41.123.53) has joined #tryton22:26
-!- kstenger(~karla@r179-24-188-210.dialup.adsl.anteldata.net.uy) has joined #tryton22:34
csotelodear coders, I have an issue on managing product prices, when I work with health insurance companies, since they uses a table named SEGUS22:36
csotelomy question is: what will be the right way on manage prices?22:36
csotelothanks22:36
aroncerocsotelo: price_list ¿?23:01
csoteloaroncero, what about product tenmplate?23:02
aroncerocsotelo: will you create the same product per company? or only change the price?23:04
csotelojust change the price23:04
csotelohowever, price is calculated23:04
csotelolet me explain23:04
aroncerocsotelo: I think prince list is the correct way, but I don't know what you want23:04
csoteloI have a table anmed segus, each insurance health company has a calculus factor23:05
csotelofor example, La POsitivia has a factor of 3.5, FEBAN 3.8523:05
csotelonamed*23:05
csoteloby another hand, each product has a universal unit23:06
csotelofor exmaple product A has a unit valu of 2, then, the price of product A for La Positiva will be 7.0 and FEBAN 7.723:07
csotelothat is the reason on thinking on template, since the unit value will be the same for all companies, but the factor is one for each company, the the price will be a calculous of the factor and the units23:08
csotelohowever is what I am thinking, and I am looking for your opinion23:09
aroncerocsotelo: I would create a price list per company and I apply it per customer23:13
aroncerocsotelo: I put unit value in the product23:13
aroncerocsotelo: and the factor in the specific price list23:13
csotelook, just oen question about the first line "I apply it per customer". what do you mean? please23:15
csoteloabout the unit value, then could be in template, right?23:15
csoteloabout the factor, I have created a new model named "Insurance Companies" which one is party related  and here, I manage the factor23:16
aroncerocsotelo: Wait a minute23:19
csotelosure!23:19
aronceroSorry, my son...23:24
aroncerocsotelo: create a product-> price=223:24
aroncerocostelo: create a new price list23:25
aroncerocsotelo: example-> la positivia23:25
csoteloaroncero, I am not using the price list module, do you mean use it or a module like that?23:25
csoteloI am reading you23:25
aroncerocsotelo: add a new line, product and formula unit_price*723:25
aroncerocostelo: create another price list -> FEBAN23:27
csoteloright!23:27
csotelothanks23:27
aroncerocsotelo: unit_price*3.823:27
csotelowwll I understand what do you say.. but I need to read the product list module to see how it works23:31
aroncerocsotelo: it makes that you want, changes the price with a formula23:33
csotelothen, my question is> install price list or build a behavior like that23:56

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!