CINXE.COM

<!DOCTYPE html> <html class="client-nojs" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Wikidata:Tools/OpenRefine/Editing/Quality assurance - Wikidata</title> <script>(function(){var className="client-js";var cookie=document.cookie.match(/(?:^|; )wikidatawikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"e592295a-1e90-48bf-9221-b1006c0a7d79","wgCanonicalNamespace":"Project","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":4,"wgPageName":"Wikidata:Tools/OpenRefine/Editing/Quality_assurance","wgTitle":"Tools/OpenRefine/Editing/Quality assurance","wgCurRevisionId":1383148254,"wgRevisionId":1383148254,"wgArticleId":51522158,"wgIsArticle":true,"wgIsRedirect": false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":[],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Wikidata:Tools/OpenRefine/Editing/Quality_assurance","wgRelevantArticleId":51522158,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"wikidata","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":5000,"wgTranslatePageTranslation":"source","wgEditSubmitButtonLabelPublish":true,"wgDiscussionToolsFeaturesEnabled":{"replytool":true,"newtopictool":true,"sourcemodetoolbar":true,"topicsubscription":false,"autotopicsub":false, "visualenhancements":false,"visualenhancements_reply":false,"visualenhancements_pageframe":false},"wgDiscussionToolsFallbackEditMode":"source","wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"]};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.translate.tag.languages":"ready","ext.discussionTools.init.styles":"ready","oojs-ui-core.styles":"ready","oojs-ui.styles.indicators":"ready","mediawiki.widgets.styles":"ready","oojs-ui-core.icons":"ready","skins.vector.styles.legacy":"ready","ext.translate.edit.documentation.styles":"ready","ext.translate":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","codex-search-styles":"ready","ext.uls.pt": "ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["mediawiki.page.media","site","mediawiki.page.ready","mediawiki.toc","skins.vector.legacy.js","wikibase.ui.entitysearch","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.translate.pagetranslation.uls","ext.gadget.Search","ext.gadget.ProtectionIndicators","ext.gadget.imagelinks","ext.gadget.NewSection","ext.gadget.formWizard","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.discussionTools.init","ext.eventLogging","ext.wikimediaEvents","ext.wikimediaEvents.wikibase","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","ext.checkUser.clientHints"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=codex-search-styles%7Cext.discussionTools.init.styles%7Cext.translate%2CwikimediaBadges%7Cext.translate.edit.documentation.styles%7Cext.translate.tag.languages%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cmediawiki.widgets.styles%7Coojs-ui-core.icons%2Cstyles%7Coojs-ui.styles.indicators%7Cskins.vector.styles.legacy%7Cwikibase.client.init&only=styles&skin=vector"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector"> <meta name="generator" content="MediaWiki 1.44.0-wmf.6"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//m.wikidata.org/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/wikidata.png"> <link rel="icon" href="/static/favicon/wikidata.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikidata (en)"> <link rel="EditURI" type="application/rsd+xml" href="//www.wikidata.org/w/api.php?action=rsd"> <link rel="canonical" href="https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance"> <link rel="license" href="/wiki/Wikidata:Copyright"> <link rel="alternate" type="application/atom+xml" title="Wikidata Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="login.wikimedia.org"> </head> <body class="ext-discussiontools-replytool-enabled ext-discussiontools-newtopictool-enabled ext-discussiontools-sourcemodetoolbar-enabled skin-vector-legacy mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-4 ns-subject mw-editable page-Wikidata_Tools_OpenRefine_Editing_Quality_assurance rootpage-Wikidata_Tools skin-vector action-view"><div id="mw-page-base" class="noprint"></div> <div id="mw-head-base" class="noprint"></div> <div id="content" class="mw-body" role="main"> <a id="top"></a> <div id="siteNotice"></div> <div class="mw-indicators"> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Wikidata</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">Tools/OpenRefine/Editing/Quality assurance</span></h1> <div id="bodyContent" class="vector-body"> <div id="siteSub" class="noprint">From Wikidata</div> <div id="contentSub"><div id="mw-content-subtitle"><div class="subpages">< <bdi dir="ltr"><a href="/wiki/Special:MyLanguage/Wikidata:Tools" title="Special:MyLanguage/Wikidata:Tools">Wikidata:Tools</a></bdi> | <bdi dir="ltr"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine" title="Special:MyLanguage/Wikidata:Tools/OpenRefine">OpenRefine</a></bdi> | <bdi dir="ltr"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing" title="Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing">Editing</a></bdi></div></div></div> <div id="contentSub2"></div> <div id="jump-to-nav"></div> <a class="mw-jump-link" href="#mw-head">Jump to navigation</a> <a class="mw-jump-link" href="#searchInput">Jump to search</a> <div id="mw-content-text" class="mw-body-content"><div class="mw-pt-translate-header noprint nomobile" dir="ltr" lang="en"><a href="/w/index.php?title=Special:Translate&group=page-Wikidata%3ATools%2FOpenRefine%2FEditing%2FQuality+assurance&action=page&filter=&action_source=translate_page" title="Special:Translate">Translate this page</a></div><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><div class="mw-pt-languages noprint navigation-not-searchable" lang="en" dir="ltr"><div class="mw-pt-languages-label">Other languages:</div><ul class="mw-pt-languages-list"><li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/de" class="mw-pt-progress mw-pt-progress--complete" title="Wikidata:Werkzeuge/OpenRefine/Bearbeiten/Qualitätssicherung (100% translated)" lang="de" dir="ltr">Deutsch</a></li> <li><span class="mw-pt-languages-ui mw-pt-languages-selected mw-pt-progress mw-pt-progress--complete" lang="en" dir="ltr">English</span></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/eo" class="mw-pt-progress mw-pt-progress--med" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/eo (18% translated)" lang="eo" dir="ltr">Esperanto</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/nl" class="mw-pt-progress mw-pt-progress--complete" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/nl (100% translated)" lang="nl" dir="ltr">Nederlands</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/da" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/da (12% translated)" lang="da" dir="ltr">dansk</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/fr" class="mw-pt-progress mw-pt-progress--med" title="Wikidata:Tools/OpenRefine/Edition/Contrôle qualité (21% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/pl" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/pl (12% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/szl" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/szl (6% translated)" lang="szl" dir="ltr">ślůnski</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/be-tarask" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/be-tarask (6% translated)" lang="be-tarask" dir="ltr">беларуская (тарашкевіца)</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/ru" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/ru (3% translated)" lang="ru" dir="ltr">русский</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/ar" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/ar (3% translated)" lang="ar" dir="rtl">العربية</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/zh" class="mw-pt-progress mw-pt-progress--low" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/zh (6% translated)" lang="zh" dir="ltr">中文</a></li> <li><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance/ja" class="mw-pt-progress mw-pt-progress--med" title="Wikidata:Tools/OpenRefine/Editing/Quality assurance/ja (61% translated)" lang="ja" dir="ltr">日本語</a></li></ul></div> <div style="font-size: 1.3125em; width: 100%; display: table; border-bottom: 1px solid #cccccc; margin: 1em -16px 1em -16px; padding: 0 16px"> <div style="width: auto; display: inline-block; float: left; border: 1px solid #cccccc; background-color: #f4f4f4; position: relative; top: 1px; padding: 0.5em 1em;"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Schema_alignment" title="Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Schema alignment">Schema alignment</a></div> <div style="width: auto; display: inline-block; float: left; border: 1px solid #cccccc; background-color: #f4f4f4; border-left: 0; position: relative; top: 1px; padding: 0.5em 1em;"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Advanced_schemas" title="Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Advanced schemas">Advanced schemas</a></div> <div style="width: auto; display: inline-block; float: left; border: 1px solid #cccccc; background-color: #f4f4f4; border-left: 0; position: relative; top: 1px; padding: 0.5em 1em;"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/New_items" title="Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/New items">New items</a></div> <div style="width: auto; display: inline-block; float: left; border: 1px solid #cccccc; background-color: #ffffff; border-bottom-color: #ffffff; border-left: 0; position: relative; top: 1px; padding: 0.5em 1em;"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Quality_assurance" title="Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Quality assurance">Quality assurance</a></div> <div style="width: auto; display: inline-block; float: left; border: 1px solid #cccccc; background-color: #f4f4f4; border-left: 0; position: relative; top: 1px; padding: 0.5em 1em;"><a href="/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Uploading" title="Special:MyLanguage/Wikidata:Tools/OpenRefine/Editing/Uploading">Uploading</a></div> </div> <figure class="mw-default-size" typeof="mw:File/Thumb"><a href="/wiki/File:OR-WD-editing-tutorial-issues.png" class="mw-file-description"><img src="//upload.wikimedia.org/wikipedia/commons/thumb/5/50/OR-WD-editing-tutorial-issues.png/220px-OR-WD-editing-tutorial-issues.png" decoding="async" width="220" height="34" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/5/50/OR-WD-editing-tutorial-issues.png/330px-OR-WD-editing-tutorial-issues.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/5/50/OR-WD-editing-tutorial-issues.png/440px-OR-WD-editing-tutorial-issues.png 2x" data-file-width="973" data-file-height="151"/></a><figcaption>Example issues reported by OpenRefine in a sample project.</figcaption></figure> <p>This page explains how the Wikidata extension of OpenRefine analyzes edits before they are uploaded to Wikidata. </p> <div id="toc" class="toc" role="navigation" aria-labelledby="mw-toc-heading"><input type="checkbox" role="button" id="toctogglecheckbox" class="toctogglecheckbox" style="display:none" /><div class="toctitle" lang="en" dir="ltr"><h2 id="mw-toc-heading">Contents</h2><span class="toctogglespan"><label class="toctogglelabel" for="toctogglecheckbox"></label></span></div> <ul> <li class="toclevel-1 tocsection-1"><a href="#Overview"><span class="tocnumber">1</span> <span class="toctext">Overview</span></a></li> <li class="toclevel-1 tocsection-2"><a href="#Reconciliation"><span class="tocnumber">2</span> <span class="toctext">Reconciliation</span></a></li> <li class="toclevel-1 tocsection-3"><a href="#Constraint_violations"><span class="tocnumber">3</span> <span class="toctext">Constraint violations</span></a></li> <li class="toclevel-1 tocsection-4"><a href="#Generic_issues"><span class="tocnumber">4</span> <span class="toctext">Generic issues</span></a></li> <li class="toclevel-1 tocsection-5"><a href="#Adding_support_for_a_new_constraint"><span class="tocnumber">5</span> <span class="toctext">Adding support for a new constraint</span></a></li> </ul> </div> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Overview" data-mw-thread-id="h-Overview"><span data-mw-comment-start="" id="h-Overview"></span>Overview<span data-mw-comment-end="h-Overview"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit&section=1" title="Edit section: Overview"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Changes are scrutinized before they are uploaded, but also before the current content of the corresponding items is retrieved and merged with the updates. This means that some constraint violations cannot be predicted by the software (for instance, adding a new statement that conflicts with an existing statement on the item). However, this makes it possible to run the checks quickly, even for relatively large batches of edits. Issues are therefore refreshed in real time while the user builds the schema. </p><p>As a consequence, not all constraint violations can be detected: the ones that are supported are listed in the <a href="#Constraint_violations">Constraint violations</a> section. Conversely, not all issues reported will be flagged as constraint violations on Wikidata: see <a href="#Generic_issues">Generic issues</a> for these. </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Reconciliation" data-mw-thread-id="h-Reconciliation"><span data-mw-comment-start="" id="h-Reconciliation"></span>Reconciliation<span data-mw-comment-end="h-Reconciliation"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit&section=2" title="Edit section: Reconciliation"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>You should always assess the quality of your reconciliation results first. OpenRefine has various tools for quality assurance of reconciliation results. For instance: </p> <ul><li>you can analyze the string similarity between your original names and those of the reconciled items (for instance with <b>Reconcile</b> → <b>Facets</b> → <b>Best candidate's name edit distance</b>);</li></ul> <ul><li>you can compare the values in your table with those on the items (via a text facet defined by a custom expression);</li></ul> <ul><li>you can facet by type on the reconciled items (add a new column with the types and use a text facet ordered by counts to get a sense of the distribution of types in your reconciled items).</li></ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Constraint_violations" data-mw-thread-id="h-Constraint_violations"><span data-mw-comment-start="" id="h-Constraint_violations"></span>Constraint violations<span data-mw-comment-end="h-Constraint_violations"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit&section=3" title="Edit section: Constraint violations"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Constraints are retrieved as defined on the properties, using <a href="/wiki/Property:P2302" title="Property:P2302">property constraint <small dir="ltr">(P2302)</small></a>. </p><p>The following constraints are supported: </p> <ul><li><a href="/wiki/Q21502404" title="Q21502404">format constraint <small>(Q21502404)</small></a>, checked on all values</li></ul> <ul><li><a href="/wiki/Q21510855" title="Q21510855">inverse constraint <small>(Q21510855)</small></a>: OpenRefine assumes that the inverses of the candidate statements are not in Wikidata yet. If you know that the inverse statements are already in Wikidata, you can safely ignore this issue.</li></ul> <ul><li><a href="/wiki/Q21528958" title="Q21528958">used for values only constraint <small>(Q21528958)</small></a>, <a href="/wiki/Q21510863" title="Q21510863">used as qualifier constraint <small>(Q21510863)</small></a> and <a href="/wiki/Q21528959" title="Q21528959">used as reference constraint <small>(Q21528959)</small></a></li></ul> <ul><li><a href="/wiki/Q21510851" title="Q21510851">allowed qualifiers constraint <small>(Q21510851)</small></a></li></ul> <ul><li><a href="/wiki/Q21510856" title="Q21510856">required qualifier constraint <small>(Q21510856)</small></a></li></ul> <ul><li><a href="/wiki/Q19474404" title="Q19474404">single-value constraint <small>(Q19474404)</small></a>: this will only trigger if you are adding more than one statement with the property on the same item, but will not detect any existing statement with this property.</li></ul> <ul><li><a href="/wiki/Q21502410" title="Q21502410">distinct-values constraint <small>(Q21502410)</small></a>: similarly, this only checks for conflicts inside your edit batch.</li></ul> <p>A comparison of the supported constraints with respect to other implementations is available at <a href="/wiki/Wikidata:WikiProject_property_constraints/reports/implementations" title="Wikidata:WikiProject property constraints/reports/implementations">Wikidata:WikiProject property constraints/reports/implementations</a>. </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Generic_issues" data-mw-thread-id="h-Generic_issues"><span data-mw-comment-start="" id="h-Generic_issues"></span>Generic issues<span data-mw-comment-end="h-Generic_issues"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit&section=4" title="Edit section: Generic issues"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>OpenRefine also detects issues that are not flagged (yet) by constraint violations on Wikidata: </p> <ul><li>Statements without references. This does not rely on <a href="/wiki/Q54554025" title="Q54554025">citation-needed constraint <small>(Q54554025)</small></a>: all statements are expected to have references. (The idea is that when importing a dataset, every statement you add should link to this dataset - it does not hurt to do it even for generic properties such as <a href="/wiki/Property:P31" title="Property:P31">instance of <small dir="ltr">(P31)</small></a>.)</li></ul> <ul><li>Spurious whitespace and non-printable characters in strings (including labels, descriptions and aliases);</li></ul> <ul><li>Self-referential statements (statements which mention the item they belong to);</li></ul> <ul><li>New items created without any label;</li></ul> <ul><li>New items created without any description;</li></ul> <ul><li>New items created without any <a href="/wiki/Property:P31" title="Property:P31">instance of <small dir="ltr">(P31)</small></a> or <a href="/wiki/Property:P279" title="Property:P279">subclass of <small dir="ltr">(P279)</small></a> statement.</li></ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Adding_support_for_a_new_constraint" data-mw-thread-id="h-Adding_support_for_a_new_constraint"><span data-mw-comment-start="" id="h-Adding_support_for_a_new_constraint"></span>Adding support for a new constraint<span data-mw-comment-end="h-Adding_support_for_a_new_constraint"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit&section=5" title="Edit section: Adding support for a new constraint"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>If you know Java, contributing a new constraint is easy! Just look at example <b>scrutinizers</b> (that is how constraint checkers are internally called) such as <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/blob/master/extensions/wikidata/src/org/openrefine/wikidata/qa/scrutinizers/SingleValueScrutinizer.java">SingleValueScrutinizer</a> or <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/blob/master/extensions/wikidata/src/org/openrefine/wikidata/qa/scrutinizers/FormatScrutinizer.java">FormatScrutinizer</a> and write a similar class that detects the issue you want to highlight. Write the corresponding test class (such as <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/blob/master/extensions/wikidata/tests/src/org/openrefine/wikidata/qa/scrutinizers/SingleValueScrutinizerTest.java">SingleValueScrutinizerTest</a> or <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/blob/master/extensions/wikidata/tests/src/org/openrefine/wikidata/qa/scrutinizers/FormatScrutinizerTest.java">FormatScrutinizerTest</a>) which demonstrates the issues raised by your scrutinizer. Finally, register your scrutinizer in <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/blob/master/extensions/wikidata/src/org/openrefine/wikidata/qa/EditInspector.java">EditInspector</a> so that it gets run with the rest of the scrutinizers on all candidate edits. Submit your code as a pull request to <a rel="nofollow" class="external free" href="https://github.com/OpenRefine/OpenRefine">https://github.com/OpenRefine/OpenRefine</a>. </p><p>If you need any help with that, do ping <a href="/wiki/User:Pintoch" title="User:Pintoch">User:Pintoch</a> who will be very happy to help. </p>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?useformat=desktop&type=1x1&usesul3=0" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://www.wikidata.org/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&oldid=1383148254">https://www.wikidata.org/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&oldid=1383148254</a>"</div></div> <div id="catlinks" class="catlinks catlinks-allhidden" data-mw="interface"></div> </div> </div> <div id="mw-navigation"> <h2>Navigation menu</h2> <div id="mw-head"> <nav id="p-personal" class="mw-portlet mw-portlet-personal vector-user-menu-legacy vector-menu" aria-labelledby="p-personal-label" > <h3 id="p-personal-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Personal tools</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-uls" class="mw-list-item active"><a class="uls-trigger" href="#"><span>English</span></a></li><li id="pt-anonuserpage" class="mw-list-item"><span title="The user page for the IP address you are editing as">Not logged in</span></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li><li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li><li id="pt-createaccount" class="mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Wikidata%3ATools%2FOpenRefine%2FEditing%2FQuality+assurance" title="You are encouraged to create an account and log in; however, it is not mandatory"><span>Create account</span></a></li><li id="pt-login" class="mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Wikidata%3ATools%2FOpenRefine%2FEditing%2FQuality+assurance" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span>Log in</span></a></li> </ul> </div> </nav> <div id="left-navigation"> <nav id="p-namespaces" class="mw-portlet mw-portlet-namespaces vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-namespaces-label" > <h3 id="p-namespaces-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Namespaces</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-project" class="selected mw-list-item"><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance" title="View the project page [c]" accesskey="c"><span>Project page</span></a></li><li id="ca-talk" class="new mw-list-item"><a href="/w/index.php?title=Wikidata_talk:Tools/OpenRefine/Editing/Quality_assurance&action=edit&redlink=1" rel="discussion" class="new" title="Discussion about the content page (page does not exist) [t]" accesskey="t"><span>Discussion</span></a></li> </ul> </div> </nav> <nav id="p-variants" class="mw-portlet mw-portlet-variants emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-variants-label" > <input type="checkbox" id="p-variants-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-variants" class="vector-menu-checkbox" aria-labelledby="p-variants-label" > <label id="p-variants-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">English</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> </div> <div id="right-navigation"> <nav id="p-views" class="mw-portlet mw-portlet-views vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-views-label" > <h3 id="p-views-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Views</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected mw-list-item"><a href="/wiki/Wikidata:Tools/OpenRefine/Editing/Quality_assurance"><span>Read</span></a></li><li id="ca-edit" class="mw-list-item"><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=edit" title="Edit this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-history" class="mw-list-item"><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li> </ul> </div> </nav> <nav id="p-cactions" class="mw-portlet mw-portlet-cactions emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-cactions-label" title="More options" > <input type="checkbox" id="p-cactions-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-cactions" class="vector-menu-checkbox" aria-labelledby="p-cactions-label" > <label id="p-cactions-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">More</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box"> <h3 >Search</h3> <form action="/w/index.php" id="searchform" class="vector-search-box-form"> <div id="simpleSearch" class="vector-search-box-inner" data-search-loc="header-navigation"> <input class="vector-search-box-input" type="search" name="search" placeholder="Search Wikidata" aria-label="Search Wikidata" autocapitalize="sentences" title="Search Wikidata [f]" accesskey="f" id="searchInput" > <input type="hidden" name="title" value="Special:Search"> <input id="mw-searchButton" class="searchButton mw-fallbackSearchButton" type="submit" name="fulltext" title="Search the pages for this text" value="Search"> <input id="searchButton" class="searchButton" type="submit" name="go" title="Go to a page with this exact name if it exists" value="Go"> </div> </form> </div> </div> </div> <div id="mw-panel" class="vector-legacy-sidebar"> <div id="p-logo" role="banner"> <a class="mw-wiki-logo" href="/wiki/Wikidata:Main_Page" title="Visit the main page"></a> </div> <nav id="p-navigation" class="mw-portlet mw-portlet-navigation vector-menu-portal portal vector-menu" aria-labelledby="p-navigation-label" > <h3 id="p-navigation-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Navigation</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Wikidata:Main_Page" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-portal" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Project:Community_portal" title="About the project, what you can do, where to find things"><span>Community portal</span></a></li><li id="n-villagepump" class="mw-list-item"><a href="/wiki/Wikidata:Project_chat"><span>Project chat</span></a></li><li id="n-special-newitem" class="mw-list-item"><a href="/wiki/Special:NewItem"><span>Create a new Item</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-wikibase-randomitem" class="mw-list-item"><a href="/wiki/Special:Random/Main" title="[x]" accesskey="x"><span>Random Item</span></a></li><li id="n-wikibase-queryservice" class="mw-list-item"><a href="//query.wikidata.org/"><span>Query Service</span></a></li><li id="n-nearby-pages-title" class="mw-list-item"><a href="/wiki/Special:Nearby"><span>Nearby</span></a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Help:Contents" title="The place to find out"><span>Help</span></a></li><li id="n-sitesupport" class="mw-list-item"><a href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=www.wikidata.org&uselang=en" title="Support us"><span>Donate</span></a></li> </ul> </div> </nav> <nav id="p-wikibase-lexeme-lexicographical-data" class="mw-portlet mw-portlet-wikibase-lexeme-lexicographical-data vector-menu-portal portal vector-menu" aria-labelledby="p-wikibase-lexeme-lexicographical-data-label" > <h3 id="p-wikibase-lexeme-lexicographical-data-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Lexicographical data</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-special-newlexeme" class="mw-list-item"><a href="/wiki/Special:NewLexeme"><span>Create a new Lexeme</span></a></li><li id="n-recentchanges-lexemes" class="mw-list-item"><a href="https://www.wikidata.org/wiki/Special:RecentChanges?namespace=146%3B147"><span>Recent changes</span></a></li><li id="n-wikibase-lexeme-randomlexeme" class="mw-list-item"><a href="/wiki/Special:Random/Lexeme"><span>Random Lexeme</span></a></li> </ul> </div> </nav> <nav id="p-tb" class="mw-portlet mw-portlet-tb vector-menu-portal portal vector-menu" aria-labelledby="p-tb-label" > <h3 id="p-tb-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Tools</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/Wikidata:Tools/OpenRefine/Editing/Quality_assurance" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Wikidata:Tools/OpenRefine/Editing/Quality_assurance" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&oldid=1383148254" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&action=info" title="More information about this page"><span>Page information</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlQ%C4%B1sald%C4%B1c%C4%B1s%C4%B1&url=https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FWikidata%3ATools%2FOpenRefine%2FEditing%2FQuality_assurance"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrKodu&url=https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FWikidata%3ATools%2FOpenRefine%2FEditing%2FQuality_assurance"><span>Download QR code</span></a></li> </ul> </div> </nav> <nav id="p-coll-print_export" class="mw-portlet mw-portlet-coll-print_export vector-menu-portal portal vector-menu" aria-labelledby="p-coll-print_export-label" > <h3 id="p-coll-print_export-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Print/export</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Special:Book&bookcmd=book_creator&referer=Wikidata%3ATools%2FOpenRefine%2FEditing%2FQuality+assurance"><span>Create a book</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Wikidata%3ATools%2FOpenRefine%2FEditing%2FQuality_assurance&action=show-download-screen"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&printable=yes" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </nav> <nav id="p-wikibase-otherprojects" class="mw-portlet mw-portlet-wikibase-otherprojects emptyPortlet vector-menu-portal portal vector-menu" aria-labelledby="p-wikibase-otherprojects-label" > <h3 id="p-wikibase-otherprojects-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In other projects</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> <nav id="p-lang" class="mw-portlet mw-portlet-lang vector-menu-portal portal vector-menu" aria-labelledby="p-lang-label" > <h3 id="p-lang-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In Wikipedia</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-add wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:NewItem?site=wikidatawiki&page=Wikidata%3ATools%2FOpenRefine%2FEditing%2FQuality+assurance" title="Add interlanguage links" class="wbc-editpage">Add links</a></span></div> </div> </nav> </div> </div> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 16 March 2021, at 10:47.</li> <li id="footer-info-copyright">All structured data from the main, Property, Lexeme, and EntitySchema namespaces is available under the <a rel="nofollow" class="external text" href="//creativecommons.org/publicdomain/zero/1.0/">Creative Commons CC0 License</a>; text in the other namespaces is available under the <a rel="nofollow" class="external text" href="//creativecommons.org/licenses/by-sa/4.0/">Creative Commons Attribution-ShareAlike License</a>; additional terms may apply. By using this site, you agree to the <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> and <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy Policy</a>.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Special:MyLanguage/Project:Introduction">About Wikidata</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Special:MyLanguage/Project:General_disclaimer">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/www.wikidata.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//m.wikidata.org/w/index.php?title=Wikidata:Tools/OpenRefine/Editing/Quality_assurance&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> <li id="footer-places-data-access"><a href="/wiki/Special:MyLanguage/Wikidata:Data_access">Data access</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> <script>(RLQ=window.RLQ||[]).push(function(){mw.log.warn("This page is using the deprecated ResourceLoader module \"codex-search-styles\".\n[1.43] Use a CodexModule with codexComponents to set your specific components used: https://www.mediawiki.org/wiki/Codex#Using_a_limited_subset_of_components");mw.config.set({"wgHostname":"mw-web.codfw.main-55db797859-g6whw","wgBackendResponseTime":104,"wgDiscussionToolsPageThreads":[{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Overview","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Reconciliation","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Constraint_violations","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Generic_issues","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Adding_support_for_a_new_constraint","replies":[]}],"wgPageParseReport":{"discussiontools":{"limitreport-timeusage":"0.009"},"limitreport":{"cputime":"0.112","walltime":"0.214","ppvisitednodes":{"value":720,"limit":1000000},"postexpandincludesize":{"value":5328,"limit":2097152},"templateargumentsize":{"value":429,"limit":2097152},"expansiondepth":{"value":7,"limit":100},"expensivefunctioncount":{"value":0,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":3239,"limit":5000000},"entityaccesscount":{"value":0,"limit":500},"timingprofile":["100.00% 70.517 1 -total"," 70.09% 49.428 14 Template:Label"," 48.25% 34.023 4 Template:P"," 37.23% 26.256 10 Template:Q"," 12.55% 8.851 1 Wikidata:Tools/OpenRefine/Editing/Header/en"," 2.82% 1.988 4 Template:Str_left"]},"scribunto":{"limitreport-timeusage":{"value":"0.019","limit":"10.000"},"limitreport-memusage":{"value":974619,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-5d74f7b59c-zmx62","timestamp":"20241217160444","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>