Reserved de-dupe rulesAdding 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

Where does SFDX store details about scratch orgs?

What's the point of deactivating Num Lock on login screens?

Is there a hemisphere-neutral way of specifying a season?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

Is it canonical bit space?

How to say in German "enjoying home comforts"

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

Took a trip to a parallel universe, need help deciphering

How do conventional missiles fly?

I Accidentally Deleted a Stock Terminal Theme

Can I use a neutral wire from another outlet to repair a broken neutral?

What mechanic is there to disable a threat instead of killing it?

Stopping power of mountain vs road bike

Alternative to sending password over mail?

Can a virus destroy the BIOS of a modern computer?

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

Anagram holiday

What killed these X2 caps?

How can I tell someone that I want to be his or her friend?

Why is Collection not simply treated as Collection<?>

Is Lorentz symmetry broken if SUSY is broken?

What is going on with Captain Marvel's blood colour?

How to take photos in burst mode, without vibration?



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













2















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.










share|improve this question


























    2















    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.










    share|improve this question
























      2












      2








      2


      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.










      share|improve this question














      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













      share|improve this question











      share|improve this question




      share|improve this question










      asked 8 hours ago









      Mick KahnMick Kahn

      636216




      636216




















          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

























          • 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


















          2














          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























          • 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











          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


















          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









          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

























          • 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















          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

























          • 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













          2












          2








          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















          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














          share|improve this answer



          share|improve this answer








          edited 7 hours ago

























          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

















          • 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











          2














          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























          • 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















          2














          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























          • 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













          2












          2








          2







          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













          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












          share|improve this answer



          share|improve this answer










          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

















          • 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

















          draft saved

          draft discarded
















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          Disable / Remove link to Product Items in Cart Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?How can I limit products that can be bought / added to cart?Remove item from cartHide “Add to Cart” button if specific products are already in cart“Prettifying” the custom options in cart pageCreate link in cart sidebar to view all added items After limit reachedLink products together in checkout/cartHow to Get product from cart and add it againHide action-edit on cart page if simple productRemoving Cart items - ObserverRemove wishlist items when added to cart

          Helsingin valtaus Sisällysluettelo Taustaa | Yleistä sotatoimista | Osapuolet | Taistelut Helsingin ympäristössä | Punaisten antautumissuunnitelma | Taistelujen kulku Helsingissä | Valtauksen jälkeen | Tappiot | Muistaminen | Kirjallisuutta | Lähteet | Aiheesta muualla | NavigointivalikkoTeoksen verkkoversioTeoksen verkkoversioGoogle BooksSisällissota Helsingissä päättyi tasan 95 vuotta sittenSaksalaisten ylivoima jyräsi punaisen HelsinginSuomalaiset kuvaavat sotien jälkiä kaupungeissa – katso kuvat ja tarinat tutuilta kulmiltaHelsingin valtaus 90 vuotta sittenSaksalaiset valtasivat HelsinginHyökkäys HelsinkiinHelsingin valtaus 12.–13.4. 1918Saksalaiset käyttivät ihmiskilpiä Helsingin valtauksessa 1918Teoksen verkkoversioTeoksen verkkoversioSaksalaiset hyökkäävät Etelä-SuomeenTaistelut LeppävaarassaSotilaat ja taistelutLeppävaara 1918 huhtikuussa. KapinatarinaHelsingin taistelut 1918Saksalaisten voitonparaati HelsingissäHelsingin valtausta juhlittiinSaksalaisten Helsinki vuonna 1918Helsingin taistelussa kaatuneet valkokaartilaisetHelsinkiin haudatut taisteluissa kaatuneet punaiset12.4.1918 Helsingin valtauksessa saksalaiset apujoukot vapauttavat kaupunginVapaussodan muistomerkkejä Helsingissä ja pääkaupunkiseudullaCrescendo / Vuoden 1918 Kansalaissodan uhrien muistomerkkim

          Adjektiivitarina Tarinan tekeminen | Esimerkki: ennen | Esimerkki: jälkeen | Navigointivalikko