Popular Post krlenjushka Posted January 30, 2021 Popular Post Share Posted January 30, 2021 (edited) I created mini Windows app for faster generating of FM Editor data. This has always been an obstacle - especially when it comes to a huge amount of data. I know this from personal experience because I also added 1500 clubs - one by one. Never again! With this program you can add that in just 1 minut. Of course you need to have that data stored somewhere. For my own data i use Excel - because its easy to work with lot of data and you can use numerous Excel formulas. I have plans to expand this to some people types (player, non-player, player/non player and official), awards, media sources. Also i want to create option to add club league history and club kits. For this i will need more time of course. In the next few days, I will try to make a better tutorial - if necessary. The app is easy to use and there should be no problem with that. The only problem can be creating an input file because everyone who wants to do it will have to understand what it must look like and in what form the individual data must be. In order to use this app you need to install Python to your Windows. When you do that you can download my app. Download link is at the bottom of this post. Extract zip file somewhere on disc D. I had some problems running this app on disc C probably because it uses batch script and Windows 10 wont work always with batch - who knows why. You have shortcut in main folder so you can send it to your desktop in order to use it easier. Same thing you can do with Input-Output folder. Bellow you have a brief explanation of how adding 5 clubs works with data for the full name of the club, city and stadium. Lets say you have 5 clubs in your excel sheet with added full name of the club, city and stadium. Remember all data that are record types in editor like cities, stadiums, clubs, competitions, nations... must be added to your excel in uid form. You cant set city of your club only with name of that city. Editor will recognize UID - not name. As you can see i added same city uid and same stadion uid - not important because this is only example. This is how your sheet should look like before you copy data to input.txt file. Why do I have 2 UID columns at the beginning? Because i need first column for "Add club" option in my APP. Just like when you click in editor to ADD club. Editor will add empty club with UID only. I added an uid column in front of each data column you want to add. This is important now - every other data need to have UID column and value column. So lets say we want to add clubs name. We need clubs UID so editor can recognize club - and we need clubs name. Same for every other data. Now we can create input.txt file. Check how record types form should look like - explanation is added to this file. Record_types_form_for_input_file.txt Copy your columns from excel to input.txt file. Its located in Input-Output folder. BTW this is only folder you need. This is how input.txt looks like - same data like you have in excel. When you copy your data from excel to txt file data columns are delimited with TAB - this is needed in order to generate data in proper way. Save input.txt and we are ready to use FM21 Editor Generator!!! If you installed Python start my APP. You will get this window. Its set by default to clubs but you can change tab if you want to add different kind of data. So we decided to add clubs name, city and stadium. Thats why we will mark those 3 options in program. Mark "Input.txt file is ready" and click on "Generate Script". You must mark this checkbox because script will not be created in proper way without this. Thats why i added this in order to remind you to check your input file. You will see blinking of the python scripts for 4-5 seconds and at the end you will get popup message: Click OK - in my case "U redu" - i use Serbian language Windows This means your script is ready to use. Click on "Generate Output File" and your output file with generated clubs is created. You will get popup message about that. Again click OK. Now when you check in Input-Output folder you will have Club_Output.txt file. In that file you will have generated clubs in XML mode. All you need is to copy content of this file to your lower league xml file and to load it in editor. I will explain this also for users who doesnt know how to copy this to xml. After this you should click on "Delete Created Script" in order to reset script file. Its used for generating of all record types here so it will not work if you keep old data in it. You have checkbox called "auto delete created script" if you are not sure you will remember to delete it. Thats all for now. I hope you will enjoy using this program and save a lot of time and nerves If you find any error please let me know so i can fix it asap. If you have any question - feel free to ask. I want to thank @emersonjr for pointing me in the right direction. Thanks buddy!!! EDIT 6.2.2021. Application is updated to version 1.1 because i had some issues with generating script - whoever had same issues - please download new version. I added new option to generate XML from output file (click this button after you generate output file) so you can load XML in editor without any editing. FM21 Editor Generator version 1.1 EDIT 25.12.2022. Application is updated to FM23 version. I added some basic things for players and changed some minor issues. Also no need to add UID in every second column anymore. First column is enough. I had some issues with Python so i recommend version 3.9.1 for installation. You can download it here: python-3.9.1-amd64.exe Text file with explanation about record types for input file: FM23 Editor Generator - record types form for input file.txt FM23 Editor Generator Version 1.0 Edited April 4, 2023 by krlenjushka 25 Link to post Share on other sites More sharing options...
wkdsoul Posted January 30, 2021 Share Posted January 30, 2021 Awesome! Link to post Share on other sites More sharing options...
oche balboa Posted January 30, 2021 Share Posted January 30, 2021 Wow this will be incredible 1 Link to post Share on other sites More sharing options...
krlenjushka Posted January 31, 2021 Author Share Posted January 31, 2021 I have working program now. I created everything needed for the clubs. Tested several times without issues. Still have lot of work - not only with program itself. I need to create some tutorial and instructions for this. Link to post Share on other sites More sharing options...
krlenjushka Posted February 1, 2021 Author Share Posted February 1, 2021 Cities generator is also finished. I will create stadium generator now and i will probably release version 1.0 in next couple hours. 3 Link to post Share on other sites More sharing options...
Ivs Posted February 1, 2021 Share Posted February 1, 2021 Really awesome idea! Two questions: 1. In the clubs section I didn't see any history option. May it be possibile to add history through this tool? 2. Is it something exclusive for FM21 at the moment? Are you planning to make it retrocompatible with older FM versions? Thank you for the effort you're putting. Link to post Share on other sites More sharing options...
krlenjushka Posted February 1, 2021 Author Share Posted February 1, 2021 8 minutes ago, Ivs said: Really awesome idea! Two questions: 1. In the clubs section I didn't see any history option. May it be possibile to add history through this tool? 2. Is it something exclusive for FM21 at the moment? Are you planning to make it retrocompatible with older FM versions? Thank you for the effort you're putting. Probably not because i need to change input files. For some record types its not problem because there isnt many options but for players - its huge job. So many options. I must check how history is added to xml. I have some small issues now - thats why i must move release for 1 day i hope. Link to post Share on other sites More sharing options...
krlenjushka Posted February 1, 2021 Author Share Posted February 1, 2021 1 hour ago, krlenjushka said: I must check how history is added to xml. i just checked - history is complicated to add like this just like kits because old values are written to xml code after every change. I dont know why this is coded like this - probably some limitations related to xml itself. For one year of history you have 11 settings - 12 if we count order settings but i guess its not used often. So just to explain - in order to set this you will have to create input and output file 11 times. Just for 1 year. First time you will set only year. Scond time you will set year and division. Third time you will set year, division and position. All this is needed in order to generate proper xml record with old values just like when editor creates that. I mean its possible but its not easy like some other things in ditor. If you have 1000 clubs to add history its better to spend 1 day for 1 year of history - much much faster than manual editing. . I mean this can be done with this but preparation for input files will be complicated. Link to post Share on other sites More sharing options...
Ivs Posted February 1, 2021 Share Posted February 1, 2021 Is this the same for clubs' cup history? It should require less settings. Link to post Share on other sites More sharing options...
krlenjushka Posted February 1, 2021 Author Share Posted February 1, 2021 3 hours ago, Ivs said: Is this the same for clubs' cup history? It should require less settings. Not sure how this should be set - is there any club in default database with added cup history? Link to post Share on other sites More sharing options...
Ivs Posted February 2, 2021 Share Posted February 2, 2021 No, I don't know any default cup history data set for clubs in the vanilla db. Link to post Share on other sites More sharing options...
krlenjushka Posted February 2, 2021 Author Share Posted February 2, 2021 21 minutes ago, Ivs said: No, I don't know any default cup history data set for clubs in the vanilla db. Dont worry i will set this for league history. You will have to run this multiple times but still its much much faster than regular way. For how many clubs you want to add history? How many seasons? Link to post Share on other sites More sharing options...
Ivs Posted February 2, 2021 Share Posted February 2, 2021 300/400 clubs. Probably 30/40 seasons or even less. Link to post Share on other sites More sharing options...
krlenjushka Posted February 2, 2021 Author Share Posted February 2, 2021 You will add all history data except "order" i guess? Link to post Share on other sites More sharing options...
Ivs Posted February 2, 2021 Share Posted February 2, 2021 Are you wondering if I'll going to import the history data in no particular season order? If so, well I'm not afraid to import data randomly because there will be no problem in game, is that correct? Link to post Share on other sites More sharing options...
krlenjushka Posted February 2, 2021 Author Share Posted February 2, 2021 11 minutes ago, Ivs said: Are you wondering if I'll going to import the history data in no particular season order? If so, well I'm not afraid to import data randomly because there will be no problem in game, is that correct? Not sure about that. I never tried to add league history i think. Maybe for few clubs only. I tried to add years like this - 2015,2012,2014 and editor sorted them after that. Link to post Share on other sites More sharing options...
Ivs Posted February 2, 2021 Share Posted February 2, 2021 Yes, it usually does it with no problem. I tried to insert history manually in no particular order in the past and the editor automatically sorted it. It's the same in-game. Link to post Share on other sites More sharing options...
krlenjushka Posted February 2, 2021 Author Share Posted February 2, 2021 4 minutes ago, Ivs said: Yes, it usually does it with no problem. I tried to insert history manually in no particular order in the past and the editor automatically sorted it. It's the same in-game. You have all data in excel? Link to post Share on other sites More sharing options...
Ivs Posted February 2, 2021 Share Posted February 2, 2021 No, not yet. Link to post Share on other sites More sharing options...
alian62 Posted February 3, 2021 Share Posted February 3, 2021 Is this released yet as i cant see the link Link to post Share on other sites More sharing options...
krlenjushka Posted February 3, 2021 Author Share Posted February 3, 2021 3 hours ago, alian62 said: Is this released yet as i cant see the link Not yet. I wanted to do this last night but i need to change something so probably today when i get back home from work. Still have to add stadium generaor but this shoudnt take much time. After that i need to add players - this will be more difficult because there is so many options there... Link to post Share on other sites More sharing options...
krlenjushka Posted February 3, 2021 Author Share Posted February 3, 2021 FM Editor Generator version 1.0 is released!!! Download link is added to first post. Enjoy! 5 Link to post Share on other sites More sharing options...
sporadicsmiles Posted February 4, 2021 Share Posted February 4, 2021 This is awesome. One of the best tools I have ever seen posted on the forums, ever. I do have a question. How feasible would it be to extend to deal with a little random generation from some given inputs? In particular I'm interested in filling teams without players for my Africa file, since the game does a poor job at this generally. I have had thoughts on creating something like this before, but I have never gotten around to it. My idea would be to supply a pool of names to choose from, a range for the CA and PA, a nationality, and a club to which they are contracted to. Then you hit "go" and X number of players (you specify how many) are generated with random names, ages, CA and PA. I'd worry about positions later, or I would just let FM handle the distribution of the positions. I ask because as I said this has been on my radar for a while, and I have made the first steps to programming this. However if it is reinventing the wheel to something your program can already do or would be easy to get it to do, better to ask. Link to post Share on other sites More sharing options...
krlenjushka Posted February 4, 2021 Author Share Posted February 4, 2021 2 hours ago, sporadicsmiles said: This is awesome. One of the best tools I have ever seen posted on the forums, ever. Thanks i really appreciate this. 2 hours ago, sporadicsmiles said: I do have a question. How feasible would it be to extend to deal with a little random generation from some given inputs? In particular I'm interested in filling teams without players for my Africa file, since the game does a poor job at this generally. I have had thoughts on creating something like this before, but I have never gotten around to it. My idea would be to supply a pool of names to choose from, a range for the CA and PA, a nationality, and a club to which they are contracted to. Then you hit "go" and X number of players (you specify how many) are generated with random names, ages, CA and PA. I'd worry about positions later, or I would just let FM handle the distribution of the positions. I ask because as I said this has been on my radar for a while, and I have made the first steps to programming this. However if it is reinventing the wheel to something your program can already do or would be easy to get it to do, better to ask. I also tried to add players only with names-i generated player names and surnames using names and surnames from serbian default database and ratio. After that i added CA,PA and nation and game handled everything else. Player position were perfect, years , height and weight also. I have plans to fill my lower league teams with fictional players so answer is yes - i can create something like this for our needs Link to post Share on other sites More sharing options...
sporadicsmiles Posted February 4, 2021 Share Posted February 4, 2021 2 minutes ago, krlenjushka said: I have plans to fill my lower league teams with fictional players so answer is yes - i can create something like this for our needs That is fantastic! I will look forward to updates on that, I think this will be a real game changer for making league systems where the database is incomplete. Link to post Share on other sites More sharing options...
krlenjushka Posted February 4, 2021 Author Share Posted February 4, 2021 Just now, sporadicsmiles said: That is fantastic! I will look forward to updates on that, I think this will be a real game changer for making league systems where the database is incomplete. Lets hope so. I know for some people creating of input file is complicated but i simply dont know how to make this easier. I guess they shoudnt try to create big league systems if they cant sort their data in excel Link to post Share on other sites More sharing options...
Wolf_pd Posted February 4, 2021 Share Posted February 4, 2021 1 hour ago, krlenjushka said: I guess they shoudnt try to create big league systems if they cant sort their data in excel Had a good laugh about it, but , yeah, you are right. Big plans need good organisation. Link to post Share on other sites More sharing options...
krlenjushka Posted February 4, 2021 Author Share Posted February 4, 2021 I changed this app to exe file so no need to install AutoHotKey anymore. Only Python installation is required. Also i changed download link because i have some issues with mediafire upload server. Link to post Share on other sites More sharing options...
krlenjushka Posted February 6, 2021 Author Share Posted February 6, 2021 Had some issues with generating scripts. Application is updated to version 1.1 - whoever had same issues - please download new version. I added new option to generate XML from output file (click this button after you generate output file) so you can load XML in editor without any editing. I will try to add function where you can add new generated data directly to your XML file created earlier with editor. Still dont know how to set this but i will do my best! Thanks! Link to post Share on other sites More sharing options...
Wolf_pd Posted February 9, 2021 Share Posted February 9, 2021 What is the limit with this tool? Not that I want to test it out, but curious for things like people creating. Link to post Share on other sites More sharing options...
krlenjushka Posted February 9, 2021 Author Share Posted February 9, 2021 Just now, Wolf_pd said: What is the limit with this tool? Not that I want to test it out, but curious for things like people creating. On current version limit for record types (For record types i mean name, short name and so on) is 15 - every database change use 2 variables and i have limit of 31 variable. One variable is used to add empty club/city/stadium or whatever. This is related to some issue about number of variables i can use. For next version i will expand this number to 71. This is good because when you want to add kits you need to use almost 70 variables (read excel columns for your input file) in order to add only shirts. If you ask about clubs/cities/stadiums limit that you can add - there isnt any. I added 30000 players without any issue - for about 3 seconds. 1 Link to post Share on other sites More sharing options...
jmckay_31 Posted February 10, 2021 Share Posted February 10, 2021 On 04/02/2021 at 14:23, krlenjushka said: Thanks i really appreciate this. I also tried to add players only with names-i generated player names and surnames using names and surnames from serbian default database and ratio. After that i added CA,PA and nation and game handled everything else. Player position were perfect, years , height and weight also. I have plans to fill my lower league teams with fictional players so answer is yes - i can create something like this for our needs Any tips for running the program on Mac? I'm creating a fictional db with Gibraltar as a base and it's been a huge pain in creating the players (I'm only getting about 30/hr in the editor...) Link to post Share on other sites More sharing options...
krlenjushka Posted February 10, 2021 Author Share Posted February 10, 2021 5 hours ago, jmckay_31 said: Any tips for running the program on Mac? I'm creating a fictional db with Gibraltar as a base and it's been a huge pain in creating the players (I'm only getting about 30/hr in the editor...) TBH i dont have any knowlege about Mac. Dont worry about that - just make sure you have all data in excel - someone will help you generate your players. 2 Link to post Share on other sites More sharing options...
jmckay_31 Posted February 10, 2021 Share Posted February 10, 2021 Thanks! Don't know how to edit via excel, but I'm sure theres a guide on here somewhere Link to post Share on other sites More sharing options...
krlenjushka Posted February 10, 2021 Author Share Posted February 10, 2021 3 minutes ago, jmckay_31 said: Thanks! Don't know how to edit via excel, but I'm sure theres a guide on here somewhere I wrote quick guide how this works - if you know basics related to excel - no problem. What exactly you want to add related to players? Full names, CA, PA? Link to post Share on other sites More sharing options...
jmckay_31 Posted February 11, 2021 Share Posted February 11, 2021 (edited) 11 hours ago, krlenjushka said: I wrote quick guide how this works - if you know basics related to excel - no problem. What exactly you want to add related to players? Full names, CA, PA? Nationality and homegrown status too, but I can do homegrown via mass edit in the editor once the players are generated. If the game/file can generate age, positions, contracts, and personalities I'd be really happy. I've got three Premier division teams left to add players to and if I can figure out how to add players more quickly, I might add them to the division below too. I'm happy with the quality that the game generates for players in the third tier, so I'll just let that happen regardless. Then, it's just going to be double checking to make sure I've balanced the teams correctly and that homegrown status works for European competitions. Edited February 11, 2021 by jmckay_31 Link to post Share on other sites More sharing options...
krlenjushka Posted February 11, 2021 Author Share Posted February 11, 2021 40 minutes ago, jmckay_31 said: Nationality and homegrown status too, but I can do homegrown via mass edit in the editor once the players are generated. If the game/file can generate age, positions, contracts, and personalities I'd be really happy. I've got three Premier division teams left to add players to and if I can figure out how to add players more quickly, I might add them to the division below too. I'm happy with the quality that the game generates for players in the third tier, so I'll just let that happen regardless. Then, it's just going to be double checking to make sure I've balanced the teams correctly and that homegrown status works for European competitions. When i tested this - only full name, nation, CA and PA are important for players. Game will set everything else very good. Of course nation can be set in editor with mass edit option. Link to post Share on other sites More sharing options...
jmckay_31 Posted February 11, 2021 Share Posted February 11, 2021 1 hour ago, krlenjushka said: When i tested this - only full name, nation, CA and PA are important for players. Game will set everything else very good. Of course nation can be set in editor with mass edit option. Cool. I haven't found your excel guide and at this point I'm way out of my league. When I export the file and open it in excel, it looks like this. That's just nonsense to me Link to post Share on other sites More sharing options...
krlenjushka Posted February 11, 2021 Author Share Posted February 11, 2021 20 minutes ago, jmckay_31 said: Cool. I haven't found your excel guide and at this point I'm way out of my league. When I export the file and open it in excel, it looks like this. That's just nonsense to me Not sure what you mean by this. Just create some list in excel with player names, CA and PA. Nationality is easy to mass edit - just like homegrown status. Link to post Share on other sites More sharing options...
FCUtdWill Posted February 11, 2021 Share Posted February 11, 2021 31 minutes ago, jmckay_31 said: Cool. I haven't found your excel guide and at this point I'm way out of my league. When I export the file and open it in excel, it looks like this. That's just nonsense to me Krlenjushka’s guide is in his opening post. As he says above it’s easy to do. Link to post Share on other sites More sharing options...
jmckay_31 Posted February 11, 2021 Share Posted February 11, 2021 (edited) 2 hours ago, krlenjushka said: Not sure what you mean by this. Just create some list in excel with player names, CA and PA. Nationality is easy to mass edit - just like homegrown status. Not sure if I'm doing it right, but here's the xml, txt, and xlsx files (my computer doesn't like xml apparently) St. Brendan's players input.txt St. Brendan's players.xlsx St. Brendan's players.xml Edited February 11, 2021 by jmckay_31 Link to post Share on other sites More sharing options...
jmckay_31 Posted February 11, 2021 Share Posted February 11, 2021 2 hours ago, FCUtdWill said: Krlenjushka’s guide is in his opening post. As he says above it’s easy to do. Thanks, I actually missed it. Link to post Share on other sites More sharing options...
krlenjushka Posted February 11, 2021 Author Share Posted February 11, 2021 32 minutes ago, jmckay_31 said: Not sure if I'm doing it right, but here's the xml, txt, and xlsx files (my computer doesn't like xml apparently) St. Brendan's players input.txt 2.72 kB · 2 downloads St. Brendan's players.xlsx 11.29 kB · 1 download St. Brendan's players.xml 22.34 kB · 1 download Xlsx is good enough. Im just not sure is first /second name better option for game than full name. Adding players is not my thing. Link to post Share on other sites More sharing options...
jmckay_31 Posted February 11, 2021 Share Posted February 11, 2021 15 minutes ago, krlenjushka said: Xlsx is good enough. Im just not sure is first /second name better option for game than full name. Adding players is not my thing. Alright, updated with first/second name. St. Brendan's players.xlsx Link to post Share on other sites More sharing options...
krlenjushka Posted February 11, 2021 Author Share Posted February 11, 2021 5 hours ago, jmckay_31 said: Alright, updated with first/second name. St. Brendan's players.xlsx 11.72 kB · 1 download When you finish your list just contact me. I guess i should add those basic settings for players until you finish your list. Link to post Share on other sites More sharing options...
jmckay_31 Posted February 11, 2021 Share Posted February 11, 2021 (edited) 1 hour ago, krlenjushka said: When you finish your list just contact me. I guess i should add those basic settings for players until you finish your list. Those 84 are all I need. That will fill out the first teams of every premier league team. I just added the fmf file too, in case that makes it easier. Thanks for your help! St. Brendan's Island V1.4.fmf Edited February 11, 2021 by jmckay_31 Link to post Share on other sites More sharing options...
krlenjushka Posted February 11, 2021 Author Share Posted February 11, 2021 9 minutes ago, jmckay_31 said: Those 84 are all I need. That will fill out the first teams of every premier league team. Do you want the fmf file too? I thought you have much more. You can easy create players manualy. Who knows when im gonna release new version. Link to post Share on other sites More sharing options...
jmckay_31 Posted February 12, 2021 Share Posted February 12, 2021 10 hours ago, krlenjushka said: I thought you have much more. You can easy create players manualy. Who knows when im gonna release new version. Alright. I'll keep checking back here to see when the update comes if I decide to add second division players. Link to post Share on other sites More sharing options...
Wolf_pd Posted February 12, 2021 Share Posted February 12, 2021 On 09/02/2021 at 19:00, krlenjushka said: On current version limit for record types (For record types i mean name, short name and so on) is 15 - every database change use 2 variables and i have limit of 31 variable. One variable is used to add empty club/city/stadium or whatever. This is related to some issue about number of variables i can use. For next version i will expand this number to 71. This is good because when you want to add kits you need to use almost 70 variables (read excel columns for your input file) in order to add only shirts. If you ask about clubs/cities/stadiums limit that you can add - there isnt any. I added 30000 players without any issue - for about 3 seconds. I was talking about the latter yes. Impressive. Link to post Share on other sites More sharing options...
endlessthunder Posted February 13, 2021 Share Posted February 13, 2021 This is some amazing work. Thank you so much 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