| chat.freenode.net #tryton log beginning Fri May 28 00:00:02 CEST 2010 | ||
| 2010-05-28 03:48 -!- ikks_(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-05-28 05:18 -!- yangoon(~mathiasb@p549F70DA.dip.t-dialin.net) has joined #tryton | ||
| 2010-05-28 07:40 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-28 07:53 -!- Timitos(~timitos@88.217.184.172) has joined #tryton | ||
| 2010-05-28 08:05 -!- sharkcz(~dan@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton | ||
| 2010-05-28 08:39 -!- eLBati(~elbati@94.162.35.200) has joined #tryton | ||
| 2010-05-28 08:59 -!- paepke(~paepke@p4FEB2160.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-05-28 09:12 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-28 09:36 -!- enlightx(~enlightx@173-109.203-62.cust.bluewin.ch) has joined #tryton | ||
| 2010-05-28 09:43 -!- bechamel(~user@chimie-prtx11.scf.fundp.ac.be) has joined #tryton | ||
| 2010-05-28 11:10 -!- tekoholic(~quassel@174-29-170-88.hlrn.qwest.net) has joined #tryton | ||
| 2010-05-28 11:19 -!- tekknokrat(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-28 11:19 -!- tekknokr1t(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-28 12:48 -!- tekknokr2t(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-28 13:00 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-28 13:11 -!- enlightx(~enlightx@173-109.203-62.cust.bluewin.ch) has joined #tryton | ||
| 2010-05-28 13:21 -!- tekknokr2t(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has left #tryton | ||
| 2010-05-28 13:33 -!- tekoholic(~quassel@174-29-170-88.hlrn.qwest.net) has joined #tryton | ||
| 2010-05-28 14:13 -!- eLBati(~elbati@93.37.80.19) has joined #tryton | ||
| 2010-05-28 14:36 -!- tekknokrat(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-28 14:55 -!- mr_amit(~amit@117.254.16.171) has joined #tryton | ||
| 2010-05-28 15:22 -!- ready(~ready@tiu.ligno.com) has left #tryton | ||
| 2010-05-28 15:41 -!- ready(~ready@tiu.ligno.com) has joined #tryton | ||
| 2010-05-28 15:53 -!- eLBati(~elbati@93.37.65.200) has joined #tryton | ||
| 2010-05-28 16:49 -!- tekoholic(~quassel@174-29-170-88.hlrn.qwest.net) has joined #tryton | ||
| 2010-05-28 17:32 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-28 17:58 -!- oliver__(~oliver@port-92-196-59-19.dynamic.qsc.de) has joined #tryton | ||
| 2010-05-28 17:59 <oliver__> Hi there. Has anybody accessed the trytond using php and rpc ??? | ||
| 2010-05-28 17:59 <oliver__> I just tired the xmlrpc libary and it did not work :( | ||
| 2010-05-28 18:02 <oliver__> I get the error : No data received from server. | ||
| 2010-05-28 18:03 <oliver__> I think, the connection parameters are wron. I use : $sock = new xmlrpc_client("/", "localhost","8070"); | ||
| 2010-05-28 18:07 <oliver__> the port must be correct. I changed it and get the error : no connection. | ||
| 2010-05-28 18:13 <oliver__> OK. I found out to start xml rpc ... but still not working ... | ||
| 2010-05-28 18:20 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has left #tryton | ||
| 2010-05-28 18:26 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has joined #tryton | ||
| 2010-05-28 18:30 <oliver__> Didn't receive 200 OK from remote server. (HTTP/1.0 401 Unauthorized) ... Any body knows what is wron ??? | ||
| 2010-05-28 18:51 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-28 18:51 <oliver__> Cool. Login is working :) Now to some SQL requests ... | ||
| 2010-05-28 19:00 <oliver__> Has anybody seen an php howto to access tryton? | ||
| 2010-05-28 19:01 <cedk> oliver__: there is some example in Python http://code.google.com/p/tryton/wiki/RemoteCalls | ||
| 2010-05-28 19:01 <cedk> oliver__: you can put a link to a copy of your code, we could perhaps help you | ||
| 2010-05-28 19:05 <cedk> oliver__: it makes a while since I have wroten PHP code :-) | ||
| 2010-05-28 19:06 <oliver__> Since the code is not so long, I will paste it here, ok? ( 14 Lines ) | ||
| 2010-05-28 19:06 <oliver__> include('xmlrpc.inc'); | ||
| 2010-05-28 19:06 <oliver__> $dbname = "neu"; | ||
| 2010-05-28 19:06 <oliver__> $user = "admin"; | ||
| 2010-05-28 19:06 <oliver__> $password = "neu"; | ||
| 2010-05-28 19:06 <oliver__> $url = "localhost"; | ||
| 2010-05-28 19:06 <oliver__> $port = "8069"; | ||
| 2010-05-28 19:06 <oliver__> $sock = new xmlrpc_client("/".$dbname, $url, $port); | ||
| 2010-05-28 19:06 <oliver__> $sock->setCredentials ($user, $password); | ||
| 2010-05-28 19:06 <cedk> oliver__: use http://pastebin.com/ | ||
| 2010-05-28 19:06 <oliver__> $msg = new xmlrpcmsg('execute'); | ||
| 2010-05-28 19:06 <oliver__> $msg->addParam(new xmlrpcval($dbname, "string")); | ||
| 2010-05-28 19:06 <oliver__> $msg->addParam(new xmlrpcval($user, "string")); | ||
| 2010-05-28 19:06 <oliver__> $msg->addParam(new xmlrpcval($password, "string")); | ||
| 2010-05-28 19:06 <oliver__> $resp = $sock->send($msg); | ||
| 2010-05-28 19:06 <oliver__> $val = $resp->value(); | ||
| 2010-05-28 19:07 <oliver__> sorry | ||
| 2010-05-28 19:07 <cedk> oliver__: which version of Tryton? | ||
| 2010-05-28 19:07 <oliver__> 1.6 | ||
| 2010-05-28 19:08 <oliver__> http://pastebin.com/TK4Wa3x6 | ||
| 2010-05-28 19:08 <oliver__> :) | ||
| 2010-05-28 19:08 <oliver__> After I found out, that the URL was the Database Name, I managed to procede a bit :) | ||
| 2010-05-28 19:09 <cedk> oliver__: what are you trying to do | ||
| 2010-05-28 19:11 <cedk> oliver__: which method do you want to call? | ||
| 2010-05-28 19:11 <oliver__> Actually right now, I try to understand how I can access Information in Tryton unsing PHP. ( I know i am just in the beginning) | ||
| 2010-05-28 19:11 <cedk> oliver__: to search for parties like in example: | ||
| 2010-05-28 19:12 <oliver__> I try to understand how I can translate the Python example of the page you send me to PHP. | ||
| 2010-05-28 19:18 <cedk> oliver__: http://pastebin.com/2U6fmxw8 | ||
| 2010-05-28 19:18 <cedk> oliver__: this should work | ||
| 2010-05-28 19:21 <oliver__> Looks better. I will test it. Pls. wait a minute.... | ||
| 2010-05-28 19:24 <oliver__> Cool. It works. How did you figure out the parameters? That was my problem. | ||
| 2010-05-28 19:40 -!- chainsaw3(~63bd7293@gateway/web/freenode/x-phdvlbdenqltgvwk) has joined #tryton | ||
| 2010-05-28 19:41 <chainsaw3> hello? | ||
| 2010-05-28 19:42 <chainsaw3> can anyone help me configure tryton 1.6 with mysql instead of postgres? | ||
| 2010-05-28 19:42 <cedk> oliver__: http://doc.tryton.org/1.6/trytond/doc/ref/models/models.html#trytond.model.ModelStorage.search | ||
| 2010-05-28 19:42 <cedk> oliver__: without cursor, user | ||
| 2010-05-28 19:43 <cedk> chainsaw3: what is the issue? | ||
| 2010-05-28 19:43 <chainsaw3> tryton 1.6 works fine with postgres | ||
| 2010-05-28 19:43 <chainsaw3> unfortunately when i try mysql, the clients could not connect | ||
| 2010-05-28 19:44 <chainsaw3> i noticed on the configuration file that tryton needs to now the location of the postgres executable but there's nothing for mysql | ||
| 2010-05-28 19:45 <cedk> chainsaw3: this is only for backup | ||
| 2010-05-28 19:45 <cedk> chainsaw3: you must configure a mysql user to connect to the database | ||
| 2010-05-28 19:46 <cedk> chainsaw3: and update trytond.conf according to it | ||
| 2010-05-28 19:46 <chainsaw3> ah yes. it's already configured. i have the right port, username, password | ||
| 2010-05-28 19:46 <chainsaw3> i see. | ||
| 2010-05-28 19:47 <cedk> chainsaw3: if you create database from the gtk client, the mysql user must also have database creation right | ||
| 2010-05-28 19:48 <chainsaw3> what do you mean by "only for backup"? when i first installed tryton, the clients could not connect. i set the path for the postgres executable and the clients were able to connect. isn't that a necessity? | ||
| 2010-05-28 19:48 <chainsaw3> ah i see. i will check it out again | ||
| 2010-05-28 19:49 <chainsaw3> i even tried root, though i know it's bad practice to do so. | ||
| 2010-05-28 19:49 <cedk> chainsaw3: no trytond doesn't require postgres executable | ||
| 2010-05-28 19:49 <chainsaw3> i'll double check my settings | ||
| 2010-05-28 19:50 <chainsaw3> really? that's odd. the server is installed on ubuntu. | ||
| 2010-05-28 19:50 <chainsaw3> i kept getting could not connect messages til i've set that line. | ||
| 2010-05-28 19:51 <chainsaw3> maybe i'm doing something wrong. i'll double check my settings | ||
| 2010-05-28 19:58 <cedk> chainsaw3: I don't know but it is realy strange | ||
| 2010-05-28 19:59 <oliver__> cedk .... Tank you for the help :) nice! | ||
| 2010-05-28 19:59 <cedk> oliver__: ur welcome | ||
| 2010-05-28 20:12 <chainsaw3> im still trying to get mysql work on tryton. btw, where can i get the crm modules for tryton 1.6? | ||
| 2010-05-28 20:13 <cedk> chainsaw3: which crm module? | ||
| 2010-05-28 20:13 <chainsaw3> all crm related modules | ||
| 2010-05-28 20:14 <cedk> chainsaw3: all modules are on the website | ||
| 2010-05-28 20:18 <chainsaw3> brb 1 min | ||
| 2010-05-28 20:48 -!- chainsaw3(~63bd7293@gateway/web/freenode/x-zegdtxzlkldalioz) has joined #tryton | ||
| 2010-05-28 20:48 <chainsaw3> i dont see any crm modules listed under ver 1.6. are there other places where i can these modules? | ||
| 2010-05-28 20:49 <chainsaw3> http://code.google.com/p/tryton/wiki/CRM | ||
| 2010-05-28 20:58 -!- enlightx(~enlightx@217.202.104.168) has joined #tryton | ||
| 2010-05-28 20:59 <cedk> chainsaw3: sale_opportuny is not yet released | ||
| 2010-05-28 20:59 <chainsaw3> oh i see. is there an eta for those modules? | ||
| 2010-05-28 21:00 <cedk> chainsaw3: http://codereview.appspot.com/779041/show | ||
| 2010-05-28 21:00 <chainsaw3> sale_opportunity... is this the same as the crm modules above? | ||
| 2010-05-28 21:01 <cedk> chainsaw3: yes crm was wrong name for the page | ||
| 2010-05-28 21:01 <cedk> chainsaw3: I will change it | ||
| 2010-05-28 21:02 <chainsaw3> I see. Does that mean tryton doesn't have any Customer Relationship Management capabilities? | ||
| 2010-05-28 21:05 <cedk> chainsaw3: eta in 1 or 2 weeks | ||
| 2010-05-28 21:05 <cedk> chainsaw3: it depends of what you named CRM | ||
| 2010-05-28 21:08 <chainsaw3> my assumption is that CRM module would be used for managing a company's interactions with clients and sales prospects | ||
| 2010-05-28 21:09 <cedk> chainsaw3: that says all and nothing at the same time | ||
| 2010-05-28 21:10 <chainsaw3> are you familiar with open erp's crm modules? | ||
| 2010-05-28 21:10 <cedk> chainsaw3: you mean OpenERP ? | ||
| 2010-05-28 21:10 <chainsaw3> ah yes | ||
| 2010-05-28 21:11 <cedk> chainsaw3: yes I know it and it sucks | ||
| 2010-05-28 21:11 <cedk> chainsaw3: i can say it because I worked on his devs | ||
| 2010-05-28 21:13 <chainsaw3> would sale_opportunity be the all-encompassing replacement for OpenERP's crm modules? | ||
| 2010-05-28 21:13 <chainsaw3> i would like a functionality to track my interactions with customers and prospects | ||
| 2010-05-28 21:14 <cedk> chainsaw3: no | ||
| 2010-05-28 21:15 <cedk> chainsaw3: only management of sale opportunities | ||
| 2010-05-28 21:20 <chainsaw3> I see. In order for us to make a sale, we have to talk to a lot of people (phone, emails). It would be nice to be able to track these. | ||
| 2010-05-28 21:21 <cedk> chainsaw3: you can extend it | ||
| 2010-05-28 21:21 <chainsaw3> Anyway, thank you for clarifying that. | ||
| 2010-05-28 21:21 <chainsaw3> extend it? | ||
| 2010-05-28 21:22 <cedk> chainsaw3: take sale_opportunity and adds what is missing for you | ||
| 2010-05-28 21:23 <cedk> chainsaw3: and can even ask to have your custom module be part of Tryton if it is generic | ||
| 2010-05-28 21:26 <chainsaw3> would sale_opportunity cover current customers as well as prospects? | ||
| 2010-05-28 21:27 <cedk> chainsaw3: in Tryton we take the choice to put every customers, prospects, suppliers etc. into party | ||
| 2010-05-28 21:28 <cedk> chainsaw3: so sale opportunity could be used for customer and prospects | ||
| 2010-05-28 21:28 <cedk> chainsaw3: as soon as you had a name for the prospect | ||
| 2010-05-28 21:32 <chainsaw3> Interesting. The nomenclature for some of the fields in Tryton is quite different from the ones here in the USA. | ||
| 2010-05-28 21:32 <cedk> chainsaw3: which one? | ||
| 2010-05-28 21:33 <cedk> chainsaw3: if you have suggestion, don't hesitate to send it to mailing list | ||
| 2010-05-28 21:37 -!- tekknokrat(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-28 21:37 <chainsaw3> I'll have to collaborate with my fellow employees to come up with a comprehensive list. If I may, calling the module CRM would attract more potential users for Tryton. At least for some companies, CRM is essential in ERP systems. | ||
| 2010-05-28 21:38 <cedk> chainsaw3: for me, CRM is a name which means nothing because you can put anything in it | ||
| 2010-05-28 21:38 <cedk> chainsaw3: it is like ERP | ||
| 2010-05-28 21:38 <cedk> chainsaw3: most people use it only for marketing | ||
| 2010-05-28 21:39 <chainsaw3> I understand. I was just expressing an opinion. | ||
| 2010-05-28 21:40 <chainsaw3> http://www.sugarcrm.com/crm/ <--- It's what we're currently using. We're looking forward to testing sale_opportunity. | ||
| 2010-05-28 21:51 <chainsaw3> Btw, crm and sale opportunity is part of the nomeclature differences. Anyway, I know it's just a name. Thank you for your time. | ||
| 2010-05-28 22:20 -!- paepke(~paepke@p5B32EBCE.dip.t-dialin.net) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!