reibleetsak Posted November 4, 2023 Share Posted November 4, 2023 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. Link to post Share on other sites More sharing options...
Wolf_pd Posted November 4, 2023 Share Posted November 4, 2023 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. Link to post Share on other sites More sharing options...
reibleetsak Posted November 4, 2023 Author Share Posted November 4, 2023 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? Link to post Share on other sites More sharing options...
Samuel77 Posted November 4, 2023 Share Posted November 4, 2023 There are some websites that have all the data (players, clubs, countries, etc.) like sortitoutsi. Have they imported everything manually? Link to post Share on other sites More sharing options...
reibleetsak Posted November 4, 2023 Author Share Posted November 4, 2023 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. Link to post Share on other sites More sharing options...
Wolf_pd Posted November 4, 2023 Share Posted November 4, 2023 They have build up their database through the years (probably), because data gets added, but gets rarely re-used in another way. Link to post Share on other sites More sharing options...
forameuss Posted November 4, 2023 Share Posted November 4, 2023 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) Link to post Share on other sites More sharing options...
reibleetsak Posted November 5, 2023 Author Share Posted November 5, 2023 Thanks again for the replies. Guess I will just have to accept that exporting the Club UID is not possible. Link to post Share on other sites More sharing options...
Noscho Posted November 8, 2023 Share Posted November 8, 2023 (edited) 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 1 Link to post Share on other sites More sharing options...
Wolf_pd Posted November 8, 2023 Share Posted November 8, 2023 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 Link to post Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now