IRC Channels
For open discussions, an IRC Channel have been set up for Open ERP and Open Object: irc://irc.freenode.net/#openobject.
Wednesday, 2010-06-09
| *** bechamel has quit IRC | 00:34 | |
| *** komsas has quit IRC | 00:47 | |
| *** ovnicraft has joined #openobject | 02:30 | |
| *** ovnicraft has quit IRC | 03:46 | |
| *** ToadP has joined #openobject | 05:40 | |
| *** ToadP1 has joined #openobject | 05:40 | |
| *** mr_amit has joined #openobject | 06:58 | |
| *** julian1828 has quit IRC | 07:23 | |
| *** julian1828 has joined #openobject | 07:24 | |
| *** rationalperseus has joined #openobject | 08:34 | |
| *** bechamel has joined #openobject | 08:35 | |
| *** eLBati has joined #openobject | 08:51 | |
| *** cedk has quit IRC | 08:56 | |
| *** mrcast has joined #openobject | 08:59 | |
| *** enlightx has joined #openobject | 08:59 | |
| *** Janneman1 has joined #openobject | 09:05 | |
| *** cjeske has joined #openobject | 09:17 | |
| *** simahawk has joined #openobject | 09:23 | |
| *** julian1828 has quit IRC | 09:25 | |
| *** julian1828 has joined #openobject | 09:25 | |
| *** cedk has joined #openobject | 09:29 | |
| *** mrcast has quit IRC | 09:31 | |
| *** cedk has quit IRC | 09:32 | |
| *** mrcast has joined #openobject | 09:34 | |
| *** bechamel has quit IRC | 10:13 | |
| *** Flydoire|Taktik has joined #openobject | 10:21 | |
| *** ludo2 has joined #openobject | 10:27 | |
| *** yangoon_rm has joined #openobject | 10:31 | |
| *** edannenbe has joined #openobject | 10:32 | |
| *** kalymero has joined #openobject | 10:44 | |
| *** Red15 has joined #openobject | 10:44 | |
| *** rationalperseus has quit IRC | 10:47 | |
| *** Nyx has joined #openobject | 10:52 | |
| *** enlightx_ has joined #openobject | 11:13 | |
| *** enlightx has quit IRC | 11:15 | |
| *** enlightx_ has quit IRC | 11:16 | |
| *** enlightx has joined #openobject | 11:17 | |
| *** hawodi has joined #openobject | 11:54 | |
| hawodi | Hello all. | 11:56 |
|---|---|---|
| hawodi | How do I put a horizontal bar on a column in a report e.g total column will have a horizontal bar with the total sum below that horizontal bar. | 11:57 |
| hawodi | example of this is found in customer invoice. Also, how do I apply color to some of the columns in the report? Thanks. | 11:59 |
| Red15 | hawodi, are you using openoffice sxw format or editing rml directly ? | 12:15 |
| hawodi | Red15:Am creating the report from Dashboards->configuration->custom reports | 12:17 |
| Red15 | dont think you can add color or custom bars etc there | 12:18 |
| *** hawodi has quit IRC | 12:21 | |
| *** Marcel|HSD has joined #openobject | 12:24 | |
| *** digitalsatori has joined #openobject | 12:26 | |
| *** Janneman1 has quit IRC | 12:30 | |
| *** hawodi has joined #openobject | 12:31 | |
| hawodi | Red15: Thanks. Where can I do that? | 12:31 |
| Red15 | create a full report, using openoffice -> sxw -> sxw2rml toolchain | 12:31 |
| Red15 | http://doc.openerp.com/developer/3_11_reports/11_1_openoffice_report.html | 12:32 |
| *** enlightx is now known as enlightx|away | 12:37 | |
| *** Flydoire|Taktik has quit IRC | 12:38 | |
| *** vockso has joined #openobject | 12:40 | |
| *** Flydoire|Taktik has joined #openobject | 12:40 | |
| hawodi | Red15: Thanks. | 12:43 |
| hawodi | Red15: Am looking at it now. | 12:43 |
| *** Zmanu has joined #openobject | 12:50 | |
| Zmanu | hello | 12:50 |
| Zmanu | is it possible to install openerp but only with module for suppliers ? | 13:02 |
| *** mmahir has joined #openobject | 13:03 | |
| mmahir | i have problem in creation the invoice | 13:03 |
| mmahir | hi | 13:04 |
| mmahir | sorry | 13:04 |
| mmahir | i have | 13:04 |
| mmahir | problem with creation the invoice in openerp | 13:04 |
| mmahir | can any when help me | 13:05 |
| *** Nyx has left #openobject | 13:11 | |
| *** Janneman1 has joined #openobject | 13:12 | |
| Red15 | mmahir, what is the problem ? | 13:14 |
| Red15 | paste the full output on http://openerp.pastebin.com | 13:14 |
| *** mmahir_ has joined #openobject | 13:19 | |
| *** enlightx|away is now known as enlightx | 13:20 | |
| *** mmahir has quit IRC | 13:22 | |
| *** mmahir_ is now known as mmahir | 13:22 | |
| Red15 | mmahir, what is the problem ? paste output on http://openerp.pastebin.com | 13:23 |
| Zmanu | so with openerp i can't install only some modules | 13:24 |
| Red15 | Zmanu, each module can specify its own dependencies | 13:24 |
| Red15 | Zmanu, so you can't really just pick one module because it will interact with some others | 13:24 |
| Red15 | Zmanu, what you might want is to hide other menu options maybe ? | 13:25 |
| Zmanu | Red15: ok, because at this time i only need supplier module, later maybe use more, but i want to have something very simple to start | 13:25 |
| Zmanu | Red15: yes, if i can hide, that can be useful | 13:25 |
| Red15 | it will be more effort to hide it than to just ignore it... | 13:25 |
| Zmanu | Red15: by default it's not possible ? | 13:26 |
| *** bechamel has joined #openobject | 13:26 | |
| Red15 | Zmanu, yes you can make a user which is only responsible for purchases | 13:26 |
| Zmanu | and so in menu it can only see activity for suppliers and not more | 13:28 |
| Red15 | yes | 13:31 |
| edannenbe | Red15, is it possible to initialise a orm wizard model before the view pops up? i want to insert some dynamic rows in one2many relation, but even abusing a _defaults it only gets triggered after the view already got displayed | 13:32 |
| Red15 | not sure why _defaults wouldn't be enough | 13:33 |
| Red15 | it should fill in the default values before you actually see the form ... (maybe 0.1s later but is that a problem?) | 13:33 |
| Zmanu | Red15: is it possible to test this in a demo ? | 13:36 |
| edannenbe | Red15, hmm actually it gets triggered before the view gets displayed, but i dont have context on the memory model about to be displayed in that function | 13:37 |
| Red15 | Zmanu, yes create a new user, give him only purchase Administration group | 13:37 |
| Red15 | what are you expecting in context then ? | 13:38 |
| Red15 | edannenbe, are you trying to make it link back to the model that opened the osv_memory or something similar ? | 13:38 |
| edannenbe | Red15, that would also be a solution | 13:38 |
| edannenbe | one sec, gotta afk a min | 13:38 |
| Red15 | edannenbe, keep in mind pre 5.0.7 there is a bug preventing context to be passed from view -> osv_memory | 13:39 |
| Zmanu | thanks for answers Red15 | 13:41 |
| *** simahawk is now known as simahawk|lunch | 13:42 | |
| edannenbe | Red15, what im trying to do is pretty simple i would think, a variant wizard holding some default values, after you press button it will generate temporary variants in another orm with a many2one on the wizard which get displayed in the 2nd step | 13:48 |
| *** yangoon_rm has quit IRC | 13:48 | |
| *** cedk has joined #openobject | 13:49 | |
| *** cedk_ has joined #openobject | 13:49 | |
| Red15 | edannenbe, this is on a product.product i presume ? | 13:49 |
| edannenbe | product.template as we made some changes to the dimensions, they are not anymore tied to a template, global instead | 13:49 |
| *** cedk_ has quit IRC | 13:49 | |
| edannenbe | but thats besides the point :) | 13:50 |
| *** cedk has quit IRC | 13:50 | |
| *** cedk has joined #openobject | 13:50 | |
| Red15 | so in context you should have an 'active_id' which is the id of the product.product you launched wizard from ? | 13:51 |
| edannenbe | yup | 13:51 |
| edannenbe | but i dont have context on what will be the next id of the orm | 13:52 |
| Red15 | why would you need the id of the orm ? | 13:52 |
| Red15 | and of what orm ? | 13:52 |
| edannenbe | the wizard orm i want to link the temporay variants to | 13:53 |
| Red15 | why are you going to link the osv_memory wizard to some other record ? | 13:54 |
| Red15 | it should be the other way | 13:54 |
| Red15 | you link the other records inside your osv_memory | 13:54 |
| edannenbe | hmm, lemme throw something up on pastebin sec | 13:54 |
| edannenbe | Red15, http://pastebin.com/SFHCzrTW thats the general structure i got at the moment, if got a way to write setting lines linked to wizard about to be displayed all would be good | 13:58 |
| edannenbe | if i* | 13:59 |
| edannenbe | i thought about just linking the setting lines to the product.template id, but then how do i display that in the wizard | 14:00 |
| Red15 | what kind of _default function have you created ? | 14:00 |
| edannenbe | http://pastebin.com/hCkKkEhw the _init_Variants() functions, it basicly checks if there are already settings lines for this wizard and if not creates them | 14:03 |
| edannenbe | function* | 14:03 |
| edannenbe | as you can see on the ugly (self.next_id+1), i dont got the id of the wizard record in the context at that point | 14:04 |
| edannenbe | what would also work if i could return a reference to the same wizard record from step1 again to be displayed in another form view | 14:06 |
| edannenbe | but i did not find anything on that >< | 14:06 |
| Red15 | why do you do id+1 ?? | 14:11 |
| Red15 | can you paste the init_variants ? | 14:12 |
| edannenbe | sure one sec, although it wont be much of help with the problem at hand i think | 14:12 |
| edannenbe | the +1 is because the actual record for the orm wizard hasnt been written yet by the system | 14:13 |
| edannenbe | so on first call next_id is 0 | 14:13 |
| Red15 | you should create a _default function for your 'setting_ids' fields | 14:15 |
| edannenbe | http://pastebin.com/1sG8Byp7 | 14:15 |
| Red15 | the way i do it is like this: | 14:17 |
| Red15 | i create a button on the osv_memory view | 14:17 |
| Red15 | that button is type='object' and so calls a memberfunction of the osv_memory class I created | 14:18 |
| Red15 | so you get an empty view first, then click a button (for me you even have to enter a few missing parameters) | 14:18 |
| Red15 | and the one2many are filled then | 14:18 |
| Red15 | would that not be feasible for you too ? | 14:19 |
| edannenbe | i did this first too, but how do you get back the view then after you press the button | 14:19 |
| hawodi | where is the link to report_openoffice_sample . Its not in the report_openoffice folder. | 14:19 |
| Red15 | edannenbe: the button does not change the view for me ... | 14:21 |
| edannenbe | oh ic, maybe there is my problem | 14:23 |
| edannenbe | what do you use for return to not change the view? | 14:24 |
| Red15 | i don't return anything :) | 14:24 |
| edannenbe | doh :) | 14:25 |
| edannenbe | lemme try | 14:25 |
| Red15 | btw if you would really like it to happen automatically i think you might have to overwrite the create function | 14:26 |
| Red15 | there you should have an id as soon as you have called super(your_class, self).create(cr, uid, vals, context) | 14:26 |
| *** pepeu has joined #openobject | 14:30 | |
| *** vockso has quit IRC | 14:31 | |
| edannenbe | Red15, cheers, staying on the same view will do nicely for now | 14:31 |
| edannenbe | i tried that yesterday too at one point but got a weird error which i dont get anymore, prolly was something else | 14:31 |
| hawodi | found it. | 14:32 |
| *** pepeu has quit IRC | 14:37 | |
| *** simahawk|lunch is now known as simahawk | 14:43 | |
| *** mmahir_ has joined #openobject | 15:01 | |
| *** mmahir has quit IRC | 15:04 | |
| *** mmahir_ is now known as mmahir | 15:04 | |
| *** mrcast has quit IRC | 15:07 | |
| *** mrcast has joined #openobject | 15:07 | |
| *** yangoon_rm has joined #openobject | 15:11 | |
| *** r3c4ll has joined #openobject | 15:16 | |
| *** marcelo has joined #openobject | 15:20 | |
| marcelo | algum brasileiro q possa me ajuda? | 15:20 |
| *** julian1828 has left #openobject | 15:24 | |
| hawodi | simahawk:Hello. Please, where can I get the obeject name for the placeholders for the openreport engine. | 15:27 |
| simahawk | hawodi, hi, what do you mean for "obeject name for the placeholders"? | 15:29 |
| simahawk | you mean "how to display what in the placeholder"? | 15:30 |
| simahawk | in that case you have to hit "ctrl+f9" | 15:31 |
| hawodi | simahawk: For example, if I need to create a report for sales order, I would need certain fields in the placeholder. Where do I get the fields from? | 15:31 |
| simahawk | ahhh | 15:31 |
| *** max3903 has joined #openobject | 15:31 | |
| simahawk | well, u have to know the names of the fields... | 15:31 |
| simahawk | some options: look at the code of the obj or place a pdb before the object is passed to the report engine and debug it | 15:32 |
| simahawk | or look at the object's table in postgres | 15:33 |
| simahawk | unfortunately there's no easy way for the time being | 15:33 |
| hawodi | simahawk: It would be cool if one link to the fields from openoffice. But from the docs, well done. | 15:34 |
| simahawk | another option is to use tiny's OOo plugin *ONLY* to see the object's structure | 15:34 |
| simahawk | *NOT TO* insert them | 15:34 |
| hawodi | Ok. | 15:34 |
| simahawk | hawodi, the future will be to have a plugin like the one I mentioned | 15:34 |
| hawodi | Can I use the report as part of a dashboard? | 15:35 |
| simahawk | but the official report machinery is going ti be replaced...so maybe is not worth to code it now | 15:35 |
| hawodi | any preview of how the new report machinery will look? | 15:36 |
| simahawk | no, AFAIK | 15:36 |
| hawodi | simahawk: Can I use the report with a dashboard? | 15:38 |
| hawodi | How do I place several reports in a dasboard like the Accounting Dashboard | 15:39 |
| simahawk | hawodi, OOo reports has nothing to do with dashboards | 15:39 |
| simahawk | has/have | 15:39 |
| hawodi | ok. But I can open the OOo reports in Openerp, right? | 15:40 |
| simahawk | hawodi, u can't OE is not an odt editor/viewer | 15:44 |
| hawodi | simahawk: Am lost here. What's OE? | 15:45 |
| simahawk | OpenERP :) | 15:45 |
| Red15 | OOo reports are used to generate pdfs | 15:46 |
| Red15 | with the data from openerp | 15:46 |
| Red15 | and layout from your xsw / rml file | 15:46 |
| hawodi | simahawk & Red15: Thanks. OOo report is clear now. | 15:56 |
| simahawk | hawodi, welcome | 15:56 |
| hawodi | Red15: Any directions on how I can create/edit dashboards like Accounting Dashboard? | 15:57 |
| *** marcelo has quit IRC | 16:01 | |
| *** bechamel has quit IRC | 16:03 | |
| *** Ribo_ has joined #openobject | 16:09 | |
| Ribo_ | Ola | 16:10 |
| Ribo_ | Bom dia | 16:10 |
| la_loOse | català or portuguese ? | 16:10 |
| Ribo_ | Catalâ nascido no Brasil | 16:11 |
| Ribo_ | portuguese | 16:12 |
| *** Janneman1 has quit IRC | 16:24 | |
| *** Ribo_ has quit IRC | 16:25 | |
| *** Marcel|HSD has left #openobject | 16:37 | |
| *** cjeske has quit IRC | 16:39 | |
| *** digitalsatori has quit IRC | 16:54 | |
| *** under__ has joined #openobject | 16:55 | |
| *** hawodi has quit IRC | 17:21 | |
| *** edannenbe has quit IRC | 17:26 | |
| *** javivf has joined #openobject | 17:36 | |
| *** hawodi has joined #openobject | 17:42 | |
| *** apoh has joined #openobject | 17:44 | |
| apoh | hi there | 17:44 |
| apoh | did someone know if theres a way for multiple inherintance for models? | 17:45 |
| hawodi | simahawk: can one add color to the fields? | 17:58 |
| *** Zmanu has quit IRC | 18:07 | |
| Red15 | apoh, yes, but it depends on what exactly ou want to do | 18:10 |
| Red15 | you* | 18:10 |
| *** ovnicraft has joined #openobject | 18:12 | |
| apoh | Red15 i've designed a model with lot of fields and did need these fields on an other model too | 18:12 |
| Red15 | do you know about _inherits ? | 18:12 |
| apoh | Red15 can i do this with '_inhertis'? | 18:12 |
| Red15 | not sure myself, have never used _inherits | 18:13 |
| apoh | hmm ok. i will try out _inhertis. if that works i will told u :) | 18:14 |
| *** cedk has quit IRC | 18:20 | |
| *** apoh has quit IRC | 18:24 | |
| *** ludo2 has quit IRC | 18:30 | |
| *** javivf has quit IRC | 18:30 | |
| *** eLBati has quit IRC | 18:50 | |
| *** kalymero has quit IRC | 18:51 | |
| *** enlightx has quit IRC | 18:55 | |
| *** simahawk has quit IRC | 19:01 | |
| *** Flydoire|Taktik has quit IRC | 19:13 | |
| *** edannenbe has joined #openobject | 19:17 | |
| *** cedk has joined #openobject | 19:20 | |
| *** Red15 has quit IRC | 19:32 | |
| *** mrcast has quit IRC | 19:41 | |
| *** r3c4ll has quit IRC | 19:50 | |
| *** enlightx has joined #openobject | 19:52 | |
| *** ovnicraft has quit IRC | 20:07 | |
| *** Gavin_Achado has joined #openobject | 20:12 | |
| *** mrcast has joined #openobject | 20:13 | |
| *** ovnicraft has joined #openobject | 21:05 | |
| *** ovnicraft has quit IRC | 21:16 | |
| *** ovnicraft has joined #openobject | 21:20 | |
| *** simahawk has joined #openobject | 21:20 | |
| *** tc0703 has joined #openobject | 21:40 | |
| zigzapgabe | hey all, i backed up a database and imported it into a new install of openerp | 21:40 |
| zigzapgabe | now i cannot login with my credentials | 21:40 |
| zigzapgabe | any suggestions? | 21:40 |
| zigzapgabe | i have pgAdmin III open looking through the db, but i dont know where i can verify the settings | 21:41 |
| cedk | zigzapgabe: passwords are stored in clear text in the table res_users | 21:41 |
| zigzapgabe | thanks :) | 21:42 |
| zigzapgabe | cedk: you are the best. | 21:42 |
| zigzapgabe | cedk: i am looking at that now in pgAdmin III, but since I am not very familiar in this db editor, I dont know what view i should look for next, once i have highlighted the table | 21:43 |
| cedk | zigzapgabe: that's why I work on Tryton instead of OpenERP :-) | 21:43 |
| zigzapgabe | cedk: i will def have to check out Tryon, never heard of it before | 21:44 |
| cedk | zigzapgabe: I don't know pgAdmin. I only use psql from command line | 21:44 |
| zigzapgabe | ok | 21:44 |
| cedk | zigzapgabe: the sql query will look like: | 21:44 |
| tc0703 | hi all, I'm planning to run 3 independent openerp servers (devel-server, test-server, prod-server) in multiple virtual-machines. What would the recommendation be on CPU and memory? | 21:44 |
| cedk | zigzapgabe: SELECT * from res_users; | 21:44 |
| zigzapgabe | cedk: ok, does tryon have a gui i can run from ssh -X ? | 21:45 |
| zigzapgabe | cedk: and do you fee it is more stable, and why? | 21:46 |
| cedk | zigzapgabe: never tested ssh -X but if you can with OE then it should be | 21:48 |
| cedk | zigzapgabe: more stable because of release policy and real codereview | 21:48 |
| zigzapgabe | cedk: is it built on the same framework? | 21:48 |
| cedk | zigzapgabe: it is a fork | 21:48 |
| zigzapgabe | cedk: gotcha. I am trying to decide what to implement internally and ultimately support for clients | 21:49 |
| zigzapgabe | cedk: also - do you think i can import an existing openerp database into it? | 21:49 |
| cedk | zigzapgabe: no because we had redesigned the data model | 21:51 |
| zigzapgabe | tc0703: i am no expert at this, but i'm running openerp on Ubuntu 10.04 with 512 of RAM | 21:53 |
| cedk | tc0703: in fact it is really hard to answer to such question | 21:54 |
| cedk | tc0703: we need to know: number of users, number of transaction per second, amount of data etc. | 21:56 |
| zigzapgabe | tc0703: i'd say you need to take into consideration how many users you have, and where you are hosting, etc | 21:56 |
| *** simahawk has quit IRC | 22:03 | |
| *** ludo2 has joined #openobject | 22:08 | |
| tc0703 | zigzapgabe, cedk: Well initially the number of users will probably be limited... 20 to 100 users on the production system. Test and development will have much less load seen their nature. | 22:09 |
| tc0703 | Later on number of users will grow till ... (depending on success of the story ;)) | 22:09 |
| zigzapgabe | tc0703: again, not being an expert, i would throw as much in the way of resources as i could at it. | 22:10 |
| cedk | tc0703: user number is a parameter but the most important is the number of transaction | 22:11 |
| tc0703 | zigzapgabe: well, yes if I would be buying the server itself I would indeed do that. However, it will be a dedicated server located in a datacenter... | 22:11 |
| tc0703 | cedk: Understood. Are there some guidelines on such numbers you know of? | 22:12 |
| cedk | tc0703: you should look at PostgreSQL website | 22:13 |
| tc0703 | cedk: OK | 22:13 |
| cedk | tc0703: after that python code will not require too much | 22:15 |
| cedk | tc0703: but it can be become too slow if there is too much request | 22:16 |
| tc0703 | cedk: So it might be worth it considering separating the DB from the OpenERP servers from the beginning | 22:16 |
| cedk | tc0703: and you must know that OE python code will use only one core | 22:16 |
| cedk | tc0703: yes if you don't have a high speed connection between both | 22:17 |
| tc0703 | cedk: because python in itself doesn't support multiple CPU's, right? | 22:17 |
| cedk | tc0703: because OE will make a lot of queries | 22:17 |
| cedk | tc0703: yes, all the threads of one python process run one after one | 22:17 |
| tc0703 | cedk: connection speed should not be an issue since both servers would be hosted in the same datacenter in that case | 22:18 |
| tc0703 | cedk: thanks | 22:18 |
| *** ToadP has quit IRC | 22:42 | |
| zigzapgabe | cedk: any idea what this error is telling me? "ProgrammingError: cannot change data type of view column "total_difference" from numeric to double precision" | 22:44 |
| *** ToadP has joined #openobject | 22:44 | |
| *** yangoon_rm has quit IRC | 22:45 | |
| *** yangoon_rm1 has joined #openobject | 22:45 | |
| *** yangoon_rm1 has quit IRC | 22:48 | |
| *** yangoon_rm has joined #openobject | 22:48 | |
| *** ToadP1 has quit IRC | 22:48 | |
| *** ToadP has quit IRC | 22:48 | |
| *** yangoon_rm1 has joined #openobject | 22:49 | |
| *** yangoon_rm has quit IRC | 22:49 | |
| *** simahawk has joined #openobject | 23:11 | |
| *** hawodi has quit IRC | 23:21 | |
| *** mrcast has quit IRC | 23:31 | |
| *** mr_amit has quit IRC | 23:38 | |
| *** bechamel has joined #openobject | 23:40 | |
| *** yangoon_rm1 has quit IRC | 23:43 | |
| *** yangoon_rm has joined #openobject | 23:57 | |
| *** enlightx has quit IRC | 23:58 | |
| *** Gavin_Achado has left #openobject | 00:02 | |
| tc0703 | The actual modules which are activated, can they be activated per database (by the database admin) or is that something which is a global activation for all databases the OpenERP server can connect to? | 00:03 |
| *** ludo2 has quit IRC | 00:04 | |
| *** simahawk has quit IRC | 00:10 | |
| *** yangoon_rm has quit IRC | 00:13 | |