How to extract Club's UID from game or Editor

[reibleetsak]

I have been looking for a way to export Club data including UID to, preferably, RTF.

I used the search function but was anable to find an existing topic that could help me.

Does anyone know of a way to export this data?

Any help or pointers in the right direction would be greatly appreciated.

[Wolf_pd]

In short, you can't do it with all data, without changing some.

The UID can be exported to XML if you make a change to a club. However, that will only mean you have the club UID and the specific change and nothing else.

[reibleetsak]

Thanks for the reply.

Somehow I can not seem to be able to export the club UID even when exporting a change.

Example: I add an underscore(_) to the name of a club. Then export the change to xml. That gives me the following output:

<record>
    <list id="verf"/>
    <list id="db_changes">
        <record>
            <integer id="database_table_type" value="3"/>
            <large id="db_unique_id" value="7456063227592"/>
            <unsigned id="property" value="1131307373"/>
            <string id="new_value" value="R. Madrid_"/>
            <integer id="version" value="3509"/>
            <integer id="db_random_id" value="492859430"/>
            <string id="odvl" value="R. Madrid"/>
            <boolean id="is_client_field" value="true"/>
            <boolean id="is_language_field" value="true"/>
        </record>
    </list>
    <integer id="version" value="3509"/>
    <integer id="rule_group_version" value="1503"/>
    <boolean id="beta" value="false"/>
    <string id="orvs" value="2340"/>
    <string id="svvs" value="2340"/>
</record>
 

In this case I used Real Madrid. The UID of Real Madrid is 1736. This value is nowhere to be found in the xml.

Am I overlooking something?

[Samuel77]

There are some websites that have all the data (players, clubs, countries, etc.) like sortitoutsi. Have they imported everything manually?

[reibleetsak]

I can't imagine the amount of time it would take to import all club data manually. So I would assume they use some other way.

[Wolf_pd]

They have build up their database through the years (probably), because data gets added, but gets rarely re-used in another way.

[forameuss]

3 hours ago, reibleetsak said:

Thanks for the reply.

Somehow I can not seem to be able to export the club UID even when exporting a change.

Example: I add an underscore(_) to the name of a club. Then export the change to xml. That gives me the following output:

<record>
    <list id="verf"/>
    <list id="db_changes">
        <record>
            <integer id="database_table_type" value="3"/>
            <large id="db_unique_id" value="7456063227592"/>
            <unsigned id="property" value="1131307373"/>
            <string id="new_value" value="R. Madrid_"/>
            <integer id="version" value="3509"/>
            <integer id="db_random_id" value="492859430"/>
            <string id="odvl" value="R. Madrid"/>
            <boolean id="is_client_field" value="true"/>
            <boolean id="is_language_field" value="true"/>
        </record>
    </list>
    <integer id="version" value="3509"/>
    <integer id="rule_group_version" value="1503"/>
    <boolean id="beta" value="false"/>
    <string id="orvs" value="2340"/>
    <string id="svvs" value="2340"/>
</record>
 

In this case I used Real Madrid. The UID of Real Madrid is 1736. This value is nowhere to be found in the xml.

Am I overlooking something?

This is how I've been doing it.  For single objects, you're probably good doing this.  In bulk though, you'll likely need to do something on the other end to parse everything you're getting out.  I wanted to extract all the person names in the database for certain nationalities, and did that by selecting all objects, changing the name to something fixed, then exporting (which takes the editor a looooong time to achieve.  Once you've exported the XML, you can use Python to get rid of all the stuff you don't care about and extract each name.  Wouldn't take too much to change that to extract the db_unique_id value, or even to assign that value to a specific name.  

Would also add though, if you're assigning, for example, Real Madrid to some value in the database, then it uses two different IDs, the db_unique_id, and a "short" id.  I'm not sure yet whether you even need the short_id for the editor to accept it (you don't need db_random_id on import, for example)

[reibleetsak]

Thanks again for the replies.

Guess I will just have to accept that exporting the Club UID is not possible.

[Noscho]

I've been searching for this for years but couldn't be able to find a solution using the official editor.

However, there's a workaround using a 3rd party tool. Genie Scout let's you export data to CSV, and this data can include UIDs.

You can use this data and with a minor work in Excel, you get this;

I've been editing my own "real name / colors fix" for 3 years using this method

I haven't done this for FM24, but I can share my file for last year if you want.

 

Edited November 8, 2023 by Noscho

[Wolf_pd]

12 hours ago, Noscho said:

I've been searching for this for years but couldn't be able to find a solution using the official editor.

However, there's a workaround using a 3rd party tool. Genie Scout let's you export data to CSV, and this data can include UIDs.

You can use this data and with a minor work in Excel, you get this;

I've been editing my own "real name / colors fix" for 3 years using this method

I haven't done this for FM24, but I can share my file for last year if you want.

Officially we can't discuss 3rd party tools on this forum. Just so you know