We use file name logging because on occasion I'm forced to go through the logs and report back to my supervisor any emails that I find to be misclassified. It's a huge waste of time I know - it is what it is.
Because of this need, we can't use move2num, so the collection quickly grows beyond the 25,000 in spam and notspam that we have set. I'm trying to come up with a way to automatically keep the number down. I'm interested in your feedback on what we've been doing with 1.4x and what I hope to use with 2.x very shortly: 1) I wrote a script to delete files older than x days in spam, notspam, and the 2 errors folders. I delete after 300 days in spam and notspam and 700 days in the 2 error folders. This just deletes really old messages. 2) I've written another script that run after the data delete script, that goes through the file listing alphabetically and deletes the third and subsequent files with the exact same file name (minus the numbers at the end). This removes a lot of the duplicates, and works fine with 1.4x, but will surely quickly break block reporting should a user request a file that's been deleted 3) After that, a 3rd script, takes a look at the total number of messages in each folder, if it's still over the maximum, then it'll delete that number that is over, selecting randomly. Again, with block reporting, this could be a problem. Any thoughts on this process, problems that it might cause, sugguestions to improve the concept, etc? I'd be more than happy to post the code if there's interest. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
