IRC logs of #tryton for Wednesday, 2008-12-17 #tryton log beginning Wed Dec 17 00:00:01 CET 2008
vengfulsquirreludono: Yeah that's fine, I definately think the books are a great resource I think I just need something more about the logic in addition to the data model because certain things are hard to grasp.00:33
-!- mmarshall_( has joined #tryton01:02
-!- ikks(n=igor@ has joined #tryton03:14
-!- gremly(n=oscar@ has joined #tryton04:33
-!- yangoon( has joined #tryton05:19
-!- Gedd( has joined #tryton08:08
-!- sharkcz( has joined #tryton08:16
-!- carlos(n=carlos@ has joined #tryton08:52
-!- marmu( has joined #tryton09:27
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton09:41
-!- bechamel( has joined #tryton10:57
-!- Cristi_an(n=Cristi@ has joined #tryton11:54
CIA-53tryton: C?dric Krier <> default * 1125:e5b497c194a9 tryton/tryton/ Remove print statement12:27
-!- ikks(n=igor@ has joined #tryton12:35
CIA-53tryton: C?dric Krier <> default * 1370:84a30f55bec9 trytond/ (11 files in 4 dirs): Add replace_attributes for xpath tag13:00
CIA-53tryton: C?dric Krier <> default * 116:4ff7766a290e company/company.xml: Use replace_attributes to change string of form13:00
CIA-53tryton: C?dric Krier <> default * 121:34eb5c3b1f3e product/product.xml: Use replace_attributes to change string of form13:00
CIA-53tryton: C?dric Krier <> default * 1126:77d251c95cee tryton/doc/usage.rst: Add email example for Thunderbird on Windows13:10
CIA-53tryton: tekknokrat roundup * #681/IntegrityError: null value in column "name" violates not-null constraint: [new] Traceback (most recent call last): File "/trytond/", line 282, in run res = method(*msg[2:]) File "/trytond/web_service/obj ...14:05
-!- ikks(n=igor@ has joined #tryton14:06
-!- Cristi_an__(n=Cristi@ has joined #tryton14:07
CIA-53tryton: ced roundup * #681/IntegrityError: null value in column "name" violates not-null constraint: [need-eg] What was the action for this backtrace?14:27
-!- ikks_(n=igor@ has joined #tryton14:50
CIA-53tryton: tekknokrat roundup * #681/IntegrityError: null value in column "name" violates not-null constraint: @ced I wasnt fast enough :-) actions: errormessage appears when entering the flags next in formular/new when input field is blank. This also happ ...14:50
-!- ikks_(n=igor@ has joined #tryton14:56
CIA-53tryton: ced roundup * #681/IntegrityError: null value in column "name" violates not-null constraint: I don't understand, can you describe precisely the actions you made?15:12
-!- Cristi_an(n=Cristi@ has joined #tryton15:56
-!- ikks_(n=igor@ has joined #tryton16:00
-!- igor__(n=igor@ has joined #tryton16:19
-!- cristi_an(n=cristi@ has joined #tryton16:44
CIA-53tryton: tekknokrat roundup * #681/IntegrityError: null value in column "name" violates not-null constraint: ok. system language is englisch user language can be german/english. I am in main dialog. Main Menu is selected. Then I go to Menu 'Form' and cho ...16:54
-!- ikks_(n=igor@ has joined #tryton17:00
-!- bepivin(i=xtc@ has joined #tryton18:01
bepivinany italian here?18:02
cristi_anhi there.19:04
cristi_ansince i learn python no win order to build my models.19:04
-!- cristi_an(n=cristi@ has joined #tryton19:24
-!- cristi_an(n=cristi@ has joined #tryton19:27
-!- udono( has joined #tryton19:41
-!- evernichon( has joined #tryton20:04
udonohi all, anybody knows how I can display an action in the footer of a form view? Momentary the action is just in the action menu seen...20:05
bechameludono: see record stock/product.xml line 5520:07
udonobechamel: thanks, keyword form_relate was it, I used form_action...20:10
udonofields.Function for type="Text" doesn't exist?20:11
bechamelevery type should works, you must return a dict like {record_id: value}20:15
udonobechamel: did fields.Function even work in WizardOSV ?20:17
udonoyes, found an example: ../party/    full_address = fields.Function('get_full_address', type='text')20:19
udonohmmm, but it seems not to work in a WizardOSV class20:24
udonobechamel: WizardOSV can not use fields.Function?20:28
bechameludono: i don't know i never tried20:38
udonoit seems not to work...20:42
bechamelif it doesnt work you can use classic field and populate them before showing form to user, look in stock_supply/ line 475 and 50720:42
udonobechamel: Great you are the wandering dictionary ;-)20:43
udonoyeah, that's it20:44
bechamelACTION is meta-grep20:46
udonoworks fine.20:49
cedkudono: Function field on WizardOSV has no sence because there is no ids for those records20:59
cedkudono: so you can put function fields on wizardosv but the function will never be called20:59
cedkudono: as bechamel says, you can just set a normal readonly field and put default value for it21:00
udonocedk: yes, and it works very well this way. Thanks a lot.21:00
cedkudono: I think it will be more clear when we will refactor all the OSV/ORM stuffs21:01
udonocedk: I hope so. For me its black magic. Momentaryly I can just use patterns without much sense for me, but slowly it gets more clear. I think I need my first 1000 hours coding experience in tryton to talk...21:04
udonoX0d_of_N0d: Hey21:08
-!- vengfulsquirrel( has joined #tryton21:08
udonoX0d_of_N0d: I finished the skeleton module prototype for your sugestions on the wiki page. Now we have a test action which could show the results of a possible ldap request. see
vengfulsquirrelHey you guys weren't joking when you said MRP is complicated.21:11
-!- snowch(n=snowch@ has joined #tryton21:13
cristi_anMRP (production) ?21:13
CIA-53tryton: vengfulsquirrel * r384 /wiki/ Created Tryton's Material/Manufacturing Resource Planning Integration wiki page through web user interface.21:14
X0d_of_N0dudono: yeah, my boss wants me to finish up some more of the tinyerp data import before I can get back to ldap stuff21:14
udonovengfulsquirrel: did you try to isolate the model parts *you* need? I think MRP is not one Module. More it is a base module with addons. What do you think?21:14
X0d_of_N0dudono: I should be able to get back to it friday21:14
vengfulsquirrelOh yeah21:14
vengfulsquirrelUghh definately21:14
udonoX0d_of_N0d: sounds good!21:15
vengfulsquirrelAlmost to the point of MRP is one module and maybe MRP II might need to be an additional module21:15
udonoX0d_of_N0d: You are you importing Tinydata to tryton?21:15
vengfulsquirrelI need to buy some books on MRP, the internet has proved to be pretty useless.21:16
X0d_of_N0dudono: no, importing from our old accounting system into tinyerp. My boss isn't willing to let me work on importing into tryton until there's more progress in mrp21:16
udonovengfulsquirrel: You will put everything in one module?21:16
snowchHello irc.  I'm trying to get to grips with terminology, e.g. ir, osv, etc.  Is there documentation/glossary somewhere?21:16
X0d_of_N0dvengfulsquirrel: we've done some research on mrp here, I'll try to help if I can21:17
udonovengfulsquirrel: for me its many modules like product_assembly, product_assembly_bom, production, planning, ...21:18
vengfulsquirreludono: Yes, there will be many modules I'm not even there yet(the point of choosing modules) I'm trying to figure out what MRP, MRPII even entail at this point.21:20
udonosnowch: exactly the terms you look for there is no glossary,
vengfulsquirreludono: There seems to be a multitude of definitions out there and "extensions" to the core principals of Materials/Manufacturing Resource Planning.21:20
udonosnowch: ir=Information repository, osv=Object Services, orm: Object-Relational-Mapper21:21
vengfulsquirreludono: I'd like to just make a giant list of things that are possible and then we can cut out or put off what isn't really important.21:21
snowchudono: thanks!21:21
X0d_of_N0dvengfulsquirrel: mrp=automated controll of everything21:22
X0d_of_N0dthat's the goal anyway21:22
udonovengfulsquirrel: that's good. Why not make a discussion in forum or a wikipage for collecting the stuff, so we can share knowledge more easy...21:22
vengfulsquirrelI made one21:23
vengfulsquirrel(12:14:19) CIA-53: tryton: vengfulsquirrel * r384 /wiki/ Created Tryton's Material/Manufacturing Resource Planning Integration wiki page through web user interface.21:23
X0d_of_N0dso the computer tells you what to make (by forecasting demand) and what to buy (based on material levels and orders)21:23
vengfulsquirreludono, X0d_of_N0d:
X0d_of_N0dthen it schedules manufacturing across machines so that your shop works in the most efficient way possible.21:24
udonovengfulsquirrel: great!21:24
vengfulsquirrelits pretty rudimentaary21:24
X0d_of_N0dyou mind if I just dump all the stuff I said in there?21:24
vengfulsquirrelInto the feature list ?21:25
X0d_of_N0dprobably into the introduction21:26
X0d_of_N0dI'll add some stuff to mrp 2 also perhaps21:26
vengfulsquirrelYeah have you heard of Closed Loop MRP ?21:26
vengfulsquirrelJust dump it at the end of any section and I will try to understand it and integrate it with what I have.21:27
vengfulsquirrelOr I guess you could say Normalize it to work with what I have.21:27
X0d_of_N0dShouldn't MPS go under MRP II?21:28
vengfulsquirrelI'm pretty sure its part of MRP I.21:28
vengfulsquirrelAlthough it may be signifigantly watered down21:28
vengfulsquirrelMRP II is just an extension of MRP I right ?21:28
X0d_of_N0dyou've read the wikipedia article on this stuff right?21:29
X0d_of_N0dACTION assumes this to be a first stop21:30
vengfulsquirrelThe MRP I and MRP II ones yes.21:31
vengfulsquirrelThey are very disorganized though.21:31
vengfulsquirrelMPS is mentioned in the MRP I article: The major problem with MRP systems is the integrity of the data. If there are any errors in the inventory data, the bill of materials (commonly referred to as 'BOM') data, or the master production schedule, then the outputted data will also be incorrect.21:32
X0d_of_N0dvengfulsquirrel: it is a really complex subject....21:33
X0d_of_N0dI'd thinking MPS should be under MRPII21:33
vengfulsquirrelOr actually more importantly I guess, what do you consider MRP I to cover?21:34
X0d_of_N0dMRP II takes into account capacity planning across machines...21:34
snowchwhat is 'rnc' as in: "There is an rnc for those files stored in trytond/tryton.rnc"21:35
vengfulsquirrelYeah that would be like MPS II though(used in MRP II), an extension to the basic MPS used by MRP I.21:35
X0d_of_N0dI think MRP I just makes sure there's enough stock to produce what needs to be produced, whereas MRP II also determines that there are enough human/machine resources and schedules manufacutring in the most efficient way possible21:36
vengfulsquirrelYeah that sounds correct to me.21:36
X0d_of_N0dACTION just wanted to be a programmer.....21:37
X0d_of_N0dI never wanted to know anything about mrp...hehehe21:37
vengfulsquirrelha yeah me either actually21:37
vengfulsquirrelor business programming in general21:37
X0d_of_N0dvengfulsquirrel: but it is kind of interesting...21:37
vengfulsquirrelIts definately full of hard to solve problems.21:38
X0d_of_N0dvengfulsquirrel:  this kind of highly organized computing really drives powerful companies like walmart21:38
X0d_of_N0dvengfulsquirrel: the really interesting problem seems to be capacity planning21:39
snowchbechamel: thanks!21:39
vengfulsquirrelYeah that's why I think we are going to need a gradient of complexity for smaller businesses to have something useful and larger businesses to also have something useful.21:39
X0d_of_N0dvengfulsquirrel: or rather MPS21:39
X0d_of_N0d+ capacity planning21:39
vengfulsquirrelYeah MPS II21:39
X0d_of_N0dvengfulsquirrel: right21:39
vengfulsquirrelI think a lot of smaller businesses won't need capacity planning.21:40
X0d_of_N0dvengfulsquirrel: well there are also a lot of different types of manufacturing operations21:40
vengfulsquirrelBUT automatic generation of planned purchase orders will be helpful or notifications to start producing sub-assemblies will be useful to small businesses21:41
X0d_of_N0dvengfulsquirrel: a textile company won't need the same bom complexity that a mechanical manufacturing company needs21:41
X0d_of_N0dvengfulsquirrel: right, especially the company I work for21:41
vengfulsquirrelYeah i think the multi-level bom will scale pretty well though21:41
vengfulsquirrelDoes your business require capacity planning ?21:42
X0d_of_N0dvengfulsquirrel: not immediately. we don't have it right now.21:42
vengfulsquirrelYeah it might be more work than its worth to type in all the necessary constraints.21:42
vengfulsquirrelHow many employees does your business have?  (If I might ask)21:43
X0d_of_N0dI think it can be easily skipped in the first iteration of the mrp module...21:43
vengfulsquirrelYeah or maybe even be pushed into a seperate module.21:43
X0d_of_N0dunder 20021:43
X0d_of_N0dbut we have software design, hardware design, manufacturing, and assembly all on site21:44
X0d_of_N0das well as sales and clerical21:44
vengfulsquirrelha wow yeah pretty diverse21:45
X0d_of_N0dyeah, it's interesting21:45
X0d_of_N0dwe also have automated manufacturing, so a bunch of our manufacturing guys are programmers21:45
vengfulsquirrelWell if you had time some time I'd like to go over the minimum inputs and outputs you need from the system.21:46
vengfulsquirrel*From the MRP system21:46
-!- ikks(n=igor@ has joined #tryton21:46
X0d_of_N0dI'm currently importing data from our old system to tinyerp so we can test the mrp in there...21:46
X0d_of_N0done of the things that tinyerp is missing is finite capacity scheduling, which we need21:47
X0d_of_N0dOnce I've got all the data imported and we've started testing I should be able to give you a more complete view of what we need here21:47
X0d_of_N0dAlso I should be free to help you research the subject during our testing21:48
-!- Timitos(n=Timitos@ has joined #tryton21:48
vengfulsquirrelX0d_of_N0d: Okay sounds good, I'm going to just keep researching and looking at examples.21:53
X0d_of_N0dvengfulsquirrel: cool, you too man21:55
-!- snowch(n=snowch@ has left #tryton22:00
-!- snowch(n=snowch@ has joined #tryton22:03
snowchIt looks as though "ir" data is persisted to the database under "ir_xxxx" tables.  Are the xml <data> files only used on first load for seeding the database?22:06
-!- yangoon1( has joined #tryton22:09
CIA-53tryton: vengfulsquirrel * r385 /wiki/ Took unintended emphasis off having single module in design doc.22:11
CIA-53tryton: * r386 /wiki/ Edited wiki page through web user interface.22:11
bechamelsnowch: each db is prefixed by a module name, each <record model="model_name"> ...</>  will create a new line in the table corresponding to model_name22:11
-!- mmarshall(n=mmarshal@ has joined #tryton22:12
-!- X0d_of_N0d(i=C-C_C-X@gateway/tor/x-9f9297a1caddb0be) has joined #tryton22:12
-!- Cristi_an(n=Cristi@ has joined #tryton22:17
snowchbechamel: ok, but after the xml file has been imported to the database, but do all further changes to the ir model takes place directly in the database and not the xml file?22:24
bechamelsnowch: the xml is just there to dump data to the db, nothing else (the xml doesn't define the db schema or any logic).22:26
snowchbechamel: got it - thanks!22:27
bechameltable are created according to all the objects that inherit osv (those object are business objects like invoice or product, except for ir.* objects, they contains necessary meta data like menu items, views, etc)22:29
bechamel@all: i think this kind of background info are really missing in the doc :)22:30
snowchfor the purposes of learning, is it possible to interact with the osv directly from a python script without the server running?  It would be nice, if I could learn osv without having to learn the rest of the framework at the same time...22:36
-!- ikks(n=igor@ has joined #tryton22:39
snowchbechamel: many thanks, just what I was looking for!  that info would be very useful in the model documentation...22:48
CIA-53tryton: Timitos roundup * #682/cannot install stock module: [new] When I install stock module with newest changesets i get the following error: The value of the field "Input" on "Stock Location" is not val ...22:52
CIA-53tryton: C?dric Krier <> default * 401:c78a508b0055 stock/location.xml: Fix creation of warehouse and set noupdate to location data for issue68223:03
CIA-53tryton: ced roundup * #682/cannot install stock module: [resolved] Fix with changeset c78a508b005523:04
CIA-53tryton: Timitos roundup * #679/KeyError: 'salable': [resolved] needed to clone my repositories again. seems like is was a mercurial handling issue.23:14
CIA-53tryton: Timitos roundup * #683/label insertion not working?: [new] i tried to add a field with a label on product category form. everything is working but the label is not shown (see attched screenshot). di ...23:26
-!- TCW( has joined #tryton23:29
TCWpanthera, *ping* :)23:30
TCWhi btw.23:30
CIA-53tryton: ced roundup * #683/label insertion not working?: [resolved] You put a capital letter to code for the label name.23:30
snowchis the tryton (tiny) orm framework homegrown, or is it based on an existing framework?23:32
bechamelsnowch: completely homegrown unfortunately23:40
TimitosTCW: hi23:41
TCWhi Timitos :)23:42
snowchis it likely that the orm framework will ever be replaced with a third party framework (e.g. SQL Alchemy)?  There would be lots of benefits...23:49
bechamelsnowch: yes we know that, and we talked a lot about this but it's a difficult task23:52
snowchbechamel: sorry, I didn't mean to be telling you how to suck eggs.  I am learning the internals of tinyerp via. the debugger but am finding that there doesn't appear to be a clear separation of orm code.  Therefore, to learn the internals of tinyerp, I am having to study the internals of the orm code too!23:56

Generated by 2.11.0 by Marius Gedminas - find it at!