FIFA 13 IDs

hayman

Club Supporter
You can get 'em yourself. It ain't that hard. ;)

Use DBM12 and export de players and the playernames tables. Open it in Excel.

Filter in "players" on "headclasscode" 0 = specific and 1=generic.

Then cut the line lastnameID from "players" into "playernames".

Make sure it's: 1: lastnameID, 2: nameID 3:name

Then create/use the following macro:

Code:
Sub Change()
    Dim rng As Range, rng2 As Range, cl As Variant
    
    Set rng = Range("A1").CurrentRegion.Columns(1)
    Set rng2 = rng.Offset(, 1).Resize(rng.Rows.Count, 2)
    For Each cl In rng.Cells
        If Application.WorksheetFunction.CountIf(rng.Offset(, 1), cl.Value) > 0 Then
            rng.Replace What:=cl.Value, Replacement:=Application.WorksheetFunction.VLookup(cl.Value, Cells(1, 2).Resize(rng.Rows.Count, 2), 2, 0), LookAt:=xlWhole
        End If
    Next
End Sub

Use the same trick and macro on 1:commonnameID 2: nameID 3:name
And VOILA! Put commonname ID and lastnameID together and you'll have your list!
 

regularcat

Manager
Moderator
root4rulez;3322136 said:
When export i dont see the name of the player

you wont, you need to get the player names table too & get the names from the ids in the player table, like i said its a lot of work nobody is going to do.
 

hayman

Club Supporter
It isn't that much work if you use the macro, I've written how to do it!
root4rulez should at least have tried it!!!!!

Anyway, I used the macro, it took me 2 minutes to generate and create your list. I can't attach it to this message. Maybe someone else can upload it somewhere?

It has one sheet with the macro written in it, one sheet on wich I used the macro, one with all the date from "players" loaden from the fifa13 database and one sheet for your generic (without commonnames) and one for the specific faces (with commonnames).
 

Mulrooney

Youth Team
does anybody know the id for the Euro qualifiers or the Euro Cup's itself or are they same as the World Cup ID 511 ?
 

AcidPT

Club Supporter
Does anyone have the tournament id's? I can't find the Euro anywhere, is it the same as the World Cup?
 

blueboy73

Club Supporter
hayman;3321845 said:
You can get 'em yourself. It ain't that hard. ;)

Use DBM12 and export de players and the playernames tables. Open it in Excel.

Filter in "players" on "headclasscode" 0 = specific and 1=generic.

Then cut the line lastnameID from "players" into "playernames".

Make sure it's: 1: lastnameID, 2: nameID 3:name

Then create/use the following macro:

Code:
Sub Change()
    Dim rng As Range, rng2 As Range, cl As Variant
    
    Set rng = Range("A1").CurrentRegion.Columns(1)
    Set rng2 = rng.Offset(, 1).Resize(rng.Rows.Count, 2)
    For Each cl In rng.Cells
        If Application.WorksheetFunction.CountIf(rng.Offset(, 1), cl.Value) > 0 Then
            rng.Replace What:=cl.Value, Replacement:=Application.WorksheetFunction.VLookup(cl.Value, Cells(1, 2).Resize(rng.Rows.Count, 2), 2, 0), LookAt:=xlWhole
        End If
    Next
End Sub

Use the same trick and macro on 1:commonnameID 2: nameID 3:name
And VOILA! Put commonname ID and lastnameID together and you'll have your list!

Could you elaborate on this a bit more please , i followed what you said but it doesn't seem to work i'm not entirely sure if i'm doing the macro right,bit of a newbie me. Thanks
 

hayman

Club Supporter
If you send me a pm with your email address I can send you the complete file.

elaboration:
If you export the database files from DBM12 you'll get a txt file, which you can open in excel. Do so.

In excel you can filter on headclasscode (which is a common or specifiek face, the number 0 equals a specific face, 1 equals a generic face).

%(If you want, you can open a new excel. Copy the player ID table in this new file for your face list with ID's.)

Then you'll have to copy, paste the "lastnameID"-table into a the playername.txt opened as excel file.

Make sure you'll paste in as a new row A.
You'll see
A: lastnameID (is a number) *new in this document
B: nameID (is a numer, corresponding to C) *already existing in playername.txt
C: name (is the name) *already existing in playername.txt

Then create a new macro. Go to the editor and copy/paste the macro code, save it. When you go to macro overview, you can run the macro (it's called "Change"). It changes the LastnameID from number to name.
You can copy the lastnameID table which are now names, next to the playerID table in your player.txt or new file. Now you'll have a list with player ID's and corresponding names of all the specific faces in fifa.

note: Do the same thing on commonnames! Some player are not known by first and lastname, but by a commonname (for example: Nani, Kaka, and many others).
 


Top