oknzl's 12 To 13 Excel Transfer Tool

[jovanu1992]

help me please

hello i am useing your tool. and i have exported the tables players and playernames out of my fifa but when i use your exel file, i get an error.

i have microsoft office excel 2007 and i get error 1004. can you please help me? because i would like to create new players easlier.

 

[oknzl]

It is very important to follow the instruction in the Read Me file.

This tool is for transferring players from FIFA12 to FIFA13 so you have to extract the players and playernames from FIFA12 and place it to CProgram Files\FIFA13 Excel Tools\FIFA12 then do the same thing with FIFA13 but this time place the players and playernames to CProgram Files\FIFA13 Excel Tools\FIFA13. I can get the same error if I don’t put the files to the exact specified place. It is an error because it can’t find the txt files in the specified folder position. If you did according to the Read Me instruction it should work.

If you still got an error 1004 click on debug write here the line that is in yellow and also move up till you find a comment like this “read in FIFA12 players database”. This will tell exactly what causes the error. Then close the VB and click ok.

 

[skeptik]

i just started using your macro-excel tools, and one question raised. Is there a way to do batch transfers of players.

ADD : I think I found out how to do that. Thanks for the excel tools. It helps a lot. In fact it ease my work converting MSL4FIFA12 to future FIFA13 version.

Sorry to bother you.

 

[oknzl]

I have made one for teams transfer also. This was far more complicated than the player tool. I encountered a issues around the language database file. Because of this there are a few things required to be done that was not required in player transfer. LanguageStrings.txt has to be opened with notepad and re-saved with Unicode encoding. Also when LanguageStrings is reloaded in DB Master hashids has to be recalculated. (Hash calculation formula is unknown to me).

I have tested this only on one team so strongly recommend making a backup copy of your latest fifa_ng_db-meta, fifa_ng_db, and any language files that you are to modify (for examle eng_us-meta and eng_us)

Download link.

http://www.mediafire.com/?ngdhifh91x57rpu

 

[oknzl]

One thing that I would like to attempt it is to make a tool for creating tournaments. I don’t really know a lot about the files required to be edited. As far as I know first need to extract the compdata/data txt files from data1, then add to these files and add to the LanguegeStrings.

Can anyone upload the original extracted compdata files I have never managed to run File Master 12 on my computer. Other BIG extractors are making unreadable text files.

I have the compdata txt files in FIFA12 but don’t really understand it because there are only numbers. I have been searching for explanations for a very long time (spent days and days) but no luck. If someone can write a short explanation what each column is in each file and upload the extracted original compdata files I would take it from there and attempt to make a useful tool.

I already tested compdata txt files from FIFA12 and it is not hard to manipulate it in excel.

UPDATE:
I have figured out that I need an empty FIFA12 folder in C\Program Files (x86)\EA Sports not in C\Program Files\EA Sports for File Master 12 and exported the files. Now I need to study the txt files to understand it. When I find a good explanation or figure it out will try to make something.

 

[pauloco]

i transfer player one by one?? But, there´s no way to transfer, like transfers 300 players once?

 

[pauloco]

oknzl's toll its not working for me, whay i doing wrong, doing like txt file.
i put the FIFA 12 ID and excell create a player
i put ID 187438(vanderson) and excell think is ID 187426 (Isaí Arredondo)

 

[oknzl]

i transfer player one by one?? But, there´s no way to transfer, like transfers 300 players once?

Unfortunately excel is not a real programming language and it would be very complicated to make one that will allow transferring multiple players with one click. You can transfer thousands in one opening by building up the transfer list. Select and click on Transfer Player one by one building up a transfer list before you click on export.

In earlier versions players had their names in the player table but recently it is kept in the playernames and it is required to search for the playername in fifa13, match it to fifa12 playername and use the new name ID for every player, before it can be added to FIFA13.

