IRC logs of #tryton for Wednesday, 2011-11-16 #tryton log beginning Wed Nov 16 00:00:01 CET 2011
2011-11-16 00:00 -!- yangoon_rm( has left #tryton
2011-11-16 00:55 <Guest51432> hi, is it possible to work with product variants in tryton ¿?
2011-11-16 00:58 <cedk> uoiea: grasbauer is working on a module
2011-11-16 01:00 <uoiea> cedk: how could i try it ¿?
2011-11-16 01:01 <cedk> uoiea: I don't think he already has something published
2011-11-16 01:01 <cedk> uoiea: should ask him when he will be back
2011-11-16 01:02 <uoiea> ok
2011-11-16 01:02 <uoiea> thanx cedk
2011-11-16 10:24 <sisalp> hello
2011-11-16 10:25 <sisalp> I like this openerp Aeroo module :
2011-11-16 10:28 <enlightx> sisalp: did you never use it?
2011-11-16 10:29 <sisalp> do you mean we have the same on Tryton ?
2011-11-16 10:30 <sisalp> I thought we could not add a new report without a piece of code
2011-11-16 10:30 <sisalp> I just modified existing ones so far, directly editing with free-office
2011-11-16 11:03 <enlightx> sisalp: that addon is based on the tryton reporting engine
2011-11-16 11:04 <enlightx> i'm the original developer, then alistek made a lot of improvements and called it aeroo (it was report_openoffice)
2011-11-16 11:17 <sisalp> enlightx: so what is the status on tryton ?
2011-11-16 11:18 <enlightx> sisalp: have a look at the default tryton's templates
2011-11-16 11:20 <sisalp> enlightx: the demo is about adding a report from the gui
2011-11-16 11:21 <enlightx> sisalp: yes, i mean that the way you create reports with aeroo is pretty much the same as for tryton
2011-11-16 11:22 <sisalp> enlightx: My tryton server fails to start. I'll check this point when I'll bring it up. Thank you
2011-11-16 11:23 <enlightx> sisalp: ok, that's another story :)
2011-11-16 11:54 <sisalp> hi, looking for instructions about client configuration file ..
2011-11-16 11:54 <sisalp> I miss it in the code
2011-11-16 11:55 <cedk> sisalp: what do you mean?
2011-11-16 11:56 <sisalp> when I invoke tryton --help it indicates a -c CONFIG, --config=CONFIG
2011-11-16 11:57 <sisalp> I'm looking for the format of that file
2011-11-16 11:57 <cedk> sisalp: it is in the package
2011-11-16 11:58 <cedk> sisalp: oops no, look at the one you got in ~/.config/tryton/x.y/tryton.conf
2011-11-16 11:59 <cedk> sisalp: indeed, the configuration file is managed by the client GUI
2011-11-16 12:00 <cedk> sisalp: I don't think it must be edited by hand
2011-11-16 12:01 <sisalp> cedk: so you don't recommand to create the config file and start tryton on it, as I use to do ?
2011-11-16 12:02 <sisalp> cedk: my concern is about starting several tryton guis
2011-11-16 12:02 <cedk> sisalp: the purpose is to just use an other place
2011-11-16 12:03 <cedk> sisalp: it is not really an issue to run many with the same config file
2011-11-16 12:04 <sisalp> cedk: yes I can survive ;-) but can I point different servers per default if I don't set different config files ?
2011-11-16 12:05 <sisalp> cedk: and also can I run different version of tryton with adequate servers list ?
2011-11-16 12:13 <nicoe> sisalp: the connection manager stores the tryton server it knows about in (°> Nicolas Évrard
2011-11-16 12:13 <nicoe> ( ) Liège `¯
2011-11-16 12:13 <nicoe> oups
2011-11-16 12:13 <nicoe> This is the path to the file : .config/tryton/x.y/profiles.cfg
2011-11-16 12:18 <sisalp> cedk: nicoe: sounds clear, evereything seems thought out already. Will adapt my script. Thank you
2011-11-16 12:55 <zxq9> Why is this always giving me an ASCII codec error? : bgcheck_purpose = fields.Many2One('oki_base_pass.bgcheck_purpose', 'Background Check Purpose', ondelete='SET NULL')
2011-11-16 12:56 <zxq9> The client is telling me that I can't use unicode character 0xe3 (which doesn't make sense; I'm not using any Unicode at all anyway).
2011-11-16 12:56 <zxq9> The server is telling me: ERROR:sql:Wrong SQL: ALTER TABLE "oki_base_pass_oki_base_pass" ADD FOREIGN KEY ("bgcheck_purpose") REFERENCES "oki_base_pass_bgcheck_purpose" ON DELETE SET NULL
2011-11-16 12:58 <nicoe> I suppose the client is acting weird on the error message
2011-11-16 12:58 <cedk> zxq9: I guess there is a typo in foreign key or the constraint can not be applied
2011-11-16 12:58 <cedk> zxq9: and you should have strange coding error message
2011-11-16 12:59 <nicoe> check that your error message is encoded in UTF8
2011-11-16 12:59 <zxq9> This happens every time I try to add a Many2One field anywhere. Fresh databases too. I just can't add Many2One fields.
2011-11-16 13:00 <zxq9> The ASCII codec error message is what Python says if you try to use unicode, actually. I think this is a mistaken error message. The interesting one is the "wrong SQL" one, I think.
2011-11-16 13:03 <cedk> zxq9: the ASCII codec error is just a small issue when the client try to display the error message
2011-11-16 13:06 <zxq9> That makese sense. But where is the letter ã coming from, I wonder?
2011-11-16 13:08 <zxq9> Anyway, the real problem is this wrong SQL thing. I've checked this for typos -- and its not the only case of this problem.
2011-11-16 13:12 <zxq9> Ah, I think I got it.
2011-11-16 13:13 <zxq9> The table for the model that is being pointed to is not created yet on initial installation.
2011-11-16 13:14 <zxq9> If I comment out the Many2One field, do the module install, the table is created. Then if I add the Many2One table on a module update then there is no error.
2011-11-16 13:14 <zxq9> So you just can't put a Many2One reference to a module that is in a class coming later in the same source file.
2011-11-16 13:15 <zxq9> model* (not module in last sentence)
2011-11-16 13:15 <cedk> zxq9: of course you have wrong dependency tree
2011-11-16 13:15 <zxq9> No, I mean the model is a class in the same source file. Same module, same source file.
2011-11-16 13:17 <cedk> zxq9: same issue, the declaration order is important
2011-11-16 13:18 <zxq9> Does that seem a little against OOP principles?
2011-11-16 13:18 <zxq9> I certainly don't mind flipping the class declaration order, I'm used to it from C anyway, but I thought this was supposed to be one of the great benefits of smart-runtime interpreted OOP languages like Python?
2011-11-16 13:18 <zxq9> But I might be wrong. C++ is my only real OOP experience. Everything is C and Lisp.
2011-11-16 13:19 <zxq9> Everything else in my experience has been C and Lisp*
2011-11-16 13:20 <cedk> zxq9: it is not about OOP but Database
2011-11-16 13:21 <zxq9> Yes. My point is, if we're using Python, shouldn't we make the OML check table creation dependencies through all module files before placing references? Since the normal habit of a Python programmer might be to add tiny classes to the end of a source file?
2011-11-16 13:22 <zxq9> Or... document this exception.
2011-11-16 13:24 <cedk> zxq9: not possible to catch all cases
2011-11-16 13:24 <cedk> zxq9: this is not an exception and has nothing to do with Python
2011-11-16 13:25 <cedk> it is the advantage of Tryton, it is not a OOP centric framework but also a database design framework
2011-11-16 13:26 <zxq9> I understand what you are saying -- and you're right. My point is just that maybe the typical Python programmer's habit may conflict in some small cases (like this one).
2011-11-16 13:27 <zxq9> And there is no documentation that this type of error will happen.
2011-11-16 13:27 <cedk> zxq9: ok patch is welcome
2011-11-16 13:27 <zxq9> :-)
2011-11-16 13:28 <zxq9> I'll think of a way to do this, though it may slow the initial table creation down a little (because it will have to crawl the code twice).
2011-11-16 13:29 <zxq9> Ah, and the fields.Time widget!
2011-11-16 13:31 -!- Guest10062(~oscar@ has left #tryton
2011-11-16 14:07 <oxcar> Hi, Somebody how get all modules 2.2 version with hg clone in one command?
2011-11-16 14:07 <nicoe> oxcar: use the hgnested extension
2011-11-16 14:08 <oxcar> Yes, I installed but don't know how work.
2011-11-16 14:08 <oxcar> Yes, I installed but don't know how work it.
2011-11-16 14:16 <nicoe> you just enable it in your mercurial config file
2011-11-16 14:17 <nicoe> the use "hg nclone" to fetch the sources
2011-11-16 14:39 <oxcar> @nicoe: thank you very much!
2011-11-16 14:49 -!- ciupicri(~ciupicri@unaffiliated/ciupicri) has joined #tryton
2011-11-16 16:06 <zxq9> Can someone point me to a good example of a well implemented search feature in a module?
2011-11-16 16:09 <bechamel> zxq9: a search query ?
2011-11-16 16:10 <zxq9> Not a query, but an implemented advanced search option. How the fields are designed, which are indexed and which are not, how the form layout works, etc.
2011-11-16 16:11 <zxq9> I have a need to implement a few search features and haven't really found any documentation that clears this up for me yet. But I'm sure there is a good example in the code somewhere, I just don't know where.
2011-11-16 16:11 <bechamel> zxq9: all of this is handled by the framework, you cannot "see" it in a module
2011-11-16 16:11 <zxq9> Oh, I see.
2011-11-16 16:17 <sisalp> where are documented dependencies debian/ubuntu for tryton (client) ?
2011-11-16 16:17 <cedk> sisalp: in
2011-11-16 16:18 <sisalp> why is # "pygtk >= 2.6", commented ?
2011-11-16 16:20 <sisalp> only two mandatory and two optional ?
2011-11-16 16:27 <cedk> sisalp: pygtk doesn't install correctly through setuptools, you must use the package manager
2011-11-16 16:27 <cedk> sisalp: and yes only 2 deps
2011-11-16 16:28 <sisalp> cedk: I di apt-get install python-gtk2 and got version 2.22
2011-11-16 16:28 <sisalp> cedk: thank you
2011-11-16 16:29 <sisalp> other question : where are documented the log channels mentionned in tryton --help ?
2011-11-16 16:29 <cedk> sisalp: no where
2011-11-16 16:29 <sisalp> I have to debug my connection which doesn't work
2011-11-16 16:29 <cedk> sisalp: I often think we should remove it
2011-11-16 16:30 <cedk> sisalp: -v
2011-11-16 16:52 <grasbauer> someone interessed in my approach of product_variants? should i upload it to code review?
2011-11-16 16:53 <cedk> grasbauer: there was someone yesterday
2011-11-16 16:53 <cedk> grasbauer:
2011-11-16 16:54 <cedk> grasbauer: anyway, I think it is something we could have in standard if it is generic enough
2011-11-16 16:54 <grasbauer> cedk: you know my code ;)
2011-11-16 16:55 <grasbauer> cedk: bitbucket first or directly to review?
2011-11-16 16:55 <cedk> grasbauer: review is better
2011-11-16 16:55 <cedk> grasbauer: I did not read it in depth :-)
2011-11-16 16:57 <zxq9> How do I add fields to the list of fields searched in a tree view?
2011-11-16 16:58 <zxq9> I thought I saw documentation about this and how to add fields to advanced search somewhere, but can't find it now.
2011-11-16 16:58 <grasbauer> zxq9: in 2.0: select=1 or select=2
2011-11-16 16:59 <zxq9> Maybe this was it.
2011-11-16 17:00 <zxq9> How do I enable the advanced search widgets?
2011-11-16 17:00 <nicoe> which version of trytond are you using ?
2011-11-16 17:00 <zxq9> 2.2
2011-11-16 17:01 <nicoe> ok we redesigned the view and there is no more an "advanced search widget"
2011-11-16 17:01 <zxq9> I put fields select=1 and get nothing when searching for values known in those fields.
2011-11-16 17:01 <zxq9> hmmm...
2011-11-16 17:02 <zxq9> So how does advanced search work now? Or is everything "just search" with no options at all?
2011-11-16 17:02 <nicoe> just search
2011-11-16 17:02 <nicoe> but way better
2011-11-16 17:02 -!- pjstevns( has left #tryton
2011-11-16 17:03 <zxq9> I set fields to search=1 and cannot search for known values in those fields. Only the "name" field is being queried.
2011-11-16 17:04 <cedk> zxq9:
2011-11-16 17:07 <zxq9> Hmmm.. so we must teach users search syntax. This is a good idea for programmers, not the average idiot working at an auto shop using an ERP client.
2011-11-16 17:07 <zxq9> Or rather, a smart person who is smart on things other than query languages.
2011-11-16 17:07 <zxq9> But the feature works.
2011-11-16 17:07 <zxq9> So thank you.
2011-11-16 17:08 <nicoe> zxq9: we plan to add "predefined queries" to the client
2011-11-16 17:08 <nicoe> those queries could be created by integrators
2011-11-16 17:08 <bechamel> cedk: what about adding search widget imporvements in goals for 2.4 ?
2011-11-16 17:09 <cedk> zxq9: FYI: google in gmail use almost the same syntax
2011-11-16 17:09 <nicoe> bechamel: +1 on adding search queries improvements
2011-11-16 17:09 <zxq9> cedk: FYI, a *very* low % of users even know that.
2011-11-16 17:09 <cedk> bechamel: but which improvements?
2011-11-16 17:09 <bechamel> gmail-like search box
2011-11-16 17:09 <bechamel> cedk: and also bokkmrks
2011-11-16 17:10 <bechamel> *bookmarks
2011-11-16 17:10 <zxq9> I *love* advanced query syntax, personally. I am a master of duckduckgo and google. But that is something that my mother, for example, will never understand -- and she has to use an ERP system at work every day.
2011-11-16 17:10 <cedk> bechamel: I find the gmail box bloated
2011-11-16 17:10 <nicoe> cedk: +1 on the bloatitude of the gmail box
2011-11-16 17:10 <bechamel> cedk: I hardly see how to do it simpler
2011-11-16 17:11 <nicoe> it looks nice in a browser but is too much in a gtk client
2011-11-16 17:11 <zxq9> +1 on the term "bloatitude"
2011-11-16 17:11 <cedk> bechamel: bookmarks are not clear in my mind
2011-11-16 17:11 <bechamel> cedk: me neither :)
2011-11-16 17:11 <bechamel> cedk: but the bloat-box is clear
2011-11-16 17:11 <cedk> bechamel: so let's first define it before adding to the roadmap :-)
2011-11-16 17:11 <zxq9> +1
2011-11-16 17:12 <bechamel> we can add "define the bloat-box" in the roadmap :)
2011-11-16 17:12 <zxq9> Does a field name have to be visible in a tree view to be queriable?
2011-11-16 17:12 <cedk> ACTION will test search entry on my mother
2011-11-16 17:13 <cedk> zxq9: not visible but defined
2011-11-16 17:13 <zxq9> cedk: Tell her to find stuff that will require her to not just use the "name" field. You can even give her a link to the docs, but can't talk to her or coach.
2011-11-16 17:15 <zxq9> Ah, invisible... this is sort of workable. I just think that for a public so used to formal GUIs (which I hate, but is the expected standard) that things like "contains" or from X to Y should have a graphical selection/widget associated with it.
2011-11-16 17:15 <nicoe> ACTION I'll try it on my girlfriend too
2011-11-16 17:15 <zxq9> That way a user can stab at a limited list of things on their screen to explore the features out instead of stabbing at 109+ keys on their keyboard trying to discover totally silent features.
2011-11-16 17:16 <zxq9> This is a problem we have had with Gnome3 design also, by the way. So I am very wary of this now.
2011-11-16 17:17 <bechamel> zxq9: this is the idea behind the bloat-box: to allow people discover search syntax
2011-11-16 17:17 <zxq9> Ah.
2011-11-16 17:17 <zxq9> Is there a way to turn it off after you've played with it? Or does it sit there all the time, eating screen space?
2011-11-16 17:18 <zxq9> I could envision a small menu that floats when a button is pressed that would build a query for you in the search line. That could be cool.
2011-11-16 17:18 <zxq9> Actually, that could be very cool. Why didn't I think of that 10 years ago?
2011-11-16 17:19 <zxq9> Oh... I never clicked anything back then and lived entirely inside vi and bash... that's probably why...
2011-11-16 17:19 <bechamel> zxq9: just open gmail and click on the little arrow in the search input field, you will understand
2011-11-16 17:20 <zxq9> I'll have to get a gmail account first.
2011-11-16 17:20 <zxq9> But I'll give it a whirl.
2011-11-16 17:20 <nicoe> ACTION thinks that the bloatbox is bloated because he lives inside vim and zsh (some stuffs has changed)
2011-11-16 17:20 <sisalp> what means this message on the server Error: [('SSL routines', 'SSL23_GET_CLIENT_HELLO', 'http request')]
2011-11-16 17:21 <sisalp> The client cannot connect
2011-11-16 17:21 <zxq9> nicoe: I have to admit, though -- vim is bloated itself, just much more quietly.
2011-11-16 17:22 <cedk> sisalp: something wrong with SSL :-)
2011-11-16 17:23 <sisalp> cedk: ok, I'll turn ssl off on the server
2011-11-16 17:23 <nicoe> zxq9: vim is a bit bloated but it hides it very well
2011-11-16 17:26 <zxq9> Sort of like an old girlfriend of mine.
2011-11-16 17:27 <cedk> sisalp: perhaps bad certificate?
2011-11-16 17:27 <sisalp> cedk : i turned ssl off
2011-11-16 17:28 <sisalp> cedk; and get now : AttributeError: SimpleXMLRPCRequestHandler instance has no attribute 'path'
2011-11-16 17:28 <cedk> sisalp: line code?
2011-11-16 17:28 <sisalp> trytond/protocols/", line 125
2011-11-16 17:29 <cedk> sisalp: which Python version?
2011-11-16 17:30 <sisalp> Python 2.6.5
2011-11-16 17:37 <cedk> sisalp: try with the patch:
2011-11-16 18:06 <sisalp> cedk: by changing localhost by the ip address for json-rpc, I got it working
2011-11-16 18:07 <sisalp> with the patch in place : - - [16/Nov/2011 18:04:54] code 400, message Bad request syntax ('\x16\x03\x01\x00Z\x01\x00\x00V\x03\x01N\xc3\x
2011-11-16 18:15 <cedk> sisalp: is it working?
2011-11-16 18:16 <sisalp> no it's not, still connection refused on xml-rpc, now ok on jsonrpc
2011-11-16 18:18 <cedk> sisalp: how do you test xml-rpc?
2011-11-16 18:18 <sisalp> I change the port on the gtk client and wait praying
2011-11-16 18:21 <cedk> sisalp: you was not awake during my talk?
2011-11-16 18:21 <cedk> sisalp: tryton client speak only one protocol
2011-11-16 18:21 <sisalp> the server speaks both and the client speakes only jsonrpc ?
2011-11-16 18:22 <cedk> sisalp: yes
2011-11-16 18:22 <cedk> sisalp: KISS
2011-11-16 18:23 <sisalp> yes, so if we have an application on xml-rpc, we keep both ports open
2011-11-16 18:23 <cedk> sisalp: yes if you need it
2011-11-16 18:23 <sisalp> and never use xml-rpc fron the gtk client
2011-11-16 18:23 <sisalp> correct
2011-11-16 18:23 <sisalp> ?
2011-11-16 18:24 <cedk> sisalp: yes
2011-11-16 18:24 <sisalp> I could have serched for some time
2011-11-16 18:24 <cedk> sisalp: that's why you got strange error
2011-11-16 18:24 <sisalp> thank you
2011-11-16 18:24 <cedk> sisalp: you should just hear at the TUL instead of talking with nicoe
2011-11-16 18:25 <cedk> s/hear/listen/
2011-11-16 18:25 <sisalp> ;-)
2011-11-16 18:26 <sisalp> I did not view the total video yet
2011-11-16 18:26 <cedk> sisalp: I saw you at the bottom near the radiator :-)
2011-11-16 18:27 <sisalp> then I'll have a look at what was wrong with my ssl
2011-11-16 18:27 <sisalp> is there something on the video regarding ssl ,
2011-11-16 18:27 <sisalp> ?
2011-11-16 18:29 <cedk> sisalp: no
2011-11-16 18:29 <cedk> sisalp: but if you test it with xml-rpc, you had perhaps no ssl issue
2011-11-16 18:35 <cedk> sisalp: bbl

Generated by 2.17.3 by Marius Gedminas - find it at!