Hi everyone,

I am trying to convert FIFA 23 DB to FIFA 07.

This is a player example (Joe Cole) of FIFA 07.

This is a player example (Joe Cole) of FIFA 23:

and I am trying to match the fields. Basic fields are the same but there are a lot of fields that do not exist in FIFA 23. Also, the fields that are related to accessories, face, hair and etc. can take different values.

My conversion matrix:

I put a question mark on problematic fields. Do you have any idea what I can do? If I can not find any solution I will just randomise them.

I am trying to convert FIFA 23 DB to FIFA 07.

This is a player example (Joe Cole) of FIFA 07.

JSON:

```
{
"acceleration": "87",
"accessorycolor1": "1",
"accessorycolor2": "3",
"accessorycolor3": "1",
"accessorycolor4": "1",
"accessorycolor5": "1",
"accessoryid1": "4",
"accessoryid2": "8",
"accessoryid3": "0",
"accessoryid4": "0",
"accessoryid5": "0",
"adaptability": "0",
"aggression": "76",
"ambition": "0",
"assetid": "27",
"ballcontrol": "89",
"birthdate": "145757",
"bodysizecode": "2",
"celebration": "0",
"crossing": "82",
"developmentstylecode": "3",
"developmenttypecode": "1",
"dribbling": "91",
"facetypeid": "4",
"facialhairstyleid": "1",
"fansfavourite": "1",
"finishing": "74",
"firstname": "Joe",
"flexibility": "0",
"freekicks": "82",
"gkdiving": "8",
"gkpositioning": "12",
"haircolorid": "2",
"hairtypeid": "16",
"handling": "11",
"heading": "49",
"height": "175",
"highclubidentification": "0",
"hightrainingworkrate": "0",
"inflexible": "0",
"injuryprone": "0",
"internationalreputation": "4",
"leadership": "68",
"learningspeed": "4",
"legtypeid": "5",
"longpassing": "68",
"longshotaccuracy": "81",
"lowclubidentification": "0",
"lowmedhairtypeid": "5",
"lowtrainingworkrate": "0",
"marking": "56",
"mediadarling": "0",
"nationality": "14",
"originalname": "1",
"playercomposure": "82",
"playerid": "27",
"playingstyle": "12",
"potential": "93",
"preferredfoot": "0",
"preferredposition1": "19",
"reactions": "87",
"reflexes": "6",
"retirementage": "33",
"scandalprone": "0",
"shoecolor": "46",
"shortpassing": "87",
"shotpower": "74",
"sleevelength": "0",
"sprintspeed": "83",
"stamina": "86",
"strength": "72",
"surname": "Cole",
"tackling": "64",
"weakfootability": "3",
"weight": "70",
"wouldnotsignfor": "0",
"wouldsignfor": "5"
}
```

This is a player example (Joe Cole) of FIFA 23:

JSON:

```
{
"acceleration": "89",
"accessorycode1": "0",
"accessorycode2": "0",
"accessorycode3": "0",
"accessorycode4": "0",
"accessorycolourcode1": "0",
"accessorycolourcode2": "0",
"accessorycolourcode3": "0",
"accessorycolourcode4": "0",
"aggression": "64",
"agility": "90",
"animfreekickstartposcode": "0",
"animpenaltiesstartposcode": "0",
"attackingworkrate": "2",
"avatarpomid": "0",
"balance": "87",
"ballcontrol": "91",
"birthdate": 139913,
"bodytypecode": "8",
"commonnameid": "0",
"composure": "83",
"contractvaliduntil": "2027",
"crossing": "87",
"curve": "87",
"defensiveawareness": "55",
"defensiveworkrate": "0",
"defspe": "51",
"dribbling": "92",
"driref": "90",
"emotion": "3",
"eyebrowcode": "0",
"eyecolorcode": "2",
"faceposerpreset": "4",
"facialhaircolorcode": "3",
"facialhairtypecode": "0",
"finishing": "85",
"finishingcode1": "0",
"finishingcode2": "0",
"firstname": "Joe",
"firstnameid": "16441",
"freekickaccuracy": "86",
"gender": "0",
"gkdiving": "9",
"gkglovetypecode": "0",
"gkhandling": "6",
"gkkicking": "13",
"gkkickstyle": "0",
"gkpositioning": "16",
"gkreflexes": "7",
"gksavetype": "0",
"haircolorcode": "3",
"hairstylecode": "0",
"hairtypecode": "19",
"hashighqualityhead": "1",
"hasseasonaljersey": "0",
"headassetid": "27",
"headclasscode": "0",
"headingaccuracy": "59",
"headtypecode": "3",
"headvariation": "0",
"height": "176",
"interceptions": "52",
"internationalrep": "3",
"iscustomized": "0",
"isretiring": "0",
"jerseyfit": "0",
"jerseysleevelengthcode": "0",
"jerseystylecode": "0",
"jumping": "79",
"lastnameid": "6972",
"longpassing": "76",
"longshots": "87",
"modifier": "0",
"nationality": "14",
"overallrating": "87",
"pacdiv": "88",
"paskic": "86",
"penalties": "73",
"personality": "4",
"phypos": "72",
"playerid": "27",
"playerjerseynameid": "15443",
"playerjointeamdate": "160273",
"positioning": "80",
"potential": "87",
"preferredfoot": "1",
"preferredposition1": "23",
"preferredposition2": "27",
"preferredposition3": "18",
"preferredposition4": "-1",
"reactions": "81",
"runningcode1": "0",
"runningcode2": "0",
"runstylecode": "0",
"shoecolorcode1": "15",
"shoecolorcode2": "21",
"shoedesigncode": "0",
"shoetypecode": "1",
"shohan": "84",
"shortpassing": "87",
"shortstyle": "0",
"shotpower": "81",
"sideburnscode": "0",
"skillmoves": "3",
"skillmoveslikelihood": "3",
"skintonecode": "3",
"skintypecode": "0",
"slidingtackle": "41",
"smallsidedshoetypecode": "501",
"socklengthcode": "0",
"sprintspeed": "87",
"stamina": "82",
"standingtackle": "46",
"strength": "69",
"surname": "Cole",
"tattooback": "0",
"tattoofront": "0",
"tattoohead": "0",
"tattooleftarm": "0",
"tattooleftleg": "0",
"tattoorightarm": "0",
"tattoorightleg": "0",
"trait1": "67240448",
"trait2": "0",
"usercaneditname": "0",
"vision": "89",
"volleys": "82",
"weakfootabilitytypecode": "4",
"weight": "73"
}
```

and I am trying to match the fields. Basic fields are the same but there are a lot of fields that do not exist in FIFA 23. Also, the fields that are related to accessories, face, hair and etc. can take different values.

My conversion matrix:

JSON:

```
{
{
"acceleration": "same",
"accessorycolor1": "accessorycolourcode1? can be 0 I guess",
"accessorycolor2": "accessorycolourcode2? can be 0 I guess",
"accessorycolor3": "accessorycolourcode3? can be 0 I guess",
"accessorycolor4": "accessorycolourcode4? can be 0 I guess",
"accessorycolor5": "not exist, i will use 0",
"accessoryid1": "accessorycode1? can be 0 I guess",
"accessoryid2": "accessorycode2? can be 0 I guess",
"accessoryid3": "accessorycode3? can be 0 I guess",
"accessoryid4": "accessorycode4? can be 0 I guess",
"accessoryid5": "not exist, i will use 0",
"adaptability": "? takes 0 or 1",
"aggression": "same",
"ambition": "? takes 0 or 1",
"assetid": "same with playerid",
"ballcontrol": "same",
"birthdate": "calculated",
"bodysizecode": "bodytypecode?",
"celebration": "? can be 0 I guess",
"crossing": "same",
"developmentstylecode": "?",
"developmenttypecode": "?",
"dribbling": "same",
"facetypeid": "headtypecode?",
"facialhairstyleid": "facialhairtypecode?",
"fansfavourite": "? takes 0 or 1",
"finishing": "same",
"firstname": "retrieved",
"flexibility": "? takes 0 or 1",
"freekicks": "?",
"gkdiving": "same",
"gkpositioning": "same",
"haircolorid": "haircolorcode?",
"hairtypeid": "hairtypecode?",
"handling": "gkhandling",
"heading": "headingaccuracy",
"height": "same",
"highclubidentification": "? takes 0 or 1",
"hightrainingworkrate": "? takes 0 or 1",
"inflexible": "? takes 0 or 1",
"injuryprone": "? takes 0 or 1",
"internationalreputation": "internationalrep",
"leadership": "? takes int 20-99",
"learningspeed": "? takes int 1-5",
"legtypeid": "?",
"longpassing": "same",
"longshotaccuracy": "longshots",
"lowclubidentification": "? takes 0 or 1",
"lowmedhairtypeid": "?",
"lowtrainingworkrate": "? takes 0 or 1",
"marking": "defensiveawareness? can be use",
"mediadarling": "? takes 0 or 1",
"nationality": "same",
"originalname": "1",
"playercomposure": "? takes int 1-99",
"playerid": "same",
"playingstyle": "? takes int 0-13",
"potential": "same",
"preferredfoot": "same",
"preferredposition1": "same",
"reactions": "same",
"reflexes": "gkreflexes",
"retirementage": "?",
"scandalprone": "? takes 0 or 1",
"shoecolor": "shoecolorcode1?",
"shortpassing": "same",
"shotpower": "same",
"sleevelength": "? takes 0 or 1",
"sprintspeed": "same",
"stamina": "same",
"strength": "same",
"surname": "retrieved",
"tackling": "standingtackle",
"weakfootability": "weakfootabilitytypecode? FIFA07:0-4, FIFA23:1-5 can be use",
"weight": "same",
"wouldnotsignfor": "? can be 0",
"wouldsignfor": "? can be 0"
}
}
```

I put a question mark on problematic fields. Do you have any idea what I can do? If I can not find any solution I will just randomise them.

Last edited: