opencats.org

What is the best way to delete all candidate uploads that are older than 5 years?

Thank you so much!

Can anyone assist me? Much appreciated?

I can't!!!

Hi RedCat,

do you mean to delete any candidate that's over five years old?

Best to run a sql query to identify anyone that matches, and then again after you're sure to delete those candidates. There's currently no option in the UI to search and bulk delete.

if you only want bulk uploads over five years deleted, what identifies a bulk upload as opposed ot a manually created one? is there something you can search for?

Finally - are you sure you want to delete them, or would you rather just mark them as inactive?

Hi Russ,

Thank you so much for your reply.
Due to the enormous size of my OpenCats database I need to delete attachments on candidates profiles (not the entire candidate profile), only the attachments (cvs, etc) they have been uploaded by ourselves or when job seekers register with us via OpenCats.

So I’m wanting to save only candidates details and delete attached that are older than, for example, 5 years. Bearing in mind I’ve been using my OpenCats database for 10yrs+ now.

Thank you so much. I look forward to your response

okay - strange as disk is cheap! However if you want to retain the database entry and just delete the files, probably simplest (assuming you're on linux) just to search the upload directory for files with a modification time older than five years;

find . -type f -mtime +1825

and then if you're happy with the result, rerun it with the delete flag;

find . -type f -mtime +1825 -delete

of course, please check the results first!

If you're on windows, I assume you can run a similar search using advanced search.