picketyp Posted February 4, 2023 Share Posted February 4, 2023 Ah excellent! That worked. Thank you for the help (and making this tool in the first place!). 1 Link to post Share on other sites More sharing options...
grade Posted March 13, 2023 Share Posted March 13, 2023 Hi @krlenjushka In the new update of your program, working with Kits? You said back in December you needed to solve a few issues in the kits section. Also, can you show an example of how we set up the kits section in Excel? Link to post Share on other sites More sharing options...
krlenjushka Posted March 13, 2023 Author Share Posted March 13, 2023 29 minutes ago, grade said: Hi @krlenjushka In the new update of your program, working with Kits? You said back in December you needed to solve a few issues in the kits section. Also, can you show an example of how we set up the kits section in Excel? Yeah sorry i dont have time for that because im working on my lower league database. Anyway its not problem to make script for your needs. This is how i did it. Shirt with kit style (type column) , background, foreground, outline and number color. For shorts and socks i use only background because i use only 1 type. 3 Link to post Share on other sites More sharing options...
RobertBoomer79 Posted March 15, 2023 Share Posted March 15, 2023 @krlenjushka Thanks for your great work. Is it possible to get all source code for your project? Or put project in github? I want add some changes to competition. Eg. Nation, Colours, Winter Ball Colour, Reputation. Sorry for my English Link to post Share on other sites More sharing options...
krlenjushka Posted March 15, 2023 Author Share Posted March 15, 2023 59 minutes ago, RobertBoomer79 said: @krlenjushka Thanks for your great work. Is it possible to get all source code for your project? Or put project in github? I want add some changes to competition. Eg. Nation, Colours, Winter Ball Colour, Reputation. Sorry for my English Sorry i dont share my work like that. I dont think nation is needed option for competition because its easy to do this in editor. Thats why i decided not to add it. Link to post Share on other sites More sharing options...
EnigMattic1 Posted April 27, 2023 Share Posted April 27, 2023 Any idea what has caused this error? I did it exactly the same way as I always have, but this is the first time I've encountered it. Link to post Share on other sites More sharing options...
krlenjushka Posted April 27, 2023 Author Share Posted April 27, 2023 7 hours ago, EnigMattic1 said: Any idea what has caused this error? I did it exactly the same way as I always have, but this is the first time I've encountered it. Yeah - you cant use there symbols: & and "" Check this file: FM23 Editor Generator - record types form for input file.txt Link to post Share on other sites More sharing options...
Emmersonforest4 Posted May 1, 2023 Share Posted May 1, 2023 @krlenjushka Please can you advise, I have downloaded the FM 23 version of the generator. When I paste my excel table into the input.txt file the columns dont align. I have made sure they are delimited tab but that dosent work for me. The screenshot is what I get below. Ive also attached my spreadsheet I used to make the cities. This is a great tool! Thank you for sharing and getting back to people. It makes editing more accessible and fun. City Upload 01-05-2023.xlsx Link to post Share on other sites More sharing options...
Emmersonforest4 Posted May 1, 2023 Share Posted May 1, 2023 @krlenjushka Also I am trying to add this to a editor file I have already downloaded from the steam workshop. Can the FM editor Generator do that to? Or will that nor work for me? Link to post Share on other sites More sharing options...
krlenjushka Posted May 1, 2023 Author Share Posted May 1, 2023 3 hours ago, Emmersonforest4 said: @krlenjushka Please can you advise, I have downloaded the FM 23 version of the generator. When I paste my excel table into the input.txt file the columns dont align. I have made sure they are delimited tab but that dosent work for me. The screenshot is what I get below. Ive also attached my spreadsheet I used to make the cities. This is a great tool! Thank you for sharing and getting back to people. It makes editing more accessible and fun. City Upload 01-05-2023.xlsx 10.35 kB · 0 downloads You have 2 errors in your sheet - you should use 2000247170 as first UID for cities. I guess they changed that again. Also longitude and lattitude should be with dot instead of comma. I tried and works 100%. Link to post Share on other sites More sharing options...
Emmersonforest4 Posted May 1, 2023 Share Posted May 1, 2023 1 hour ago, krlenjushka said: You have 2 errors in your sheet - you should use 2000247170 as first UID for cities. I guess they changed that again. Also longitude and lattitude should be with dot instead of comma. I tried and works 100%. Thank you! I started at that UID for the cities cause I want to add these to a database I have downloaded and that database starts at those numbers I had put on originally. Will that not work than? Also was it commas that was causing the issue with the longtitude and lattitide? Thank you for pointing me in the right direction. Link to post Share on other sites More sharing options...
krlenjushka Posted May 2, 2023 Author Share Posted May 2, 2023 15 hours ago, Emmersonforest4 said: Will that not work than? Yes. 15 hours ago, Emmersonforest4 said: Also was it commas that was causing the issue with the longtitude and lattitide? Yeah you must use dot instead. Link to post Share on other sites More sharing options...
MichielVM Posted May 2, 2023 Share Posted May 2, 2023 On 27/04/2023 at 21:41, krlenjushka said: Yeah - you cant use there symbols: & and "" Check this file: FM23 Editor Generator - record types form for input file.txt 5.3 kB · 1 download What about other 'special' characters like "é, ç, ë, ô, ï, î, è, ö, ü, Ö, ã, ä, ó, í, ê, Ü, É, â, á, Ç, ú, Á, ñ, ò, ø, à, Ó"? They seem to be causing errors for me. Do I have to replace them and if so, by what? Link to post Share on other sites More sharing options...
MichielVM Posted May 2, 2023 Share Posted May 2, 2023 (edited) I figured it out, you have to search and replace the characters in the finale XML-file (which you'll have to import into the editor) by their numeric character reference in XML, for my examples that is: Search Replace by á á Á Á à à â â ä ä ã ã ç ç Ç Ç é é É É è è ê ê ë ë í í î î ï ï ñ ñ ó ó Ó Ó ò ò ô ô ö ö Ö Ö ø ø ú ú ü ü Ü Ü Edited May 2, 2023 by MichielVM 1 Link to post Share on other sites More sharing options...
krlenjushka Posted May 2, 2023 Author Share Posted May 2, 2023 1 hour ago, MichielVM said: I figured it out, you have to search and replace the characters in the finale XML-file (which you'll have to import into the editor) by their numeric character reference in XML, for my examples that is: Search Replace by á á Á Á à à â â ä ä ã ã ç ç Ç Ç é é É É è è ê ê ë ë í í î î ï ï ñ ñ ó ó Ó Ó ò ò ô ô ö ö Ö Ö ø ø ú ú ü ü Ü Ü TBH i dont know because i dont have these letters in serbian language. I will add this to tutorial xml file. Link to post Share on other sites More sharing options...
MichielVM Posted May 3, 2023 Share Posted May 3, 2023 6 hours ago, krlenjushka said: TBH i dont know because i dont have these letters in serbian language. I will add this to tutorial xml file. No problem, glad to help 😁 Link to post Share on other sites More sharing options...
Emmersonforest4 Posted May 3, 2023 Share Posted May 3, 2023 On 02/05/2023 at 16:16, krlenjushka said: Yes. Yeah you must use dot instead. Thank you so much for that, so can I import data into another editor database? How would I do that? Also if my input file looks like this picture below will it not work? Link to post Share on other sites More sharing options...
Emmersonforest4 Posted May 3, 2023 Share Posted May 3, 2023 12 Tiers TE Version 30-04-23.fmf So I want to add the attached Cities to a database I downloaded off the workshop. Is that possible? Problem is the databse I have downloaded has already used the first UID for the Cities so I cant import it and merge the data. City Upload 01-05-2023.xlsx Link to post Share on other sites More sharing options...
Emmersonforest4 Posted May 6, 2023 Share Posted May 6, 2023 Does anyone know if you can merge the upload with fmf files? Link to post Share on other sites More sharing options...
PostMovieCam Posted May 6, 2023 Share Posted May 6, 2023 Dumb Question has anyone been able to get a new clubs xml to work with both foreground and background color on? I Have the RGB numbers in their own columns, are they suppose to be one all together? Link to post Share on other sites More sharing options...
Renskay Posted May 13, 2023 Share Posted May 13, 2023 (edited) Hey man, was trying to get in contact with you but I don't know the best method. You helped me previously with FM Editor data for cities that you extracted. Could you please send me the data for Irish and Northern Irish cities if possible? If not too much to ask I would really be interested in getting the data for clubs and stadiums in Ireland and Northern Ireland as well. I'm trying to add new stadiums and clubs to the database with your script but I don't want to add anything already in the game. Edited May 13, 2023 by Renskay Link to post Share on other sites More sharing options...
griffin99 Posted May 16, 2023 Share Posted May 16, 2023 (edited) On 06/05/2023 at 10:38, Emmersonforest4 said: Does anyone know if you can merge the upload with fmf files? I haven't tried it, but can you import the fmf into the editor, search the db for the last UID number for City/Competition/Club etc and then use then number after that as the first UID in your import so it's sequential and following on from the data in the fmf? EDIT: I have just added the fmf and the last club UID is 2000248939 Eaton Socon in the city Eaton Socon which I am 100% sure isn't in the original, so the next test is to add a club at number 2000248940... just a moment! FURTHER EDIT: Short answer... you can if you create your xml first, using the first free UID number in the base Db and import your xml first. Then use the Merge Files command and load the FMF afterwards. It moves all the numbers of the clubs or whatever it is you're importing in the FMF down by however many of those things you've already added [in my import of one team Eaton Socon became 2000248940, the new XML team was added at 2000247395 which is a club number not long after the end of the 23.4.0 Db]. You'd have to test whether that causes any problems for linking the FMF data with other FMF data from having different numbers. I think it's all relational within the XML so it should still work (ie all the new numbers in the FMF find all the other new numbers), but haven't checked that because I don't know what that data is supposed to look like to begin with. But in theory so far it seems to work. You can't load the FMF first then Merge the XML into it because the FM Editor doesn't allow you to merge xml format and you also can't import anything on top of the FMF, so you have to do it the other way around. It's been years since I messed about with these bits so apologies if this is a bit obvious to some of you! Edited May 17, 2023 by griffin99 Updated info (again) Link to post Share on other sites More sharing options...
griffin99 Posted May 16, 2023 Share Posted May 16, 2023 (edited) On 06/05/2023 at 20:08, PostMovieCam said: Dumb Question has anyone been able to get a new clubs xml to work with both foreground and background color on? I Have the RGB numbers in their own columns, are they suppose to be one all together? Dumb response too (EDITED) - just spotted the new version FM23 v1.0 on the front page of the thread, which is awesome - just got a new laptop so been re-installing apps for a few weeks. I'll give it a test with the foreground and background colours, maybe not with all 1260 clubs I've got in my spreadsheet though. Edited May 20, 2023 by griffin99 1 Link to post Share on other sites More sharing options...
griffin99 Posted May 17, 2023 Share Posted May 17, 2023 (edited) On 03/05/2023 at 18:32, Emmersonforest4 said: Thank you so much for that, so can I import data into another editor database? How would I do that? Also if my input file looks like this picture below will it not work? On 03/05/2023 at 18:32, Emmersonforest4 said: Thank you so much for that, so can I import data into another editor database? How would I do that? Also if my input file looks like this picture below will it not work? I've never had a problem importing when the data looks like this, the tab breaks are still in the right places hidden within the text. The one thing I did notice however was that I needed a blank column in the spreadsheet/input file after the the Stadium UID and before the Stadium Name, or the import didn't link the UID to the Stadium Name. But that may have been FM21 v1.1 as it was a few months back. Edited May 20, 2023 by griffin99 Link to post Share on other sites More sharing options...
griffin99 Posted May 21, 2023 Share Posted May 21, 2023 (edited) On 06/05/2023 at 20:08, PostMovieCam said: Dumb Question has anyone been able to get a new clubs xml to work with both foreground and background color on? I Have the RGB numbers in their own columns, are they suppose to be one all together? I've done a fair bit of looking at this tonight. And yeah I'm using the right version of the tool this time (FM23 v.1). The first thing is that I think the "Year Founded" needs to go *before* the Foreground and Background RGB columns on your spreadsheet. Having one column each for Foreground and Background also means all the other settings after it work correctly too. However, I can't get it to work automatically with the tool, only the Red values show, eg it imports 255,0,0 instead of, say, 255,126,1. Same for both Foreground and Background I have worked out that if you manually enter <colour id="new_value" red="255" green="126" blue="1" alpha="255"/> (with your preferred RGB values) in the row under the unsigned id property value for Foreground and Background in the XML, it will work manually one club at a time, but can't get the bulk import to work. There must be a particular format needed - any ideas? Edited May 21, 2023 by griffin99 Link to post Share on other sites More sharing options...
cimmi Posted May 27, 2023 Share Posted May 27, 2023 (edited) Please could I have an example on how to add players? I would like to make a retro update without using the official editor, it would take too long Edited May 27, 2023 by cimmi Link to post Share on other sites More sharing options...
xbenjaminx Posted June 18, 2023 Share Posted June 18, 2023 Hi, I'm sorry for repeating this here but I don't know where you're likely to see itm first. You're program looks great. I am looking for something that would allow me to add a vast number of languages from Microsoft Excel into the PGE. For clarity, by languages I mean the languages in-game that are spoken by players and staff. Could I accomplish this with your program? Link to post Share on other sites More sharing options...
michael21 Posted July 23, 2023 Share Posted July 23, 2023 Amazing tool, this is an absolute game changer. Thank you! One bug/issue I noticed is the foreground and background colors xml does not generate properly when generating the club output. 1 Link to post Share on other sites More sharing options...
griffin99 Posted July 29, 2023 Share Posted July 29, 2023 (edited) On 23/07/2023 at 16:12, michael21 said: Amazing tool, this is an absolute game changer. Thank you! One bug/issue I noticed is the foreground and background colors xml does not generate properly when generating the club output. It is fantastic isn't it! I noticed this too though - it only seems to create the Red part of the RGB even if you move "year founded" in front of the RGB (which is needed to get any row for colour to populate), and never creates Green or Blue - would be fantastic if this could be fixed as it's a massive time-saver in editing new teams which exist but aren't in the game. Edited July 29, 2023 by griffin99 Link to post Share on other sites More sharing options...
Jorgen Posted August 3, 2023 Share Posted August 3, 2023 @krlenjushka I have found a website that gives ELO-scores to 2800+ football clubs around the world. I copied all those scores to Excel and multiplied them to fit in FM's 0-10000 reputation range. Can I now use this to swap the reputation and the ELO scores? Link to post Share on other sites More sharing options...
griffin99 Posted August 4, 2023 Share Posted August 4, 2023 On 03/08/2023 at 22:10, Jorgen said: @krlenjushka I have found a website that gives ELO-scores to 2800+ football clubs around the world. I copied all those scores to Excel and multiplied them to fit in FM's 0-10000 reputation range. Can I now use this to swap the reputation and the ELO scores? As long as you know the team ID, because reputation is one of the categories in the tool, yes. It might take a little trial and error to work out how many tabs you need - which are essential other than Reputation and Team UID (eg I don't know if you need the team name or if the ID alone is enough, it's been 3 months since I used it regularly). But it absolutely should work if you tick Reputation and get the input format correct. 1 Link to post Share on other sites More sharing options...
msobs Posted August 11, 2023 Share Posted August 11, 2023 Hi, I've been working on expanding the number of Polish names in the database (via adding named Polish players) for a Polish lower league save I plan to start, but have run into this issue when try to import the xml file. Any idea what's causing this and how I can fix it? Link to post Share on other sites More sharing options...
grade Posted August 14, 2023 Share Posted August 14, 2023 On 13/03/2023 at 11:37, krlenjushka said: Yeah sorry i dont have time for that because im working on my lower league database. Anyway its not problem to make script for your needs. This is how i did it. Shirt with kit style (type column) , background, foreground, outline and number color. For shorts and socks i use only background because i use only 1 type. If I want the first kit of selection kit on editor, on type do I fill with a 1 or a 0? Link to post Share on other sites More sharing options...
griffin99 Posted August 16, 2023 Share Posted August 16, 2023 On 11/08/2023 at 06:18, msobs said: Hi, I've been working on expanding the number of Polish names in the database (via adding named Polish players) for a Polish lower league save I plan to start, but have run into this issue when try to import the xml file. Any idea what's causing this and how I can fix it? The first thing I'd do is check for non-standard characters in the name. - That Miroslaw has a special character and it's possible it might have been entered wrongly somewhere else in the list, for instance. I think there's a list of the "special character" codes earlier in this thread if you want to keep special characters in. 1 Link to post Share on other sites More sharing options...
griffin99 Posted August 16, 2023 Share Posted August 16, 2023 (edited) On 14/08/2023 at 17:27, grade said: If I want the first kit of selection kit on editor, on type do I fill with a 1 or a 0? Judging from the Type in the table you quoted it would be a 1, but let us know if you get this to work, I can't get the RGB colours to create properly using the tool, only the Red value is created. Edited August 23, 2023 by griffin99 Link to post Share on other sites More sharing options...
MisterX Posted November 17, 2023 Share Posted November 17, 2023 (edited) Can you use this tool for adding players too? And for FM24? Edited November 17, 2023 by MisterX Link to post Share on other sites More sharing options...
griffin99 Posted November 18, 2023 Share Posted November 18, 2023 On 17/11/2023 at 11:17, MisterX said: Can you use this tool for adding players too? And for FM24? Yes and yes. Though as far as I can there's no way (yet) around the dodgy FM verification stopping things like changes to nation rules from working in FM24 due to stupid errors, so the benefit of adding competitions is temporarily a bit restricted. The usual verification fix doesn't work - shouldn't affect adding players though. Link to post Share on other sites More sharing options...
cimmi Posted November 25, 2023 Share Posted November 25, 2023 Perfect. How is it done? Can you write an example on how to add players? Link to post Share on other sites More sharing options...
griffin99 Posted November 26, 2023 Share Posted November 26, 2023 (edited) On 25/11/2023 at 09:00, cimmi said: Perfect. How is it done? Can you write an example on how to add players? Everything you need is already in this thread. Download the tool (v1.1) from page 1, create an excel spreadsheet with the person characteristics you want to create in the same order as the tool (and using the first ID the game creates when you add a new player for your first player, then increase the ID by 1 for each line), then cut the Excel info and paste it into the input.txt file, tick the "input.txt is ready" button and make sure your tick boxes correspond with the info in the columns, run the scripts/generate output/xml in the tool, and there's your xml with your players and their data to import into the pre-game editor and load into FM when you start a new game. (Or there's this tool too: https://community.sigames.com/forums/topic/580152-fm24-fm-auto-editor-project/) Edited November 26, 2023 by griffin99 Link to post Share on other sites More sharing options...
krlenjushka Posted November 30, 2023 Author Share Posted November 30, 2023 On 25/11/2023 at 10:00, cimmi said: Perfect. How is it done? Can you write an example on how to add players? Generator is not updated to FM24. Im not sure i will update it at all. First time in last 15 years i dont have FM. Link to post Share on other sites More sharing options...
cimmi Posted December 2, 2023 Share Posted December 2, 2023 Thank you very much for your answers to griffin and krlenjushka 1 Link to post Share on other sites More sharing options...
krlenjushka Posted December 8, 2023 Author Share Posted December 8, 2023 I bought FM24 and i will try to update this tool to new version. 2 Link to post Share on other sites More sharing options...
griffin99 Posted December 8, 2023 Share Posted December 8, 2023 (edited) 57 minutes ago, krlenjushka said: I bought FM24 and i will try to update this tool to new version. Awesome news - could you particularly have a look at the kit colour generation? The other FM23 functions all still seem to work in FM24 for me using an initial XML then manually adding the Outputs as generated for each element. I also managed to get a spreadsheet import to work for shirt colours, but only by concatenating separate RGB values into the correct XML text format in the spreadsheet and then doing a find and replace as they seem to have changed the initial text in the shirt colour line from "integer id" to "colour id". Would also be really useful to know how the colours should be split in the original spreadsheet - is it RGB values in 00|00|00 format in one column, or RGB values separately, etc? *After* you've played the game for a bit, of course! Edited December 8, 2023 by griffin99 Link to post Share on other sites More sharing options...
krlenjushka Posted December 8, 2023 Author Share Posted December 8, 2023 6 minutes ago, griffin99 said: I also managed to get a spreadsheet import to work for shirt colours, but only by concatenating separate RGB values into the correct XML text format in the spreadsheet and then doing a find and replace as they seem to have changed the initial text in the shirt colour line from "integer id" to "colour id". Would also be really useful to know how the colours should be split in the original spreadsheet - is it RGB values in 00|00|00 format in one column, or RGB values separately, etc? Probably separately - i need to check how editor writes kit colors on this version. BTW i dont think i will play too much because i cant get my lower leagues to work - as always we have to wait for real release date in march. Every year before final update - we have stupid errors like this. Link to post Share on other sites More sharing options...
griffin99 Posted December 8, 2023 Share Posted December 8, 2023 I ran a test on v24.0 changing a colour and for black it uses <colour id="new_value" red="0" green="0" blue="0" alpha="255"/> (see attached file for the rest of the record). Test colour style.xml Link to post Share on other sites More sharing options...
krlenjushka Posted December 8, 2023 Author Share Posted December 8, 2023 20 minutes ago, griffin99 said: I ran a test on v24.0 changing a colour and for black it uses <colour id="new_value" red="0" green="0" blue="0" alpha="255"/> (see attached file for the rest of the record). Test colour style.xml 1.02 kB · 1 download Yeah its normal red green blue code. Black is 0,0,0 so this is ok. Link to post Share on other sites More sharing options...
djdomo Posted December 8, 2023 Share Posted December 8, 2023 could you change home grown player rules for the league with this. thanks Link to post Share on other sites More sharing options...
griffin99 Posted December 8, 2023 Share Posted December 8, 2023 46 minutes ago, krlenjushka said: Yeah its normal red green blue code. Black is 0,0,0 so this is ok. Didn't work using "Integer ID" rather than "Colour ID" though, is my point. Link to post Share on other sites More sharing options...
Ieuano Posted January 3 Share Posted January 3 (edited) To get club foreground and background colour working as intended, change line 5 in "clubforegroundcolor.txt" and "clubbackgroundcolor.txt" to echo ^<colour id="new_value" variable/^> both files are located in D:\...\FM23 Editor Generator ver 1.0\FM23 Editor Generator ver 1.0\System Likewise, you need to have the year founded column ahead of the colours in the text file used to generate the .xml, and have the colours written like @griffin99's example above (red="255" green="255" blue="255" alpha="255"). EDIT: to save the reader a few moments, this works in Excel (obviously change the column numbers to the ones you have the RGB values in). =CONCAT("red=",CHAR(34),I3,CHAR(34)," green=",CHAR(34),J3,CHAR(34)," blue=",CHAR(34),K3,CHAR(34)," alpha=",CHAR(34),255,CHAR(34)) Edited January 3 by Ieuano 1 Link to post Share on other sites More sharing options...
FedeGoti20 Posted August 16 Share Posted August 16 Hello @krlenjushka! What an amazing tool to be honest, you're a time saver and this helps A LOT. However, I saw above you mention you might update it for 2024. If you dont mind me asking..., were you able to do so? I know not too many changes may apply, but it would be great if new record types can be added, such as "General Data" and "Positions" for players. Anyways, I greatly appreciate your time and help creating this tool, it is marvelous and amazing! 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