| 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/!