Dinhani

@GlauberC Your instructions are correct, these two commands are necessary to install the dependencies to parse the CSV and XML files. For the path, you can use "/" as you mentioned, or in case of backslashes, you can use double backslask "\\" because single backslash have special meaning in programming languages.

@GlauberC I attached in this post the script and data for you to use. You need to adjust the value on line 13 with the path to your LaunchBox installation. Please be careful because it will read and write all you imported games and it will clear the Series field from all games before updating. Make a backup of all your data before running it. launchbox-set-series-field.py Series.csv

With some Python scripting, I was able to populate other platforms series based on Wikipedia/Wikidata data. First I exported a CSV file with all available games and series from Wikidata with this SPARQL query. Then I wrote a script that gets the WikipediaURL field from games metadata and tries to match it with the Wikipedia URL in the Series CSV file. Based on the matches I populate the Series field. Now almost all games have the field populated. The query I used in case it goes offline on Wikidata: SELECT (?Game AS ?GameID) ?GameLabel ?GameLink (?Series AS ?SeriesID) ?SeriesLabel WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' . } ?Game wdt:P31 wd:Q7889 . OPTIONAL { ?GameLink schema:about ?Game . ?GameLink schema:inLanguage 'en' . ?GameLink schema:isPartOf <https://en.wikipedia.org/> . } ?Game wdt:P179 ?Series . }

It seems that only Arcade/MAME games have the Series field populated. I was expecting to find console games like Pokemon, Donkey Kong Country, Paper Mario and several other to have this field populated, but it is always empty. Is there a way to start populating this field for non-arcade games in the official metadata database?