IRC logs of #tryton for Wednesday, 2009-03-11 #tryton log beginning Wed Mar 11 00:00:01 CET 2009
-!- USER___( has joined #tryton00:08
saxaheh, what should mean Purchases in Quotation ?00:17
saxaare the quotations I get from my suppliers ?00:18
saxai suppose not00:18
saxaDraft purchases should be RFQ to supplier correct ?00:21
saxaConfirmed purchases should be what was confirmed by my supplier00:22
saxaand purchases in quotation is what ?00:22
saxathe sent RFQ's to my suppliers ?00:22
saxawhat is purchase request used for ?00:23
saxaufff, everything i need to ask :)00:24
cedksaxa: in quotation means that you are waiting the confirmation of the supplier00:24
cedksaxa: draft, it is not ask to supplier00:24
cedksaxa: purchase request are the purchase that the system generate automaticaly (based on order point, stock quantity, etc.)00:25
saxaso draft is just something i prepare ?00:25
cedksaxa: yes00:25
saxaand then wait for it to be sent to the supplier ?00:25
saxais this same in sales ?00:26
cedksaxa: yes when you send it to supplier, you put it in the state quotation00:26
saxai would probably use a different terminology for that in that case00:26
saxano problem, its important to understand what it is00:27
saxaas i will try to play a little with the program00:27
saxabut i already had a bug report, there was a traceback00:27
saxamaybe i was doing something wrong00:27
saxaduring creating the copmany00:28
saxaok, so now, I need to import some products00:28
saxato see if i can play with it.00:28
saxaprobably will do that tomorrow, as its late already00:28
saxagood, thx for now cedk00:29
CIA-10tryton: C?dric Krier <> default * 1211:d5e9cd933672 tryton/tryton/gui/window/view_form/view/list_gtk/ Use the right display_format for Datetime00:29
cedksaxa: ok, don't forget to fill an issue in roundup00:31
vengfulsquirrelcedk: Hey what is the plan for the documention ?  Does a new version only come out with a new release ?  Is there a trunk version of the documentation ?00:33
cedkvengfulsquirrel: doc is in the same repository00:34
cedkvengfulsquirrel: we will try to update it for the next release but we need help00:39
vengfulsquirrelokay there seems to be an error but I guess building them worked00:44
vengfulsquirrelYeah I'll try to contribute something but I'm still trying to figure out certain things myself.00:44
CIA-10tryton: vengfulsquirrel roundup * #854/Documenation Build Warning: [new] There is no static directory in the doc directory and building the docs gives a warning, I think we should just remove it from the build fil ...01:00
-!- tekknokrat( has left #tryton01:01
CIA-10tryton: C?dric Krier <> default * 1611:2c10088e537d trytond/trytond/backend/postgresql/ Fix logger when self.cursor.query is None01:08
CIA-10tryton: C?dric Krier <> default * 1212:5b292dfc9269 tryton/ (2 files in 2 dirs): Make graph works also with datetime01:08
-!- juanfer(n=juanfer@ has joined #tryton01:21
-!- igor__(n=igor@ has joined #tryton01:54
-!- saxa_( has joined #tryton02:18
-!- saxa( has joined #tryton02:18
-!- igor__(n=igor@ has joined #tryton03:11
-!- yangoon( has joined #tryton05:20
-!- sharkcz( has joined #tryton07:38
-!- paola( has joined #tryton08:01
-!- Gedd(n=ged@ has joined #tryton08:15
-!- racke( has joined #tryton08:32
-!- Timitos(n=Timitos@ has joined #tryton08:34
saxa_morning ppl08:46
-!- gadaga( has joined #tryton08:49
saxahi Timitos09:13
saxaok I found one small bug09:13
saxaabout the login window in tryton client09:13
Timitossaxa: hi09:14
saxaa simple fix of replaceing the spaces with the tabs solves it09:14
saxado I fill a bug report or I just tell it here ?09:14
saxamaybe mail the ML ?09:14
saxaits a oneliner :))09:14
Timitossaxa: it is better to fill an issue in the bugtracker. you also can provide a patch if you want09:15
saxaok, will prepare a patch for it.09:15
saxaand fill up a bug09:15
Timitossaxa: thx09:16
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton09:22
-!- Timitos(n=Timitos@ has joined #tryton09:25
cedkTimitos: ho suprise !!!09:27
Timitoscedk: yes09:27
cedkhe's pity, two days to prepare this subscription09:31
CIA-10tryton: casaxa roundup * #855/Login window does not return up if wrong password.: [new] Hi, I'm not sure whether this still happens in trunk. In any case I have a tryton-1.0.2 installed on my system and when I put in a wrong pas ...09:33
cedkTimitos: there was somebody who talk about that yesterdy in the "irc meeting"09:33
-!- udono( has joined #tryton09:33
Timitoscedk: i did not see. but i expected this09:34
saxaok, i see bot already advised up :)09:34
cedkTimitos: an other thing, he talk that he meet Sun to make OpenERP use of MySQL09:34
cedkTimitos: and works on Solaris09:34
saxacedk: that for sure would be a nice addon also for tryton09:35
saxamysql is well known09:35
cedksaxa: mysql is not enough transactional level for an ERP09:36
saxaoh ok09:36
saxai dont know that so much in deep09:36
saxaanyway, a nice add on for tryton would be this 20 lines of code which you said some time ago, if you remember we spoke that if its possible to have the lines imported into documents from a xls, or cvs file09:37
saxacedk: do you have an advise for me where can I look in the code for this ?09:37
cedksaxa: there is already a csv file import09:38
saxathis kind of feature is very very useful and will make life way simpler09:38
cedksaxa: but I think it doesn't work for update09:39
saxacedk: i know there is, but it does not import lines into a document like a quote or invoice09:39
saxait import lines into other things09:39
saxalike products, pricelists09:39
cedksaxa: ok, you must check import_data in modelstorage09:39
saxawhat i meant is to import lines into a document I'm preparing like a RFQ09:39
saxathis is in the client part correct ?09:40
cedksaxa: server09:40
saxaoh ok09:40
cedksaxa: an maybe you must check also win_import on the client side09:40
saxaok thx09:41
cedksaxa: the code is a little bit difficult to understand because it is recursive and variable names are not very good09:44
cedkbut it comes from OpenERP :-)09:44
saxaheh, will try it, in case will ask if i need something09:47
cedknot use relatorio :-)09:47
-!- enlightx(n=enlightx@ has joined #tryton09:53
-!- simahawk( has joined #tryton09:58
-!- simahawk( has left #tryton09:58
-!- daeda( has joined #tryton10:08
saxaheh, anybody knows how to simply explain what one2many and many2many means ?10:13
-!- Matthias_vD( has joined #tryton10:14
-!- nicoe( has joined #tryton10:24
Timitossaxa: what do you want to know exactly?10:30
saxaTimitos: what exactly this means, I would like to know what one2many does ?10:31
saxawhat is the purpose of it ?10:31
saxasame for m2m10:31
saxamaybe there is a web page explaining more about this10:32
Timitossaxa: many2many and one2many are relations of two tables. many2many is an n:m-relation and one2many is an 1:n-relation10:33
Timitossaxa: like invoice -> one2many -> invoice_lines10:34
Timitosso one invoice has many invoice_lines10:34
Timitossaxa: for one2many you always need to create a corresponding many2one in the other table10:36
gadagasaxa: an explication on openerp developer book :
saxathx Timitos ,thx gadaga10:40
saxawill try to read that and think more intensely about it :)10:41
gadagasaxa: if you have any problems you can expose them here ;)10:42
saxaactually i never understood where this is used,  but will try to read about it first10:43
saxanever looked deeply into this10:43
gadagasaxa: did you use mpd, mcd model before?10:43
-!- daedax20( has joined #tryton10:55
-!- enlightx(n=enlightx@ has joined #tryton11:33
-!- igor__(i=igor@ has joined #tryton11:37
-!- Matthias_vD( has left #tryton12:32
-!- bechamel(n=user@ has joined #tryton12:43
-!- yangoon( has left #tryton13:04
-!- yangoon( has joined #tryton13:05
CIA-10tryton: matb roundup * #856/IntegrityError: duplicate key value violates unique constraint "party_party_cod: [new] Creating new party from view project: Traceback (most recent call last): File "/trytond/protocols/", line 48, in run res = d ...13:21
-!- igor__(i=igor@ has joined #tryton13:22
-!- genios112( has joined #tryton13:22
genios112Hallo, nachdem ich Tryton nun Lauffähig habe und eine Datenbank "TestDB" angelegt habe kann ich mich nicht anmelden, habe, meines Wissens, keine Einstellungen an den Benutzerdaten vorgenommen, wie sind Benutzername und Passwort?13:23
-!- genios112( has left #tryton13:25
-!- genios112( has joined #tryton13:29
genios112wieder da13:29
cedkgenios112: most of people here talk in english13:30
yangoongenios112: für deutsche fragen bitte benutzen, hier ist der englische kanal13:30
genios112thanks, after install i cant login, username & passwort ?13:30
yangoongenios112: it is the admin passwd configured in trytond.conf13:31
yangoongenios112: normally admin/admin13:31
cedkgenios112: did you create a database?13:33
cedkgenios112: if so, you must have give the password for admin user13:33
genios112ok, i will create a new database :)13:33
-!- enlightx( has joined #tryton13:33
cedkgenios112: you can do it from the login window13:34
genios112nice, it works, thanks13:36
CIA-10tryton: C?dric Krier <> default * 286:a83dffa2e949 website/ (6 files in 5 dirs): Add german channel for issue85313:47
CIA-10tryton: ced roundup * #853/website: german channel: [resolved] Done13:47
cedkThe demo server has been down during the last hour13:55
cedkThis was an issue in the host provider13:56
cedknow everything is working13:56
CIA-10tryton: ced roundup * #855/Login window does not return up if wrong password.: [resolved] I don't understand because the current code is correct. Your patch will make sig_login call every time even if the password is correct.13:58
CIA-10tryton: ced roundup * #856/IntegrityError: duplicate key value violates unique constraint "party_party_cod: [testing] Did you change the sequence of the party code?13:59
CIA-10tryton: C?dric Krier <> default * 1612:d26731194e20 trytond/doc/ Remove html_static_path from sphinx conf for issue85414:01
CIA-10tryton: ced roundup * #854/Documenation Build Warning: [resolved] Fix with changeset d26731194e2014:01
yangooncedk: bechamel how do we proceed with licences for graphics on the website?14:15
-!- enlightx( has joined #tryton14:16
cedkyangoon: what do you mean?14:16
yangooncedk: bechamel at the moment they are copyrighted for Tryton14:16
-!- Timito1(n=Timitos@ has joined #tryton14:17
yangooncedk if someone asks, if he can use them, would be good to have some public repos for them to download14:17
cedkyangoon: all is in the website repo14:19
yangooncedk or the other way round: are the graphics in repos free available for auch use?14:19
bechamelyangoon: you talk about the svg source maybe14:19
yangooncedk bechamel genios112 wants to make something on ubuntuusers, so is he permitted to take these graphics (without asking)?14:20
cedkyangoon: as we previously said, we have the ownership of the trademark Tryton but it is to protect it14:22
cedkyangoon: so anyone can use it when it stays a fairuse and revert to the project14:23
bechamelcedk: maybe one should mention this on the website, and also put the svg source14:24
yangooncedk +114:25
yangooncedk thx so far14:25
-!- Timito2(n=Timitos@ has joined #tryton14:30
-!- simahawk( has joined #tryton14:31
-!- simahawk( has left #tryton14:31
cedkthe public page description14:53
-!- genios112( has left #tryton14:57
cedkTimito2, udono: I think you must create a profile on
Timito2cedk: done15:12
Timito2for me15:12
cedkTimito2: fill the wiki page with your id15:12
CIA-10tryton: casaxa roundup * #855/Login window does not return up if wrong password.: [chatting] Hmm, I dont understand then, maybe I'm wrong, but that return statement was already there. In that case I will prepare a new patch whi ...15:27
CIA-10tryton: ced roundup * #855/Login window does not return up if wrong password.: [resolved] Yes it was already there and in the right place just after a bad login.15:36
CIA-10tryton: mindauga roundup * #857/LINE 1: ...","subdivision","name","zip","sequence","country","delivery"...: [new] Traceback (most recent call last): File "/trytond/protocols/", line 48, in run res = dispatch(host, port, 'NetRPC', *msg) F ...15:41
CIA-10tryton: * r457 /wiki/ Add gsoc id15:45
CIA-10tryton: * r458 /wiki/ Edited wiki page through web user interface.15:45
CIA-10tryton: ced roundup * #857/Error saving party address (column "delivery"): [chatting] For a hot fix, make an --update=all15:55
-!- enlightx( has joined #tryton16:08
udonocedk: bechamel: Hi, the demoserver seems down again16:11
cedkudono: fixed16:14
cedkudono: the server was one again restarted16:14
udonocedk: :-) thanks16:14
cedkudono: I added the demo server start in the rc script16:15
cedknext time it will start alone16:15
udonocedk: that's fine16:15
-!- enlightx_(n=enlightx@ has joined #tryton16:22
-!- juanfer(n=juanfer@ has joined #tryton16:23
-!- paola( has joined #tryton16:28
CIA-10tryton: udo.spallek * r459 /wiki/ Edited wiki page through web user interface.17:38
-!- saxa( has joined #tryton17:43
CIA-10tryton: casaxa roundup * #855/Login window does not return up if wrong password.: [chatting] Strangely before was not working on my machine. After moving it back to what it was seems that works ok. Rgds Saxa18:05
-!- vengfulsquirrel( has joined #tryton18:05
saxadont know why the first time I tried the things wasnt working like it shoud.18:14
saxaACTION speaks of issue #85518:14
cedksaxa: it was perhaps not a bad password error but a network error18:35
saxacedk: on the same machine ?20:23
saxaany of you guys in here, ever tought to create a gui interface into tryton to make the design of the reports ?20:29
saxaI mean, you just select the fields, put them on the right place in the opened window with a paper in it, and the fields you want are printed in its place20:30
saxamoving a field just with the mouse, would also move it on the printed paper20:30
saxai think this would really be a good add on20:31
-!- schlaflos4all( has joined #tryton20:31
-!- simahawk( has joined #tryton21:02
-!- simahawk( has left #tryton21:02
udonocedk: bechamel told me on the cebit iirc that you had some tcp/ip V6 problems21:32
saxahow was cebit ?21:38
saxai could not be there visiting21:38
cedkudono: I don't think21:38
saxai wanted it so much21:38
Timitossaxa: we made some nice contacts and it was great to meet bechamel again.21:39
cedksaxa: for the report tools, you can see the csv extract or copy paste like what you want21:40
cedksaxa: on other cool thing could be to allow to create a custom list in the client21:41
cedksaxa: and perhaps also an interface to generate a model with a sql query21:42
saxacedk: how you mean a custom list in the client ?21:53
saxaa custom list of what ?21:53
cedksaxa: of anything21:56
cedksaxa: I mean a generic tool to create simply views for the client22:00
cedksaxa: like sum(sale.amount) by month22:00
cedksaxa: I will prefer this than writing a graphical editor (like OOo)22:01
saxaoh ok, i got it, so somebody could just arrange the stuff to print together in there ?22:05
cedksaxa: what do you mean by print22:21
cedksaxa: is it on paper or on the screen22:21
saxacedk: i tought of the following, many companies need to adapt the prints of the reports to their paper (letterhead or form for invoice and other docs), now this work is difficult to do for a normal user, who doesnt know where to look.22:54
saxaif there could be a simple way to have like a GUI tool to do that , would be nice22:55
saxaso in administration , an admin user could prepare a report of the print alone22:55
saxajust with few clicks of the mouse22:55
saxamany companies need to change fields, personalize the report in various ways22:56
saxathis kind of GUI would allow you to do that just by designing your own report22:56
saxawhithout any knowledge of python, or objects ar fields22:57
saxathat would be something what the program should translate automatically22:57
saxajust an idea22:57
saxaok, a quick question23:05
saxathe right place to create a company as a customer or supplier is to put it into23:06
saxaor companies ?23:06
saxaprobably companies correct ?23:07
saxaFile "/site-packages/trytond/osv/", line 1858, in create23:13
saxa    'VALUES (' + str(id_new) + upd1 + ')', tuple(upd2))23:13
saxa  File "/site-packages/trytond/", line 70, in execute23:13
saxa    res = self.cursor.execute(sql, params)23:13
saxaIntegrityError: null value in column "company" violates not-null constraint23:13
saxawhere do I need to put that company ?23:13
saxain Companies ?23:13
saxathis happens when I want to register a product, and I click purchesable23:14
CIA-10tryton: casaxa roundup * #858/CONTEXT: SQL statement "UPDATE ONLY "public"."company_employee" SET "company" = NULL WHERE $1 OPERATOR(pg_catalog.=) "company"": [new] Traceback (most recent call last): File "/site-packages/trytond/", line 282, in run res = method(*msg[2:]) File "/site-pack ...23:16
CIA-10tryton: casaxa roundup * #859/IntegrityError: null value in column "company" violates not-null constraint: [new] Traceback (most recent call last): File "/site-packages/trytond/", line 282, in run res = method(*msg[2:]) File "/site-pack ...23:22
saxanight ppl23:29
vengfulsquirrelI'd think party...23:36
vengfulsquirrelSorry I'm not too knowledgeable but I'd think a customer or supplier would both be a party.23:36
vengfulsquirrelsaxa: Also did you check that your user belongs to a company ?23:41
vengfulsquirrelAre function fields unsortable ?23:49

Generated by 2.11.0 by Marius Gedminas - find it at!