IRC logs of #tryton for Tuesday, 2009-01-06 #tryton log beginning Tue Jan 6 00:00:02 CET 2009
-!- mmarshall( has joined #tryton01:13
-!- gremly(n=gremly@ has joined #tryton04:13
-!- yangoon( has joined #tryton05:20
-!- sharkcz( has joined #tryton07:56
-!- vengfulsquirrel( has joined #tryton08:16
-!- sharkcz( has joined #tryton09:03
-!- Timitos(n=Timitos@ has joined #tryton09:35
-!- bechamel(n=user@ has joined #tryton10:09
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton10:22
-!- oversize( has joined #tryton10:27
-!- carlos( has joined #tryton11:28
-!- Guest85123( has joined #tryton11:28
-!- carlos_( has joined #tryton11:29
CIA-8tryton: Timitos roundup * #728/order_field for party seems not to work: [new] if i open my list of parties they are ordered from Z-A. I do not find a reason for this as they normally should be orders by field code as i ...11:54
CIA-8tryton: Timitos roundup * #727/res = self.cursor.execute(sql, params): Sounds good for a developer but not for a user. Perhaps we should extend all error messages with information for normal users. In this case: "Y ...11:57
CIA-8tryton: ced roundup * #727/res = self.cursor.execute(sql, params): This exception can happen with other action than delete.12:01
-!- cristi_an(i=5978d3ce@gateway/web/ajax/ has joined #tryton12:07
-!- udono( has joined #tryton12:29
CIA-8tryton: udono roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: [new] In invoice.taxes there is only the 'description' attribute available for taxes but in Germany we need the 'name' attribute on invoices (the ...12:35
CIA-8tryton: Timitos roundup * #727/res = self.cursor.execute(sql, params): what about: "Your action cannot be applied! Details: Integrity Error: You try to bypass a constraint!"12:46
CIA-8tryton: C?dric Krier <> default * 1065:22163b221293 tryton/CHANGELOG: Prepare changelog for release 1.0.212:47
CIA-8tryton: C?dric Krier <> default * 1066:d93e10703e0b tryton/.hgtags: Added tag 1.0.2 for changeset 22163b22129312:47
CIA-8tryton: ced roundup * #727/res = self.cursor.execute(sql, params): For me when you have an error message, it is clear that the action you try to perform failed.12:53
CIA-8tryton: Timitos roundup * #727/res = self.cursor.execute(sql, params): you are a developer. but i think we should take care of normal user with no knowledge of the word "constraint" i think that "you try to bypass a ...12:57
-!- carlos_( has joined #tryton13:17
-!- CIA-9(n=CIA@ has joined #tryton13:31
CIA-9tryton: C?dric Krier <> default * 321:4b36adcce0b6 account/ Increase version number13:31
CIA-9tryton: C?dric Krier <> default * 322:ef3592e4a6bd account/COPYRIGHT: Update copyright13:33
CIA-9tryton: C?dric Krier <> default * 201:0a8d0b122066 account_invoice/CHANGELOG: Prepare changelog for release 1.0.213:35
CIA-9tryton: C?dric Krier <> default * 202:d1e1cd4cad65 account_invoice/.hgtags: Added tag 1.0.2 for changeset 0a8d0b12206613:35
CIA-9tryton: C?dric Krier <> default * 203:b6dbe84274ec account_invoice/ Increase version number13:39
CIA-9tryton: C?dric Krier <> default * 101:41226a464bf4 company/CHANGELOG: Prepare changelog for release 1.0.213:43
CIA-9tryton: C?dric Krier <> default * 102:e5dc21a3f77c company/.hgtags: Added tag 1.0.2 for changeset 41226a464bf413:43
CIA-9tryton: C?dric Krier <> default * 103:bf441d2495da company/ Increase version number13:43
CIA-9tryton: C?dric Krier <> default * 208:b12e15da90af party/CHANGELOG: Prepare changelog for release 1.0.213:45
CIA-9tryton: C?dric Krier <> default * 209:693bd695a188 party/.hgtags: Added tag 1.0.2 for changeset b12e15da90af13:45
CIA-9tryton: C?dric Krier <> default * 210:9de83a8c9496 party/ Increase version number13:46
CIA-9tryton: C?dric Krier <> default * 165:4c01a8a1e35f purchase/CHANGELOG: Prepare changelog for release 1.0.213:47
CIA-9tryton: C?dric Krier <> default * 166:8c7911cdab1b purchase/.hgtags: Added tag 1.0.2 for changeset 4c01a8a1e35f13:47
CIA-9tryton: C?dric Krier <> default * 167:4c2e0f391d89 purchase/ Increase version number13:48
CIA-9tryton: C?dric Krier <> default * 72:10675c9bedad sale/CHANGELOG: Prepare changelog for release 1.0.213:49
CIA-9tryton: C?dric Krier <> default * 73:0fd91b142a2c sale/.hgtags: Added tag 1.0.2 for changeset 10675c9bedad13:49
CIA-9tryton: C?dric Krier <> default * 74:410377268494 sale/ Increase version number13:50
CIA-9tryton: C?dric Krier <> default * 387:00f417866b68 stock/CHANGELOG: Prepare changelog for release 1.0.213:52
CIA-9tryton: C?dric Krier <> default * 388:44e41ba4022e stock/.hgtags: Added tag 1.0.2 for changeset 00f417866b6813:52
CIA-9tryton: C?dric Krier <> default * 389:e3397483b304 stock/ Increase version number13:53
-!- ikks(n=igor@ has joined #tryton14:16
CIA-9tryton: C?dric Krier <> default * 160:c37e817216f3 gentoo-overlay/app-office/tryton/ (Manifest tryton-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 161:87db47ce57e8 gentoo-overlay/app-office/trytond/ (Manifest trytond-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 162:3ba73ee6b784 gentoo-overlay/app-tryton/account/ (Manifest account-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 163:1ed2560d4928 gentoo-overlay/app-tryton/account_invoice/ (Manifest account_invoice-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 164:ffb6b09f8789 gentoo-overlay/app-tryton/company/ (Manifest company-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 165:ca2e518189fc gentoo-overlay/app-tryton/party/ (Manifest party-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 166:1567493aec07 gentoo-overlay/app-tryton/purchase/ (Manifest purchase-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 167:f396cec4b8f8 gentoo-overlay/app-tryton/sale/ (Manifest sale-1.0.2.ebuild): Version bump14:22
CIA-9tryton: C?dric Krier <> default * 168:43472fbd5919 gentoo-overlay/app-tryton/stock/ (Manifest stock-1.0.2.ebuild): Version bump14:22
-!- Gedd( has joined #tryton14:33
CIA-9tryton: C?dric Krier <> default * 252:79a16b50a0ce website/ (7 files in 5 dirs): Add news14:43
CIA-9tryton: C?dric Krier <> default * 253:d4d78d9b2333 website/locale/de_DE/LC_MESSAGES/tryton.po: merge14:43
-!- carlos( has joined #tryton15:13
CIA-9tryton: * r413 /wiki/ Add app-tryton category15:14
CIA-9tryton: ced roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: [need-eg] Why do you need two different field to distinct taxes? What we had now is more powerful than your solution, we can group different taxes ...15:18
CIA-9tryton: ced roundup * #728/order_field for party seems not to work: [resolved] It is not a bug as the order is set to DESC. With this you had the latest party on top.15:22
CIA-9tryton: matb roundup * #730/UndefinedError: 1 has no member named "full_name": [new] When printing invoices (different updated databases) Traceback (most recent call last): File "/trytond/", line 282, in run r ...15:40
CIA-9tryton: Timitos roundup * #731/UndefinedError: 1 has no member named "full_name": [new] Traceback (most recent call last): File "/trytond/", line 282, in run res = method(*msg[2:]) File "/trytond/web_service/rep ...15:41
CIA-9tryton: Timitos roundup * #731/UndefinedError: 1 has no member named "full_name": [chatting] tried to print an invoice report in a completely new db. only account_invoice installed.15:42
CIA-9tryton: Timitos roundup * #731/UndefinedError: 1 has no member named "full_name": [resolved] same issue as issue 73015:44
CIA-9tryton: ced roundup * #730/UndefinedError: 1 has no member named "full_name": [testing] Please update your party module.15:58
-!- enlightx( has joined #tryton15:59
CIA-9tryton: Timitos roundup * #730/UndefinedError: 1 has no member named "full_name": for me no change after the update. i updated with trytond -d db -u party16:02
CIA-9tryton: udono roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: yangoon, timitos and me are planning on this, now. I think we need a little different solution. Maybe it is just to have a code field on taxes (no ...16:08
-!- cristi_an(i=5978d3ce@gateway/web/ajax/ has joined #tryton16:21
cristi_ani had a presentation today of the current version of tryton16:25
Timitoscristi_an: nice16:27
udonocristi_an: sounds good. And did you answered all the questions?16:27
cristi_anit is a firm that has 2 companies : one with 2 warehouses and 4 shops (commerce all kind)  and the other 1 warehouse and 6 shops (mobile phones+ stuff)16:28
cristi_anthey were very very impressed by how it looks ,how fast it was16:28
cristi_ani tried to respond with yes to every question :)16:29
cristi_anand sure ,and of course ...:)16:29
cristi_anso they would really want to do with this....but i need to adapt it16:30
cristi_anto custom needs16:31
cristi_anso in cases like this .... how is suposed to be done...16:31
cristi_ani may create extra modules16:31
cristi_anextedn some existing ones ?16:31
Timitoscrisit_an: i think there won´t be any project where no customization would be needed. you have always to do some customizing16:32
cristi_anreally ?16:32
Timitoscristi_an: yes. the right way is creating modules16:32
cristi_anand where you put your modules16:32
cristi_anon branch or you keep those private16:32
Timitoscristi_an: in the moment we are working on some modules. if they are ready we will publish on intuxication for feedback and optimization. perhaps some of them will taken into base but i don´t know yet.16:33
cristi_ani see so you have some unpublished code yet16:34
CIA-9tryton: udono roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: [resolved] I close this feature request, because we write an addon module for this.16:36
CIA-9tryton: ced roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: [chatting] So you must set two taxes with two different descriptions: - 19% VAT - 7% VAT The field name is for internal use (like putting suppli ...16:36
CIA-9tryton: C?dric Krier <> default * 1445:1ec74e31d8f3 trytond/trytond/osv/
CIA-9tryton: Fix the prefetching of fields in BrowseRecord for issue730 and improve it to16:38
CIA-9tryton: prevent to read twice the same field.16:38
CIA-9tryton: ced roundup * #730/UndefinedError: 1 has no member named "full_name": [resolved] Fix with changeset 1ec74e31d8f316:39
-!- cristi_an(n=cristi@ has joined #tryton16:43
cristi_ani was disconnected16:44
cristi_anhowever,i do not know how this it supposed to work16:45
Timitoscristi_an: what?16:45
cristi_anmay i create a site where to put a version of a demo that will be translated in romanian16:45
cristi_ana site that is translated into romanian16:45
CIA-9tryton: matb roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: [chatting] @ced: We need for Germany exact identifaction of the taxes used. There are those descriptions like: "Steuerfreie Ausfuhrlieferung und d ...16:46
cristi_anwhat kind of license tryton has ?16:46
Timitoscristi_an: GPLv316:46
cristi_anthat means free16:46
cristi_anlet me google it16:47
cedkcristi_an: translate juste this file:
Timitoscristi_an: you find the LICENSE in those LICENSE files of the modules16:47
cristi_ancedk: only that file ?16:49
cristi_an+ how to tranlsate  thing that is on wiki16:49
cristi_anor you mean for the site ?16:50
Timitoscristi_an: this way you can translate the website for romania16:50
Timitoscristi_an: you also need to translate the client and the modules to romanian16:51
Timitoscristi_an: this is on the wiki yes16:51
cristi_annow i have some more tech questions16:52
cristi_anthis firm has like 5000 -10000 invoices / month16:53
cristi_anthat means like 300000 - 600000 invoice details (products) / month16:53
cristi_anafter 1,2 years....16:54
cristi_anhow tryton will behave...16:54
cristi_ani ask this since i have no clue how ORM works behind16:54
yangoon cedk: could you please have a look at ? It is currently a showstopper for new modules containing (inherited) reports and I am not able to prepare translations for such modules.16:55
Timitoscristi_an: for performance i think the most important thing is a powerful hardware for the postgresql db. this is the bottle neck16:55
cristi_anTimitos: that is the black box for me yet16:56
Timitoscristi_an: i think you should write test module which fills a db with such a number of record. then you can test the behavior16:56
cristi_anTimitos: that is a good ideea16:57
Timitoscristi_an: its like a stress test of tryton.16:57
cristi_anbut i want to find out how orm works as well16:57
cristi_anfor example i want to display all the invoices from 200816:57
cristi_anthere will be like 60000 invoices16:57
cristi_ani hope that the orm will not make 60000 calls to DB to get for each invoice the party16:58
Timitoscristi_an: this is a question for cedk or bechamel.17:00
bechamelcristi_an: has udono told you yesterday, you can have a first clue with the list of translation on the demo server17:00
cristi_anbechamel: that is a nice piece of code and i tested it17:01
bechamelcristi_an: there are more than 12000 records on this table17:01
cristi_anbechamel: i noticed that those are retrived by scrolling17:02
cristi_anlike a pagination17:02
bechamelcristi_an: and from here the list is open in 3sec17:02
cristi_anok but that list has references to other objects17:02
cristi_anand invoice has reference to party object17:03
cristi_anmy question is ORM you an sql like select * from invoices,party where = party.party17:03
cristi_anor for each invoice calls getPArty or so17:03
udonocristi_an: for this amount of account moves I would propose some tests with a lot of data.17:04
cristi_anbechamel: but ORM how it works behind the scence ?17:06
bechamelcristi_an: the orm never call one line at time, the worst situation is one call by column (i.e all party for the invoices are fetch in one query, except for  big list, in this case only sublist are fetched)17:06
bechamelthe only piece of code that doenst use lists, are the workflow stuff, because the workflow must be evaluated for each record17:07
cristi_ani have no clue what that is :)17:08
cristi_anbut slowly i will17:08
udonocristi_an: I found some interesting comments on open_erp about the generals of being a consultant:
cristi_ani will read it17:09
cristi_anrvalyi is a good guy17:09
-!- drcode(i=c7cbb864@gateway/web/ajax/ has joined #tryton17:11
cristi_anbechamel: not sure i understood your above explination but  for a certain situation like i described before how orm proceeds ? (assume i want to see on the client side invoice for 2008)17:11
cristi_anthis may be resolved in 1 query agree17:12
cristi_an1 db call17:12
cristi_anselect * from invoices,party where data>2008 data<200917:12
bechamelcristi_an: no, if it send all the data in one bunch it will kill your server, the network and the client :)17:13
cristi_aneven on a local network ?17:13
cristi_an300000 results may come in less then a second17:13
bechamelcristi_an: actualy all the invoice ids are sent, then the client ask for data for all the ids that are shown17:14
cristi_anand you ask for like firs 100 ids's17:14
cristi_anthen the next ones17:14
cristi_andependign as the user scrolls17:15
CIA-9tryton: ced roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: [chatting] Don't understand, you need this description where?17:15
bechamelso when you scroll the client ask the server for new data (if not already in the cahce)17:15
cristi_anbechamel:but for the data that arrived on client let's say for the first 10017:15
bechamelcristi_an: actualy i don't see why and how a user want to look at 60000 at the same time17:16
cristi_anbechamel: what is the operation that is done on server17:16
cristi_anbechamel: maybe is not the persfect sample,what if he want to print a report ? with all 6000017:16
bechamelcristi_an: it's different for reports, odt are generated on the server side and all is sent to the client17:18
bechamelcristi_an: all the odt i mean17:18
cristi_anand there is 1 db call ?17:19
cristi_anfor getting that odt ?17:19
-!- drcode(i=c7cbb864@gateway/web/ajax/ has left #tryton17:21
CIA-9tryton: Timitos roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: if is for internal use why is it used in invoice report on invoice line? we noticed that would be to long for some german issues ...17:22
cristi_anTimitos: does your firm have a site ?17:22
bechamelcristi_an: it depens for each report, but often there is more than one call17:22
CIA-9tryton: matb roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: This description is needed somewhere on the invoice to explain, which tax exactly was used on the relative lines. In the example in msg2684 by ud ...17:23
cristi_anbechamel: i am asking this because i would like to implement to this firm tryton,but i can rely on a black box17:23
Timitoscristi_an: (basic one in german) a more powerful site will follow in the beginning of march17:24
cristi_anwho know maybe you and cedk receive some big offer from google17:24
cristi_anand forget about tryton17:24
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton17:24
cristi_anthat is why core is better to be known by more then 2 persons17:25
cristi_anTimitos: thx ...try to see how a consultant site looks like17:26
Timitoscristi_an: as i only had 1,5 days for text and layout you should not take this site as a good example ;-)17:27
cristi_anfor beggining will be more then enough17:27
cristi_ani thought using Joomla17:27
bechamelcristi_an: it's not blackbox, it's opensource :)17:28
cristi_anwhat is used for the tryton site ?17:28
cristi_anbechamel: it is in this moment :)17:28
ikkscristi_an sphinx17:28
ikksjoomla is really vulnerable...17:28
ikksAvoid it as much as you can.17:28
cristi_anwell it is only an option17:28
cristi_ani did not had time to use it yet17:29
cristi_anikks: is sphinx python related ? or django is better ?17:29
bechamelcristi_an: the website is also a mercurial repos:
ikkscristi_an django is not a CMS17:29
cristi_anpfff i wish i had 3 heads and like 6 hands :)17:29
Timitoscristi_an: this is always the same when you begin a new business17:30
cristi_anto build a site,learn the core,also the client17:30
cristi_anTimitos: thx for encouraging me17:30
ikksACTION loves django17:30
cristi_anthe bad news is that i have to adapt tryton (create romanian modules until 1 may)17:31
cristi_anwonder if i can do that.....17:31
cristi_analso i neeed the FIFO stuff17:31
Timitosenlightx: did you take a look on relatorio?17:35
Timitosenlightx: i think this could be interesting for you. tryton uses relatorio17:35
enlightxTimitos: yes of course, it sounds nice17:35
enlightxTimitos: i'm already working on tryton17:35
enlightxi translated the website and i'm translating the software17:36
udonocristi_an: Maybe I would start with translation of client/server/modules. With this you get an impression of the whole functionality of tryton in detail and you have it translated.17:36
Timitosenlightx: great17:36
cristi_anudono: sure but that is the easiest part :)17:39
cristi_anthe hardcore is coming ....17:39
cristi_anTimitos: "Anbindung anderer Anwendungen über XML-RPC"17:40
cristi_anis not NET-RPC ?17:40
Timitoscristi_an: you can also use net-rpc. but as i wrote this is hadn´t done an example with net-rpc. so i wrote xml-rpc17:40
udononetrpc is just zipped xmlrpc, AFAIK17:41
udonoor not?17:41
udonoBTW did someone try out the dev script ?17:42
cristi_ani did17:42
udonofor me it produces an error17:42
cristi_anwith timitos's help17:42
cristi_anand we had to adjust some things there17:42
cristi_anit did not work correctly17:43
yangoonudono: what error?17:43
cristi_anTimitos: where you can set the protocol used ? net rpc or xml rpc17:43
udonocristi_an: Tryton chooses the best avail. self17:45
udonobut in /etc/trytond you can setup17:45
cristi_anself ???17:46
CIA-9tryton: C?dric Krier <> default * 246:6ca33c867a13 account_invoice/invoice.odt: Use tax description instead of name on invoice line for issue72917:46
CIA-9tryton: C?dric Krier <> default * 204:581a5e1d7e37 account_invoice/invoice.odt: Use tax description instead of name on invoice line for issue72917:46
CIA-9tryton: C?dric Krier <> default * 205:8b64aff4406a account_invoice/COPYRIGHT: Update copyright17:47
CIA-9tryton: C?dric Krier <> default * 247:b8564861d19c account_invoice/COPYRIGHT: Update copyright17:48
udonocristi_an: yes, the client choose the most quick protocol. And the server provides the protocol you specify17:48
CIA-9tryton: ced roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: It was a issue fixed with changeset 6ca33c867a1317:48
Timitoscristi_an: normaly tryton uses net-rpc. but you can also activate xml-rpc in trytond.conf if you want to use it17:48
cristi_anwhere in administration ? in local server ?17:50
udonocristi_an: yes, do not use the demo server for real things, cos it is reseted every night17:51
CIA-9tryton: ced roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: I think that we can perhaps make something. We could remove the print of taxes on invoice line and replace it by just a number that refers to the ...17:51
cristi_anok but later my translation maybe be ported to the default database17:52
cristi_anskip "?"17:52
Timitoscristi_an: you only need to put the translations on bug tracker and they will be put into the repositories17:53
cristi_anin what format ?17:54
cristi_anexported from database17:54
udonocristi_an: see Administration > localisation17:55
udonoyangoon: do you have an idea?17:56
yangoonudono: just testing17:56
yangoonudono: I get the same error17:57
udonook, Then the pagelayout may have changed17:57
yangoonudono: there must be some change on the website since it worked last time17:57
udonoyangoon: :-)17:58
udonoyangoon: I take a look if I find the error17:58
yangoonudono: there was at least in css..., perhaps more17:58
yangoonudono: porbably the link uppermost to the right17:59
yangoonudono: grep -v -E '(Mercurial|zip|gz|bz2|Atom|RSS|Name|Description|Contact|Last change|^$)'\ does the tric, but I can't get along with Repostories list18:12
cedkudono, yangoon: fixed18:15
udonocedk: yes, thanks, I hate sed18:16
yangooncedk: I get nevertheless abort: '' does not appear to be an hg repository!18:18
udonocedk: yangoon: I get an abort: HTTP Error 400: Bad Request18:18
cristi_anin time the db increase in size and that may cause the db to respond slower , is there something against this ?18:19
udonocristi_an: autovacuum18:19
cristi_ani meant what countrer measures may be applied for this18:19
cristi_andelete data ?18:19
cristi_anjust like that ?18:19
udonocristi_an: google for autovakuum and postgres18:20
udonocristi_an: it is final deleting deleted data and cleanup18:20
cristi_anthat will help ?18:21
cristi_anthat does not help too much i think18:21
cristi_ansome module will be needed maybe18:21
-!- CIA-8(n=CIA@ has joined #tryton18:22
cristi_anto delete old moves and to place then is some special stastistical tables or so18:22
udonocristi_an: autovakuum resolve the most speed problems in postgres AFAIK.18:22
udonocristi_an: EXPLAIN ANALYZE help to find out where the long querys are.18:23
cristi_anudono: w8 i am not asking that kind of optimization18:24
udonocristi_an: so what?18:24
cristi_anmaybe you are right for that part i just wonder that any system is better to keep transcational tables as small as possible18:24
cristi_animagine the system after 4 years18:24
cristi_anof usage18:24
udonocristi_an: tell it ebay, and they will lol18:24
cristi_anwhat about ebay ?18:25
udonocristi_an: a lot of transactions per second18:25
cristi_anhow do you know how big is their transactional table18:26
cristi_ando you think that they have in one table all the bids since ebay started ?18:26
cristi_ani doubt that18:26
udonocristi_an: I don't know, but I imagine they archive. But about achiving we can't talk in a year, I think. Because you need your data of the running year persistent.18:27
cristi_ani am talking about the data of a closed year18:28
cristi_anmaybe a module that puts that is some separate table is welcomed18:29
cristi_anor data warehousing18:29
udonocristi_an: maybe a solution...18:31
-!- CIA-8(n=CIA@ has joined #tryton18:31
cristi_anwe can think better on that in a year or so :)18:31
cedkcristi_an: for stock move we think about having some kind of period18:40
cedkand we will do like for fiscalyear closed18:40
cristi_angood thinking18:42
cedkand so with a index, there will be no performence issue18:42
cedkand if the table become to be very big, you can still delete the oldest move18:43
cristi_anmaybe later i will understant 100% what you just said18:45
cristi_anbut as big picture it seems ok for me18:45
cristi_ani forgot to ask something......VIP for me :)18:48
cristi_anserver is running on windows ?18:48
cedkcristi_an: you can if you install all the python environement18:49
cedkcristi_an: but we don't recomend it18:49
cristi_anwhy is that ?18:49
Timitoscristi_an: i tried this a few month ago. it works but i also would not recommend it18:49
Timitoscristi_an: there is not enough testing for trytond on windows. and some things could be more difficult to implement i think. for the best possibilities to extend tryton in future i would recommend to use linux for the server18:51
cristi_anin theory it should work no ?18:52
cristi_ansince pyton is like java18:52
cristi_andoes not matter the OS18:52
CIA-8tryton: Mathias Behrle <> default * 1446:f692a21b7a55 trytond/trytond/ (4 files in 4 dirs): Update translation for de_DE18:53
CIA-8tryton: Mathias Behrle <> default * 364:8261f411d11b account/de_DE.csv: Update translation for de_DE18:53
cedkcristi_an: there is some OS depend stuffs but it will work18:53
Timitoscristi_an: yes. i had tryton server running on windows. but there are some packages that work a little different on windows. and so there is a danger that some things might not work18:53
CIA-8tryton: Mathias Behrle <> default * 111:cf639722c16f account_statement/de_DE.csv: Update translation for de_DE18:54
cristi_anwhich one are problematic ?18:54
CIA-8tryton: Mathias Behrle <> default * 57:323e46922d68 analytic_account/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 26:8c54187ba6f9 analytic_sale/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 27:aec7e81704e0 analytic_sale/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 119:ca16cf0e43e7 company/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 20:393a166896f2 country/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 54:3662cca32983 currency/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 222:d0ef96ab6523 party/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 126:0bcdc136d5c5 product/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 40:d27146e2eddd project/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 23:77f3d57cd0da project_revenue/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 203:3b82b169862e purchase/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 99:e35591427ea8 sale/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 414:4e8485dd685d stock/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 153:9962bb9ba876 stock_supply/de_DE.csv: Update translation for de_DE18:54
CIA-8tryton: Mathias Behrle <> default * 60:62ad3777c1a6 timesheet/de_DE.csv: Update translation for de_DE18:54
cedkcristi_an: I don't recommend it, not because there is not enough test but because windows is not a enough reliable OS18:55
CIA-8tryton: Mathias Behrle <> default * 248:8bb23b9d41d3 account_invoice/de_DE.csv: Update translation for de_DE18:55
CIA-8tryton: Mathias Behrle <> default * 249:0bd23ac33e05 account_invoice/: merge18:55
cristi_anok i belive you and is enough for me linux but i do not agree "windows is not a enough reliable OS"18:56
cristi_anit's python;s problem18:56
cristi_annot OS18:56
cedkcristi_an: for critical stuff like an ERP, you must have an OS that runs for months with needed to reboot18:57
cedkudono: now must work18:58
cedkcristi_an: he yes without reboot18:58
cedkcristi_an: I know to much place where people finish by making a script to reboot windows server each night18:58
cristi_anwell i asked not for production use18:59
cristi_ani aske more for development use18:59
cristi_anbut i will get used with linux19:00
cedkthey add a certificate for modules19:00
cristi_anmeaning ?19:00
cedkcristi_an: but you are free to use it on windows19:00
cedkcristi_an: I just not recommend it19:01
cristi_ani got you point very well19:01
cedkcristi_an: by the way you need also to manage postgresql on windows19:02
cristi_anthat work well19:02
yangooncedk: for me it works, but I am really wondering, why the same exclusion string didn't when I used it (Repositories list)19:03
CIA-8tryton: C?dric Krier <> default * 365:077f12e8fa91 account/ ( account.xml): Add complete_name on account type and use it in list view19:06
CIA-8tryton: C?dric Krier <> default * 366:70f4355f530c account/COPYRIGHT: Update copyright19:06
CIA-8tryton: C?dric Krier <> default * 367:271134c87bcf account/: merge19:06
udonocedk: is working fine, thank you19:06
udonocedk: about its not a bad idea. But for openERP it is much more important then for tryton, since you can install anything via the GUI in OERP...19:07
udonocedk: another thing could be providing checksums for the packages, to be sure they are complete and not modified19:08
CIA-8tryton: matb roundup * #729/Invoice Report: Missing name attribute in invoice.taxes: @ced: great, exactly what is needed19:10
bechameludono: i understand the usefulness of the checksum (even if  hg head would the trick), but i don't see the use of the "certificate"  (which is just a number if i read correctly)19:10
CIA-8tryton: C?dric Krier <> default * 1447:4e163c0d3e5a trytond/trytond/ir/ Use en_US order for translation export19:11
cedkand checksum is only for python installation, so it must be handle by the package manager19:13
-!- bch(n=user@ has joined #tryton19:20
cedkcertificate looks like that:
cedkvery strange19:25
udonocedk: bechamel: hm, I don't understand their aim, too19:26
cedkudono: they put it on all modules
cedkudono: it must be something like the maintenance contract in the base module19:32
udonocedk: maybe they use it to identify the original modules and changes. But the certificate looks not like a certificate19:32
bechamelmaybe one can ask the question on the openerp forum :)19:33
cedkudono: it is just a number with modulo 97 == 2919:33
cedkfor real certificate, they need to use some real crypto19:34
cedkbechamel: I will ask on IRC19:35
cristi_anwhat is fuzzy ?19:50
cristi_anon translations ?19:50
cedkcristi_an: it is when there is little change in the source19:51
yangooncristi_an: check, if the translation is still correct and the uncheck the field19:52
cedkcristi_an: the system detect that there is some little change in the source string so you must check if the translation is still correct19:53
cedkit is like the fuzzy tags in gettext19:53
cristi_ani see19:55
cristi_ancedk: locally i may override the english translation and navigate from one to another20:03
cristi_anwht happes a new record is cretated for the language i will specify ?20:04
cristi_ansince english is set as not translatable ?20:04
cristi_ani updated an english translation to romanian and it created a new item in romanian20:05
cristi_anthat seems to be good for speeding up things20:05
cristi_anbechamel: what are record rules ?20:14
-!- bechamel(n=user@ has joined #tryton20:14
cristi_anwhat is account statement module does ?20:30
cristi_anbechamel: are you here ?20:45
-!- enlightx_( has joined #tryton21:04
cristi_andoes someone knows how to use postgresql autodoc ?21:12
ikksit generates a .dot file21:13
ikksyou can look at it with dotty21:14
ikkspostgresql_autodoc --help21:14
ikksto get you started21:14
ikksit also generates .dia files21:15
ikksapt-get install dia21:15
ikksand look at the dia files21:15
cristi_anthank you...21:15
cristi_anikks: you are from columbia21:15
ikksno Columbia, Colombia with o ;)21:16
cristi_anin Romanian si Columbia :)21:16
ikksThe south american country not the north american state21:16
ikksoh, Rumania or Romania?21:16
cristi_anPablo Escobar21:17
ikksI see, here they call your country Rumania.21:17
ikksBut I prefer to call the country the way you call it.21:17
ikkssadly yes, Pablo Escobar and many others :(21:18
cristi_ani know a lot of football players from Colombia21:19
cristi_anyou had a good team21:19
cristi_annowsays...not that good21:19
cristi_anikks: Producing test.dia from /usr/share/postgresql-autodoc/postgresql_autodoc/dia.tmpl21:30
cristi_anCan't open test.dia: Permission denied at /usr/bin/postgresql_autodoc line 1620, <STDIN> line 1.21:30
Timitoscristi_an: do you want to create a view of the tables of tryton?21:43
Timitoscristi_an: perhaps i have a hint for you21:43
cristi_anTimitos: plz21:44
cristi_anthe diagram21:44
cristi_ani would like to create and21:44
cristi_anEntity Relation Diagram (ER)21:44
Timitoscristi_an: look in tryton at Administration -> Models -> Models21:44
Timitoschoose a model and create a 'Graph'21:44
TimitosThis will make the same i think21:44
Timitosmake it the tryton way ;-)21:45
cristi_anTimitos: how can i create a graph ?21:46
cristi_ani am there models models21:47
Timitoslook below. there should be a report21:47
Timitoscristi_an: ups. perhaps this is only available on dev version21:47
cristi_andev version ?21:48
-!- juanfer(n=juanfer@ has joined #tryton21:49
ikkswrong channel :P21:50
cristi_anikks: i cant generate with that command :(21:50
ikkscristi_an I bet you know more soccer Colombian players than me :D21:50
cristi_anikks: maybe :)21:50
ikkscristi_an copy paste the exact command you ran21:50
cristi_anyou have famous singers as well21:51
cristi_anpostgresql_autodoc -d test -s test221:51
cristi_anikks:  i may paste the pgAdmin21:53
cristi_ando you know where i can find paste a pic ?21:54
cristi_anok is working now22:02
cristi_anbut unreadable22:02
ikkscristi_an and the exact error is?22:02
cristi_anthe dia22:02
cristi_ani mean is a very ugly picture22:02
ikkssure :)22:02
cristi_anall tables are one uopn the other22:02
ikksthe use dotty to look at the .dot22:02
ikksthe .dot is read only, and usually looks more beautiful, but not readable at all.22:03
cristi_andotty ?22:03
cristi_anshoudl i install that as well22:04
ikksapt-get install graphviz22:04
ikksthat would install dotty, you are blessed with a deb powered distro22:05
cristi_anthis is Dia22:05
-!- bechamel(n=user@ has joined #tryton22:11
ikksnope, graphviz a powerful tool22:11
ikksdia is nice too, but don't hesitate to visit graphviz, you'll be amazed22:12
ikksI hope ;)22:12
cristi_anwell i am not :)22:14
cristi_an dotty test2.dot22:14
cristi_anand opens a window that freeze22:15
cristi_anare you here ?22:20
-!- bechamel`(n=user@ has joined #tryton22:20
ikkscristi_an strange that the window is freezed22:23
ikksdia results a lot slower than dotty22:23
cristi_anand i can even close it22:24
CIA-8tryton: C?dric Krier <> default * 223:a4829e694409 party/ Remove state on function field and fix guidelines22:37
CIA-8tryton: C?dric Krier <> default * 224:7428923070c3 party/COPYRIGHT: Update copyright22:37
cristi_ancedk: i saw that in the database are kept in ir table all the fields db has22:41
cristi_anand is possible as administrator to remove whatever is wanted22:42
cristi_anon what these stored fields are used ?22:42
cedkcristi_an: not remove and not yet add22:43
cristi_anbut is possible to remove or to add22:44
cristi_ani am just courious where this will be used ?22:44
cedkit is not22:45
cristi_anit is not used ?22:48
cristi_anor too complicate to tell me now ? or is not used for now ?22:48
cedknot use for now22:49
cristi_anoki ...can you tell me on what it will be used ? or is a secret ?22:49
cristi_anBTW you do not have some diagram with the tables ?22:49
CIA-8tryton: matb roundup * #732/Translation: no display of translation with line breaks in src: [new] Translation: line breaks in src sometimes lead to translation not being displayed translated. not working: ============ self._error_message ...22:58
cedkcristi_an: we think about the posibility to add fields or object manualy but it is not a priority22:59
cristi_ani saw something similar in adempiere23:01
cristi_anbut despite it sounds nice i wonder how often such a thing is used23:01
cristi_ancedk: last question today23:03
cristi_ancedk: you don;t have a diagram with base tables ?23:03
cristi_anor with all :)23:03
cristi_anthx good night23:06

Generated by 2.11.0 by Marius Gedminas - find it at!