EHM 1 Database & Saved Game Editor v1: BUG REPORTS & FEATURE REQUESTS

Discuss all aspects of editing the data and databases in EHM here. Have a question about the EHM Editor, EHM Assistant, editing the .cfg files, hex editing the .dat or .db files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
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
Post Reply
AngeLxLost
Junior League
Posts: 16
Joined: Mon May 23, 2016 11:59 pm
Favourite Team: Pittsburgh Penguikns

Re: EHM 1 Database & Saved Game Editor

Post by AngeLxLost »

Thanks for your reply!

I'm not sure why but the editor I'm using (0.2.8) always crashes when I try to export the players/non-players spreadsheet. Fortunately it seems to work if I narrow it to only nhl players.

I also exported arenas, cities, and clubs and managed to get past the award ceremony so I'm almost 100% certain that it was some issue with changing the awards.

But anyway, thanks to your suggestion I at least have most of my work back. Thanks for your help.
User avatar
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:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

It sounds like you're trying to export using XLSX which is a known issue (see the Home screen of the Editor for more details). If you export to CSV then it should work fine (and it'll be much quicker to export/import).

Unfortunately I haven't come up with a solution for the XLSX crash yet. Unlike the rest of the Editor which is all coded by me, the XSLX functions are a third party plug-in (writing a platform independent XLSX module would have been a massive project in itself). So it involves a lot more work to debug.
AngeLxLost
Junior League
Posts: 16
Joined: Mon May 23, 2016 11:59 pm
Favourite Team: Pittsburgh Penguikns

Re: EHM 1 Database & Saved Game Editor

Post by AngeLxLost »

Oh thanks, exporting csv worked fine.

I also figured out the reasons for the crashes I was getting at the awards ceremony. It was changing the awards criteria (ie. changing the norris from "best defenseman" to "best offensive defenseman"), adding awards, and trying to remove awards by removing the league that they're suppose to be awarded in. Just in case you can somehow use this information.
User avatar
DK_Hockey
Junior League
Posts: 32
Joined: Wed May 04, 2011 7:29 am

Re: EHM 1 Database & Saved Game Editor

Post by DK_Hockey »

Hi all,

I keep get a error when I load a game.
I just install the game on my new Windows 10 PC from work and when I just load the Swedish league ALL and NHL I cant get past the first day.
No matter how many leagues I load, it crashes.
User avatar
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

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

What is the proper identifier (A1 cell) to import club competitions? Keep getting an error despite using the raw export. is this supported?
User avatar
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:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

I'm doing it from memory, but I think it is "league" or "club_competition". It should be the same as the default filename minus the file extension.

Are you exporting with the Export as Research Sheet setting enabled? It has to be in research sheet format. If so then it's an oversight by me and I'll fix it for the next version.

DK_Hockey - is your issue related to the Editor? If so, you need to provide a lot more detail.
User avatar
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

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

