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

chat.freenode.net #tryton log beginning Tue Feb 16 00:00:02 CET 2016
2016-02-16 00:51 -!- udono(~udono@ip-178-202-239-109.hsi09.unitymediagroup.de) has joined #tryton
2016-02-16 01:06 -!- udono(~udono@ip-178-202-239-8.hsi09.unitymediagroup.de) has joined #tryton
2016-02-16 01:12 -!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton
2016-02-16 01:27 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-02-16 01:39 -!- juanfe(~juanfe@181.143.145.58) has joined #tryton
2016-02-16 06:50 -!- prakashpandey(~prakashpa@c-73-158-39-110.hsd1.ca.comcast.net) has joined #tryton
2016-02-16 07:40 -!- frispete_(~frispete@p54A91B91.dip0.t-ipconnect.de) has joined #tryton
2016-02-16 07:57 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2016-02-16 07:57 -!- leio(~leio@gentoo/developer/leio) has joined #tryton
2016-02-16 08:03 -!- rpit(~rpit@2a02:908:e672:9420:56ee:75ff:fe0d:d3c7) has joined #tryton
2016-02-16 08:12 -!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton
2016-02-16 08:20 -!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton
2016-02-16 08:58 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-02-16 09:06 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2016-02-16 09:13 -!- bechamel(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton
2016-02-16 09:22 -!- bechamel(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton
2016-02-16 10:14 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-02-16 10:33 -!- kstenger1(~karla@r186-50-23-53.dialup.adsl.anteldata.net.uy) has joined #tryton
2016-02-16 11:40 -!- nicoe(~nicoe@balisto.wifi.b2ck.com) has joined #tryton
2016-02-16 11:42 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2016-02-16 12:33 -!- fran_(~chatzilla@181.228.26.143) has joined #tryton
2016-02-16 13:15 -!- nelek_(~nf@62.235.65.181) has joined #tryton
2016-02-16 13:18 -!- fran_arg(b5e41a8f@gateway/web/freenode/ip.181.228.26.143) has joined #tryton
2016-02-16 13:19 <fran_arg> hello.
2016-02-16 13:19 <fran_arg> How can I drop a fk trough def __register__()
2016-02-16 13:19 <fran_arg> ?
2016-02-16 13:30 -!- fran_arg(b5e41a8f@gateway/web/freenode/ip.181.228.26.143) has left #tryton
2016-02-16 13:33 -!- csotelo(~csotelo@190.232.71.228) has joined #tryton
2016-02-16 13:35 -!- fran_arg(b5e41a8f@gateway/web/freenode/ip.181.228.26.143) has joined #tryton
2016-02-16 13:53 -!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton
2016-02-16 14:07 -!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton
2016-02-16 14:33 -!- bechamel(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton
2016-02-16 14:39 -!- bvillasanti1(~bvillasan@138.117.21.56) has joined #tryton
2016-02-16 15:04 -!- bechamel1(~Adium@host-149-154-211-53.dynamic.voo.be) has joined #tryton
2016-02-16 15:11 <dj_xatra> I'm starting my server with "cpord zdr prafd
2016-02-16 15:11 <dj_xatra> ehm
2016-02-16 15:12 <dj_xatra> I'm starting my server with "/usr/local/bin/trytond --config /usr/local/etc/tryton/trytond.conf"
2016-02-16 15:13 <dj_xatra> I've set "uri = "postgresql://..." in trytond.conf
2016-02-16 15:13 <dj_xatra> But trytond ignores that setting. It only works when I set TRYTON_DATABASE_URI
2016-02-16 15:14 <dj_xatra> How do I make it read trytond.conf?
2016-02-16 15:23 <cedk> dj_xatra: --config is the option
2016-02-16 15:28 <cedk> dj_xatra: in verbose mode, trytond tells you which configuration file it reads
2016-02-16 15:50 <pokoli> dj_xatra: does the user running tytond has permisions to access/read the config file?
2016-02-16 15:52 <dj_xatra> nm, issue with permissions. sorry for the noise.
2016-02-16 15:54 -!- abrunacci(~Alejandro@181.229.95.104) has joined #tryton
2016-02-16 15:54 <abrunacci> hello everyone
2016-02-16 15:57 <abrunacci> I'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 parameter
2016-02-16 15:58 <abrunacci> sales = Sales.search([('sale','in',sales)], group=[('shipment_method')])
2016-02-16 16:00 <cedk> abrunacci: there is no group_by
2016-02-16 16:00 <abrunacci> oh, so i have to do the filter by myself?
2016-02-16 16:01 <cedk> abrunacci: http://doc.tryton.org/3.8/trytond/doc/ref/models/models.html?#trytond.model.ModelStorage.search
2016-02-16 16:01 <cedk> abrunacci: I don't understand, what do you mean by filter? A domain is a filter
2016-02-16 16:02 <abrunacci> yes, i mean, the "group by" by myself
2016-02-16 16:02 <abrunacci> sorry
2016-02-16 16:02 <abrunacci> thanks @cedk
2016-02-16 16:02 <abrunacci> cedk **
2016-02-16 16:02 <abrunacci> (idk how this chat works jejeje)
2016-02-16 16:04 <cedk> abrunacci: how do you want to have records grouped? What does it mean?
2016-02-16 16:04 <cedk> abrunacci: in SQL you can only group if you use aggregate methods
2016-02-16 16:05 <abrunacci> in sql you can do ' Select firsName, lastName, Address from people group by firstName'
2016-02-16 16:06 <cedk> abrunacci: no you can not
2016-02-16 16:08 <cedk> abrunacci: you need an aggregate function for all columns not in "group by"
2016-02-16 16:09 <abrunacci> cedk: http://www.postgresql.org/docs/8.0/static/sql-select.html
2016-02-16 16:09 <cedk> abrunacci: any way, in Tryton for such need you must create a Model with a query_table
2016-02-16 16:09 <cedk> abrunacci: thanks but I know SQL
2016-02-16 16:10 <abrunacci> ok, I will do that
2016-02-16 16:11 <abrunacci> and i make a mistake in that query, it should be: 'Select firsName, lastName, Address from people group by firstName, lastName, Address'
2016-02-16 16:12 <cedk> abrunacci: so you want to make a search for records grouped by all the fields?
2016-02-16 16:12 <cedk> abrunacci: this will be the exact same result as without grouping because there is the id which is a primary key
2016-02-16 17:30 -!- nh2(~niklas@2a02:168:6406:0:6874:9293:350:54ca) has joined #tryton
2016-02-16 18:19 -!- rpit(~rpit@2a02:908:e672:9420:56ee:75ff:fe0d:d3c7) has joined #tryton
2016-02-16 18:52 -!- nelek(~nf@unaffiliated/nelek) has joined #tryton
2016-02-16 19:00 -!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton
2016-02-16 19:36 -!- uranus(~uranus@ool-4a5824d5.dyn.optonline.net) has joined #tryton
2016-02-16 20:33 -!- leio(~leio@gentoo/developer/leio) has joined #tryton
2016-02-16 21:15 -!- JosDzG(~Thunderbi@189.148.200.33) has joined #tryton
2016-02-16 21:22 -!- bvillasanti(~bvillasan@138.117.21.56) has joined #tryton
2016-02-16 21:22 -!- nh2(~niklas@2a02:168:6406:0:6874:9293:350:54ca) has joined #tryton
2016-02-16 21:42 -!- hectorh30(~hectorh30@190.149.223.38) has joined #tryton
2016-02-16 22:26 -!- csotelo(~csotelo@190.41.123.53) has joined #tryton
2016-02-16 22:34 -!- kstenger(~karla@r179-24-188-210.dialup.adsl.anteldata.net.uy) has joined #tryton
2016-02-16 22:36 <csotelo> dear coders, I have an issue on managing product prices, when I work with health insurance companies, since they uses a table named SEGUS
2016-02-16 22:36 <csotelo> my question is: what will be the right way on manage prices?
2016-02-16 22:36 <csotelo> thanks
2016-02-16 23:01 <aroncero> csotelo: price_list ¿?
2016-02-16 23:02 <csotelo> aroncero, what about product tenmplate?
2016-02-16 23:04 <aroncero> csotelo: will you create the same product per company? or only change the price?
2016-02-16 23:04 <csotelo> just change the price
2016-02-16 23:04 <csotelo> however, price is calculated
2016-02-16 23:04 <csotelo> let me explain
2016-02-16 23:04 <aroncero> csotelo: I think prince list is the correct way, but I don't know what you want
2016-02-16 23:05 <csotelo> I have a table anmed segus, each insurance health company has a calculus factor
2016-02-16 23:05 <csotelo> for example, La POsitivia has a factor of 3.5, FEBAN 3.85
2016-02-16 23:05 <csotelo> named*
2016-02-16 23:06 <csotelo> by another hand, each product has a universal unit
2016-02-16 23:07 <csotelo> for 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.7
2016-02-16 23:08 <csotelo> that 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 units
2016-02-16 23:09 <csotelo> however is what I am thinking, and I am looking for your opinion
2016-02-16 23:13 <aroncero> csotelo: I would create a price list per company and I apply it per customer
2016-02-16 23:13 <aroncero> csotelo: I put unit value in the product
2016-02-16 23:13 <aroncero> csotelo: and the factor in the specific price list
2016-02-16 23:15 <csotelo> ok, just oen question about the first line "I apply it per customer". what do you mean? please
2016-02-16 23:15 <csotelo> about the unit value, then could be in template, right?
2016-02-16 23:16 <csotelo> about the factor, I have created a new model named "Insurance Companies" which one is party related and here, I manage the factor
2016-02-16 23:19 <aroncero> csotelo: Wait a minute
2016-02-16 23:19 <csotelo> sure!
2016-02-16 23:24 <aroncero> Sorry, my son...
2016-02-16 23:24 <aroncero> csotelo: create a product-> price=2
2016-02-16 23:25 <aroncero> costelo: create a new price list
2016-02-16 23:25 <aroncero> csotelo: example-> la positivia
2016-02-16 23:25 <csotelo> aroncero, I am not using the price list module, do you mean use it or a module like that?
2016-02-16 23:25 <csotelo> I am reading you
2016-02-16 23:25 <aroncero> csotelo: add a new line, product and formula unit_price*7
2016-02-16 23:27 <aroncero> costelo: create another price list -> FEBAN
2016-02-16 23:27 <csotelo> right!
2016-02-16 23:27 <csotelo> thanks
2016-02-16 23:27 <aroncero> csotelo: unit_price*3.8
2016-02-16 23:31 <csotelo> wwll I understand what do you say.. but I need to read the product list module to see how it works
2016-02-16 23:33 <aroncero> csotelo: it makes that you want, changes the price with a formula
2016-02-16 23:56 <csotelo> then, my question is> install price list or build a behavior like that

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