Error installing report_openoffice

[emyllymaki]

Hello,

I am trying to install report_openoffice and running into an error.

Machine is Ubuntu 8.04 LTS with new install of OpenERP from stable/5.0.

report_openoffice was obtained by: bzr branch lp:report-openoffice

The error I am getting when trying to install:

Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 244, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 73, in __call__
return getattr(self, method)(*params)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 653, in execute
return self._execute(db, uid, wiz_id, datas, action, context)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 633, in _execute
return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
File "/usr/lib/python2.5/site-packages/openerp-server/wizard/__init__.py", line 177, in execute
res = self.execute_cr(cr, uid, data, state, context)
File "/usr/lib/python2.5/site-packages/openerp-server/wizard/__init__.py", line 73, in execute_cr
action_res = action(self, cr, uid, data, context)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module
db, pool = pooler.restart_pool(cr.dbname, update_module=True)
File "/usr/lib/python2.5/site-packages/openerp-server/pooler.py", line 62, in restart_pool
return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
File "/usr/lib/python2.5/site-packages/openerp-server/pooler.py", line 40, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 740, in load_modules
r = load_module_graph(cr, graph, status, report=report)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 581, in load_module_graph
register_class(package.name)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 403, in register_class
imp.load_module(m, *fm)
File "/opt/openerp/stable/5.0/addons/report_openoffice/__init__.py", line 29, in <module>
import report_openoffice
File "/opt/openerp/stable/5.0/addons/report_openoffice/report_openoffice.py", line 40, in <module>
from ExtraFunctions import ExtraFunctions
File "/usr/lib/python2.5/site-packages/uno.py", line 301, in _uno_import
raise ImportError( "type "+ name + "." +x + " is unknown" )
ImportError: type ExtraFunctions.ExtraFunctions is unknown

python
import uno
import pyuno

produce no errros.

Thanks for any help.

[Normunds]

The current trunk version of Openoffice_report is considered alpha.
We have made a lot of bugfixes and improvements since last launchpad upload on december. Wait a little bit. We will upload a new version late today or on Friday.

[emyllymaki]

The current trunk version of Openoffice_report is considered alpha.
We have made a lot of bugfixes and improvements since last launchpad upload on december. Wait a little bit. We will upload a new version late today or on Friday.

Great - thank you.

[Normunds]

One more thing.
Uninstall, old openoffice_report module, before new installation.
Sequence:
Uninstall old
Delete old module
Put new module on server
Restart server
Install module

[emyllymaki]

I just updated from launchpad (bzr branch lp:report-openoffice )but it's the same version as the one that is not working for me, rev3.

Is this where I should be looking for updates?

Thanks.

[Normunds]

Try once more. It is updated now.

http://launchpad.net/report-openoffice/ ... office.zip

[emyllymaki]

Try once more. It is updated now.

http://launchpad.net/report-openoffice/ ... office.zip

Thanks very much for the update.

I uninstalled report_openoffice and report_openoffice_samples, stopped the server and deleted the report_openoffice and report_openoffice_samples folders in addons.

I moved the new report_openoffice module into addons and restarted the server.

I tried to install in my existing database but got the same error as before.

So I made a new database with minimal profile but got the same error when trying to install there as well:

Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 244, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 73, in __call__
return getattr(self, method)(*params)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 653, in execute
return self._execute(db, uid, wiz_id, datas, action, context)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 633, in _execute
return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
File "/usr/lib/python2.5/site-packages/openerp-server/wizard/__init__.py", line 177, in execute
res = self.execute_cr(cr, uid, data, state, context)
File "/usr/lib/python2.5/site-packages/openerp-server/wizard/__init__.py", line 73, in execute_cr
action_res = action(self, cr, uid, data, context)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module
db, pool = pooler.restart_pool(cr.dbname, update_module=True)
File "/usr/lib/python2.5/site-packages/openerp-server/pooler.py", line 62, in restart_pool
return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
File "/usr/lib/python2.5/site-packages/openerp-server/pooler.py", line 40, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 740, in load_modules
r = load_module_graph(cr, graph, status, report=report)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 581, in load_module_graph
register_class(package.name)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 403, in register_class
imp.load_module(m, *fm)
File "/opt/openerp/stable/5.0/addons/report_openoffice/__init__.py", line 29, in <module>
import report_openoffice
File "/usr/lib/python2.5/site-packages/uno.py", line 262, in _uno_import
return _g_delegatee( name, *optargs )
File "/opt/openerp/stable/5.0/addons/report_openoffice/report_openoffice.py", line 40, in <module>
from ExtraFunctions import ExtraFunctions
File "/usr/lib/python2.5/site-packages/uno.py", line 301, in _uno_import
raise ImportError( "type "+ name + "." +x + " is unknown" )
ImportError: type ExtraFunctions.ExtraFunctions is unknown

[emyllymaki]

Try once more. It is updated now.

http://launchpad.net/report-openoffice/ ... office.zip

RESOLVED!

I had installed PIL via easy_install and it seemed like it had worked (no errors) - I had not tested it though.

I just checked the ExtraFunctions.py file and tried to load it by itself and got a "PIL not found" error.

So I installed PIL with "sudo apt-get install python-imaging" and now the module installs.

Thanks again and sorry for the noise.

[emyllymaki]

I am getting an error when I try and set the type in "Report XML".

I read the README.txt in report_openoffice_samples and it said:

** ISSUE: for barcodes' reports you need to set the proper type from the 'Report XML' menu.
See reports_samples.xml to understand why.
**

I didn't learn much from reading reports_samples.xml but I went into ReportsXML and tired to change the report type for the BarcodeEAN report to "OpenOffice - pdf output" and got the following error:

Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 244, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 73, in __call__
return getattr(self, method)(*params)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 597, in execute
res = service.execute(db, uid, object, method, *args)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 61, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 120, in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 112, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/stable/5.0/addons/report_openoffice/report_xml.py", line 139, in write
parser=load_from_source("from report import report_sxw\n"+vals['parser_def'])
File "/opt/openerp/stable/5.0/addons/report_openoffice/report_openoffice.py", line 325, in load_from_source
exec source in context
File "<string>", line 2
class Parser(report_sxw.rml_parse):

^
SyntaxError: invalid syntax

[emyllymaki]

Making progress - I found your page here on the install procedure:

http://kndati.lv/index.php/en/openerp/o ... stallation

which is very helpful (i think mention of it in the module would be great - __terp__.py description maybe?)

So soffice was not up and running in headless mode. I started it up, tested with telnet and then went back to Low Level Objects and saved the OpenOffice connection which now saved with no error.

Now I get a BadZipFile error when I try and get one of the sample reports and it looks like this is an outstanding bug:
https://bugs.launchpad.net/report-openo ... bug/499540

Any suggestions on how to continue?

Thanks.