OpenRefine

This page contains instructions to connect OpenRefine to this Wikibase instance. We offer a reconciliation service against this Wikibase that makes it easy to use OpenRefine.

Requirements

• an account on the Wikibase instance allowing to make edits

Setup

• Download OpenRefine (we tested with version 3.6.0)

• Upload your data. For example
  • Create Project
  • Clipboard
  • Insert the data in the Table below
  • Next
  • Create Project

Nom	Nationalité	Date de naissance
Dennis Diefenbach	Allemand/Italienne	2/15/1988
Ali Haidar	Libanais	5/10/1997
Guo Kungpeng	Chinois	1/13/1996
Clement Defretiere	Francais	7/2/1999
Lois Veni	Francais
Jonathan Mallet	Francais

Configure Open Refine for this Wikibase

• On the top right click on the Extensions Wikidata button and select "Select Wikibase instance"
• Add Wikibase
• Paste

{
"version":"1.0",
  "mediawiki":{
     "name":"Wikibase - The QA Company",
     "root":"https://wikibase.the-qa-company.com/wiki/",
     "main_page":"https://wikibase.the-qa-company.com/wiki/Wikibase_-_The_QA_Company",
     "api":"https://wikibase.the-qa-company.com/w/api.php"
  },
  "wikibase":{
     "site_iri":"https://wikibase.the-qa-company.com/entity/",
     "tag":"",
     "maxlag":5,
     "properties":{
        "instance_of":"P5",
        "subclass_of":"P47"
     },
     "constraints":{
        "property_constraint_pid":"P58",
        "exception_to_constraint_pid":"P120",

        "constraint_status_pid":"P119",
        "mandatory_constraint_qid":"Q76",
        "suggestion_constraint_qid":"Q354",
        "distinct_values_constraint_qid":"Q425"
     }
  },
  "reconciliation":{
     "endpoint":"https://openrefine-reconciliation.wikibase.the-qa-company.com/${lang}/api"
  },
  "editgroups":{
     "url_schema":"([[:toollabs:editgroups/b/OR/${batch_id}|details]])"
  }
}

• Press "Add Wikibase" and the Wikibase will appear in the list as one options to choose.

Reconcile your data

In general follow the instructions on OpenRefine for these steps. Here is just an example:

• Choose the column "Nom" and click on "Reconcile -> Use Values as Identifiers"
• Then the column will be completely reconcile

Model your data using the Wikibase Schema

In general follow the instructions on OpenRefine for these steps. Here is just an example:

• Click on the schema tab
• Click on "add item".
• Drag and drop "entity" to the field "item"
• Click on "add statement" and find the property "birth date" (P145)
• Drag and drop the column name "Date de naissance" to the statement item
• You can now check if you have some issues with the import by checking the "Issues" tab or see a preview of what you've done.

Upload your data

In general follow the instructions on OpenRefine for these steps. Here is just an example:

• In the upper right click on Wikidata -> Upload Edits to Wikibase
• Log in
• Upload Edits

The data you ingested is now available in the Wikibase!