1992/93: Lawrence97's Roster Update

[Anch]

I'll do that
As a disclaimer/warning: lack of time and experience means that I haven't done the player attributes for the few hundred players that have been added. I'll see if I can rectify that.

And does anyone have any ideas on how to handle the major junior franchises that didn't exist in 92/93? For instance, that season there were 16 OHL teams, but there's 20 in the game.

[nino33]

As a disclaimer/warning: lack of time and experience means that I haven't done the player attributes for the few hundred players that have been added. I'll see if I can rectify that.

My two cents...Player Role, CA/PA and Offensive/Defensive Role are the ones to focus on if possible; more details here http://www.ehmtheblueline.com/forums/vi ... 10&t=16778

And does anyone have any ideas on how to handle the major junior franchises that didn't exist in 92/93? For instance, that season there were 16 OHL teams, but there's 20 in the game.

In the future we should be able to edit # of teams in a league with Archi's work-in-progress EHM Editor (see his September 23rd post for the latest development update http://www.ehmtheblueline.com/forums/vi ... 10&t=16778)

For now, my recommendation for handling franchises that didn't exist in retro databases is the "underdatabase" - essentially create a blank version of the database you're working on using the EHM Updater, then create a game with the blank database and at startup select all possible "add players/staff" options, and then export your newly created fake database using the EHM Assistant.....then you can use the fake players/staff as necessary to fill in the franchises that didn't exist (I also recommend doing a quick review of the fake players/staff and editing/deleting as necessary to ensure no one fake is elite). The underdatabase is explained more here http://www.ehmtheblueline.com/forums/vi ... 10&t=16779

[Anch]

Thank you very much for the help!
Looks like I have some balancing to do with regards to OR/DR for the new players...
The "underdatabase" seems like an interesting solution. I'll take a deeper look at that after the NHL teams' rosters and staff are finished.

[Anch]

Work has been progressing nicely, but that strange error where you can't even open the database with the DB Editor without the game then going crazy about "player in the squad without a contract" means that I'll have to use the pre-game editor to remove every guy who's playing for a club but lacks a contract.

Does anyone know of a less time-consuming way to fix the problem?

[archibalduk]

Could you post a screenshot of the error you're getting?

[Anch]

Strangely enough, the problem is no longer showing up after I removed some contract-less players and imported the database again. I've no idea how and why that worked, but I'm delighted it did
If the problem shows up again, I'll post a screenshot.

[Anch]

And now the problem is back:
http://imageshack.com/a/img923/4739/sMycGK.png

It's the same one that I get if I open up UUDB v6.1 in the DB Editor.

[archibalduk]

It sounds like you have a player or non-player with their Club Contracted set as blank/free agent but the Club Playing For is set to a team.

Have you been using the EHM Updater at all? You can use the Updater to export a list of all players and non-players in the database (aka a Staff list). You can then filter through it using Excel and identify any persons with a Club Contracted/Playing For mismatch. If it's not that, then it must be a bug with the way in which the club roster is updated in the Pre-Game Editor (I'm assuming this is what you're using to edit the DB) - but I would be extremely surprised if it were that.

If you are not sure how to use the Updater, drop me an email with a copy of your database and I can check for you (archibalduk @ gmail . com).

[Anch]

There's a couple thousand players with Club Playing set to a team but Club Contracted set to blank. I've been using the Pre-Game Editor to sift through the leagues and remove them. Once they're all removed, I'll use the Updater to see if there's anyone I've missed.

On a related note: The mod seems to be based on UUDB, which means that there is a LOT of minor leaguers born in the 70's and 80's. I'm a little worried that they may cause problems, like for instance making young future stars retire due to not finding a club to play for. Is that something to be concerned about? And is there anyway to remove players from a database?

And thanks!

Edit: Another thing, I tried setting everyone as an FA via the Updater. That doesn't affect the Pre-game Editor though. For example, while Pierre Turgeon is an FA in the Updater, loading the same database in the Pre-game Editor still shows him as signed to the New York Islanders. I've no idea why that is or what it means, but I am definitely looking forwards to the next version of the Editor!

[archibalduk]

There's a couple thousand players with Club Playing set to a team but Club Contracted set to blank. I've been using the Pre-Game Editor to sift through the leagues and remove them. Once they're all removed, I'll use the Updater to see if there's anyone I've missed.

You can use the contract_update spreadsheet in the Updater to quickly make changes like this. You just list all of the changes you want to make in your contract_update file and then import it via the Updater.

