Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

Not run pyExcelerator and AerooLib in OpenERP 6.1 for Windows

By
Joaquin
on 3/15/13, 5:20 AM 10,301 views

Hello. I am setting up an installation of OpenERP for Windows, by customer requirements. I installed version 6.1 AllInOne, I configured a version 9.2 of PostgreSQL, and everything works perfectly in a Windows 7.0 Enterprise Edition. But what I do not get to see are OpenERP own Python modules, since when do the IMPORT from OpenERP, it does not, but that code transferred and executed directly in Python, gives no problems and runs perfectly.

The code are this:

*import pyexcelerator as xl, webbrowser
work_book_document = xl.Workbook()
doc_sheet_1 = work_book_document.add_sheet("sheet1")
my_font = xl.Font()
my_font.name = 'Time New Roman'
my_font.bold = True
my_font.underline = True
my_font.italic = True
my_font.colour_index = 3
my_font_style = xl.XFStyle()
my_font_style.font = my_font
doc_sheet_1.write(0,0,'value') # (row, column, ...)
doc_sheet_1.write(0,1,'name', my_font_style)
work_book_document.save('/temp/filename.xls') *

I have configured your computer correctly and as is indicated in the different existing post in the community forum. Then put the state of the system running the SET command from the system console:

C:\Users\Joaquin>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\Joaquin\AppData\Roaming
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=WSVAL116
ComSpec=C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK=NO
GTK_BASEPATH=C:\GTK
HOMEDRIVE=C:
HOMEPATH=\Users\Joaquin
INCLUDE=C:\GTK\INCLUDE;C:\GTK\INCLUDE\GTK-2.0;C:\GTK\INCLUDE\GLIB-2.0;C:\GTK\INCLUDE\PANGO-1.0;C:\GTK\INCLUDE\CAIRO;C:\GTK\INCLUDE\ATK-1.0;C:\GTK\INCLUDE\GTKGLEXT-1.0;C:\GTK\LIB\GTK-2.0\INCLUDE;C:\GTK\LIB\GLIB-2.0\INCLUDE;C:\GTK\LIB\GTKGLEXT-1.0\INCLUDE;C:\GTK\INCLUDE\LIBGLADE-2.0;C:\GTK\INCLUDE\LIBXML2;
LIB=C:\GTK\LIB;
LOCALAPPDATA=C:\Users\Joaquin\AppData\Local
LOGONSERVER=\WSVAL116
NUMBER_OF_PROCESSORS=4
OS=Windows_NT
Path=C:\GTK\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Java\jre7\bin;C:\Program Files\TortoiseSVN\bin;C:\Python27;C:\Python27\Lib;C:\Work\OE7\Server\server\openerp\addons;C:\Python27\Scripts;C:\Python27\Lib\site-packages;C:\Program Files (x86)\Graphviz2.20\Bin;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2505
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
PYTHONPATH=C:\Python27;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts;C:\Python27\Lib\sitepackages;C:\Work\OE7\Server\server\openerp\addons;
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\Joaquin\AppData\Local\Temp
TMP=C:\Users\Joaquin\AppData\Local\Temp
USERDOMAIN=WSVAL116
USERNAME=Joaquin
USERPROFILE=C:\Users\Joaquin
windir=C:\Windows
windows_tracing_flags=3
windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

No recognizes OpenERP, pyExcelerator module. But neither recognizes AEROOLIB module, which is also installed, as it can see below:

Welcome to Python 2.7! This is the online help utility.
If this is your first time using Python, you should definitely check out
the tutorial on the Internet at
Enter the name of any module, keyword, or topic to get help on writing
Python programs and using Python modules. To quit this help utility and
return to the interpreter, just type "quit".
To get a list of available modules, keywords, or topics, type "modules",
"keywords", or "topics". Each module also comes with a one-line summary
of what it does; to list the modules whose summaries contain a given word
such as "spam", type "modules spam".
help> modules aero
Here is a list of matching modules. Enter any module name to get more help.
aeroolib - Aeroo Library
aeroolib.plugins
aeroolib.plugins.base
aeroolib.plugins.opendocument
aeroolib.reporting


From the pyExcelerator:

help> modules pyExcel
Here is a list of matching modules. Enter any module name to get more help.
pyexcelerator
pyexcelerator.BIFFRecords
pyexcelerator.Bitmap
pyexcelerator.Cell
pyexcelerator.Column
pyexcelerator.CompoundDoc
pyexcelerator.Deco
pyexcelerator.ExcelFormula
pyexcelerator.ExcelFormulaLexer
pyexcelerator.ExcelFormulaParser
pyexcelerator.ExcelMagic
pyexcelerator.Formatting
pyexcelerator.ImportXLS
pyexcelerator.Row
pyexcelerator.Style
pyexcelerator.UnicodeUtils
pyexcelerator.Utils - pyXLWriter.utilites
pyexcelerator.Workbook
pyexcelerator.Worksheet
pyexcelerator.antlr
pyexcelerator.pyExcelerator
pyexcelerator.pyExcelerator.BIFFRecords
pyexcelerator.pyExcelerator.Bitmap
pyexcelerator.pyExcelerator.Cell
pyexcelerator.pyExcelerator.Column
pyexcelerator.pyExcelerator.CompoundDoc
pyexcelerator.pyExcelerator.Deco
pyexcelerator.pyExcelerator.ExcelFormula
pyexcelerator.pyExcelerator.ExcelFormulaLexer
pyexcelerator.pyExcelerator.ExcelFormulaParser
pyexcelerator.pyExcelerator.ExcelMagic
pyexcelerator.pyExcelerator.Formatting
pyexcelerator.pyExcelerator.ImportXLS
pyexcelerator.pyExcelerator.Row
pyexcelerator.pyExcelerator.Style
pyexcelerator.pyExcelerator.UnicodeUtils
pyexcelerator.pyExcelerator.Utils - pyXLWriter.utilites
pyexcelerator.pyExcelerator.Workbook
pyexcelerator.pyExcelerator.Worksheet
pyexcelerator.pyExcelerator.antlr
pyexcelerator.setup


When installing AEROO REPORT, get this error:

Client Traceback (most recent call last):
File "C:\Work\OE7\Server\server\openerp\addons\web\common\http.py", line 180, in dispatch
File "C:\Work\OE7\Server\server\openerp\addons\web\controllers\main.py", line 1052, in call_button
File "C:\Work\OE7\Server\server\openerp\addons\web\controllers\main.py", line 996, in call_common
File "C:\Work\OE7\Server\server\openerp\addons\web\controllers\main.py", line 1010, in _call_kw
File "C:\Work\OE7\Server\server\openerp\addons\web\common\openerplib\main.py", line 250, in proxy
File "C:\Work\OE7\Server\server\openerp\addons\web\common\openerplib\main.py", line 117, in proxy
File "C:\Work\OE7\Server\server\openerp\addons\web\common\http.py", line 608, in send Server Traceback (most recent call last):
File "C:\Work\OE7\Server\server\openerp\addons\web\common\http.py", line 593, in send
File "C:\Work\OE7\Server\server.\openerp\netsvc.py", line 360, in dispatch_rpc
File "C:\Work\OE7\Server\server.\openerp\service\web_services.py", line 586, in dispatch
File "C:\Work\OE7\Server\server.\openerp\osv\osv.py", line 186, in execute_kw
File "C:\Work\OE7\Server\server.\openerp\osv\osv.py", line 129, in wrapper
File "C:\Work\OE7\Server\server.\openerp\osv\osv.py", line 195, in execute
File "C:\Work\OE7\Server\server.\openerp\osv\osv.py", line 183, in execute_cr
File "C:\Work\OE7\Server\server\openerp\addons\base\module\wizard\base_module_upgrade.py", line 101, in upgrade_module
File "C:\Work\OE7\Server\server.\openerp\pooler.py", line 39, in restart_pool
File "C:\Work\OE7\Server\server.\openerp\modules\registry.py", line 202, in new
File "C:\Work\OE7\Server\server.\openerp\modules\loading.py", line 338, in load_modules
File "C:\Work\OE7\Server\server.\openerp\modules\loading.py", line 253, in load_marked_modules
File "C:\Work\OE7\Server\server.\openerp\modules\loading.py", line 165, in load_module_graph
File "C:\Work\OE7\Server\server.\openerp\modules\module.py", line 409, in load_openerp_module
File "C:\Work\OE7\Server\server.\openerp\modules\module.py", line 139, in load_module
File "C:\Work\OE7\Server\server\openerp\addons\report_aeroo__init__.py", line 32, in <module>
ImportError: No module named aeroolib

I need Help!!!

