| chat.freenode.net #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 <ced@b2ck.com> default * 807:b0f4ea618346 trytond/trytond/ (ir/translation.xml osv/orm.py): | ||
| 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 <ced@b2ck.com> default * 808:a1e4e4b8ab27 trytond/trytond/ir/translation.py: Fix export translation for unicode string | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> default * 809:a446034a0c53 trytond/trytond/ir/translation.py: Add test for ttype error and raise an exception for unknown type | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> 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 <ced@b2ck.com> default * 171:91ed02ac31ea account/ (__tryton__.py fr_FR.csv): Add fr_FR translation | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> default * 91:d2008637a283 account_invoice/ (__tryton__.py fr_FR.csv): Add fr_FR translation | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> default * 44:1c182bfaf52f company/ (__tryton__.py fr_FR.csv): Add fr_FR translation | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> default * 11:680d7efc34c2 currency/ (__tryton__.py fr_FR.csv): Add fr_FR translation | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> default * 66:8388184fd3d6 product/ (__tryton__.py fr_FR.csv): Add fr_FR translation | ||
| 2008-08-06 00:50 <CIA-54> tryton: C?dric Krier <ced@b2ck.com> 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@88.217.184.172) has joined #tryton | ||
| 2008-08-06 09:04 -!- Gedd(n=ged@77.109.115.229) has joined #tryton | ||
| 2008-08-06 09:10 -!- gadaga(n=gael@sednaco19320-gw.clients.easynet.fr) 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@212.14.79.210) 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(n=kultviec@p54973F1D.dip.t-dialin.net) has joined #tryton | ||
| 2008-08-06 10:36 -!- essich(n=essich@p4FCFAF67.dip0.t-ipconnect.de) 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(n=nicoe@ip-80-236-206-69.dsl.scarlet.be) has joined #tryton | ||
| 2008-08-06 13:24 -!- kultviech(n=kultviec@p54973F1D.dip.t-dialin.net) has joined #tryton | ||
| 2008-08-06 13:40 -!- gadaga(n=gael@sednaco19320-gw.clients.easynet.fr) has joined #tryton | ||
| 2008-08-06 14:37 <udono> gadaga: Both are shown in the resultlist... | ||
| 2008-08-06 14:37 -!- lionel_(n=lionel@pic33-1-87-88-179-8.dsl.club-internet.fr) has joined #tryton | ||
| 2008-08-06 14:38 <gadaga> udono: thanks | ||
| 2008-08-06 15:05 -!- Leyoda(n=Leyoda@pic33-1-87-88-179-8.dsl.club-internet.fr) has joined #tryton | ||
| 2008-08-06 15:06 -!- nicoe(n=nicoe@ip-80-236-206-69.dsl.scarlet.be) 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@77.109.115.229) 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> http://hg.openhex.org/relatorio BTW we also have a trac instance to track bugs, add information in http://relatorio.openhex.org | ||
| 2008-08-06 15:48 -!- gael_(n=gael@sednaco19320-gw.clients.easynet.fr) 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: http://pypi.python.org/pypi/relatorio | ||
| 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/test_api.py | ||
| 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: http://paste.pocoo.org/show/81395/ | ||
| 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><l.item.price></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 (http://relatorio.openhex.org/) 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://<test></test>">relatorio://<test></test></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: http://paste.pocoo.org/show/81403/ | ||
| 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://<test></test>" 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 :-) http://www.jroller.com/erAck/ 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 irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!