Imadinnerjacket Posted July 30, 2020 Share Posted July 30, 2020 (edited) The Waffle I've used the editor for a number of years now. Mainly to create Legendary players and managers. I really enjoy the research part watching videos, reading articles, forum post etc on the players I’m creating. Sometimes posting them here but mainly on Steam. Every FM that comes out I've bought on Pre-order and dived straight in on release. Trying to transfer last year’s work over to the new game. Sometimes it works sometimes it doesn't. Mainly due to UID's for individuals have been removed completely or the player becoming a retired person, then their UID changes every new release. I also found names, clubs, DoB etc will get corrupted on the export for one version to another. With experience and ideas to make my creations better i start from the beginning most new releases! By about Jan, Feb i feel burned out and stop playing and creating, swearing I’m never playing or creating for this game again!!! I do other things, play other games, then the football season finishes and the next FM is on 4 months away! I then get the bug again! So this time around I was thinking of how i could retain all the hours of work I’ve put in and still be able to transfer them across without too much hassle. Well I needed to have all the players I’ve created on a Database (to tell the truth i started this a round Jan this year and it’s what broke me haha) I then wanted to make it open for everyone to use, even to add their own versions of Legends real or fake (regen the regen). I want the user to be able to choose what player or players they want, at what age and club of their choosing! I looked around to see if it had been done before. There are a few people doing amazing work in their own databases (Fenech, davidczv, The Mad Scientist and many more) but nothing like what i was thinking about. As i don't have any skills in software (which i assume would be the best way to creating this kind of output), I’ll use excel to create .xml for the output. Been looking about for information on how this would work. found one thread (I’ll link it below) on how to do it for fixtures. Beyond that there’s nothing out there! Current Aim To record. UID's for inputs and their values*individual inputs like name, hair colour and their values*Clubs*Cities*Nations Need to start at the beginning in regards to what going into the xml. Every input has a UID and Value, these are coded on to the .xml file for the game to interpret. Attached to this post is a spreadsheet that I’m using to record these values. I’m doing it screen by screen from the editor. Add a player in the people database. Then change/add one of the inputs. Save file. Export file. Open .xml in Notepadd++. record the UID, code and the value of the different options for that input. unless its country, city, club etc. its taking sometime! I hope that this will also be helpful information for anyone else to use, now or in the future. Links By magicmastermind124 Excel and the FM Editor - FM editing Help *If you know where i can get some of this information from? other then painstakingly taking it from the editor I would appreciate it very much *If this has been done before? *Know of a link for a tutorial that could help with formatting/processing/understanding this information? *Want to help collate this information to put on this thread? pm me. Done so far Details Database Version for FM19, FM20 International Data Club Contract Loan Future Transfer Nation UID Major Clubs UID Languages UID Attributes Job Preference Language Days at Club/Nation General Positions Mental Attributes Physical Attributes Technical Attributes Goalkeeper Attributes Preferred Moves MLS Player Details added Not Recorded page. This is for some sections I've miss out for now File updated: 20/08/2020 FM XML BREAKDOWN.xlsx Edited August 20, 2020 by Imadinnerjacket 2 Link to post Share on other sites More sharing options...
Imadinnerjacket Posted August 20, 2020 Author Share Posted August 20, 2020 updated Left to complete for phase one Relationships Playing History Non Playing History Achievements Cities Competitions 2 Link to post Share on other sites More sharing options...
wkdsoul Posted October 23, 2020 Share Posted October 23, 2020 Awesome, might see if i can write a macro or mail merge text to mass create the xml from a excel database i can import straight into the notepad++ and then the editor. 1 Link to post Share on other sites More sharing options...
wkdsoul Posted October 24, 2020 Share Posted October 24, 2020 So far so good, using a template and mail merge system, some teething issues with contracts and player types so far, but basics player name, dob, etc all good Link to post Share on other sites More sharing options...
magicmastermind124 Posted November 14, 2020 Share Posted November 14, 2020 I've been keeping an eye on the Excel thread and the recent posts. I still use a similar method. I mainly use it for histories so that way I have a list of histories on Excel than can be converted to XML. I don't use mail merge though, I just simply concantenate the series of XML code required to build up all the changes, with checks in place to skip entires that are blank e.g. Team Cup History Second Stages. I then transpose the single history records into XML on a single line that can then be inserted into Notepad++ (or the Mac equivalent, used to be TextWrangler, think it's now BBEdit but I no longer use a Mac). The Transpose requires Office 365 due to the new calculation engine in Excel that allows simpler array formulas to spill their results into adjacent non-blank cells. But I wanted to drop by and wish you the best of luck with this. If it means that you and others can extend the amoutn of research and work that you want to put into FM, then clearly everyone benefits! 1 Link to post Share on other sites More sharing options...
wkdsoul Posted November 14, 2020 Share Posted November 14, 2020 I found a mail merge works for me, created one for cities, players,clubs, non players which is ok. Some have to be done manually like kits and relationships. but it gets the bulk of my work done fast for all players/attributes etc which is what i needed. Link to post Share on other sites More sharing options...
PostMovieCam Posted January 11, 2021 Share Posted January 11, 2021 On 14/11/2020 at 09:04, wkdsoul said: I found a mail merge works for me, created one for cities, players,clubs, non players which is ok. Some have to be done manually like kits and relationships. but it gets the bulk of my work done fast for all players/attributes etc which is what i needed. Is there any online demo that explain mail merging? Thanks for any help at all. And has anyone tried this excel sheet on the Fm21editor? Link to post Share on other sites More sharing options...
wkdsoul Posted January 11, 2021 Share Posted January 11, 2021 5 minutes ago, PostMovieCam said: Is there any online demo that explain mail merging? Thanks for any help at all. And has anyone tried this excel sheet on the Fm21editor? I dont think so - its the same as a normal mail merge process for letters and stuff though. It was just easier for me that way. Might be a guide on the basics on YT etc. Link to post Share on other sites More sharing options...
Lello1990 Posted July 19, 2023 Share Posted July 19, 2023 (edited) good morning everyone, congratulations for this work, two things are not clear to me 1) is there a compilation example to understand how to use the excel sheet? for example: if I had to recreate Maradona or Pele where should I fill in the excel sheet? 2) once the work with excel is finished, how do you then convert it into a game? not knowing English I used the translator I apologize if something is not understandable Edited July 19, 2023 by Lello1990 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