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

Is it possible to create light that imparts a greater proportion of its energy as momentum rather than heat?

How can saying a song's name be a copyright violation?

1960's book about a plague that kills all white people

Could gravitational lensing be used to protect a spaceship from a laser?

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

Why can't we play rap on piano?

Facing a paradox: Earnshaw's theorem in one dimension

Were any external disk drives stacked vertically?

Infinite Abelian subgroup of infinite non Abelian group example

I'm flying to France today and my passport expires in less than 2 months

Will google still index a page if I use a $_SESSION variable?

Do I have a twin with permutated remainders?

Alternative to sending password over mail?

Combinations of multiple lists

What does it mean to describe someone as a butt steak?

Is it canonical bit space?

Is the Joker left-handed?

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

Is it legal for company to use my work email to pretend I still work there?

Stopping power of mountain vs road bike

Why does Kotter return in Welcome Back Kotter

Can a virus destroy the BIOS of a modern computer?

In a Spin are Both Wings Stalled?

What is the word for reserving something for yourself before others do?



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 7 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
            6 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
            4 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
            2 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
            2 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
            6 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
            4 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
            6 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
            4 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 6 hours ago

























          answered 7 hours ago









          DemeritDemerit

          4,0462621




          4,0462621












          • Ah you're right. I'll update answer.

            – Demerit
            6 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
            4 hours ago

















          • Ah you're right. I'll update answer.

            – Demerit
            6 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
            4 hours ago
















          Ah you're right. I'll update answer.

          – Demerit
          6 hours ago





          Ah you're right. I'll update answer.

          – Demerit
          6 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
          4 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
          4 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
            2 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
            2 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
            2 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
            2 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 4 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
            2 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
            2 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
            2 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
            2 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
          2 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
          2 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
          2 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
          2 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

          Möglingen Índice Localización Historia Demografía Referencias Enlaces externos Menú de navegación48°53′18″N 9°07′45″E / 48.888333333333, 9.129166666666748°53′18″N 9°07′45″E / 48.888333333333, 9.1291666666667Sitio web oficial Mapa de Möglingen«Gemeinden in Deutschland nach Fläche, Bevölkerung und Postleitzahl am 30.09.2016»Möglingen

          Virtualbox - Configuration error: Querying “UUID” failed (VERR_CFGM_VALUE_NOT_FOUND)“VERR_SUPLIB_WORLD_WRITABLE” error when trying to installing OS in virtualboxVirtual Box Kernel errorFailed to open a seesion for the virtual machineFailed to open a session for the virtual machineUbuntu 14.04 LTS Virtualbox errorcan't use VM VirtualBoxusing virtualboxI can't run Linux-64 Bit on VirtualBoxUnable to insert the virtual optical disk (VBoxguestaddition) in virtual machine for ubuntu server in win 10VirtuaBox in Ubuntu 18.04 Issues with Win10.ISO Installation

          Torre de la Isleta Índice Véase también Referencias Bibliografía Enlaces externos Menú de navegación38°25′58″N 0°23′02″O / 38.43277778, -0.3838888938°25′58″N 0°23′02″O / 38.43277778, -0.38388889Torre de la Illeta de l’Horta o Torre Saleta. Base de datos de bienes inmuebles. Patrimonio Cultural. Secretaría de Estado de CulturaFicha BIC Torre de la Illeta de l’Horta. Dirección General de Patrimonio Cultural. Generalitat ValencianaLugares de interés. Ayuntamiento del CampelloTorre de la Isleta en CastillosNet.org