IRC logs of #tryton for Thursday, 2008-08-28 #tryton log beginning Thu Aug 28 00:00:01 CEST 2008
2008-08-28 01:37 -!- b52laptop(n=b52lapto@ has joined #tryton
2008-08-28 07:43 -!- Timitos(n=Timitos@ has joined #tryton
2008-08-28 08:02 -!- Gedd(n=ged@ has joined #tryton
2008-08-28 08:40 <CIA-56> tryton: 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 logging
2008-08-28 09:07 -!- yangoon( has joined #tryton
2008-08-28 09:09 <Timitos> yangoon: hi
2008-08-28 09:13 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton
2008-08-28 09:16 -!- rli( has joined #tryton
2008-08-28 09:21 <CIA-56> tryton: ced roundup * #285/AttributeError: 'module' object has no attribute 'DefaultFactory': [resolved] Same as issue287
2008-08-28 09:52 -!- bechamel( has joined #tryton
2008-08-28 10:13 <udono> hi all
2008-08-28 10:56 <cedk> bechamel: for the issue288
2008-08-28 10:57 <bechamel> cedk: yes i don't know what to do, if its allowed for a user to change it or not
2008-08-28 10:58 <cedk> bechamel: I think you must not create the sequence in the xml but adding a configuration wizard to create the sequence
2008-08-28 10:58 <bechamel> cedk: oh ok
2008-08-28 10:58 <cedk> bechamel: like for the accounting
2008-08-28 10:58 <bechamel> cedk: yep
2008-08-28 10:59 <cedk> bechamel: I assign you the issue
2008-08-28 10:59 <bechamel> cedk: ok
2008-08-28 11:01 <cedk> bechamel: and perhaps also for default location
2008-08-28 11:02 <cedk> but it is perhaps enough to allow to modify xml location
2008-08-28 11:02 <bechamel> cedk: it's already allowed on locations
2008-08-28 11:03 <cedk> bechamel: yes I know, it is me who fix it
2008-08-28 11:03 <cedk> :-)
2008-08-28 11:04 <cedk> and as location doesn't depend on company, I think it is enough
2008-08-28 11:04 <bechamel> cedk: 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 ?
2008-08-28 11:07 <cedk> bechamel: for me everythings is ok
2008-08-28 11:07 <cedk> bechamel: did you clean your cache
2008-08-28 11:08 <bechamel> cedk: yes, but my version seems very buggy, but fast .. but buggy
2008-08-28 11:09 <cedk> bechamel: of course, if it downloads only the half of the page :-)
2008-08-28 11:13 <cedk> bechamel: don't you have add-blockers?
2008-08-28 11:14 <cedk> bechamel: because it can think that it is add
2008-08-28 11:16 <bechamel> cedk: on the other pages everything is ok, it's just on roundup
2008-08-28 11:19 <cedk> bechamel: I can check on lighttpd logs if there is a get request for the image from your browser
2008-08-28 11:20 <cedk> bechamel: just reload the page now
2008-08-28 11:21 <bechamel> cedk: i tried "see background image" and the result is: "echec de la connection securisée" :)
2008-08-28 11:22 -!- b52laptop(n=b52lapto@ has joined #tryton
2008-08-28 11:22 <cedk> bechamel: you connect with ssl
2008-08-28 11:23 <cedk> bechamel: if so, you must allow permanently the self-signed certificate of the server
2008-08-28 11:25 <bechamel> cedk: 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 tricks
2008-08-28 11:25 <bechamel> cedk: i think other people will have the problem
2008-08-28 11:31 <Timitos> cedk: 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 certificates
2008-08-28 11:34 <bechamel> Timitos: to you have an id of the cost ?
2008-08-28 11:34 <yangoon> Timitos: hi, anything special at 9 clock?;)
2008-08-28 11:35 <yangoon> cedk: what about a certificate from
2008-08-28 11:35 <Timitos> bechamel: an easy certificate costs about 100 eur for 3 years
2008-08-28 11:35 <yangoon> they don't cost and they are meanwhile included in ca-certificates in debian
2008-08-28 11:35 <Timitos> yangoon: no nothings. just wanted to say hello
2008-08-28 11:36 <yangoon> Timitos: ok:) but I have a question: do you proceed with the german accounting plan?
2008-08-28 11:36 <Timitos> yangoon: but they are not included in common webbrowsers. so the user still needs to add the certificate himself
2008-08-28 11:37 <bechamel> Timitos: if i go to the cacert site, firefox warn me that the certificate is self signed :)
2008-08-28 11:37 <yangoon> Timitos: that's, what I wanted to check, but if you did already, ok
2008-08-28 11:38 <Timitos> yangoon: sorry. there is not enough time these days. i will do this in the week from 6th of september
2008-08-28 11:41 <yangoon> Timitos: great, I don't have much time, too, but if I can be of any help, at least for testing...
2008-08-28 11:42 <yangoon> Timitos: because for testing tryton really, I need a "real" accounting plan
2008-08-28 11:42 <cedk> bechamel: I fix it, all the images of roundup are now referenced with the same domain name
2008-08-28 11:42 <Timitos> yangoon: you can already use the account chart udono sent to you. there will be only a few changes.
2008-08-28 11:42 <yangoon> cedk: 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...
2008-08-28 11:43 <Timitos> bechamel: i am just looking for a site, but i only find a german site with the certificates i mean.
2008-08-28 11:44 <cedk> now, anybody who accept the certificate for will see also images
2008-08-28 11:44 <cedk> so no need to have a trust signed certificate
2008-08-28 11:45 <Timitos> bechamel: this is quite near what i used:
2008-08-28 11:45 <bechamel> Timitos: i think that for a bugtracker the certificate is a bit overkill
2008-08-28 11:46 <Timitos> bechamel: your are perhaps right. so forget it.
2008-08-28 11:47 <bechamel> Timitos: maybe one day if we open a "tryton on demand" online shop ! ;)
2008-08-28 11:47 <Timitos> :-)
2008-08-28 11:48 <Timitos> yangoon: did you already try the account chart?
2008-08-28 11:49 <cedk> Timitos: I'm working on account type template
2008-08-28 11:49 <Timitos> cedk: this is what i am waiting for ;-) great thx
2008-08-28 11:54 <yangoon> Timitos: no, i am currently getting the message form udono out of my spam catcher account...;)
2008-08-28 11:55 <Timitos> yangoon: :-D
2008-08-28 11:55 <udono> ACTION is the Lord of Spam
2008-08-28 11:56 <udono> hi all, is it possible to delete XML records via XML?
2008-08-28 11:58 <udono> I 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.
2008-08-28 11:58 <bechamel> udono: yes you can only overwrite, it's not possible to delete
2008-08-28 11:59 <udono> bechamel: but when I try to overwrite the id, then I get an unique error...
2008-08-28 11:59 <cedk> udono: yes it is not necessary to delete it just update all the values
2008-08-28 11:59 <cedk> udono: you must override it from an other module
2008-08-28 12:12 <yangoon> udono: Timitos: got it, thx
2008-08-28 12:12 <udono> yangoon: great!
2008-08-28 12:12 <Timitos> yangoon: there is still some work to do.
2008-08-28 12:12 <Timitos> yangoon: but for testing it is enough
2008-08-28 12:13 <udono> bechamel, cedk: Thanks for the ideas, but it doesnt work, since the field "report_name" must be unique.
2008-08-28 12:14 <bechamel> udono: yes to inherit xml record you must prefix the id with the name of the module from which it comes
2008-08-28 12:15 <udono> bechamel: great info! Thanky
2008-08-28 12:15 <bechamel> udono: i.e: something like id="account.id_of_the_invoice_report"
2008-08-28 12:19 <udono> bechamel: 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.
2008-08-28 12:22 <bechamel> udono: great
2008-08-28 12:23 <bechamel> udono: iirc you told us that you wanted to have the both report available side by side, or am i wrong ?
2008-08-28 12:25 <udono> bechamel: everything changes in a desperated mind :-) I ask you everything but not this simple question...
2008-08-28 12:27 <bechamel> udono: now you know all about reports in tryton :)
2008-08-28 12:28 <udono> bechamel: everything. If you want to know something about reports, you are welcome to ask me :-)
2008-08-28 12:29 <udono> bechamel: BTW I solved the pagewise subtotals and sums carryed over to the next page on invoicelike reports.
2008-08-28 12:30 <udono> bechamel: But it works just with oo3 and just with dirty tricks
2008-08-28 12:30 <bechamel> udono: :D
2008-08-28 12:31 <bechamel> udono: page subtotal, good work
2008-08-28 12:32 <udono> I 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...
2008-08-28 12:32 <cedk> udono: by the way, do you that I have change a little bit the formatLang function
2008-08-28 12:32 <cedk> udono: now, you can use it with currency and it put the currency on the right side
2008-08-28 12:33 <cedk> like: 100€ or $100
2008-08-28 12:33 <udono> cedk: I recognized yesterday, now I wont update Tryton for the next months
2008-08-28 12:34 <cedk> udono: I think we are closed to the point of no API modification
2008-08-28 12:35 <udono> cedk: Just a joke :-)
2008-08-28 12:35 <cedk> this change was mandatory as we use locale for formatting but it is not threadsafe
2008-08-28 12:36 <bechamel> udono: it's the destiny of module dev., try to achieve work when those damn kernel dev. are always changing how everything work :)
2008-08-28 12:36 <udono> cedk: This modification was on of the most important. It was very often requested in Tiny times, but never made...
2008-08-28 12:37 <udono> cedk: The date, time, number and currency preferences need to be customisable userside
2008-08-28 12:37 <cedk> udono: it is on the language and currency
2008-08-28 12:38 <cedk> udono: so it is global for all users
2008-08-28 12:38 <cedk> udono: but customizable
2008-08-28 12:38 <udono> bechamel: cedk: ... so good job done!
2008-08-28 12:38 <udono> cedk: Its a companywide declaration?
2008-08-28 12:39 <CIA-56> tryton: C?dric Krier <> default * 887:5495361b77d9 trytond/trytond/ Add constraint if it doesn't exist
2008-08-28 12:39 <CIA-56> tryton: C?dric Krier <> default * 888:03417d011bc0 trytond/trytond/ Fix add foreign key to recreate it if on_delete have changed
2008-08-28 12:39 <CIA-56> tryton: C?dric Krier <> default * 889:beea7533c162 trytond/trytond/osv/ ( Add _sql_error_messages to customize error message from SQL
2008-08-28 12:39 <CIA-56> tryton: C?dric Krier <> default * 182:52e07926d8a1 account/ ( account.xml):
2008-08-28 12:39 <CIA-56> tryton: Add account type template
2008-08-28 12:39 <CIA-56> tryton: Add some ondelete constraint on account and type
2008-08-28 12:39 <cedk> udono: what do you mean?
2008-08-28 12:40 <udono> cedk: that the formats are declarated for the whole company or the whole system? I understand that it is equal for all users.
2008-08-28 12:40 <cedk> udono: for the all system
2008-08-28 12:41 <cedk> udono: but it must be quite easy to write a module to change this
2008-08-28 12:41 <cedk> udono: and let it be by company or even by users
2008-08-28 12:42 <udono> cedk: 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.
2008-08-28 12:42 <bechamel> cedk: nothing prevent us to define new langage: french_thousands_with_dots french
2008-08-28 12:43 <cedk> bechamel: but you must translate all in this new language
2008-08-28 12:43 <bechamel> cedk: yes, bad luck
2008-08-28 12:44 <cedk> udono: it is by databases and not server instance
2008-08-28 12:44 <cedk> udono: so saas will at least by databases separated :-)
2008-08-28 12:44 <udono> cedk: ok, I understand.
2008-08-28 12:45 <bechamel> cedk: or one can imagine doing this by inheritance, ir.lang and ir.lang_format like product_template and product_product
2008-08-28 12:45 <cedk> bechamel: the best way is to write module that make fields become function and you use different value depending of the user or the context
2008-08-28 12:46 <cedk> bechamel: or just override the read/write function
2008-08-28 12:46 <cedk> any way, there is many solutions
2008-08-28 12:46 <bechamel> cedk: yes
2008-08-28 12:50 <udono> Apropos 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...
2008-08-28 12:53 <cedk> udono: I'm not sure that we will have one day fr_BE
2008-08-28 12:53 <cedk> udono: I don't think that the translation will be different
2008-08-28 13:05 <udono> There 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.
2008-08-28 13:06 <cedk> udono: best way will be to copy fr_FR.csv to fr_BE.csv and fix the difference
2008-08-28 13:07 -!- ruijuan_( has joined #tryton
2008-08-28 13:07 <udono> cedk: yes, this is the easy way, but not save for translation updates... but its just an idea for later
2008-08-28 13:15 <cedk> udono: we can perhaps have a fr.csv file with the common translation for all fr_xx
2008-08-28 13:15 <cedk> udono: and fr_FR.csv, fr_BE.csv for specific parts
2008-08-28 13:17 <udono> cedk: this would be a great future solution, just a different fallback.
2008-08-28 13:18 <cedk> udono: simple as I like :-)
2008-08-28 13:18 <udono> cedk: :-)
2008-08-28 14:15 -!- b52lap(n=b52lapto@ has joined #tryton
2008-08-28 15:14 -!- CIA-56(n=CIA@ has joined #tryton
2008-08-28 15:43 <udono> I 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, that
2008-08-28 15:43 <udono> Any ideas.
2008-08-28 15:53 <cedk> udono: can you copy/paste the report somewhere
2008-08-28 15:54 <udono> cedk: I pack you a module
2008-08-28 16:04 <udono> Another question: Is there a way in Tryton to automatic update account_invoice module when I uninstall my custom module?
2008-08-28 16:04 <cedk> udono: no and we don't have uninstall option
2008-08-28 16:05 <udono> cedk: Ok, than its a matter of module install description.
2008-08-28 16:18 <cedk> udono: I will disable the button
2008-08-28 16:22 <udono> cedk: I dont understand?
2008-08-28 16:23 <cedk> udono: there is the button in the form but it doesn't work
2008-08-28 16:23 <cedk> udono: so I will disable it unitl we have a good solution for uninstallation
2008-08-28 16:24 <udono> cedk: but in most cases uninstallation works fine...
2008-08-28 16:25 -!- CIA-55(n=CIA@ has joined #tryton
2008-08-28 16:25 <yangoon> cedk: whats about CIA?
2008-08-28 16:25 <yangoon> cedk: ah, logged in again, I missed a message from roundup
2008-08-28 16:28 <cedk> yangoon: sometimes CIA is down because of too much traffic
2008-08-28 16:34 <yangoon> cedk: CIA is here, but nevertheless no messages from roundup
2008-08-28 16:36 <cedk> yangoon: sometimes, the irc client is connected but the CIA server is down
2008-08-28 16:36 <cedk> yangoon: so roundup can not send message to CIA
2008-08-28 16:37 <yangoon> cedk: ok
2008-08-28 16:38 <yangoon> afk
2008-08-28 16:39 <udono> cedk: did you see a problem in the report? I use the same structure like the report you provided, but it doesnt work...
2008-08-28 17:05 <cedk> udono: did you have the table?
2008-08-28 17:06 <udono> test=# 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%30dN
2008-08-28 17:07 <udono> cedk:
2008-08-28 17:07 <cedk> udono: no I mean in the report when you print it ?
2008-08-28 17:08 <udono> yes, the table is there, even the payment lines, but not the payment description... this is the strange I meant...
2008-08-28 17:08 <cedk> udono: because I see that you remove the <if test="invoice.payment_term.description">
2008-08-28 17:08 <udono> cedk: yes, to see if there is anything False inside
2008-08-28 17:10 <udono> cedk: is there a way to find out all variables in a report and their values?
2008-08-28 17:10 <udono> cedk: I think of a prettyprint representation of the object...
2008-08-28 17:13 <cedk> udono: I don't know
2008-08-28 17:13 <cedk> udono: I try your report, but there is some issue
2008-08-28 17:14 <cedk> udono: first you use the country code of the address with testing before that there is a country on the address
2008-08-28 17:14 <cedk> udono: and all formatLang have not been converted to the new format
2008-08-28 17:14 <cedk> udono: so I can not try the report
2008-08-28 17:15 <udono> cedk: ok, so I must first migrate :-)
2008-08-28 17:15 <udono> cedk: you catch me ...
2008-08-28 17:16 <cedk> udono: so the only difference that I see that can be the issue for payment terms is the <if test=...>
2008-08-28 17:16 <cedk> udono: can you try it?
2008-08-28 17:17 <udono> you mean the same strukture like in your invoice report
2008-08-28 17:18 <udono> <if test="invoice.payment_term.description">
2008-08-28 17:18 <udono> cedk:
2008-08-28 17:20 <cedk> udono: yes
2008-08-28 17:22 <udono> cedk: all payment lines there, but no payment_term_description
2008-08-28 17:25 <udono> cedk: 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...
2008-08-28 17:26 -!- CIA-56(n=CIA@ has joined #tryton
2008-08-28 17:47 <CIA-56> tryton: 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 ...
2008-08-28 17:48 <CIA-56> tryton: 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 ...
2008-08-28 17:48 <CIA-56> tryton: 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 " ...
2008-08-28 17:54 <CIA-56> tryton: 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?
2008-08-28 18:53 -!- b52laptop(n=b52lapto@ has joined #tryton
2008-08-28 19:09 <cedk> I just push a new feature that allow to translate sql error that comes from a _sql_constraint
2008-08-28 19:10 <cedk> so for german people, you can try to update the translation with these new messages
2008-08-28 19:18 <yangoon> cedk: german people are unable to start the client any more with current tip;)
2008-08-28 19:18 <cedk> yangoon: remove the tryton.pyc
2008-08-28 19:18 <yangoon> cedk: ah, once again
2008-08-28 19:19 <cedk> yangoon: I don't know, but it is the last issue with the client
2008-08-28 19:19 <cedk> yangoon: otherwise send the traceback
2008-08-28 19:20 <yangoon> cedk: no. running again, all perfect, perhaps I forgot to delete it in this test instance
2008-08-28 19:40 -!- CIA-57(n=CIA@ has joined #tryton
2008-08-28 19:40 -!- yangoon( has joined #tryton
2008-08-28 21:53 -!- CIA-53(n=CIA@ has joined #tryton
2008-08-28 22:22 -!- bechamel( has joined #tryton

Generated by 2.17.3 by Marius Gedminas - find it at!