log client gtk:

openoffice 2.4.3 has python23.dll and not python25.dll ,even if i copy it in progam, all the time same error, read spec for pyuno on windows et ooo3:
http://udk.openoffice.org/python/python-bridge.html.
but the script I gave works (have not error "no module named pyuno")

We are pleased to announce release of more or less usable user documentation for this module.

It can be found here:
http://kndati.lv/index.php/en/openerp/o ... ing-engine

Here you can find usable information on how to use OpenOffice reporting engine and create your first reports.

Many thanks to those who contributed with their bug reports,

Kaspars
-----------------------------
http://kndati.lv

Instaling report_openoffice on Ubuntu 8.04 LTS/ openerp 5.0.7/ openoffice 3.2.0 dont work.
the error:

File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 403, in register_class
imp.load_module(m, *fm)
File "/usr/lib/python2.5/site-packages/openerp-server/addons/report_openoffice/__init__.py", line 29, in <module>
import report_openoffice
File "/usr/lib/python2.5/site-packages/openerp-server/addons/report_openoffice/report_openoffice.py", line 39, 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

Can you tell me why?
Thanks!

It's working now for me!!!

if it could be interesting for someone, I posted all my troubles here(not very much actually)

http://www.openerpsite.com/el-nuevo-mot ... /1389.html

Hello All,

Has anyone figured out how to do this on a Windows machine. I have been trying for a couple of days now and it is confusing and frustrating.

Here is the error message I get when trying to install the report-openoffice module in OpenERP:

Environment Information :
System : Windows-XP-5.1.2600-SP3
OS Name : nt
Operating System Release : XP
Operating System Version : 5.1.2600
Operating System Architecture : 32bit
Operating System Locale : en_US.cp1252
Python Version : 2.5.2
OpenERP-Client Version : 5.0.7
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "netsvc.pyo", line 244, in dispatch
File "netsvc.pyo", line 73, in __call__
File "service\web_services.pyo", line 632, in execute
File "service\web_services.pyo", line 612, in _execute
File "wizard\__init__.pyo", line 178, in execute
File "wizard\__init__.pyo", line 73, in execute_cr
File "C:\Program Files\OpenERP AllInOne\Server\addons\base\module\wizard\wizard_module_upgrade.py", line 92, in _upgrade_module
File "pooler.pyo", line 62, in restart_pool
File "pooler.pyo", line 40, in get_db_and_pool
File "addons\__init__.pyo", line 740, in load_modules
File "addons\__init__.pyo", line 581, in load_module_graph
File "addons\__init__.pyo", line 409, in register_class
File "C:\Program Files\OpenERP AllInOne\Server\addons\report_openoffice.zip\report_openoffice\__init__.py", line 29, in <module>
File "C:\Program Files\OpenERP AllInOne\Server\addons\report_openoffice.zip\report_openoffice\report_openoffice.py", line 31, in <module>
ImportError: No module named relatorio.templates.opendocument

I have relatorio installed in my Python files. On Windows if you look under C drive you can see all the Python versions installed. I had 3 versions installed but only one listed in my environment variable path. I listed the Python 2.5 version. I originally tried using Python 2.6 but OpenERP was using Python 2.5 - So I changed that. I used Python Package manager to install all the Python modules - works great if you are on windows.

I do not understand the error message about no module named relatario.templates.opendocument. There is a module named relatario and it has a sub folder called templates and it has a document called opendocument. Here is the path C:\Python25\Lib\site-packages\relatorio\templates and then as I said the opendocument file is in the templates folder???

Any help would be greatly appreciated. I am not a Python programmer and I need detailed instructions if possible. I really like OpenERP but reporting functions and customization are going to be very important and I do not currently have the 500 Euros they want for their module. Not in the budget right now. And I know I could get their file off a bit torrent server but I don't like that option. Again any help would be appreciated.