Yes "Export as a research sheet" is selected (it's actually greyed out for club_competitions) and 'league' worked but I got errors on every single row either:

Mode | League | Classification or Mode | League | Continent | Classification

Assuming the structure needed for import varies from the export, is there a template you can share?
User avatar
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:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

Ah yes, it looks like I've missed it. I'll add it for the next version.

In the meantime, go to File -> Import Spreadsheet -> Create Templates.
User avatar
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

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

There is no template created for club_competitions :(
User avatar
CJ
TBL Rosters Researcher
Posts: 3411
Joined: Tue Nov 08, 2011 6:34 pm
Custom Rank: Formerly jhcjobpb
Favourite Team: Florida Panthers
Location: Finland

Re: EHM 1 Database & Saved Game Editor

Post by CJ »

Hi Archie. I noticed as I'm adding new cities to the 1998 DB that I'm not able to copy/paste the longitude/latitudes. The city name I'm able to copy/paste there. And I can't add dots either, which are needed. :-k
User avatar
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:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

xECK29x wrote:There is no template created for club_competitions :(
It works for me. It is called league.csv (or .xlsx, xml, etc).
CJ wrote:Hi Archie. I noticed as I'm adding new cities to the 1998 DB that I'm not able to copy/paste the longitude/latitudes. The city name I'm able to copy/paste there. And I can't add dots either, which are needed. :-k
Where are you trying to copy from (the Editor or a spreadsheet)? Where are you trying to paste to (the Editor or a spreadsheet)?
AngeLxLost
Junior League
Posts: 16
Joined: Mon May 23, 2016 11:59 pm
Favourite Team: Pittsburgh Penguikns

Re: EHM 1 Database & Saved Game Editor

Post by AngeLxLost »

Apologies if this has already been solved but I was just wondering why the attribute values for certain players that I've edited are different in game than in the editor.

ie. here's Crosby's attributes from my edited db (left) vs his actual attributes in game (right). I highlighted all the attributes that seem off https://imgur.com/a/thVkyrD

but then here's an also edited Yanni Gourde with attributes that seem to be more or less the same https://imgur.com/a/uEzdk

Idk if this has anything to do with it but Crosby's current/potential ability is 198/200 while Gourde is 145/180

Here's a download link to the db as well https://drive.google.com/open?id=1Kp7IQ ... R5dxXh6hGH_

Thank you in advance
User avatar
CJ
TBL Rosters Researcher
Posts: 3411
Joined: Tue Nov 08, 2011 6:34 pm
Custom Rank: Formerly jhcjobpb
Favourite Team: Florida Panthers
Location: Finland

Re: EHM 1 Database & Saved Game Editor

Post by CJ »

AngeLxLost wrote:Apologies if this has already been solved but I was just wondering why the attribute values for certain players that I've edited are different in game than in the editor.

ie. here's Crosby's attributes from my edited db (left) vs his actual attributes in game (right). I highlighted all the attributes that seem off https://imgur.com/a/thVkyrD

but then here's an also edited Yanni Gourde with attributes that seem to be more or less the same https://imgur.com/a/uEzdk

Idk if this has anything to do with it but Crosby's current/potential ability is 198/200 while Gourde is 145/180

Here's a download link to the db as well https://drive.google.com/open?id=1Kp7IQ ... R5dxXh6hGH_

Thank you in advance
You're using a 1-100 attribute scale in-game instead of the default1-20. That's all. Everything looks fine.
ankanbtw
Learning to skate
Posts: 2
Joined: Tue Oct 18, 2016 9:02 pm
Favourite Team: Linköping HC, Pens

Re: EHM 1 Database & Saved Game Editor

Post by ankanbtw »

Hello,

I'm new to this editor, so i wonder if there is any guide on how to import the real teams and players in too the editor?
Not so exited to rename every player :-p
AngeLxLost
Junior League
Posts: 16
Joined: Mon May 23, 2016 11:59 pm
Favourite Team: Pittsburgh Penguikns

Re: EHM 1 Database & Saved Game Editor

Post by AngeLxLost »

CJ wrote:
AngeLxLost wrote:Apologies if this has already been solved but I was just wondering why the attribute values for certain players that I've edited are different in game than in the editor.

ie. here's Crosby's attributes from my edited db (left) vs his actual attributes in game (right). I highlighted all the attributes that seem off https://imgur.com/a/thVkyrD

but then here's an also edited Yanni Gourde with attributes that seem to be more or less the same https://imgur.com/a/uEzdk

Idk if this has anything to do with it but Crosby's current/potential ability is 198/200 while Gourde is 145/180

Here's a download link to the db as well https://drive.google.com/open?id=1Kp7IQ ... R5dxXh6hGH_

Thank you in advance
You're using a 1-100 attribute scale in-game instead of the default1-20. That's all. Everything looks fine.
How? Just look at the shots, 18x5=90 and 19x5=95, not 72 and 77. Plus I'm using 1-20 in game.
User avatar
CJ
TBL Rosters Researcher
Posts: 3411
Joined: Tue Nov 08, 2011 6:34 pm
Custom Rank: Formerly jhcjobpb
Favourite Team: Florida Panthers
Location: Finland

Re: EHM 1 Database & Saved Game Editor

Post by CJ »

archibalduk wrote:
CJ wrote:Hi Archie. I noticed as I'm adding new cities to the 1998 DB that I'm not able to copy/paste the longitude/latitudes. The city name I'm able to copy/paste there. And I can't add dots either, which are needed. :-k
Where are you trying to copy from (the Editor or a spreadsheet)? Where are you trying to paste to (the Editor or a spreadsheet)?
I was trying it here in the Editor v0.2.8
https://i.imgur.com/DcynFbh.png
Is this not the place to be when adding cities?

Also these used to show the team colours:
https://i.imgur.com/1ts2fcO.png
Now they're all grey/black. I have to change one colour for it to show now, which is frustrating when doing mass team colour changing.

EDIT: I tested the v.0.2.7: The team colours are showing there without issues. Must be a v0.2.8 bug. :-k
I noticed that the issue was why I couldn't copy/paste those coordinates was that it included the dot. -> "." In both v0.2.7 and v0.2.8
AngeLxLost wrote:How? Just look at the shots, 18x5=90 and 19x5=95, not 72 and 77. Plus I'm using 1-20 in game.
I missed those things. Well it seems if you have edited them yourself, you've made him better than his CA states. Means that the game will take down some attributes from him. The game requires that the attributes reflects his attributes and vice versa. If you do him worse than his CA is then the game will raise some attributes.
AngeLxLost
Junior League
Posts: 16
Joined: Mon May 23, 2016 11:59 pm
Favourite Team: Pittsburgh Penguikns

Re: EHM 1 Database & Saved Game Editor

Post by AngeLxLost »

CJ wrote:I missed those things. Well it seems if you have edited them yourself, you've made him better than his CA states. Means that the game will take down some attributes from him. The game requires that the attributes reflects his attributes and vice versa. If you do him worse than his CA is then the game will raise some attributes
Oh okay, I initially thought that that might be the issue but dismissed it since his CA was already at 198. I even set it at 200 and there was still decrease but lowering a few of the other attributes did bring up the shots. Thanks for your help

Edit: Hm, I've increased a few player's CA/PA by 20-30 and the attributes show no change and stay lower than they should be. I can only seem to increase certain attributes by lowering others and changing the ability values isn't doing anything ):
User avatar
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:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

CJ wrote: I was trying it here in the Editor v0.2.8
https://i.imgur.com/DcynFbh.png
Is this not the place to be when adding cities?
Try using a comma instead of a dot. Can you manually enter numbers or does this not work either?
CJ wrote:Also these used to show the team colours:
https://i.imgur.com/1ts2fcO.png
Now they're all grey/black. I have to change one colour for it to show now, which is frustrating when doing mass team colour changing.

EDIT: I tested the v.0.2.7: The team colours are showing there without issues. Must be a v0.2.8 bug. :-k
Yes it's a known bug for 0.2.8 which is fixed for the next release.
CJ wrote:I noticed that the issue was why I couldn't copy/paste those coordinates was that it included the dot. -> "." In both v0.2.7 and v0.2.8
Sorry, I'm not sure what you mean here.
User avatar
Manimal
TBL Admin Team
Posts: 6344
Joined: Thu Apr 24, 2008 4:01 am
Custom Rank: EHM Rosters Man
Favourite Team: Djurgårdens IF
Location: Karlstad, Sweden

Re: EHM 1 Database & Saved Game Editor

Post by Manimal »

I came to think about another thing that would be useful for the editing.

Filtering players by their rights.
User avatar
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

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

archibalduk wrote:
xECK29x wrote:There is no template created for club_competitions :(
It works for me. It is called league.csv (or .xlsx, xml, etc).
Thanks, however how do I get missing items to be imported? I assume that is with a variable I put in the Mode row? I am trying to import 100+ cities.
User avatar
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:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

Manimal wrote:I came to think about another thing that would be useful for the editing.

Filtering players by their rights.
I have added to my to-do list. :thup:
xECK29x wrote:
archibalduk wrote:
xECK29x wrote:There is no template created for club_competitions :(
It works for me. It is called league.csv (or .xlsx, xml, etc).
Thanks, however how do I get missing items to be imported? I assume that is with a variable I put in the Mode row? I am trying to import 100+ cities.
Use the Cities template spreadsheet and put "a" in the Mode column.
User avatar
Manimal
TBL Admin Team
Posts: 6344
Joined: Thu Apr 24, 2008 4:01 am
Custom Rank: EHM Rosters Man
Favourite Team: Djurgårdens IF
Location: Karlstad, Sweden

Re: EHM 1 Database & Saved Game Editor

Post by Manimal »

I can't find where I can see what the roster errors are. It was in the "Data" section of a previous version
User avatar
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

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

Manimal wrote:I can't find where I can see what the roster errors are. It was in the "Data" section of a previous version
There does not seem to be cumulative list, but if you use the filter button under Staff or Clubs you can highlight which entries have errors.
Townsy17
Junior League
Posts: 7
Joined: Thu Dec 15, 2016 6:18 pm
Favourite Team: Toronto Maple Leafs

Re: EHM 1 Database & Saved Game Editor

Post by Townsy17 »

It's been a while since I've been on here, so I apologize if it has been addressed in another post, but I was curious to know whether or not the ability to add additional international sub-leagues (i.e. World Championships Div. 4, Div. 5, etc.) was possible? I've tinkered with countries reputations and relative strengths and it would be neat to see a non-traditional hockey country from say South America or Africa make their way up the ladder eventually! However, when I last asked, international league structures such as that weren't able to be added upon.

Also, is it possible to create fully-functioning leagues/tournaments in general? I'd like to create different domestic and international competitions for, again, non-traditional hockey countries, but wasn't sure if it was doable/viable (again, apologies if this has been addressed previously, just wanted to be sure). And if so, any tips for doing so, as I'm relatively new to this haha.

Any response would be greatly appreciated!
Townsy17
Junior League
Posts: 7
Joined: Thu Dec 15, 2016 6:18 pm
Favourite Team: Toronto Maple Leafs

Re: EHM 1 Database & Saved Game Editor

Post by Townsy17 »

Also, not sure if this is possible, but can you edit your reputation with your team in a more favourable manner? I'm doing a Vegas GM during which, in my first year, I tanked and finished last. During the offseason I drastically improved, though made some trades my fanbase/board weren't happy with as well. Had a great start to year two aside from a 7-game losing streak (6 in OT :roll: ) and I'm in first. However, my board was still unhappy enough with me to the point where I got fired if I lost my next game. I didn't want to lose all the work I had done, so I'd save and reset to make sure I won the game. Now I'm in December, on a 13-game win streak, first in the league, and my board is 'pleased with me' - but, again, after one loss I'm fired the next day due to a 'string of bad results'. Is there a workaround to this, or am I just doomed?
Post Reply