muk-it / muk_web

MuK Odoo Web Modules
GNU Lesser General Public License v3.0
110 stars 233 forks source link

Preview MS Office Module Issues - Odoo 10 #21

Closed DatenSAS closed 5 years ago

DatenSAS commented 6 years ago

I have installed this module in Odoo 10 and I get this issues:

PDF.js v1.7.225 (build: 17d135f) Mensaje: Unexpected server response (415) while retrieving PDF "http://34.220.243.124:8069/web/preview/converter/msoffice?url=http%3A%2F%2F34.220.243.124%3A8069%2Fweb%2Fcontent%3Fmodel%3Dmuk_dms.file%26filename%3DDIAZ%2BSALINAS_MAYO19%2B1%2B(1).doc%26filename_field%3Dname%26field%3Dcontent%26id%3D5%26download%3Dtrue".

I have tested unoconv command from console and PDF archives are generated for Excel without any problem, for Word I get a PDF file, but with this warnings:

W: Unknown node under /registry/extlang: deprecated W: Unknown node under /registry/grandfathered: comments W: Unknown node under /registry/grandfathered: comments

Finally for .ppt unoconv works fine (like Excel) but with .pptx generates an error and the PDF file is not generated.

:1: parser error : Document is empty PK ^ :1: parser error : Document is empty PK ^ :1: parser error : Document is empty PK ^ unoconv: UnoException during import phase: The document 'file:///home/ubuntu/SIG.pptx' could not be opened.

Versions

Name: pdfconv Version: 1.0.11 Summary: PDF Converter Home-page: https://github.com/keshrath/pdfconv Author: Mathias Markl Author-email: mathias.markl@mukit.at License: GPLv2 Location: /usr/local/lib/python2.7/dist-packages Requires:

Name: requests Version: 2.11.1 Summary: Python HTTP for Humans. Home-page: http://python-requests.org Author: Kenneth Reitz Author-email: me@kennethreitz.com License: Apache 2.0 Location: /usr/local/lib/python2.7/dist-packages Requires: Required-by: ebaysdk

Package: unoconv
State: installed Automatically installed: no Version: 0.7-1.1 Priority: extra Section: universe/text Maintainer: Ubuntu Developers ubuntu-devel-discuss@lists.ubuntu.com Architecture: all Uncompressed Size: 332 k Depends: python3, python3-uno (>= 4.0) Recommends: libreoffice-writer, libreoffice-draw, libreoffice-calc, libreoffice-impress Conflicts: odt2txt (<= 0.3-1) Description: converter between LibreOffice document formats This package provides a commandline utility which can convert from any document format that LibreOffice can import to any document format it can export. It uses LibreOffice's UNO bindings for non-interactive conversion of documents.

Supported document formats include Open Document format, MS Word, MS Office Open/MS OOXML, PDF, HTML, XHTML, RTF, DocBook, and more. Homepage: http://dag.wieers.com/home-made/unoconv/

Thanks.

Kerrim- commented 6 years ago

Hi,

Regarding the docx problem: these warnings can be ignored. Regarding pptx: can you try a different file because this sounds like the file is broken.

But i think the problem is that odoo doesnt have permission to write the file to disk with unoconv.

Can you try something like: sudo -u odoo unoconv ... And tell me what the output is?

DatenSAS commented 6 years ago

Hi Kerrim,

You were right about pptx file, I tried with another document and unoconv works fine.

With sudo -u odoo unoconv I have this output:

Failed to connect to /usr/lib/libreoffice/program/soffice.bin (pid=2336) in 6 seconds. Connector : couldn't connect to socket (Success) Error: Unable to connect or start own listener. Aborting.

How can I fix that?

Thanks

Kerrim- commented 6 years ago

Hi,

a possible explanation for this is that soffice needs more than 6 seconds to start (or at least it sounds that way). Can you try changing the unoconv timeout. If this works you will need to find out how to persist this setting.

sudo -u odoo --timeout=30 unoconv ...

keshrath commented 6 years ago

Maybe you will find some insights directly on unoconv site: https://github.com/dagwieers/unoconv/issues

DatenSAS commented 6 years ago

@Kerrim, with sudo -u odoo unoconv -T 30 file123.docx, I had the same error:

Failed to connect to /usr/lib/libreoffice/program/soffice.bin (pid=2764) in 30 seconds. Connector : couldn't connect to socket (Success) Error: Unable to connect or start own listener. Aborting.

@keshrath, I'm still searching in the issues, no luck so far ...

keshrath commented 6 years ago

Could you resolve your issue?

DatenSAS commented 6 years ago

Hi Mathias,

Not really. Actually I'm going to try a new Odoo installation from scratch to see what happen

2018-09-16 6:23 GMT-05:00 Mathias Markl notifications@github.com:

Could you resolve your issue?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/muk-it/muk_web/issues/21#issuecomment-421748493, or mute the thread https://github.com/notifications/unsubscribe-auth/AirsyYh2l_t8IL9n38M2Z6k9YoGXKzNoks5ubjSwgaJpZM4VzRQ4 .

-- Carlos Alberto Villarreal C. Director de Proyectos DATEN S.A.S. Calle 12 # 74 - 06, Cali - Colombia Celular:+ 57 3127575669

jorsea commented 6 years ago

Fix /muk_web_preview_msoffice/controllers/main.py
image

it's work.

minardo commented 5 years ago

Fix /muk_web_preview_msoffice/controllers/main.py image

it's work.

hi @jorsea thank for your solution, it's work for me in .doc and .docx format, but the error is in the .pptx format.

DatenSAS commented 5 years ago

Hi,

Now, I'm trying to install on Odoo.sh V10. Through a requirement.txt it was possible to install 'cachetools' but when I try to install 'pdfconv' I get an error.

El vie., 16 nov. 2018 a las 1:59, Muhamad Minardo (notifications@github.com) escribió:

Fix /muk_web_preview_msoffice/controllers/main.py [image: image] https://user-images.githubusercontent.com/9857984/47283648-bdfe8a00-d616-11e8-9806-1fd377236808.png

it's work.

hi @jorsea https://github.com/jorsea thank for your solution, it's work for me in .doc and .docx format, but the error is in the .pptx format.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/muk-it/muk_web/issues/21#issuecomment-439300684, or mute the thread https://github.com/notifications/unsubscribe-auth/AirsyR4VREsKkJLIW_2kleePd11mELEbks5uvmJNgaJpZM4VzRQ4 .

-- Carlos Alberto Villarreal C. Director de Proyectos DATEN S.A.S. Calle 12 # 74 - 06, Cali - Colombia Celular:+ 57 3127575669

keshrath commented 5 years ago

We don't maintain pdfconv anymore, but it should still be in PyPi. But you can't use this under Odoo.sh because you need unoconv and Odoo.sh doesn't allow apt installations as far as I know.