Automatic resize of uploaded images

We had the same problem with the images. Many images uploaded by the users are way too big and slow down the user interface. That is why we opted for a solution in SQL with an custom made assembly. There are other ways to resize the images, for example uploading to an API where the resized images are returned. We didn’t want to use such solution because you don’t know wat such party does with this data.

We created a class library in Visual Studio which resizes the images. The input is the original file data and width, the output is the reduced images data.  We loaded the ouput dll into sql and made a function. With the code below, we reduce the images with a width of 200

disadvantage is that this doesn't work in the cloud, you can't add an assemblies here.

It's not quite ready yet but maybe this will help you

declare @org_img nvarchar(max) =  (select base64Image from item cross apply (select image_blob_data '*' for xml path('')) T (base64Image) where item_id = @item_id)

declare @reduced_image varbinary(max) =   CAST(dbo.ClevrrResizeImage(@org_img, 200) AS xml).value('xs:base64Binary(.)', 'varbinary(max)')

update i set image_blob_data = @ reduced_image from item i where i.item_id = @item_id

Would be great to have this working for at least various Image extensions as well as for PDF.

If this could be specified with some optional settings per File Storage location, which are then interpreted by Indicium during File upload, we'd be very happy!

​@Arie V any update on this feature?

We have discussed this, implementation is not yet prioritized. I do want to highlight in which direction we're thinking and I am curious if this fits with the expectations of the voters.

We intent to implement this client-side, as the resizing uses a lot of memory and we don't want to risk overloading the server unexpectedly. This implies that the Universal GUI would take care of it, and resizing can't be used in Process Flows or API calls for example.

We consider to add a resize setting to the Domain for upload Controls, providing the flexibility to use Resizing for some, but not all upload Controls.

Would this work for the Use Cases you have in mind?

​@Arie V ,
Client side is fine by me. Hopefully this will be prioritized a bit higer. At this speed it will be a feature in the GUI when I am enjoying my retirement…