IRC logs of #tryton for Friday, 2008-08-08

chat.freenode.net #tryton log beginning Fri Aug 8 00:00:01 CEST 2008
2008-08-08 07:30 -!- Timitos(n=Timitos@88.217.184.172) has joined #tryton
2008-08-08 08:48 -!- nicoe(n=nicoe@ip-80-236-206-69.dsl.scarlet.be) has joined #tryton
2008-08-08 08:51 <nicoe> udono: I think I found a solution to the problem of the debugging with relatorio
2008-08-08 08:52 <udono> nicoe: Godd morn'
2008-08-08 08:52 <udono> nicoe: great to read
2008-08-08 08:52 <nicoe> udono: Good morning.
2008-08-08 08:52 <udono> nicoe: Iam evaluating now, you get the massage in some minutes
2008-08-08 08:52 <udono> message=email
2008-08-08 08:52 <nicoe> udono: In fact it is really simple: just use the genshi interpolation stuff
2008-08-08 08:53 <nicoe> udono: ${o.customer.name} in the reports works too
2008-08-08 08:53 <nicoe> udono: thanks to genshi
2008-08-08 08:53 <udono> nicoe: hmm, never heard about this stuff
2008-08-08 08:53 <nicoe> It's a feature of genshi
2008-08-08 08:54 <nicoe> For simple thing you do not have to use <py:replace> tag
2008-08-08 08:54 <udono> nicoe: where is the problem in debugging with relatorio? havn't recognized this
2008-08-08 08:54 -!- gadaga(n=gael@sednaco19320-gw.clients.easynet.fr) has joined #tryton
2008-08-08 08:54 <gadaga> hi
2008-08-08 08:54 <nicoe> Just a simple ${variable} will be replace by a <py:replace>
2008-08-08 08:54 <nicoe> hi
2008-08-08 08:54 <gadaga> nicoe: hi
2008-08-08 08:56 <nicoe> It will ease the debuggin I think, we could keep the text:a stuff for very specific things (for/choose/... and for value in the oocalc)
2008-08-08 08:58 <udono> hi gadaga
2008-08-08 08:58 <udono> nicoe: I thing I have to read the genshi documentation...
2008-08-08 08:59 <udono> nicoe: you have mail
2008-08-08 08:59 <gadaga> udono: hi
2008-08-08 08:59 <nicoe> udono: I'll take a look.
2008-08-08 09:00 <gadaga> everyone can create a new database with the next rev of trytond?
2008-08-08 09:00 <gadaga> my create crash every time :(
2008-08-08 09:03 <udono> gadaga: where it crash?
2008-08-08 09:04 <gadaga> udono: on createdb
2008-08-08 09:04 <udono> gadaga: hmm, could be my fault
2008-08-08 09:04 <udono> gadaga: what happens?
2008-08-08 09:04 <gadaga> udono: error : relation "ir_model" already exist
2008-08-08 09:05 <udono> gadaga: this error depends on other things, than my modifications
2008-08-08 09:05 <udono> ACTION duck
2008-08-08 09:05 <udono> :-)
2008-08-08 09:05 <gadaga> udono: :(
2008-08-08 09:06 <Timitos> gadaga: udono: for me database creation works with the actual changeset
2008-08-08 09:06 <udono> gadaga: Rule 1: Fault are the others
2008-08-08 09:06 <gadaga> udono: could you send me a dump of a new database?
2008-08-08 09:06 <udono> gadaga: No, just joking
2008-08-08 09:06 <udono> gadaga: database creation works fine on my machines...
2008-08-08 09:06 <gadaga> i'll try to reinstall trytond
2008-08-08 09:07 <udono> gadaga: This could solve problems, but when it is on database side...
2008-08-08 09:07 <udono> gadaga: but its worth to try...
2008-08-08 09:08 <udono> gadaga can you open an existing database?
2008-08-08 09:08 <gadaga> udono: with a new trytond, 've got the same problem
2008-08-08 09:08 <gadaga> udono: yes i can open an existing database
2008-08-08 09:09 <udono> gadaga: but you can not update an existing database?
2008-08-08 09:10 <gadaga> udono: i don't know, i borke my relationship_party records with a test :p
2008-08-08 09:10 <gadaga> udono: you are in postgresql 8.2 or 8.3?
2008-08-08 09:11 <udono> gadaga: Iam in 8.2
2008-08-08 09:11 <udono> gadaga: which OS you use?
2008-08-08 09:12 <gadaga> udono: ubuntu 7.10 and postgres 8.2
2008-08-08 09:12 -!- bch(n=user@user-85-201-14-207.tvcablenet.be) has joined #tryton
2008-08-08 09:13 <udono> gadaga: the sam I had on my old installation... without problems
2008-08-08 09:14 <udono> gadaga: Iam now on Ubuntu 8.04, but there has been are some flaws in the upgrade...
2008-08-08 09:15 <udono> gadaga: but now its working...
2008-08-08 09:16 <udono> gadaga: maybe I have an good idea...
2008-08-08 09:16 <gadaga> udono: with a dump i have no pb
2008-08-08 09:16 <udono> gadaga: can you examine databasetables via psql or another tool?
2008-08-08 09:16 <gadaga> udono: of course
2008-08-08 09:17 <udono> gadaga: open the template1 database and show if there is tryton stuff inside...
2008-08-08 09:17 <udono> gadaga: the same with template0
2008-08-08 09:18 <udono> gadaga: because if someone creates a database, there will created a copy of template1...
2008-08-08 09:18 <udono> gadaga: and if there is already trytonstuff inside, tryton fails in creating the same structure...
2008-08-08 09:19 <udono> gadaga: I had this problem seen in my last projects...
2008-08-08 09:20 <gadaga> \c template1
2008-08-08 09:20 <gadaga> oups :p
2008-08-08 09:20 <udono> got it?
2008-08-08 09:21 <udono> gadaga: ?
2008-08-08 09:21 <gadaga> udono: i don't found trytonstuff
2008-08-08 09:23 <udono> gadaga: no table ir_model in both databases?
2008-08-08 09:25 <gadaga> udono: yes i found the table
2008-08-08 09:26 <udono> gadaga: in template1 or 0 or both?
2008-08-08 09:27 <gadaga> udono: i can't connect to template0
2008-08-08 09:28 <nicoe> bch: I think I found a way to avoid bugs in relatorio with URL
2008-08-08 09:28 <udono> gadaga: can you CREATE DATABASE template3 TEMPLATE template0;
2008-08-08 09:29 <udono> gadaga: user postgres...
2008-08-08 09:29 <Timitos> bch: hi
2008-08-08 09:29 <bch> hi all
2008-08-08 09:29 <nicoe> salut tout seul
2008-08-08 09:29 <udono> bch: Timitos: hi
2008-08-08 09:30 <Timitos> bch: do you know for what the field kind in account.account is used?
2008-08-08 09:30 <Timitos> bch: only for computing payable and receivable on relationship.party?
2008-08-08 09:31 <udono> gadaga: ?
2008-08-08 09:31 <gadaga> udono: ok
2008-08-08 09:31 <bch> Timitos: it's the result of your last discussion with ced about it, i think kind was on the account.type before.
2008-08-08 09:31 <gadaga> udono: i did it
2008-08-08 09:32 <udono> gadaga: you can create template3 as template from template0?
2008-08-08 09:32 <gadaga> udono: yep
2008-08-08 09:32 <Timitos> bch: yes. thats ok. but i need to know where this value is used.
2008-08-08 09:32 <udono> gadaga: \c template3
2008-08-08 09:33 <udono> gadaga: and show for ir_model inside
2008-08-08 09:33 <Timitos> bch: i am working on german account chart and can not parse these values completely. so i want to set them to "Other" in most cases. but i don´t know which effect this will have.
2008-08-08 09:34 <gadaga> udono: template3 is empty
2008-08-08 09:34 <udono> gadaga: juat the standard pg_* tables?
2008-08-08 09:34 <gadaga> udono: with \dt : no relation found
2008-08-08 09:35 <bch> Timitos: essentially kind is used to filter on kind 'receivable' and 'payable' when such an account is needed
2008-08-08 09:35 <udono> gadaga: try select * from pg_<TAB-Key> then should some pg_ tables shown
2008-08-08 09:36 <gadaga> udono: ok i see pg_ tables
2008-08-08 09:36 <bch> Timitos: and also iirc the kind is used to filter accoutns on reporting
2008-08-08 09:36 <udono> gadaga: I think we can drop the template1 table and recreate it with template0, but dont bite me if your computer begin to burn ;-)
2008-08-08 09:37 <udono> gadaga: \c template3
2008-08-08 09:37 <Timitos> bch: is there also some filtering on the values 'expense' and 'revenue'? these values are my problems.
2008-08-08 09:37 <udono> gadaga: drop database template1;
2008-08-08 09:37 <gadaga> udono: i already use openerp to....
2008-08-08 09:37 <Timitos> bch: i can parse everything but not divide my accounts by 'expense' and 'revenue' :-(
2008-08-08 09:38 <bch> Timitos: all the filter i see about expense and revenue are made on the type of the journal
2008-08-08 09:38 <udono> gadaga than make a dump of template1
2008-08-08 09:39 <udono> gadaga: is template1 your production database?
2008-08-08 09:40 <gadaga> udono: yes :(
2008-08-08 09:40 <Timitos> bch: but this is not connected to the field kind i think?
2008-08-08 09:41 <Timitos> bch: not correct! there is only a "kind!="view""
2008-08-08 09:42 <Timitos> bch: this should not be a problem for me. so i hope that i can do i my way. i worst case i need to fill these values by hand :-(
2008-08-08 09:43 <udono> gadaga: no problem
2008-08-08 09:43 <udono> gadaga: did you drop the database? If not DOT DO IT
2008-08-08 09:44 <udono> gadaga: template1 I mean with database
2008-08-08 09:44 <udono> gadaga: ...but you told you have a dump?
2008-08-08 09:44 <gadaga> udono: are you sure i can drop template1 without pb if i use openerp and tryton?
2008-08-08 09:44 <udono> gadaga: wait
2008-08-08 09:45 <gadaga> udono: i have a dump of a tryton database
2008-08-08 09:45 <udono> gadaga: Your template1 is tainted by non templating data
2008-08-08 09:45 <bch> Timitos: maybe you can have a look in account_be
2008-08-08 09:46 <udono> gadaga: This is, sorry, a user mistake from a previous installation. Tryton needs to avoid updating template* databases, I'll create a bugentry
2008-08-08 09:47 <Timitos> bch: great idea!!! :-D seems that there are also no values "expense" and "revenue" in there.
2008-08-08 09:47 <udono> gadaga: you need a backup or rename of the template1 database to somthing tryton/open-erp, after this you need to recreate the template1 database from template0
2008-08-08 09:48 <udono> gadaga: http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html
2008-08-08 09:49 <gadaga> udono: ok thanks
2008-08-08 09:54 <bch> nicoe: you told me that you find a way to avoid bug wit urls ?
2008-08-08 09:54 <nicoe> bch: yes, just use genshi interpolation mechanism
2008-08-08 09:55 <nicoe> bch: In fact Ged told me that it would be nice to have this mechanism and will reading genshi code I notice we already had it.
2008-08-08 09:56 <nicoe> so instead of having <text:placeholder>toto</text:placeholder> or <text:a href="relatorio://toto">toto</text:a> you can use ${toto} in your template
2008-08-08 09:57 <CIA-54> tryton: uspallek roundup * #238/Avoid updating postgres template Databases: [new] gadaga has the problem that he installs Tryton or OpenERP into the template1 database of postgres. But postgres uses the template1 database ...
2008-08-08 09:57 <udono> gadaga: I place an issue and put you on the nosy list...
2008-08-08 09:58 <bch> nicoe: .. and forget about the tags ?
2008-08-08 09:58 <nicoe> the text:a stuff can be reserved only for "complicated" stuffs: for/choose/or inclusion in calc documents
2008-08-08 09:58 <udono> gadaga: is the template1 database from tryton or openERP?
2008-08-08 09:58 <nicoe> bch: yes
2008-08-08 09:58 <nicoe> bch; It comes bundled in genshi so I did not even think about it ...
2008-08-08 09:59 <nicoe> But it is the easiest way to do it.
2008-08-08 09:59 <bch> nicoe: yes, by far
2008-08-08 09:59 <nicoe> I'm quite happy with this solution
2008-08-08 09:59 <bch> nicoe: maybe you were influenced by the way we where doing it in tryton before
2008-08-08 10:01 <CIA-54> tryton: uspallek roundup * #238/Avoid updating postgres template Databases: [chatting] Maybe its possible to solve this issue in case of failures with openERP or something else: Try to create a new Tryton database with tem ...
2008-08-08 10:02 <nicoe> bch: I doubt so because I did not look at tryton when working on relatorio v0.1
2008-08-08 10:02 <CIA-54> tryton: uspallek roundup * #238/Avoid updating postgres template Databases: See also chatlog from 2008-08-08 09:00 chat betwee gadaga and udono
2008-08-08 10:02 <nicoe> bch: when it was still included in ohxpd
2008-08-08 10:03 <bch> nicoe: yes ok
2008-08-08 10:06 <bch> udono: about the template db, i think that it would be good to check in tryton that the user don't try to alter system db. But providing a way to resolve the problem inside tryton is a bit too much. It's a erp not a db tools (but if you want you can create a db_tools module in tryton :), it's mean to be a framework anyway )
2008-08-08 10:08 <CIA-54> tryton: gadaga roundup * #239/UnboundLocalError: local variable 'ids' referenced before assignment: [new] Traceback (most recent call last): File "/trytond/netsvc.py", line 335, in run res = method(*msg[2:]) File "/trytond/web_service/wiz ...
2008-08-08 10:08 <udono> nicoe: great solution. Not this clean to mix controll and content, but unbeatable easy. And ${...} isn't use in any business documents.
2008-08-08 10:09 -!- gael_(n=gael@sednaco19320-gw.clients.easynet.fr) has joined #tryton
2008-08-08 10:09 <bch> nicoe: and of course the best thing would be to provide a way to choose
2008-08-08 10:09 <nicoe> udono: ${...} is only used for content, for control you still have to use text:a ...
2008-08-08 10:09 <gael_> udono: i rename template 1, and i create a new tempalte1 from template0. I can createdb from openerp and tryton but in create_db on tryton I have notice that he say "relation ir_cron doesn't exist"
2008-08-08 10:09 <udono> nicoe: yes, just avoiding that a tainted template is used and avoiding that the database name = template*
2008-08-08 10:09 <nicoe> bch: choose between what ?
2008-08-08 10:10 <bch> nicoe: ${} vs link vs placeholder :)
2008-08-08 10:11 <nicoe> bch: link vs placeholder it should be feasible ... but if link can do what ${...} does the reverse is not true.
2008-08-08 10:13 <bch> nicoe: the reverse is not true ... in ods i presume
2008-08-08 10:13 <udono> nicoe: don't understand the difference between ${...} and link?
2008-08-08 10:14 <nicoe> bch, udono : the reverse is not true everywhere
2008-08-08 10:14 <nicoe> brb
2008-08-08 10:14 <udono> nicoe: of course, the reverse of true is false...
2008-08-08 10:14 <udono> gael_: hi
2008-08-08 10:14 <gael_> udono: it's me gadaga :p
2008-08-08 10:15 <udono> gael_: :-)
2008-08-08 10:16 <udono> gael_: "relation ir_cron doesn't exist", I have no ideas...
2008-08-08 10:16 <udono> gael_: I created a new database, and there was not such an error...
2008-08-08 10:16 <gadaga> udono: i cant' install relationship module but i can install product
2008-08-08 10:17 <udono> gael_: you have a broken relationship module?
2008-08-08 10:17 <udono> gadaga:
2008-08-08 10:17 <nicoe> udono, bch: I'll thake an example: ${for each="toto in foo"} does not work
2008-08-08 10:17 <gadaga> udono: i pull the lastest version of hg represitory
2008-08-08 10:18 <bch> nicoe: and ${for toto in foo} ?
2008-08-08 10:19 <nicoe> bch: does not work
2008-08-08 10:19 <bch> nicoe: damn
2008-08-08 10:20 <nicoe> but ${len(function(foo))} works
2008-08-08 10:22 <nicoe> I do not see it as a problem since it forces you to seperate structure with variable
2008-08-08 10:22 <nicoe> moreover I added a check so that you are warned when the content of a text:a is different from the url in the text:a
2008-08-08 10:24 -!- Gedd(n=ged@ip-80-236-206-69.dsl.scarlet.be) has joined #tryton
2008-08-08 10:25 <CIA-54> tryton: Bertrand Chenal <bch@b2ck.com> default * 811:e08e383d5ae0 trytond/trytond/ir/translation.py: FIX: init ids to empty list
2008-08-08 10:26 <CIA-54> tryton: bch roundup * #239/UnboundLocalError: local variable 'ids' referenced before assignment: [testing] Should be fixed with changeset e08e383d5ae0
2008-08-08 10:27 <udono> gadaga: I did the same, no error: http://paste.pocoo.org/show/81586/
2008-08-08 10:27 <bch> gadaga: about the french translation, ced told me that made all the traductions (he had nothing else to do), i will push them when i will have a connection
2008-08-08 10:28 <udono> nicoe: the last test I dont like...
2008-08-08 10:28 <nicoe> udono, which test ?
2008-08-08 10:28 <udono> nicoe: a check so that you are warned when the content of a text:a is different from the url in the text:a
2008-08-08 10:28 <gadaga> bch: thanks relationship module works now
2008-08-08 10:29 <nicoe> udono: Why don't you like it, it is created so that you have to know what you are doing when you customize the content of the text:a
2008-08-08 10:31 <gadaga> udono: i retry to create a database and i have no error :) thx
2008-08-08 10:31 <udono> nicoe: Just to many possibilitys, but maybe you are right
2008-08-08 10:31 <udono> gadaga: what a luck, I can help you!
2008-08-08 10:32 <udono> nicoe: I am a fan of easy one way api, if you make things wrong -> fatal error
2008-08-08 10:33 <CIA-54> tryton: gadaga roundup * #239/UnboundLocalError: local variable 'ids' referenced before assignment: Fixed with changset e08e383d5ae0
2008-08-08 10:47 <udono> nicoe: the distiction between ${Tryton-variable} and link:genshi is ok for me. Because than we have to document only the tryton-variables. The genshi stuff is documented by gensh self...
2008-08-08 10:48 <udono> nicoe: but then could the privat protocol better genshi:// than relatorio... because you will earn the genshi requests from the users...
2008-08-08 10:54 <nicoe> udono: you're right
2008-08-08 10:56 <udono> nicoe: but its an openhex decision
2008-08-08 10:58 -!- markusleist(n=markus@212.14.79.210) has joined #tryton
2008-08-08 11:00 -!- b52laptop(n=b52lapto@41.249.250.195) has joined #tryton
2008-08-08 11:00 <b52laptop> morning
2008-08-08 11:08 <Timitos> b52laptop: hi
2008-08-08 11:09 <udono> b52laptop: hi
2008-08-08 11:10 <nicoe> hi
2008-08-08 11:34 <udono> afk
2008-08-08 12:56 <bch> nicoe: about the ${} stuff, it has a drawback: nothing prevent OOo to put tags inside ${}, it's a big problem in tiny because sometimes it's impossoble to fix inside OOo (the only solution is to erase and re-type)
2008-08-08 13:00 <nicoe> bch; Indeed. Using a specific tag avoids this but unfortunately placeholders works only in odt.
2008-08-08 13:01 <nicoe> On the other hand, I don't see how you can do variable interpolation without having this kind of problem.
2008-08-08 13:02 <bch> nicoe: yes, so we are back to the link vs placeholder discussion :)
2008-08-08 13:03 <nicoe> bch: If someone has a better idea than text:a I'm more then ready to adopt it.
2008-08-08 13:04 <bch> nicoe: for odt the best tag is placeholder :)
2008-08-08 13:04 <nicoe> But I'm afraid there is no better idea (that's what the guy from SUN told udono AFAIK)
2008-08-08 13:04 <nicoe> But relatorio is not only about odt
2008-08-08 13:05 <nicoe> Using an option to toggle between placholders and text:a is an option
2008-08-08 13:05 <bch> yes
2008-08-08 13:06 <nicoe> after all this is just a matter of selecting nodes
2008-08-08 13:06 <nicoe> But it would break the coherence ...
2008-08-08 13:07 <bch> nicoe: the cohence between different usages or in the code ?
2008-08-08 13:07 <nicoe> Moreover, the variable interpolation is present in genshi and it won't disappear so whatever the choice we do, the problem you talked about will appear
2008-08-08 13:08 <nicoe> coherence between different usages
2008-08-08 13:22 <udono> nicoe: yes there is no no other tag we can use in all openOffice applications he knows about, so he told me...
2008-08-08 13:23 <udono> nicoe: he= Sun guy
2008-08-08 13:24 <udono> nicoe, bch: but if you like to talk to him, he is on #dev.openoffice.org and called erAck
2008-08-08 13:36 -!- gadaga(n=gael@sednaco19320-gw.clients.easynet.fr) has joined #tryton
2008-08-08 13:56 -!- kultviech(n=kultviec@p549740D5.dip.t-dialin.net) has joined #tryton
2008-08-08 14:37 -!- ruijuan(n=rli@sednaco19320-gw.clients.easynet.fr) has joined #tryton
2008-08-08 14:37 <ruijuan> test
2008-08-08 14:37 <gadaga> ruijuan: hi ;)
2008-08-08 14:37 <ruijuan> hi
2008-08-08 14:37 <Timitos> ruijuan:hi
2008-08-08 14:39 <ruijuan> hi
2008-08-08 14:44 -!- bch`(n=user@user-85-201-14-207.tvcablenet.be) has joined #tryton
2008-08-08 14:44 -!- gadaga(n=gael@sednaco19320-gw.clients.easynet.fr) has joined #tryton
2008-08-08 14:45 <CIA-54> tryton: Timitos roundup * #240/cannot remove parent from accounttype: [new] don´t know if this is a feature. if i try to remove a parent from an account.type i get a message "write_xml_record" "xml_record_desc" ther ...
2008-08-08 14:46 <gadaga> bch: in currency, code and name has benn defined by an iso specification?
2008-08-08 14:46 -!- rli(n=rli@sednaco19320-gw.clients.easynet.fr) has joined #tryton
2008-08-08 14:48 <bch`> gadaga: no there is no constraint on the code field
2008-08-08 14:48 <bch`> gadaga: except for the size
2008-08-08 14:49 <bch`> gadaga: you where not talking about constraint but about the xml data ...
2008-08-08 14:49 <gadaga> bch: why for Dollar you choose $ and for Eur not € ? it's not logical
2008-08-08 14:50 <bch`> gadaga: i see $ and € here
2008-08-08 14:50 <Timitos> gadaga: i see € too :-)
2008-08-08 14:51 <gadaga> bch, Timitos : in symbol yes
2008-08-08 14:52 <rli> ¥ also
2008-08-08 14:52 <gadaga> rli: you can put it in configuration of currency
2008-08-08 14:54 <rli> yep but i need a tutorial ;)
2008-08-08 14:55 <gadaga> rli: have you look the wiki?
2008-08-08 14:55 <bch`> rli: take a look in currency/currency.xml the two last block
2008-08-08 15:00 <gadaga> bch: ok you use iso 4217 for the code currency
2008-08-08 15:00 <gadaga> bch`: why we don't use a selection for iso4217 codes?
2008-08-08 15:04 <rli> thanks
2008-08-08 15:05 <bch`> gadaga: i don't know, where did you found that the code are iso4217 ?
2008-08-08 15:05 <gadaga> bch`: http://www.iso.org/iso/fr/support/faqs/faqs_widely_used_standards/widely_used_standards_other/currency_codes/currency_codes_list-1.htm
2008-08-08 15:06 <gadaga> bch`: and here : http://fr.wikipedia.org/wiki/Codes_ISO_4217_des_monnaies
2008-08-08 15:07 <gadaga> bch`: we have the relation on name,code is this table
2008-08-08 15:08 <bch`> gadaga: one can imagine to define all the currencies in the xml
2008-08-08 15:09 <gadaga> bch`: yes it's a good idea no?
2008-08-08 15:09 <gadaga> bch`: field name in currency.currency is translatable?
2008-08-08 15:10 <bch`> gadaga: yes there is a little flag
2008-08-08 15:10 <gadaga> bch`: nice
2008-08-08 15:11 <gadaga> bch`: rli can make the xml if you want
2008-08-08 15:13 <bch`> gadaga: i was wondering about the symbols, but rli was able to type ¥ (that i just past) :)
2008-08-08 15:14 <bch`> gadaga: joke aside, it's not critical
2008-08-08 15:14 <gadaga> bch`: :p
2008-08-08 15:15 <gadaga> bch`: we can enter the symbol as an unicode?
2008-08-08 15:17 <bch`> gadaga: whe use unicode everywhere now, if it doesn't work we have to fix it
2008-08-08 15:20 <gadaga> bch`: ok rli try to make the xml
2008-08-08 15:20 <udono> gadaga: bch`: pycountry
2008-08-08 15:21 <udono> see issue235
2008-08-08 15:23 <gadaga> udono: good idea but pycountry don't give symbol
2008-08-08 15:25 <gadaga> udono: when will you implement it?
2008-08-08 15:26 <udono> gadaga: I think for this I am to newbee in python... so I do it next Year ...
2008-08-08 15:27 <udono> gadaga: but maybe its a nice addon module and dont need to be taken into the trytond...
2008-08-08 15:28 <udono> gadaga: I think the implementation needs some discussion...
2008-08-08 15:28 <gadaga> bch`: we can make the xml in first time and after implement pycountry?
2008-08-08 15:28 <gadaga> udono: i think too, but pycountry is a nice addons for trytond
2008-08-08 15:31 <bch`> the advantage of pycountry is on the long run, if the package is well updated it's a plus, if not an xml is enough. It's difficult to judge, pycountry seems very new.
2008-08-08 15:32 <udono> bch`: yes, its from beginning 2008, but for a first import it could be smart to use the debian knowledge.
2008-08-08 15:32 <udono> bch`: even I have some databases around for zip codes of germany and austria
2008-08-08 15:34 <bch`> udono: yes of course it's the easiest tool to generate the xml
2008-08-08 15:35 <udono> did you have official zipcodes for belgique
2008-08-08 15:35 <udono> ?
2008-08-08 15:35 <gadaga> bch`: we make the xml or standby?
2008-08-08 15:36 <bch`> udono: no, but maybe they are in openerp
2008-08-08 15:37 <udono> bch`: with what quality?
2008-08-08 15:37 <udono> bch`: maybe there is some official list provided by the government. Its more easy to maintain data from the same source...
2008-08-08 15:38 <bch`> gadaga: i was thinking about the country table in relationship
2008-08-08 15:40 <bch`> gadaga: but i don't think that we need a relation between the two table
2008-08-08 15:40 <udono> gadaga: I would like to provide via xml, because the data could be wrong or there are missing entrys. So I like to see that we can edit them like the way we do now.
2008-08-08 15:40 <bch`> udono: yes sure, iirc the one use by tiny comes from a friend of a friend and is not perfectly up-to-date
2008-08-08 15:44 <gadaga> bch`: i don't think that the relation between the two table is needed
2008-08-08 15:45 <udono> bch`: I have a xslt which process from a table like: Zip; City a tinyerp XML.
2008-08-08 15:45 <nicoe> udono: I believe you there is no problem
2008-08-08 16:15 <gadaga> bch`, udono : pycountry doesn't reconized code 'AFN' :( pycountry isn't completly compatible with iso 4217
2008-08-08 16:17 <udono> gadaga: what is AFN?
2008-08-08 16:19 <bch`> Afghani
2008-08-08 16:22 <gadaga> bch`: yep
2008-08-08 16:23 <gadaga> udono: in iso 4217 we have 239 codes
2008-08-08 16:23 <gadaga> udono: in pycountry we have only 183 codes
2008-08-08 16:24 <udono> gadaga: so we use iso4217 for the countrys, pycountry fot the states
2008-08-08 16:24 <udono> gadaga: and everything missing is a user problem
2008-08-08 16:27 <gadaga> udono: iso 4217 is only for currencies
2008-08-08 16:28 <udono> gadaga: ok, than we use currencies from iso
2008-08-08 16:31 <gadaga> bch`: I found currency symbol in unicode for iso 4217 codes ;)
2008-08-08 16:31 <gadaga> bch`: http://www.xe.com/symbols.php
2008-08-08 16:33 <bch`> ﷼ ₦ ₮ ден :)
2008-08-08 16:37 <gadaga> Php <- great symbol for pesos ;)
2008-08-08 18:08 <nicoe> bch, udono I just commited support for text:placeholder and an example of a ConTeXt template
2008-08-08 18:15 <udono> nicoe: we can parse latex?
2008-08-08 18:15 <nicoe> not LaTeX, ConTeXt ...
2008-08-08 18:16 <udono> nicoe: ok, I thought it is similar
2008-08-08 18:16 <nicoe> Bertrand told me it was a better replacement if all you want is generating pdfs
2008-08-08 18:17 <nicoe> It has been ages since I have done any LaTeX so, I could not really tell what are the differences (although creating tables was way more easy in LaTeX I think)
2008-08-08 18:35 <udono> nicoe: I am quite experienced in latex, but latex lacks of page control and summarizing in tables. Nearly impossible to make subtotals on page end and sum carried forward to the next page. But for ODT I have a solution for this...
2008-08-08 18:38 <nicoe> udono: This plugin is there so that people can do other stuff with relatorio than our needs.
2008-08-08 18:38 <nicoe> udono: The next plugin I would like to create is one outputting a graph from a set of data.
2008-08-08 18:38 <udono> nicoe: Is it possible to parse simple text files with this plugin?
2008-08-08 18:39 <nicoe> udono: Not with this plugin but with genshi's TextTemplate it is
2008-08-08 18:40 <nicoe> I should add simple example of those too.
2008-08-08 18:40 <udono> nicoe: because I have simple POS printer in the eye, they just understand text files 40 colums...
2008-08-08 18:41 <udono> nicoe: what about the graph, is it openoffice based?
2008-08-08 18:41 <nicoe> I'll create an example for you of a textemplate
2008-08-08 18:41 <nicoe> udono: don't know yet
2008-08-08 18:41 <nicoe> udono: I was thinking about gnuplot
2008-08-08 18:42 <udono> nicoe: ah ok, sounds interesting
2008-08-08 18:42 <nicoe> Or maybe another python library outputting svg (yet to be found)
2008-08-08 18:43 <udono> nicoe: did relatorio even connect to the other software and takes controll over the generation process, too?
2008-08-08 18:44 <udono> nicoe: or just generating the documents for other software?
2008-08-08 18:47 <nicoe> udono: for context I use the subprocess module to launch the required command and the I read the resulting file
2008-08-08 18:57 <udono> nicoe: ok, it seems better to divide the parsing and the handling into parts
2008-08-08 18:58 <nicoe> This is genshi principles: A template generates a stream of events that are then serialized by another object.
2008-08-08 18:59 <nicoe> for ConTeXt, the template is just a simple TextTemplate but the serializer do the call to the command
2008-08-08 20:22 -!- kultviech(n=kultviec@p549740D5.dip.t-dialin.net) has left #tryton
2008-08-08 20:55 -!- FWiesing(n=Wiesinge@194.208.185.12) has left #tryton
2008-08-08 21:28 -!- udono(n=udono@dynamic-unidsl-85-197-20-120.westend.de) has joined #tryton
2008-08-08 21:37 -!- Timitos(n=Timitos@88.217.184.172) has joined #tryton
2008-08-08 22:18 -!- udono(n=udono@dynamic-unidsl-85-197-20-120.westend.de) has left #tryton
2008-08-08 22:51 <CIA-54> tryton: htgoebel roundup * #232/Improvement of condition syntax: Why not use normal python expressions here? The example in msg893 is not readable anymore. Python already includes a parser, implementing a walke ...
2008-08-08 23:30 -!- kultviech(n=kultviec@p5B0D18F0.dip0.t-ipconnect.de) has joined #tryton
2008-08-08 23:33 -!- kultviech(n=kultviec@p5B0D18F0.dip0.t-ipconnect.de) has left #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!