• 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!

oknzl's 12 To 13 Excel Transfer Tool

O

oknzl

Club Supporter
I have made this small tool for myself to transfer over 200 created players from FIFA12 to FIFA13. It is a simple excel file with some macros that do the required work in excel automatically. I don’t know any programming languages to do this so I used my excel knowledge combined with a few simple lines of Visual Basic.

I still create players in FIFA12 with Creation Master and then use this excel tool to transfer it over to FIFA13.

Install it and open the Read Me file where you find a step by step explanation.

FIFA13 has a different player overall rating calculation than FIFA12 therefore when transferring it over this will change. I have chosen an option to leave the specific attribute ratings (e.g. crossing, speed…..) the same and accept the player overall rating change. If someone can give me a player overall rating calculation for FIFA13 I could change this to keep the overall rating as it is in FIFA12 and adjust the specific attribute ratings to match the overall rating.

Also boot IDs are different so what I did is to give every player a generic boot with two colours that match in colour the specific boot (eg Nike boot) assigned to it in FIFA12. Boot matching is in worksheet shoeconversion that can be edited. If someone can match the FIFA12 and FIFA13 boots editing this worksheet will do the job.



I have found one small mistake in the file. I didn't cover the FIFA12 shoetypecode ID (0). Also done some improvements.

Still can’t find anywhere the FIFA13 boot ID list. If everyone knows please give me a link I would like to improve this to match shoes rather than use generic types.

Download link.

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



I have made one for teams transfer also. This was far more complicated than the player tool. I encountered 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
 
J

jschuck12001

Senior Squad
My Excel will only use as read only, I did enable macros, any ideas. The message I get is "The Visual Basic for Applications in this workbook are corrupted and have been deleted".

Oh well, wish I had this 2 weeks ago because all is converted. Just an FYI I use portable Excel and it doesn't work.
 
O

oknzl

Club Supporter
I am not 100% sure but when this message comes up in excel people usually can’t use macros in any excel files on one computer as long they could use the same file on other computers.

Here is a comment find on the internet “The problem turned out to be that VBA was not enabled during the original installation of Office/Excel. After modifying the Office/Excel installation with Add/Remove Programs and enabling VBA, it worked great.”

I have used this on two computers and it worked ok but will try and test it on a laptop also to see if I can get the similar issues.

Please anyone let me know if this happens only for jschuck12001 or it is an issue with the file.

Yes manually to transfer over players is not that hard. The biggest problem for me was that the name IDs changed. Eg Jacob in FIFA12 now in FIFA13 has a different nameID number. Searching for the correct nameID and changing it for every player was a pain in the …
 
O

oknzl

Club Supporter
I just managed yesterday using excel to transfer over a team manually (not macros) and it also worked. Now I have Auckland City FC in FIFA13 (lost all my friendly games). Could make a team transfer tool in excel with macros also but there are a lot of additional info in FIFA13 for example in Leagueteamlinks :teamshortform, hasachivedobjective, unbeatenallcomps …… All this values has to be filled out but there is no relating info in FIFA12. If the attached file for player transfer is not working for anyone else except me there is no point trying. If it works anyone can make similar tools by watching some video explanation how to make macros in excel. If you use excel regularly it is not that complicated.
 
J

jschuck12001

Senior Squad
oknzl;3329744 said:
I just managed yesterday using excel to transfer over a team manually (not macros) and it also worked. Now I have Auckland City FC in FIFA13 (lost all my friendly games). Could make a team transfer tool in excel with macros also but there are a lot of additional info in FIFA13 for example in Leagueteamlinks :teamshortform, hasachivedobjective, unbeatenallcomps …… All this values has to be filled out but there is no relating info in FIFA12. If the attached file for player transfer is not working for anyone else except me there is no point trying. If it works anyone can make similar tools by watching some video explanation how to make macros in excel. If you use excel regularly it is not that complicated.
Click to expand...

Thanks for the response, I do use a portable version of Excel so not sure if that matters and I do use excel a ton so I will just follow what you said and figure out how to enable macros. It worked for bangus so its obviously something on my end. Thanks
 
S

scottish_carson

Senior Squad
Yep, got to agree with Munross, this is such a fantastic little tool that'll save so many modders and patch-makers hours of time, I honestly can't tell you how much I appreciate it!
 
R

rique

Senior Squad
oknzl this little program of yours work great for me, thank you very much
Click to expand...

Yep, got to agree with Munross, this is such a fantastic little tool that'll save so many modders and patch-makers hours of time, I honestly can't tell you how much I appreciate it!
Click to expand...

Ok, Guys so this does work well, right? I'm gonna test it out later.
 
Munross

Munross

Youth Team
rique;3331197 said:
Ok, Guys so this does work well, right? I'm gonna test it out later.
Click to expand...

Yup it does, just follow the instructions as stated. I've already transferred about 30 players over from 12 to 13 without any database bugs.

So oknzl it would be super if you could also make a team transfer tool!:browsmiley::33vff3o:
 
R

rique

Senior Squad
Munross;3331211 said:
Yup it does, just follow the instructions as stated. I've already transferred about 30 players over from 12 to 13 without any database bugs.

So oknzl it would be super if you could also make a team transfer tool!:browsmiley::33vff3o:
Click to expand...

Excellent work! You need to do the team transfer tool...as well...Wonderful...
Simply brilliant.
Cheers, mate.
 
O

oknzl

Club Supporter
I have started working on one for the teams. Will have to do similar adjustments and rearrangements to:

teams, teamstadiumlinks, teamkits, LanguageStrings, formations, teamplayerlinks

There are two possible issues. One is to end up with a huge excel file. I will see what can be done later when more is completed.

The other is what to do with all the new information in FIFA13 that doesn't relate to anything in FIFA12. I will give some default values and a possibility to change it as it is in the latest player transfer file.

I am not sure if I will have time to complete it but I will try.
 
R

rique

Senior Squad
oknzl;3332871 said:
I have started working on one for the teams. Will have to do similar adjustments and rearrangements to:

teams, teamstadiumlinks, teamkits, LanguageStrings, formations, teamplayerlinks

There are two possible issues. One is to end up with a huge excel file. I will see what can be done later when more is completed.

The other is what to do with all the new information in FIFA13 that doesn't relate to anything in FIFA12. I will give some default values and a possibility to change it as it is in the latest player transfer file.

I am not sure if I will have time to complete it but I will try.
Click to expand...

Ok. That's cool. I am doing my patch and I am at the stage of doing team player links and it's killing me. I have about 1,200 created players for COncacaf National teams. It's tough. I guess I'll just have to get started and not wait on your tool. Thanks for the player transfer excel and macros from 12 - 13. Great job, mate.
 
You must log in or register to reply here.


Top