IRC logs of #tryton for Wednesday, 2008-12-17 #tryton log beginning Wed Dec 17 00:00:01 CET 2008
2008-12-17 00:33 <vengfulsquirrel> udono: 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.
2008-12-17 01:02 -!- mmarshall_( has joined #tryton
2008-12-17 03:14 -!- ikks(n=igor@ has joined #tryton
2008-12-17 04:33 -!- gremly(n=oscar@ has joined #tryton
2008-12-17 05:19 -!- yangoon( has joined #tryton
2008-12-17 08:08 -!- Gedd( has joined #tryton
2008-12-17 08:16 -!- sharkcz( has joined #tryton
2008-12-17 08:52 -!- carlos(n=carlos@ has joined #tryton
2008-12-17 09:27 -!- marmu( has joined #tryton
2008-12-17 09:41 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton
2008-12-17 10:57 -!- bechamel( has joined #tryton
2008-12-17 11:54 -!- Cristi_an(n=Cristi@ has joined #tryton
2008-12-17 12:27 <CIA-53> tryton: C?dric Krier <> default * 1125:e5b497c194a9 tryton/tryton/ Remove print statement
2008-12-17 12:35 -!- ikks(n=igor@ has joined #tryton
2008-12-17 13:00 <CIA-53> tryton: C?dric Krier <> default * 1370:84a30f55bec9 trytond/ (11 files in 4 dirs): Add replace_attributes for xpath tag
2008-12-17 13:00 <CIA-53> tryton: C?dric Krier <> default * 116:4ff7766a290e company/company.xml: Use replace_attributes to change string of form
2008-12-17 13:00 <CIA-53> tryton: C?dric Krier <> default * 121:34eb5c3b1f3e product/product.xml: Use replace_attributes to change string of form
2008-12-17 13:10 <CIA-53> tryton: C?dric Krier <> default * 1126:77d251c95cee tryton/doc/usage.rst: Add email example for Thunderbird on Windows
2008-12-17 14:05 <CIA-53> tryton: 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 ...
2008-12-17 14:06 -!- ikks(n=igor@ has joined #tryton
2008-12-17 14:07 -!- Cristi_an__(n=Cristi@ has joined #tryton
2008-12-17 14:27 <CIA-53> tryton: ced roundup * #681/IntegrityError: null value in column "name" violates not-null constraint: [need-eg] What was the action for this backtrace?
2008-12-17 14:50 -!- ikks_(n=igor@ has joined #tryton
2008-12-17 14:50 <CIA-53> tryton: 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 ...
2008-12-17 14:56 -!- ikks_(n=igor@ has joined #tryton
2008-12-17 15:12 <CIA-53> tryton: 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?
2008-12-17 15:56 -!- Cristi_an(n=Cristi@ has joined #tryton
2008-12-17 16:00 -!- ikks_(n=igor@ has joined #tryton
2008-12-17 16:19 -!- igor__(n=igor@ has joined #tryton
2008-12-17 16:44 -!- cristi_an(n=cristi@ has joined #tryton
2008-12-17 16:54 <CIA-53> tryton: 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 ...
2008-12-17 17:00 -!- ikks_(n=igor@ has joined #tryton
2008-12-17 18:01 -!- bepivin(i=xtc@ has joined #tryton
2008-12-17 18:01 <bepivin> hi
2008-12-17 18:02 <bepivin> any italian here?
2008-12-17 19:04 <cristi_an> hi there.
2008-12-17 19:04 <cristi_an> since i learn python no win order to build my models.
2008-12-17 19:05 <cristi_an>
2008-12-17 19:24 -!- cristi_an(n=cristi@ has joined #tryton
2008-12-17 19:27 -!- cristi_an(n=cristi@ has joined #tryton
2008-12-17 19:41 -!- udono( has joined #tryton
2008-12-17 20:04 -!- evernichon( has joined #tryton
2008-12-17 20:05 <udono> hi 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...
2008-12-17 20:07 <bechamel> udono: see record stock/product.xml line 55
2008-12-17 20:10 <udono> bechamel: thanks, keyword form_relate was it, I used form_action...
2008-12-17 20:11 <udono> fields.Function for type="Text" doesn't exist?
2008-12-17 20:15 <bechamel> every type should works, you must return a dict like {record_id: value}
2008-12-17 20:17 <udono> bechamel: did fields.Function even work in WizardOSV ?
2008-12-17 20:19 <udono> yes, found an example: ../party/ full_address = fields.Function('get_full_address', type='text')
2008-12-17 20:24 <udono> hmmm, but it seems not to work in a WizardOSV class
2008-12-17 20:28 <udono> bechamel: WizardOSV can not use fields.Function?
2008-12-17 20:38 <bechamel> udono: i don't know i never tried
2008-12-17 20:42 <udono> it seems not to work...
2008-12-17 20:42 <bechamel> if it doesnt work you can use classic field and populate them before showing form to user, look in stock_supply/ line 475 and 507
2008-12-17 20:43 <udono> bechamel: Great you are the wandering dictionary ;-)
2008-12-17 20:44 <udono> yeah, that's it
2008-12-17 20:44 <udono> thanks
2008-12-17 20:46 <bechamel> ACTION is meta-grep
2008-12-17 20:49 <udono> works fine.
2008-12-17 20:59 <cedk> udono: Function field on WizardOSV has no sence because there is no ids for those records
2008-12-17 20:59 <cedk> udono: so you can put function fields on wizardosv but the function will never be called
2008-12-17 21:00 <cedk> udono: as bechamel says, you can just set a normal readonly field and put default value for it
2008-12-17 21:00 <udono> cedk: yes, and it works very well this way. Thanks a lot.
2008-12-17 21:01 <cedk> udono: I think it will be more clear when we will refactor all the OSV/ORM stuffs
2008-12-17 21:04 <udono> cedk: 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...
2008-12-17 21:08 <udono> X0d_of_N0d: Hey
2008-12-17 21:08 -!- vengfulsquirrel( has joined #tryton
2008-12-17 21:09 <udono> X0d_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
2008-12-17 21:11 <vengfulsquirrel> Hey you guys weren't joking when you said MRP is complicated.
2008-12-17 21:13 -!- snowch(n=snowch@ has joined #tryton
2008-12-17 21:13 <cristi_an> MRP (production) ?
2008-12-17 21:14 <CIA-53> tryton: vengfulsquirrel * r384 /wiki/ Created Tryton's Material/Manufacturing Resource Planning Integration wiki page through web user interface.
2008-12-17 21:14 <X0d_of_N0d> udono: yeah, my boss wants me to finish up some more of the tinyerp data import before I can get back to ldap stuff
2008-12-17 21:14 <udono> vengfulsquirrel: 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?
2008-12-17 21:14 <X0d_of_N0d> udono: I should be able to get back to it friday
2008-12-17 21:14 <vengfulsquirrel> Oh yeah
2008-12-17 21:14 <vengfulsquirrel> Ughh definately
2008-12-17 21:15 <udono> X0d_of_N0d: sounds good!
2008-12-17 21:15 <vengfulsquirrel> Almost to the point of MRP is one module and maybe MRP II might need to be an additional module
2008-12-17 21:15 <udono> X0d_of_N0d: You are you importing Tinydata to tryton?
2008-12-17 21:16 <vengfulsquirrel> I need to buy some books on MRP, the internet has proved to be pretty useless.
2008-12-17 21:16 <X0d_of_N0d> udono: 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 mrp
2008-12-17 21:16 <udono> vengfulsquirrel: You will put everything in one module?
2008-12-17 21:16 <snowch> Hello irc. I'm trying to get to grips with terminology, e.g. ir, osv, etc. Is there documentation/glossary somewhere?
2008-12-17 21:17 <X0d_of_N0d> vengfulsquirrel: we've done some research on mrp here, I'll try to help if I can
2008-12-17 21:18 <udono> vengfulsquirrel: for me its many modules like product_assembly, product_assembly_bom, production, planning, ...
2008-12-17 21:20 <vengfulsquirrel> udono: 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.
2008-12-17 21:20 <udono> snowch: exactly the terms you look for there is no glossary,
2008-12-17 21:20 <vengfulsquirrel> udono: There seems to be a multitude of definitions out there and "extensions" to the core principals of Materials/Manufacturing Resource Planning.
2008-12-17 21:21 <udono> snowch: ir=Information repository, osv=Object Services, orm: Object-Relational-Mapper
2008-12-17 21:21 <vengfulsquirrel> udono: 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.
2008-12-17 21:21 <snowch> udono: thanks!
2008-12-17 21:22 <X0d_of_N0d> vengfulsquirrel: mrp=automated controll of everything
2008-12-17 21:22 <X0d_of_N0d> that's the goal anyway
2008-12-17 21:22 <udono> vengfulsquirrel: that's good. Why not make a discussion in forum or a wikipage for collecting the stuff, so we can share knowledge more easy...
2008-12-17 21:23 <vengfulsquirrel> I made one
2008-12-17 21: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.
2008-12-17 21:23 <X0d_of_N0d> so the computer tells you what to make (by forecasting demand) and what to buy (based on material levels and orders)
2008-12-17 21:23 <vengfulsquirrel> udono, X0d_of_N0d:
2008-12-17 21:24 <X0d_of_N0d> then it schedules manufacturing across machines so that your shop works in the most efficient way possible.
2008-12-17 21:24 <X0d_of_N0d> ok...
2008-12-17 21:24 <udono> vengfulsquirrel: great!
2008-12-17 21:24 <vengfulsquirrel> its pretty rudimentaary
2008-12-17 21:24 <X0d_of_N0d> you mind if I just dump all the stuff I said in there?
2008-12-17 21:25 <vengfulsquirrel> Into the feature list ?
2008-12-17 21:26 <X0d_of_N0d> probably into the introduction
2008-12-17 21:26 <X0d_of_N0d> I'll add some stuff to mrp 2 also perhaps
2008-12-17 21:26 <vengfulsquirrel> Yeah have you heard of Closed Loop MRP ?
2008-12-17 21:27 <vengfulsquirrel> Just dump it at the end of any section and I will try to understand it and integrate it with what I have.
2008-12-17 21:27 <vengfulsquirrel> Or I guess you could say Normalize it to work with what I have.
2008-12-17 21:28 <X0d_of_N0d> Shouldn't MPS go under MRP II?
2008-12-17 21:28 <vengfulsquirrel> I'm pretty sure its part of MRP I.
2008-12-17 21:28 <vengfulsquirrel> Although it may be signifigantly watered down
2008-12-17 21:28 <X0d_of_N0d> hum
2008-12-17 21:28 <vengfulsquirrel> MRP II is just an extension of MRP I right ?
2008-12-17 21:29 <X0d_of_N0d> right
2008-12-17 21:29 <X0d_of_N0d> you've read the wikipedia article on this stuff right?
2008-12-17 21:30 <X0d_of_N0d> ACTION assumes this to be a first stop
2008-12-17 21:31 <vengfulsquirrel> The MRP I and MRP II ones yes.
2008-12-17 21:31 <vengfulsquirrel> They are very disorganized though.
2008-12-17 21:32 <vengfulsquirrel> MPS 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.
2008-12-17 21:33 <X0d_of_N0d> vengfulsquirrel: it is a really complex subject....
2008-12-17 21:33 <X0d_of_N0d> I'd thinking MPS should be under MRPII
2008-12-17 21:34 <vengfulsquirrel> Why?
2008-12-17 21:34 <vengfulsquirrel> Or actually more importantly I guess, what do you consider MRP I to cover?
2008-12-17 21:34 <X0d_of_N0d> MRP II takes into account capacity planning across machines...
2008-12-17 21:35 <snowch> what is 'rnc' as in: "There is an rnc for those files stored in trytond/tryton.rnc"
2008-12-17 21:35 <vengfulsquirrel> Yeah that would be like MPS II though(used in MRP II), an extension to the basic MPS used by MRP I.
2008-12-17 21:36 <X0d_of_N0d> I 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 possible
2008-12-17 21:36 <vengfulsquirrel> Yeah that sounds correct to me.
2008-12-17 21:37 <X0d_of_N0d> ACTION just wanted to be a programmer.....
2008-12-17 21:37 <X0d_of_N0d> I never wanted to know anything about mrp...hehehe
2008-12-17 21:37 <vengfulsquirrel> ha yeah me either actually
2008-12-17 21:37 <vengfulsquirrel> or business programming in general
2008-12-17 21:37 <bechamel> snowch:
2008-12-17 21:37 <X0d_of_N0d> vengfulsquirrel: but it is kind of interesting...
2008-12-17 21:38 <vengfulsquirrel> Its definately full of hard to solve problems.
2008-12-17 21:38 <X0d_of_N0d> vengfulsquirrel: this kind of highly organized computing really drives powerful companies like walmart
2008-12-17 21:39 <X0d_of_N0d> vengfulsquirrel: the really interesting problem seems to be capacity planning
2008-12-17 21:39 <snowch> bechamel: thanks!
2008-12-17 21:39 <vengfulsquirrel> Yeah 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.
2008-12-17 21:39 <X0d_of_N0d> vengfulsquirrel: or rather MPS
2008-12-17 21:39 <X0d_of_N0d> + capacity planning
2008-12-17 21:39 <vengfulsquirrel> Yeah MPS II
2008-12-17 21:39 <X0d_of_N0d> vengfulsquirrel: right
2008-12-17 21:40 <vengfulsquirrel> I think a lot of smaller businesses won't need capacity planning.
2008-12-17 21:40 <X0d_of_N0d> vengfulsquirrel: well there are also a lot of different types of manufacturing operations
2008-12-17 21:41 <vengfulsquirrel> BUT automatic generation of planned purchase orders will be helpful or notifications to start producing sub-assemblies will be useful to small businesses
2008-12-17 21:41 <X0d_of_N0d> vengfulsquirrel: a textile company won't need the same bom complexity that a mechanical manufacturing company needs
2008-12-17 21:41 <X0d_of_N0d> vengfulsquirrel: right, especially the company I work for
2008-12-17 21:41 <vengfulsquirrel> Yeah i think the multi-level bom will scale pretty well though
2008-12-17 21:42 <vengfulsquirrel> Does your business require capacity planning ?
2008-12-17 21:42 <X0d_of_N0d> vengfulsquirrel: not immediately. we don't have it right now.
2008-12-17 21:42 <vengfulsquirrel> Yeah it might be more work than its worth to type in all the necessary constraints.
2008-12-17 21:43 <vengfulsquirrel> How many employees does your business have? (If I might ask)
2008-12-17 21:43 <X0d_of_N0d> I think it can be easily skipped in the first iteration of the mrp module...
2008-12-17 21:43 <vengfulsquirrel> Yeah or maybe even be pushed into a seperate module.
2008-12-17 21:43 <X0d_of_N0d> under 200
2008-12-17 21:44 <X0d_of_N0d> but we have software design, hardware design, manufacturing, and assembly all on site
2008-12-17 21:44 <X0d_of_N0d> as well as sales and clerical
2008-12-17 21:45 <vengfulsquirrel> ha wow yeah pretty diverse
2008-12-17 21:45 <X0d_of_N0d> yeah, it's interesting
2008-12-17 21:45 <X0d_of_N0d> we also have automated manufacturing, so a bunch of our manufacturing guys are programmers
2008-12-17 21:46 <vengfulsquirrel> Well if you had time some time I'd like to go over the minimum inputs and outputs you need from the system.
2008-12-17 21:46 <vengfulsquirrel> *From the MRP system
2008-12-17 21:46 -!- ikks(n=igor@ has joined #tryton
2008-12-17 21:46 <X0d_of_N0d> I'm currently importing data from our old system to tinyerp so we can test the mrp in there...
2008-12-17 21:47 <X0d_of_N0d> one of the things that tinyerp is missing is finite capacity scheduling, which we need
2008-12-17 21:47 <X0d_of_N0d> Once 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 here
2008-12-17 21:48 <X0d_of_N0d> Also I should be free to help you research the subject during our testing
2008-12-17 21:48 -!- Timitos(n=Timitos@ has joined #tryton
2008-12-17 21:53 <vengfulsquirrel> X0d_of_N0d: Okay sounds good, I'm going to just keep researching and looking at examples.
2008-12-17 21:55 <X0d_of_N0d> vengfulsquirrel: cool, you too man
2008-12-17 22:00 -!- snowch(n=snowch@ has left #tryton
2008-12-17 22:03 -!- snowch(n=snowch@ has joined #tryton
2008-12-17 22:06 <snowch> It 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?
2008-12-17 22:09 -!- yangoon1( has joined #tryton
2008-12-17 22:11 <CIA-53> tryton: vengfulsquirrel * r385 /wiki/ Took unintended emphasis off having single module in design doc.
2008-12-17 22:11 <CIA-53> tryton: * r386 /wiki/ Edited wiki page through web user interface.
2008-12-17 22:11 <bechamel> snowch: each db is prefixed by a module name, each <record model="model_name"> ...</> will create a new line in the table corresponding to model_name
2008-12-17 22:12 -!- mmarshall(n=mmarshal@ has joined #tryton
2008-12-17 22:12 -!- X0d_of_N0d(i=C-C_C-X@gateway/tor/x-9f9297a1caddb0be) has joined #tryton
2008-12-17 22:17 -!- Cristi_an(n=Cristi@ has joined #tryton
2008-12-17 22:24 <snowch> bechamel: 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?
2008-12-17 22:26 <bechamel> snowch: the xml is just there to dump data to the db, nothing else (the xml doesn't define the db schema or any logic).
2008-12-17 22:27 <snowch> bechamel: got it - thanks!
2008-12-17 22:29 <bechamel> table 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)
2008-12-17 22:30 <bechamel> @all: i think this kind of background info are really missing in the doc :)
2008-12-17 22:36 <snowch> for 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...
2008-12-17 22:39 -!- ikks(n=igor@ has joined #tryton
2008-12-17 22:41 <bechamel> snowch:
2008-12-17 22:48 <snowch> bechamel: many thanks, just what I was looking for! that info would be very useful in the model documentation...
2008-12-17 22:52 <CIA-53> tryton: 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 ...
2008-12-17 23:03 <CIA-53> tryton: C?dric Krier <> default * 401:c78a508b0055 stock/location.xml: Fix creation of warehouse and set noupdate to location data for issue682
2008-12-17 23:04 <CIA-53> tryton: ced roundup * #682/cannot install stock module: [resolved] Fix with changeset c78a508b0055
2008-12-17 23:14 <CIA-53> tryton: Timitos roundup * #679/KeyError: 'salable': [resolved] needed to clone my repositories again. seems like is was a mercurial handling issue.
2008-12-17 23:26 <CIA-53> tryton: 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 ...
2008-12-17 23:29 -!- TCW( has joined #tryton
2008-12-17 23:30 <TCW> panthera, *ping* :)
2008-12-17 23:30 <TCW> hi btw.
2008-12-17 23:30 <CIA-53> tryton: ced roundup * #683/label insertion not working?: [resolved] You put a capital letter to code for the label name.
2008-12-17 23:32 <snowch> is the tryton (tiny) orm framework homegrown, or is it based on an existing framework?
2008-12-17 23:40 <bechamel> snowch: completely homegrown unfortunately
2008-12-17 23:41 <Timitos> TCW: hi
2008-12-17 23:42 <TCW> hi Timitos :)
2008-12-17 23:49 <snowch> is 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...
2008-12-17 23:52 <bechamel> snowch: yes we know that, and we talked a lot about this but it's a difficult task
2008-12-17 23:56 <snowch> bechamel: 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!

Generated by 2.17.3 by Marius Gedminas - find it at!