topic Re: Transform / Renderer of XLSX Files in Alfresco Forum

Transform / Renderer of XLSX Files

marcog — Wed, 26 Jul 2023 13:19:28 GMT

Good morning.

I have a docker-based installation of Alfresco Community 7.1 and a load balancer with 4 Transform containers (using a proxy to balance between the 4 containers).

And every time I upload an Excel spreadsheet, it takes time to generate the thumbnail and also the preview of the document in Alfresco Share.
This time can take from 5 to 10 minutes, and I've had up to 30 minutes of time, causing Alfresco to overload and stop.

My server has 64 Gb Ram and 16 Cores.

I configured alfresco-global.properties not to generate thumbnails for all the files and I was testing settings so as not to generate previews of the xlsx files (for example) but it didn't work.

After applying these configurations to alfresco-global.properties, is there any further procedure to do?

What can I do to not generate a thumbnail of .xlsx files and not generate the rendition of these files, as well as the non-preview of these files too?

Thanks

Re: Transform / Renderer of XLSX Files

abhinavmishra14 — Wed, 26 Jul 2023 22:19:55 GMT

This should not take the amount of time you have mentioned. With pretty much ootb settings itself i tested a 10 mb xls file and it got the thumbnail within fe seconds. System config is 4 CPU and 16G RAM.

Here is a sample project that i tested with: https://github.com/abhinavmishra14/acs-community-71-docker/blob/main/docker-compose.yml

Now to disable the thumbnail generation globally set the following property in alfresco-global.properties:

system.thumbnail.generate=false

I am not sure what properties you were setting. but with 7.1 there is no legacy transformer. So all these settings has to be done in repective transform engine. e.g. for docx, xlsx, etc it would be lifreoffice.

To disable you need to update this config and build the container with updated config: https://github.com/Alfresco/alfresco-transform-core/blob/master/engines/libreoffice/src/main/resources/libreoffice_engine_config.json

You mentioned proxy in between transform service, check if there is any bottleneck between alfresco -> activemq -> transform service containers.

Re: Transform / Renderer of XLSX Files

marcog — Thu, 27 Jul 2023 20:41:56 GMT

Hello thanks for the information.

But as for Thumbnail, I already managed to define a configuration that does not create thumbnail for .xlsx files.

How do I make it not display in preview (when I select the document)?

Do you have any help on this?

Re: Transform / Renderer of XLSX Files

AlfrescoZZZ — Mon, 31 Jul 2023 11:21:53 GMT

If you want to disable the xlsx transformer on Alfresco (Rest API ecc.), you must modify the json transformer configuration file of Alfresco, here a very good demo project about it : https://github.com/aborroy/alfresco-transform-service-3.0.0

If you want just disable on Alfresco Share you can use the same methos exaplined here : https://hub.alfresco.com/t5/alfresco-content-services-forum/disable-xlsx-preview-on-alfresco-share/m-p/316872/highlight/true#M29219