Gsyfuy

Why does Optional.map make this assignment work?

Do I have a twin with permutated remainders?

Why does Kotter return in Welcome Back Kotter

I would say: "You are another teacher", but she is a woman and I am a man

How much of data wrangling is a data scientist's job?

Stopping power of mountain vs road bike

Does casting Light, or a similar spell, have any effect when the caster is swallowed by a monster?

What's the difference between 'rename' and 'mv'?

Is it possible to download Internet Explorer on my Mac running OS X El Capitan?

Is it canonical bit space?

Reserved de-dupe rules

Forgetting the musical notes while performing in concert

Is it unprofessional to ask if a job posting on GlassDoor is real?

Emailing HOD to enhance faculty application

Etiquette around loan refinance - decision is going to cost first broker a lot of money

Does a druid starting with a bow start with no arrows?

What to put in ESTA if staying in US for a few days before going on to Canada

Increase size of symbol intercal when in superscript position

Assassin's bullet with mercury

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

I Accidentally Deleted a Stock Terminal Theme

Anagram holiday

Did Shadowfax go to Valinor?

How can I make my BBEG immortal short of making them a Lich or Vampire?

Reserved de-dupe rules

Adding value conditions to dedupe rulesCreate new contacts every time someone makes a contribution ( with duplicate emails )Deduping organizationsWhat are the Attributes for the Reserved DeDupe RulesContact Dedupe BasicsCivi duplicate rules with respect to email & primary versus location typeEmployer on Profile - MismatchingDedupe Rules to import contacts without email addresses *UPDATE*Import Contacts with dedupe rulesUnsupervised reserved rule for individuals not working

1

1

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

share|improve this question

asked 4 hours ago

Mick KahnMick Kahn

621216

add a comment | 

1

1

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

share|improve this question

asked 4 hours ago

Mick KahnMick Kahn

621216

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

share|improve this question

asked 4 hours ago

Mick KahnMick Kahn

621216

share|improve this question

asked 4 hours ago

Mick KahnMick Kahn

621216

share|improve this question

asked 4 hours ago

Mick KahnMick Kahn

621216

asked 4 hours ago

Mick KahnMick Kahn

621216

asked 4 hours ago

Mick KahnMick Kahn

621216

2 Answers
2

active

oldest

votes

2

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.

share|improve this answer

edited 3 hours ago

answered 3 hours ago

DemeritDemerit

4,0462621

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Ah you're right. I'll update answer.
  
  – Demerit
  3 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
  1 hour ago
  

  
  
  
  

add a comment | 

1

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

share|improve this answer

answered 1 hour ago

Mick KahnMick Kahn

621216

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
});


}
});

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

2

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.

share|improve this answer

edited 3 hours ago

answered 3 hours ago

DemeritDemerit

4,0462621

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Ah you're right. I'll update answer.
  
  – Demerit
  3 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
  1 hour ago
  

  
  
  
  

add a comment | 

2

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.

share|improve this answer

edited 3 hours ago

answered 3 hours ago

DemeritDemerit

4,0462621

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Ah you're right. I'll update answer.
  
  – Demerit
  3 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
  1 hour 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.

share|improve this answer

edited 3 hours ago

answered 3 hours ago

DemeritDemerit

4,0462621

share|improve this answer

edited 3 hours ago

answered 3 hours ago

DemeritDemerit

4,0462621

answered 3 hours ago

DemeritDemerit

4,0462621

answered 3 hours ago

DemeritDemerit

4,0462621

1

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

share|improve this answer

answered 1 hour ago

Mick KahnMick Kahn

621216

add a comment | 

1

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

share|improve this answer

answered 1 hour ago

Mick KahnMick Kahn

621216

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

share|improve this answer

answered 1 hour ago

Mick KahnMick Kahn

621216

share|improve this answer

answered 1 hour ago

Mick KahnMick Kahn

621216

answered 1 hour ago

Mick KahnMick Kahn

621216

answered 1 hour ago

Mick KahnMick Kahn

621216