SGMRock wrote:elguapo wrote:SGMRock wrote:Here's a thread with db definitions.
Awesome thank you. I also found this one that Cursive did
I added a Madden 20 tab to this and added one change that I know of where one of the abbreviations was changed from
Madden 19 PHCL , Hair Color or Style, to new abbreviation in Madden 20 PLHS It was also moved to a different row in the database but I think you said that doesn't matter anyway in the other thread where we talked about how to convert Madden 19 rosters to Madden 20.
As far as I can tell this was the only change in the ROSTER-Official database fields from M19 to M20 from what Cursive already had on there.
I'll look into Cursive's spreadsheet.
Stingray68 made the DB Editor read the CSV file and if any fields in the CSV are also present in the current TABLE those fields will be imported no matter the order of the fields. Make sure all necessary fields are present tho since the DB Editor will delete all current records and create new records with the imported CSV fields. For example if you're missing the TGID field the new records will have 0 in their TGID field. If you move the TGID column in the CSV to the end, the DB Editor will still import the new records with their TGID imported value. What I usually use this feature for is to convert roster formats.