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
-
- Second Line
- Posts: 656
- Joined: Sat Jan 07, 2012 11:21 pm
Re: EHM 1 Database & Saved Game Editor
Cool beans, no need to jump on it, just something that could make future database mods easier for the end users.
- Alessandro
- Olympic Gold
- Posts: 2865
- Joined: Sat Aug 27, 2005 1:54 pm
- Custom Rank: TBL Rosters Man
- Favourite Team: Team Russia
- WHL Team: Calgary Flames
Re: EHM 1 Database & Saved Game Editor
Kazakhstan had an argument with the IOC?

-
- TBL Rosters Researcher
- Posts: 601
- Joined: Sun Nov 24, 2013 7:34 pm
Re: EHM 1 Database & Saved Game Editor
2005? Was that the last year of the EIHL/BHL/ENL structure in Britain? Would it just be the case we'd need to get league-structures in (as the player data already exists).
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
No, that was 2004/05. So the season covered by EHM 2004. But yes, it's just a case of adding the structures to the DB.
I can partly read the EHM 2004 database but I haven't finished it yet. Annoyingly the EHM 2004 Editor won't run unless EHM 2004 installed but I don't have a CD-ROM drive, meaning I cannot install the game. I tried running the demo but that's not enough to keep the Editor happy. I need to run the EHM 2004 Editor in order to figure out the data structure.](./images/smilies/wallbash.gif)
I can partly read the EHM 2004 database but I haven't finished it yet. Annoyingly the EHM 2004 Editor won't run unless EHM 2004 installed but I don't have a CD-ROM drive, meaning I cannot install the game. I tried running the demo but that's not enough to keep the Editor happy. I need to run the EHM 2004 Editor in order to figure out the data structure.
](./images/smilies/wallbash.gif)
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
I ended up ordering a cheap external DVD drive on Amazon so that I can install EHM 2004 on my laptop and hopefully figure out the database structure.
I've made quite a few adjustments/improvements to the Editor since the last release. I've also added player/staff auto-deletion (i.e retired and invalid staff) and city and affiliate importing/editing via spreadsheets. I'm now working on a new form of staff import spreadsheet which I hope will make working on the roster updates a little easier (you just list the rosters in the spreadsheet and the Editor will figure out what moves to make and what players to create).
I've made quite a few adjustments/improvements to the Editor since the last release. I've also added player/staff auto-deletion (i.e retired and invalid staff) and city and affiliate importing/editing via spreadsheets. I'm now working on a new form of staff import spreadsheet which I hope will make working on the roster updates a little easier (you just list the rosters in the spreadsheet and the Editor will figure out what moves to make and what players to create).
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
I now have the basics of the Smart Update up and running (I know it's a tacky name, but I want to distinguish it from the Staff Importer spreadsheet). This is really just a slightly different form of Staff Importer spreadsheet with the main differences being that the Smart Update will (1) create a new player if it cannot find a matching player in the database (rather than coming back with a "No Match" error) and (2) empty each relevant team's rosters before importing the changes (but this can be disabled).
The idea behind this is that you list a team's entire roster in a spreadsheet (see screenshot below) and the Importer will then make the necessary changes by moving players to those teams and/or creating any missing players. The reason for the Smart Update clearing those teams' rosters before running the changes is so that players who have left those teams are made free agents (and can then be covered in a separate Smart Update spreadsheet or manually edited in the Editor). Only the teams covered in the Smart Update will have their rosters cleared (i.e. it won't affect the whole database).
The main challenge I have at the moment is figuring out how the Smart Update can find similar players where the DOB is slightly wrong in the DB but is correct in the spreadsheet. For example, I found a UK youth player in the DB with a DOB from 1996 but his correct DOB is 1998 (which is how it is in the spreadsheet). The incorrect DOB is obvious to a person looking at it but I haven't quite figured out how the Smart Update can figure this out for itself and then make the correction. If the Smart Update cannot figure this out (as is the case at present) then it'll create a new player who will be a duplicate of the player with the wrong DOB...

The idea behind this is that you list a team's entire roster in a spreadsheet (see screenshot below) and the Importer will then make the necessary changes by moving players to those teams and/or creating any missing players. The reason for the Smart Update clearing those teams' rosters before running the changes is so that players who have left those teams are made free agents (and can then be covered in a separate Smart Update spreadsheet or manually edited in the Editor). Only the teams covered in the Smart Update will have their rosters cleared (i.e. it won't affect the whole database).
The main challenge I have at the moment is figuring out how the Smart Update can find similar players where the DOB is slightly wrong in the DB but is correct in the spreadsheet. For example, I found a UK youth player in the DB with a DOB from 1996 but his correct DOB is 1998 (which is how it is in the spreadsheet). The incorrect DOB is obvious to a person looking at it but I haven't quite figured out how the Smart Update can figure this out for itself and then make the correction. If the Smart Update cannot figure this out (as is the case at present) then it'll create a new player who will be a duplicate of the player with the wrong DOB...


-
- Learning to skate
- Posts: 3
- Joined: Fri Feb 12, 2016 2:09 am
- Favourite Team: san jose sharks
Re: EHM 1 Database & Saved Game Editor
Just wondering if anyone has any idea how to edit Pittsburgh Penguins colors ? I just recently updated, the logo from the gold to yellow. I've tried the EHM Editor 2.4 and saved but no changes take effect after I save it. 

-
- Learning to skate
- Posts: 2
- Joined: Fri Aug 14, 2015 10:57 pm
- Favourite Team: montreal canadiens
Comment loader apres editer
J'ai effectué des changements dans le database (ajout de nom) . Lorsque je recommence une partit, je n'ai pas c'est nom lorsque je veux les editer. Quel est le probleme ?
- Tasku
- TBL Admin Team
- Posts: 8158
- Joined: Sat Jul 10, 2004 9:36 pm
- Custom Rank: W-WPoTBLfaSaD
- Favourite Team: WSH Capitals
- Location: Finland
Re: Comment loader apres editer
The forum language is English. Please repeat your question in English. 

-
- Learning to skate
- Posts: 1
- Joined: Sat Dec 23, 2017 8:12 pm
- Favourite Team: Whitley Warriors
Re: EHM 1 Database & Saved Game Editor
is there anyway of getting the editor to work within playonmac?
-
- Prospect
- Posts: 71
- Joined: Tue May 14, 2013 2:28 am
Re: EHM 1 Database & Saved Game Editor
Trying to edit the newest data update pre-game. I can start a new game with the database, but can't find the file with the editor. Any help?
Edit: Figured it out. But how can I switch draft picks?
Edit: Figured it out. But how can I switch draft picks?
-
- Top Prospect
- Posts: 121
- Joined: Wed Aug 28, 2013 7:01 pm
Re: EHM 1 Database & Saved Game Editor
Hey Archi, is there a way (or, if not, are there plans) to export/import players individually?
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
I'm afraid I don't have a Mac and cannot test this. Try installing the 32-bit version (also known as vcredist_x86.exe) (do not install the 64-bit version): https://www.microsoft.com/en-gb/downloa ... x?id=48145Bradkelly57 wrote:is there anyway of getting the editor to work within playonmac?
Also install the latest .NET Framework.
Are you editing a database or a saved game. Saved game editing is not advisable and changes are unlikely to work. If editing a database, ensure that you use Run as Admin when running the Editor.trevorjazz wrote:Just wondering if anyone has any idea how to edit Pittsburgh Penguins colors ? I just recently updated, the logo from the gold to yellow. I've tried the EHM Editor 2.4 and saved but no changes take effect after I save it.
You can export a Player & Non-Player Research Sheet via Tools -> Export Spreadsheet. Delete all of the rows of data from the spreadsheet except for the individual player. Then put an "a" in the Mode column next to the player in question. Then import this into your chosen database.zbguy wrote:Hey Archi, is there a way (or, if not, are there plans) to export/import players individually?
The next version of the Editor also allows Career History exporting which can also then be imported using a similar method as described above.
Use the "DRAFT_PICK_SWITCH" setting in extra_config - see here: viewtopic.php?f=110&t=2382Epic wrote:Trying to edit the newest data update pre-game. I can start a new game with the database, but can't find the file with the editor. Any help?
Edit: Figured it out. But how can I switch draft picks?
- leafsrock67
- Junior League
- Posts: 42
- Joined: Thu Apr 09, 2015 5:48 am
- Favourite Team: Toronto Maple Leafs
Re: EHM 1 Database & Saved Game Editor
Hi. I am using the editor to edit the new rosters (10.0). I have a question. When saving the edited database, where should I save it? Should I save it in the folder with all the other databases as a new file, or should I overwrite the database that I donwloaded from the Steam workshop? Also, I have tried saving it multiple times but when I try loading the database in game, nothing happens. I turned of Save Compressed, and still nothing happens. Why? When I go and see when the .db file was last modified, it says that there weren't any changes. Why? Do I need to close the editor? Or is it something else?
-
- Learning to skate
- Posts: 1
- Joined: Sun Dec 31, 2017 9:03 am
- Favourite Team: dsf
Re: EHM 1 Database & Saved Game Editor
Hi i would like to ask, if i can change competitions from which is European champions league or continental cup binding... For example i dont want in continental cup club from Serbian league but i want in continental cup club from Slovenian league. Is it possible? Sorry for my english
thanks
thanks
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
It really depends on how you are keeping backups of your database and whether you want your edited database to be separate from the original. If your changes are not being saved then it might be because you are not running the Editor as administrator. Here are the steps to do so:leafsrock67 wrote:Hi. I am using the editor to edit the new rosters (10.0). I have a question. When saving the edited database, where should I save it? Should I save it in the folder with all the other databases as a new file, or should I overwrite the database that I donwloaded from the Steam workshop? Also, I have tried saving it multiple times but when I try loading the database in game, nothing happens. I turned of Save Compressed, and still nothing happens. Why? When I go and see when the .db file was last modified, it says that there weren't any changes. Why? Do I need to close the editor? Or is it something else?
I suggest saving your edited database to your desktop and then manually moving it to a new sub-folder of your <EHM installation folder>/data/database/ folder.1. Right-click on the EHM Editor.exe file.
2. Choose Properties.
3. On the Compatibility tab, select the Run This Program As An Administrator option.
4. Click OK.
5. When you next load the Editor, if you see a User Account Control prompt, accept it.
No I don't think you can. It is currently hard-coded. I believe you can alter which teams start in the first season by adding/removing Continental Licences, but I don't think you can change which leagues feed into the CHL from the second season onwards.erik12 wrote:Hi i would like to ask, if i can change competitions from which is European champions league or continental cup binding... For example i dont want in continental cup club from Serbian league but i want in continental cup club from Slovenian league. Is it possible? Sorry for my english
thanks
-
- Junior League
- Posts: 6
- Joined: Wed Jul 12, 2017 10:19 am
- Favourite Team: Toronto
Re: EHM 1 Database & Saved Game Editor
Hi Archi,
first, happy new year:)
second, thanks again for all your work on the editor. Before I use a new database I create (by your import function) lots of new players (and non players) to have more second names in the game.
As a german, it's much more fun if every german player is not named Seidenberg or so:). But I noticed that if I create too many new players the game crashes after some playing time (3, 4 years, usually) due to an array overflow.
Well, OK, I overdid it with creating >100k new players, so I wonder:
is it possible to have an importer function for second names?
first, happy new year:)
second, thanks again for all your work on the editor. Before I use a new database I create (by your import function) lots of new players (and non players) to have more second names in the game.
As a german, it's much more fun if every german player is not named Seidenberg or so:). But I noticed that if I create too many new players the game crashes after some playing time (3, 4 years, usually) due to an array overflow.
Well, OK, I overdid it with creating >100k new players, so I wonder:
is it possible to have an importer function for second names?
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
Yes that would certainly be possible. I have added it to my list and will look into it when I look into name deletion options (so that we can delete garbage/typo names). 
It is interesting that ~150k players will cause the game to crash. I guess with each player having numerous career history entries then the database will fill up fast.
Happy New Year to you too!

It is interesting that ~150k players will cause the game to crash. I guess with each player having numerous career history entries then the database will fill up fast.
Happy New Year to you too!
-
- Junior League
- Posts: 6
- Joined: Wed Jul 12, 2017 10:19 am
- Favourite Team: Toronto
Re: EHM 1 Database & Saved Game Editor
Awesome, thank you. I wonder if Riz would be interested in the save file?
-
- TBL Rosters Researcher
- Posts: 4
- Joined: Sat Dec 30, 2017 12:42 pm
- Favourite Team: Fassa Falcons
Re: EHM 1 Database & Saved Game Editor
Hello all
I'm new on Eastside Hockey Manager and really would like to use the Editor and help with Roster Updates. Is somewhere a Editor's tutorial avaliable?
Thanks
Matt

Thanks
Matt
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
I am afraid there isn't any manual at present. I plan on writing some sort of help guide, but I need to keep developing the Editor for now.
If you are interested in helping with the TBL Roster updates then let me know in this thread and we can help you get started. Research for the TBL Rosters requires the use of spreadsheets rather than the Editor. I know you previously posted in that thread, but I wasn't sure if you were offering to research the AlpsHL or just looking to create some addons for it.
If you are interested in helping with the TBL Roster updates then let me know in this thread and we can help you get started. Research for the TBL Rosters requires the use of spreadsheets rather than the Editor. I know you previously posted in that thread, but I wasn't sure if you were offering to research the AlpsHL or just looking to create some addons for it.
Possibly. I suggest uploading it to the SI Forums - details here: https://community.sigames.com/topic/345275-ftp-details/Great Imp wrote:Awesome, thank you. I wonder if Riz would be interested in the save file?
- MasterMatt23
- Junior League
- Posts: 7
- Joined: Sun Dec 31, 2017 3:53 am
- Favourite Team: Montreal Canadiens
Re: EHM 1 Database & Saved Game Editor
I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?
- Tonait
- Junior League
- Posts: 24
- Joined: Mon Sep 19, 2011 9:15 pm
- Location: Turku, Finland
Re: EHM 1 Database & Saved Game Editor
How can I place all players as free agents at the beginning of the game?
- archibalduk
- TBL Admin Team
- Posts: 20373
- Joined: Tue Jul 06, 2004 8:44 pm
- Custom Rank: Seaside + Fruit Juice Mode
- Favourite Team: Guildford (EPL) / Invicta (NIHL)
- Location: United Kingdom
- Contact:
Re: EHM 1 Database & Saved Game Editor
Editing ratings shouldn't cause a crash. Did you edit something else as well?MasterMatt23 wrote:I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?
You could use the Staff importer file to list every player and make them free agents.Tonait wrote:How can I place all players as free agents at the beginning of the game?
- Tonait
- Junior League
- Posts: 24
- Joined: Mon Sep 19, 2011 9:15 pm
- Location: Turku, Finland
Re: EHM 1 Database & Saved Game Editor
I'm not sure now How i find Staff importer file?archibalduk wrote:You could use the Staff importer file to list every player and make them free agents.Tonait wrote:How can I place all players as free agents at the beginning of the game?