TOOL: Roster extracter/importer tool

[smozoma 341]

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)

[dman72 0]

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.

[Pearate 10]

Great tool !

[CamKneely 3]

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.

[smozoma 341]

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!

[CamKneely 3]

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

[Pearate 10]

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...

[smozoma 341]

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

[PlabaxV2 0]

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

[Pearate 10]

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 ?

[PlabaxV2 0]

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 November 9, 2012 by PlabaxV2

[aqualizard 122]

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/

[Quadruple Deke 1]

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?

[aqualizard 122]

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!

[AtomicRaven 16]

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

[Premium 52]

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 July 5, 2016 by Premium

[chaos 164]

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.

[Premium 52]

The first player is the 0 offset.

Thank you, I couldn't remember.

[AtomicRaven 16]

Hey guys,

Thanks for the responses and help!

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

Raven

Edited July 5, 2016 by AtomicRaven