{"id":119,"date":"2021-08-08T16:59:43","date_gmt":"2021-08-08T16:59:43","guid":{"rendered":"https:\/\/blogs.scummvm.org\/av-dx\/?p=119"},"modified":"2021-08-08T16:59:43","modified_gmt":"2021-08-08T16:59:43","slug":"making-use-of-games-database-week-9-progress","status":"publish","type":"post","link":"https:\/\/blogs.scummvm.org\/av-dx\/2021\/08\/08\/making-use-of-games-database-week-9-progress\/","title":{"rendered":"Making use of games database (Week 9 progress)"},"content":{"rendered":"\n

Task 1 : Adding more grouping methods<\/h2>\n\n\n\n

Just like with the grouped list, the next task is to get more groups working with the grid. I added a popup widget to select the grouping method and added few more grouping methods.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Task 2: Fix formatting issues<\/h2>\n\n\n\n

In the last picture, 2 things are very clearly wrong, there is way too much space in the middle, and the entries are trying to draw themselves outside of their bounds and on top of the scrollbar. What is not visible here is that counter-intuitively, clicking on the triangle does nothing, its not part of the header. So I fixed all these formatting issues.<\/p>\n\n\n\n

\"\"
Also some additional formatting to group headers<\/figcaption><\/figure>\n\n\n\n

Task 3: Use the ScummVM database to improve the grouping<\/h2>\n\n\n\n

As mentioned in my last post, ScummVM maintains a database of games, both as a Google Sheet, and in .YAML format in the scummvm-web (website) repository. I was able to grab the .YAML files and convert them to .XML with some Regex, then use the implemented XMLParser to inherit a MetadataParser class to read in the database. This allows us to display fields which aren’t captured in the config.ini file, and to provide full names to fields of which only ID’s are stored in the config.<\/p>\n\n\n\n

\"\"
Sort by Series<\/figcaption><\/figure>\n\n\n\n
\"\"
Sort by Engine, now with full names<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Task 1 : Adding more grouping methods Just like with the grouped list, the next task is to get more groups working with the grid. I added a popup widget to select the grouping method and added few more grouping methods. Task 2: Fix formatting issues In the last picture, 2 things are very clearly… Continue reading Making use of games database (Week 9 progress)<\/span><\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-119","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/posts\/119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/comments?post=119"}],"version-history":[{"count":1,"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/posts\/119\/revisions"}],"predecessor-version":[{"id":125,"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/posts\/119\/revisions\/125"}],"wp:attachment":[{"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/media?parent=119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/categories?post=119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.scummvm.org\/av-dx\/wp-json\/wp\/v2\/tags?post=119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}