Rules disappear over weekend

hcl-bot · February 28, 2005, 12:04pm

I have a problem mail db, it seems that every weekend, I lose my mail rules. No duplicate (rules) folders…

I create a new view showing docs with Form “Mail Rules” and no documents show. If I look at my calendar profile via Notespeek, I can still see the $FilterForumla_# fields…

Confused I am…

hcl-bot · March 1, 2005, 8:27am

Subject: Rules disappear over weekend

The rules are compile in the calendar profile.If the rule document where deleted from your Db, it’s normal to see them in your calendar profile.

To allow users to use Mail Rules:

Edit the Server document. The “allowed to use monitors” field should be set to * or should list the users allowed to use Mail Rules.

Dans le carnet CSST, cette valeur est déjà présente.

NOTE: Mail Rules have nothing whatsoever to do with Agents. Users do not need the ability to run agents on the server to use Mail Rules.

Mail Router

Just before a new email is saved in the mail database, the Router task on the server looks at the CalendarProfile document stored in that database. This

special document has hidden fields called $FilterFormula_xx.

Note that the individual “Mailrule” documents are not used by the Mail Router. Only the CalendarProfile is used. It’s therefore possible that the CalendarProfile document may not reflect the individual Mailrule documents found in the database. For example, if you paste a Mailrule document in to the database, the CalendarProfile document is not updated, and the Mailrule document has no effect.

Mailrule documents

Each user’s mail database contains a Folder called Rules. This will usually only contain documents created with the form “Mailrule”. Keep in mind that this is a Folder and not a View. (Iris should change this to a View.) If there are other documents in this Folder, then the CalendarProfile may get an invalid $FilterFormula.

The Mailrule form calculates two hidden fields that are stored on all Mailrule documents: $FilterFormula and OrderNum. When the user clicks the Enable/Disable Rule(s) buttons, the CalendarProfile document is updated. Each Mailrule document is identified on the CalendarProfile as $FilterFormula_OrderNum.

If the user did a copy&paste of an existing Mailrule document, then there will be two Mailrule documents with the same value for the OrderNum field. When the CalendarProfile is updated, each Mailrule document will try to store their information in the same $FilterFormula_OrderNum field. One Mailrule document is therefore not added to the CalendarProfile. To correct this problem, use the MoveUp and MoveDown buttons (this changes the OrderNum field). This will ensure that all Mailrule documents have a unique OrderNum field.

If you’re having trouble with Mailrules that are not working, or deleted Mailrules that are still being evaluated by the Mail Router, then remember:

The Mail Router looks at the CalendarProfile document only.
To recompute the CalendarProfile’s $FilterFormula_xx fields, select all Mailrule documents in the folder and click the Disable Rule(s) button, then select all Mailrule documents again and click the Enable Rule(s) button. It’s a good idea to use the MoveUp MoveDown buttons to make sure each Mailrule document has a unique OrderNum value.

Mailrules that MoveToFolder or CopyToFolder, store that folder’s UNID as part of the $FilterFormula. You should therefore never paste a Mailrule from one database to another.

if you delete a Rule document in the mail file, before disabling it, the calendar profile still has the field that stores the compiled version of that Rule, so it still runs

To solve this problem, you can use this button:à

Sub Click(Source As Button)

Dim session As New NotesSession

Dim db As NotesDatabase

Dim workspace As New NotesUIWorkspace

Dim folder As NotesView



Set db = session.currentdatabase	

Set folder = db.GetView("(Rules)")



  'Trouver le document  "(Calendar profile)" dans la base

Dim calendarProfile As NotesDocument

Set calendarProfile = db.GetProfileDocument( "CalendarProfile" )



   'LEs règles sont conpilés dans un champs nommé $FilterFormula_xx   xx représente un OrderNum

   'On retire les champs du "(Calendar profile)"

Forall item In calendarProfile.Items

	If( Lcase$(Left$(item.Name,15)) = "$filterformula_" ) Then

		Print "Cleanup " & item.Name

		Call item.Remove

	End If

End Forall



'Enregistrer les changements du "(Calendar profile)"

Call calendarProfile.Save( False, False )



'Désactiver toutes les règles visibles ou non.

Dim mailrule As NotesDocument

Set mailrule = folder.GetFirstDocument

While Not( mailrule Is Nothing )

	Call mailrule.ReplaceItemValue( "Enable","0" )

	Call mailrule.Save( True,False,True )

	

	Set mailrule = folder.GetNextDocument( mailrule )

Wend



 'Ouvrir le dossier Règles poru que l'usager réactive seulement celle qui sont nécessaires

Call workspace.OpenDatabase( db.Server, db.FilePath, "(Rules)" )



Messagebox "Mise-à-jour terminée, veuillez réactiver les règles s'il y a lieu."

End Sub

JYR

hcl-bot · March 3, 2005, 11:47am

Subject: RE: Rules disappear over weekend

Thanks for the response, but there is something well beyond the ordinary going on here. I have a hunch that it may be the Mail Rules this user creates are being eaten up by the SoftDelete process.

Looked at the mail file in question again yesterday and rules created Monday morning were gone from the Rules folder, creating a view to show all docs with Form=“MailRule” shows no rules in database.