User:Djm-leighpark/HOWTO

Add a TV series season to Wikidata with Quickstatments sitelinking to WQ
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: 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):
 * 1) Len - The name of the Wikiquote article. (B2)
 * 2) Q999111222333 : The Wikidata qcode of the master article. (A6)
 * 3) The season number which must be in quotes.  This is "2" below. (E6)
 * 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
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
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!!!

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:. 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!