Open Object

General discussion :: RE: Partner filtering

jacorbacho — Tue, 09 Feb 2010 09:15:20 GMT

Author: jacorbacho
Posted: Tue Feb 09, 2010 11:15 am (GMT 2)

SOLVED:

The solution I've found is not the prettiest but it works (and I'm glad and I like it).
As the problem with the many2many fields in record rules seems to persists, I have removed them.
Instead, in every object I want to restrict, I have overriden the search method forcing it to take into account the restriction on departments.

Code:

def search(self, cr, uid, args, offset=0, limit=None, order=None, context=None, count=False):
   if context is None:
      context = {}
   res = self._get_partner_ids(cr, uid, args, context)
   args.append(('partner_id','in', res))
   return super(res_partner, self).search(cr, uid, args, offset, limit, order, context=context, count=count)

def _get_partner_ids(self, cr, uid, args, context=None):
   """Get a list of partner visible by current user"""
   cr.execute('select distinct partner_id from hr_department_partner_rel where department_id in (select department_id from hr_department_user_rel where user_id = %s)', (uid,))
   resultSet = cr.fetchall()
   res = []
   for result in resultSet:
      res.append(result[0])
   return res

Sorry I'm not a Python guy (yet) and the code can be improved but this works for all the views where partners are listed.
_________________
Jose A. Corbacho
Trobz (www.trobz.com)

General discussion :: RE: Build setup windows with sources using windows

GEM — Tue, 09 Feb 2010 08:10:58 GMT

Author: GEM
Posted: Tue Feb 09, 2010 10:10 am (GMT 2)

bug error timezone with client gtk is fixed.
don't use or modify the part of configuration :

Quote:

Do this if there is an error pytz timezone in client gtk(bug fixed)

search name of your local timezone in your windows :
start->execute type regedit
go to HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/Time Zones/
search your timezone
by example for me "Romance Standard Time" -> subkey on the right "std" value "Paris, Madrid"
copy python25\Lib\site-packages\pytz\zoneinfo\Europe\Paris in python25\Lib\site-packages\pytz\zoneinfo\Paris, Madrid
in python25\Lib\site-packages\pytz\__init__.py at the end of the script in all_timezones list add the line :
'Paris, Madrid',
you must do this with your own timezone installed on your computer.

Reporting development :: RE: Please help: How to convert sxw to rml

jmollers — Tue, 09 Feb 2010 07:39:16 GMT

Author: jmollers
Posted: Tue Feb 09, 2010 9:39 am (GMT 2)

Hi,

Try to invoke the conversion from the windows (DOS) command prompt, something like:

Python25.exe tiny_sxw2rml.py C:\test_report.sxw > C:\test_report.rml

Stock & Manufacturing :: stock_location how does it works

grizzly — Tue, 09 Feb 2010 02:07:55 GMT

Author: grizzly
Subject: stock_location how does it works
Posted: Tue Feb 09, 2010 4:07 am (GMT 2)

hi people...

i have a problem about stock_location for rentable product. how does it works? how the product deliver to customer (by outgoing product or stock moves)?? because the product cannot be sent.
i've been tried such instructions in the book:
http://doc.openerp.com/book/5/5_14_Stock/5_14_Stock_advanced.html#example-1-a-rentable-product

but it doesnt work. there is no form which indicates that the product will be back. whereas openerp say good receipts will raise in the state draft.

thnx...

French Forum :: ereur chanp many2one

tariklallouch — Mon, 08 Feb 2010 21:32:04 GMT

Author: tariklallouch
Subject: ereur chanp many2one
Posted: Mon Feb 08, 2010 11:32 pm (GMT 2)

