Steam APP Id Field for Games?

A place to talk about whatever you want.
Post Reply
maltenf
Posts: 7
Joined: Fri Mar 05, 2021 2:11 am

Steam APP Id Field for Games?

Post by maltenf »

Hi!

Currently Im matching the games between thegamesdb and steam via "Title" with removed special chars, spaces, and uppercase.

A field when we add or modify games here we can fill out for external ids would be handy for that.

So I was wondering if others here were interested in this and if this could be added in a later version?

For example like that in the json:

Code: Select all

{
	"externalIds": {
		"STEAM": "12335465",
		"EPIC": "1322434455",
		"PSN": "3244324334" // not sure about that
		// etc...
	}
}

Best,

Malte

PeteOC
Posts: 60
Joined: Fri Jul 10, 2020 3:05 pm

Re: Steam APP Id Field for Games?

Post by PeteOC »

This is a good recommendation - I've added it as a feature request on github - https://github.com/TheGamesDB2/Website/issues/34

Fidelia
Posts: 1
Joined: Tue May 28, 2024 2:21 am

Re: Steam APP Id Field for Games?

Post by Fidelia »

maltenf wrote:
Sat Mar 30, 2024 7:06 pm
Hi!

Currently Im matching the games between thegamesdb and steam via "Title" with removed special chars, spaces, and uppercase.

A field when we add or modify games here we can fill out for external ids would be handy for that.

So I was wondering if others here were interested in this and if this could be added in a later version?

For example like that in the json:

Code: Select all

{
	"externalIds": {
		"STEAM": "12335465",
		"EPIC": "1322434455",
		"PSN": "3244324334" // not sure about that
		// etc...
	}
}

Best,

Malte
That's a great suggestion! Having a dedicated field to store external IDs for games would be extremely helpful, especially for tasks like the one you're working on - matching games between databases using title information.

wandering
Posts: 1
Joined: Wed Oct 02, 2024 8:36 am

Re: Steam APP Id Field for Games?

Post by wandering »

It sounds like you're working on improving game matching across databases (TheGamesDB and Steam) based on cleaned-up titles. Having an external ID field would indeed be helpful to streamline the process, making it easier to track and match games across different platforms by their unique identifiers rather than relying solely on the title, which can sometimes be inconsistent.

maltenf
Posts: 7
Joined: Fri Mar 05, 2021 2:11 am

Re: Steam APP Id Field for Games?

Post by maltenf »

For those waiting for the feature - here is my "SteamAppService" Implementation so far - it works 80% of the time but with a failure in name matching
Its in c# tho.


ToAliasName() Method:

Code: Select all

 public static string GenerateGameAliasName(this string title)
 { 
     return Regex.Replace(title, @"[^0-9a-zA-Z:-;,?ß]+", "__").ToUpper();
 }
 
Usage:

Code: Select all


//Gien that full alias name was used (title-<last releaseyear) it should find one
var res2 = await this._SteamAppsRepository.GetOneByCustomCriteriaAsync(x => x.AliasName == fullAlias);

if (res2 != null)
{
    return res2;
}


// Given that alias was saved without release date or release date does not match we check if only one result returned by querying for StartsWith
var res = await this._SteamAppsRepository.GetManyByCustomCriteria(x => x.AliasName != null && x.AliasName.StartsWith(title2)).ToListAsync();

if (res.Count == 1)
{
// We only got one result so we asume this the correct one 
    return res.First();
}

// We got more than one or we got zero results.  Safer to return null so we dont mess things up.
return null;

Post Reply