Dear simahawk,

thanks for the interesting module. I wanted to test it today, but experienced the exact problem of logic_openerp. However, I am not on Windows but on FreeBSD.

I have installed relatorio and openoffice-python. But the result is the same.

Please let me know, if I can help you with further tests/output to help you identify the problem (I am not familiar with python, though).

Best regards.

hi utrenkner,
happy to have this module tested on multiple platforms

I'm not used to FreeBSD... but I'm going to test it on a vm asap.

In the meanwhile, if you already didn't do it, can you try to "import relatorio" directly from the python shell?

Just go to a terminal and type "python2.4/5/6" - based on which version you are using for OE - and then type "import relatorio"

Hi!
I try to install your module with ubuntu but I have the same issue (I install relatorio and openoffice-python with easy_install).
nvironment Information :
System : Linux-2.6.31-11-generic-i686-with-Ubuntu-9.10-karmic
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu karmic (development branch)
Release: 9.10
Codename: karmic
Operating System Release : 2.6.31-11-generic
Operating System Version : #36-Ubuntu SMP Fri Sep 25 06:37:51 UTC 2009
Operating System Architecture : 32bit
Operating System Locale : fr_FR.UTF8
Python Version : 2.5.4
OpenERP-Client Version : 5.0.6
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/netsvc.py", line 244, in dispatch
result = LocalService(service_name)(method, *params)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/netsvc.py", line 73, in __call__
return getattr(self, method)(*params)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/service/web_services.py", line 639, in execute
return self._execute(db, uid, wiz_id, datas, action, context)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/service/web_services.py", line 619, in _execute
return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/wizard/__init__.py", line 178, in execute
res = self.execute_cr(cr, uid, data, state, context)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/wizard/__init__.py", line 74, in execute_cr
action_res = action(self, cr, uid, data, context)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module
db, pool = pooler.restart_pool(cr.dbname, update_module=True)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/pooler.py", line 62, in restart_pool
return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/pooler.py", line 40, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/addons/__init__.py", line 728, in load_modules
r = load_module_graph(cr, graph, status, report=report)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/addons/__init__.py", line 578, in load_module_graph
register_class(package.name)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/addons/__init__.py", line 400, in register_class
imp.load_module(m, *fm)
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/addons/report_openoffice/__init__.py", line 1, in <module>
import report_openoffice
File "/home/logicalsoft/openerp-5.0.6/openerp-server-5.0.6/bin/addons/report_openoffice/report_openoffice.py", line 30, in <module>
from relatorio.templates.opendocument import Template
ImportError: No module named relatorio.templates.opendocument
Thanks

I was wrong! Sorry! It does work with ubuntu
But now, I don't know how to use it! So if you can to explain how to use it I would be thankful!
Thank you

Please, have a look at report_openoffice_samples and pay attention to its README.txt

Cheers

Hi simahawk,

sorry for the longer absence from this forum.

Thank you for the hint on the import through the python-shell. It revealed that further modules had to be installed as well py-pycha and py-yaml in my case.

Now I was able to install the modules report_openoffice and report_openoffice_samples. But the information in the README is not enough for me to understand what I have to do. I did change the invoice to the Openoffice type as you suggested. Is this all there is to do?

Because when I then try to print an invoice, I get a lot of python error message. However, at this point I should probably say that I am not running trunk but openerp-server-5.0.6. Do you think this is or could be the reason?

Thanks and regards
Uwe.

hi,

can you paste them somewhere?

5.0.6: me too but it works smoothly... let's see your errors

Cheers

Hi,

I have sent you a private message with a link to the resulting errors.

Looking forward to hearing from you. Best regards!

Dear simahawk,

you are right, we should continue the discussion, here in the forum.

I can confirm that both, report_openoffice and report_openoffice_samples are installed in their version 5.0.0.1.

For the records, these are the messages I receive(d) with the different reporting setting:

This is what I get with "OpenOffice - odt/ods output" for invoice in "report xml":
File "/usr/local/lib/python2.6/site-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 606, in respond
cherrypy.response.body = self.handler()
File "/usr/local/lib/python2.6/site-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cpdispatch.py", line 25, in __call__
return self.callable(*self.args, **self.kwargs)
File "/usr/local/lib/python2.6/site-packages/openerp_web-5.0.6-py2.6.egg/openerp/controllers/base.py", line 122, in wrapper
return fn(*args, **kw)
File "/usr/local/lib/python2.6/site-packages/openerp_web-5.0.6-py2.6.egg/openerp/tools/expose.py", line 204, in func_wrapper
res = func(*args, **kw)
File "/usr/local/lib/python2.6/site-packages/openerp_web-5.0.6-py2.6.egg/openerp/controllers/form.py", line 878, in action
return actions.execute(action, model=params.model, id=id, ids=ids, report_type='pdf')
File "/usr/local/lib/python2.6/site-packages/openerp_web-5.0.6-py2.6.egg/openerp/controllers/actions.py", line 281, in execute
return execute_report(action['report_name'], **data)
File "/usr/local/lib/python2.6/site-packages/openerp_web-5.0.6-py2.6.egg/openerp/controllers/actions.py", line 177, in execute_report
return _print_data(val)
File "/usr/local/lib/python2.6/site-packages/openerp_web-5.0.6-py2.6.egg/openerp/controllers/actions.py", line 129, in _print_data
cherrypy.response.headers['Content-Type'] = PRINT_FORMATS[data['format']]
KeyError: u'odt'


And this is what I get with "OpenOffice - pdf output" for invoice in "report xml":
File "/usr/local/lib/python2.6/site-packages/openerp-server/service/web_services.py", line 687, in go
(result, format) = obj.create(cr, uid, ids, datas, context)
File "/usr/local/lib/python2.6/site-packages/openerp-server/addons/report_openoffice/report_openoffice.py", line 137, in create
return fnct(cr, uid, ids, data, report_xml, context)
File "/usr/local/lib/python2.6/site-packages/openerp-server/report/report_sxw.py", line 392, in create_source_pdf
result = self.create_single_pdf(cr, uid, [obj.id], data, report_xml, context)
File "/usr/local/lib/python2.6/site-packages/openerp-server/addons/report_openoffice/report_openoffice.py", line 145, in create_single_pdf
return self.create_relatorio_report(cr, uid, ids, data, report_xml, context=context, output='pdf')
File "/usr/local/lib/python2.6/site-packages/openerp-server/addons/report_openoffice/report_openoffice.py", line 105, in create_relatorio_report
data = convert_pdf(data)
File "/usr/local/lib/python2.6/site-packages/openerp-server/addons/report_openoffice/convert_pdf.py", line 43, in convert_pdf
raise Exception('ImportError', str(exception))
Exception: ('ImportError', 'No module named unohelper')

Hope this helps.

Hi, I meant that this

means that you don't have openoffice.org's modules - in this case "unohelper" - installed or properly installed in your system.

You have to check for python-uno...

Hi,

dpkg does not exist in a normal FreeBSD system, as we use either the pkg-tools or ports (there exists a Debian project which uses the FreeBSD kernel with GNU userland... but that is something very different).

But I found the files anyway. Unfortunately there is something wrong with the pyuno module so that I won't get this to run. I have an idea what the cause could be, but a fix would need a recompile of OOo, which takes several hours... therefore, I will have to live without your addon for the moment.

If and when I can solve that issue, I will give it a try, again.

Many thanks for your help and patience so far!

Best regards
Uwe.

A question here

I changed the sample template and if I run the report as ODT output - it opens up the edited template. However, if I set it to Type: OpenOffice-PDF - the cached PDF is opening each time.

What's the solution for this?
Thanks a lot!

Ok, the solution is UNCHECKING the RELOAD FROM ATTACHMENT in Administration - ReportXML!

Hi *,
we moved report_openoffice and report_openoffice_samples to a dedicated branch:

lp:~openerp-community/openobject-addons/report_openoffice

Hi all, first of all, I'd like to thank simahawk for such a usefull and free module, but I get the same error as above even though I've installed relatorio, openoffice-python and openoffice.org on my system (windows).

I used the commands:

easy_install relatorio
easy_install openoffice-python

I also installed all the reguired modules for relatorio and openoffice-python.

I've verified that the paths for the packages are included in the python sys.path.

still, the modules won't install in openerp. I think the problem might be that openerp can't find the packages.

does anyone have any idea how to fix this? I tried google and it ran out of ideas too.


figassis