Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Not run pyExcelerator and AerooLib in OpenERP 6.1 for Windows

Subscribe

Get notified when there's activity on this post

This question has been flagged
v6.1pythonpyexceleratoraeroolib
2 Replies
21682 Views
Avatar
Joaquin

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!!!

2
Avatar
Discard
Joaquin
Author

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.

Avatar
Cyril Gaspard (GEM)
Best Answer

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

3
Avatar
Discard
Joaquin
Author

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
Author

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

Joaquin
Author

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

Joaquin
Author

I have Python 2.7

Cyril Gaspard (GEM)

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

SWAS

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

Cyril Gaspard (GEM)

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

Avatar
Joaquin
Author Best Answer

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


1
Avatar
Discard
Joaquin
Author

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
Author

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
Author

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
Author

Please help me!!!

Joaquin
Author

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

SWAS

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Not Run AerooLib in OpenERP 6.1 for Windows
v6.1 python aeroolib openerp
Avatar
Avatar
1
Mar 15
7314
Which python version is recommended? Solved
v6.1 python version v7
Avatar
Avatar
Avatar
Avatar
3
Mar 15
33518
Is there somewhere a list of needed python libraries?
v6.1 python v7 dependencies libraries
Avatar
Avatar
1
Mar 15
15206
using RML to Pull data from other tables
v6.1 python rml account.invoice sale.order
Avatar
Avatar
1
Mar 15
7835
눈Volaris Contacto Numero눈¿Cómo hablar con un asesor de Volaris?
v6.1
Avatar
0
Nov 25
10
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now