Environment Information :
System : Linux-2.6.31-17-generic-i686-with-Ubuntu-9.10-karmic
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 9.10
Release: 9.10
Codename: karmic
Operating System Release : 2.6.31-17-generic
Operating System Version : #54-Ubuntu SMP Thu Dec 10 16:20:31 UTC 2009
Operating System Architecture : 32bit
Operating System Locale : fr_FR.UTF8
Python Version : 2.6.4
OpenERP-Client Version : 5.0.3
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 244, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 73, in __call__
return getattr(self, method)(*params)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/base_module_record/base_module_record.py", line 38, in execute
res = super(recording_objects_proxy, self).execute(*args, **argv)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 583, in execute
res = service.execute(db, uid, object, method, *args)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 59, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 118, in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 110, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2888, in name_search
res = self.name_get(cr, user, ids, context)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2877, in name_get
[self._rec_name], context, load='_classic_write')]
KeyError: 'x_name'

merci

OpenERP Client :: RE: OEPL restrictions

pheller — Mon, 08 Feb 2010 21:15:15 GMT

Author: pheller
Posted: Mon Feb 08, 2010 11:15 pm (GMT 2)

...and still no response.
_________________
--phil

General discussion :: RE: price_accuracy not loading from conf file on windows service

Christophe Chauvet — Mon, 08 Feb 2010 21:15:08 GMT

Author: Christophe Chauvet
Posted: Mon Feb 08, 2010 11:15 pm (GMT 2)

Hi

This is a bugs, i report it many month ago

see https://bugs.launchpad.net/openobject-server/5.0/+bug/392114

Leave a comment with your issue

Regards,
_________________
Christophe Chauvet
Directeur Technique/Technical Manager
Sylëam Info Services
www.syleam.fr

General discussion :: RE: Problem with file tutorial on OpenERP.tv

bertoo — Mon, 08 Feb 2010 20:40:43 GMT

Author: bertoo
Posted: Mon Feb 08, 2010 10:40 pm (GMT 2)

hello,

Did you see :
http://openobject.com/forum/topic14846.html

IMHO you should try this report builder If you don't want to waste time and money

General discussion :: price_accuracy not loading from conf file on windows service

StealthM — Mon, 08 Feb 2010 19:57:01 GMT

Author: StealthM
Subject: price_accuracy not loading from conf file on windows service
Posted: Mon Feb 08, 2010 9:57 pm (GMT 2)

Hello,

I was attempting to utilize price_accuracy = 6 from my openerp-server.conf file however it seems that it still uses the default value of 2 every time I try it as a service.

However, when I run the "openerp-server --price_accuracy 6" without running it as a service the correct setting for price_accuracy is used.

Has anyone experienced this issue besides me?

Thanks!

Accounting and finance :: RE: Financial Journals for multicurrency bank accounts

pjkersten — Mon, 08 Feb 2010 19:44:26 GMT

Author: pjkersten
Posted: Mon Feb 08, 2010 9:44 pm (GMT 2)

+1 for me.

The development of the Account Banking Framework has now touched this area too. Apparently there are multi currency bank accounts which allow amounts in different currencies to co-exist. There is no clear understanding of how OpenERP should deal with this.

In lots of places, OpenERP coerces moves in different currencies to the companies default or some defined secondary currency. This is done using one of two coercion methods: average or current. The problem is that both methods only compute once. The multiple currency scenario calls for a third option: dynamic. Every calculation should be recalculated on review using the latest exchange rates.

On top of that there are is the challenge of reporting: how do you show the real amounts in the various currencies hidden in the system?

At first sight, adapting OpenERP for this looks like domino day - every correction triggers the need for new corrections. Right now I can't oversee the full scope of this.

As multiple currency accounts seem to become the new standard, action is needed. At least 5 member states of the EU are already affected by this.
_________________
Pieter J. Kersten
EduSense BV
http://www.edusense.nl

General discussion :: RE: [Patch] Little improvement on printing with the GTK-client

pjkersten — Mon, 08 Feb 2010 18:50:03 GMT

Author: pjkersten
Posted: Mon Feb 08, 2010 8:50 pm (GMT 2)

