IRC logs of #tryton for Monday, 2011-01-10 #tryton log beginning Mon Jan 10 00:00:02 CET 2011
-!- heg(~heg@ has left #tryton00:06
-!- pepeu(~manuel@ has joined #tryton00:27
-!- hoRn( has joined #tryton00:40
-!- plantian( has joined #tryton01:02
-!- pepeu(~manuel@ has joined #tryton01:41
-!- plantian( has joined #tryton03:35
-!- plantian( has joined #tryton04:00
-!- plantian( has left #tryton04:04
-!- marga( has joined #tryton04:49
-!- yangoon( has joined #tryton05:19
-!- jbunting( has joined #tryton06:14
-!- sharoon(~sharoon@ has joined #tryton06:22
-!- carter( has joined #tryton06:57
-!- lem0na(~lem0na@ has joined #tryton06:59
-!- carter( has joined #tryton07:17
-!- Vladimirek( has joined #tryton08:08
-!- paepke( has joined #tryton08:16
-!- enlightx( has joined #tryton08:28
-!- plantian( has joined #tryton08:56
-!- Timitos(~kp@ has joined #tryton08:58
-!- pjstevns( has joined #tryton09:04
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:07
-!- hoRn( has joined #tryton09:15
-!- plantian( has left #tryton09:35
-!- enlightx( has joined #tryton09:49
-!- paepke( has joined #tryton09:51
-!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton09:58
-!- bechamel( has joined #tryton10:07
-!- paepke( has joined #tryton10:08
-!- plantian( has joined #tryton10:09
-!- paepke( has left #tryton10:36
-!- paepke( has joined #tryton10:37
-!- plantian( has joined #tryton11:13
cedkTimitos: don't forget to assign you issue on which you work11:29
Timitoscedk: ok. thx11:30
-!- sharoon(~sharoon@ has joined #tryton11:38
cedksharoon: hi, could you check if it is correct
sharooncedk: doing that now :)12:00
cedksharoon: I found the information on wikipedia12:01
sharooncedk: looks good to me...12:24
sharooncedk: it works12:24
cedksharoon: thx12:28
-!- paepke( has left #tryton12:28
-!- lem0na(~lem0na@ has joined #tryton12:37
udonoroundup down?12:50
-!- irclog( has joined #tryton12:57
cedkudono: rebooted13:06
-!- lem0na(~lem0na@ has joined #tryton13:09
udonocedk: thanks!13:32
-!- slef( has joined #tryton13:44
slefHi all. Does anyone know if the webdav server only logs exceptions? I'm struggling to understand how to get debugging logs for webdav with tryton 1.8.13:44
cedksharoon: yes only with verbose option13:54
sharoonslef: i believe that cedk message was for you13:55
slefcedk: thanks. It only logs exceptions with verbose option, or I need to give it the verbose option (in trytond.conf?) to get more logs?13:56
cedkoops yes autocomplet issue :-)13:56
cedkslef: only logs exception with verbose option13:56
slefcedk: is there a way to get more logs? A Kontact user says it is unable to save new or edited events over caldav, so I'd like to see any server-side errors.13:58
cedkslef: no except putting print statement13:58
slefcedk: ok, thanks. I'll put verbose = True in trytond.conf and see if that gets enough.13:59
slefApparently Sunbird works, so I guess it's not our config. It's something with Kontact.14:00
slefI'll comment here if I narrow it down to a bug or an interaction.14:00
cedkslef: you should dump the http connection14:02
slefcedk: easiest way to do that? socat? I think I can't fire up a packet sniffer on that server.14:03
cedkslef: I use wireshark14:03
slefcedk: which is a sniffer... if all else fails, I'll see if I can get the user to run that on their workstation.14:05
cedkslef: you can run it on the server14:07
-!- pepeu(~manuel@ has joined #tryton14:20
slefcedk: I'm not sure I have permission. Safer to run on client.15:04
cedkslef: it requires root access15:08
-!- ecarreras( has joined #tryton15:10
-!- ecarreras(~under@unaffiliated/ecarreras) has joined #tryton15:10
-!- pepeu(~manuel@ has joined #tryton15:18
-!- hoRn( has joined #tryton15:19
udonocedk: what do you think about ?17:49
cedkudono: don't know yet17:52
udonocedk: ok17:52
cedkudono: the form display what will be seen in the report17:53
udonocedk: yes, Understand, But the user chooses a different name. This is irritating.17:53
udonocedk: ... and we actually do not know if a custom report uses or tax.description.17:55
cedkudono: it must use tax.description18:00
cedkudono: it is the public name of the tax18:01
-!- paepke( has joined #tryton18:04
Timitoscedk: but why should the public name be used on the view? as the user selects the tax by the internal name i recommend to use the internal name on the view, too.18:04
Timitoscedk: i agree with udono that the current behavior is irritating for the user18:05
-!- paepke( has joined #tryton18:19
cedkTimitos: yes but description could be changed by the user as it is what will be seen in the report18:27
Timitoscedk: ok. this might be an argument. have not seen this like that until now18:31
Timitosfor me this was data that should not be changed by a user as he might do not have the knowledge to this in a correct way18:32
cedkTimitos: yes but it is for accountant18:33
Timitoscedk: ok. as i had a different view on the current behavior it is ok for me to keep it as it is. i can now explain it in another way.18:41
-!- pheller( has joined #tryton19:08
phellercedk: just curious -- do you think the tryton client will capable of multiple windows to different servers at some point?  (rather than a new process)19:13
paepkeACTION likes to see different windows to different databases on the same server.19:15
-!- lem0na(~lem0na@ has joined #tryton19:15
cedkpheller: never for different server19:15
cedkpaepke: and I don't think it is good for different databases19:15
paepkecedk. why it isn't good?19:16
cedkpaepke: this will be confusing19:17
cedkpaepke: you just have to open a new client19:20
cedkpheller: idem for multi-server19:20
phellercedk: how is opening a new client any less confusing?19:21
-!- cristi_an(4e144018@gateway/web/freenode/ip. has joined #tryton19:26
cedkpheller: you got connection params in the bottom19:27
-!- chrue( has joined #tryton19:28
phellercedk: this could be the same for multiple windows in the same process....19:28
paepkecedk, its not that easy to open two different tryton processes on osx for example.19:29
cedkpheller: what will be the advantage19:30
cedkpaepke: it is the osx fault19:30
paepkecedk, depends on the eye of the beholder: its the osx advantage.19:31
udonoACTION would like to have a command line option, which defines a colored statusbar/titlebar/... for the client19:31
paepkefull ack to udono. working with two databases and have different colors for them eases the use of multiple tryton windows. already did that on other erp software and the users were very very happy.19:32
paepkeudono, maybe you can archieve that with the gtk-style setting19:33
udonopaepke: ?19:33
udonopaepke: what is gtk-style setting?19:34
phellercedk: perhaps simpler to debug multi-server connections.  If each server/database has it's own thread within the same process.   (well, ok, simpler for people who use an IDE :-)19:34
paepkeudono, you can set the gtk-style (isn't that the right word?) for the client. like "clearlooks"19:34
phellercedk: only one process will run the IPCServer...19:35
phellercedk: and sure, it makes it easier to integrate on the Mac.19:35
cedkpaepke: it is an advantage to not be able to run twice the same program ? Are you kidding19:35
phellercedk: you can always run a program more than once, it's just that the Mac OS Launch services doesn't make this convenient.19:37
cedkpheller: thread was not create for this19:37
cedkpheller: this is not KISS but KICB (Keep It Complex and Bloated :-)19:38
paepkeyou can run two times the same program if you want to. but the idea behind is to ease the use of the whole interface.19:38
cedkpaepke, udono: I don't think that gtk-style can manage different theme per process19:38
udonopaepke: this would be too much invention for me. Just a --color=red or --color=#ff0000 would be enough for me.19:39
paepkeudono, agree with --color=xxx19:39
cedkudono: it could be in the new/futur connection manager19:40
udonocedk: yes19:41
paepkecedk, the idea on osx is to have one program launch different windows.19:41
cedkpaepke: I know but this doesn't make application KISS19:42
cedksomeone should say to Steve that now OS are multi-process19:43
paepkecedk, its kiss for the user. even every modern browser works like this.19:43
cedkpaepke: this is not KISS even for user. This is simply hide stuff.19:44
paepkecedk, you know why steve is everytime wearing this turtleneck sweaters? everything else has too many buttons.19:44
cedkpheller: perhaps we should create a launcher for OSX?19:48
paepkecedk, why shouldn't it be multi-process? I'm not familiar with that osx programming. maybe its just a matter of registration to the same menu to have multiple windows/processes apper as the same application.19:48
paepkecedk, or something like that. had kind of same idea19:48
cedkpaepke: I don't know any GUI lib that allow multi-process19:48
paepkecedk, isn't chromium for example running every tab as extra process? i'm not sure...19:49
cedkpaepke: yes but the rendering is done by the main thread19:52
cedkpaepke: by rendering I mean put the "image" in the tab19:53
cedkpaepke: but perhaps they use some kind of encapsulation of display19:54
cedkany way, this is not the behavior we want for Tryton19:54
cedkbecause the multi-process of chromium is for security, to prevent contamination of other tabs19:54
cedkin Tryton, we want to have communication between tabs, windows etc.19:55
paepkecedk, i don't think of seperating the tabs. more like seperating different windows with different database connection.19:56
paepkecedk, and the idea of having a launcher process for tryton on osx which let two seperate tryton processes look like any other osx application would work ok.19:57
paepkepheller made a big step forward with his osx enhancements.19:58
phellerpaepke: I will fully try to make the URL launcher work the same under OS X as others, I'm only thinking of what to do if it turns out to be very difficult.19:59
cedkpaepke: yes, we need to provide a better launcher than the OSX one19:59
paepkecedk, than we are on the same level. i don't want to force something like a complex process model inside the tryton client. i'm looking from the users side of view.20:02
-!- pheller( has joined #tryton20:03
-!- plantian( has joined #tryton20:04
cristi_anlong time no see guys...20:19
udonocristi_an: indeed20:20
cristi_antryton became bigger20:20
cristi_anudono: how is going with tryton ?20:20
cristi_anstill do not belive in a web interface ?20:21
udonocristi_an: no more work then a prototype called sao, based on gwt20:22
udonocristi_an: but a great client lib, which helps to make custom clients20:23
udonocalled proteus20:23
cristi_anproteus ? is there a demo to see ....20:23
cristi_anbased on the tryton client ...i supose20:23
udonocristi_an: no, not based. You can see the api e.g. here:
udonocristi_an: upon proteus it is very easy to communicate with tryton. Upon this api, you can create easily a webserver which propagate stuff to trytond.20:26
cristi_ansearching on net to read more about...sounds interesting20:27
cristi_anso this is a client API20:28
cristi_anno UI at all20:28
udonocristi_an: yes20:28
cristi_ananyone can use it to develop in any UI desires20:28
cristi_anis stateless i guess20:28
cristi_anthis might be seen like an extraction from the Client that now is separated into an idependent API20:29
cristi_anthe Tryton client use this ?20:29
udonocristi_an: no, not for now.20:30
udonocristi_an: maybe it will be used in the gtk client, but Iam unsure about this.20:30
cristi_anit is a good ideea to have such more oportunities for the client side20:31
cristi_anbut is this something that is fully done or is experimental ?20:31
phellercristi_an: in between, I think.  in fact, doctests are mostly written in a proteus compatible manner20:32
udonocristi_an: it is complete, but afaik report generation is missing. We use it daily for new projects with trytond > 1.620:33
phellercristi_an: I've started using it to interate with Asterisk for telephony projects....20:34
cristi_anso there are other projects done based on tryton then ERP ?20:34
cristi_anit became like a Application platform ?20:34
paepkeACTION has begun writing a specialized ncurses client on top of it. it feels kinda stable.20:34
phellerpaepke: something like the openerp ncurses client?20:34
cristi_anthis looks like active record from rails but this is remote stuff20:35
udonocristi_an: Just step into our App-Store ;-)20:35
paepkepheller, no. its a specialized one. nothing generic.20:35
cristi_anyou have App store ? really ?20:35
cristi_anor is a joke20:35
udonocristi_an: just kidding20:35
cristi_andid not been here for a while :))20:35
paepkeudono, but kinda intresting :-)20:35
cristi_anwas not20:35
cristi_anproteus...? there is a wiki for it ?20:36
cristi_anguys but this proteus client code20:39
cristi_anmight be executed on a remote client20:39
cristi_anor it has to be on the same machine?20:39
cristi_anlocal or remote calls ?20:39
paepkecristi_an, remote via xml-rpc and if you wish local via sockets20:40
cristi_anpaepke: so it can be used also in a fat client also for a web client..20:40
cristi_anthat is quite nice...20:40
cristi_anthere are some docs related to Proteus ?20:41
-!- Timitos(~kp@ has joined #tryton20:41
paepkecristi_an, i know only the in code docs.20:42
paepkegetting hungry. bbl20:43
-!- paepke( has left #tryton20:43
cristi_andoes tryton support multiple database20:44
cristi_anknow that cedk worked on this in 200820:44
cristi_anif yes which ones ?20:44
phelleryes - sqlite and postgresql at least.20:45
phellercristi_an: mysql too, I believe, though I haven't tried it.20:45
cristi_anmysql that would be super gr820:45
cristi_anwill try that soon20:46
cristi_annice to see that there were so many impreovements20:46
phelleryes, mysql support is in the code.20:46
phellerand for the most recent 1.8 release, a Transaction manager was implemented -- so no longer a need to pass cursor, uid, and context to each server method.20:47
phellerso all the method signatures are much cleaner and more understandable now.20:48
cristi_anlike in java + spring20:50
cristi_anor jee20:51
phellercristi_an: yes, things are moving along nicely here.  would be nice to have more developers on board :-)20:55
cristi_anpheller: i had this idea of doing somehting on top of tryton 2 years ago...started slowly but job took me from romania into belgium ...then family ,kid time left for that issue was 020:57
cristi_annowdays things are much more calmer :)20:57
phellercristi_an: so are you finding more time for tryton now, then?  if so, that is great!20:58
cristi_ani plan to do that...but time will i read the docs try to see what is new20:58
cristi_anprepare my ubuntu20:58
cristi_anfor the development and series of tries20:59
phellercristi_an: cool.  you'll also like ced's new "hgnested" module.  One command will checkout entire trytond and nested module repositories.20:59
cristi_ani want with this ocassion to actually code in python since all day i do java a change and diverstity will not hurt20:59
cristi_anhe had that was like a command that retreived all in one....mybe today is different21:00
cristi_anmercurial it was used if i rem correctly21:00
phellercristi_an: ah yes, I think I read about this.  yes, still mercurial... it's just that the nested repository is done with a production mercurial extension now21:01
plantianRight the forest extension, I think this is simpler and allows for multiple pull and update.21:01
-!- bechamel( has joined #tryton21:01
udonoplantian: hi21:02
plantianudono:  hello hello21:02
-!- enlightx( has joined #tryton21:02
udonoplantian: In the past you talked about performance issues with the stock locations.21:03
udonoplantian: did you solve them?21:03
plantianudono: Well I don't use the stock module's inventory anymore and I wrote my own.  I have had many different performance problems though I'm not sure which one.  Its still an ongoing problem.21:04
plantianI have not migrated to 1.8 I'm still in the process of upgrading modules and adding new features.21:04
plantianGoing to migrate in the next month some time.21:04
udonoplantian: Do you use mptt?21:05
plantianudono: It is tryton in general though, not just locations.  I have many products too.  It gets faster all the time though.21:05
plantian*Tryton gets faster all the time.21:05
plantianudono: I don't know if my indexing is great.  What is mptt?21:05
udonoplantian: the parent-child with left and right....21:06
cristi_anso this snippets from here21:06
plantianOh yeah,  I use tree of locations.21:06
udonolike used in stock/ or account/account.py21:06
cristi_anare not valid anymore ?21:06
cristi_anon 1.821:06
udonocristi_an: just an example missing...21:07
cristi_anthe one where the context is missing ?21:07
plantianudono: I have around 1000 locations arranged in a tree.  Like warehouse->main storage->(20 sections)->(each section has between 1 and 15 rows)->(each row has 3 spots: top, middle, bottom).21:08
udonoplantian: I see21:09
cristi_anplantian: super question : wanted to aske the perfromance in retriving objects from DB21:09
udonoplantian: did you put the structure into trytond manually or with a script?21:10
-!- pheller( has joined #tryton21:10
udonoplantian: I guess with a script21:10
plantianudono: With script21:10
plantianudono: I think the locations though are too small to cause problem, products are the biggest problem.21:11
plantianThere are around 20,000 I think and when I open them in the client it was pretty slow.  And then it makes a lot of things that scan products slow.21:11
udonoplantian: yes, we found another problem with the chart of accounts. There is mptt used, too and yangoon found out it the mptt tree is always rebuild after each create.21:12
plantianudono: ha oh god, I thought I saw an alternative on a blog somewhere to mptt but I didn't look to far into it21:13
-!- woakas(~woakas@ has joined #tryton21:15
udonoplantian: but our problems are different, you have long read/gui-rendering, we have it only on create. The gui is not the problem for now.21:15
plantianudono:  My product import script took over 10 hours.21:15
cristi_an10 H ?21:16
udonoplantian: for how many products?21:16
cristi_anhow many ?21:16
udonoplantian: on which hardware?21:16
plantianudono: 23000, on 2.0 Ghz AMD single processor.  It was a long time ago though.21:17
plantianmaybe 2 years ago21:17
cristi_anthat has to be seconds not hours21:17
udonoplantian: and with the same procedure you create the stock locations?21:18
cristi_anperformance issue ...i assume there was initiated a transaction for each insert or things like this (i talk in general not what tryton  does)21:18
udonocristi_an: its postgres, not oracle :-)21:18
cristi_anmaybe bulk inserts need to be done21:18
cristi_anudono: 22000 for a database like postgress is nothing21:19
udonoplantian: and with the same procedure you create the stock locations?21:19
cristi_anudono: in mysql 22000 is les then 5 sec21:20
cristi_anon my old laptop21:20
udonocristi_an: Ok21:20
plantianudono: Yes, it was through tryton api.  I think from the wiki, using trytond as a module.21:20
plantianMaybe it was horribly wrong, all it takes though is product to take over 1 second and things get slow fast.21:21
-!- elbenfreund( has joined #tryton21:21
udonoplantian: ok, thanks for investigating.21:23
cristi_anudono: really 22000 products to import has to take more then LET's say 10 min in worst case ?21:26
cristi_anhowever you know if tryton can work with jython ?21:27
cristi_ani would like to try how it behaves on a JVM21:27
udonocristi_an: yes, we are talking about nested structures with a lot of parent-child lookups in a greater deepth.21:28
cristi_anbut these are inserts not retrival no ?21:28
-!- paepke( has joined #tryton21:29
plantianudono: On more though, maybe it was only 6 hours.21:29
udonocristi_an: at the very end, these are inserts, but you need to update a lot in parent-child relationships21:29
plantiancristi_an: One creation can be many inserts as well many checks.  The ERP must maintain consistency at all times, it is much more complicated than reading in a sql dump.21:31
cristi_anudono: i do not know the model...but on migration there has not be any updates only inserts..21:31
udonocristi_an: ?21:32
cristi_anplantian: check are reads...agree and might slow things21:32
cristi_anudono: i start to get import things via tryton model or so....21:32
udonocristi_an: yes21:33
cristi_anand data is provided how from text files ?21:34
cristi_anor you read them with some conversion tool from another database21:34
plantiancristi_an: I had another database with products.  So I imported from mysql into trytond running over postgresql.21:37
udonocristi_an: plantian, Sorry, I need to go, now. Thanks a lot for your help. I think yangoon, timitos or me will report as soon as we have more details.21:38
paepkecristi_an, cedk mentioned he did some tests with other python compilers like pypy or jython. but i don't thinkt it would be an  official platform.21:38
plantianudono: cool, ttyl21:39
cristi_anpaepke: k .21:39
udonosee you21:39
cristi_anplantian: and you created every object in tryton model...from mysql21:39
cristi_anthen saved....21:40
cristi_aninto postgress21:40
cristi_anand it took 10 h21:40
plantiancristi_an: Oh right ,earlier I said I think it might have just been 6 hours.21:43
cristi_anplantian: there is some special thing to import from mysql21:44
cristi_ani am interested in such thing as well21:44
plantiancristi_an: nothing special, I just used sqlalchemy to get the data and plug it into the tryton api21:44
cristi_anso you did your own conversion...21:45
cristi_anthx for tips21:46
plantiancristi_an: Yes, it worked fine though once I got it setup.  I really like tryton so far it just gets better with every release.  There is much work to still be done though.21:49
cristi_anwell i come from java andyou might heard of spring ,jee6 ....21:50
cristi_anthere as well is work to do and imporve21:50
cristi_anlike everywhere :)21:50
plantiancristi_an: Yeah, I haven't used Java since I was in school.  Is the common complaint about a lot of boiler plate the biggest problem ?  Or do you just not feel as productive in the language compared to Python?21:52
cristi_anNowdays it is productive enough with all this tools ....there is Spring Roo ,Grails ...for rapid development...21:53
cristi_anbut does not hurt to learn new stuff21:53
cristi_ani have this positive feeling about tryton :)21:57
cristi_anso that is why i am here ...21:57
-!- plantian( has left #tryton22:21
-!- plantian( has joined #tryton22:24
-!- plantian( has joined #tryton23:47

Generated by 2.11.0 by Marius Gedminas - find it at!