Loading...
 
Features / Usability

Features / Usability


[SOLVED] How to find big size files in file galleries ?

posts: 8633 Israel

Hello,

On a Tiki25, when I look at the file directory on the server I see very big files that were uploaded without being optimized for the web.

Their filename look like this : "23be060a82dc8d1fb6268c3b91exxxx"

I need to find them on the file galleries to see what it is and replace the original file with an optimized version of the same file.

But I can't match the filename and the files on the file galleries side.
With 7900 files placed in hundreds of sub-galleries, sorting by size to see the big files is really not a pleasant option.

Any idea on how to find/filter those files ?

posts: 126886 United Kingdom

Hi @Bernard Sfez / Tiki Specialist

You could do it in the database i think, the file size is recorded in there, so something like this should work:

Copy to clipboard
SELECT `fileId`, `galleryId`, `name`, `filename`, `filesize`, `filetype`, `user` FROM `tiki_files` ORDER BY `filesize` DESC LIMIT 0,1000;


Any help?

posts: 126886 United Kingdom

Alternatively (of course) you could try something based on this:

Copy to clipboard
{LIST()} {filter type="file"} {sort mode="filesize_ndesc"} {LIST}
posts: 8633 Israel
Jonny Bradley wrote:

Alternatively (of course) you could try something based on this:

Copy to clipboard
{LIST()} {filter type="file"} {sort mode="filesize_ndesc"} {LIST}


/me Stupiiiddd.... 🤣

Of course you are right !
I can even quickly setup a custom a template to link the object to the file page.

Thank you Jonny


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting