Hi all!! I've just made the first filtering script to translate SQL filters to System filters. It takes user parameter (something like 'rcdev@cio.cat') and the system filtering type. At the moment, allowed types are 'procmail' (default) and 'exim'. If you call it without params, it will ask for IMAP user and translate filters to procmail format. Translated filters are printed to stdout. The 'help' param prints out help.

I repeat: this is a very earlier version. You can only match a containing string on some message's part, not regexps. You can only move messages to another mailbox, not forwarding neither anytihng else.

Now I will concentrate on Sieve. If anyone knows other significant mail filtering systems, tell me and, if possible, some syntax specification webpage.

After doing firsts versions of more significant mail filtering systems, I will improve a better UI to allow advanced matching systems, probably adding another table to roundcube DB and altering the 'filters' existing one.

Please, comment out when (in which step) do you think it will be applicable to svn version (upload work).

Attached to this message, I send the script and the output from running the script with my user rcdev, one with procmail type and the other with exim's. Bugs and comments are welcome.

Thanks to everybody!!

PD: I've seen several connections from you to my server. Anyone wants to comment anything to filters UI? And is there someone who can tell me how to use drag'n'drop lists (to change filters order)?

emi

--- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/KV/gEbX/jku/sql2filter.php http://detached.gigo.com/rc/KV/gEbX/jku/rcdev_exim.txt http://detached.gigo.com/rc/KV/gEbX/jku/rcdev_procmail.txt Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< ---

List info: http://lists.roundcube.net/dev/