player stats spreadsheet

Can you get all the player stats into a spreadsheet or has anyone done one!

There is no real way of finding the right player you want other than to go into every team and check each player...

That wld be so hard. It would have to be MASSIVE.

Hambo said:

Can you get all the player stats into a spreadsheet or has anyone done one!

Click to expand...

As it happens, yes I have, and TorontoLynx it is just over 2MB as a CSV file. However I am unsure as to what the legal position of such information would be (is it copyright EA, do I get into trouble for reverse engineering the data formats) and therefore I've not made it generally available.

Anyone offer an opinion on the legality of making such a spreadsheet available?? How about simply releasing the program that generates it (and also produces a more comprehensive one for careers along with HTML reports that mirror the information available, but a nightmare to work your way through, in-game)??

I'd be loathe to take on supporting my work, especially since the program itself runs from a 32-bit command line (works fine in Win2K and WinXP and would probably work in a CONAGENT window in Win98, although I've not tried it) which would probably confuse the great unwashed, but as long as EA wouldn't sue my rear end off I'd be willing to make it available on an as-is basis.

Well, i cant offer any advise regarding the lagality of this but i certainly wouldnt mind giving your utility a try Steve.

I would imagine its what you do with the data that would cause the problems. as long as you dont publish it perhaps!! considering all the other fifa tools out there maybe its ok. anyway , as i say id like to give it a go and am not bothered about support, i just want an easy way of browsing the player db!!

cheers
Hambo

look in ur fifa.db file in data/cnf ... if u convert it to a microsoft access file u can fiew a roster of all players.... all 10,099 of them

Hambo said:

anyway , as i say id like to give it a go and am not bothered about support, i just want an easy way of browsing the player db!!

Click to expand...

Okey dokey. Assuming that the email address in your profile is correct you can expect to find a ZIP file in your inbox sometime later this evening (UK time) or possibly tomorrow morning if it takes me longer than expected to churn out enough documentation to get you started.

skip2mylou said:

look in ur fifa.db file in data/cnf ... if u convert it to a microsoft access file u can fiew a roster of all players.... all 10,099 of them

Click to expand...

Two obvious problems spring to mind. Firstly you still need a utility to perform the extract, and secondly you are stuck if you don't have anything that handles .MDB files. My utility produces CSV files, which can be read by almost any spreadsheet or database program.

Oh, and there are 10,994 players in the database as shipped by EA Sports (at least, there are in the UK version). YMMV according to what patches you've applied, of course.

Hambo,

ZIP file sent on its way. Please let me know (via this board) whether or not you've received it

Thanks Steve,
Message reveived
ill give it a try when i get home from work!

cheers
Hambo

Works a treat Steve, well done!

Had a bit of trouble at first, im using the career hack and i got loads of 'unrecognised character' errors but i swapped back my original fifa.db and it worked 1st time.


many thanks
Hambo

Hambo said:

Works a treat Steve, well done!

Click to expand...

Thanks, I'm glad to hear you got what you were looking for from it. How did you get on with the documentation?? Did you just use the tool to generate the CSV file or did you take a look at the HTML reports too?? Any comments on the content??

Hambo said:

Had a bit of trouble at first, im using the career hack and i got loads of 'unrecognised character' errors

Click to expand...

Those character issues shouldn't have stopped it producing a usable set of output files (just that it couldn't 'anglicise' all of the names). Where can I get a copy of this hack to test it out (or would you be willing to run again with the hack in place and send me the console output along with the FIFA.D??

Steve,
The documentation was really good. Really in depth, a lot more than i was expecting
I just ran the .bat file as is (except for editing some of my paths) and it worked no probs.
i didnt have that much time to play with the other output settings, ill have a go at this tonight..

i did snapshot the error messages but i forget to bring them to work with me. i got the liverppol career hack from here somewhere
http://www.soccergaming.tv/showthread.php?t=119085

i will send you my fifa.db if you still want me to.

Have you considered a gui front end to this utility! it would be cool if you could add some filters to the command line like just show me midfielders above skill x etc and use it as a search tool!!

anyways, let me know if you want me to send my db if you havent been able to find one using the above link.

cheers Hambo

Hambo,

Thanks for the kind words - I really wasn't sure that what I'd done would be comprehensible to anyone else.

Hambo said:

The documentation was really good. Really in depth, a lot more than i was expecting

Click to expand...

I can churn out the words when the muse is with me, but I did wonder whether I'd gone OTT with that lot. Still haven't finished the usage guide, but perhaps the thought that this might be useful to others will inspire me further.

Hambo said:

i did snapshot the error messages but i forget to bring them to work with me.

Click to expand...

No worries, if you remember then I'll be grateful, but I think getting hold of the FIFA.DB is probably more useful to me (since that way I'll be able to see what the offending characters look like in the game screens)

Hambo said:

i will send you my fifa.db if you still want me to.

Click to expand...

Yes please. I dug through the thread that you indicated, but the only links to files I can find have all expired. If I get a chance I'll go and dig through the SoccerGaming downloads area, but I need to do some work at some point today

Hambo said:

Have you considered a gui front end to this utility!

Click to expand...

Not until I started writing the Getting Started guide so that you could use what I'd already done!! I am an old dinosaur (when I started out in computing we used punched cards and paper tape) who uses the command line (albeit a seriously enhanced version of the nonsense that MS distributes with their OSes - JP Software's 4NT and Take Command) for a majority of what he does at the computer (when not playing games, obviously).

I write software for a living, but a lot of what I do is designed to run on IBM mainframe computers as well as PCs, so I don't have any need to add GUI front-ends and therefore use Watcom C for most of my Windows programs. Since F2K5DUMP was originally intended solely for 'internal use' I just gave it the capabilities that I needed, and I didn't need Windows getting in the way. I only added the command line options because I got fed up with re-compiling the code just so that it would report on my son's career file rather than my own.

Having said all that I have dug out my copy of C++ Builder v3 and started thinking about what is the minimum necessary to create a front-end to the existing program (it would run the existing program in the background so that I don't have to break the current logic apart and put it back together in a competely different environment). It will take me a while to get back into the GUI RAD stuff (which I haven't touched in the last five years) but I'll try and put something together over the next couple of weeks.

Hambo said:

it would be cool if you could add some filters to the command line like just show me midfielders above skill x etc and use it as a search tool!!

Click to expand...

The main reason that I haven't done anything along those lines is that I load the output CSV file into an Excel spreadsheet and use Excel's AutoFilter feature to select records based on a variety of criteria (I don't use the game's skill levels because I don't agree with the algorithms it uses to calculate them). It would get really messy trying to allow a whole raft of selection criteria to be supplied via command line options, but something similar is on my potential features list for a GUI front-end.

However, most databases and spreadsheets will allow you to do what you're after, so it is really just a question of saving the effort of loading up another program to do the work.

Anyway, thanks for the feedback, and I'd be interested in hearing what you have to say about the other output from the program.

hi Steve,
Did you get my fifa db. i know what hotmail can be like with large files!!

Hambo

Hambo said:

hi Steve,
Did you get my fifa db. i know what hotmail can be like with large files!!

Click to expand...

Picked it up this morning (Saturday) as I haven't had a chance to check my Hotmail in the past thirty-six hours or so.

I'm not surprised that that FIFA.DB didn't give you great results, because it is slightly damaged internally. Three players are assigned to more than one team (although in one case it is the same team) and that triggered a bug in my logic for handling that situation, which was what generated the other errors. I've fixed that now and will ship you out another version which then ought to work with your career file (fingers crossed)

Could someone just email the list to me plz. Thanks in advance.

P.s. Plz provide the potenial stat

NGAFOOTBALLKING said:

Could someone just email the list to me plz

Click to expand...

I think I made my reasons for not providing the information directly pretty clear earlier in the thread, but you might like to know that I'm putting the finishing touches to a GUI front-end to the utility mentioned above, and tried out by Hambo, so you'll be able to generate the player attribute spreadsheet, and a load more besides, for yourself.

well ive got a ps2

NGAFOOTBALLKING said:

well ive got a ps2

Click to expand...

Sorry old son, my work is not going to be of any use to you

Besides, if you are playing career mode things change fairly quickly over the first three or four seasons so that anything you see in the original data is out-of-date. The sleepers don't stay sleepers for very long as they soon start to develop and become more expensive in the process.

Steve,
Just to let you know that your fifaanalyser (beta) app works pretty good. Had no problems with it.

All the player stats in csv is invaluable and the html output is excelent.

thanks
Hambo