IRC Channels

For open discussions, an IRC Channel have been set up for Open ERP and Open Object: irc://

Tuesday, 2010-04-27

*** rsampaio has joined #openobject00:19
*** eLBati has quit IRC00:21
*** rationalperseus has quit IRC00:29
*** Nyx has quit IRC00:31
*** cedk has quit IRC00:44
*** rsampaio has quit IRC00:51
*** pepeu has quit IRC01:45
*** Gavin_Achado has quit IRC02:19
*** ovnicraft has quit IRC02:30
*** bearcame has joined #openobject04:24
*** bearcame_ has joined #openobject04:24
*** cjalmeida has joined #openobject04:27
*** cjalmeida has quit IRC04:27
*** beunteu has quit IRC05:01
*** yangoon has quit IRC05:21
*** Gavin_Achado has joined #openobject05:26
*** Gavin_Achado has left #openobject05:26
*** yangoon has joined #openobject05:36
*** hounddog has joined #openobject07:04
*** Billynkid has joined #openobject07:06
*** Billynkid has quit IRC07:16
*** Billynkid has joined #openobject07:24
*** Billynkid has left #openobject07:24
*** cedk has joined #openobject08:06
*** Billynkid has joined #openobject08:39
*** eLBati has joined #openobject08:43
*** Billynkid has quit IRC08:44
*** Billynkid has joined #openobject08:47
*** Billynkid has quit IRC08:52
*** Billynkid has joined #openobject08:52
*** cedk has quit IRC09:00
*** Billynkid has quit IRC09:00
*** enlightx has joined #openobject09:08
*** simahawk has joined #openobject09:13
*** quodt has joined #openobject09:14
*** rona1 has joined #openobject09:26
*** cedk has joined #openobject09:27
*** javivf has joined #openobject09:28
*** newtoopenerp has joined #openobject09:44
newtoopenerphey guys. where is the QT client for openerp? I cant easily find it....09:44
*** simahawk has quit IRC09:45
*** simahawk has joined #openobject09:45
*** mrcast has joined #openobject09:49
*** newtoopenerp has quit IRC09:51
ecarrerasnewtoopenerp, the project's page:
*** mozmck_work1 has joined #openobject10:01
*** mozmck_work has quit IRC10:04
*** rationalperseus has joined #openobject10:08
*** ludo2 has joined #openobject10:17
*** simahawk has quit IRC10:24
*** eLBati has quit IRC10:26
*** ludo2 has joined #openobject10:35
*** simahawk has joined #openobject10:36
*** simahawk has quit IRC10:43
*** simahawk has joined #openobject10:43
*** komsas has joined #openobject11:02
*** Red15 has joined #openobject11:03
*** Nyx has joined #openobject11:04
*** bechamel has joined #openobject11:28
*** Billynkid has joined #openobject11:31
*** simahawk has quit IRC11:37
*** cedk has quit IRC11:39
*** Billynkid has quit IRC11:42
*** zipgem has joined #openobject11:44
zipgemRed15: hi, last week you told me how I can create an action with 2 new custom view (form/tree) associated without open the standard ... now I'd like to know how can I use the field sequence ...11:46
zipgemthank in advance11:46
Red15what do you men how you can use the field sequence ?11:49
*** simahawk has joined #openobject11:50
Red15you mean what would happen if you set higher/lower sequence ?11:50
*** Billynkid has joined #openobject11:50
*** Neveen has joined #openobject11:51
zipgemyes ... I try to set this value like 10 or 11 but it change the view of standard form and this is not what I want to do11:52
zipgemI want to create only new ... not override the standard11:53
*** Billynkid has left #openobject11:53
Red15set it to higher than 16 then i think11:53
Red15low number = higher priority11:53
Red15a bit weird when you think about it but consider they just use a sort on the sequence (so low comes before high)11:54
zipgemok ... thank you ... now I try11:55
NeveenHello , When am using "raise wizard.except_wizard(_('Message !'),_('No records returned with the selected criteria'))" it cause "except_wizard: ('Message !', 'No records returned with the selected criteria')" ??11:55
*** simahawk has quit IRC11:59
*** simahawk has joined #openobject11:59
*** simahawk_ has joined #openobject12:01
Red15Neveen, what else do you expect it to do then ?12:01
NeveenHello Red15, am expecting  to display a the written message12:02
Red15are you raising this exception in a wizard.interface class ?12:02
Red15are you sure you're not using an osv_memory style wizard ?12:03
*** simahawk has quit IRC12:05
NeveenRed15 : no am not, How can i display a message when result set is empty to not generating the report ??12:06
Red15so you're inside a report where you try to raise ?12:06
NeveenRed15 : inside class ticket(report_sxw.rml_parse):12:07
*** cedk has joined #openobject12:07
Red15just do raise _('Message'),_('No results for criteria')12:07
Red15example in auction/report/auction_invoice.py12:08
NeveenThanks a lot Red15, am trying it :)12:08
*** simahawk_ is now known as simahawk12:09
NeveenRed15 : it causes  "TypeError: exceptions must be classes or instances, not str"12:11
Red15Neveen, hmm i think your only other option is to either do this check on selection criteria in the wizard (before the report) or just print an empty report ...12:12
Red15it's not really a big deal is it ? an empty report ? as you have a preview12:12
NeveenRed15 : How can i display an empty report ??12:12
Red15if you iterate on an empty list it will only print things like headers etc12:21
Red15where you use repeatIn(...)12:21
zipgemRed15: so I've tried to set an high number on form view (like 30) but if I go to standard menu of account.analytic.account and click on analytic account form, appear my custom form and not the standard12:24
zipgemfor tree instead all is right: standard tree and custom tree ... I've tried also to not insert field sequence, but nothing change12:24
zipgemwhere I do mistake ??12:24
NeveenRed15 : i used it before the repeated section so when the result is empty it causes :"    for id in lst:12:25
NeveenTypeError: 'NoneType' object is not iterable"12:25
Red15Neveen, dont get None for lst, make sure you get an empty list = []12:25
*** Nyx has left #openobject12:25
Red15zipgem, that's weird ... in what record type did you set the sequence ?12:25
NeveenRed15 : Thanks i will check it :)12:26
Red15an empty list is always better because [] == False12:26
NeveenRed15 : i returned empty list [] if len(result) = 0 but it causes " IndexError: list index out of range"12:30
zipgemRed15: I paste the code
zipgemok ... I resolve the problem12:43
zipgemRed15: now I put into the view declaration the field priority with value 3012:43
zipgemand both standard view and custom view work correctly when I want12:44
zipgem... but ...12:44
zipgemcan I do the same with wizard ??? I created a wizard and I want to open custom view and custom tree ... is possible ?12:45
*** cedk has quit IRC12:45
*** yangoon has quit IRC12:53
*** Neveen has quit IRC12:54
*** yangoon has joined #openobject12:54
*** Neveen has joined #openobject12:55
*** enlightx has quit IRC13:00
Red15Neveen, dont use if len(result) == 013:25
Red15use "if not result"13:26
Red15as i said [] == false13:26
Red15[False] == True13:26
Red15zipgem, yes you can, just specify the view_id in the action you return13:26
*** bearcame_ has quit IRC13:32
*** bearcame has quit IRC13:32
NeveenRed15 : you mean return [] if not result13:35
Red15yea and also don't check the length it's a bad way for checking iterables13:35
*** simahawk is now known as simahawk|lunch13:37
*** simahawk_ has joined #openobject13:51
*** simahawk|lunch has quit IRC13:54
*** dodo has joined #openobject14:01
dodoHello, is ORing working with OpenERP web client? example: {'invisible':['|',('referencenumber','=','01'),('state','=','care_closed')]} a valid syntax?14:02
dodoI tried this diff too but till now it didn't work :S
zipgemhi again14:25
zipgemRed15: also if I want to open specific custom tree and specific custom form ??? like action ???14:26
Red15hmm zipgem not 100 sure, because action you return from wizard is just an action that is created 'on-the-fly' so you can't point your custom views to this action14:27
*** ToadP has quit IRC14:31
*** simahawk_ is now known as simahawk14:31
zipgemmhmmmmm ... :( ok I'll try14:31
*** dodo has quit IRC14:57
zipgemeheh ... DataError: invalid input syntax for integer: "i"14:58
zipgemthis error occurs when in my wizard I try to call view with parameter ---> 'view_id': 'custom_form_analyticaccount_bind',14:58
zipgemI think it is no possible because custom_... is not the value but an attribute ...14:58
*** ToadP has joined #openobject15:00
zipgemRed15: so in this case, the only way is to create a custom class based on the same table of account_analytic_account and associate the two custom view15:02
zipgemI'm wrong ???15:02
Red15zipgem, view_id expects an integer15:02
Red15so you have to either manually insert the id of your view in it15:03
Red15or do a search in your ir_model_data15:04
*** enlightx has joined #openobject15:05
zipgemeasy easy15:06
zipgembut in this case I can use only 1 custom view, not one for form and one for tree15:08
*** eLBati has joined #openobject15:11
*** quentin_theuret has joined #openobject15:16
Red15not sure i think there might be a way, let me search15:19
zipgemoh thank15:23
Red15i think you can include the parameter 'view_ids' (instead of view_id)15:26
Red15view_ids = [   {'view_id': 'custom_form_analyticaccount_bind', 'view_type': 'form'}, {'view_id': 'custom_tree ...', 'view_type': 'tree'} ]15:27
Red15inside that view_ids you can also specify a 'sequence' per view_id if you so wish15:27
zipgemwow ... I'll try it immediatly15:28
Red15also maybe in your top action add a 'view_type' : ('tree','form')15:29
Red15like you usually do on actions if they should be able to switch between both15:29
Red15btw dont copy & paste that line i did for view_ids15:29
Red15replace the custom_form_... names with the id's you looked up before15:30
zipgemfor example id for custom_form_analyticaccount_bind is 524: I write {'view_id': 524, ... }15:33
*** Billynkid has joined #openobject15:34
*** Billynkid has quit IRC15:43
*** Billynkid has joined #openobject15:43
Red15looks about right15:47
Red15might have to tinker a bit with the view_type and view_mode (on the top level)15:47
zipgembut the id of the view that I have to use, is id field in ir_model_data or in ir_ui_view ??15:51
*** simahawk__ has joined #openobject15:52
*** simahawk has quit IRC15:54
Red15zipgem, in ir_model_data you will see the link between the name you gave it in xml and the res_id (which points to the ir_ui_view with this id)16:03
zipgemso the right id is res_id in ir_model_data and id in ir_ui_view16:06
*** dodo has joined #openobject16:12
*** pheller has joined #openobject16:20
Red15res_id in ir_model_data == ir_ui_view.id16:21
Red15select * from ir_ui_view where id  in ( select res_id from ir_model_data where name = 'custom_form_analyticaccount_bind' )16:22
Red15if that makes it more clear to you ?16:22
*** Billynkid has quit IRC16:25
zipgemeheh ... I understand this, maybe I was not clear before ... I use in my wizard, for view_id, res_id16:25
zipgemonly this ... :)16:25
zipgemnow I'm trying to make work the wizard with my view ...16:26
*** Billynkid has joined #openobject16:26
*** Billynkid has left #openobject16:26
*** quodt has quit IRC16:29
*** xrg_ has joined #openobject16:29
*** quodt has joined #openobject16:33
NeveenHello Red15 , when am returning [] it causes "  File "/usr/lib/python2.6/dist-packages/reportlab/platypus/", line 1312, in _drawBkgrnd16:34
Neveen    y0 = rowpositions[sr]16:34
NeveenIndexError: list index out of range"16:34
*** quodt has quit IRC16:34
Red15hmm tricky ..16:34
Red15that's quite low level16:34
*** quodt has joined #openobject16:35
*** gego has joined #openobject16:37
NeveenRed15 : What is the type returned from cr.dictfetchall() ??16:38
Red15a list with dictionaries inside16:39
Red15[{'id':1},{'id':2}] and such16:39
NeveenRed15 : The id represent record id ??16:41
Neveenit must be an id ??16:41
*** sharoon has joined #openobject16:42
*** simahawk__ has quit IRC16:47
*** beunteu has joined #openobject16:50
Red15Neveen,just an example16:55
Red15as id is in everything16:55
Red15the dict keys are actually the columns names you selected16:55
NeveenRed15 : i tried list = [{'ref':''}] then return list16:55
Neveenit cause an error  File "/usr/local/lib/python2.6/dist-packages/openerp-server/report/render/rml2pdf/", line 114, in _process_text16:56
Neveen[2010-04-27 16:31:45,994] ERROR:report:[19]:     txt = eval(expr,self.localcontext)16:56
Neveen[2010-04-27 16:31:45,994] ERROR:report:[20]:   File "<string>", line 1, in <module>16:56
Neveen[2010-04-27 16:31:45,994] ERROR:report:[21]: KeyError: 'ref'16:56
Neveen[2010-04-27 16:31:45,994] ERROR:report:[22]:16:56
Neveen[2010-04-27 16:31:45,994] ERROR:report:[23]: 'ref'16:57
Neveen[2010-04-27 16:31:45,994] ERROR:report:[24]: expr: obj['ref']16:57
Red15in your report what do you have for repeatIn ?17:05
Neveen[[ repeatIn(get_data(data['form']['date1']),'obj') ]]17:08
Red15and you then do obj['ref'] somewhere inside this repeatIn ?17:09
Red15and i assume get_data returns cr.dictfetchall() ?17:09
Neveenyes, get_data return result returned from query17:10
Red15still think it might be better to either return [] or None from get_data when you have nothing to repeat17:12
NeveenRed15 : i tried return [] and it didn't work but i will try return None now . Thanks :)17:14
Red15it's worth a shot Neveen17:15
*** prepo has joined #openobject17:33
NeveenRedRed15: Thanks :)17:33
*** simahawk has joined #openobject17:33
Red15Neveen, it worked ?17:34
NeveenRed15: not yet :)17:34
Red15then don't thank me just yet :D17:35
prepoHello, Is there a way to generate XML Report  with xls extension  not pdf extension?17:35
NeveenRed15 : 0k , am thank u 4 ur effort wiz me:D17:40
dodoprepo: you should use the MS plugin17:40
dodoI don't think you could do it by any other way17:41
prepododo: do you have a tutorial or smthing to follow ?17:41
dodoprepo: no.. may be another person could help you17:42
simahawkprepo, you can use report_openoffice17:43
simahawkI don't remember if the official version support xls ootb but you can have it17:43
*** rona1 has left #openobject17:45
*** ovnicraft has joined #openobject17:45
simahawkprepo, you can also have a look at this
*** simahawk has quit IRC18:01
*** mrcast_ has joined #openobject18:03
*** enlightx_ has joined #openobject18:03
*** enlightx has quit IRC18:05
*** mrcast has quit IRC18:06
*** ToadP has quit IRC18:11
*** simahawk has joined #openobject18:13
*** zipgem has left #openobject18:13
*** javivf has quit IRC18:18
*** quodt has quit IRC18:19
*** xrg_ has quit IRC18:22
*** quentin_theuret has quit IRC18:22
*** ludo2 has quit IRC18:25
*** simahawk has quit IRC18:26
*** javivf has joined #openobject18:37
*** oktay has joined #openobject18:39
oktayhi. what open source CRM is everybody using nowadays?18:41
*** ToadP has joined #openobject18:42
*** cedk has joined #openobject18:52
*** gego has quit IRC18:53
*** bechamel has quit IRC18:57
*** javivf has quit IRC18:58
*** javivf has joined #openobject19:02
*** dodo has quit IRC19:02
*** Neveen has quit IRC19:06
*** mrcast_ has quit IRC19:14
*** Red15 has quit IRC19:20
*** komsas has quit IRC19:24
*** sharoon has quit IRC19:25
*** eLBati has quit IRC19:26
*** enlightx has joined #openobject19:53
*** eLBati has joined #openobject20:00
*** sharoon has joined #openobject20:09
*** LucaSub1 has joined #openobject20:21
*** LucaSub1 has left #openobject20:23
*** javivf has quit IRC20:26
*** oktay has quit IRC20:46
*** dodo has joined #openobject20:47
*** eLBati has quit IRC21:16
*** hounddog has quit IRC21:22
*** eLBati has joined #openobject21:26
*** sharoon has quit IRC21:29
*** mrcast has joined #openobject21:39
*** rationalperseus has quit IRC21:57
*** o-brown has joined #openobject22:00
o-brownHello, could some one help me install Open ERP on my computer ? I'm unable to create a new database to load the demonstration data22:01
*** rationalperseus has joined #openobject22:06
*** o-brown has quit IRC22:18
*** mrcast has left #openobject22:19
*** Gavin_Achado has joined #openobject22:22
*** dim has joined #openobject22:22
dimhi there22:22
dim[openerp] I'm having a problem to edit an invoice, relative to some analytic account22:23
*** pheller has quit IRC23:33
*** rationalperseus has quit IRC23:51
*** eLBati has quit IRC23:52