User:Djm-leighpark/HOWTO
Add a TV series season to Wikidata with Quickstatments sitelinking to WQ edit
Set the following up in a spreadsheet. Quotes are super-critical. If Len is set to the name of the Wikiquote article then only three inputs are needed:
- Len - The name of the Wikiquote article. (B2)
- Q999111222333 : The Wikidata qcode of the master article. (A6)
- The season number which must be in quotes. This is "2" below. (E6)
If you set up the spreadsheet neatly with Create in A1 then you can set C7 to "=A6"; E7 to "=E6" and C8 "=C2" (touch wood I have this right):
- I accept no responsbility if you try this and it goes wrong.
- This actually contains lots of bad practice and refernces are really needed.
- You have to check you're own work and back it out if it goes wrong. And with a Quickstatements newbie it probably will. A QS guru will likely tear this advice apart.
- Best practice is to visiting the item and manually place followed by and follows explicitly on this item and the preceding season.
CREATE LAST Len "Auf Wiedersehen, Pet (series 2)" LAST Den "Season of a television series" LAST P31 Q3464665 /* Television series season */ LAST P364 Q1860 /* English language*/ 999111222333 P527 LAST P1545 "2" /* Part of the series */ LAST P179 999111222333 P1545 "2" /* Has parts */ LAST Senwikiquote "Auf Wiedersehen, Pet (series 2)"
Create a Wikidata item edit
Set up a spreadsheet as follows. The B columns in the first bit are for parameters. Refernece the data by $B$1 amd the rest by relatives. Its useless without the formulas which are in a wikitable below. This gives a dude a very quick wikidata. Cut and paste stuff not into the cell but into the doofer entry box at the top of the sheet. Check no pre existing wikidata item! The stuff after create is copied to Quickstatement input. Be prepared to end up in a heap!
THIS EXAMPLE DOESNT WORK. IT LOSES THE OCCUPATION WHEN Ref URL2(occ) present. There may be more bugs than that!
WQ Article Alexandra Maseko Description Zimbabwean basketball player Sex F /* Use F for female and leave blank for male */ Occupation Q3665646 /* Polition (Q82955) Journalist (Q1930187) author (Q36180) */ Ref.URL1(occ) https://www.theguardian.com/global-development/gallery/2020/dec/17/we-rise-by-lifting-others-outstanding-women-of-zimbabwe-in-pictures Ref URL2(occ) https://www.herald.co.zw/afrobasket-preps-confusion/ Ref URL3(hum) https://www.chronicle.co.zw/kirsty-mines-gold/ VIAF Citizenship Q954 CREATE LAST Len "Alexandra Maseko" LAST Den "Zimbabwean basketball player" LAST P31 Q5 S854 "https://www.chronicle.co.zw/kirsty-mines-gold/" S813 +2023-01-24T00:00:00Z/11 LAST P21 Q6581072 LAST Senwikiquote "Alexandra Maseko" LAST P27 Q954 LAST P106 Q3665646 S854 "https://www.theguardian.com/global-development/gallery/2020/dec/17/we-rise-by-lifting-others-outstanding-women-of-zimbabwe-in-pictures" S813 +2023-01-24T00:00:00Z/11 !S854 "https://www.herald.co.zw/afrobasket-preps-confusion/" S813 +2023-01-24T00:00:00Z/11
This was run in as QS batch 112222
Spreadsheet setup edit
This may (probably will) contain bugs. My "Project egg! derived technique ... breaks given any chance. If this is placed at the top of a sheet it is possible to leave it blank and then copy rows 2 to 22 further down the sheet. If you are beginner level with spreadsheets or dont have a basic clue of editing wikidata items dont do this, if you mess up with Quickstatements you have to fix your own mess and you need some experience with wikidata items to do that. This all breaks if every isn't near perfectly right. URL-REF1(occ) & URL-REF2(occ) should source the "occupation (broadly defined)" URL-REF3(hum) simply has to identify the subject as human. But used right on a good day pasting 6 or 7 items into a spreadsheet (best not directly into the cells but into the top entry box or you take the crazy fonts with you) or which only 2 are Q-codes to look up you get a range of cells that can be copied/pasted into quickstatements to get wikidata item ready linked to Wikiquote!
SELF TROUT AGAIN- This hasn't worked. It has a bug and I need to fix it! TROUT TROUT TROUT!!!
Row | A | B | C | D | E | F | G | H | I | J | K |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | TODAY | =CONCATENATE("+",TEXT(TODAY(),"yyyy-mm-dd"),"T00:00:00Z/11") | |||||||||
2 | WQ Article | /* Title of Wikipedia article */ | |||||||||
3 | Description | /* Description of Subject (KISS) */ | |||||||||
4 | Sex | /* Use F for female and leave blank for male or mess up for gender reassignment */ | |||||||||
5 | Q-Occupation | /* QCODE - Position (Q82955) Journalist (Q1930187) author (Q36180) */ | |||||||||
6 | RefURL1(occ) | /* Best reference URL of occupation looked up today */ | |||||||||
7 | RefURL2(occ) | /* 2nd Best reference URL of occupation looked up today */ | |||||||||
8 | RefURL3(hum) | /* 3nd Best reference URL of occupation looked up today */ | |||||||||
9 | VIAF | /* VIAF id from viaf.org if can be found (optional) */ | |||||||||
10 | Q-Citizenship | /* QCODE for citizenship (optional) */ | |||||||||
11 | |||||||||||
12 | CREATE | ||||||||||
13 | LAST | Len | =CONCATENATE("""",B2,"""") | /* dbg:LAST⇒Qcode */ | |||||||
14 | =A13 | Den | =CONCATENATE("""",B3,"""") | ||||||||
15 | =A13 | P31 | Q5 | =IF(ISBLANK(B8),"","S854") | =IF(ISBLANK(B8),"",CONCATENATE("""",B8,"""")) | =IF(ISBLANK(B8),"","S813") | =IF(ISBLANK(B8),"",$B$1) | ||||
16 | =A13 | P21 | =IF(ISBLANK(B4),"Q6581097","Q6581072") | ||||||||
17 | =A13 | Senwikiquote | =CONCATENATE("""",B2,"""") | ||||||||
18 | =IF(ISBLANK(B9),"",A13) | =IF(ISBLANK(B9),"","P214") | =IF(ISBLANK(B9),"",CONCATENATE("""",B9,"""")) | ||||||||
19 | =IF(ISBLANK(B10),"",A13) | =IF(ISBLANK(B10),"","P27") | =B10 | ||||||||
20 | =A13 | P106 | =B5 | S854 | =CONCATENATE("""",B6,"""") | S813 | =$B$1 | =IF(ISBLANK(B7),"","!S854") | =IF(ISBLANK(B7),"",CONCATENATE("""",B7,"""")) | =IF(ISBLANK(B7),"","S813") | =IF(ISBLANK(B7),"",$B$1) |
While P106 seemed fail to go in Q116369973 was created. Cell B13 can be changed from LAST to Q116369973 and than will propogate to all rows as additional statements now need to be run against Q116369973 and not last. I can then try the following statement (the "tabbed" version from the spreadsheet is needed not the raw tab-expanded version below):
Q116369973 P106 Q3665646 S854 "https://www.theguardian.com/global-development/gallery/2020/dec/17/we-rise-by-lifting-others-outstanding-women-of-zimbabwe-in-pictures" S813 +2023-01-24T00:00:00Z/11 !S854 "https://www.herald.co.zw/afrobasket-preps-confusion/" S813 +2023-01-24T00:00:00Z/11
When I has that as QS batch B112223 it didn't seem to honour the "!" in front of the S854 in the way I hoped it would but added both urls in to the same reference URL value ... see: [1]. At this point I am going to fix manually and have another cup of tea. Moral of story: Avoid using REF-url2(occ) for the moment and keep it blank. Should have read my own warning about ending up in a heap!