Im looking for someone smart that can help create a script to delete 0kb files , files created by excel when opening any excel file let me explain.
every time you open a excel file it creates a temporary ghost file called Auto recovery , the problem on drive is that people that don't have DELETE access each time they view a excel sheet or edit the temporary white 0kb auto recovery file stays there, now for the regular user this is prob not an issue, it can be resolved in excel by disabling this feature, but for me with over 90 users and thousands of directories and files it's not an option.
synology engineer replied :
this problem happens only on users who have no delete permissions. This is expected, the temporary file will be deleted on the client-side only but it remains on the server-side due to no delete permissions.
This temporary file has no filename extension thus there is no way to set up a filter not to sync this kind of temporary file.
In this case, you really need to delete them one by one. Or you may consider writing a script and setting up a Scheduled Task to move these 0-byte files to a specific folder. You could check files under this folder to make sure all files are expected then remove them manually.
Im not sure how to do a Script to delete these 0kb files but sometimes they are 1mb
here are some example of the files. users who edited these excel files but the auto recovery stayed.
anyone have an idea?
every time you open a excel file it creates a temporary ghost file called Auto recovery , the problem on drive is that people that don't have DELETE access each time they view a excel sheet or edit the temporary white 0kb auto recovery file stays there, now for the regular user this is prob not an issue, it can be resolved in excel by disabling this feature, but for me with over 90 users and thousands of directories and files it's not an option.
synology engineer replied :
this problem happens only on users who have no delete permissions. This is expected, the temporary file will be deleted on the client-side only but it remains on the server-side due to no delete permissions.
This temporary file has no filename extension thus there is no way to set up a filter not to sync this kind of temporary file.
In this case, you really need to delete them one by one. Or you may consider writing a script and setting up a Scheduled Task to move these 0-byte files to a specific folder. You could check files under this folder to make sure all files are expected then remove them manually.
Im not sure how to do a Script to delete these 0kb files but sometimes they are 1mb
here are some example of the files. users who edited these excel files but the auto recovery stayed.
anyone have an idea?