If you think this is hard then imagine before this toll patch makers use to do this in excel manually adjusting the FIFA12 database filling out the new columns and matching every player’s name to a new FIFA13 database.

 

[oknzl]

oknzl's toll its not working for me, whay i doing wrong, doing like txt file.
i put the FIFA 12 ID and excell create a player
i put ID 187438(vanderson) and excell think is ID 187426 (Isaí Arredondo)

I noticed that your database is not sorted by the player ID number. That is strange because whenever I export the players from my FIFA12 with DB Master 12 I got them sorted by player ID. Because of this I didn't add a macro line to sort the FIFA12 database by playerid after importing. Please check the following:

Playernames12 should be sorted by nameid (smallest to largest)
Players12 should be sorted by playerid (smallest to largest)
Players12to13 should be sorted by playerid (smallest to largest)
Playernames13byname should be sorted by name (A to Z)
Playernames13byid should be sorted by playerid (smallest to largest)
Players13byid should be sorted by playerid (smallest to largest)

This has to be sorted like this because excels “Lookup” formula is case sensitive. The simplest solution is if required to sort the sheets manually before you start transferring players. Otherwise if you tell me the sheet that is not sorted as mentioned above I can add a macro line and upload a new version.

 

[pauloco]

Only sort by... its working, i think
thank you master.
Will export and tell ya

 

[pauloco]

and... the teams the list need sorted by teamid or playerid. Thank you for amazing tools

 

[pauloco]

interesting the players with fifa12 id has many many many many hidden avatar picture, as Fernando Henrique dos Anjos (id:135287) imported by me, have a different picture than fifa12. already have brazilian serieb, old squad but...going.
So i trying to work serieb in carreer using sonata-kleguea

 

[Mr. NDH]

Help me i cant run transform players from 12 to 13! i get run-time 1004 error it cant refresh what should I do,guys?

 

[oknzl]

Help me i cant run transform players from 12 to 13! i get run-time 1004 error it cant refresh what should I do,guys?

If you are using Excel 2007 this is the problem:

Excel 2007 users will not be able to run any macros automatically because it is not part of standard installation.

Check out this link for the solution.

http://www.excel-vba.com/vba-excel-install.htm

 

[Mr. NDH]

If you are using Excel 2007 this is the problem:

Excel 2007 users will not be able to run any macros automatically because it is not part of standard installation.

Check out this link for the solution.

http://www.excel-vba.com/vba-excel-install.htm

Well i would be happy if thats the case but it isnt i have excel 2003! I opened that file i press enable macros then i press trasfer players from fifa 12 to fifa 13 and i get "run-time 1004 error cant refresh" then i press debug and i get this http://postimage.org/image/bbk0zo7rv/

 

[oknzl]

Well i would be happy if thats the case but it isnt i have excel 2003! I opened that file i press enable macros then i press trasfer players from fifa 12 to fifa 13 and i get "run-time 1004 error cant refresh" then i press debug and i get this http://postimage.org/image/bbk0zo7rv/

Ok you are running the macros that is clear. You have to read the file “Read me” and follow the instructions step by step. This will not just help you transfer the players it will also explain how to transfer the graphic files like specific faces and minifaces. This issue already come up in this forum.

“It is very important to follow the instruction in the Read Me file.

This tool is for transferring players from FIFA12 to FIFA13 so you have to extract the players and playernames from FIFA12 and place it to C\Program Files\FIFA13 Excel Tools\FIFA12 then do the same thing with FIFA13 but this time place the players and playernames to C\Program Files\FIFA13 Excel Tools\FIFA13. I can get the same error if I don’t put the files to the exact specified place. It is an error because it can’t find the txt files in the specified folder position. If you did according to the Read Me instruction it should work.”

The macro stops working basically because a few lines up from that yellow you have a line “TEXT;C\Program Files\FIFA13 Excel Tools\FIFA12\playernames.txt” and it cant find the file in that position.

 

[Mr. NDH]