On a related note: The mod seems to be based on UUDB, which means that there is a LOT of minor leaguers born in the 70's and 80's. I'm a little worried that they may cause problems, like for instance making young future stars retire due to not finding a club to play for. Is that something to be concerned about? And is there anyway to remove players from a database?

This is a question for Nino/CJ I think! However, you can retire players en masse using the contract_update file I mention above.

Edit: Another thing, I tried setting everyone as an FA via the Updater. That doesn't affect the Pre-game Editor though. For example, while Pierre Turgeon is an FA in the Updater, loading the same database in the Pre-game Editor still shows him as signed to the New York Islanders. I've no idea why that is or what it means, but I am definitely looking forwards to the next version of the Editor!

It sounds like you're not saving the DB.

Alternatively, you're not using Run as Admin when loading either the Pre-Game Editor or the Updater. If you don't use Run as Admin and your DB is saved in C:\Program Files\...\ then you end up with two copies of the DB (there will be one located in your Users\...\Roaming\ folder with those changes made where Run as Admin was not used).

[Anch]

You can use the contract_update spreadsheet in the Updater to quickly make changes like this. You just list all of the changes you want to make in your contract_update file and then import it via the Updater.

That's beautiful, thanks! I'd missed the Updater.

It sounds like you're not saving the DB.

Alternatively, you're not using Run as Admin when loading either the Pre-Game Editor or the Updater. If you don't use Run as Admin and your DB is saved in C:\Program Files\...\ then you end up with two copies of the DB (there will be one located in your Users\...\Roaming\ folder with those changes made where Run as Admin was not used).

No, it's the same file. I just checked it again: Removed all contracts and save in the DB Editor, loaded the database in the Pre-game editor and the contracts are still there. It's the same copy of the database, and everyone's an FA when I load it in the DB Editor again. This is more strange than an immediate problem though.

[nino33]

On a related note: The mod seems to be based on UUDB, which means that there is a LOT of minor leaguers born in the 70's and 80's. I'm a little worried that they may cause problems, like for instance making young future stars retire due to not finding a club to play for. Is that something to be concerned about? And is there anyway to remove players from a database?

This is a question for Nino/CJ I think! However, you can retire players en masse using the contract_update file I mention above.

I wouldn't think that would be a problem, but I don't know 100% for sure



With the retro databases I've created/worked on, all such "extra" real players (and staff) that didn't connect to the new start date were deleted and players/staff that were kept from the original database had their Age and Attributes and Team adjusted to fit the new start date

The 1974 database (that I haven't worked on in years) has only 4,180 players, because there's no underdatabase (a recent idea).
The 1998 database has an underdatabase, and has 26,404 players.

[Anch]

After a bit of fiddling around and a lot of cursing, I've figured out how to use the Updater and all Uncontracted roster players have been removed

The 1992 database has 350002 players, 21524 of which were born after 1980. That seems excessive, as do the 6500 players with a PA of between 0 and 50.

[archibalduk]

No, it's the same file. I just checked it again: Removed all contracts and save in the DB Editor, loaded the database in the Pre-game editor and the contracts are still there. It's the same copy of the database, and everyone's an FA when I load it in the DB Editor again. This is more strange than an immediate problem though.

You shouldn't be using the EHM Editor at all. That will edit the EHM 1 format database which is completely separate from the EHM 2007 format database (i.e. they are two separate databases - which explains why you're not seeing changes in one from the other). So you should only use the Pre-Game Editor and the Updater.

[Anch]

Of course, I somehow managed to forget that!
But how do you edit player roles without it?

[archibalduk]

Use the EHM Updater to edit player roles (use the attribute_update sheet). I recommend keeping a list of all player roles in an attribute_update sheet. When you edit a player in the Pre-Game Editor his player role will be erased because the Pre-Game Editor is not compatible with them (but editing goalie roles is ok). So it's best just to keep a backup list in a separate attribute_update file which you can import each time you want to test or release your database.

[nino33]

The 1992 database has 350002 players, 21524 of which were born after 1980. That seems excessive, as do the 6500 players with a PA of between 0 and 50.

If you wanted to, you can use the EHM Updater to remove those of the 21,524 players you don't want

