EHM The Blue Line

So I've been going through and Retiring (so I can Delete) the modern Staff...already retired all those in a few Leagues and then started on Major Junior - wow! I had no idea there were so many modern Staff on Major Junior teams (so far both the WHL and OHL each have had well over 100 Scouts)...

I've got a number of Guides to help me when creating historical Staff, AND the recent good news that a "blank database" works helps a lot in knowing about what happens (what is "needed" by the EHM), the values of what "EHM creates" and therefore what can be done via editing!

Blank Database Thread - http://www.ehmtheblueline.com/forums/vi ... 60#p145060

The goal from the beginning was to try to not run into modern players/staff while playing the 1974 database...the deleting of modern staff and the creation/adding of some more historical staff should help!


Regards

Would you be able to export your staff using the EHM Updater, take it into Excel, delete the modern staff, and then import it into the blank database? I'm just wondering if this might save you some time.

bruins72 wrote:Would you be able to export your staff using the EHM Updater, take it into Excel, delete the modern staff, and then import it into the blank database? I'm just wondering if this might save you some time.

Alas no, as to delete they have to be retired, and the EHM Updater doesn't allow you to set/update players to retired status to my knowledge...I'm OK with this, as with the 1974 db I've done much of the work long ago (i.e. modern player removal is essentially done), and my future projects (like a 1994 database) will use the blank database as a starting point

FYI it's not really that you delete things in excel...you edit them in excel, and then import what you've edited (and you can't edit everything, and there's different files for different purposes - creating new players/staff, editing Attributes, editing contracts, etc are all done in separate files/updates); also the "deleting" is actually a function of the EHM Updater whereby selecting it all players/staff who are set as "Retired" are removed/deleted (the Updater does the removal automatically)

And as for importing the 1974 db into the blank database, alas everything's not in just one file...things like team/league history and team/league records and retired numbers and more have already been edited in the 1974 database - the idea of determining what/how to transfer the historical/edited parts of the 1974 db to the blank database is much to big a task for me to look at even attempting! I'd much rather carry on the work I've already begun on a 1994 database, or check in on my DMA/NBHL teams, or continue on with the weeks/months of already planned editing for version 1.1, or play in the Challenge, or…

But if/once Archi has created an EHM Updater for EHM05 I'd be very interested in transferring the 1974 db to EHM05! Very interested! HaHa

Haha any excuse to plug the EHM 2005 Updater!

Copying all the data from one DB to another is probably a bit of a tall order given the current state of the Updater. It's probably best to carry on retiring players. If I can find time I'll see if I can add a _retire option to the contract updating csv sheet. I'd been meaning to do this anyway, and it shouldn't take too much time to add.

archibalduk wrote:Haha any excuse to plug the EHM 2005 Updater!

Guilty as charged! HaHa


Does the creating of a blank database connect to the Updater?
i.e. would it be quick/easy to create a blank 2005 database? maybe not worth it due to the 2005 editor limitations...just wondering

nino33 wrote:

bruins72 wrote:Would you be able to export your staff using the EHM Updater, take it into Excel, delete the modern staff, and then import it into the blank database? I'm just wondering if this might save you some time.

Alas no, as to delete they have to be retired, and the EHM Updater doesn't allow you to set/update players to retired status to my knowledge...I'm OK with this, as with the 1974 db I've done much of the work long ago (i.e. modern player removal is essentially done), and my future projects (like a 1994 database) will use the blank database as a starting point

bruins probably ment that delete all modern staff from exported csv file before importing it to blank database.
You can do it pretty easily that way..

nino33 wrote:Does the creating of a blank database connect to the Updater?
i.e. would it be quick/easy to create a blank 2005 database? maybe not worth it due to the 2005 editor limitations...just wondering

Yeah, it connects to the Updater. Basically, it retires all but the first ten staff in the database and then it applies the staff validation function (the one that deletes all of the retired and invalid staff). The retiring bit is easy, but the validation bit is extremely complex and isn't something I could easily apply to the 05 DB - there would need to be a lot of work on converting the code (hundreds and hundreds of lines of code).

Lazion wrote:bruins probably ment that delete all modern staff from exported csv file before importing it to blank database.
You can do it pretty easily that way..

You can't delete them in the csv/excel file!

You delete them by selecting a function that deletes all retired players, so a player/staff MUST be retired to be deleted...and you can't retire a player using the EHM Updater, it has to be done manually at this point (one player/staff at a time, using the PreGame Editor)


EDIT - Thanks for the reply Arch

nino33 wrote:

