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
BKarchitect
Second Line
Posts: 656
Joined: Sat Jan 07, 2012 11:21 pm

Re: EHM 1 Database & Saved Game Editor

Post by BKarchitect »

Cool beans, no need to jump on it, just something that could make future database mods easier for the end users.
User avatar
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

Post by Alessandro »

archibalduk wrote:I have ironed out the remaining issues with the EHM 2005 conversion and now have the original EHM 2005 database up and running in EHM 1! :joy: I haven't done much simming yet, but it's looking pretty good to so far (using the 2006 rule set of course).


Image
Kazakhstan had an argument with the IOC? :-D
marksbros6
TBL Rosters Researcher
Posts: 601
Joined: Sun Nov 24, 2013 7:34 pm

Re: EHM 1 Database & Saved Game Editor

Post by marksbros6 »

archibalduk wrote:I have ironed out the remaining issues with the EHM 2005 conversion and now have the original EHM 2005 database up and running in EHM 1! :joy: I haven't done much simming yet, but it's looking pretty good to so far (using the 2006 rule set of course).

Image

Image

Image
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).
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 »

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. ](*,)
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 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).
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 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... :-k

Image
trevorjazz
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

Post by trevorjazz »

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. :dunno:
kgee420
Learning to skate
Posts: 2
Joined: Fri Aug 14, 2015 10:57 pm
Favourite Team: montreal canadiens

Comment loader apres editer

Post by kgee420 »

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 ?
User avatar
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

Post by Tasku »

The forum language is English. Please repeat your question in English. :-)
Bradkelly57
Learning to skate
Posts: 1
Joined: Sat Dec 23, 2017 8:12 pm
Favourite Team: Whitley Warriors

Re: EHM 1 Database & Saved Game Editor

Post by Bradkelly57 »

is there anyway of getting the editor to work within playonmac?
Epic
Prospect
Posts: 71
Joined: Tue May 14, 2013 2:28 am

Re: EHM 1 Database & Saved Game Editor

Post by Epic »

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?
zbguy
Top Prospect
Posts: 121
Joined: Wed Aug 28, 2013 7:01 pm

Re: EHM 1 Database & Saved Game Editor

Post by zbguy »

Hey Archi, is there a way (or, if not, are there plans) to export/import players individually?
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 »

Bradkelly57 wrote:is there anyway of getting the editor to work within playonmac?
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=48145

Also install the latest .NET Framework.
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. :dunno:
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.
zbguy wrote:Hey Archi, is there a way (or, if not, are there plans) to export/import players individually?
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.

The next version of the Editor also allows Career History exporting which can also then be imported using a similar method as described above.
Epic 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?
Use the "DRAFT_PICK_SWITCH" setting in extra_config - see here: viewtopic.php?f=110&t=2382
User avatar
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

Post by leafsrock67 »

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?
erik12
Learning to skate
Posts: 1
Joined: Sun Dec 31, 2017 9:03 am
Favourite Team: dsf

Re: EHM 1 Database & Saved Game Editor

Post by erik12 »

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
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 »

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?
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:
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.
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.

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
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.
Great Imp
Junior League
Posts: 6
Joined: Wed Jul 12, 2017 10:19 am
Favourite Team: Toronto

Re: EHM 1 Database & Saved Game Editor

Post by Great Imp »

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?
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 »

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). :thup:

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!
Great Imp
Junior League
Posts: 6
Joined: Wed Jul 12, 2017 10:19 am
Favourite Team: Toronto

Re: EHM 1 Database & Saved Game Editor

Post by Great Imp »

Awesome, thank you. I wonder if Riz would be interested in the save file?
StamkosMatt
TBL Rosters Researcher
Posts: 4
Joined: Sat Dec 30, 2017 12:42 pm
Favourite Team: Fassa Falcons

Re: EHM 1 Database & Saved Game Editor

Post by StamkosMatt »

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
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 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.
Great Imp wrote:Awesome, thank you. I wonder if Riz would be interested in the save file?
Possibly. I suggest uploading it to the SI Forums - details here: https://community.sigames.com/topic/345275-ftp-details/
User avatar
MasterMatt23
Junior League
Posts: 7
Joined: Sun Dec 31, 2017 3:53 am
Favourite Team: Montreal Canadiens

Re: EHM 1 Database & Saved Game Editor

Post by MasterMatt23 »

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?
User avatar
Tonait
Junior League
Posts: 24
Joined: Mon Sep 19, 2011 9:15 pm
Location: Turku, Finland

Re: EHM 1 Database & Saved Game Editor

Post by Tonait »

How can I place all players as free agents at the beginning of the game?
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 »

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?
Editing ratings shouldn't cause a crash. Did you edit something else as well?
Tonait wrote:How can I place all players as free agents at the beginning of the game?
You could use the Staff importer file to list every player and make them free agents.
User avatar
Tonait
Junior League
Posts: 24
Joined: Mon Sep 19, 2011 9:15 pm
Location: Turku, Finland

Re: EHM 1 Database & Saved Game Editor

Post by Tonait »

archibalduk wrote:
Tonait wrote:How can I place all players as free agents at the beginning of the game?
You could use the Staff importer file to list every player and make them free agents.
I'm not sure now How i find Staff importer file?
Post Reply