Beyond Notability

User:Mzeinstra/sandbox/QS: Difference between revisions

User page Discussion

User:Mzeinstra/sandbox/QS (view source)

Revision as of 13:31, 1 July 2024

1,597 bytes added ,  3 months ago
no edit summary
No edit summary
 
(5 intermediate revisions by one other user not shown)
Line 18: Line 18:


* fist referencing the Q number of the item in question (eg. [[Item:Q462|Q465]]), Edith Blake
* fist referencing the Q number of the item in question (eg. [[Item:Q462|Q465]]), Edith Blake
* followed by the P number of the property (eg. gender [[Property:P3|P3]])  
* followed by the P number of the property (eg. instance of [[Property:P12|P12]])  
* and finally the value to be added,  
* and finally the value to be added,  
** which can reference another item by its Q number (eg. woman [[Item:Q3|Q3]])  
** which can reference another item by its Q number (eg. human [[Item:Q2137|Q2137]])  
** or a string value, delimited by "" (eg. "2021-02-21" or "Lucius, Michel").  
** or a string value, delimited by "" (eg. "2021-02-21" or "Lucius, Michel").  


These 3 elements need to be separated by a TAB or "|" characters
These 3 elements need to be separated by a TAB or "|" characters
e.g. adding that Edith Blak is a woman, and adding that her birth day is 1876-12-09 (fictitious date).
e.g. adding that Edith Blake is a woman, and adding that her birth day is 1876-12-09 (fictitious date).
  Q462|P3|Q3
  Q462|P12|QQ2137


  Q462 P26 "1876-12-09"
  Q462 P26 "1876-12-09"
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.


== Open Refine ==
== Moving data from statement to statement ==
Data edited in OpenRefine can also be exported to the QuickStatements format. (to be described).
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
Retrieved from "https://beyond-notability.wikibase.cloud/wiki/Special:MobileDiff/19309...61132"