SFE wish list
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6007
Printed Date: 09 May 2025 at 1:04am
Topic: SFE wish list
Posted By: WebGuyz
Subject: SFE wish list
Date Posted: 21 March 2007 at 2:34pm
|
For the tblwl_autowhitelistforcedelivery table add a field called date and create a ini setting called expireautowhitelistentry=x where is x is settable. This way IF a date was entered in the date field and IF it was older then then the expireautowhitelistentry=x entry it would be deleted. I know a few users currently do something like that in SFI db to keep the autowhitelist from getting stale. We have a couple of pay day stores and they do business with a lot of users, but only once, so they might get tons of entries, but if we could expire stale addresses then it might help keep the list size manageable. Another wish would be some sql scripts to automate copying over default domain stuff to ALL our domains. Easy to do manually if you have just a few domains but it can take a while if you have hundreds to do. Also, SFE seems to be unresponsive while its copying all the info into the tables especially if you have hundreds of keywords entered over a long time. Would be better to do it offline of SFE via script. Lookin good! ------------- http://www.webguyz.net |
Replies:
Posted By: LogSat
Date Posted: 21 March 2007 at 11:17pm
|
We don't have plans for the "expiry" settings yet, but having the settings in the database should help admins to achieve more functionality. For example, in theory you could add another column to that table, and set its default value to the date of the new record being inserted. You could then add database jobs that would remove old records from the table, which would immediately be re-imported by SpamFilter. Just an idea for a workaround... For the copying of the values to the other domains, I'll referer you to the posting at http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6003#9890 - http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID= 6003#9890 as there may be some confusion about the default settings in SFE. Please let us know however if we misunderstood. For the unresponsive issue, we thought we had the export/import process separated into a different thread as to not incur in delays. Can you please let us know step-by-step how to reproduce the problem? ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: WebGuyz
Date Posted: 22 March 2007 at 12:34am
|
I believe the unresponsive issue was a result of telling SFE to not use defaults of ALL DOMAINS and doing a copy files from ALL DOMAINS. The darn autowhitelistdelivery table has over 34000 entires and of course it created 34000 more for the domain I was working with, this on a shared MS SQL server during the middle of the day with my production SFI's hammering away. So its not SFE's issue, but rather planning on my part. I realize I need to zero out the autowhitelistdelivery file and then write a script to go through line by line and add it with the correct domainid so that there is a total of 34000 lines only and whatever gets added in the future. Your right about adding the date field and creating a script to delete. After I wrote this post I realized that it was something I could easily do and should not have have been requested. Expect more floundering around as I get more familiar with SFE, but starting to see the potential and having everything SQL based makes automation easy. ------------- http://www.webguyz.net |