IRC logs of #tryton for Thursday, 2008-08-28 #tryton log beginning Thu Aug 28 00:00:01 CEST 2008
-!- b52laptop(n=b52lapto@ has joined #tryton01:37
-!- Timitos(n=Timitos@ has joined #tryton07:43
-!- Gedd(n=ged@ has joined #tryton08:02
CIA-56tryton: Timitos roundup * #288/cannot change customer packing sequence: [new] if i try to change customer packing sequence i get an error: write_xml_record xml_record_desc there is no other error logging08:40
-!- yangoon( has joined #tryton09:07
Timitosyangoon: hi09:09
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton09:13
-!- rli( has joined #tryton09:16
CIA-56tryton: ced roundup * #285/AttributeError: 'module' object has no attribute 'DefaultFactory': [resolved] Same as issue28709:21
-!- bechamel( has joined #tryton09:52
udonohi all10:13
cedkbechamel: for the issue28810:56
bechamelcedk: yes i don't know what to do, if its allowed for a user to change it or not10:57
cedkbechamel: I think you must not create the sequence in the xml but adding a configuration wizard to create the sequence10:58
bechamelcedk: oh ok10:58
cedkbechamel: like for the accounting10:58
bechamelcedk: yep10:58
cedkbechamel: I assign you the issue10:59
bechamelcedk: ok10:59
cedkbechamel: and perhaps also for default location11:01
cedkbut it is perhaps enough to allow to modify xml location11:02
bechamelcedk: it's already allowed on locations11:02
cedkbechamel: yes I know, it is me who fix it11:03
cedkand as location doesn't depend on company, I think it is enough11:04
bechamelcedk: since i have ff3 i don't see the tryton logo on the bugtracker page, is it only me or you've got the same problem ?11:04
cedkbechamel: for me everythings is ok11:07
cedkbechamel: did you clean your cache11:07
bechamelcedk: yes, but my version seems very buggy, but fast .. but buggy11:08
cedkbechamel: of course, if it downloads only the half of the page :-)11:09
cedkbechamel: don't you have add-blockers?11:13
cedkbechamel: because it can think that it is add11:14
bechamelcedk: on the other pages everything is ok, it's just on roundup11:16
cedkbechamel: I can check on lighttpd logs if there is a get request for the image from your browser11:19
cedkbechamel: just reload the page now11:20
bechamelcedk: i tried "see background image" and the result is: "echec de la connection securisée" :)11:21
-!- b52laptop(n=b52lapto@ has joined #tryton11:22
cedkbechamel: you connect with ssl11:22
cedkbechamel: if so, you must allow permanently the self-signed certificate of the server11:23
bechamelcedk: the problem was that to access i added an exception on it, but for the images the url's are, so another exception made the tricks11:25
bechamelcedk: i think other people will have the problem11:25
Timitoscedk: bechamel: you should use a valid ssl-certificate signed by a trust center on tryton website. they are not that expensive i think. then there will be no problems. firefox is very strict with self signed ssl certificates11:31
bechamelTimitos: to you have an id of the cost ?11:34
yangoonTimitos: hi, anything special at 9 clock?;)11:34
yangooncedk: what about a certificate from
Timitosbechamel: an easy certificate costs about 100 eur for 3 years11:35
yangoonthey don't cost and they are meanwhile included in ca-certificates in debian11:35
Timitosyangoon: no nothings. just wanted to say hello11:35
yangoonTimitos: ok:) but I have a question: do you proceed with the german accounting plan?11:36
Timitosyangoon: but they are not included in common webbrowsers. so the user still needs to add the certificate himself11:36
bechamelTimitos: if i go to the cacert site, firefox warn me that the certificate is self signed :)11:37
yangoonTimitos: that's, what I wanted to check, but if you did already, ok11:37
Timitosyangoon: sorry. there is not enough time these days. i will do this in the week from 6th of september11:38
yangoonTimitos: great, I don't have much time, too, but if I can be of any help, at least for testing...11:41
yangoonTimitos: because for testing tryton really, I need a "real" accounting plan11:42
cedkbechamel: I fix it, all the images of roundup are now referenced with the same domain name11:42
Timitosyangoon: you can already use the account chart udono sent to you. there will be only a few changes.11:42
yangooncedk: bechamel: I am running Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv: Gecko/2008071420 Iceweasel/3.0.1 (Debian-3.0.1-1) and don't have problems on roundup...11:42
Timitosbechamel: i am just looking for a site, but i only find a german site with the certificates i mean.11:43
cedknow, anybody who accept the certificate for will see also images11:44
cedkso no need to have a trust signed certificate11:44
Timitosbechamel: this is quite near what i used:
bechamelTimitos: i think that for a bugtracker the certificate is a bit overkill11:45
Timitosbechamel: your are perhaps right. so forget it.11:46
bechamelTimitos: maybe one day if we open a "tryton on demand" online shop ! ;)11:47
Timitosyangoon: did you already try the account chart?11:48
cedkTimitos: I'm working on account type template11:49
Timitoscedk: this is what i am waiting for ;-) great thx11:49
yangoonTimitos: no, i am currently getting the message form udono out of my spam catcher account...;)11:54
Timitosyangoon: :-D11:55
udonoACTION is the Lord of Spam11:55
udonohi all, is it possible to delete XML records via XML?11:56
udonoI want to delete record model="" id="report_invoice" and replace it by a nother one. But since the id of an record is unique I cant just overwrite it, I think.11:58
bechameludono: yes you can only overwrite, it's not possible to delete11:58
udonobechamel: but when I try to overwrite the id, then I get an unique error...11:59
cedkudono: yes it is not necessary to delete it just update all the values11:59
cedkudono: you must override it from an other module11:59
yangoonudono: Timitos: got it, thx12:12
udonoyangoon: great!12:12
Timitosyangoon: there is still some work to do.12:12
Timitosyangoon: but for testing it is enough12:12
udonobechamel, cedk: Thanks for the ideas, but it doesnt work, since the field "report_name" must be unique.12:13
bechameludono: yes to inherit xml record you must prefix the id with the name of the module from which it comes12:14
udonobechamel: great info! Thanky12:15
bechameludono: i.e: something like id="account.id_of_the_invoice_report"12:15
udonobechamel: cedk: Very great! It works... It took me one week to be able to ask the right question... Tried everything more complicated ... Now with the most easy way I get it :-) Thanks a lot.12:19
bechameludono: great12:22
bechameludono: iirc you told us that you wanted to have the both report available side by side, or am i wrong ?12:23
udonobechamel: everything changes in a desperated mind :-) I ask you everything but not this simple question...12:25
bechameludono: now you know all about reports in tryton :)12:27
udonobechamel: everything. If you want to know something about reports, you are welcome to ask me :-)12:28
udonobechamel: BTW I solved the pagewise subtotals and sums carryed over to the next page on invoicelike reports.12:29
udonobechamel: But it works just with oo3 and just with dirty tricks12:30
bechameludono: :D12:30
bechameludono: page subtotal, good work12:31
udonoI followed cedk's advice to try to solve the problem in the document only not in tryton, and it works without doing a patch to tryton...12:32
cedkudono: by the way, do you that I have change a little bit the formatLang function12:32
cedkudono: now, you can use it with currency and it put the currency on the right side12:32
cedklike: 100€ or $10012:33
udonocedk: I recognized yesterday, now I wont update Tryton for the next months12:33
cedkudono: I think we are closed to the point of no API modification12:34
udonocedk: Just a joke :-)12:35
cedkthis change was mandatory as we use locale for formatting but it is not threadsafe12:35
bechameludono: it's the destiny of module dev., try to achieve work when those damn kernel dev. are always changing how everything work :)12:36
udonocedk: This modification was on of the most important. It was very often requested in Tiny times, but never made...12:36
udonocedk: The date, time, number and currency preferences need to be customisable userside12:37
cedkudono: it is on the language and currency12:37
cedkudono: so it is global for all users12:38
cedkudono: but customizable12:38
udonobechamel:  cedk: ... so good job done!12:38
udonocedk: Its a companywide declaration?12:38
CIA-56tryton: C?dric Krier <> default * 887:5495361b77d9 trytond/trytond/ Add constraint if it doesn't exist12:39
CIA-56tryton: C?dric Krier <> default * 888:03417d011bc0 trytond/trytond/ Fix add foreign key to recreate it if on_delete have changed12:39
CIA-56tryton: C?dric Krier <> default * 889:beea7533c162 trytond/trytond/osv/ ( Add _sql_error_messages to customize error message from SQL12:39
CIA-56tryton: C?dric Krier <> default * 182:52e07926d8a1 account/ ( account.xml):12:39
CIA-56tryton: Add account type template12:39
CIA-56tryton: Add some ondelete constraint on account and type12:39
cedkudono: what do you mean?12:39
udonocedk: that the formats are declarated for the whole company or the whole system? I understand that it is equal for all users.12:40
cedkudono: for the all system12:40
cedkudono: but it must be quite easy to write a module to change this12:41
cedkudono: and let it be by company or even by users12:41
udonocedk: not the best solution (with an eye on bechamel saas) but good enough. Ok, if it could be possible by company or user via a module, than its the best solution for preferencing tryton.12:42
bechamelcedk: nothing prevent us to define new langage: french_thousands_with_dots french12:42
cedkbechamel: but you must translate all in this new language12:43
bechamelcedk: yes, bad luck12:43
cedkudono: it is by databases and not server instance12:44
cedkudono: so saas will at least by databases separated :-)12:44
udonocedk: ok, I understand.12:44
bechamelcedk: or one can imagine doing this by inheritance, ir.lang and ir.lang_format like product_template and product_product12:45
cedkbechamel: the best way is to write module that make fields become function and you use different value depending of the user or the context12:45
cedkbechamel: or just override the read/write function12:46
cedkany way, there is many solutions12:46
bechamelcedk: yes12:46
udonoApropos Language: Another idea for later could be to have for each translation a base language, where to look when there is nothing translated. So you can easyly make fr_FR based on be_FR. Or for FWiesing at_DE based on de_DE, or special terms for special business...12:50
cedkudono: I'm not sure that we will have one day fr_BE12:53
cedkudono: I don't think that the translation will be different12:53
udonoThere are differences between Germany Austria and Swiss in some terms. And I guess there may some terms in French differ from Belgique, because of different government culture.13:05
cedkudono: best way will be to copy fr_FR.csv to fr_BE.csv and fix the difference13:06
-!- ruijuan_( has joined #tryton13:07
udonocedk: yes, this is the easy way, but not save for translation updates... but its just an idea for later13:07
cedkudono: we can perhaps have a fr.csv file with the common translation for all fr_xx13:15
cedkudono: and fr_FR.csv, fr_BE.csv for specific parts13:15
udonocedk: this would be a great future solution, just a different fallback.13:17
cedkudono: simple as I like :-)13:18
udonocedk: :-)13:18
-!- b52lap(n=b52lapto@ has joined #tryton14:15
-!- CIA-56(n=CIA@ has joined #tryton15:14
udonoI have a problem with my overwritten report. The Payment term description (invoice.payment_term.description) is shown on the invoice report, when an invoice is in state open. But my overwritten invoice (its in another module) doesnt show any invoice.payment_term.description. Strange is, that the "for each='line in invoice.lines_to_pay'" are working fine in my module... I tested it a lot with new open invoices, since I recognized, that15:43
udonoAny ideas.15:43
cedkudono: can you copy/paste the report somewhere15:53
udonocedk: I pack you a module15:54
udonoAnother question: Is there a way in Tryton to automatic update account_invoice module when I uninstall my custom module?16:04
cedkudono: no and we don't have uninstall option16:04
udonocedk: Ok, than its a matter of module install description.16:05
cedkudono: I will disable the button16:18
udonocedk: I dont understand?16:22
cedkudono: there is the button in the form but it doesn't work16:23
cedkudono: so I will disable it unitl we have a good solution for uninstallation16:23
udonocedk: but in most cases uninstallation works fine...16:24
-!- CIA-55(n=CIA@ has joined #tryton16:25
yangooncedk: whats about CIA?16:25
yangooncedk: ah, logged in again, I missed a message from roundup16:25
cedkyangoon: sometimes CIA is down because of too much traffic16:28
yangooncedk: CIA is here, but nevertheless no messages from roundup16:34
cedkyangoon: sometimes, the irc client is connected but the CIA server is down16:36
cedkyangoon: so roundup can not send message to CIA16:36
yangooncedk: ok16:37
udonocedk: did you see a problem in the report? I use the same structure like the report you provided, but it doesnt work...16:39
cedkudono: did you have the table?17:05
udonotest=# select * from account_invoice_payment_termtest-# ; id |        create_date         |         write_date         | create_uid | write_uid | description | active |   name----+----------------------------+----------------------------+------------+-----------+-------------+--------+----------  1 | 2008-08-23 22:31:58.231025 | 2008-08-28 10:47:29.990895 |          1 |         1 |             | t      | 3d3%30dN17:06
cedkudono: no I mean in the report when you print it ?17:07
udonoyes, the table is there, even the payment lines, but not the payment description... this is the strange I meant...17:08
cedkudono: because I see that you remove the <if test="invoice.payment_term.description">17:08
udonocedk: yes, to see if there is anything False inside17:08
udonocedk: is there a way to find out all variables in a report and their values?17:10
udonocedk: I think of a prettyprint representation of the object...17:10
cedkudono: I don't know17:13
cedkudono: I try your report, but there is some issue17:13
cedkudono: first you use the country code of the address with testing before that there is a country on the address17:14
cedkudono: and all formatLang have not been converted to the new format17:14
cedkudono: so I can not try the report17:14
udonocedk: ok, so I must first migrate :-)17:15
udonocedk: you catch me ...17:15
cedkudono: so the only difference that I see that can be the issue for payment terms is the <if test=...>17:16
cedkudono: can you try it?17:16
udonoyou mean the same strukture like in your invoice report17:17
udono<if test="invoice.payment_term.description">17:18
cedkudono: yes17:20
udonocedk: all payment lines there, but no payment_term_description17:22
udonocedk: I found another issue, so I think its not a problem of account_invoice... If I copy my invoice over the original invoice.odt, then the field isn't shown, too. So it must be a problem in my odt report...17:25
-!- CIA-56(n=CIA@ has joined #tryton17:26
CIA-56tryton: matb roundup * #289/Error in creation of new database: [new] Updated to tip, created new database: Traceback (most recent call last): File "/usr/local/tryton/trytond/trytond/web_service/", line ...17:47
CIA-56tryton: matb roundup * #290/Error in database update: [new] Updating a rather recent database results in: Traceback (most recent call last): File "./trytond", line 29, in <module> trytond.serve ...17:48
CIA-56tryton: matb roundup * #290/Error in database update: [chatting] another database says: psycopg2.IntegrityError: insert or update on table "account_account_template" violates foreign key constraint " ...17:48
CIA-56tryton: ced roundup * #289/Error in creation of new database: I don't understand, here it works and the field "decimal_point" is well defined in ir/ Can you check that it is?17:54
-!- b52laptop(n=b52lapto@ has joined #tryton18:53
cedkI just push a new feature that allow to translate sql error that comes from a _sql_constraint19:09
cedkso for german people, you can try to update the translation with these new messages19:10
yangooncedk: german people are unable to start the client any more with current tip;)19:18
cedkyangoon: remove the tryton.pyc19:18
yangooncedk: ah, once again19:18
cedkyangoon: I don't know, but it is the last issue with the client19:19
cedkyangoon: otherwise send the traceback19:19
yangooncedk: no. running again, all perfect, perhaps I forgot to delete it in this test instance19:20
-!- CIA-57(n=CIA@ has joined #tryton19:40
-!- yangoon( has joined #tryton19:40
-!- CIA-53(n=CIA@ has joined #tryton21:53
-!- bechamel( has joined #tryton22:22

Generated by 2.11.0 by Marius Gedminas - find it at!