| *** cedk has quit IRC | 00:03 |
| *** julian1828 has left #openobject | 00:29 |
| *** yangoon_rm has joined #openobject | 00:29 |
| *** yangoon_rm has left #openobject | 00:30 |
| *** bechamel has quit IRC | 01:00 |
| *** rsampaio has quit IRC | 02:50 |
| *** Stattrav has quit IRC | 03:50 |
| *** Stattrav has joined #openobject | 04:23 |
| *** febb has quit IRC | 05:00 |
| *** yangoon has quit IRC | 05:03 |
| *** yangoon has joined #openobject | 05:18 |
| *** hounddog has quit IRC | 05:31 |
| *** julian1828 has joined #openobject | 06:07 |
| *** julian1828 has quit IRC | 06:16 |
| *** febb has joined #openobject | 06:26 |
| *** julian1828 has joined #openobject | 06:45 |
| *** hounddog has joined #openobject | 06:57 |
| *** hounddog has quit IRC | 07:57 |
| *** quodt has joined #openobject | 08:27 |
| *** hounddog has joined #openobject | 08:28 |
| *** sharoon has joined #openobject | 08:37 |
| *** Janneman1 has joined #openobject | 08:38 |
| *** mrcast has joined #openobject | 08:43 |
| *** mr_amit has joined #openobject | 08:52 |
| *** enlightx has joined #openobject | 08:54 |
| *** mr_amit has quit IRC | 08:59 |
| *** javivfAfk is now known as javivf | 09:02 |
| javivf | morning | 09:02 |
|---|
| *** edannenbe has joined #openobject | 09:09 |
| *** eLBati has joined #openobject | 09:12 |
| *** mr_amit has joined #openobject | 09:15 |
| *** cedk has joined #openobject | 09:25 |
| *** Janneman1 has quit IRC | 09:40 |
| *** javivf has quit IRC | 09:44 |
| *** javivf has joined #openobject | 09:48 |
| *** ludo2 has joined #openobject | 09:49 |
| *** rationalperseus has joined #openobject | 09:52 |
| *** jehan_ has joined #openobject | 10:02 |
| *** Red15 has joined #openobject | 10:13 |
| *** bechamel has joined #openobject | 10:27 |
| *** mlhamel has joined #openobject | 10:34 |
| *** dukai has joined #openobject | 10:42 |
| *** Red15-Bubbles-IT has joined #openobject | 11:19 |
| *** Red15 has quit IRC | 11:23 |
| *** sveri has joined #openobject | 11:31 |
| sveri | hi, does somebody know how i can retrieve the product description in the order reports? [[line.description]] doesnt work :( | 11:32 |
|---|
| *** Red15-Bubbles-IT is now known as Red15 | 11:41 |
| alex_joni | sveri: what object do you reference in the order report? | 11:47 |
|---|
| alex_joni | sale.order? purchase.order? | 11:47 |
|---|
| sveri | [[repeatIn(o.order_line,'line')]] | 11:48 |
|---|
| alex_joni | that's the line | 11:48 |
|---|
| alex_joni | sveri: you have a report defined | 11:49 |
|---|
| sveri | ah, i have to add an extra one for the purchase? | 11:49 |
|---|
| alex_joni | hang on | 11:49 |
|---|
| alex_joni | lets start from the beginning | 11:49 |
|---|
| sveri | ok | 11:49 |
|---|
| alex_joni | you have a report defined | 11:49 |
|---|
| sveri | i exported the standard order report into openeoffice | 11:49 |
|---|
| alex_joni | there are 2 reports, one for sale order one for purchase order | 11:49 |
|---|
| sveri | uhm, wait, i have it in german | 11:50 |
|---|
| sveri | its hard to translate | 11:50 |
|---|
| alex_joni | when I want to export an order form I get to chose from: Production Order, Purchase Order, sale.order and repair.order | 11:50 |
|---|
| alex_joni | sveri: say it in german, it's ok for me | 11:50 |
|---|
| sveri | i mean the verkaufsangebot | 11:51 |
|---|
| alex_joni | that is sale order | 11:51 |
|---|
| sveri | ah ok | 11:51 |
|---|
| sveri | i always mix up order and offer | 11:51 |
|---|
| alex_joni | offer is not really an english word | 11:51 |
|---|
| alex_joni | it's quotation ;) | 11:51 |
|---|
| alex_joni | ok, so sale order / quotation | 11:52 |
|---|
| sveri | i exported it to openoffice format with the base_report_designer | 11:52 |
|---|
| sveri | hehe, i see | 11:52 |
|---|
| alex_joni | right | 11:52 |
|---|
| alex_joni | now.. that report is done on the sale.order object | 11:52 |
|---|
| sveri | hm, where can i see thatV | 11:52 |
|---|
| alex_joni | if you look at Administration->Low Level Objects->Actions->Report XML | 11:52 |
|---|
| sveri | ß | 11:52 |
|---|
| sveri | ah, i see | 11:53 |
|---|
| alex_joni | for me it's: Name: Quotation/Order, Type: ir.actions.report.xml, XML: sale.order, Type: pdf | 11:53 |
|---|
| alex_joni | the sale.order is the important part now | 11:53 |
|---|
| sveri | yea, thats what i got too | 11:53 |
|---|
| alex_joni | now we want to see what fileds sale.order has | 11:53 |
|---|
| alex_joni | fields* even | 11:54 |
|---|
| sveri | ok | 11:54 |
|---|
| alex_joni | go to: Administration->Customization->Database structure->Objects | 11:54 |
|---|
| alex_joni | look for sale.order | 11:54 |
|---|
| sveri | i got it | 11:54 |
|---|
| alex_joni | sale.order is the whole sale object | 11:54 |
|---|
| alex_joni | but it has inside it one field called order_line which is one2many | 11:55 |
|---|
| alex_joni | that means that there can be more than one order_line's | 11:55 |
|---|
| sveri | ok, i understand | 11:55 |
|---|
| alex_joni | if you look at order_line you will see that it's one2many and Object Relation is sale.order.line | 11:55 |
|---|
| alex_joni | [[repeatIn(o.order_line,'line')]] | 11:56 |
|---|
| sveri | ok | 11:56 |
|---|
| alex_joni | that means line will cycle through all o.order_line | 11:56 |
|---|
| alex_joni | so it's of type sale.order.line | 11:56 |
|---|
| alex_joni | now we look at the object sale.order.line | 11:57 |
|---|
| sveri | ok, up to this point everything is logic | 11:57 |
|---|
| sveri | i got it, i mean sale.order.line | 11:58 |
|---|
| alex_joni | yup | 11:58 |
|---|
| alex_joni | now you see that sale.order.line has lots of fields which you don't need now, but there's a product reference | 11:58 |
|---|
| * alex_joni waits for sveri to find it | 11:59 |
| sveri | you mean product_id? | 11:59 |
|---|
| alex_joni | yup | 11:59 |
|---|
| sveri | product.product | 11:59 |
|---|
| alex_joni | which is many2one that points to product.product | 11:59 |
|---|
| alex_joni | perfect | 11:59 |
|---|
| alex_joni | now we look at object product.product and look for the description | 12:00 |
|---|
| sveri | ok | 12:00 |
|---|
| sveri | hm, i dont see any description field | 12:00 |
|---|
| alex_joni | me neither | 12:00 |
|---|
| sveri | but product.template has a description field | 12:01 |
|---|
| alex_joni | right | 12:01 |
|---|
| alex_joni | description, description_sale and description_purchase | 12:01 |
|---|
| sveri | yea, indeed | 12:02 |
|---|
| alex_joni | now you decide which one you want, then we assemble the line to put in the report | 12:02 |
|---|
| sveri | i think i need tha basic description field | 12:02 |
|---|
| alex_joni | ok, we had line which referenced sale.order.line | 12:03 |
|---|
| sveri | yes | 12:03 |
|---|
| alex_joni | we want line.product_id (which references product) | 12:03 |
|---|
| sveri | ok | 12:03 |
|---|
| alex_joni | line.product_id.product_tmpl_id (references product template) | 12:03 |
|---|
| alex_joni | line.product_id.product_tmpl_id.description | 12:03 |
|---|
| sveri | ok, that sounds very logic | 12:03 |
|---|
| sveri | wow, it works instantly | 12:05 |
|---|
| sveri | this is so cool | 12:05 |
|---|
| sveri | thank you so much | 12:05 |
|---|
| alex_joni | sveri: now you should know how to do it for other fields | 12:06 |
|---|
| sveri | is that somewhere documented? | 12:06 |
|---|
| sveri | yea, i do know now | 12:06 |
|---|
| alex_joni | see log above ^^ | 12:06 |
|---|
| * alex_joni grins | 12:06 |
| alex_joni | sveri: not that I know.. | 12:06 |
|---|
| sveri | you taught me about how to fish | 12:06 |
|---|
| sveri | is it ok if i blog about it? | 12:07 |
|---|
| alex_joni | sveri: perfectly ok | 12:08 |
|---|
| alex_joni | the more information out there, the better | 12:08 |
|---|
| sveri | cool, thank you again | 12:08 |
|---|
| sveri | yea, thats true | 12:08 |
|---|
| alex_joni | just paste a link in here when you're done | 12:08 |
|---|
| alex_joni | ;) | 12:08 |
|---|
| sveri | ok | 12:08 |
|---|
| alex_joni | btw.. just [[ line.product_id.product_tmpl_id.description ]] isn't enough | 12:08 |
|---|
| sveri | not? but it works for me | 12:08 |
|---|
| alex_joni | that might cause errors if it's not existant | 12:08 |
|---|
| sveri | ah, true | 12:08 |
|---|
| alex_joni | use [[ line.product_id.product_tmpl_id.description or removeParentNode('para') ]] | 12:09 |
|---|
| alex_joni | [[ line.product_id.product_tmpl_id.description or '' ]] | 12:09 |
|---|
| sveri | yea, ok | 12:09 |
|---|
| alex_joni | [[ line.product_id.product_tmpl_id.description or removeParentNode('tr') ]] | 12:09 |
|---|
| alex_joni | either of the 3 will work but have 3 different results | 12:10 |
|---|
| alex_joni | the second is the simples, just put '' if it doesn't exist | 12:10 |
|---|
| sveri | i need the second one in my template | 12:10 |
|---|
| alex_joni | removeParentNode('para') removes the paragraph | 12:10 |
|---|
| alex_joni | and removeParentNode('tr') removes the table row | 12:10 |
|---|
| alex_joni | I usually have the description in a separate table row | 12:10 |
|---|
| sveri | yea, thats clearer | 12:11 |
|---|
| sveri | but for me its perfect to have it under the product name | 12:11 |
|---|
| alex_joni | right | 12:11 |
|---|
| alex_joni | I see the default report has a line.notes | 12:12 |
|---|
| sveri | yea, but that doesnt work for me | 12:12 |
|---|
| alex_joni | for me it gets filled out with description_sale | 12:12 |
|---|
| alex_joni | when I create a new sale/quotation | 12:12 |
|---|
| alex_joni | I assume the same happens on a purchase order with description_purchase | 12:13 |
|---|
| sveri | hm, it didnt for me | 12:13 |
|---|
| sveri | i tried a lot of things yesterday | 12:13 |
|---|
| alex_joni | well, if this works.. | 12:16 |
|---|
| sveri | yea, its always good to know the story behind it | 12:18 |
|---|
| *** enlightx has quit IRC | 12:22 |
| sveri | alex_joni: http://blog.sveri.de/index.php?/archives/155-openerp,-order-reports-and-product-description.html | 12:27 |
|---|
| *** mr_amit has quit IRC | 12:33 |
| *** sharoon has quit IRC | 12:34 |
| *** mr_amit has joined #openobject | 12:37 |
| alex_joni | sveri: super | 12:59 |
|---|
| sveri | : | 13:01 |
|---|
| sveri | :-) | 13:01 |
|---|
| alex_joni | sveri: http://blog.sveri.de/index.php?/archives/154-openerp,-report-and-translations.html | 13:04 |
|---|
| alex_joni | I always do the translations directly in the client | 13:05 |
|---|
| alex_joni | not the best habit, but it works the fastest | 13:05 |
|---|
| alex_joni | also, the last part on that page doesn't display here | 13:06 |
|---|
| *** enlightx has joined #openobject | 13:12 |
| *** rsampaio has joined #openobject | 13:14 |
| sveri | ah ok, thank you :-) | 13:22 |
|---|
| sveri | its all new to me, so i have to figure it out | 13:22 |
|---|
| *** ToadP has quit IRC | 14:15 |
| *** sharoon has joined #openobject | 14:26 |
| *** ToadP has joined #openobject | 14:44 |
| *** ToadP has quit IRC | 14:50 |
| *** ToadP has joined #openobject | 14:52 |
| *** amine has joined #openobject | 15:17 |
| amine | i there, i'm trying to hide a field depending on a value in a form, eg: if the field "name" contains "amine", then the field "surname" should be invisible | 15:19 |
|---|
| *** mr_amit has quit IRC | 15:21 |
| *** pepeu has joined #openobject | 15:42 |
| *** edannenbe has quit IRC | 16:08 |
| *** menols2 has joined #openobject | 16:09 |
| menols2 | hi all | 16:09 |
|---|
| menols2 | could someone tell me why a user can't create a partner even though the have the partner group permission? | 16:09 |
|---|
| *** edannenbe has joined #openobject | 16:10 |
| *** dukai has quit IRC | 16:19 |
| *** Red15 has quit IRC | 16:23 |
| menols2 | never mind | 16:29 |
|---|
| *** Red15 has joined #openobject | 16:35 |
| *** sharoon has quit IRC | 16:42 |
| *** amine has quit IRC | 16:50 |
| *** ToadP has quit IRC | 16:54 |
| *** ToadP has joined #openobject | 16:58 |
| *** ToadP has quit IRC | 17:13 |
| menols2 | openerp is very buggy! | 17:17 |
|---|
| menols2 | it allows somehow the creation of partial database entries | 17:21 |
|---|
| menols2 | resulting in errors such as this ProgrammingError: column "price_type" does not exist | 17:21 |
|---|
| menols2 | LINE 1: ...oice","period_id","move_id","amount_total","name","price_typ... | 17:21 |
|---|
| menols2 | no body has anything to say? | 17:22 |
|---|
| menols2 | fuck this | 17:25 |
|---|
| *** menols2 has left #openobject | 17:25 |
| *** bechamel has quit IRC | 17:27 |
| Red15 | haha, another one "i expect full commercial quality and idiot proof software" rant | 17:27 |
|---|
| Red15 | partial database entries my ass, he probably just added his own field of some sorts and did not upgrade the module in that database | 17:28 |
|---|
| enlightx | Red15: or he was using the trunk with 500 extra addons installed :) | 17:32 |
|---|
| *** mlhamel_ has joined #openobject | 17:41 |
| *** mlhamel has quit IRC | 17:43 |
| *** pepeu has quit IRC | 17:45 |
| *** ToadP has joined #openobject | 17:47 |
| *** javivf is now known as javivfAfk | 17:51 |
| *** edannenbe has quit IRC | 17:55 |
| *** eLBati has quit IRC | 17:57 |
| *** amine has joined #openobject | 18:10 |
| *** quodt has quit IRC | 18:11 |
| *** maggo has joined #openobject | 18:15 |
| maggo | hi all, anyone here how know something abaout openERP and base_report_unicode module? | 18:16 |
|---|
| *** enlightx has quit IRC | 18:25 |
| Red15 | about openerp, most of us will know something :) | 18:25 |
|---|
| Red15 | about base_report_unicode it's a bit harder | 18:25 |
|---|
| Red15 | but what i know of it is that it's just a fix to allow truetype fonts to be used in the reports | 18:26 |
|---|
| maggo | yes thats right, but i get permanently unicode failures if i print a custom report on openerp | 18:28 |
|---|
| maggo | although i have installed this module | 18:29 |
|---|
| maggo | i tried out the newest version via bzr to but no improvment | 18:30 |
|---|
| Red15 | i think the issue is that inside your reports you have to change the fonts used | 18:31 |
|---|
| maggo | ok and how can i do that? | 18:32 |
|---|
| Red15 | and the module allows you to specify TTF fonts, but does not map them automatically ? | 18:32 |
|---|
| Red15 | edit the rml files would be one way | 18:32 |
|---|
| maggo | ok and where are the rml file of my custom report? | 18:32 |
|---|
| *** ludo2 has quit IRC | 18:35 |
| maggo | red15: can you have a look at the last post of this topic http://www.openobject.com/forum/post52084.html#52084 | 18:40 |
|---|
| Red15 | sorry not too familiar with the module | 18:41 |
|---|
| Red15 | so i can't really tell a short fix for this | 18:42 |
|---|
| *** Red15 has quit IRC | 18:56 |
| *** ludo2 has joined #openobject | 18:57 |
| *** sharoon has joined #openobject | 19:11 |
| *** enlightx has joined #openobject | 19:29 |
| *** heg has joined #openobject | 19:35 |
| *** amine has quit IRC | 19:50 |
| maggo | Ha all, is there a file where the postgres password is stored | 19:50 |
|---|
| enlightx | maggo: it's stored inside postgresql itself | 19:53 |
|---|
| enlightx | if postgres (the user) has a password | 19:54 |
|---|
| maggo | ok and how do the opener-server know which password is to use for connecting the database? | 19:55 |
|---|
| enlightx | maggo: you have to specify user/pass | 19:56 |
|---|
| enlightx | on the command line, or inside the config file | 19:56 |
|---|
| maggo | where did you mean ? by installation or on login? | 19:56 |
|---|
| enlightx | initially, you need to create a postgresql user | 19:57 |
|---|
| enlightx | then you use that user to connect openerp-server to postgres | 19:57 |
|---|
| maggo | Ok ähm explain my problem in other words i try to connect to postgres database of openerp with jasper and need the password | 19:57 |
|---|
| enlightx | which user are you using with jasper? | 19:58 |
|---|
| maggo | ok and is this password stored in a file for openerp | 19:58 |
|---|
| maggo | i use postgres | 19:58 |
|---|
| enlightx | i suggest you to create a new user | 19:58 |
|---|
| maggo | hm new user for postgres with privileges for all databases read only? | 19:59 |
|---|
| enlightx | for all or just one...it depends on your needs | 20:00 |
|---|
| maggo | ok in productive environment i will do, but i only testing jasper and will get a connection can i reset the postgres password of the postgres unix user or do i have to change the password of the database user? | 20:01 |
|---|
| enlightx | maggo: btw, you can set a password for postgres an change ident with md5 inside the pg_hab.conf file | 20:04 |
|---|
| *** mlhamel_ has quit IRC | 20:06 |
| maggo | ok in this file all is on trust, so do i need a password? | 20:07 |
|---|
| *** mlhamel_ has joined #openobject | 20:08 |
| enlightx | maggo: with trust...every password you type should be ok | 20:10 |
|---|
| maggo | ok | 20:10 |
|---|
| maggo | i'll try | 20:10 |
|---|
| *** LucaSub1 has joined #openobject | 20:16 |
| *** LucaSub2 has joined #openobject | 20:16 |
| *** LucaSub1 has left #openobject | 20:18 |
| *** LucaSub2 has quit IRC | 20:18 |
| *** mrcast has left #openobject | 20:27 |
| *** mlhamel_ has quit IRC | 20:30 |
| *** rsampaio has quit IRC | 20:55 |
| *** bechamel has joined #openobject | 21:07 |
| *** ludo2 has quit IRC | 21:09 |
| *** febb has quit IRC | 21:37 |
| *** quodt has joined #openobject | 21:49 |
| *** julian1828 has left #openobject | 21:49 |
| *** maggo has quit IRC | 21:53 |
| *** rationalperseus has quit IRC | 22:04 |
| *** ludo2 has joined #openobject | 22:11 |
| *** ludo2 has quit IRC | 22:25 |
| *** enlightx has quit IRC | 22:58 |
| *** quodt has quit IRC | 23:21 |
| *** javivfAf1 has joined #openobject | 23:33 |
| *** javivfAfk has quit IRC | 23:35 |
| *** javivfAf1 has quit IRC | 23:41 |
| *** javivfAfk has joined #openobject | 23:42 |
| *** javivfAfk has quit IRC | 23:47 |
| *** javivfAfk has joined #openobject | 23:47 |
| *** javivfAfk has quit IRC | 23:52 |
| *** javivfAfk has joined #openobject | 23:52 |
| *** sveri has quit IRC | 23:57 |
| *** javivfAfk has quit IRC | 23:58 |
| *** javivfAfk has joined #openobject | 23:58 |
