griffin99

You should be able to use the Editor here to do that. Create the Csv with the right info (including the current IDs), add it to the Input file, and tick the right boxes in the editor to create the xml. Then you can import the xml into the pre-game editor.

Awesome, keep going!

I came here to point out the "EFL" wasn't called anything other than "The Football League" until 2016 too. An incredible piece of work, nevertheless.

Didn't work using "Integer ID" rather than "Colour ID" though, is my point.

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

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!

Probably quite a few in the former Soviet, Yugoslav and Czechoslovakian countries too.

Awesome sounding update (especially exploiting the hidden stadium section editor) - I haven't seen whether it reflects the 24.2 database first new IDs yet (or indeed if there are any Db ID changes)? OpenOffice works fine as an interim measure btw, I take a copy, update that to save changes and then move all the data back into the original

Sorry, my 2am typo = now edited - I meant saving as XLS not XML - the created file is an XLSM which I can open and edit but (presumably as it's the OpenOffice app not the Excel one) doesn't seem to allow me to save the edit spreadsheet anywhere else (which would allow me to set it up with the info in a spreadsheet, then just import it across when I want to create the XML) - it might just be a formatting thing with OpenOffice. EDIT: Have now saved a copy in the native OpenOffice .ODS format which I can copy into the XLSM file in the Input folder when I've got all the info in the right format and can save that as I go. Will just need to update the XLSM in one go and that should work fine. Would be great if you could add the style number (although a kit interface that's much easier to use than the Editor and provides all the XML output is probably the only way to improve on the RGB faffery).

It's probably because I'm using OpenOffice and not Excel, but I can't save progress as an xmls (I have a lot of created info so need some saves as I add it) - and if I try to save as XLS it doesn't seem to do that. Does it work if I save the file elsewhere (or, say as a csv?) then move it back to the Input file to complete the xml creation? The other thing is that due to the RGB and multiple pieces, kit creation is a nightmare enough without having to remember that kit style 56 is called "3 Central Vertical Stripes (Middle Different Colour)" and type all of that in, when it's only going to convert it to "56" in the xml anyway. A rare time when entering the numbers might work better for the user than the description? Nice tool though, have enjoyed using it so far even if it refuses to save my interim changes (which admittedly also makes it difficult to test).

Still works for me, I just did it.

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/)

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.

God-level response. Thanks!

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.

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.

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.

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.

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?

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.

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.

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!