Lazion wrote:bruins probably ment that delete all modern staff from exported csv file before importing it to blank database.
You can do it pretty easily that way..

You can't delete them in the csv/excel file!

You delete them by selecting a function that deletes all retired players, so a player/staff MUST be retired to be deleted...and you can't retire a player using the EHM Updater, it has to be done manually at this point (one player/staff at a time, using the PreGame Editor)


EDIT - Thanks for the reply Arch

B72 and Lazion aren't really talking about retiring players and staff. They mean to only copy the staff you want to into a blank db.

Manimal wrote:

nino33 wrote:

Lazion wrote:bruins probably ment that delete all modern staff from exported csv file before importing it to blank database.
You can do it pretty easily that way..

You can't delete them in the csv/excel file!

You delete them by selecting a function that deletes all retired players, so a player/staff MUST be retired to be deleted...and you can't retire a player using the EHM Updater, it has to be done manually at this point (one player/staff at a time, using the PreGame Editor)


EDIT - Thanks for the reply Arch

B72 and Lazion aren't really talking about retiring players and staff. They mean to only copy the staff you want to into a blank db.

Exactly! If you export all of the players into a csv file, couldn't you then add or remove entries as you wish, then import those all as new players into the blank database?

Manimal wrote:

nino33 wrote:

Lazion wrote:bruins probably ment that delete all modern staff from exported csv file before importing it to blank database.
You can do it pretty easily that way..

You can't delete them in the csv/excel file!

You delete them by selecting a function that deletes all retired players, so a player/staff MUST be retired to be deleted...and you can't retire a player using the EHM Updater, it has to be done manually at this point (one player/staff at a time, using the PreGame Editor)


EDIT - Thanks for the reply Arch

B72 and Lazion aren't really talking about retiring players and staff. They mean to only copy the staff you want to into a blank db.

And why would I want to do this?

Wouldn't this blank database be missing hundreds of hours of editing? (all the team changes, affiliation changes, reputation changes, the hex-edited unretired jersey numbers, team colours, team arenas, average attendance, team finances, etc etc.....plus the time it would take to export/import many csv files to transfer the award history, team records, the many thousands of historical created players, player history, etc - most of these functions I've never used in the Updater!)

It's not a big deal to me to delete Staff manually! I've completed 5 leagues since starting yesterday! Finnish Elite League, Swedish Elitserien, Russian Elite League, Deutsche Eishockey Liga, and the WHL are all done! OHL is almost done!

bruins72 wrote: If you export all of the players into a csv file, couldn't you then add or remove entries as you wish, then import those all as new players into the blank database?

No, you can NOT just add/remove entries if you want!

The EHM Updater, at the click of a single key, deletes all RETIRED players/staff in a database.
BUT you can NOT "Retire" a player using the EHM Updater!!!!
The only way to "Retire" a player is manually, one-at-a-time, using the PreGame Editor!

So I have to make hundreds of modern Staff "Retired" in the 1974 db...I suspect by the weekend I'll be done (maybe sooner).
Then, the Updater will delete/remove all the Retired players/staff for me with one key click!

You can retire all of the LNAH, too. Those players will get signed by minor pro league-teams, otherwise

Manimal wrote:You can retire all of the LNAH, too. Those players will get signed by minor pro league-teams, otherwise

Thanks much!

nino33 wrote:

bruins72 wrote: If you export all of the players into a csv file, couldn't you then add or remove entries as you wish, then import those all as new players into the blank database?

No, you can NOT just add/remove entries if you want!

The EHM Updater, at the click of a single key, deletes all RETIRED players/staff in a database.
BUT you can NOT "Retire" a player using the EHM Updater!!!!
The only way to "Retire" a player is manually, one-at-a-time, using the PreGame Editor!

So I have to make hundreds of modern Staff "Retired" in the 1974 db...I suspect by the weekend I'll be done (maybe sooner).
Then, the Updater will delete/remove all the Retired players/staff for me with one key click!

Hopefully you are using mouse key recorder then and not doing this manually click by click.

If you're editing staff, I did find some tweaks to be made. You may or may not have caught these already, or may have a good reason to have them the way they are. If so, I apologize.

Jim Devellano (NYI) is 65 in the DB, when he should be 33-34.
Red Sullivan (WAS) is listed twice.
Camille Henry (SD) is listed twice.
Jaques Demers (SEA) is 63 in the DB. Should be 30.