Sorry for being an asshole but it far more complicated than i thought! Ive unpacked it and it worked ive set the original playernames.txt and players.txt after a minute of transfering i get this http://postimage.org/image/tb31flw3l/ Run-time error 438 Object doesn't support this property or method

 

[oknzl]

Sorry for being an asshole but it far more complicated than i thought! Ive unpacked it and it worked ive set the original playernames.txt and players.txt after a minute of transfering i get this http://postimage.org/image/tb31flw3l/ Run-time error 438 Object doesn't support this property or method

The macro runs and I can see it reads in the files and it stops at the next thing and that is sorting.

Unfortunately I think it is a non-compatibility issue of an older excel with a code that is for a newer version. The bad news is that even if we sort this out it may be some other code lines that will become an issue in Excel 2003.

I don’t have an older Excel to confirm this theory but I have found that the code line I used it has been introduced in Excel 2007 as long before that it was a different code.

See the following.

http://www.mrexcel.com/forum/excel-...ding-macros-07-excel-attempting-run-03-a.html

Excel 2007 or later code:

ActiveWorkbook.Worksheets("playernames13byname").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("playernames13byname").Sort.SortFields.Add Key:= _
Range("A2:A50000"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption _
:=xlSortNormal
With ActiveWorkbook.Worksheets("playernames13byname").Sort
.SetRange Range("A1:C50000")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin


Based on information the equivalent code in Excel 2003 should be:


ActiveWorkbook.Worksheets("playernames13byname").Range("A2:C50000").Sort _
key1:=Range("A1"), order1:=xlAscending, DataOption1:=xlSortTextAsNumbers, _
Header = xlYes, _
MatchCase:=False, _
Orientation:=xlTopToBottom, _
SortMethod:=xlPinYin

I can’t really help you on this because it would require rewriting all sorting codes and it is full of it.

 

[Mr. NDH]

The macro runs and I can see it reads in the files and it stops at the next thing and that is sorting.

Unfortunately I think it is a non-compatibility issue of an older excel with a code that is for a newer version. The bad news is that even if we sort this out it may be some other code lines that will become an issue in Excel 2003.

I don’t have an older Excel to confirm this theory but I have found that the code line I used it has been introduced in Excel 2007 as long before that it was a different code.

See the following.

http://www.mrexcel.com/forum/excel-...ding-macros-07-excel-attempting-run-03-a.html

Excel 2007 or later code:

ActiveWorkbook.Worksheets("playernames13byname").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("playernames13byname").Sort.SortFields.Add Key:= _
Range("A2:A50000"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption _
:=xlSortNormal
With ActiveWorkbook.Worksheets("playernames13byname").Sort
.SetRange Range("A1:C50000")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin


Based on information the equivalent code in Excel 2003 should be:


ActiveWorkbook.Worksheets("playernames13byname").Range("A2:C50000").Sort _
key1:=Range("A1"), order1:=xlAscending, DataOption1:=xlSortTextAsNumbers, _
Header = xlYes, _
MatchCase:=False, _
Orientation:=xlTopToBottom, _
SortMethod:=xlPinYin

I can’t really help you on this because it would require rewriting all sorting codes and it is full of it.

Now i have type 13 mismatch when clicking on transfer player (If Sheets("playeradd").Range("A2") <> "" Then)

 

[oknzl]

Now i have type 13 mismatch when clicking on transfer player (If Sheets("playeradd").Range("A2") <> "" Then)

You managed to pass the transform12to13 macro.

In the transferplayer macro try to replace this line:

If Sheets("playeradd").Range("A2") <> "" Then

With this:

If Not Sheets("playeradd").Range("A2").Value = "" Then

If this dosent work try this:

Dim Check1 As Variant
Check1 = Sheets("playeradd").Range("A2").Value
If Not Check1 = "" Then

As I mentioned before I can’t check if this will work. In Excel 2010 all of the above works.

You will also have to fix 3 sorting codes that will follow after this.