Bl installation problem

sandhyarao · **Joined:** Sat Jun 20, 2009 8:26 am **Posts:** 30

Hi,

Can anyone tell the proper procedure for installation of BI module?
I have installed openerpallinone 5.0 version on windows xp.

asb · **Joined:** Tue Aug 05, 2008 1:29 pm **Posts:** 37

Hello,

On windows xp you need to add have sqlalchemy.

You can get it from http://www.sqlalchemy.org/download.html

Unzip the folder you downloaded.

Open the extracted folder and move to the lib folder. Copy sqlalchemy folder from there

Paste that folder / add folder (copied one) in to library.zip in server folder in program files.

You need to have the olap, olap_sale folder in your server addons. You can get olap modules from trunk-extra-addons.

Try installing olap if it gives error of the sqlalchemy in that case paste the sqlalchemy folder(tht previously we copied) in to the olap folder in your addons directory of the server .

To test and run you need to have the bi web client from launchpad lp:~openerp/openobject-bi/client-new-trunk)

I hope this will be helpful in running the bi.

sandhyarao · **Joined:** Sat Jun 20, 2009 8:26 am **Posts:** 30

Hi asb,

Thank you for the reply.
I followed the steps that you mentioned. I got an error no module name sqlalchemy. I copied the sqlalchemy folder inside the olap folder. Now it gives the below error:

ValidateError

The value "mdx" for the field "type" is not in the selection.

vda · **Joined:** Thu Sep 10, 2009 3:02 pm **Posts:** 18

Hello.
Just Add one thing in this file in openerp-server/bin/addons/base/ir/ir_ui_view.py.
in this there is class view(osv.osv). just add ('mdx','mdx') in type column.

Thanks.
vda

sandhyarao · **Joined:** Sat Jun 20, 2009 8:26 am **Posts:** 30

Hi vaibhav,

Thanks

I could install BI successfully after adding mdx in the ir_ui_view.py.

But when I check business intelligence cube designer through web client it gives below error:

404 Not Found

The path '/designer' was not found.

URL is http://localhost:8080/designer

Is there any procedure for this?

diggerd · **Joined:** Sat Sep 12, 2009 5:39 am **Posts:** 27

Hi

I have been been able to install the BI Module OK thanks to the info on this forum, but am having some difficulty getting the BI web client. As per the other posts relating to this topic, I have registered and gone to the launchpad branch below, but I cannot see where/how to get the client?

lp:~openerp/openobject-bi/client-new-trunk

Currently evaluating OpenERP and very new to all of this but I don't have any experiece on launchpad, so any advice on getting the webclient and installing it would be great.

I have probably missed something really basic. When I clicked on the 2044 recent revision I just got an internal server error.

I read somewhere about "taking" or getting the branch but not sure what that requires.

Many Thanks

vda · **Joined:** Thu Sep 10, 2009 3:02 pm **Posts:** 18

Hello sandhyarao,
Have u taken the branch of bi client?

lp:~openerp/openobject-bi/client-new-trunk

after install,
run this client. then its work successfully.

Thanks,

sandhyarao · **Joined:** Sat Jun 20, 2009 8:26 am **Posts:** 30

Hi vaibhav,

I am using the openerpallinone v 5. Is any bi client needed? I haven't used launchpad till now. Don't know how to download bi client and operate it also.

Any help.

vda · **Joined:** Thu Sep 10, 2009 3:02 pm **Posts:** 18

Hello,

for bi u need the bi client. its necessary.because we have not merged this branch to the openerp web.
for that u need to register in launchpad. then and only you can get the bi client branch.

bzr branch :
lp:~openerp/openobject-bi/client-new-trunk

Thanks,

vda · **Joined:** Thu Sep 10, 2009 3:02 pm **Posts:** 18

Hello diggerd,
have u installed bazaar(bzr)?
to take the branch from launchpad:
bzr branch lp:~openerp/openobject-bi/client-new-trunk

Thanks,

diggerd · **Joined:** Sat Sep 12, 2009 5:39 am **Posts:** 27

OK, seems like I was just having a server issue on my first launchpad visit so that threw this newbie right off the track.

I have the branch now from launchpad now, but still not totally clear on which files to use and how/where to install the web client?

Thanks for help so far

vda · **Joined:** Thu Sep 10, 2009 3:02 pm **Posts:** 18

Hello diggerd,

Have u installed Turbogears(>= 1.0.7)?
u can install the bi web-client branch anywhere.
to start bi web client:
(1). in command prompt go to the folder where u have installed this bi web client.

in bi web client there is start-openerp-web.py file.
(2). start-openerp-web.py
it starts bi web client.

Thanks,

diggerd · **Joined:** Sat Sep 12, 2009 5:39 am **Posts:** 27

Hi vda

Have turbogears installed but keep getting the following error when I go to run the module

ImportError: cannot import name xpath

Full script below

Quote:

C:\Program Files\Bazaar\client-new-trunk>start-openerp-web.py
C:\Python25\lib\site-packages\ruledispatch-0.5a1.dev_r2506-py2.5-win32.egg\dispa
tch\__init__.py:98: Warning: 'as' will become a reserved keyword in Python 2.6
C:\Python25\lib\site-packages\ruledispatch-0.5a1.dev_r2506-py2.5-win32.egg\dispa
tch\predicates.py:239: Warning: 'as' will become a reserved keyword in Python 2.
6
C:\Python25\lib\site-packages\ruledispatch-0.5a1.dev_r2506-py2.5-win32.egg\dispa
tch\predicates.py:263: Warning: 'as' will become a reserved keyword in Python 2.
6
C:\Python25\lib\site-packages\ruledispatch-0.5a1.dev_r2506-py2.5-win32.egg\dispa
tch\predicates.py:281: Warning: 'as' will become a reserved keyword in Python 2.
6
Traceback (most recent call last):
File "C:\Program Files\Bazaar\client-new-trunk\start-openerp-web.py", line 15,
in <module>
start()
File "C:\Program Files\Bazaar\client-new-trunk\openerp\commands.py", line 64,
in start
from openerp.controllers import Root
File "C:\Program Files\Bazaar\client-new-trunk\openerp\controllers.py", line 5
0, in <module>
from openerp import subcontrollers
File "C:\Program Files\Bazaar\client-new-trunk\openerp\subcontrollers\__init__
.py", line 1, in <module>
import actions
File "C:\Program Files\Bazaar\client-new-trunk\openerp\subcontrollers\actions.
py", line 44, in <module>
from openerp import tools
File "C:\Program Files\Bazaar\client-new-trunk\openerp\tools.py", line 34, in
<module>
from xml import xpath
ImportError: cannot import name xpath

C:\Program Files\Bazaar\client-new-trunk>

Have I done something wrong?

Cheers

vda · **Joined:** Thu Sep 10, 2009 3:02 pm **Posts:** 18

Hello diggerd,
install:
lxml-2.1.2.win32-py2.5
PyXML-0.8.4.win32-py2.5

it should work.

Thanks.

Pavel910 · **Joined:** Mon Jul 27, 2009 12:45 pm **Posts:** 148

Fighting with this for a few hours now, read your suggestions over and over again but still keep getting error running web-client, here is the traceback:

Code:

pavel@pavel-laptop:~$ start-openerp-web
Traceback (most recent call last):
  File "/usr/bin/start-openerp-web", line 5, in <module>
    from pkg_resources import load_entry_point
  File "/usr/lib/python2.5/site-packages/pkg_resources.py", line 2562, in <module>
    working_set.require(__requires__)
  File "/usr/lib/python2.5/site-packages/pkg_resources.py", line 626, in require
    needed = self.resolve(parse_requirements(requirements))
  File "/usr/lib/python2.5/site-packages/pkg_resources.py", line 524, in resolve
    raise DistributionNotFound(req)  # XXX put more info here
pkg_resources.DistributionNotFound: Extremes>=1.1

Any ideas?
Thanks