Richie Daggers Crime wrote:Jim Devellano (NYI) is 65 in the DB, when he should be 33-34.
Red Sullivan (WAS) is listed twice.
Camille Henry (SD) is listed twice.
Jaques Demers (SEA) is 63 in the DB. Should be 30.

Thanks much! All fixed now!

One last thing, then I'm keeping my big mouth shut (I'd simply edit these myself, but I'm on a Mac). Willi Plett is 5' 10" in the DB, but was 6' 3" IRL. THANKS!

Richie Daggers Crime wrote:One last thing, then I'm keeping my big mouth shut (I'd simply edit these myself, but I'm on a Mac).

I'm glad you're telling me! I'm actively working on version 1.1, so it's helpful! I appreciate it!

Richie Daggers Crime wrote:Willi Plett is 5' 10" in the DB, but was 6' 3" IRL.

Agreed/fixed!




I'm doing some more testing now on Height/Weight development (and CA too)...such testing takes many days to complete

Height/Weight development is a real challenge as the amount grown/gained is random!
- All players age 18 and under can/do grow quite a bit at start-up
- Many players age 19-21 grow a bit at start-up
- It seems maybe players under age 10, and players about age 11-15, and players age 16-18, and players age 19-21 all grow at different rates

My height/weights for players age 1-5 at start-up were to high, and they apparently grow a bit to big as adults - I'm working on fixing this.
So far I've found for players age 18-21 a high 90s percentage of adult height/weight seems to work best...
Currently after 4 tests I got a starting point that seems to work for players under 10 (75% of height and 70% of weight), but it doesn't seem to work for older players
My 4th test is currently in year 5 and still running...

It'll take awhile to get the needed results and make refinements and test again, but I'm working on it!

A thing that I noticed when playing as the Red Wings as part of the challenge with them is that Terry Sawchuck is listed as a assistant coach in Detroit, but he died in 1970.

An observation, if I may.

For NHL teams' short names, I really think it's a better idea to use the team name than the city - gets confusing ("Are we talking about the Islanders or the Rangers?").

joehelmer wrote: thing that I noticed when playing as the Red Wings as part of the challenge with them is that Terry Sawchuck is listed as a assistant coach in Detroit, but he died in 1970.

That was done on purpose! A couple/few who passed away before 1974 were still included (IIRC Turk Broda/Tim Horton were included too, despite an IRL death prior to 1974)........given the modern hockey world has well over 600 Staff positions to fill, and the hockey world of 1974 had maybe around 200, I had to use almost every "available" ex-NHLer to fill the Staff positions that I did

XenHL wrote:For NHL teams' short names, I really think it's a better idea to use the team name than the city - gets confusing ("Are we talking about the Islanders or the Rangers?").

Are the Rangers/Islanders the only issue? I could maybe change the Islanders to "Long Island" - or maybe I should use the nickname part? (i.e. Rangers/Islanders)...Manimal 4.2 uses the nickname - maybe I was supposed to change things to the nickname and forgot to do so?

RE 1974 db 1.0 may be a little “to defensive” (missing a bit of offense)

I am very pleased with the results of the 1974 db, and honestly I’m very pleased it seems a bit “to defensive” – because…I think it’ll be relatively easy to improve on the offense…one of the things I’ve been looking forward to is a “further review” of NHL players “one-at-a-time” style; rather than a review based on excel sorting, I’ll look at each player as an individual and adjust things that seem to require it based on the WRITE UPS I have on the player/staff


I have a number of resources (like Jim Proudfoot Hockey Yearbooks, Hockey World Annuals and Zander Hollander Hockey Handbooks) and all of these resources have actual paragraph or more “write ups” on the players (not just stats)…and I have these Yearbooks/Annuals from 1968-1986, so I can get more than just one “written description/snapshot” of a player……PLUS I have actual 1974-75 Media Guides for (so far) 14 of the 30 teams in the 1974 db NHL, and each of these has a full page “write up” on each player…I’m really looking forward to this particular editing, and I think in the process a bit more offense will be edited into the 1974 db


Regards

Team names: personally, I'd prefer using the nicknames as the short name, but in the end it's your call!

I wouldn't say things are "too defensive" - I've seen a number of blowouts so far in my new game, but these are reasonable blowouts, like Habs-Caps 8:0 and such. I'm about 50 games into the season, and so far it's looking like there'll be 6-10 100-point scorers, which is plenty more offensive than the standard/modern game!

The only thing I'd complain about - except that this is probably a hard-coded thing - is the lack of scoring from defencemen. Bobby Orr with 25 points in 50 games, in fourth place amongst defencemen? Potvin leading with 31 points? That seems ridiculously low!