Skip to Content
Odoo Menú
  • Registra entrada
  • Prova-ho gratis
  • Aplicacions
    Finances
    • Comptabilitat
    • Facturació
    • Despeses
    • Full de càlcul (IA)
    • Documents
    • Signatura
    Vendes
    • CRM
    • Vendes
    • Punt de venda per a botigues
    • Punt de venda per a restaurants
    • Subscripcions
    • Lloguer
    Imatges de llocs web
    • Creació de llocs web
    • Comerç electrònic
    • Blog
    • Fòrum
    • Xat en directe
    • Aprenentatge en línia
    Cadena de subministrament
    • Inventari
    • Fabricació
    • PLM
    • Compres
    • Manteniment
    • Qualitat
    Recursos humans
    • Empleats
    • Reclutament
    • Absències
    • Avaluacions
    • Recomanacions
    • Flota
    Màrqueting
    • Màrqueting Social
    • Màrqueting per correu electrònic
    • Màrqueting per SMS
    • Esdeveniments
    • Automatització del màrqueting
    • Enquestes
    Serveis
    • Projectes
    • Fulls d'hores
    • Servei de camp
    • Suport
    • Planificació
    • Cites
    Productivitat
    • Converses
    • Validacions
    • IoT
    • VoIP
    • Coneixements
    • WhatsApp
    Aplicacions de tercers Odoo Studio Plataforma d'Odoo al núvol
  • Sectors
    Comerç al detall
    • Llibreria
    • Botiga de roba
    • Botiga de mobles
    • Botiga d'ultramarins
    • Ferreteria
    • Botiga de joguines
    Food & Hospitality
    • Bar i pub
    • Restaurant
    • Menjar ràpid
    • Guest House
    • Distribuïdor de begudes
    • Hotel
    Immobiliari
    • Agència immobiliària
    • Estudi d'arquitectura
    • Construcció
    • Gestió immobiliària
    • Jardineria
    • Associació de propietaris de béns immobles
    Consultoria
    • Empresa comptable
    • Partner d'Odoo
    • Agència de màrqueting
    • Bufet d'advocats
    • Captació de talent
    • Auditoria i certificació
    Fabricació
    • Textile
    • Metal
    • Mobles
    • Menjar
    • Brewery
    • Regals corporatius
    Salut i fitness
    • Club d'esport
    • Òptica
    • Centre de fitness
    • Especialistes en benestar
    • Farmàcia
    • Perruqueria
    Trades
    • Servei de manteniment
    • Hardware i suport informàtic
    • Sistemes d'energia solar
    • Shoe Maker
    • Serveis de neteja
    • Instal·lacions HVAC
    Altres
    • Nonprofit Organization
    • Agència del medi ambient
    • Lloguer de panells publicitaris
    • Fotografia
    • Lloguer de bicicletes
    • Distribuïdors de programari
    Browse all Industries
  • Comunitat
    Aprèn
    • Tutorials
    • Documentació
    • Certificacions
    • Formació
    • Blog
    • Pòdcast
    Potenciar l'educació
    • Programa educatiu
    • Scale-Up! El joc empresarial
    • Visita Odoo
    Obtindre el programari
    • Descarregar
    • Comparar edicions
    • Novetats de les versions
    Col·laborar
    • GitHub
    • Fòrum
    • Esdeveniments
    • Traduccions
    • Converteix-te en partner
    • Services for Partners
    • Registra la teva empresa comptable
    Obtindre els serveis
    • Troba un partner
    • Troba un comptable
    • Contacta amb un expert
    • Serveis d'implementació
    • Referències del client
    • Suport
    • Actualitzacions
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Programar una demo
  • Preus
  • Ajuda

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

  • CRM
  • e-Commerce
  • Comptabilitat
  • Inventari
  • PoS
  • Projectes
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
Ajuda

Not run pyExcelerator and AerooLib in OpenERP 6.1 for Windows

Subscriure's

Get notified when there's activity on this post

This question has been flagged
v6.1pythonpyexceleratoraeroolib
2 Respostes
21687 Vistes
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
Descartar
Joaquin
Autor

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
Descartar
Joaquin
Autor

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
Autor

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

Joaquin
Autor

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

Joaquin
Autor

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
Autor 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
Descartar
Joaquin
Autor

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
Autor

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
Autor

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
Autor

Please help me!!!

Joaquin
Autor

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!

Registrar-se
Related Posts Respostes Vistes Activitat
Not Run AerooLib in OpenERP 6.1 for Windows
v6.1 python aeroolib openerp
Avatar
Avatar
1
de març 15
7314
Which python version is recommended? Solved
v6.1 python version v7
Avatar
Avatar
Avatar
Avatar
3
de març 15
33520
Is there somewhere a list of needed python libraries?
v6.1 python v7 dependencies libraries
Avatar
Avatar
1
de març 15
15208
using RML to Pull data from other tables
v6.1 python rml account.invoice sale.order
Avatar
Avatar
1
de març 15
7837
눈Volaris Contacto Numero눈¿Cómo hablar con un asesor de Volaris?
v6.1
Avatar
0
de nov. 25
10
Community
  • Tutorials
  • Documentació
  • Fòrum
Codi obert
  • Descarregar
  • GitHub
  • Runbot
  • Traduccions
Serveis
  • Allotjament a Odoo.sh
  • Suport
  • Actualització
  • Desenvolupaments personalitzats
  • Educació
  • Troba un comptable
  • Troba un partner
  • Converteix-te en partner
Sobre nosaltres
  • La nostra empresa
  • Actius de marca
  • Contacta amb nosaltres
  • Llocs de treball
  • Esdeveniments
  • Pòdcast
  • Blog
  • Clients
  • Informació legal • Privacitat
  • Seguretat
الْعَرَبيّة 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 és un conjunt d'aplicacions empresarials de codi obert que cobreix totes les necessitats de la teva empresa: CRM, comerç electrònic, comptabilitat, inventari, punt de venda, gestió de projectes, etc.

La proposta única de valor d'Odoo és ser molt fàcil d'utilitzar i estar totalment integrat, ambdues alhora.

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