The Blue Line

EHM 1 Database & Saved Game Editor

Discuss all aspects of editing the data in EHM here. Have a question about the Pre Game Editor, editing the .cfg files, hex editing the .dat 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.

Please note that discussion about roster updates belongs in the Game Add-ons Forum.

Re: EHM 1 Database & Saved Game Editor

Postby AngeLxLost » Thu Apr 12, 2018 10:43 am

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.
AngeLxLost
Junior League
 
Posts: 14
Joined: Tue May 24, 2016 12:59 am
Points: 0.14

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Thu Apr 12, 2018 8:19 pm

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.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,844
Joined: Tue Jul 06, 2004 9:44 pm
Points: 199.64
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby AngeLxLost » Fri Apr 13, 2018 12:36 am

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.
AngeLxLost
Junior League
 
Posts: 14
Joined: Tue May 24, 2016 12:59 am
Points: 0.14

Re: EHM 1 Database & Saved Game Editor

Postby DK_Hockey » Fri Apr 13, 2018 11:34 am

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.
DK_Hockey
Junior League
 
Posts: 25
Joined: Wed May 04, 2011 8:29 am
Points: 0.25

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Fri Apr 13, 2018 3:37 pm

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
xECK29x
Premier Pivot Rosters Man
Top Prospect
 
Posts: 126
Joined: Sun May 03, 2015 3:52 pm
Points: 1.26

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Fri Apr 13, 2018 7:44 pm

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
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,844
Joined: Tue Jul 06, 2004 9:44 pm
Points: 199.64
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Fri Apr 13, 2018 11:17 pm

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
xECK29x
Premier Pivot Rosters Man
Top Prospect
 
Posts: 126
Joined: Sun May 03, 2015 3:52 pm
Points: 1.26

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sat Apr 14, 2018 7:29 am

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
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,844
Joined: Tue Jul 06, 2004 9:44 pm
Points: 199.64
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Sat Apr 14, 2018 2:05 pm

There is no template created for club_competitions :(
User avatar
xECK29x
Premier Pivot Rosters Man
Top Prospect
 
Posts: 126
Joined: Sun May 03, 2015 3:52 pm
Points: 1.26

Re: EHM 1 Database & Saved Game Editor

Postby CJ » Wed Apr 18, 2018 5:09 pm

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
CJ
Formerly jhcjobpb
TBL Rosters Researcher
 
Posts: 3,384
Joined: Tue Nov 08, 2011 8:34 pm
Points: 54.87

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Wed Apr 18, 2018 8:55 pm

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)?
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,844
Joined: Tue Jul 06, 2004 9:44 pm
Points: 199.64
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby AngeLxLost » Thu Apr 19, 2018 9:54 am

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 ... 5dxXh6hGH_

Thank you in advance
AngeLxLost
Junior League
 
Posts: 14
Joined: Tue May 24, 2016 12:59 am
Points: 0.14

Re: EHM 1 Database & Saved Game Editor

Postby CJ » Thu Apr 19, 2018 12:33 pm

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 ... 5dxXh6hGH_

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.
User avatar
CJ
Formerly jhcjobpb
TBL Rosters Researcher
 
Posts: 3,384
Joined: Tue Nov 08, 2011 8:34 pm
Points: 54.87

Re: EHM 1 Database & Saved Game Editor

Postby ankanbtw » Thu Apr 19, 2018 5:46 pm

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
ankanbtw
Learning to skate
 
Posts: 2
Joined: Tue Oct 18, 2016 10:02 pm
Points: 0.02

Re: EHM 1 Database & Saved Game Editor

Postby AngeLxLost » Thu Apr 19, 2018 6:21 pm

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 ... 5dxXh6hGH_

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.
AngeLxLost
Junior League
 
Posts: 14
Joined: Tue May 24, 2016 12:59 am
Points: 0.14

Re: EHM 1 Database & Saved Game Editor

Postby CJ » Thu Apr 19, 2018 6:41 pm

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.
User avatar
CJ
Formerly jhcjobpb
TBL Rosters Researcher
 
Posts: 3,384
Joined: Tue Nov 08, 2011 8:34 pm
Points: 54.87

Re: EHM 1 Database & Saved Game Editor

Postby AngeLxLost » Thu Apr 19, 2018 7:03 pm

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 ):
AngeLxLost
Junior League
 
Posts: 14
Joined: Tue May 24, 2016 12:59 am
Points: 0.14

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Thu Apr 19, 2018 9:42 pm

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
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,844
Joined: Tue Jul 06, 2004 9:44 pm
Points: 199.64
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby Manimal » Thu Apr 19, 2018 11:10 pm

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

Filtering players by their rights.
User avatar
Manimal
EHM Rosters Man
TBL Admin Team
 
Posts: 6,191
Joined: Thu Apr 24, 2008 5:01 am
Points: 205.96
Trophies:  4 

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Fri Apr 20, 2018 2:49 pm

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
xECK29x
Premier Pivot Rosters Man
Top Prospect
 
Posts: 126
Joined: Sun May 03, 2015 3:52 pm
Points: 1.26

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sat Apr 21, 2018 10:19 am

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
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,844
Joined: Tue Jul 06, 2004 9:44 pm
Points: 199.64
Trophies:  1   2   1

Previous

Return to Data Editing Forum

Who is online

Users browsing this forum: No registered users and 1 guest