query-f911fb5adba9ab95424773eafb334628
Looking for a tool for altering descriptions in multiple languages 22:08, 29 July 2022 (UTC)) talk (Jarekt. Is there some tool which would make that task easier than editing 50 descriptions one by one? (P217)inventory number ) of the title is impossible without first altering descriptions of other items, often requiring changes in multiple languages one does not speak. The cleanest solution is to add something unique and language independent to all the descriptions like the year of creation or this, and any attempt to add a new translation (like (Q148475)Jean-Baptiste Camille Corot are all paintings with the same title by (Q17331798)Landscape and (Q18178206)Landscape. , (Q20792242)Landscape Artworks often get standard labels and descriptions. The title of the artwork usually is used as label and standard description like "painting by ..." is used as description. The problem is that Wikidata will block adding titles to items if the same title/description is used on other item. I run often into this issue when the same author creates multiple paintings or sculptures with the same title. In such cases a bot adds standard description in 50 languages which blocks any attempts of adding titles in those languages. For example 00:21, 30 July 2022 (UTC)) talk (Tagishsimon - put the third column into an editor, search & replace QQQ with a tab, bung it in quickstatements & you're good. --https://w.wiki/5WtnAbsent a tool, I'd be inclined to knit a SPARQL query which'll emit Quickstatements. In this example - 03:03, 30 July 2022 (UTC)) talk (Jarekt, That is an excellent idea. I modified your query a bit so that I can pick either description alteration by year or by inventory number and can cut an paste directly from the query output. Thanks. --Tagishsimon
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT ?QID ?Dlang ?desc2
WHERE
{
VALUES ?item { wd:Q17331798 }
?item schema:description ?description .
?item wdt:P217 ?inv .
?item wdt:P571 ?date .
bind(str(YEAR(?date)) as ?year)
BIND(LANG(?description) as ?lang)
bind(strafter(str(?item),"http://www.wikidata.org/entity/")as ?QID)
bind(concat("D",?lang) as ?Dlang)
bind(concat('"',?description," (",?inv,')"') as ?desc1)
bind(concat('"',?description,", ",?year,'"') as ?desc2)
}