Reserved de-dupe rules
I'm wanting to refine the de-duping rules, but first of all I'd like to find out exactly what the predefined rules are before I create my own. They are reserved, so you can't edit them, which is fine, but it only tells you which fields they use and not what the weights and thresholds are so the full behaviour is not clear.
duplicate-contacts
asked 8 hours ago
Mick KahnMick Kahn
636216
add a comment |
I'm wanting to refine the de-duping rules, but first of all I'd like to find out exactly what the predefined rules are before I create my own. They are reserved, so you can't edit them, which is fine, but it only tells you which fields they use and not what the weights and thresholds are so the full behaviour is not clear.
duplicate-contacts
asked 8 hours ago
Mick KahnMick Kahn
636216
add a comment |
I'm wanting to refine the de-duping rules, but first of all I'd like to find out exactly what the predefined rules are before I create my own. They are reserved, so you can't edit them, which is fine, but it only tells you which fields they use and not what the weights and thresholds are so the full behaviour is not clear.
duplicate-contacts
asked 8 hours ago
Mick KahnMick Kahn
636216
I'm wanting to refine the de-duping rules, but first of all I'd like to find out exactly what the predefined rules are before I create my own. They are reserved, so you can't edit them, which is fine, but it only tells you which fields they use and not what the weights and thresholds are so the full behaviour is not clear.
duplicate-contacts
duplicate-contacts
asked 8 hours ago
Mick KahnMick Kahn
636216
asked 8 hours ago
Mick KahnMick Kahn
636216
asked 8 hours ago
Mick KahnMick Kahn
636216
asked 8 hours ago
Mick KahnMick Kahn
636216
asked 8 hours ago
Mick KahnMick Kahn
636216
636216
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If you have access to the database type
SELECT * from civicrm_dedupe_rule r inner join civicrm_dedupe_rule_group rg on rg.id = r.dedupe_rule_group_id;
which will give you a table which isn't pretty but is mostly understandable.
answered 8 hours ago
DemeritDemerit
4,0462621
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
add a comment |
Using Demerit's correct and useful answer above, here are the details in plain text of the three pre-configured rules that you can't see by the normal method, so may be of use to others:
Name and Email (reserved): Supervised: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 7
Email: Length "null", Weight 10
Threshold 20
Email (reserved): Unsupervised: Individual
Email: Length "null", Weight 10
Threshold 20
Name and Address (reserved): General: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 5
Street Address: Length "null", Weight 5
Middle Name: Length "null", Weight 1
Suffix: Length "null", Weight 1
Threshold: 15
answered 5 hours ago
Mick KahnMick Kahn
636216
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "605"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f29155%2freserved-de-dupe-rules%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you have access to the database type
SELECT * from civicrm_dedupe_rule r inner join civicrm_dedupe_rule_group rg on rg.id = r.dedupe_rule_group_id;
which will give you a table which isn't pretty but is mostly understandable.
answered 8 hours ago
DemeritDemerit
4,0462621
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
add a comment |
If you have access to the database type
SELECT * from civicrm_dedupe_rule r inner join civicrm_dedupe_rule_group rg on rg.id = r.dedupe_rule_group_id;
which will give you a table which isn't pretty but is mostly understandable.
answered 8 hours ago
DemeritDemerit
4,0462621
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
add a comment |
If you have access to the database type
SELECT * from civicrm_dedupe_rule r inner join civicrm_dedupe_rule_group rg on rg.id = r.dedupe_rule_group_id;
which will give you a table which isn't pretty but is mostly understandable.
answered 8 hours ago
DemeritDemerit
4,0462621
If you have access to the database type
SELECT * from civicrm_dedupe_rule r inner join civicrm_dedupe_rule_group rg on rg.id = r.dedupe_rule_group_id;
which will give you a table which isn't pretty but is mostly understandable.
answered 8 hours ago
DemeritDemerit
4,0462621
edited 7 hours ago
answered 8 hours ago
DemeritDemerit
4,0462621
answered 8 hours ago
DemeritDemerit
4,0462621
answered 8 hours ago
DemeritDemerit
4,0462621
4,0462621
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
add a comment |
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Ah you're right. I'll update answer.
– Demerit
7 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
Thanks that tells me what I need, so I have deleted my earlier comment on your previous version of the answer
– Mick Kahn
5 hours ago
add a comment |
Using Demerit's correct and useful answer above, here are the details in plain text of the three pre-configured rules that you can't see by the normal method, so may be of use to others:
Name and Email (reserved): Supervised: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 7
Email: Length "null", Weight 10
Threshold 20
Email (reserved): Unsupervised: Individual
Email: Length "null", Weight 10
Threshold 20
Name and Address (reserved): General: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 5
Street Address: Length "null", Weight 5
Middle Name: Length "null", Weight 1
Suffix: Length "null", Weight 1
Threshold: 15
answered 5 hours ago
Mick KahnMick Kahn
636216
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
add a comment |
Using Demerit's correct and useful answer above, here are the details in plain text of the three pre-configured rules that you can't see by the normal method, so may be of use to others:
Name and Email (reserved): Supervised: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 7
Email: Length "null", Weight 10
Threshold 20
Email (reserved): Unsupervised: Individual
Email: Length "null", Weight 10
Threshold 20
Name and Address (reserved): General: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 5
Street Address: Length "null", Weight 5
Middle Name: Length "null", Weight 1
Suffix: Length "null", Weight 1
Threshold: 15
answered 5 hours ago
Mick KahnMick Kahn
636216
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
add a comment |
Using Demerit's correct and useful answer above, here are the details in plain text of the three pre-configured rules that you can't see by the normal method, so may be of use to others:
Name and Email (reserved): Supervised: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 7
Email: Length "null", Weight 10
Threshold 20
Email (reserved): Unsupervised: Individual
Email: Length "null", Weight 10
Threshold 20
Name and Address (reserved): General: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 5
Street Address: Length "null", Weight 5
Middle Name: Length "null", Weight 1
Suffix: Length "null", Weight 1
Threshold: 15
answered 5 hours ago
Mick KahnMick Kahn
636216
Using Demerit's correct and useful answer above, here are the details in plain text of the three pre-configured rules that you can't see by the normal method, so may be of use to others:
Name and Email (reserved): Supervised: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 7
Email: Length "null", Weight 10
Threshold 20
Email (reserved): Unsupervised: Individual
Email: Length "null", Weight 10
Threshold 20
Name and Address (reserved): General: Individual
First Name: Length "null", Weight 5
Last Name: Length "null", Weight 5
Street Address: Length "null", Weight 5
Middle Name: Length "null", Weight 1
Suffix: Length "null", Weight 1
Threshold: 15
answered 5 hours ago
Mick KahnMick Kahn
636216
answered 5 hours ago
Mick KahnMick Kahn
636216
answered 5 hours ago
Mick KahnMick Kahn
636216
answered 5 hours ago
Mick KahnMick Kahn
636216
636216
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
add a comment |
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
Not blaming you at all but some of those look a bit nuts. Is it possible you mis-copied the Email Unsupervised? Having Email = 10 and Threshold = 20 does not seem healthy. I do not see that on a site i just checked. The Threshold was set to 10.
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
For the Name and Address (which I do see the same on a db i just checked) have Middle Name = 1 and Suffix = 1 for a Threshold of 15 seems pointless as they will never play a role in determining someone is a match will they?
– petednz - fuzion♦
3 hours ago
add a comment |
Thanks for contributing an answer to CiviCRM Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f29155%2freserved-de-dupe-rules%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
