Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - SFE wish list
  FAQ FAQ  Forum Search   Register Register  Login Login

SFE wish list

 Post Reply Post Reply
Author
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post Topic: SFE wish list
    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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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 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

LogSat Software

Spam Filter ISP
Back to Top
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.