It's actually pretty fiddly to add for the current Editor (lots of tables use city data). I will try to add this to the Editor v2 however. In the meantime, if you rename one of the cities to include something like "Duplicate" at the end of the name then you can export staff/arena/nation spreadsheets to see where they're used.xECK29x wrote: Sun Apr 19, 2020 3:02 pm Small request, under cities can you put a counter for how many times its used? Will help me in some of the work to remove duplicates/wrong entries. Similar to how names are counted.
EHM 1 Database & Saved Game Editor v1: BUG REPORTS & FEATURE REQUESTS
Forum rules
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.
Have a bug or feature request for the EHM Editor? Post them in the EHM Editor thread. Please start a new thread or post in another thread if you have a question about how to use the EHM Editor.
Given the large number of questions on similar topics, we ask that you start a new thread for a new question unless you can locate a similar question in an existing thread. This will hopefully ensure that similar questions do not get buried in large threads.
Useful links: EHM 1 Assistant (Download) | EHM 1 Editor (Download) | EHM 1 Editor Tutorials | Editing Rules & Structures Guide | Converting EHM 2004 / 2005 DBs to EHM 1 | Converting an EHM 2007 DB to EHM 1 | Extra_config.cfg | Import_config.cfg | Player Roles
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.
Have a bug or feature request for the EHM Editor? Post them in the EHM Editor thread. Please start a new thread or post in another thread if you have a question about how to use the EHM Editor.
Given the large number of questions on similar topics, we ask that you start a new thread for a new question unless you can locate a similar question in an existing thread. This will hopefully ensure that similar questions do not get buried in large threads.
Useful links: EHM 1 Assistant (Download) | EHM 1 Editor (Download) | EHM 1 Editor Tutorials | Editing Rules & Structures Guide | Converting EHM 2004 / 2005 DBs to EHM 1 | Converting an EHM 2007 DB to EHM 1 | Extra_config.cfg | Import_config.cfg | Player Roles
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
- xECK29x
- TBL Rosters Researcher
- Posts: 1010
- Joined: Sun May 03, 2015 2:52 pm
- Custom Rank: Premier Pivot Rosters Man
- Favourite Team: New York Islanders
EHM 1 Database & Saved Game Editor
What about adding player/staff filter for place of birth to find those renamed entries?
Last edited by xECK29x on Mon Apr 20, 2020 11:57 am, edited 1 time in total.
- xECK29x
- TBL Rosters Researcher
- Posts: 1010
- Joined: Sun May 03, 2015 2:52 pm
- Custom Rank: Premier Pivot Rosters Man
- Favourite Team: New York Islanders
EHM 1 Database & Saved Game Editor
Yea that's exactly what I've been doing! Not a problemarchibalduk wrote: Sun Apr 19, 2020 9:37 pm It's actually pretty fiddly to add for the current Editor (lots of tables use city data). I will try to add this to the Editor v2 however. In the meantime, if you rename one of the cities to include something like "Duplicate" at the end of the name then you can export staff/arena/nation spreadsheets to see where they're used.
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
Yes I can add that to the next release.xECK29x wrote: Mon Apr 20, 2020 11:56 am What about adding player/staff filter for place of birth to find those renamed entries?
- TBIF
- Top Prospect
- Posts: 106
- Joined: Sun Jan 01, 2017 8:38 pm
- Custom Rank: 2000/01 Rosters Author
- Favourite Team: Canucks
EHM 1 Database & Saved Game Editor
Can we export individual players to excel from their player page?
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
No but you can export all players from the Export Spreadsheet screen and then filter out the relevant row in Excel.TBIF wrote: Mon Apr 20, 2020 11:47 pm Can we export individual players to excel from their player page?
-
- Drafted
- Posts: 196
- Joined: Fri Aug 11, 2006 7:59 pm
EHM 1 Database & Saved Game Editor
Im confused... so I went and followed Archi's notes... to install the Visual C++ Redistributable for Visual Studio 2015 and then to open the editor and i am still getting the missing VCruntime140.dlll file
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
We're now using the 2019 Redistributable. Here's the link (you need the x64/64-bit version): https://aka.ms/vs/16/release/VC_redist.x64.exe
-
- Drafted
- Posts: 196
- Joined: Fri Aug 11, 2006 7:59 pm
EHM 1 Database & Saved Game Editor
Archi...
Question about your svae editor... If i sim to March 22nd 2019 or something and i can a team can i delete that team history or no?
Question about your svae editor... If i sim to March 22nd 2019 or something and i can a team can i delete that team history or no?
- xECK29x
- TBL Rosters Researcher
- Posts: 1010
- Joined: Sun May 03, 2015 2:52 pm
- Custom Rank: Premier Pivot Rosters Man
- Favourite Team: New York Islanders
EHM 1 Database & Saved Game Editor
Request from one of our researchers, he would like to see keyboard navigation added to the menus, so when he scrolls up/down with the keyboard it will refresh the pane on the right, same functionality for all screens. Would be nice to be able to page up/down actually instead of clicking sometimes
.

- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
Good point. That has bugged me for some time too. I'll see if I can add it to the upcoming release of the Editor.xECK29x wrote: Mon May 04, 2020 1:42 pm Request from one of our researchers, he would like to see keyboard navigation added to the menus, so when he scrolls up/down with the keyboard it will refresh the pane on the right, same functionality for all screens. Would be nice to be able to page up/down actually instead of clicking sometimes.

-
- Junior League
- Posts: 9
- Joined: Thu Jul 09, 2020 6:04 pm
- Favourite Team: Columbus Blue Jackets
EHM 1 Database & Saved Game Editor
Hi, I've been having some issues trying to edit player attribute data for yojimbro1111's WIP 92/93 database in the editor. (This is not the 24 team DB but the 30 team version found on the Workshop.) Every time I create a copy of the database and then attempt to change attributes and save, all of the data in the copy file is deleted. Any help would be greatly appreciated!
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
It sounds like you're not using Run as Administrator when running the Editor. Right-click on the EHM Editor.exe and click on Run as Administrator.
You can make Run as Administrator permanent by following these instructions: https://www.itechtics.com/run-programs- ... inistrator
You can make Run as Administrator permanent by following these instructions: https://www.itechtics.com/run-programs- ... inistrator
-
- Junior League
- Posts: 9
- Joined: Thu Jul 09, 2020 6:04 pm
- Favourite Team: Columbus Blue Jackets
EHM 1 Database & Saved Game Editor
That's not it, unfortunately, I have admin mode enabled. I'll do some more troubleshooting and see if anything manifests.
- xECK29x
- TBL Rosters Researcher
- Posts: 1010
- Joined: Sun May 03, 2015 2:52 pm
- Custom Rank: Premier Pivot Rosters Man
- Favourite Team: New York Islanders
EHM 1 Database & Saved Game Editor
Feature request: Can you add a yellow warning label to active clubs where Professional Status is set to [None]? I found a bunch of these (mostly junior clubs)
- nino33
- Mr. Goalie
- Posts: 6088
- Joined: Sat Aug 07, 2010 3:37 am
- Custom Rank: Retro Rosters Specialist
- Favourite Team: 1970s hockey
EHM 1 Database & Saved Game Editor
Is it possible to be able to edit League Records and Team Records via exporting/importing a spreadsheet?
It doesn't seem to be that I can see.....could the ability to do so be added to the editor?
It doesn't seem to be that I can see.....could the ability to do so be added to the editor?
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
At present I'm afraid it isn't possible. If I can find the time, I'll add it to the Editor but in any event it will definitely be in for Editor v2. It's a bit fiddly to add to the current Editor compared with the existing import spreadsheets.
- xECK29x
- TBL Rosters Researcher
- Posts: 1010
- Joined: Sun May 03, 2015 2:52 pm
- Custom Rank: Premier Pivot Rosters Man
- Favourite Team: New York Islanders
EHM 1 Database & Saved Game Editor
Archi did we ever get the ability to delete career history records added? I want to spend some time purging old history records for qualifying rounds/relegation playoffs as technically they aren't playoffs or regular season and thus don't fit the supported schema.
- nino33
- Mr. Goalie
- Posts: 6088
- Joined: Sat Aug 07, 2010 3:37 am
- Custom Rank: Retro Rosters Specialist
- Favourite Team: 1970s hockey
EHM 1 Database & Saved Game Editor
Greatarchibalduk wrote: Wed Jul 15, 2020 9:53 pm At present I'm afraid it isn't possible. If I can find the time, I'll add it to the Editor but in any event it will definitely be in for Editor v2.

P.S. I've got NHL as well as some Minor Pro/Major Junior Guides that I could use to provide Team/League Records for the 1992, 1998 and 2000 databases

