Wikidata:Property proposal/StopGame ID

From Wikidata
Jump to navigation Jump to search

StopGame ID[edit]

Originally proposed at Wikidata:Property proposal/Creative work

   Done: StopGame ID (P10030) (Talk and documentation)
Descriptionidentifier of a video game at the website Stopgame.ru
RepresentsStopGame (Q72406450)
Data typeExternal identifier
Domainvideo game (Q7889)
Allowed values[a-z0-9_]+
Example 1The Last of Us Part II (Q27950674)last_of_us_2
Example 2The Last of Us (Q1986744)last_of_us_the
Example 3Resident Evil Village (Q96216515)resident_evil_village
Example 4Control (Q54935655)control
Example 5The Callisto Protocol (Q104172915)callisto_protocol
Sourcehttps://stopgame.ru/games
External linksUse in sister projects: [ar][de][en][es][fr][he][it][ja][ko][nl][pl][pt][ru][sv][vi][zh][commons][species][wd][en.wikt][fr.wikt].
Expected completenessalways incomplete (Q21873886) 16454
Formatter URLhttps://stopgame.ru/game/$1
Robot and gadget jobsConsidering the size of this database, yes, a separate mix'n'match catalogue is mandatory required.
See alsoIgromania ID (P6827)
Applicable "stated in"-valueStopGame (Q72406450)
Distinct-values constraintYes
Wikidata projectWikiProject Video games (Q8485882)

Motivation[edit]

applsdev Arlo Barnes BugWarp Coloradohusky CptViraj Cupkake4Yoshi Cwf97 Cynde Moya Danrok Datumizer Dexxor Diggr Dispenser Dollarsign8 DoublePendulumAttractor EdoAug Edolusill Eniehack Facenapalm Floyd-out FullyAwesome Harshrathod50 Jean-Frédéric Jotamide Keplersj Kirilloparma Lewis Hulbert LotsofTheories Macocobovi Macrike Master Of Ninja Matthias M. Metafire18 Nicereddy Nw520 Oduci Poslovitch Rampagingcarrot RampantSpirit Sanqui Santer Sight Contamination Sir Lothar thgiex Tomodachi94 VGPaleontologist Wd-Ryan WikiSyn YotaMoteuchi

Notified participants of WikiProject Video games

StopGame (Q72406450), like Igromania (Q4197757), is a major Russian-language video game news and reviews website that is also considered as reliable source on ruwiki (see here). Kirilloparma (talk) 01:00, 14 October 2021 (UTC)[reply]

Discussion[edit]

@Jean-Frédéric: Unfortunately this is not a numeric identifier :(. Everything that starts with /show/ slug is just different section of the StopGame website, examples: video review, game solutions, article and etc. – all these numeric identifiers, as you can see, differ from each other. So, yeah, unfortunately StopGame does not have a numeric identifier for video games. Regards Kirilloparma (talk) 20:46, 14 October 2021 (UTC)[reply]
Other example: [1], [2], [3], [4], [5], [6],[7], [8], [9], [10] etc. Regards Kirilloparma (talk) 21:45, 14 October 2021 (UTC)[reply]
@Kirilloparma: Thanks for the research and the answer :) Jean-Fred (talk) 14:13, 15 October 2021 (UTC)[reply]
@Kirilloparma, Poslovitch, Jean-Frédéric, Sir Lothar: ✓ Done StopGame ID (P10030) Pamputt (talk) 19:59, 2 November 2021 (UTC)[reply]
@Pamputt: Thanks for creating the property, however I don't find mix'n'match catalogue which was mandatory required. Has it already been created? Regards Kirilloparma (talk) 23:41, 2 November 2021 (UTC)[reply]
@Kirilloparma: It has not yet been created to my knowledge. Usually it is necessary to have the property number in order to create the catalogue, so this can now be done. Pamputt (talk) 06:58, 3 November 2021 (UTC)[reply]
@Pamputt: Alright, could you please create it, because unfortunately I can't do it on my own, I tried to create it many times, but to no avail. By the way you can create a mix'n'match catalogue even if the property does not exist yet (example). Regards Kirilloparma (talk) 00:41, 6 November 2021 (UTC)[reply]
@Kirilloparma: actually it is not really easy to me to create the catalogue because I do not speak Russian. So I do not know how to find where I can download all the database of the website so that I can convert it to Mix'n'Match. Pamputt (talk) 08:21, 6 November 2021 (UTC)[reply]
@Pamputt: Here is the link. You can also try this link in order to scrape all the games. The games are arranged in alphabetical order (Latin script): from a to z, from 1 to 9 and from А to Я (in Russian). I'm really sorry if I bother you. I wish I could create the catalogue by myself, but I do not understand how to do this. There are no clear instructions or videos on how to do it correctly either. I have already created 6 catalogues for the test (see [11], [12], [13], [14], [15], [16]), however it didn't work for me. Regards Kirilloparma (talk) 03:54, 7 November 2021 (UTC)[reply]
@Kirilloparma: Actually, what is needed is a text file (for example a CSV file) that contains all the games (one game by line for example). It is really painful (or I do not know how to do it) if we have only the list of the games in different web pages. Pamputt (talk) 09:49, 7 November 2021 (UTC)[reply]
@Pamputt: Here. I have scraped about + 17 000 entries with necessary information like name and description. You can also download it as .csv or .tsv file. This should be enough to create a new catalogue. I did my best and I can't do more than that. I have already helped as much as I could. I also tried again to create catalogue on my own using this completely pointless instruction with no clear example. Absolutely no result. The only thing I get is an endless message Test is running... even if I only test five entries. I have no idea what's wrong here ... Regards Kirilloparma (talk) 05:32, 8 November 2021 (UTC)[reply]
So far, I also get the "Test is running" message. There is maybe a problem on the server. I will retry later. Pamputt (talk) 06:57, 10 November 2021 (UTC)[reply]
@Kirilloparma: I've created the catalog 4884. Currently, the data are being imported. So the full catalog should be available in the next hours. Pamputt (talk) 09:28, 13 November 2021 (UTC)[reply]
@Pamputt: Thank you! I can see that the data is imported correctly. Thank you also for adding the type constraint for the video game series, but unfortunately this identifier is not intended for this, since the website is entirely dedicated to video games only. Regarding the previous comment I noticed that they fixed the problematic message, so now the import function works as expected. The only thing i don't understand is how the catalog can be updated with new entries in the future? To do this, it seems to me, I will need to scrape the data again (from the beginning to the end), and only then, probably, the import function itself will detect new entries. Isn't it? Regards Kirilloparma (talk) 04:09, 14 November 2021 (UTC)[reply]
Ok, I removed the constraint for the video game series. I added it for 7.62 (Q108370490) but I might be wrong when I added StopGame ID (P10030) to this item.
About updating the catalog, it would be done automatically each time we update the Google Doc spreadsheet if I've decided to import the catalog using the spreadsheet URL. Unfortunately, for testing reason, I did it from a CSV file. So in the future, we can easier import a new CSV file and Mix'n'match will add the new entries to the catalog or point to the Google Spreadsheet and Mix'n'match will update the catalog periodically when it will detect the spreadsheet has been updated. Pamputt (talk) 08:06, 14 November 2021 (UTC)[reply]