Thanks. Aerolib are placed in C:\Python27\Lib\site-packages\aeroolib And are installed in: C:\Python27\Lib\site-packages\aeroolib-1.0.0-py2.7.egg

I have installed OpenOffice, but I have your variables in the Path.

I made ​​the switch to put the variables that you show me, but keeps saying AerooLib not found.

It is installed in the same way pyExcelerator and pyExcelerator not find the OpenERP, but if it is seen from the Python interpreter itself.

It is as if the PithonPath, was not played by OpenERP.

Joaquin
on 3/15/13, 9:17 AM
3

Cyril Gaspard (GEM)

--Cyril Gaspard (GEM)--
4136
| 5 6 8
Paris, France
--Cyril Gaspard (GEM)--

Forum contributor since 2008

Cyril Gaspard (GEM)
On 3/15/13, 8:57 AM

HI,

download on your desktop report_aeroo here for v6.1 :

here

extract directly in your desktop (without creation of a new folder container).

copy paste folder report_aeroo in c:\ ....\server\openerp\addons

download on your desktop aeroolib here :

here

extract directly in your desktop (without creation of a new folder container). on desktop go to aeroolib folder. In this folder copy folder aeroolib and paste in in c:...\server

aeroolib needs python library genshi (not in openerp server package libraries. You can download it here :

here

extract directly in your desktop (without creation of a new folder container).

copy folder genshi in c:...\server

restart openerp server.

update module list.

install module report_aeroo

no error no module named aeroolib.

But I think you should do again some configurations to use it. In this case create a new question.

Bye

Thanks. Aerolib are placed in C:\Python27\Lib\site-packages\aeroolib And are installed in: C:\Python27\Lib\site-packages\aeroolib-1.0.0-py2.7.egg I have installed OpenOffice, but I have your variables in the Path. I made ​​the switch to put the variables that you show me, but keeps saying AerooLib not found. It is installed in the same way pyExcelerator and pyExcelerator not find the OpenERP, but if it is seen from the Python interpreter itself. It is as if the PithonPath, was not played by OpenERP. This is my Set:<br> C:\>set <br>ALLUSERSPROFILE=C:\ProgramData <br>APPDATA=C:\Users\Joaquin

Joaquin
on 3/15/13, 10:25 AM

Not Install any of Modules os Aeroo Report. All run in this OpenReport Installation, but not install nothing :(

Joaquin
on 3/15/13, 10:34 AM

I have reinstall all, follow all and have the same error: ImportError: No module named aeroolib

Joaquin
on 3/18/13, 11:15 AM

I have Python 2.7

Joaquin
on 3/18/13, 12:54 PM

update answer, tested on openerp allinone 6.1, windows 7. Bye

Cyril Gaspard (GEM)
on 3/24/13, 12:39 PM

Thanks GEM this is really very use full and this help me install aeroo report but when i try to install aeroo report openoffice addon I got following error except_osv: ('Warning! Unmet python dependencies!', 'No module named cups') I am using openerp7 on windows please anyone can help me? thanks

waqar
on 9/26/13, 3:14 AM

HI, perhaps install python library pycups with command line : easy_install pycups . If you have an error with vcvarsall.bat, see post "At least I found my solution from drawing feedback from other answers:" in topic http://stackoverflow.com/questions/2817869/error-unable-to-find-vcvarsall-bat . Bye

Cyril Gaspard (GEM)
on 10/2/13, 6:07 AM
1
Joaquin
On 3/18/13, 1:09 PM

This is the folder on have all packages of Python:

Directorio de C:\Python27\Lib\site-packages
_xmlplus
adodbapi
aeroolib
aeroolib-1.0.0-py2.7.egg
axscript
bzrlib
cairo
dateutil
genshi
Genshi-0.6-py2.6.egg-info
gtk-2.0
isapi
libxmlmods
lxml
lxml-2.3.6-py2.7.egg-info
mako
Mako-0.3.1-py2.5.egg-info
matplotlib
mpl_toolkits
mx
numpy
OpenSSL
PIL
psycopg2
py2exe
pychart
pydot-1.0.2-py2.5.egg-info
pyexcelerator
pythonwin
pytz
pytz-2008i-py2.5.egg-info
pywin32_system32
pyXLWriter
reportlab
setuptools
setuptools-0.6c11-py2.7.egg-info
vobject
vobject-0.7.1-py2.5.egg-info
win32
win32com
win32comext

Files:
**_memimporter.pyd
_renderPM.pyd
_rl_accel.pyd
bzr-2.5.1-py2.7.egg-info
dot_parser.py
dot_parser.pyc
dot_parser.pyo
drv_libxml2.py
drv_libxml2.pyc
drv_libxml2.pyo
easy_install.py
easy_install.pyc
easy_install.pyo
easy-install.pth
egenix_mx_base-3.1.1-py2.5.egg-info
egenix_mx_base-3.2.5-py2.7.egg-info
egenix_pyopenssl-0.8.0_0.9.8i_1-py2.5.egg-info
Genshi-0.6-py2.7-win32.egg
libxml2.py
libxml2.pyc
libxml2.pyo
libxml2_python-2.7.7-py2.7.egg-info
libxslt.py
libxslt.pyc
libxslt.pyo
matplotlib-1.2.0-py2.7.egg-info
numpy-1.6.2-py2.7.egg-info
PIL.pth
pkg_resources.py
pkg_resources.pyc
pkg_resources.pyo
psycopg2-2.4.6-py2.7.egg-info
py2exe-0.6.9-py2.7.egg-info
pycairo-1.8.10-py2.7.egg-info
pycairo-1.8.8-py2.7.egg-info
PyChart-1.39-py2.5.egg-info
pydot.py
pydot.pyc
pydot.pyo
pyExcelerator-0.6.4.1-py2.7.egg-info
pygtk.pth
pygtk.py
pygtk.pyc
pygtk.pyo
pyHnj.pyd
pylab.py
pylab.pyc
pylab.pyo
pyparsing.py
pyparsing.pyc
pyparsing.pyo
pyparsing-1.5.0-py2.5.egg-info
pythoncom.py
pythoncom.pyc
pythoncom.pyo
PyWin32.chm
pywin32.pth
pywin32.version.txt
pywin32-214-py2.7.egg-info
PyXML-0.8.4-py2.7.egg-info
README.txt
reportlab-2.5-py2.7.egg-info
sgmlop.pyd
site.py
site.pyc
site.pyo
six.py
six.pyc
six.pyo
zipextimporter.py
zipextimporter.pyc
zipextimporter.pyo


I followed all the steps. I extract the folder "C: \ Python27 \ Lib \ site-packages \ aeroolib" and proceed to install the product by executing the "python setup.py-install" from the folder "C: \ Python27 \ Lib \ site-packages \ aeroolib " It is installed correctly and generates the "C: \ Python27 \ Lib \ site-packages \ aeroolib-1.0.0.RC4-py2.7.egg" After initialize Seller as follows: "C: \ Python27 \ Lib \ site-packages \ aeroolib-1.0.0.RC4-py2.7.egg \ aeroolib> python __ init__.py"

OpenERP But still not meet the bookstore AEROOLIB

Joaquin
on 3/19/13, 11:37 AM

Hello. I copied to "C: \ Python27 \ Lib \ site-packages" what you show me, and no matter what I do, which is not AEROOLIB of OpenERP any means, but if he sees Python. And it is not hard, but I've tried everything and do not know where to continue. That is why I installed the package, I desisntalado, I copied you show me where and no way to OpenERP enciuentre Seller. I can give my remote computer through TeamViewer if you want, for you to check that all requirements are met.

Joaquin
on 3/19/13, 1:40 PM

i was creeated this python script, and it return OK, but OPENERP not found AEROOLIB: try: import aeroolib print "ok" except ImportError, e: pass # module doesn't exist, deal with it. print "nok"

Joaquin
on 3/20/13, 11:42 AM

Please help me!!!

Joaquin
on 3/20/13, 12:17 PM

Please GEM, not where to go, everything is installed and configured correctly, AEROOLIB visible from Python, but OpenERP not see it, and do not know where I can continue

Joaquin
on 3/20/13, 1:42 PM

Thanks GEM this is use full guide for me, i have installed aeroo report module after following your instructions but when i try to install aeroo report openoffice addon I got following Error "except_osv: 'Warning! Unmet python dependencies!', 'No module named cups'), anyone have a Idea about it Please guide me.. (I am using openerp 7 on windows 7). thanks

waqar
on 9/26/13, 2:22 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 3/15/13, 5:20 AM
Seen: 10301 times
Last updated: 3/16/15, 8:10 AM