Skip to Content
Odoo Meniu
  • Autentificare
  • Try it free
  • Aplicații
    Finanțe
    • Contabilitate
    • Facturare
    • Cheltuieli
    • Spreadsheet (BI)
    • Documente
    • Semn
    Vânzări
    • CRM
    • Vânzări
    • POS Shop
    • POS Restaurant
    • Abonamente
    • Închiriere
    Site-uri web
    • Constructor de site-uri
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Lanț Aprovizionare
    • Inventar
    • Producție
    • PLM
    • Achiziție
    • Maintenance
    • Calitate
    Resurse Umane
    • Angajați
    • Recrutare
    • Time Off
    • Evaluări
    • Referințe
    • Flotă
    Marketing
    • Social Marketing
    • Marketing prin email
    • SMS Marketing
    • Evenimente
    • Automatizare marketing
    • Sondaje
    Servicii
    • Proiect
    • Foi de pontaj
    • Servicii de teren
    • Centru de asistență
    • Planificare
    • Programări
    Productivitate
    • Discuss
    • Aprobări
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Aplicații Terțe Odoo Studio Platforma Odoo Cloud
  • Industrii
    Retail
    • Book Store
    • Magazin de îmbrăcăminte
    • Magazin de Mobilă
    • Magazin alimentar
    • Magazin de materiale de construcții
    • Magazin de jucării
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Distribuitor de băuturi
    • Hotel
    Proprietate imobiliara
    • Real Estate Agency
    • Firmă de Arhitectură
    • Construcție
    • Estate Managament
    • Grădinărit
    • Asociația Proprietarilor de Proprietăți
    Consultanta
    • Firma de Contabilitate
    • Partener Odoo
    • Agenție de marketing
    • Law firm
    • Atragere de talente
    • Audit & Certification
    Producție
    • Textil
    • Metal
    • Mobilier
    • Mâncare
    • Brewery
    • Cadouri corporate
    Health & Fitness
    • Club Sportiv
    • Magazin de ochelari
    • Centru de Fitness
    • Wellness Practitioners
    • Farmacie
    • Salon de coafură
    Trades
    • Handyman
    • IT Hardware and Support
    • Asigurare socială de stat
    • Cizmar
    • Servicii de curățenie
    • HVAC Services
    Altele
    • Organizație nonprofit
    • Agenție de Mediu
    • Închiriere panouri publicitare
    • Fotografie
    • Închiriere biciclete
    • Asigurare socială
    Browse all Industries
  • Comunitate
    Învăță
    • Tutorials
    • Documentație
    • Certificări
    • Instruire
    • Blog
    • Podcast
    Empower Education
    • Program Educațional
    • Scale Up! Business Game
    • Visit Odoo
    Obține Software-ul
    • Descărcare
    • Compară Edițiile
    • Lansări
    Colaborați
    • Github
    • Forum
    • Evenimente
    • Translations
    • Devino Partener
    • Services for Partners
    • Înregistrează-ți Firma de Contabilitate
    Obține Servicii
    • Găsește un Partener
    • Găsiți un contabil
    • Meet an advisor
    • Servicii de Implementare
    • Referințe ale clienților
    • Suport
    • Actualizări
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Obține un demo
  • Prețuri
  • Ajutor

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

  • CRM
  • e-Commerce
  • Contabilitate
  • Inventar
  • PoS
  • Proiect
  • MRP
All apps
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Suport

Not run pyExcelerator and AerooLib in OpenERP 6.1 for Windows

Abonare

Primiți o notificare când există activitate la acestă postare

Această întrebare a fost marcată
v6.1pythonpyexceleratoraeroolib
2 Răspunsuri
21700 Vizualizări
Imagine profil
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
Imagine profil
Abandonează
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.

Imagine profil
Cyril Gaspard (GEM)
Cel mai bun răspuns

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
Imagine profil
Abandonează
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

Imagine profil
Joaquin
Autor Cel mai bun răspuns

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
Imagine profil
Abandonează
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!

Înscrie-te
Related Posts Răspunsuri Vizualizări Activitate
Not Run AerooLib in OpenERP 6.1 for Windows
v6.1 python aeroolib openerp
Imagine profil
Imagine profil
1
mar. 15
7334
Which python version is recommended? Rezolvat
v6.1 python version v7
Imagine profil
Imagine profil
Imagine profil
Imagine profil
3
mar. 15
33591
Is there somewhere a list of needed python libraries?
v6.1 python v7 dependencies libraries
Imagine profil
Imagine profil
1
mar. 15
15247
using RML to Pull data from other tables
v6.1 python rml account.invoice sale.order
Imagine profil
Imagine profil
1
mar. 15
7860
눈Volaris Contacto Numero눈¿Cómo hablar con un asesor de Volaris?
v6.1
Imagine profil
0
nov. 25
10
Comunitate
  • Tutorials
  • Documentație
  • Forum
Open Source
  • Descărcare
  • Github
  • Runbot
  • Translations
Servicii
  • Hosting Odoo.sh
  • Suport
  • Actualizare
  • Custom Developments
  • Educație
  • Găsiți un contabil
  • Găsește un Partener
  • Devino Partener
Despre Noi
  • Compania noastră
  • Active de marcă
  • Contactați-ne
  • Locuri de muncă
  • Evenimente
  • Podcast
  • Blog
  • Clienți
  • Aspecte juridice • Confidențialitate
  • Securitate
الْعَرَبيّة 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 este o suită de aplicații de afaceri open source care acoperă toate nevoile companiei dvs.: CRM, comerț electronic, contabilitate, inventar, punct de vânzare, management de proiect etc.

Propunerea de valoare unică a Odoo este să fie în același timp foarte ușor de utilizat și complet integrat.

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