OpenRefine: Difference between revisions
No edit summary |
|||
Line 14: | Line 14: | ||
**Next | **Next | ||
**Create Project | **Create Project | ||
Nom Nationalité Date de naissance Emploi Qualification | |||
Dennis Diefenbach Allemand/Italienne 2/15/1988 Indetermine Directeur de recherche et développement | |||
Ali Haidar Libanais 5/10/1997 Indetermine Developpeur | |||
Guo Kungpeng Chinois 1/13/1996 Determine Developpeur | |||
Clement Defretiere Francais 7/2/1999 Alternance Developpeur | |||
Lois Veni Francais 18/5/2000 Alternance Marketing | |||
Jonathan Mallet Francais Determine Developpeur | |||
{| class="wikitable" | {| class="wikitable" | ||
|+ | |+ | ||
| | |Nom | ||
| | |Nationalité | ||
| | |Date de naissance | ||
|- | |- | ||
|<nowiki> | |<nowiki>Dennis Diefenbach</nowiki> | ||
| | |Allemand/Italienne | ||
|<nowiki> | |<nowiki>2/15/1988</nowiki> | ||
|- | |- | ||
|<nowiki> | |<nowiki>Ali Haidar</nowiki> | ||
| | |Libanais | ||
|<nowiki> | |<nowiki>5/10/1997</nowiki> | ||
|- | |- | ||
|<nowiki> | |<nowiki>Guo Kungpeng</nowiki> | ||
| | |Chinois | ||
|<nowiki> | |<nowiki>1/13/1996</nowiki> | ||
|- | |- | ||
|<nowiki> | |<nowiki>Clement Defretiere</nowiki> | ||
| | |Francais | ||
|<nowiki> | |<nowiki>7/2/1999</nowiki> | ||
|- | |- | ||
|<nowiki> | |<nowiki>Lois Veni</nowiki> | ||
| | |Francais | ||
| | | | ||
|- | |- | ||
|<nowiki> | |<nowiki>Jonathan Mallet</nowiki> | ||
| | |Francais | ||
| | | | ||
|- | |- | ||
|} | |} | ||
Line 114: | Line 95: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
* Press "Add Wikibase" and the | * Press "Add Wikibase" and the Wikibase will appear in the list as one options to choose. | ||
=== Reconcile your data === | === Reconcile your data === | ||
Line 120: | Line 101: | ||
In general follow the [https://docs.openrefine.org/manual/wikibase/reconciling instructions on OpenRefine] for these steps. Here is just an example: | In general follow the [https://docs.openrefine.org/manual/wikibase/reconciling instructions on OpenRefine] for these steps. Here is just an example: | ||
* Choose the column " | * Choose the column "Nom" and click on "Reconcile -> Use Values as Identifiers" | ||
* Then the column will be completely reconcile | * Then the column will be completely reconcile | ||
Line 129: | Line 110: | ||
* Click on "add item". | * Click on "add item". | ||
* Drag and drop "entity" to the field "item" | * Drag and drop "entity" to the field "item" | ||
* Click on "add statement" and find the property " | * Click on "add statement" and find the property "birth date" (P145) | ||
* Drag and drop the column name " | * 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. | * 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. | ||
Line 140: | Line 120: | ||
* Upload Edits | * Upload Edits | ||
The data you ingested is now available in the | The data you ingested is now available in the Wikibase! |
Revision as of 20:29, 15 August 2022
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.5.2)
- Upload your data. For example
- Create Project
- Clipboard
- Insert the data in the Table below
- Next
- Create Project
Nom Nationalité Date de naissance Emploi Qualification Dennis Diefenbach Allemand/Italienne 2/15/1988 Indetermine Directeur de recherche et développement Ali Haidar Libanais 5/10/1997 Indetermine Developpeur Guo Kungpeng Chinois 1/13/1996 Determine Developpeur Clement Defretiere Francais 7/2/1999 Alternance Developpeur Lois Veni Francais 18/5/2000 Alternance Marketing Jonathan Mallet Francais Determine Developpeur
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!