Add ability to tweak automatch with some sort of 'rules configuration' (Bugzilla #1686)

[GoogleCodeExporter]

Original Description:
In the forum, JWiley asked if it is possible to tweak the automatch rules. 
The use case provided is if each record has a date associated with it, 
then JWiley would like to be able to tweak the automatch to favour records 
with a later date as the master.

See http://www.sqlpower.ca/forum/posts/list/1904.page#4057

Comment from Jonathan:
We should look at some MUA's (email client programs) to see if we like the 
way they do the user interface for mail filtering. This is a similar 
problem, so we should be able to put together a familiar interface if we 
do a survey of what's out there.

Original issue reported on code.google.com by mo.j...@gmail.com on 9 Sep 2009 at 7:15

[GoogleCodeExporter]

I have a similar use case: My records have a column containing the source 
system they are coming from. I would need to be able to select which source is 
my "master source". In addition it would be helpful if I could weight or order 
the different source systems (values in the column). This way I could create 
the following rules:
If matches from source A, source B, source C -> record from source A master
If matches from source B, source C -> record from source B master

Original comment by bdietz.de on 9 Jul 2010 at 1:42