TUTORIAL: How to Convert FIFA 19 Database to FIFA 16

Discussion in 'FIFA 16 Mods, Patches and Total Conversions' started by rique1984, May 4, 2019.

  1. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    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: May 5, 2019
  2. Johnny28ua

    Johnny28ua Starting XI

    Joined:
    Aug 10, 2017
    Messages:
    2,572
    Likes Received:
    2,738
    Location:
    Ukraine
    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 :)
     
  3. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    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
     
  4. Johnny28ua

    Johnny28ua Starting XI

    Joined:
    Aug 10, 2017
    Messages:
    2,572
    Likes Received:
    2,738
    Location:
    Ukraine
    yes buddy:)
     
  5. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    (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: May 5, 2019
    Johnny28ua likes this.
  6. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    TABLES CONVERTED FROM FIFA 19 DEFAULT DATABASE TO FIFA 16:



     

    Attached Files:

    Johnny28ua likes this.
  7. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    ADDITIONAL FILES:
     

    Attached Files:

    Johnny28ua likes this.
  8. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    ADDITIONAL FILES:

     

    Attached Files:

    Johnny28ua likes this.
  9. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
  10. Papinho81

    Papinho81 Club Supporter

    Joined:
    Aug 26, 2017
    Messages:
    210
    Likes Received:
    165
    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...)?
     
  11. kotiara6863

    kotiara6863 Youth Team

    Joined:
    Feb 22, 2016
    Messages:
    728
    Likes Received:
    1,252
    Where can I find DB Master 18? Nothing to find.
     
  12. rique1984

    rique1984 Reserves

    Joined:
    Sep 15, 2017
    Messages:
    878
    Likes Received:
    2,009
    I will upload the link.
     
    Lord Grim likes this.
  13. Lord Grim

    Lord Grim Club Supporter

    Joined:
    Oct 30, 2018
    Messages:
    26
    Likes Received:
    12
    Please upload other tools also
     
      

Share This Page