I was able to set up an ODBC connection from Open Office to my OpenERP database. Does anyone know how to get the reports out of OpenERP to be edited in OpenOffice? I see there is a function to upload an edited report back into OpenERP. The problem I have is how do I first get the report out as an RML file and then convert to a sxw for editing in Open Office and then convert back to RML for upload back into OpenERP??? I know this is what the module for sale does. Anyone know how to do the conversions wihtout using the expensive module? I wish I had the funds to buy the product but I don't.

Thanks,

Trish

There are only two options at this moment for editing reports in OpenOffice- using costly Report Designer (with GUI) or report_openoffice module. I think that it is not worth to buy Report Designer, because of it's wrong design and problems caused because of it.
There is also one big problem with report_openoffice use. It is rather hard to install in linux (solution:read carefully install instructions, to avoid troubles) and at this moment nobody managed to set up it in windows server environment (at least haven't informed).
I will try to set up in windows this week, and will inform the result.

Hello 3pm,

Thanks for taking the time to try and figure this thing out. I am also continuing to try and sort it out. I read somewhere in the forums or in the developer section about the sxw and rml conversion of files, I usually try and find my answers before I post to a forum, I wonder if you have seen the information in the following post?

http://doc.openerp.com/developer/3_11_reports/11_1_openoffice_report.html

They talk about using the following file and it's location

The tiny_sxw2rml.py can be found in the base_report_designer Open ERP module at this location: (I gave you the path because the documentation page does not really let you see where the file is located)

server/bin/addons/base_report_designer/wizard/tiny_sxw2rml/tiny_sxw2rml.py

This is the path on my machine - it is slightly different (no bin)

\\Presarioxp\presario (c)\Program Files\OpenERP AllInOne\Server\addons\base_report_designer\wizard\tiny_sxw2rml

Have you used this functionality? Is this option worth trying to figure out?

I am just a bit surprised that OpenERP is so nice but has no "easy" report customization. I am a little disappointed. Anyway thanks for your help!

Trish

Hi, pkemke!

To understand what sxw & rml stuff is like - you can read, what Raphaël says about it.
http://openobject.com/forum/topic14846-15.html

And believe me, he knows, what he is talking about - at the moment he is one of the most experienced community members.

It is at least ten times faster to create and deploy new report with this new OOo reporting engine than any sxw/rml combination, even proprietary Report Designer software. And requires absolutely no money investment to create and install new report without developing special module, and all that in 5 minutes. Just need to set it up.

Yes, there are some problems, that are not solved by now, like complete system on Windows, but it is just a matter of time.

Best regards,
Kaspars
-----------------------------
http://kndati.lv

Hi Kaspars,

Thanks for the heads up about sxw and rml issue. I very much want to be able to install your reporting engine and get it to work for me and my clients. Problem is I use Windows. So I am looking forward to when the problems are solved. Thanks for all your hard work putting the reporting engine together. Hopefully 3pm will have some luck trying the install on a Windows machine.

Thanks,

Trish

Hello!

So.
Spent some two hard days of setting working report_openoffice environment in windows.

At this point I an say, it WORKS- both odt and pdf conversions!!!
At least manged to set up on Vista 64bit (with self compiled openerp-server 5.0.7 and some modifications in DocumentConverter.py)

BUT.
Do not try it with default compiled server for windows from openerp.com it will fail, cause it has not all necessary modules compiled in- it is waste of time.

@3pm
have you find solution to use report_openoffice on windows ?
If yes can you explain modifications to do please.
Thanks

Hello 3pm,

I have a Vista 64 bit system and an XP Professional machine too. So if you got this to work on Vista I would be interested in knowing how you did it - if you feel like sharing. I very much appreciate all your hard work and any help you may feel like offering.

As an alternative, do you think just editing the reports xml... files will work? That was my latest plan but kind of time comsuming and not something my clients (non IT people) would be comfortable doing.

Thanks,

Trish

Short guideline for windows setup is here:
http://kndati.lv/forum/viewtopic.php?f=11&t=62

Hi 3pm,
thanks for answer, but another question to build server with python 2.6 that I don't test, do I install list of libraries given for python 2.5 but build for python 2.6 (no bug or problem found ?).
no problem with clients which are build with python 2.5, or do i build its with python 2.6 too?
Thanks.