cancel
Showing results for 
Search instead for 
Did you mean: 

Transform / Renderer of XLSX Files

marcog
Confirmed Champ
Confirmed Champ

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

3 REPLIES 3

abhinavmishra14
World-Class Innovator
World-Class Innovator

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/resourc... 

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

~Abhinav
(ACSCE, AWS SAA, Azure Admin)

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?

4535992
Star Collaborator
Star Collaborator

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...

Welcome to the new Hyland Connect. Get started or submit feedback.