Aranaktu
Club Supporter
Some of the squadfiles currently available are poorly made (causing game crashes) and some others are outdated. After many questions, that I've seen on discord like "How to add icons" etc. I've decided to make this tutorial.
I'll describe the most proper way of doing this based on my knowledge about FIFA. If you find any mistakes then let me know, nobody is perfect.
Requirements:
Where to find icons data?
First of all, we need to get the data of the icons. Their playerid, attributes, appearance etc. It's stored in cards_ng_db.db database. Open this file with db master.
Players data is stored in players table, but first, we need to know the playerid. If you just want to add one icon then probably the quickest way will be to find the name in playernames table, copy it's nameid for example Ronaldinho - 20327:
And then search for player which one of nameids (firstnameid/lastnameid/commonnameid/playerjerseynameid) is equal to 20327.
To quickly find all playerids of icons you can check teamplayerlinks table. All icons are in team with teamid - 112658
Adding the icons to squadfile
All official squad files that you download through game are located in Documents\FIFA 20\settings. (Squadfiles got Squad prefix in the file name). Open one of these files in Revolution Database Master 20
To add icon(s) to the squadfile you need to create a new record in 3 tables:
So, let's start from players table first.
here we can copy the data 1:1. There isn't any magic here.
Now, teamplayerlinks. Here you can define the team where your player will be. I recommend to put the player in free agents (teamid: 111592
) and then possibly transfer him using the transfer player feature in-game.
And the last table is editedplayernames. We need to set custom name for our player because the FUT mode and squadfile/career is using different playernames table. For example in FUT the nameid - 20328 is Ronaldo, but in career mode it can be Namjilyn or anyone else. The simplest fix is to set the name in table mentioned above. The game is at first checking if the name is set in editedplayernames and if it's not then it's pulling the name from
playernames. Not quite sure how it works for commentary names. If the commentary is wrong you may need to set the value of lastnameid in players table to 0. This should remove commentary completely from the player.
Done! Now, you just need to repeat all the steps 266 more times to add all icons! Good luck!
Just kidding... It's 2020, you can automate this boring process with any programming language you want. Actually I've automated it for you.
Automate adding icons to squad file
I've written two python scripts which can automate almost the whole process. All you need to do is:
If you don't have python 3 then download and install python 3.7.6 x86 from here
Download the python scripts (squadfile_icons.zip) and unzip it somewhere, can be on desktop.
Open clean, official squad file from EA in RDBM. Then export the players table & teamplayerlinks table. Save these files in directory with the python script -> FIFA 20 -> squadfile
run the add_icons_all.bat file to add all version of icons, or add_icons_baby/middle/prime_only.bat to add only one version.
CMD window should pop up. Wait until it closes, meaning that python script has finished its job.
If everything worked fine you should have 3 new files in the directory with script:
Import these tables to the squadfile with RDBM.
Saving the edited squadfile and loading it in the game
After you have added the icon you can finally save the squadfile and load it in the game.
To save it just click on File -> Save in top left corner
To load in game, from main menu navigate to Customise -> Profile -> Load Squads
And when the squad file is loaded you can finally start a new career with icons by choosing "Use Current Squads" option
I'll describe the most proper way of doing this based on my knowledge about FIFA. If you find any mistakes then let me know, nobody is perfect.
Requirements:
- DB Master 15
- Revolution Database Master 20
- cards_ng_db.db & cards_ng_db-meta.xml (you can extract these files with frosty or download them from here)
- Official squad file from EA!
Where to find icons data?
First of all, we need to get the data of the icons. Their playerid, attributes, appearance etc. It's stored in cards_ng_db.db database. Open this file with db master.
Players data is stored in players table, but first, we need to know the playerid. If you just want to add one icon then probably the quickest way will be to find the name in playernames table, copy it's nameid for example Ronaldinho - 20327:
And then search for player which one of nameids (firstnameid/lastnameid/commonnameid/playerjerseynameid) is equal to 20327.
To quickly find all playerids of icons you can check teamplayerlinks table. All icons are in team with teamid - 112658
Adding the icons to squadfile
All official squad files that you download through game are located in Documents\FIFA 20\settings. (Squadfiles got Squad prefix in the file name). Open one of these files in Revolution Database Master 20
To add icon(s) to the squadfile you need to create a new record in 3 tables:
- players table
- teamplayerlinks table
- editedplayernames table
So, let's start from players table first.
here we can copy the data 1:1. There isn't any magic here.
- Find first empty record
- Write down the values from players table from cards_ng_db to the players table in squad file
Now, teamplayerlinks. Here you can define the team where your player will be. I recommend to put the player in free agents (teamid: 111592
) and then possibly transfer him using the transfer player feature in-game.
- Again, find first empty record
- artificialkey is the primary key in this table, so we shouldn't duplicate it. The table should be already sorted by its artificialkey value, so just increment by one the value from the previous row, in example, if last valid record got artificialkey equal to 20553 then our next artificialkey should be 20554.
- teamid is up to you. If you want to have icon in free agents then put 111592 there
- playerid is the id of our player. So, for Ronaldinho - 28130
- position - preferably 28 or 29. 28 is substitute player and 29 is tribune player.
- jerseynumber - for Free Agent should be 99 I belive. for other team you want to keep it unique, so better first check if the jersey number is free in the new team.
- form/injury/isamongtopscorers. For form use 3 which is normal form, rest of the values keep on 0. You can try to experiment with these values if you want to.
And the last table is editedplayernames. We need to set custom name for our player because the FUT mode and squadfile/career is using different playernames table. For example in FUT the nameid - 20328 is Ronaldo, but in career mode it can be Namjilyn or anyone else. The simplest fix is to set the name in table mentioned above. The game is at first checking if the name is set in editedplayernames and if it's not then it's pulling the name from
playernames. Not quite sure how it works for commentary names. If the commentary is wrong you may need to set the value of lastnameid in players table to 0. This should remove commentary completely from the player.
- Find first empty record
- playerid is the id of our player. So, for Ronaldinho - 28130
- Other fields can contain anything you want I belive.
- If you want to keep it same as original then in cards_ng_db check what is firstnameid of the icon -> find the id in playernames -> copy the string. Repeat for lastnameid, commonnameid and playerjerseynameid
Done! Now, you just need to repeat all the steps 266 more times to add all icons! Good luck!
Just kidding... It's 2020, you can automate this boring process with any programming language you want. Actually I've automated it for you.
Automate adding icons to squad file
I've written two python scripts which can automate almost the whole process. All you need to do is:
- export the players & teamplayerlinks table with RDBM from squadfile
- run the script
- import back the players, teamplayerlinks and editedplayer names table with all icons added with RDBM
If you don't have python 3 then download and install python 3.7.6 x86 from here
Download the python scripts (squadfile_icons.zip) and unzip it somewhere, can be on desktop.
Open clean, official squad file from EA in RDBM. Then export the players table & teamplayerlinks table. Save these files in directory with the python script -> FIFA 20 -> squadfile
run the add_icons_all.bat file to add all version of icons, or add_icons_baby/middle/prime_only.bat to add only one version.
CMD window should pop up. Wait until it closes, meaning that python script has finished its job.
If everything worked fine you should have 3 new files in the directory with script:
- result_teamplayerlinks.txt
- result_players.txt
- result_editedplayernames.txt
Import these tables to the squadfile with RDBM.
- result_teamplayerlinks.txt to teamplayerlinks table
- result_players.txt to players table
- result_editedplayernames.txt to editedplayernames table
Saving the edited squadfile and loading it in the game
After you have added the icon you can finally save the squadfile and load it in the game.
To save it just click on File -> Save in top left corner
To load in game, from main menu navigate to Customise -> Profile -> Load Squads
And when the squad file is loaded you can finally start a new career with icons by choosing "Use Current Squads" option
Last edited:
