bsecure
Posts: 4
Joined: 28.Mar.2007
Status: offline
|
Worked out how to do this, you will need MS Access and MS Excel. I have imported words into a new Content Filtering rule into a fresh install of GFi MailSecurity.
Disclaimer part, I have not had any technical assistance from GFi. So if you do make modifications, and it breaks, don't expect any support!
I would definitely make sure you have a full backup of the server, take the server offline when do this and make sure you take a file copy of the avapicfg.mdb database.
STEP 1
Create a new Content Filtering rule using the GFi MailSecurity Web interface. (You do not to need to create a rule, if you want to append to existing rules, open the table below to find the Parent_id).
Make sure you add a word to the body & the subject.
Close the Web page.
STEP 2
Open X:\Program files\GFI\ContentSecurity\MailSecurity\Data\avapicfg.mdb in MS Access.
Locate and open the table Tb_contcheck_body_list, scroll to the bottom, you will see your entry. Copy the Parent_id, looks something like {4f34tf3t-34ffgsfg-werwer-543453} adjacent to the the newest entry.
STEP 3
Open MS Excel.
Create a table as below, without the headings. The ID will be overwritten when you import (I used concurrent numbers), with out this column the import will mess up. Parent_id is copied from the table above. Phrase is the word / phrase that you want to add to the rule. Rule ID is an incremental number the first word starts with 0 - already in the table.
ID Parent_id phrase Rule ID
44 {4f34tf3t - Parent ID -543453} word1 1
45 {4f34tf3t - Parent ID -543453} word2 2
46 {4f34tf3t - Parent ID -543453} word3 3
47 {4f34tf3t - Parent ID -543453} word4 4
STEP 4
Select and copy the whole table (without the headings), go back to the open Tb_contcheck_body_list in MS Excel and choose Edit \ Paste Append. A prompt will appear to confirm to paste the records.
Check the words have been imported, you can delete the records if necessary.
Save and close the table.
Re-open MailSecurity and go to the rule you created earlier, click on the body tab and all the phrases should be present.
If you want to populate the subject, repeat the process but edit the Tb_contcheck_subject_list table. There is a slight proviso, this table does not have the fourth column (Rule ID).
Send test e-mails.
Good luck!
< Message edited by bsecure -- 8.Dec.2009 9:04:29 AM >
|
Printable Version
Content Filtering Import - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread