smozoma

TOOL: Roster extracter/importer tool

Recommended Posts

Dervin10 made this a couple years ago. really useful.

You can create a CSV file (which can be opened with excel) of the players in a ROM. then you can change the skills of the players and import the players from the CSV back into the ROM.

It works with NHL 94 (and maybe 93?), but as Cam Kneely points out, you can use NOSE to copy rosters from a different game into an NHL 94 ROM, and extract from there.

A couple usage notes:

1: do not change the order of the players

2: do not change the player names, positions, or teams.

You can only change the skills/attributes.

Installation

1: Download and unzip to wherever you want: NHL_Hockey_Roster_Tool.zip

2: Also, this requires the .NET framework. I think version 2.0 will work, but if not, try version 1.1

(if you need to install the framework, can you please tell me which one works so i can update this to be more accurate? thanks)

Share this post


Link to post
Share on other sites
Dervin10 made this a couple years ago. really useful.

You can create a CSV file (which can be opened with excel) of the players in a ROM. then you can change the skills of the players and import the players from the CSV back into the ROM.

A couple usage notes:

1: do not change the order of the players

2: do not change the player names, positions, or teams.

You can only change the skills/attributes.

Installation

1: Download and unzip to wherever you want: NHL_Hockey_Roster_Tool.zip

2: Also, this requires the .NET framework. I think version 2.0 will work, but if not, try version 1.1

(if you need to install the framework, can you please tell me which one works so i can update this to be more accurate? thanks)

Worked like a charm on the first pass, I didn't need to install framework. Thanks again.

Share this post


Link to post
Share on other sites

The extractor only works with 94 roms...but if you use NOSE to copy the rosters over from other roms to 94, it will work.

Share this post


Link to post
Share on other sites

The extractor only works with 94 roms...but if you use NOSE to copy the rosters over from other roms to 94, it will work.

Excellent tip.. wouldn't have thought of that!

Share this post


Link to post
Share on other sites

Thanks. Yeah, I thought I was looking at hours and hours of finger-breaking labor...luckily I thought of this.

Share this post


Link to post
Share on other sites

The extractor only works with 94 roms...but if you use NOSE to copy the rosters over from other roms to 94, it will work.

Can you explain in detail how you manage that ? I'm trying to copy the rosters from nhl 91 to nhl 94...

Share this post


Link to post
Share on other sites

i've never tried it but I think this is how:

open 2 instances of NOSE (2 NOSE windows..)

open a ROM in each NOSE

copy/paste stuff between windows

i have no idea which versions of EA NHL can be copied between, though

Share this post


Link to post
Share on other sites

i've never tried it but I think this is how:

open 2 instances of NOSE (2 NOSE windows..)

open a ROM in each NOSE

copy/paste stuff between windows

i have no idea which versions of EA NHL can be copied between, though

I have got it to work with 94-97 Rom bases.

On a side note, the players are rated differently in 96 and 97 but NOSE will calculate the results for you

Share this post


Link to post
Share on other sites

i've never tried it but I think this is how:

open 2 instances of NOSE (2 NOSE windows..)

open a ROM in each NOSE

copy/paste stuff between windows

i have no idea which versions of EA NHL can be copied between, though

That's what I tried to do... but the number of players in the teams are not the same...

You copy and past, or just past the attributes ?

You delete or create some players first, for having the exact match ?

Share this post


Link to post
Share on other sites

That's what I tried to do... but the number of players in the teams are not the same...

You copy and past, or just past the attributes ?

You delete or create some players first, for having the exact match ?

Yes, you can delete some players, and to make sure you have the same amount of forwards and defense you can adjust the ''Forwards'' number above the rosters in the ''Players'' window.

Edited by PlabaxV2

Share this post


Link to post
Share on other sites

When I used this tool to export the new VHL ROM to a CSV, it leaves out some players? (Well at least one: Ovechkin. But I figure if there is one left out, perhaps there are more?)

The vast majority of players, which it does export, are in tact and uncorrupted.

Any reason why some players would fail to export?

The ROM usd is "NHL16v8.bin" from http://forum.nhl94.com/index.php/topic/17330-nhl16-rom-midseason-update-by-skip/

Share this post


Link to post
Share on other sites

When I used this tool to export the new VHL ROM to a CSV, it leaves out some players? (Well at least one: Ovechkin. But I figure if there is one left out, perhaps there are more?)

The vast majority of players, which it does export, are in tact and uncorrupted.

Any reason why some players would fail to export?

The ROM usd is "NHL16v8.bin" from http://forum.nhl94.com/index.php/topic/17330-nhl16-rom-midseason-update-by-skip/

I just checked and it worked fine. Did you change the number of teams from 28 to 30?

Share this post


Link to post
Share on other sites

I just checked and it worked fine. Did you change the number of teams from 28 to 30?

I did not. That was the problem! Thanks!

Do I just leave "TeamOffset Hex" at "30E"? (I did, but want to make sure.)

Thanks a lot, QD!

Share this post


Link to post
Share on other sites

Hey guys,

Is there a way to get the actual PlayerId's as far as Gens is concerned? The ones spit out of the excel don't seem to match what Gens is outputting.

I'm working on parsing the save games for exhibition matches.

Thanks

Raven

Share this post


Link to post
Share on other sites

I think the 'actual' IDs of the players are team specific and the number is the slot of the player on the team (starting with 0 and going from G-->F-->D, or the same order the program extracts, like an index)

For example, BOS would have Moog as 0, Blue as 1, Oates as 2, Poulin as 3, or CGY would have Vernon as 0, Reese as 1, Nieuwendyk as 2, Reichel as 3 and so on.

---------------------------------

So, if using a database... it would probably look like:

Get PLAYER where TEAM is the team of the player and PLAYERINDEX is the "ID" from the uploader

If you were extracting a goal scored by Adam Oates, the extractor would search for the player on Boston with an index of 2, who is Oates.

Edited by Premium

Share this post


Link to post
Share on other sites

I think the 'actual' IDs of the players are team specific and the number is the slot of the player on the team (starting with 1 and going from G-->F-->D, or the same order the program extracts, like an index)

For example, BOS would have Moog as 1, Blue as 2, Oates as 3, Poulin as 4, or CGY would have Vernon as 1, Reese as 2, Nieuwendyk as 3, Reichel as 4 and so on.

---------------------------------

So, if using a database... it would probably look like:

Get PLAYER where TEAM is the team of the player and PLAYERINDEX is the "ID" from the uploader

If you were extracting a goal scored by Adam Oates, the extractor would search for the player on Boston with an index of 3, who is Oates.

The first player is the 0 offset.

So, in Plabax's example, if it says the 03 for player who scored, it would actually be Poulin and not Oates.

If you are making your own stat extractor, the easiest way would be to have the rosters and team order already extracted and saved in a DB. Upload the game, pull all the game stats (SP1, GP1, SP2, GP2, etc), and player stats (G,A, Chks, TOI, etc), using the team order and roster with offsets to pull the right data for the right team/player, then check the scoring summary and penalty summary. When going through the scoring and penalty summaries, you can use the DB roster with offset to figure out who scored, assisted, got a penalty, etc for displaying purposes in the box score. You would also use the summaries to decide if it was a PP or SH or EV goal, type of assist, PIM for each player, and add that data in the DB if you desire.

Share this post


Link to post
Share on other sites

The first player is the 0 offset.

Thank you, I couldn't remember.

Share this post


Link to post
Share on other sites

Hey guys,

Thanks for the responses and help!

I get it now and have the player data flowing nicely into the db.

Raven

Edited by AtomicRaven

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who's Online   0 Members, 0 Anonymous, 20 Guests (See full list)

    There are no registered users currently online