IRC logs of #tryton for Wednesday, 2008-08-06 #tryton log beginning Wed Aug 6 00:00:01 CEST 2008
2008-08-06 00:27 -!- ChanServ(ChanServ@services.) has joined #tryton
2008-08-06 00:38 -!- ChanServ(ChanServ@services.) has joined #tryton
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 807:b0f4ea618346 trytond/trytond/ (ir/translation.xml osv/
2008-08-06 00:50 <CIA-54> tryton: Remove _error_messages in ORM object and put the translation in
2008-08-06 00:50 <CIA-54> tryton: translation.xml
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 808:a1e4e4b8ab27 trytond/trytond/ir/ Fix export translation for unicode string
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 809:a446034a0c53 trytond/trytond/ir/ Add test for ttype error and raise an exception for unknown type
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 810:8e7cf988d2be trytond/trytond/ (ir/fr_FR.csv res/fr_FR.csv webdav/fr_FR.csv): Update fr_FR translation
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 171:91ed02ac31ea account/ ( fr_FR.csv): Add fr_FR translation
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 91:d2008637a283 account_invoice/ ( fr_FR.csv): Add fr_FR translation
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 44:1c182bfaf52f company/ ( fr_FR.csv): Add fr_FR translation
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 11:680d7efc34c2 currency/ ( fr_FR.csv): Add fr_FR translation
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 66:8388184fd3d6 product/ ( fr_FR.csv): Add fr_FR translation
2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <> default * 118:5c51502203fb relationship/fr_FR.csv: Update fr_FR translation
2008-08-06 01:27 -!- betamax_(i=betamax@gateway/tor/x-fb6f1fbcdc6240a3) has joined #tryton
2008-08-06 07:46 -!- Timitos(n=Timitos@ has joined #tryton
2008-08-06 09:04 -!- Gedd(n=ged@ has joined #tryton
2008-08-06 09:10 -!- gadaga( has joined #tryton
2008-08-06 09:10 <gadaga> hi
2008-08-06 09:32 <udono> gadaga: hi
2008-08-06 09:32 <gadaga> udono: hi
2008-08-06 09:39 -!- markusleist(n=markus@ has joined #tryton
2008-08-06 10:22 <udono> hello, someone knows how I can use the translation mechanism of tryton in the reports? I like to see the labels like Quantity, Description, amount,.. in the native language of the Party...
2008-08-06 10:23 <udono> In the reports are just the contents translated, but not the labels/headers...
2008-08-06 10:24 <udono> another question is, where is the invoice header defined? Its neither in the invoice template, nor in the company settings.
2008-08-06 10:34 -!- kultviech( has joined #tryton
2008-08-06 10:36 -!- essich( has joined #tryton
2008-08-06 10:36 <essich> hi
2008-08-06 10:37 <essich> just looking in after some weeks for a few minutes :-)
2008-08-06 11:12 <CIA-54> tryton: Timitos roundup * #227/translation of client does not work under windows: its a german xp pro. everything is german. so i think german language should be installed.
2008-08-06 12:28 <gadaga> Why in product.category when we do a search, the result return the complete_name and not the name?
2008-08-06 12:28 <gadaga> no a search a read ;)
2008-08-06 12:47 -!- nicoe( has joined #tryton
2008-08-06 13:24 -!- kultviech( has joined #tryton
2008-08-06 13:40 -!- gadaga( has joined #tryton
2008-08-06 14:37 <udono> gadaga: Both are shown in the resultlist...
2008-08-06 14:37 -!- lionel_( has joined #tryton
2008-08-06 14:38 <gadaga> udono: thanks
2008-08-06 15:05 -!- Leyoda( has joined #tryton
2008-08-06 15:06 -!- nicoe( has joined #tryton
2008-08-06 15:07 <nicoe> udono: You'll be happy to know that I successfully created a pivot table (called data pilot table) in openoffice calc
2008-08-06 15:37 <udono> nicoe: The greatest man in universe :-)
2008-08-06 15:37 <udono> nicoe: how did you do it?
2008-08-06 15:38 <nicoe> It was complicated
2008-08-06 15:38 <nicoe> I'm commiting the changes to the hg right now
2008-08-06 15:39 <nicoe> But it involved some customizing of the ods' content.xml file by hand
2008-08-06 15:40 <nicoe> And I use a tab as a data repository only (no formula, just headers and data)
2008-08-06 15:40 -!- Gedd(n=ged@ has joined #tryton
2008-08-06 15:42 <nicoe> udono: ok changes are pushed.
2008-08-06 15:43 <nicoe> Another interesting thing is that now the table data should follow the data in placeholders even in the odt files.
2008-08-06 15:44 <udono> nicoe: is it in the relatorio sources?
2008-08-06 15:44 <nicoe> udono: in relatorio's mercurial repository
2008-08-06 15:44 <udono> nicoe: where to find?
2008-08-06 15:45 <udono> nicoe: got it
2008-08-06 15:45 <nicoe> BTW we also have a trac instance to track bugs, add information in
2008-08-06 15:48 -!- gael_( has joined #tryton
2008-08-06 16:03 <udono> nicoe: is the change already as an egg available?
2008-08-06 16:04 <udono> nicoe: or as mercurial repository?
2008-08-06 16:04 <nicoe> Not yet, I'll make a release soon
2008-08-06 16:04 <nicoe> But it is already present in the mercurial repository
2008-08-06 16:34 <nicoe> udono: I released an egg:
2008-08-06 16:35 <udono> nicoe: You are my man! Thanks a lot. So I just update my old eggs from eastern ,-)
2008-08-06 16:36 <udono> nicoe: you dont change the version number? No prob, I just delete the old relatorio...
2008-08-06 16:37 <udono> nicoe: easy install tells me its relatorio-0.2.0-py2.5.egg
2008-08-06 16:37 <nicoe> udono: What needs to be done is a way to create placeholder in the oocalc always going in the content.xml file is difficult for "normal" people :)
2008-08-06 16:37 <nicoe> on pypi it's 0.3.0
2008-08-06 16:37 <udono> nicoe: ok
2008-08-06 16:42 <udono> nicoe: I first test it with your testscrips...
2008-08-06 16:42 <nicoe> udono: ok
2008-08-06 16:45 <udono> nicoe: hmm, cant get the test called...
2008-08-06 16:46 <nicoe> udono: what's happening ?
2008-08-06 16:46 <udono> nicoe: I installed via egg and easyinstall
2008-08-06 16:46 <udono> nicoe: all fine
2008-08-06 16:47 <udono> nicoe: the testscripts are in the repos, so I pull them
2008-08-06 16:47 <nicoe> udono: hu ok
2008-08-06 16:48 <udono> nicoe: than I change into the relatorio folder:
2008-08-06 16:48 <udono> nicoe:... and call python relatorio/tests/
2008-08-06 16:49 <udono> nicoe: but it raises an error: ImportError: No module named reporting
2008-08-06 16:49 <udono> nicoe: maybe the eggs are broken :-)
2008-08-06 16:49 <nicoe> udono: there is one failed test there. But without any impact on the opendocument plugin
2008-08-06 16:50 <nicoe> udono: can you paste somewhere the complete traceback ?
2008-08-06 16:51 <udono> nicoe:
2008-08-06 16:53 <nicoe> Try running the test from the relatorio directory
2008-08-06 16:53 <nicoe> BTW those are nosetests tests.
2008-08-06 16:53 <nicoe> What you are looking for is in the example directory
2008-08-06 16:53 <udono> nicoe: nose I installed...
2008-08-06 16:54 <udono> nicoe: the same result from relatorio folder...
2008-08-06 16:55 <udono> nicoe: example works fine :-)
2008-08-06 16:55 <nicoe> Do you also have the pivot table ?
2008-08-06 16:55 <nicoe> You need to refresh it
2008-08-06 16:55 <nicoe> it's strange that nose does not work
2008-08-06 16:56 <udono> yeah, all there
2008-08-06 16:58 <udono> nicoe: I show the Template of the ods, Thats the syntax I like to see. Great job!
2008-08-06 16:59 <udono> nicoe: you name the table pivot, but its just a simple odt table isnt it?!
2008-08-06 16:59 <udono> sorrx odt=ods
2008-08-06 17:00 <udono> nicoe what we have to manipulate inside the ods XML?
2008-08-06 17:00 <nicoe> No, it's generated from the content of the data table
2008-08-06 17:00 <udono> :-)
2008-08-06 17:00 <udono> nicoe: ok, I just recognize the data table...
2008-08-06 17:00 <nicoe> There is no way to create a <text:placeholder> tag in the interface of openoffice for Spreadsheet
2008-08-06 17:01 <nicoe> So I inserted them by hand
2008-08-06 17:02 <nicoe> I think the easyest way to create a pivot table is: (a) create your data table with the name of the fields (b) create the pivot table (c) edit content.xml to use placeholders
2008-08-06 17:03 <nicoe> you could probably use an intermediate table to do computation on the data
2008-08-06 17:03 <udono> nicoe: great! the pivot is running fine.
2008-08-06 17:04 <udono> nicoe: is the manipulation needed just for parsing the data table? or on the pivot creation?
2008-08-06 17:05 <nicoe> The creation of the pivot.ods file was a mess, but I would say that it is only need for the parsing data. I'll try to create a more complicated example without doing anything else but adding placeholder tags
2008-08-06 17:06 <udono> nicoe: I will ask the openoffice guys if they have a solution.
2008-08-06 17:07 <udono> nicoe: I c you put the placeholder tag inside the text:p <text:p><text:placeholder>&lt;l.item.price&gt;</text:placeholder></text:p>
2008-08-06 17:07 <nicoe> udono: please do :).
2008-08-06 17:08 <nicoe> udono, yes I did minimal changes on the generated content
2008-08-06 17:08 <udono> nicoe: and you parse the ods the same like the odt?!
2008-08-06 17:08 <nicoe> it's the same norm
2008-08-06 17:08 <udono> nicoe: ok, I will ask them in some minutes...
2008-08-06 17:09 <nicoe> Doing it the same way allows you to use the format number stuff from calc in writer
2008-08-06 17:10 <nicoe> eg you do not have to use a py:if just to highlight negative numbers in red. OO will do it for you. even in odt document
2008-08-06 17:14 <udono> ACTION can't get enough from dreaming ...
2008-08-06 17:14 <udono> nicoe: great ideas!
2008-08-06 17:15 <nicoe> In fact it was a nice plus ... I realized it would work only after having done it
2008-08-06 18:17 <udono> nicoe: there is no reaction untill now... I requested the following:
2008-08-06 18:17 <udono> Hello, we have a problem with parsing ODS Content.xml files. We are working on relatorio ( an open source template parser for Open-Office dokuments. With this parser it's possible to replace special tags in ODT files with Python variable values. We like to extend the functionality of our parser to ODS documents. But there are some Problems.How we do in ODT: The user create his document via OpenOffice. Spe
2008-08-06 18:17 <udono> ield function to be inserted. This function generates the following code in the content.xml:<text:p text:style-name="P4"><text:placeholder text:placeholder-type="text">My Variable to be parsed</text:placeholder></text:p>The same we like to do in ODS. But there is no eqivalent function like this. The ODS cell content looks like:<table:table-cell office:value-type="float"><text:p>My Variable to be parsed</text:p></table:table-cell>But
2008-08-06 18:17 <udono> content is just normal text or a variable to be parsed.If we could put a <text:placeholder> tag inside, we even do not neet to rewrite our parser. In a testcase with manualy inserting this tag we can parse ods without problems.Is there a way to put a tag inside the <text:p></text:p> from userside?Where I can start to solve this problem?
2008-08-06 18:34 <udono> Hey nicoe, have a soulution...
2008-08-06 18:44 <udono> nicoe: if you insert a hyperlink with an own protocol like "relatorio://<and the tags inside />" than you get the structure:<table:table-cell office:value-type="string"><text:p><text:a xlink:href="relatorio://&lt;test&gt;&lt;/test&gt;">relatorio://&lt;test&gt;&lt;/test&gt;</text:a></text:p></table:table-cell>
2008-08-06 18:56 <udono> nicoe: a comparisation between ODT and ODS results in the same structure:
2008-08-06 18:59 <udono> nicoe: so I would propose to use Hyperlinks with a private Protokoll to insert the genshi structures and no longer ODT only placeholders...
2008-08-06 19:01 <udono> nicoe: The Hyperlink solution is valid ODF.
2008-08-06 19:02 <udono> nicoe: We can hide complex structures behind a simple Name, if we use the xlink:href="relatorio://&lt;test&gt;&lt;/test&gt;" expression for the parsing things and the content between for the Name...
2008-08-06 19:04 <nicoe> udono I'm back
2008-08-06 19:04 <udono> nicoe: welcome I received a good ides...
2008-08-06 19:04 <udono> idea
2008-08-06 19:05 <nicoe> I did not understand your last message could you show me the url you'd like to create (but withtout escaping it for the sake of clarity)
2008-08-06 19:06 <udono> relatorio://<test></test>
2008-08-06 19:06 <udono> its a private protokol and genshi after this...
2008-08-06 19:06 <nicoe> In the url idee we do not need the <> ... They are inserted by openoffice but I dont like them
2008-08-06 19:07 <nicoe> We could have relatorio://(a + b)
2008-08-06 19:07 <nicoe> relatorio://for each="foo in bar"
2008-08-06 19:08 <udono> nicoe: this looks not bad
2008-08-06 19:08 <nicoe> I don't know ...
2008-08-06 19:09 <nicoe> I'll rewrite the example documents and see what it looks like
2008-08-06 19:10 <nicoe> Of course if we go this way, cedk will have to rewrite their documents
2008-08-06 19:10 <udono> nicoe: did you recognize the sentence with xlink:href?
2008-08-06 19:10 <nicoe> Or I could support the old syntax and issue warning
2008-08-06 19:11 <nicoe> udono it's <test></test>
2008-08-06 19:11 <udono> nicoe: It could be possible to hide complex structure behind a simple name...
2008-08-06 19:11 <nicoe> udonon ?
2008-08-06 19:12 <udono> nicoe: The user see the simple name, and behind this is the complex hyperlink...
2008-08-06 19:13 <udono> nicoe: For me the old syntax is only good for ODT, but unusable for ods, because Openoffice filter them out after saving...
2008-08-06 19:13 <nicoe> in your pasted code the href contains the same thing as the a
2008-08-06 19:13 <udono> nicoe: yes, but it mustn't be
2008-08-06 19:13 <nicoe> you're right
2008-08-06 19:13 <udono> nicoe: better to use the xlink:href attribute.
2008-08-06 19:14 <nicoe> We should use the xlink:href and let the developper the opportunity to add "comments" in the TEXT node
2008-08-06 19:14 <nicoe> That seems quite good
2008-08-06 19:15 <nicoe> Where there any other ideas on the opeoffice channel ?
2008-08-06 19:15 <udono> nicoe: I tested the href entry: I cant see an end, It slurps more than 4500 characters...
2008-08-06 19:17 <udono> nicoe: no, the gui who helps me (seems a sun-boy) meant that the hyperlink is the only way to get valid odf, even for odt and ods
2008-08-06 19:17 <nicoe> If guys at Sun says so ...
2008-08-06 19:17 <nicoe> They know better :)
2008-08-06 19:18 <nicoe> I'll try that.
2008-08-06 19:18 <udono> nicoe: One guy with sun in his name :-) thats his blog
2008-08-06 19:21 <udono> nicoe: He meant at the end of our conversation: thinking further: it might even be possible to create an extension that handles a private protocol during runtime [/me doesn't know how though]
2008-08-06 19:21 <nicoe> udono I suppose he meant an extension to OO
2008-08-06 19:22 <udono> nicoe: yes
2008-08-06 19:22 <udono> nicoe: I understand the same
2008-08-06 19:23 <nicoe> udono I don't feel like writing an OO extension (Java, something to install, etc)
2008-08-06 19:23 <nicoe> udono one day who knows
2008-08-06 19:24 <udono> nicoe: me not, too. But we must not do this. The only thing not so nice is, that the Hyperlink is a single entryline...
2008-08-06 19:25 <nicoe> Usually stuffs replacing the code is just one line this does not seems like a problem to me
2008-08-06 19:26 <udono> nicoe: ok
2008-08-06 19:26 <nicoe> It seems more like a good thing in fact
2008-08-06 19:27 <udono> nicoe: yes, maybe. Iam new to the genshi syntax, but in the past when we used python as the template language, it was not so easy to put complex structures into one single line...
2008-08-06 19:28 <udono> nicoe: but you may be right
2008-08-06 19:28 <nicoe> oh ok I understand
2008-08-06 19:29 <udono> nicoe: but now everything is going easier, thanks to relatorio...
2008-08-06 19:31 <nicoe> I think the more processing you put in the python code before rendering the template the better
2008-08-06 19:34 <udono> nicoe: of course, even when using python as templating language, and eval="it" you get a security hole...
2008-08-06 19:35 <nicoe> Indeed
2008-08-06 20:50 <udono> FWiesing: Hello
2008-08-06 21:07 <FWiesing> udono: hello!
2008-08-06 21:07 <udono> FWiesing: how are you?
2008-08-06 21:08 <FWiesing> udono: all ok
2008-08-06 21:08 <FWiesing> udono: thx
2008-08-06 21:08 <udono> FWiesing: great! I like to ask, if we can put the translations into the modules?
2008-08-06 21:08 <FWiesing> udono: please give me 5 minutes
2008-08-06 21:08 <udono> FWiesing: You have 10
2008-08-06 21:09 <FWiesing> I think you could
2008-08-06 21:09 <udono> ;-)
2008-08-06 21:09 <FWiesing> :-)
2008-08-06 21:19 <FWiesing> back
2008-08-06 21:36 <FWiesing> udono: If I update my trytond - can I start the trytond with the options -d <databasenam> and -u all ?
2008-08-06 21:37 <Timitos> FWiesing: the server will stop after the update. you need to start the server in normal mode after db update
2008-08-06 21:38 <FWiesing> udono: Ok - First step is to start trytond with the option -d <databasename> and then in restart in normal mode
2008-08-06 21:39 <Timitos> FWiesing: I am Timitos ;-) and yes you are right
2008-08-06 21:39 <FWiesing> thx :-)
2008-08-06 21:41 <FWiesing> german language - I think you can use the translation - but I'm sure - there are one or two things which needs an update ...
2008-08-06 21:41 <FWiesing> last week I didn't could test very much
2008-08-06 21:41 <Timitos> i think we will find these points easier when using the translation
2008-08-06 21:42 <Timitos> FWiesing: me too. had to much other work.
2008-08-06 21:42 <FWiesing> this month and september I'm in a terrible hurry and only in the evening available
2008-08-06 21:44 <Timitos> donĀ“t worry. we have enough to do. i am sitting on account chart these days. i hope that it will be available in the end of august.
2008-08-06 21:44 <FWiesing> should I send a databasedump?
2008-08-06 21:45 <Timitos> this is not nessecary in the moment as i go a different way from yours. if i succeed i will be able to parse a account chart for AT on the fly
2008-08-06 21:45 <FWiesing> Timitos: you have time to take a look of my account-chart for Austria
2008-08-06 21:45 <FWiesing> OK
2008-08-06 21:49 <FWiesing> girl-friend is calling - I need to go ... :-)
2008-08-06 21:49 <FWiesing> cu
2008-08-06 21:49 <udono> bye
2008-08-06 21:49 <Timitos> cu
2008-08-06 21:50 <FWiesing> come back a later!
2008-08-06 22:11 <udono> good night all, need sleep.
2008-08-06 22:11 <Timitos> gute n8

Generated by 2.17.3 by Marius Gedminas - find it at!