2,187
edits
User:Mzeinstra/sandbox/QS: Difference between revisions
no edit summary
No edit summary Tag: Manual revert |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 83: | Line 83: | ||
Also, you will *not* be able to store batches for working on them later. | Also, you will *not* be able to store batches for working on them later. | ||
== | == Moving data from statement to statement == | ||
It is possible to move data from one field to another using quick statement. For example copying all 'en-gb' labels to 'en' labels: | |||
Steps to reproduce | |||
* Write a Sparql query to get all en-gb labels and descriptions of all items and properties. | |||
* Download these as a TSV | |||
* Manipulated the TSV so they become QuickStatements commands. For example use some text-edit magic and Regular Expressions, or manipulate the TSV using a spreadsheet editor. | |||
* | |||
e.g. | |||
https://beyond-notability.wikibase.cloud/entity/Q1022 Transactions of the Historic Society of Lancashire and Cheshire journal of the Historic Society of Lancashire and Cheshire | |||
(notice this is <link><tab><label><tab><description>) | |||
becomes | |||
Q1022 Len "Transactions of the Historic Society of Lancashire and Cheshire" | |||
Q1022 Den "journal of the Historic Society of Lancashire and Cheshire" | |||
* Test the commands and verify that the right labels and descriptions get ingested. | |||
* Run the entire set commands | |||
== Creating a spreadsheet based ingest== | |||
Creating a QuickStatements CSV | |||
For example we want to import this information for new records: | |||
* Label (in english) | |||
* Gender | |||
* Resided at | |||
With the qualifiers to the resided at statement | |||
* Street address free text | |||
* Start time | |||
We would create a spreadsheet with the following header (row): | |||
* qid | |||
* Len | |||
* P3 | |||
* P29 | |||
* qal1 | |||
* P29 | |||
* qal31 | |||
Where qid remains an empty column (indicating a new record needs to be created. A good help section on how to create these spreadsheets can be found on quickstatements/#/batch under the ‘import CSV’ button. Fill in the spreadsheet, export it as a CSV and use QuickStatement to add multiple statements at once. | |||
== More information == | == More information == | ||
https://www.wikidata.org/wiki/Help:QuickStatements | https://www.wikidata.org/wiki/Help:QuickStatements | ||