Community mailing list archives

community@mail.odoo.com

Re: Fwd: Aeroo Documentation

by
Serpent Consulting Services Pvt. Ltd., Jay Vora
- 05/25/2015 06:16:13
Great Job Luke!
I will update our blog too!
Thanks.

On Mon, May 25, 2015 at 3:06 PM, Luke Branch <odoocommunitywidgets@gmail.com> wrote:
Hi Nuria,

I've updated the forum post here:


to include information about using the script here:


Please pass it to your developers and ask them to give it a go using the installation method found in the script. The script has yes/no options for installing Odoo 8, and aeroo_reports modules, allowing you to use the script with an existing Odoo installation if you choose.

Please feel free to report any issues with the script on github here:


Regards,

Luke

On Wed, May 13, 2015 at 5:13 PM, Nuria Arranz Velazquez <nuria@opusvl.com> wrote:
Brilliant, looking forward to that, Luke.

On 11/05/15 18:07, Luke Branch wrote:
<blockquote cite="mid:CAA0hvkJjb4PWujqRzo9Y9pJMnGGUirqjt7WfUf+KO6NxFD54_Q@mail.gmail.com" type="cite">
Hi Nuria,

Thanks for taking the time to explain all that to me, I wan't aware of the locking issue.

In regards to report_aeroo_ooo, this was the original module that was incompatible with Ubuntu 14.04. This was due to the fact the pyuno package for Ubuntu 14.04 (that is packaged with OpenOffice/LibreOffice) was written in Python 3, while Odoo is written in 2.7 and all dependencies are written in 2.7 as well. This module (report_aeroo_ooo) was replaced by aeroo_docs (you can find this along with the other modules in github.com/aeroo).

From the little I understand about the module, aeroo_docs creates a bridge between the Python 3 uno package, and the rest of the Python 2.7 modules and Odoo. This allows you to connect to openoffice/libreoffice running as a headless service to allow the conversion of *.ods and *.odt report templates into *.xls, *.doc, *.pdf and other formats.

What I plan to do when I can find half an hour to put it together is create an sh script to install the aeroolib, aeroo_docs, and all dependencies in Ubuntu 14.04 to make it easier to adopt Aeroo for the average user.

It took me an afternoon to sift through many of the forum posts on alistek's website and help.odoo.com among other things to figure out how to set it up properly, and there are still some API-related bugs that need to be merged into the master/8.0 branch (Aeroo) for various modules like the direct_print module, however i've been using it in production for printing XLS multi-sheet product catalogs, quotations, invoices, etc. and the only real problem I have run into is printing a product catalog in XLS with product images when I created one with around 200,000 rows spread across multiple sheets. I believe at this point OpenOffice/LibreOffice crashed due to the lack of available resources on the low-spec development machine I was working on (4GB DDR2 RAM, 2 core processor), however this is an extreme use-case, and for standard day-to-day reports I have not run into any real issues yet.

Regarding Jasper, thanks for the links, i'll take a look into the docs in more detail when I can find time. I'd like to run a few of the different options (Aeroo, Jasper, Pentaho, etc.) side by side in different instances so I can decide which one i'll go with in the long run

I'll post a link to that forum post with a script once i've had the chance to put it together.

Regards,

Luke


On Mon, May 11, 2015 at 5:12 PM, Nuria Arranz Velazquez <nuria@opusvl.com> wrote:
Hi Luke,

Aeroo

The problem we had with Aeroo were purely installation, we never got to try it because it was too costly to invest any more time into installing it.

These are the things that stopped us:

1. First error was a simple one, File not found: report_aeroo_ooo/test_temp.odt
We went to aeroo_sample/report_aeroo/installer.py and change the path to report_aeroo/test_temp.odt

2. We then realised of a potential bottleneck, summarised by our engineers as follows:

In order to prevent issues with overloading OpenOffice the aerooo tools use a threadlock. This means that calls to convert open office documents will be a bottleneck as these can only be processed one at a time. I'm guessing this isn't a common operation so this shouldn't be a big problem. If however there is something jammed, then all future operations trying to access the open office app will also jam.

