• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

TUTORIAL: How to Convert FIFA 19 Database to FIFA 16

R

rique1984

Reserves
THIS IS A TUTORIAL ON HOW TO CONVERT FIFA 19 DATABASES AND SQUAD UPDATES TO FIFA 16.

TOOLS NEEDED:

DBMASTER 16
CREATION MASTER 16
MS EXCEL
FIFA 19 Saved Squads DB Tool

In order to successfully convert the FIFA 19 database to FIFA 16 the above tools are necessary. Firstly, you need to get a clean unmodded FIFA 16 database and a FIFA 19 database. There are specific tables that need to be converted. Not all tables need to bo converted.

Here we go:

Firstly, note the tables that need to be converted. These are:

teamstadiumlinks
teams
teamplayerlinks
teamnationlinks
teamkits
teamballs
starratingboundaries(optional)
stadiums(optional)
shoecolors
rowteamnationlinks
rivals
previousteam
players
playernames
playerloans
playerboots
player_grudgelove
manager
leagueteamlinks
leagues
competition


 
Last edited:
JohnnyUA

JohnnyUA

Fan Favourite
rique1984 said:
THIS IS A TUTORIAL ON HOW TO CONVERT FIFA 19 DATABASES AND SQUAD UPDATES TO FIFA 16.

TOOLS NEEDED:

DBMASTER 16
CREATION MASTER 16
MS EXCEL
Click to expand...
Buddy you know how to convert transfers and can do it for FIFA 16?I think for me it will be difficult to make it.And I can test db for you :)
 
R

rique1984

Reserves
Johnny28ua said:
Buddy you know how to convert transfers and can do it for FIFA 16?I think for me it will be difficult to make it.And I can test db for you :)
Click to expand...
YEAH, I DO MATE. I AM CONVERTING THE SQUAD UPDATE FROM LAST WEEK.
DOES A NEW FIFA 19 SQUAD UPDATE COME OUT TODAY? FOR THE TUTORIAL
I WILL CONVERT LAST WEEK'S SQUAD AND CONVERT THIS WEEK'S SQUAD
UPDATE TOMORROW.

P.S. YOU CAN TEST THE CONVERTS FOR ME...NO PROBLEM, MATE
 
JohnnyUA

JohnnyUA

Fan Favourite
rique1984 said:
YEAH, I DO MATE. I AM CONVERTING THE SQUAD UPDATE FROM LAST WEEK.
DOES A NEW FIFA 19 SQUAD UPDATE COME OUT TODAY? FOR THE TUTORIAL
I WILL CONVERT LAST WEEK'S SQUAD AND CONVERT THIS WEEK'S SQUAD
UPDATE TOMORROW.

P.S. YOU CAN TEST THE CONVERTS FOR ME...NO PROBLEM, MATE
Click to expand...
yes buddy:)
 
R

rique1984

Reserves
(1) Open both the FIFA 19 database and FIFA 16 database with DB Master 18. Then extract these tables into any folder

Screenshot (52)_0.png


You can extract the specific tables that were listed or choose to extract all tables

(2) Open these tables with MS Excel

Screenshot (100).png


Compare the headings for FIFA 19 tables and FIFA 16 tables. In FIFA 19 there are some tables that are not present in FIFA 16. Delete these tables from FIFA 19 tables.

Screenshot (84).png


In this example...clubworth is in FIFA 19 but not FIFA 16. Delete this entry. You will continue this process in all tables.
***IN SOME INSTANCES TABLES FROM FIFA 19 NEED TO REARRANGED INTO EXCEL TO MATCH WITH THOSE IN FIFA 19.
THE ORDER THE TABLES APPEAR IN MUST BE IDENTICAL FOR THEM TO BE ABLE TO IMPORT THESE TABLES INTO THE FIFA
16 DATABASE.
Screenshot (90).png

Once this is completed, import these edited tables into FIFA 16 default database and everything should be completed.

NB*** SOME TABLES IN FIFA 19 AND FIFA 16 ARE IDENTICAL SUCH AS PLAYERLOANS, PLAYER_GRUDGELOVE AND TEAMBALLS AND STARRATING BOUNDARIES.
YOU CAN SIMPLY IMPORT THESE. HOWEVER, SOME TABLES ARE IDENTICAL BUT NEED TO BE REARRANGED. AN EXAMPLE OF THIS IS ROWTEAMNATIONLINKS. THIS SHOULD BE DONE. IN FIFA 16 THE COLUMN NATIONID IS FIRST AND TEAMID IS SECOND. IN FIFA 19 THIS IS THE OPPOSITE. THIS NEEDS TO BE EDITED TO REFLECT THIS. SOME ENTRIES IN FIFA 19 MAY ALSO BE HIGHER THAN A CORRESPONDING ENTRY IN FIFA 16. FOR EXAMPLE:

(haircolorcode 13 - red hair - FIFA 16 MAXIMUM VALUE IS 12
facialhairtype 17 (shaved), 16 - (shaved) - IN FIFA 16 MAXIMUM VALUE IS 15
hairtypecode 541 -women hair low - IN FIFA 16 MAXIMUM MAXIMUM VALUE IS 540
bodytypecode 18 - sydney leroux women - IN FIFA 16 MAXIMUM VALUE IS 17)


THESE FILES CAN BE RE-IMPORTED USING DBMASTER 18...
 
Last edited:
R

rique1984

Reserves
TABLES CONVERTED FROM FIFA 19 DEFAULT DATABASE TO FIFA 16:



 

Attachments

  • competition_19_16.txt
    2.3 KB · Views: 306
  • leagues_19_16.txt
    3.7 KB · Views: 302
  • playerboots_19_16.txt
    16.7 KB · Views: 220
  • manager_19_16.txt
    24.8 KB · Views: 295
  • leagueteamlinks_19_16.txt
    122.6 KB · Views: 290
R

rique1984

Reserves
ADDITIONAL FILES:
 

Attachments

  • rowteamnationlinks_19_16.txt
    590 bytes · Views: 239
  • stadiums_19_16.txt
    40.9 KB · Views: 275
  • teamnationlinks_19_16.txt
    1.2 KB · Views: 273
  • teams_19_16_1.txt
    339.2 KB · Views: 259
Papinho81

Papinho81

Reserves
Thank you for the tutorial!

What about columns for a specific table that exist in the two versions (19 and 16) but that have values in 19 that do not exist in 16? Example, playertaits in the players.txt table (and many others...)?
 
You must log in or register to reply here.


Top