Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
#5879
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?
#5880
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 🙏😁
#5881
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.

Our PDF Word Counter Tool is designed to make co[…]

Ensure that the SQL syntax is correct. The error m[…]

Discover Women Seeking Casual Encounters Tonight […]

Discover Women Looking for Spontaneous Nights Out[…]