Actually, there is no need to change the client. Just extend the extensions part of the .openerprc file:

Code:

[extensions]
filetype = {'odt': ('/usr/bin/ooffice', '/usr/bin/ooffice'), 'ps': ('/usr/bin/evince', '/usr/bin/gtklp'), 'pdf': ('/usr/bin/evince', '<some script that combines pdf2ps and gtklp>')}

The pattern is: filetype: (previewcommand, printcommand)

Make sure it is one single line!
_________________
Pieter J. Kersten
EduSense BV
http://www.edusense.nl

Espanol Forum :: RE: Error de impresion en todos los modulos too large on page2

percevaq — Mon, 08 Feb 2010 16:25:45 GMT

Author: percevaq
Subject: Como arreglar esto
Posted: Mon Feb 08, 2010 6:25 pm (GMT 2)

Para resumir tienes que bajarte los ficheros contenidos aqui
http://bazaar.launchpad.net/~openerp/openobject-server/trunk/files/head%3A/bin/report/render/rml2pdf/

y ponerlos en Server\library.zip\report\render\rml2pdf

Si no tienes la carpeta library.zip simplemente descomprime el zip que esta en Server\library.zip y renombra la carpeta library a library.zip

Todo esto para windows.

Ciao

General Questions :: RE: stmpclient

nicoblut — Mon, 08 Feb 2010 16:20:23 GMT

Author: nicoblut
Posted: Mon Feb 08, 2010 6:20 pm (GMT 2)

I have the same message..

General discussion :: RE: Cannot enter US State address in company data

joel-jbe — Mon, 08 Feb 2010 15:59:51 GMT

Author: joel-jbe
Posted: Mon Feb 08, 2010 5:59 pm (GMT 2)

Greetings everyone,

I briefly tried to enter the US State data in the drop down box. It didn't take, and I moved on. I will try that again.

As of now, I don't see too much trouble, if any, resulting from this and maybe that is why it is somewhat loose. I expect to create any documents that will leave our office in reports where I can enter any address info we need. There is even a great looking module with the ability to connect to Open Office for simple documents and reports.

I will try to get the data entered and let you know if I have any success.

Thanks, this isn't major but seeing the response is. It's the community that makes a project like this work

Joel

General discussion :: initial Balance in account

kgenot — Mon, 08 Feb 2010 15:54:02 GMT

Author: kgenot
Subject: initial Balance in account
Posted: Mon Feb 08, 2010 5:54 pm (GMT 2)

Hello,

I want to write the initial balance in my account but without counterparty?
Does someone how to do that? I've created a journal with type Situation, and centralized. But it'snt seem to work...

Thank for help.

K.G

General Questions :: remove changes in SaleOrder lines

59590 — Mon, 08 Feb 2010 15:45:01 GMT

Author: 59590
Subject: remove changes in SaleOrder lines
Posted: Mon Feb 08, 2010 5:45 pm (GMT 2)

Hi,

how can i remove changes in SaleOrder lines when i press the cancel button in
orderlineform with the gtk-client.

These function was Ok with web-client.

Any help!

Thanks
Manfred

French Forum :: RE: ERREUR RECHERCHE FACTURE

pelucre — Mon, 08 Feb 2010 15:14:06 GMT

Author: pelucre
Posted: Mon Feb 08, 2010 5:14 pm (GMT 2)

merci,

je vais signaler mon bug

General discussion :: RE: Problem with file tutorial on OpenERP.tv

howtolearn — Mon, 08 Feb 2010 15:05:59 GMT

Author: howtolearn
Posted: Mon Feb 08, 2010 5:05 pm (GMT 2)

Thanks bertoo, your video is about "Report Designer" which is very powerful tool to make or change a OpenERP's report.
However, this tool is not free, and I can't afford to purchase it. If you know other free tools that help to make or customize a report, please tell me.
Now I'm using OpenOffice to make file *.sxw then convert to *.rml, but I also got a problem. By the way, if you know how to convert sxw to rml show me the detail. I'll appreciate
Anyway, thank you for your reply ^_^

French Forum :: RE: Champs url ne fonctionne pas

GEM — Mon, 08 Feb 2010 14:55:53 GMT

Author: GEM
Posted: Mon Feb 08, 2010 4:55 pm (GMT 2)

eventuellement,
telecharger openerp-client build last rev-1045 individual package (08/02/2010) :
http://dl.free.fr/teqIxyM7E

General Questions :: RE: XML-RPC on Windows Mobile?

iguanoman — Mon, 08 Feb 2010 14:36:20 GMT

Author: iguanoman
Posted: Mon Feb 08, 2010 4:36 pm (GMT 2)

[quote="larscwallin"]I am glad to hear this

Is this project of yours open source as well?

Ciao[/quote]

I think that won't be open source. The company where I'm working is developing a project for driving school that uses OpenERP for manage the classes, students and professors. And in the mobile part, the professor can see his classes, evaluate the student, ...

I think that my boss don't want to do it open source... sorry!
_________________
buscando...

General Questions :: Using the calendar view

larscwallin — Mon, 08 Feb 2010 14:35:57 GMT

Author: larscwallin
Subject: Using the calendar view
Posted: Mon Feb 08, 2010 4:35 pm (GMT 2)

Hi,
I am making a resource booking system and would like to use the calendar view to check availability of items.

Is the calendar a generalized GUI component like the other view types?

If not, any suggestions how to implement/reuse the calendar?

Ciao,
Lars

French Forum :: RE: ERREUR RECHERCHE FACTURE

GEM — Mon, 08 Feb 2010 14:35:55 GMT

Author: GEM
Posted: Mon Feb 08, 2010 4:35 pm (GMT 2)

une correction de bug peut en amener un autre :
https://bugs.launchpad.net/openobject-addons/+bug/510293
ce qui a change et provoque une autre erreur chez toi :
http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/stable_5.0-extra-addons/revision/4190

peut etre ajouter ton bug sur ce meme report en precisant que la modif qui corrige deja un bug provoque un autre bug, donner le message d'erreur complet.

French Forum :: RE: ACCOUNT_ASSET

Mlle — Mon, 08 Feb 2010 14:30:54 GMT

Author: Mlle
Posted: Mon Feb 08, 2010 4:30 pm (GMT 2)

bonjour,

"après j'ai créer une nlle facture fournisseur dans laquelle j'ai intégrer dans la ligne de produit cette asset avec..."

sur l'onglet "factures fournisseur"> "lignes de facture"> dans la colonne produit, cette asset vous l'avez créé ou bien...?

sanâa

Reporting development :: Please help: How to convert sxw to rml

howtolearn — Mon, 08 Feb 2010 14:28:45 GMT

Author: howtolearn
Subject: Please help: How to convert sxw to rml
Posted: Mon Feb 08, 2010 4:28 pm (GMT 2)

Hi, everybody
I begin to customize new report but I have got the problem when I converted file *.sxw to *.rml
At first, I followed the instruction from Openerp books and forums that means I have installed {python25.exe, reportlab and libxml}, then typed the command in Python25.exe
C:\Python25\Lib\site-packages>tiny_sxw2rml.py "C:\test_report.sxw" > "C:\test_report.rml"
but it annonced that "invalid syntax" so how could I fix it??
By the way, am I right when I typed that command in python25.exe? if I am wrong so where should we type this command??
I really need this part. I know maybe someone can do this successfully so I hope I will receive the instruction and the advice from everybody.
I really appreciate this and thanks anyway!

General Questions :: RE: XML-RPC on Windows Mobile?

larscwallin — Mon, 08 Feb 2010 14:25:07 GMT

Author: larscwallin
Posted: Mon Feb 08, 2010 4:25 pm (GMT 2)

I am glad to hear this

Is this project of yours open source as well?

Ciao