krlenjushka Posted February 14, 2021 Author Share Posted February 14, 2021 On 12/02/2021 at 14:39, Wolf_pd said: I was talking about the latter yes. Impressive. Unfortunately that 71 variables option doesnt work. However i managed to "fix" those 31 variables so now we can use all 31. There will be no need for duplicate UID columns anymore like i explained in my mini tutorial. This will be enough 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. Because of this "fix" we will be able to use 30 record types instead of 15. Its still not ideal solution but i will continue to improve this. Link to post Share on other sites More sharing options...
kcinlober Posted February 20, 2021 Share Posted February 20, 2021 the "inhabitants range" for cities is a bit tricky, and wasn't working as i anticipated. Instead of the range it needs to be the number of the option in the editor's drop down list (1-15). so in the relevant entry in the text file should not be something like "2501-5000", but rather "3" (since "2501-5000" is the third option-not counting "not set"- in the inhabitants range drop down list). Is this the case for similar records that use drop-down lists in the editor? Im thinking of "status" for clubs for example. 1 Link to post Share on other sites More sharing options...
krlenjushka Posted February 20, 2021 Author Share Posted February 20, 2021 14 minutes ago, kcinlober said: the "inhabitants range" for cities is a bit tricky, and wasn't working as i anticipated. Instead of the range it needs to be the number of the option in the editor's drop down list (1-15). so in the relevant entry in the text file should not be something like "2501-5000", but rather "3" (since "2501-5000" is the third option-not counting "not set"- in the inhabitants range drop down list). Is this the case for similar records that use drop-down lists in the editor? Im thinking of "status" for clubs for example. Yeah youre right - i will create tutorial for that kind of data with detailed explanation or excel list. Thanks for raising this 1 Link to post Share on other sites More sharing options...
krlenjushka Posted February 20, 2021 Author Share Posted February 20, 2021 Here is explanation file. Added to the first post also. Record_types_form_for_input_file.txt 1 Link to post Share on other sites More sharing options...
gibbo11 Posted February 20, 2021 Share Posted February 20, 2021 This is absolutely incredible. Wow. Top work @krlenjushka Link to post Share on other sites More sharing options...
TRFC23 Posted February 20, 2021 Share Posted February 20, 2021 (edited) Can this be used for players or is that feature still to come? Edited February 20, 2021 by TRFC23 Link to post Share on other sites More sharing options...
krlenjushka Posted February 20, 2021 Author Share Posted February 20, 2021 1 minute ago, gibbo11 said: This is absolutely incredible. Wow. Top work @krlenjushka Thanks man i hope this helps everyone who wants to create lower leagues. 3 minutes ago, TRFC23 said: Can this be used for players or is that feature still to come? This feature will be in next update. Probably only basic stuff like first and second names, CA, PA... Link to post Share on other sites More sharing options...
TRFC23 Posted February 20, 2021 Share Posted February 20, 2021 6 minutes ago, krlenjushka said: Thanks man i hope this helps everyone who wants to create lower leagues. This feature will be in next update. Probably only basic stuff like first and second names, CA, PA... Ah right, thanks Was worried it was a problem my end. Link to post Share on other sites More sharing options...
Wolf_pd Posted February 20, 2021 Share Posted February 20, 2021 The nice thing is when the addition of players works, all you need is a list of names for a country and you can edit about 150 and coach them international. No more handwork, except for downloading a list of names into excel and add them via this generator. Link to post Share on other sites More sharing options...
wkdsoul Posted February 20, 2021 Share Posted February 20, 2021 6 hours ago, kcinlober said: the "inhabitants range" for cities is a bit tricky, and wasn't working as i anticipated. Instead of the range it needs to be the number of the option in the editor's drop down list (1-15). so in the relevant entry in the text file should not be something like "2501-5000", but rather "3" (since "2501-5000" is the third option-not counting "not set"- in the inhabitants range drop down list). Is this the case for similar records that use drop-down lists in the editor? Im thinking of "status" for clubs for example. Yeah i had to work those out for a number of thing (ethnicity, hair colour, role, coaching style, player role, etc) time consuming for the dropdown stuff Link to post Share on other sites More sharing options...
kcinlober Posted February 20, 2021 Share Posted February 20, 2021 5 hours ago, krlenjushka said: Here is explanation file. Added to the first post also. Record_types_form_for_input_file.txt 4.31 kB · 5 downloads awesome, overall this tool has been a lifesaver! Link to post Share on other sites More sharing options...
krlenjushka Posted February 20, 2021 Author Share Posted February 20, 2021 19 minutes ago, wkdsoul said: Yeah i had to work those out for a number of thing (ethnicity, hair colour, role, coaching style, player role, etc) time consuming for the dropdown stuff Yeah it is but when you get everything you need its very fast. 11 minutes ago, kcinlober said: awesome, overall this tool has been a lifesaver! I know thats why i decided to create something like this. Its gonna be a long process to add everything i want but no hurry. Link to post Share on other sites More sharing options...
wkdsoul Posted February 20, 2021 Share Posted February 20, 2021 7 minutes ago, krlenjushka said: Yeah it is but when you get everything you need its very fast. Yeah, least once its done. its done. Let me know if you need any UID or dropdown ones i can send a list of what i have as well, might save you some time Link to post Share on other sites More sharing options...
krlenjushka Posted February 20, 2021 Author Share Posted February 20, 2021 6 minutes ago, wkdsoul said: Yeah, least once its done. its done. Let me know if you need any UID or dropdown ones i can send a list of what i have as well, might save you some time Yeah why not - there is no reason to do same work again. Thanks! Link to post Share on other sites More sharing options...
wkdsoul Posted February 20, 2021 Share Posted February 20, 2021 12 minutes ago, krlenjushka said: Yeah why not - there is no reason to do same work again. Thanks! UID LISTS.xlsx 1 Link to post Share on other sites More sharing options...
wkdsoul Posted February 20, 2021 Share Posted February 20, 2021 15 minutes ago, wkdsoul said: UID LISTS.xlsx 36.57 kB · 1 download You';ll prob have most but cant hurt., if i collect anymore for my process (Ive awards and derbies to do soon) i'll let you know if I find/use anymore Link to post Share on other sites More sharing options...
Champol Posted February 24, 2021 Share Posted February 24, 2021 This is great!! Thanks! Will probably use it Link to post Share on other sites More sharing options...
grade Posted March 4, 2021 Share Posted March 4, 2021 Krlenjushka, thanks for the file, but I'm on the mac, so I can't use the app. However, I will probably use to create Stadiums and probably players for my fictional teams. In the Excel file, if the teams aren't yet created or do not wish to input Latitude or Longitude, do I leave the camp blank or do I need to input any number? What about the case I wish the pitch length and width be the default one, do I enter anything or the default values? Thanks for the help and the app. Link to post Share on other sites More sharing options...
krlenjushka Posted March 4, 2021 Author Share Posted March 4, 2021 25 minutes ago, grade said: Krlenjushka, thanks for the file, but I'm on the mac, so I can't use the app. However, I will probably use to create Stadiums and probably players for my fictional teams. In the Excel file, if the teams aren't yet created or do not wish to input Latitude or Longitude, do I leave the camp blank or do I need to input any number? What about the case I wish the pitch length and width be the default one, do I enter anything or the default values? Thanks for the help and the app. You need only data that you want to add but you must same columns for all stadiums. Cant add latitude for some teams and for others not. Script cant skip empty places. If you have some data columns like that (some stadiums have some data and other not) you must filter your stadiums by that column (filter only stdiums that have added data) and add that change in different script run. Link to post Share on other sites More sharing options...
grade Posted March 4, 2021 Share Posted March 4, 2021 25 minutes ago, krlenjushka said: You need only data that you want to add but you must same columns for all stadiums. Cant add latitude for some teams and for others not. Script cant skip empty places. If you have some data columns like that (some stadiums have some data and other not) you must filter your stadiums by that column (filter only stdiums that have added data) and add that change in different script run. Thanks for the quick reply. What I mean is, not adding Latitude and Longitude for all stadium that I want to create (that info it will depend on the cities they are based). On the Pitch length and width I want to be the same size for all stadiums created (the default ones, when you create a new stadium). Link to post Share on other sites More sharing options...
krlenjushka Posted March 4, 2021 Author Share Posted March 4, 2021 7 minutes ago, grade said: Thanks for the quick reply. What I mean is, not adding Latitude and Longitude for all stadium that I want to create (that info it will depend on the cities they are based). On the Pitch length and width I want to be the same size for all stadiums created (the default ones, when you create a new stadium). You can choose whatever you want to add or not. Thats why i added checkboxes to generator. If you want to add stadium with lets say name, capacity and city - you will check add stadium, name, city and capacity. If you have those 4 columns in your input file - thats it. Link to post Share on other sites More sharing options...
grade Posted March 4, 2021 Share Posted March 4, 2021 2 minutes ago, krlenjushka said: You can choose whatever you want to add or not. Thats why i added checkboxes to generator. If you want to add stadium with lets say name, capacity and city - you will check add stadium, name, city and capacity. If you have those 4 columns in your input file - thats it. Ah nice. I will work on the Excel file. I might need help someone here, since I'm on a Mac. Link to post Share on other sites More sharing options...
krlenjushka Posted March 4, 2021 Author Share Posted March 4, 2021 4 minutes ago, grade said: Ah nice. I will work on the Excel file. I might need help someone here, since I'm on a Mac. No problem. Make sure you add all data in right form. Check text file from first post. Link to post Share on other sites More sharing options...
grade Posted March 4, 2021 Share Posted March 4, 2021 6 minutes ago, krlenjushka said: No problem. Make sure you add all data in right form. Check text file from first post. Already downloaded. Link to post Share on other sites More sharing options...
grade Posted March 9, 2021 Share Posted March 9, 2021 One quick question. In your example how do you add 5 stadiums (created) to those 5 created teams in your example, without having to do in the editor and one by one? Link to post Share on other sites More sharing options...
FCUtdWill Posted March 9, 2021 Share Posted March 9, 2021 7 hours ago, grade said: One quick question. In your example how do you add 5 stadiums (created) to those 5 created teams in your example, without having to do in the editor and one by one? Look at Krlenjushka’s first screenshot of Excel in his opening post. Link to post Share on other sites More sharing options...
grade Posted March 9, 2021 Share Posted March 9, 2021 4 hours ago, FCUtdWill said: Look at Krlenjushka’s first screenshot of Excel in his opening post. But that is UID of stadium that already exist in FM database, I'm talking of making a new stadium (or several stadiums). Link to post Share on other sites More sharing options...
FCUtdWill Posted March 9, 2021 Share Posted March 9, 2021 3 minutes ago, grade said: But that is UID of stadium that already exist in FM database, I'm talking of making a new stadium (or several stadiums). If you haven’t got any stadiums so far in your database; on a new file, click on add new and use the first new ID available, if you make more than one, add 1 to the number. Link to post Share on other sites More sharing options...
grade Posted March 9, 2021 Share Posted March 9, 2021 2 minutes ago, FCUtdWill said: If you haven’t got any stadiums so far in your database; on a new file, click on add new and use the first new ID available, if you make more than one, add 1 to the number. Okay, will do. Link to post Share on other sites More sharing options...
krlenjushka Posted March 10, 2021 Author Share Posted March 10, 2021 17 hours ago, FCUtdWill said: If you haven’t got any stadiums so far in your database; on a new file, click on add new and use the first new ID available, if you make more than one, add 1 to the number. Yeah this is some basic stuff. Easy to do in excel. 1 Link to post Share on other sites More sharing options...
grade Posted March 10, 2021 Share Posted March 10, 2021 I have 3 suggestions for the your app, @krlenjushka. 1- In the clubs, you have Stadiums option, can we have the Training Ground option? 2- might not possible, but I feel it what takes a lot of time in large files, which is kits. I know there many options, but I mean is at least add only these 2 Types: Text (4 options) and Icon (3 options). These have the least variables of all the kit types. 3- ability to add info of any reserve or youth teams in club info. If more occurs to me, I will let you know. But for me all the options in the app and these, i think these are the most time consuming of doing in the editor. Link to post Share on other sites More sharing options...
krlenjushka Posted March 10, 2021 Author Share Posted March 10, 2021 25 minutes ago, grade said: I have 3 suggestions for the your app, @krlenjushka. 1- In the clubs, you have Stadiums option, can we have the Training Ground option? 2- might not possible, but I feel it what takes a lot of time in large files, which is kits. I know there many options, but I mean is at least add only these 2 Types: Text (4 options) and Icon (3 options). These have the least variables of all the kit types. 3- ability to add info of any reserve or youth teams in club info. If more occurs to me, I will let you know. But for me all the options in the app and these, i think these are the most time consuming of doing in the editor. Training ground is not problem - i can add it without any problems. I have plans to add kit section in next version (i thought this will be released 10 days ago but i had problems with script and also i was very busy at work) but i wanted to add only shirt,shorts and socks. I think reserve/yout teams can be added in the future. Need to check that section in editor. 1 Link to post Share on other sites More sharing options...
grade Posted March 10, 2021 Share Posted March 10, 2021 (edited) AWESOME!!!! That will be a time saver. For me kits is the hardest and the most grinding part of creating big files. With this I can focus on doing the graphics part of my Leagues file. The youth and reserves is the least time consuming, since with selecting multiple teams I can do it quickly. So no rush. Can't wait for this new version. Thank you and I think SI should create award for the forum, called Krlenjushka Award, to the user in the forum, who was most cooperative and most helpful in the forum of the year. Edited March 10, 2021 by grade Link to post Share on other sites More sharing options...
Monsi9958 Posted March 10, 2021 Share Posted March 10, 2021 Great idea ! But can we use OpenOffice or LibreOffice instead of excel ? Link to post Share on other sites More sharing options...
krlenjushka Posted March 10, 2021 Author Share Posted March 10, 2021 2 minutes ago, Monsi9958 said: Great idea ! But can we use OpenOffice or LibreOffice instead of excel ? I used LibreOffice so yes. Link to post Share on other sites More sharing options...
Monsi9958 Posted March 10, 2021 Share Posted March 10, 2021 OK. Excellent news ! Link to post Share on other sites More sharing options...
Champol Posted March 10, 2021 Share Posted March 10, 2021 (edited) 16 hours ago, krlenjushka said: Yeah this is some basic stuff. Easy to do in excel. Question! If I want to add new teams with new stadiums for each team, which do I create first? I'm a little lost on how to chose the UID for my teams and stadiums, does it matter if I create teams first but already giving them the UID for their stadium, which I will create later? And do you have any recommendation in how to chose the UID range for my teams and stadiums? I imagine I have to use values that haven't been used in the original database. Another question: Do I have to put an "UID" column before EVERY new column I want to include? Or only those who refer to another club/stadium/city? For example, my columns should be like A or B? A: UID UID Club name UID Abr UID Status UID Reputation UID Stadium UID Division B: UID UID Club name Abr Status Reputation UID Stadium UID Division Edited March 11, 2021 by Champol Link to post Share on other sites More sharing options...
FCUtdWill Posted March 11, 2021 Share Posted March 11, 2021 9 hours ago, Champol said: Question! If I want to add new teams with new stadiums for each team, which do I create first? I'm a little lost on how to chose the UID for my teams and stadiums, does it matter if I create teams first but already giving them the UID for their stadium, which I will create later? And do you have any recommendation in how to chose the UID range for my teams and stadiums? I imagine I have to use values that haven't been used in the original database. Another question: Do I have to put an "UID" column before EVERY new column I want to include? Or only those who refer to another club/stadium/city? For example, my columns should be like A or B? A: UID UID Club name UID Abr UID Status UID Reputation UID Stadium UID Division B: UID UID Club name Abr Status Reputation UID Stadium UID Division Make the stadiums first and then the clubs. That way you can assign your new stadiums to your new clubs. On a separate file in the editor, add a new club and stadium. Take the UID from both and use this as a starting point. For every new record you make, add one to this number. Yes you have to put an UID before every column, it’s the way the editor (and in turn the game) reads the change. But you can fill in the first column with your UID, and then when you’ve got all your info sorted, copy and paste it into your other columns. 1 Link to post Share on other sites More sharing options...
PostMovieCam Posted March 11, 2021 Share Posted March 11, 2021 41 minutes ago, FCUtdWill said: Yes you have to put an UID before every column, it’s the way the editor (and in turn the game) reads the change. But you can fill in the first column with your UID, and then when you’ve got all your info sorted, copy and paste it into your other columns. I thought he fixed it like he showed here? On 14/02/2021 at 10:05, krlenjushka said: Unfortunately that 71 variables option doesnt work. However i managed to "fix" those 31 variables so now we can use all 31. There will be no need for duplicate UID columns anymore like i explained in my mini tutorial. This will be enough Because of this "fix" we will be able to use 30 record types instead of 15. Its still not ideal solution but i will continue to improve this. Link to post Share on other sites More sharing options...
FCUtdWill Posted March 11, 2021 Share Posted March 11, 2021 26 minutes ago, PostMovieCam said: I thought he fixed it like he showed here? Ah right, it still works if you include them so it’s up to you. Link to post Share on other sites More sharing options...
grade Posted March 11, 2021 Share Posted March 11, 2021 So while I was doing my files... still working on it. I had a thought. With this method, how possible is it to create new nations? If so, i wonder how do I can create a World Champions League and include the new nation. On small variant, if we can't create new nations, it is simply replacing a defunct nation? How do I set up the World Champions League, do I include in the editor the defunct nation in list of nations? Link to post Share on other sites More sharing options...
Champol Posted March 11, 2021 Share Posted March 11, 2021 8 hours ago, FCUtdWill said: Make the stadiums first and then the clubs. That way you can assign your new stadiums to your new clubs. On a separate file in the editor, add a new club and stadium. Take the UID from both and use this as a starting point. For every new record you make, add one to this number. Yes you have to put an UID before every column, it’s the way the editor (and in turn the game) reads the change. But you can fill in the first column with your UID, and then when you’ve got all your info sorted, copy and paste it into your other columns. Thank you very much! 1 Link to post Share on other sites More sharing options...
krlenjushka Posted March 11, 2021 Author Share Posted March 11, 2021 20 hours ago, Champol said: Question! If I want to add new teams with new stadiums for each team, which do I create first? I'm a little lost on how to chose the UID for my teams and stadiums, does it matter if I create teams first but already giving them the UID for their stadium, which I will create later You cant set stadium if there isnt that stadium in database. Its same when you create that in editor. You need to create stadium first in order to set it for some club. Pure logic. 10 hours ago, PostMovieCam said: I thought he fixed it like he showed here? This will be fixed in next version. On version 1.1 you need to put UID in front of every column. 6 hours ago, grade said: So while I was doing my files... still working on it. I had a thought. With this method, how possible is it to create new nations? You cant create new nations. Link to post Share on other sites More sharing options...
Vonohlenfun Posted March 12, 2021 Share Posted March 12, 2021 Amazing app! Simple question, where I can find lower league xml files and how to load it in editor? Link to post Share on other sites More sharing options...
krlenjushka Posted March 12, 2021 Author Share Posted March 12, 2021 6 minutes ago, Vonohlenfun said: Amazing app! Simple question, where I can find lower league xml files and how to load it in editor? Lower league file? Link to post Share on other sites More sharing options...
Vonohlenfun Posted March 12, 2021 Share Posted March 12, 2021 1 hour ago, krlenjushka said: Lower league file? This is my output xml file. So, How can load this file in FM Editor? new added clubs.xml Link to post Share on other sites More sharing options...
krlenjushka Posted March 12, 2021 Author Share Posted March 12, 2021 28 minutes ago, Vonohlenfun said: This is my output xml file. So, How can load this file in FM Editor? new added clubs.xml 108.81 kB · 0 downloads Use import option. Link to post Share on other sites More sharing options...
Vonohlenfun Posted March 12, 2021 Share Posted March 12, 2021 3 hours ago, krlenjushka said: Use import option. Thanks a lot. You saved my time. Link to post Share on other sites More sharing options...
grade Posted March 26, 2021 Share Posted March 26, 2021 So I was creating a Nation league system (a USA and Canadian merger into one) file and an idea occur to me. Is it possible in creating 2 league systems which are in independent files (like one file for USA and another file for Canada)? Is the club UID 1st team of Canada the next number after the last team of the USA? Example: Last team of USA club UID is 20000066267 and on another excel do I start the Canada file with the first team club UID starts at 20000066268? Also krlenjushka how is coming the second update of the app? Do awards part work on the app? Link to post Share on other sites More sharing options...
krlenjushka Posted March 27, 2021 Author Share Posted March 27, 2021 On 26/03/2021 at 17:05, grade said: So I was creating a Nation league system (a USA and Canadian merger into one) file and an idea occur to me. Is it possible in creating 2 league systems which are in independent files (like one file for USA and another file for Canada)? Is the club UID 1st team of Canada the next number after the last team of the USA? Example: Last team of USA club UID is 20000066267 and on another excel do I start the Canada file with the first team club UID starts at 20000066268? Also krlenjushka how is coming the second update of the app? Do awards part work on the app? No sorry i dont have time right now. My mother had covid19 so i was all about that. I hope i will find some free time soon to finish this update. 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