• use the Updater to export the players (exported_attributes file), then sort to get those born after 1980
• sort those born after 1980 by PA, and remove all those with a PA that is not "NHL worthy" (this should ensure you don't remove any "future NHLers" that are supposed to be in the 1992 database)
• copy/paste the list of players into a contract_update file and set them all to Retire & then use the Database Optimization button in the EHM Updater to delete all those retired

The 1992 database has 350002 players, 21524 of which were born after 1980. That seems excessive, as do the 6500 players with a PA of between 0 and 50.

The current modern database (TBL 8.2) has 7,013 players with a PA of between 0 and 50

[Anch]

archibalduk, you may want to add a link to the Updater 2.0.6 here: http://www.ehmtheblueline.com/forums/vi ... 10&t=11154
I downloaded 2.0.5 first - which doesn't have the player roles and is why I asked about them - and a quick search suggested that I'm not the only one who's made that mistake.

Anyway, in order to not derail this thread completely and make it about Anch's adventures learning how to mod EHM, here's a status update:
NHL teams: Rosters are complete and roughly equivalent to what they were on the 3/9 1992. This includes minor leaguers, signed prospects and the rights to more prominent (and a few less so) prospects.
OTT and TBL have the players picked in the 93 expansion draft assigned to them, with later trades accounted for.
ATL, COL, FLA, MDA, MIN and NSH have got rosters consisting of minor leaguers, a few players that retired after the 91-92 season IRL, the odd undrafted college player and a mix of Finns, Swedes and Russians who had limited NHL experience IRL.
NHL staffs are updated to match the 92-93 season, although ownership remains to be included.
OHL: All 16 historical teams have mostly correct rosters consisting of at least 13 players and 2 goalies (with Ottawa 67's as the odd exception re: goalies). Overagers remain to be distributed and the four non-historical teams are as yet without players.
QMJHL: 9 out of 12 historical teams have got rosters consisting of at least 13 players and 2 goalies. 2 out of 5 new teams have rosters made up of appropriate players picked from lesser Quebec leagues.
WHL: Remains to be done.
AHL and ECHL: Underage players have been removed.
College: Ages of fictional players have been adjusted in three of the major US college leagues.
Prospects: All NHL players from the 91, 92 and 93 drafts have been included and assigned to their historical teams. All players with at least 100 NHL games from the 90, 94, 95, 96 and 97 drafts have been included and assigned to historical/reasonable teams. Busts and more career minor leaguers will be added later.

After the Canadian junior leagues have been finished, I'll do a first playtest.

NIno: Thanks! I've done that and gotten rid of 950 of the worst and the youngest

[archibalduk]

Thanks! I've fixed the link to 2.0.6 in that thread.

[nino33]

The 1992 database has 350002 players, 21524 of which were born after 1980. That seems excessive, as do the 6500 players with a PA of between 0 and 50.

If you wanted to, you can use the EHM Updater to remove those of the 21,524 players you don't want

• use the Updater to export the players (exported_attributes file), then sort to get those born after 1980
• sort those born after 1980 by PA, and remove all those with a PA that is not "NHL worthy" (this should ensure you don't remove any "future NHLers" that are supposed to be in the 1992 database)
• copy/paste the list of players into a contract_update file and set them all to Retire & then use the Database Optimization button in the EHM Updater to delete all those retired

NIno: Thanks! I've done that and gotten rid of 950 of the worst and the youngest

Did you mean you only had 950 left (of the 6500)? I would have thought you would have had more than 950 to delete...

IMO you can safely delete all players born 1979-1999 who have a PA of 0, -1, -2, -3, -4, -5 -11 and -12 (and probably -6 too, unless you're populating "future real players" that will never play in the NHL but will play in Europe/Russia)

NHL staffs are updated to match the 92-93 season, although ownership remains to be included.

Let me know if you want the names of the ownership, and I can list them off for you (I've got a 1992 NHL Guide that lists off all Staff for the NHL teams, from Trainers and Scouts to Owners and everyone in-between!)

OHL: All 16 historical teams have mostly correct rosters consisting of at least 13 players and 2 goalies (with Ottawa 67's as the odd exception re: goalies). Overagers remain to be distributed and the four non-historical teams are as yet without players.

If you import the database and start a game with it, and make sure you check off "Add Player to Playable Teams," you can quickly/easily create the needed players/staff! Then use the EHM Assistant to export the players/staff, edit PAs as necessary (lower them so you don't have your created fake players/staff making the NHL) & import your players/staff into the database using the EHM Updater and you won't have any teams without players/staff in your playable league(s)

[Anch]

Did you mean you only had 950 left (of the 6500)? I would have thought you would have had more than 950 to delete...
IMO you can safely delete all players born 1979-1999 who have a PA of 0, -1, -2, -3, -4, -5 -11 and -12 (and probably -6 too, unless you're populating "future real players" that will never play in the NHL but will play in Europe/Russia)

I started with the worst, figuring it was better to be conservative to start with and retire/delete more of them once I've gotten a better idea of how things work.

Let me know if you want the names of the ownership, and I can list them off for you (I've got a 1992 NHL Guide that lists off all Staff for the NHL teams, from Trainers and Scouts to Owners and everyone in-between!)

That would be fantastic! And there's a few teams that could really use a few more coaches and/or scouts.

[nino33]

Did you mean you only had 950 left (of the 6500)? I would have thought you would have had more than 950 to delete...
IMO you can safely delete all players born 1979-1999 who have a PA of 0, -1, -2, -3, -4, -5 -11 and -12 (and probably -6 too, unless you're populating "future real players" that will never play in the NHL but will play in Europe/Russia)

I started with the worst, figuring it was better to be conservative to start with and retire/delete more of them once I've gotten a better idea of how things work.

Makes sense!

Let me know if you want the names of the ownership, and I can list them off for you (I've got a 1992 NHL Guide that lists off all Staff for the NHL teams, from Trainers and Scouts to Owners and everyone in-between!)

That would be fantastic! And there's a few teams that could really use a few more coaches and/or scouts.

If you'd like, use the EHM Updater to export a list of the Staff (select Non-Player Attributes) and email it to me at ehmtesting@hotmail.com & I can take a look and create a staff_new file of any missing NHL Staff



Also, you noted earlier "All players with at least 100 NHL games from the 90, 94, 95, 96 and 97 drafts have been included and assigned to historical/reasonable teams. Busts and more career minor leaguers will be added later."

• FYI - Players will be "hidden" until they reach age 14-16 (depending on where they're from, usually NA is 14 and Europe/Russia is 16), so keep that in mind when determining a team to put them on (they can be left as Free Agents and if their CA/PA is appropriate they'll find a team)
• Players that start the game hidden should have a CA and Attributes to match their age when they'll appear in game (their CA and Attribute will be frozen while they're hidden/they won't develop until they appear in game)
• We used the same standard (100 NHL games) with the 1998 database; if you'd like I can export the players from the 1998 database to cover the 1998-2017 Drafts and email them to you (you can review and edit them as you see fit, but you'd have them!)

[ppaalloo]

http://prntscr.com/cygbgf there is a big problem vinny is better than expected around round 4 in draft and he is not latvian
http://prntscr.com/cygcq8

[Anch]

If you'd like, use the EHM Updater to export a list of the Staff (select Non-Player Attributes) and email it to me at ehmtesting@hotmail.com & I can take a look and create a staff_new file of any missing NHL Staff

Thanks! I'll try to send you the file later today.

Also, you noted earlier "All players with at least 100 NHL games from the 90, 94, 95, 96 and 97 drafts have been included and assigned to historical/reasonable teams. Busts and more career minor leaguers will be added later."

• FYI - Players will be "hidden" until they reach age 14-16 (depending on where they're from, usually NA is 14 and Europe/Russia is 16), so keep that in mind when determining a team to put them on (they can be left as Free Agents and if their CA/PA is appropriate they'll find a team)
• Players that start the game hidden should have a CA and Attributes to match their age when they'll appear in game (their CA and Attribute will be frozen while they're hidden/they won't develop until they appear in game)
• We used the same standard (100 NHL games) with the 1998 database; if you'd like I can export the players from the 1998 database to cover the 1998-2017 Drafts and email them to you (you can review and edit them as you see fit, but you'd have them!)

Oh yes, there's loads of balancing of younger prospects left to be done. The 98-99 and 74-75 DBs will probably be a great help with that.
And the DB currently lacks European bantam and midget leagues, which is a concern. How difficult is it to create new non-playable leagues and teams?
The players from the 1998 to 2017 drafts would be great!

ppaalloo: Thanks! I've fixed Vinny's nationality and birthplace. His PA and CA is at roughly the same level as other elite 13-yearolds.

[Manimal]

And the DB currently lacks European bantam and midget leagues, which is a concern. How difficult is it to create new non-playable leagues and teams?

Not difficult, but time-consuming.
It needs to be done manually with the pre-game editor. Just click the add new both for competitions and clubs