I have a customer with over 157K files in the UploadFile table. For reasons they know, they upload a LOT of files. They also send thousands of invoices per month which creates PDF files as well.
They are running out of diskspace and they asked me for a way to purge files in masse.
I created a screen to do this. But, I see that system images are being listed in my grid. I have tried very hard to find a way to identify these image files as “system files” so they cannot be accidentally deleted.
For example:
I thought about restricting files created by admin, but that would mean they wouldn’t be able to purge attachments to emails from many years ago.
Further down in the grid shown above, there is a file that I think they should be able to delete without any issues being created other than losing history:
Strangely, the File Maintenance screen will let you delete these files. They look to me like files that are needed by the core Acumatica site. This is the “finger print” image.
I will restate that you CAN delete these system files using the File Maintenance screen. I’m surprised Acumatica will let a user do this.
I’ve dug through as many tables I can find and looked at the various fields in them to see if there is ANY way to restrict the files listing to exclude these files.
I was wondering if anyone knows of a way to determine files in the UploadFiles (and related) table are system files that should not be deleted.