OpenRefine: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
=== Setup === | === Setup === | ||
* [https://openrefine.org/download.html Download OpenRefine] (we tested with version 3. | * [https://openrefine.org/download.html Download OpenRefine] (we tested with version 3.6.0) | ||
* Upload your data. For example | * Upload your data. For example | ||
| Line 17: | Line 17: | ||
{| 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 87: | ||
</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 93: | ||
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 102: | ||
* 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 112: | ||
* Upload Edits | * Upload Edits | ||
The data you ingested is now available in the | The data you ingested is now available in the Wikibase! | ||
Latest revision as of 20:30, 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[edit | edit source]
- an account on the Wikibase instance allowing to make edits
Setup[edit | edit source]
- 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[edit | edit source]
- 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[edit | edit source]
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[edit | edit source]
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[edit | edit source]
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!