- Geordie_Bolts
- Junior League
- Posts: 43
- Joined: Fri Sep 16, 2011 12:46 am
EHM 1 Database & Saved Game Editor
I don't think this issue has been raised before, so apologies if it has.
I know we're not really able/meant to edit saved games with this tool but I have routinely been able to use it to edit the Salary Cap limits for the NHL only without issue since the earlier versions however for my current save, when I am making that same edit I am now getting an error message when re-loading the game that causes it to crash when I try to advance to the next day.
The message appears during the "loading database" part of loading a saved game and reads... "TRAINING_MANAGER::load_from_disk(): cannot read human_team_training"
I'm a little lazy so I always have Head Coach takes care of practice selected and I've never encountered this before.
Any help or suggestions would be appreciated as it's left me very confused!
Thanks
I know we're not really able/meant to edit saved games with this tool but I have routinely been able to use it to edit the Salary Cap limits for the NHL only without issue since the earlier versions however for my current save, when I am making that same edit I am now getting an error message when re-loading the game that causes it to crash when I try to advance to the next day.
The message appears during the "loading database" part of loading a saved game and reads... "TRAINING_MANAGER::load_from_disk(): cannot read human_team_training"
I'm a little lazy so I always have Head Coach takes care of practice selected and I've never encountered this before.
Any help or suggestions would be appreciated as it's left me very confused!
Thanks
- 88AMcGee
- Learning to skate
- Posts: 1
- Joined: Sun Mar 29, 2015 2:25 am
- Favourite Team: Chicago Blackhawks
- Location: Adelaide, SA
- Contact:
EHM 1 Database & Saved Game Editor
Can you please elaborate on the issues with historical records, if the player with the record doesn’t exist in the DB, the game generates a fake name. Is this not possible to be coded in another file? Without the need for hundreds of non-players added to the DB? Also the Competitions Honors tab for several teams are a mess, Detroit, Boston and Chicago to name a few, any reason for this error?
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
As you say, editing saved games isn't supported with the Editor as we simply don't have enough information about the saved game structure to enable any real editing. Hence it's not possible for us to suggest or make any fixes. It's likely the Editor changed something when saving the edited saved game which has caused a dangling/invalid ID reference.Geordie_Bolts wrote: Sat Jul 18, 2020 11:54 am I don't think this issue has been raised before, so apologies if it has.
I know we're not really able/meant to edit saved games with this tool but I have routinely been able to use it to edit the Salary Cap limits for the NHL only without issue since the earlier versions however for my current save, when I am making that same edit I am now getting an error message when re-loading the game that causes it to crash when I try to advance to the next day.
The message appears during the "loading database" part of loading a saved game and reads... "TRAINING_MANAGER::load_from_disk(): cannot read human_team_training"
I'm a little lazy so I always have Head Coach takes care of practice selected and I've never encountered this before.
Any help or suggestions would be appreciated as it's left me very confused!
Thanks
It's exactly as you say - historical records won't appear in game unless the player exists in the database. This reminds me that I need to check the v1.5 patch changelist to see if this is something that has been fixed. If it hasn't, I'll mention it to Riz as I can't remember whether or not I reported this.88AMcGee wrote: Sat Jul 18, 2020 2:53 pm Can you please elaborate on the issues with historical records, if the player with the record doesn’t exist in the DB, the game generates a fake name. Is this not possible to be coded in another file? Without the need for hundreds of non-players added to the DB?
I'm not really sure if I follow - is the Editor scrambling your data? If so, please can you detail your steps so that I can replicate the issue? If this is in relation to a particular database then I suggest posting it in the TBL Rosters Forum or the relevant database thread.88AMcGee wrote: Sat Jul 18, 2020 2:53 pmAlso the Competitions Honors tab for several teams are a mess, Detroit, Boston and Chicago to name a few, any reason for this error?
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
Yes just set the Club and Comp to "_none" and the GP to zero. The Editor will then delete the entry when you next save/refresh. This can be done either via the Editor or the importer spreadsheet (you'll need to enter the current Club, Comp, Season and Playoffs in the spreadsheet and then set the Edit Club and Edit Comp to "_none" and GP to zero).xECK29x wrote: Wed Jul 15, 2020 10:00 pm Archi did we ever get the ability to delete career history records added? I want to spend some time purging old history records for qualifying rounds/relegation playoffs as technically they aren't playoffs or regular season and thus don't fit the supported schema.
- nino33
- Mr. Goalie
- Posts: 6088
- Joined: Sat Aug 07, 2010 3:37 am
- Custom Rank: Retro Rosters Specialist
- Favourite Team: 1970s hockey
EHM 1 Database & Saved Game Editor
YIkes! I didn't realize this!archibalduk wrote: Sat Jul 18, 2020 10:40 pm It's exactly as you say - historical records won't appear in game unless the player exists in the database. This reminds me that I need to check the v1.5 patch changelist to see if this is something that has been fixed. If it hasn't, I'll mention it to Riz as I can't remember whether or not I reported this.
I think in EHM07 it worked...you could have the player ID (the player name was a link to the player in the database), or you could have just first name & last name (using an identifying # for each first/last name) but these didn't link to anything...or am I remembering wrong?
- archibalduk
- TBL Admin Team
- Posts: 20372
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
EHM 1 Database & Saved Game Editor
It has been a couple of years since I last looked at it but I recall EHM 1 being a bit fussier with records than EHM 2007. That said, it should be easier with historical DBs to use the old EHM 2007 approach because the chances of deleting the player to the randomly selected player ID is fairly low (e.g. in a modern DB, if you used John Doe's player ID and he is subsequently retired/deleted from the DB, the Editor will blank out his player ID from the various records linked to his ID).nino33 wrote: Sat Jul 18, 2020 11:15 pmYIkes! I didn't realize this!archibalduk wrote: Sat Jul 18, 2020 10:40 pm It's exactly as you say - historical records won't appear in game unless the player exists in the database. This reminds me that I need to check the v1.5 patch changelist to see if this is something that has been fixed. If it hasn't, I'll mention it to Riz as I can't remember whether or not I reported this.
I think in EHM07 it worked...you could have the player ID (the player name was a link to the player in the database), or you could have just first name & last name (using an identifying # for each first/last name) but these didn't link to anything...or am I remembering wrong?