topic Re: libreoffice not working properly in Alfresco Archive

libreoffice not working properly

framtk — Fri, 09 Dec 2016 15:46:48 GMT

Hi,I installed Alfresco on windows with the installer and disabled libreoffice. I tried to install it later as described in the documentation here Installing LibreOffice | Alfresco Documentation and there are some problems.I can see the preview of txt files just fine but when i try to see the previe

Re: libreoffice not working properly

afaust — Mon, 12 Dec 2016 08:53:54 GMT

Unfortunately it is difficult to help from this information. Have you tried running conversions on the affected documents from the command line yourself? Depending on the way you have installed LibreOffice there may be some components missing, e.g. a customer of mine once installed it from the repository specific to his Linux distribution and simply forgot to install one of the dozen software packages that compose LibreOffice.

If you are using Alfresco Enterprise Edition you can install the Alfresco Support Tools addon to test transformations via the admin console. If you run Alfresco Community Edition you can build and install the Community Support Tools addon for the same feature.

Re: libreoffice not working properly

framtk — Mon, 12 Dec 2016 13:15:49 GMT

I hve an even stranger problem now, friday on my test machine (with libreoffice installed with the alfresco installer) i could see docx previews correctly while today i can only see the first page of the pdf and no lateral scroll bar or page selector on top is shown

EDIT:

restarting the tomcat server fixed this last problem, strange (it was running for less than an hour)

Re: libreoffice not working properly

afaust — Mon, 12 Dec 2016 13:17:52 GMT

This is just the fallback to a different kind of preview when the PDF preview is not available. The docx file contains a thumbnail of the first page and this is displayed as a static preview in this case.

Re: libreoffice not working properly

framtk — Mon, 12 Dec 2016 13:22:53 GMT

Oh ok, i wasn't aware of that functionality, as of today on the machine that i tried installing libreoffice on later i can see only some of the previews for the same MIME type (can see preview of document x.docx but not y.docx), also on my test machine i have a button "Edit in Microsoft Office" in the preview page while on the other i don't have it even when the preview is shown. Any idea what might cause this? Later today i'll try to install libreoffice again checking all the dependencies necessary and if i'm missing any

Re: libreoffice not working properly

afaust — Mon, 12 Dec 2016 13:29:30 GMT

"Edit in Microsoft Office" is unrelated to the preview and dependant on the mimetype, location (within a site), browser and presence of an addon module in Alfresco. If e.g. the mimetype is not correctly associated with a document the action may not be shown, and an incorrect mimetype may also result in a preview not to be shown. The name of the file is only an indicator of the mimetype, used by Alfresco to gues the mimetype during upload but it can be overriden by a careless user.

Re: libreoffice not working properly

framtk — Mon, 12 Dec 2016 14:05:07 GMT

So, let me understand this. To get the MIME type Alfresco takes the extension after the last "."? I'm not really sure i understood the ocation bit, if it's in a site or in the repository might not make the edit button show?

Re: libreoffice not working properly

afaust — Mon, 12 Dec 2016 14:25:42 GMT

I believe my response explained how the "Edit in Microsoft Office" action is dependant on the location. This statement did and does not apply to the preview.

Re: libreoffice not working properly

framtk — Mon, 12 Dec 2016 15:14:25 GMT

sorry it was a typo on my end.

Is it possible that the preview will not show if the MIME type is not recognized/wrong? Since i can't see the edit in office button that might be the root of the problem

Re: libreoffice not working properly

afaust — Mon, 12 Dec 2016 15:17:52 GMT

I believe I also mentioned that in my response. Previews are always using the mimetype to determine how they can be generated and if they are supported at all, so an incorrectly determined mimetype may result in a failure to show a preview.

Re: libreoffice not working properly

framtk — Mon, 12 Dec 2016 15:45:16 GMT

I think i found the problem, i tried to rename one of the files that didn't open to "test" and now the preview shows. I guess it was the name of the file/path that was too long, do you know if there is a way to avoid this problem without having to rename the files?

Re: libreoffice not working properly

afaust — Mon, 12 Dec 2016 15:58:27 GMT

If you are running Alfresco on Windows then there is a path length limit that may prevent previews from being generated. This is a known issue.

Re: libreoffice not working properly

framtk — Thu, 15 Dec 2016 13:44:18 GMT

I guess that was the problem, thanks

Re: libreoffice not working properly

douglascrp — Mon, 19 Dec 2016 18:42:35 GMT

Adding to your answer, there is a public fix for this at GitHub - keensoft/oo-temp-filename-shortener: Alfresco Open Office temp filename shortener