TOOL: Roster extracter/importer tool

[smozoma 484]

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)

Source Code

Dennis has provided the source code. Also included is his SRM file editor (which would allow you to fake User Records on an emulator, if you so wished to do...)

 

NHL_Hockey_Roster_Tool.src.zip

[dman72 1]

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.

[PixelDragon 10]

Great tool !

[CamKneely 4]

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 484]

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 4]

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

[PixelDragon 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 484]

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

[PixelDragon 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 144]

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 144]

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 25]

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 62]

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 267]

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 62]

The first player is the 0 offset.

Thank you, I couldn't remember.

[AtomicRaven 25]

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

[smozoma 484]

Source code zip added

 

[Stefan 3]

Is there some way to transfer the players and their ratings from a genesis Rom to an snes one, as opposed to manually copying it? 

[smozoma 484]

7 minutes ago, Stefan said:

Is there some way to transfer the players and their ratings from a genesis Rom to an snes one, as opposed to manually copying it? 

I think the data format is pretty much identical. So you could manually copy/paste the data using a hex editor.

Double-check this first with an original Sega ROM and original SNES ROM, as there may be a few differences. But I think if you look for say Wayne Gretzky in both ROMs, you'll see his data is mostly (if not completely) the same. The one thing that I wouldn' tbe surprised is different is the name length counter (which is the 2 bytes preceding the player name), the bytes might be reversed between Sega/SNES ROMs

[Stefan 3]

Okay.

I guess where I'd be confused is that I'm copying an updated genesis roster to a snes roster so wayne gretzky wont be on the genesis one...

 

Yeah, I tried copying Boston Bruins from Sega to SNES and it totally didn't work.

Any way I could copy the CSV data over from the spreadsheet? 

Edited May 21, 2020 by Stefan

[Stefan 3]

I figure it would be easy to copy over the info from the Genesis to SNES CSV but the formatting is different for each one, and there's different cells for each of them.