跳至内容
Odoo 菜单
  • 登录
  • 免费试用
  • 应用程序
    财务
    • 会计
    • 发票
    • 费用
    • 电子表格 (BI)
    • 文档
    • 电子签名
    销售
    • 客户关系管理
    • 销售
    • POS 销售点管理-零售
    • POS 销售点管理 - 餐厅
    • 订阅
    • 租赁
    网站
    • 网站设计
    • 电子商务
    • 博客
    • 论坛
    • 在线客服
    • 在线学习
    供应链
    • 库存
    • 制造
    • 产品生命周期
    • 采购
    • 维护保养
    • 品控
    人力资源
    • 员工
    • 招聘
    • 休假
    • 评价
    • 内部推荐
    • 车队
    营销
    • 社媒营销
    • 电邮营销
    • 短信营销
    • 近期活动
    • 营销自动化
    • 网上调查
    服务
    • 项目管理
    • 工时单
    • 现场服务
    • 服务台
    • 排期
    • 预约
    生产力
    • 讨论
    • 批核
    • IoT物联网
    • VoIP
    • 知识库
    • WhatsApp
    第三方应用软件 Odoo 定制 Odoo云端平台
  • 行业
    零售
    • 书店
    • 服装店
    • 家具店
    • 食品杂货店
    • 五金店
    • 玩具店
    餐饮与酒店服务
    • 酒吧及酒馆
    • 餐厅
    • 快餐
    • 民宿
    • 饮品分销商
    • 酒店
    房地产
    • 房地产代理
    • 建筑师事务所
    • 建造业
    • 地产管理
    • 园艺
    • 业主协会
    咨询
    • 会计师事务所
    • Odoo合作伙伴
    • 市场推广公司
    • 律师事务所
    • 人才招聘
    • 审核 & 认证
    制造
    • 纺织
    • 金属
    • 家具
    • 食品
    • 啤酒厂
    • 企业礼品
    保健与健身
    • 体育俱乐部
    • 眼镜店
    • 健身中心
    • 健康从业者
    • 药房
    • 发型屋
    商贸服务
    • 维修人员
    • IT 硬件及支持
    • 太阳能系统
    • 鞋匠
    • 清洁服务
    • 暖通空调服务
    其他
    • 非营利组织
    • 环境机构
    • 广告牌租赁
    • 摄影服务
    • 自行车租赁
    • 软件经销商
    浏览所有行业
  • 社区
    学习
    • 教学视频
    • 文档
    • 认证
    • 培训
    • 博客
    • 播客
    赋能教育
    • 教育计划
    • Scale Up! 商业游戏
    • 参观Odoo
    获取软件
    • 下载
    • 版本对比
    • 发布
    合作
    • Github
    • 论坛
    • 近期活动
    • 翻译
    • 成为合作伙伴
    • 合作伙伴服务
    • 注册您的会计事务所
    获取服务
    • 寻找合作伙伴
    • 查找会计服务
    • 预约顾问咨询
    • 安装及推行服务
    • 客户参考
    • 支持
    • 升级
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    获取演示
  • 定价
  • 技术支持

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

  • 客户关系管理
  • e-Commerce
  • 会计
  • 库存
  • PoS
  • 项目
  • MRP
All apps
只限注册用戶才可与社群互动。
所有帖文 人 徽章
标签 (查看所有)
odoo accounting v14 pos v15
关于此论坛区
只限注册用戶才可与社群互动。
所有帖文 人 徽章
标签 (查看所有)
odoo accounting v14 pos v15
关于此论坛区
帮助

Not run pyExcelerator and AerooLib in OpenERP 6.1 for Windows

订阅

此帖文有活动时,接收通知

此问题已终结
v6.1pythonpyexceleratoraeroolib
2 回复
21697 查看
形象
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
形象
丢弃
Joaquin
编写者

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.

形象
Cyril Gaspard (GEM)
最佳答案

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
形象
丢弃
Joaquin
编写者

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
编写者

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

Joaquin
编写者

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

Joaquin
编写者

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

形象
Joaquin
编写者 最佳答案

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
形象
丢弃
Joaquin
编写者

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
编写者

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
编写者

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
编写者

Please help me!!!

Joaquin
编写者

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

喜欢讨论吗?不要只阅读,加入进来!

立即创建账户,享受专属功能,与我们的精彩社区互动!

注册
相关帖文 回复 查看 活动
Not Run AerooLib in OpenERP 6.1 for Windows
v6.1 python aeroolib openerp
形象
形象
1
3月 15
7325
Which python version is recommended? 已解决
v6.1 python version v7
形象
形象
形象
形象
3
3月 15
33557
Is there somewhere a list of needed python libraries?
v6.1 python v7 dependencies libraries
形象
形象
1
3月 15
15235
using RML to Pull data from other tables
v6.1 python rml account.invoice sale.order
形象
形象
1
3月 15
7850
눈Volaris Contacto Numero눈¿Cómo hablar con un asesor de Volaris?
v6.1
形象
0
11月 25
10
社区
  • 教学视频
  • 文档
  • 论坛
开源
  • 下载
  • Github
  • Runbot
  • 翻译
服务
  • Odoo.sh 托管
  • 支持
  • 升级
  • 自定义开发服务
  • 教育
  • 查找会计服务
  • 寻找合作伙伴
  • 成为合作伙伴
关于我们
  • 我们的公司
  • 品牌资产
  • 联系我们
  • 招聘
  • 近期活动
  • 播客
  • 博客
  • 客户
  • 法律 • 隐私
  • 安全
الْعَرَبيّة 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致力于为企业管理提供高效智能的开源解决方案,是全球业内高速成长的软件服务商之一,逾七百五十万用户选择Odoo进行数字化升级。通过一系列全业务链覆盖、高度集成、简单易用的商业应用,助力企业实现信息化改革、降本增效并释放公司增长潜力。

Odoo独特的价值在于是一款非常容易使用又完全集成的应用。

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