3. Then there was incompatibility issues (from our engineer's notes):

It appears that the version of OpenOffice we have installed and the aerolib are trying to talk apples and oranges. The python is making a JSON web request and OpenOffice is waiting for it's own Corba like communication protocol named UNO.

Sent by python :-

00000000  50 4f 53 54 20 2f 20 48  54 54 50 2f 31 2e 31 0d POST / H TTP/1.1.
00000010  0a 48 6f 73 74 3a 20 6c  6f 63 61 6c 68 6f 73 74 .Host: l ocalhost
00000020  3a 38 31 30 30 0d 0a 43  6f 6e 74 65 6e 74 2d 4c :8100..C ontent-L
00000030  65 6e 67 74 68 3a 20 31  30 32 38 33 0d 0a 63 6f ength: 1 0283..co
00000040  6e 74 65 6e 74 2d 74 79  70 65 3a 20 61 70 70 6c ntent-ty pe: appl
00000050  69 63 61 74 69 6f 6e 2f  6a 73 6f 6e 0d 0a 41 63 ication/ json..Ac
00000060  63 65 70 74 2d 45 6e 63  6f 64 69 6e 67 3a 20 67 cept-Enc oding: g
00000070  7a 69 70 2c 20 64 65 66  6c 61 74 65 2c 20 63 6f zip, def late, co
00000080  6d 70 72 65 73 73 0d 0a  41 63 63 65 70 74 3a 20 mpress.. Accept: 
00000090  2a 2f 2a 0d 0a 55 73 65  72 2d 41 67 65 6e 74 3a */*..Use r-Agent:
000000A0  20 70 79 74 68 6f 6e 2d  72 65 71 75 65 73 74 73  python- requests
000000B0  2f 32 2e 30 2e 30 20 43  50 79 74 68 6f 6e 2f 32 /2.0.0 C Python/2
000000C0  2e 37 2e 33 20 4c 69 6e  75 78 2f 33 2e 31 33 2e .7.3 Lin ux/3.13.
000000D0  30 2d 34 39 2d 67 65 6e  65 72 69 63 0d 0a 0d 0a 0-49-gen eric....
000000E0  7b 22 70 61 72 61 6d 73  22 3a 20 7b 22 75 73 65 {"params ": {"use
000000F0  72 6e 61 6d 65 22 3a 20  22 61 6e 6f 6e 79 6d 6f rname":  "anonymo
00000100  75 73 22 2c 20 22 64 61  74 61 22 3a 20 22 55 45 us", "da ta": "UE
00000110  73 44 42 42 51 41 41 41  41 41 41 45 56 73 6e 6a sDBBQAAA AAAEVsnj
...

Sent by OpenOffice :-

    00000000  00 00 00 65 00 00 00 01  f8 04 96 00 00 27 63 6f ...e.... .....'co
    00000010  6d 2e 73 75 6e 2e 73 74  61 72 2e 62 72 69 64 67 m.sun.st ar.bridg
    00000020  65 2e 58 50 72 6f 74 6f  63 6f 6c 50 72 6f 70 65 e.XProto colPrope
    00000030  72 74 69 65 73 15 55 72  70 50 72 6f 74 6f 63 6f rties.Ur pProtoco
    00000040  6c 50 72 6f 70 65 72 74  69 65 73 00 00 19 2e 55 lPropert ies....U
    00000050  72 70 50 72 6f 74 6f 63  6f 6c 50 72 6f 70 65 72 rpProtoc olProper
    00000060  74 69 65 73 54 69 64 00  00 ca 2d 65 75          tiesTid. ..-eu

Then both sides sit waiting for the other to say something they understand and everything is hung. Add to that the fact that there is a lock around the comms with the OpenOffice and you're going to get nowhere fast.

I'm guessing this stuff probably works with an older version of OpenOffice. The alternative will be to convert the aero lib to a newer library to talk to OpenOffice as I suspect it's only doing simple things. I believe the modern python library for talking to OpenOffice is Python-UNO - http://www.openoffice.org/udk/python/python-bridge.html. Alternatively if someone has update Aeroo perhaps there is a newer version with that library?

Luke, at this stage you provided us with some solution to the problem, I don't know if you remember,

https://www.odoo.com/forum/help-1/question/8-0-how-can-i-install-the-official-aeroo-reports-alistek-for-odoo-version-8-solved-76044

4. But when we attempted it we had the next incompatibility problem:

It appears that aeroo_docs depends on aeroolib. That appears to be needed in both Python 2 and 3, but the setup.py isn't compatible with 3.

At this point we gave up.

Jasper

Looking at the Community edition, you probably already got this documentation about Jasper reports:

http://community.jaspersoft.com/documentation?version=13758

I'm not aware of any other, sorry. If I find something else, I'll let you know.

iReport Ultimate Guide - is what you need for using the report designer, but it expects you to know how to compile reports and SQL

There is also an server guide available, TIBCO JasperReports Server Ultimate Guide.

Be ware they are a bit out of date, but still relevant.

We haven't tried the enterprise edition.

Regards,
Nuria



On 07/05/15 15:19, Luke Branch wrote:
<blockquote cite="mid:CAA0hvkKDppUrhoqgEazO8m84CrDqZSeu5fyrS8dt+PqRjTnbiA@mail.gmail.com" type="cite">
Hi Nuria,

The only bugs i've run into so far have been API related, and quite easy fixes. Is there any problems in particular that you've run into that you could elaborate on? I've been using it in production for awhile now, and I can't say i've had any real issues with it. 

I haven't tried Jasper Reports yet, although I have heard good things about it, do you have any links to documentation for Jasper Reports that you could share? I'm interested in comparing the two (Aeroo/Jasper) in terms of flexibility, functionality and ease of use, so that I can decide on which one i'd like to use in the long-term.

Regards,

Luke

On Thu, May 7, 2015 at 5:14 PM, Nuria Arranz Velazquez <nuria@opusvl.com> wrote:
Hi Daniel,

Aeroo is a bit of a problem, because you need to use a specific library version for it, which comes with bugs, and there is a false path in one of the files that points to the wrong library which will give you errors. DOCS connection will give you a handful of issues on dependencies too. And if you don't use the correct module for your Odoo instance, it will cause all sort of anomalies even after removing it (as it will linger in your local files).

If you are thinking of a report editor that doesn't crash your Odoo instance beyond repair, you might want to consider using a third party that connects to your Odoo database, like LibreOffice Base. It's simple, but it works. And with a bit of sql knowledge you'll be able to do quite a lot with it.

Or Jasper Reports is another option. One of my colleagues totally swears by it, although I've only seen it in action a couple of times. It looks quite complete.

Best of luck,
Nuria



On 06/05/15 18:47, Daniel Blanco wrote:
<blockquote cite="mid:CANZdyrkAA9aXV9wN8KG3b7+2ZpV_VJJvMHPzVZ+13KYg_3KfQQ@mail.gmail.com" type="cite">
Is there any good documentation about Aeroo in any place? Everything I've found in forums, google groups, Alistek's website and youtube is very old, and with use examples about desktop version.

Perhaps the odt / ods creation procedure is the same, but there are a lot of new options in the config menu, without help or doc that I can refer.

Thanks


<img moz-do-not-send="true" src="imap://nuria@mail.opusvl.com:143/fetch%3EUID%3E.Drafts%3E1282?entryPoint=image&amp;name=92170875-3bb9-ac6c-7e55-5522a3d1e64f">

Ing. Daniel Blanco
Director
Blanco Martín & Asociados
Skype: hdanielb
Twitter: hdanielb

Chile: 
Blanco Martín EIRL
Apoquindo 6410 Of 212
Las Condes - Región Metropolitana

Argentina:
BMyA S.A.
Nicasio 6970. Córdoba
Argüello - Córdoba




_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



-- 
N. Arranz-Velazquez
OpusVL Odoo Specialist Team (OOST)

OpusVL
Drury House
Drury Lane
Rugby
CV21 3DE

T: 01788 298 450
W: www.opusvl.com

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



-- 
N. Arranz-Velazquez
OpusVL Odoo Specialist Team (OOST)

OpusVL
Drury House
Drury Lane
Rugby
CV21 3DE

T: 01788 298 450
W: www.opusvl.com

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



-- 
N. Arranz-Velazquez
OpusVL Odoo Specialist Team (OOST)

OpusVL
Drury House
Drury Lane
Rugby
CV21 3DE

T: 01788 298 450
W: www.opusvl.com

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
The Splendid journey of 2 years in Numbers
---
Regards,
Jay Vora,
Managing Director,
<img src="cid:part1.09000700.05080805@serpentcs.com" style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
Serpent Consulting Services Pvt. Ltd.
Web : http://www.serpentcs.com
Mobile : 91 - 9879354457
Twitter: jaynvora
Skype: jaynvora
Blog : http://jayvora.blogspot.com