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
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 Editor (2016)

Post by archibalduk »

bäckström19 wrote:i didnt find any players, why?

where i can change the states from the player?
archibalduk wrote:The players are under the Staff button/category. Staff means both players and non-players.
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 Editor (2016)

Post by archibalduk »

Image
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 Editor (2016)

Post by archibalduk »

New version here: http://www.ehmtheblueline.com/forums/vi ... 06#p206841

CHANGELIST: VERSION 0.0.3 (25-Feb-2016)

New Features:
  • Arena editing screen;
  • First name and second name editing screens;
  • Official editing screen;
  • Player awards editing screen;
  • Export screen added;
  • Non-player and player attributes exporting;
  • Add data button enabled for all editing screens except for Staff and Officials;
  • Raw table data export function on each editing screen;
  • Saved game loading, saving, unpacking and editing support.
Fixes and Improvements:
  • Added additional World Championship divisions to Senior National Team division settings;
  • EU Membership setting on the Nations screen fixed;
  • Fixed Morale and Natural Fitness attributes being swapped around;
  • Improved header/labelling system including headers that update with each edit;
  • Rearranged the Database Header editing screen;
  • Year of Birth field now automatically updates upon editing a date of birth.
***** BACKUP YOUR SAVED GAME / DATABASE BEFORE USING THE EDITOR *****
Note that you cannot move players between teams when editing saved games (it won't work properly in game).
User avatar
A9L3E
All-Star
Posts: 1230
Joined: Tue Sep 09, 2008 6:22 am
Custom Rank: Shiny gilded nameplate
Favourite Team: Helsingin Jokerit
Location: Vantaa, Finland

Re: EHM 1 Database Editor (2016)

Post by A9L3E »

Can one see from the arena editing screen which clubs have the arena as their home rink?
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 Editor (2016)

Post by archibalduk »

A9L3E wrote:Can one see from the arena editing screen which clubs have the arena as their home rink?
No, I'm afraid not. However, I have some code from the Updater v3 for creating a spreadsheet showing this - I'll try to remember to copy this over to the Editor for the next version.
User avatar
A9L3E
All-Star
Posts: 1230
Joined: Tue Sep 09, 2008 6:22 am
Custom Rank: Shiny gilded nameplate
Favourite Team: Helsingin Jokerit
Location: Vantaa, Finland

Re: EHM 1 Database Editor (2016)

Post by A9L3E »

archibalduk wrote:No, I'm afraid not. However, I have some code from the Updater v3 for creating a spreadsheet showing this - I'll try to remember to copy this over to the Editor for the next version.
That would be highly appreciated. :thup:
User avatar
Edgars
Top Prospect
Posts: 134
Joined: Fri Mar 08, 2013 6:37 am
Location: Rīga, Latvija

Re: EHM 1 Database Editor (2016)

Post by Edgars »

Are you planning to add "Delete" function to the editor?
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 Editor (2016)

Post by archibalduk »

Edgars wrote:Are you planning to add "Delete" function to the editor?
Yes eventually. But I need to first fully decode the DB in order to do so.
User avatar
ehmfans
Minor League
Posts: 223
Joined: Thu Nov 13, 2008 12:05 am
Location: Canada

Re: EHM 1 Database Editor (2016)

Post by ehmfans »

great job with editor!
Exarz
Junior League
Posts: 27
Joined: Fri Mar 30, 2012 4:23 pm
Favourite Team: VIK Västerås HK & Jokerit
Location: Sweden

Re: EHM 1 Database Editor (2016)

Post by Exarz »

Great editor!

However, it would be nice if you could add the option to search teams by league! It simplifies things a lot when you want teams to switch leagues etc! :D
Exarz
Junior League
Posts: 27
Joined: Fri Mar 30, 2012 4:23 pm
Favourite Team: VIK Västerås HK & Jokerit
Location: Sweden

Re: EHM 1 Database Editor (2016)

Post by Exarz »

I discovered a glitch: I added some teams to the KHL and moved some teams to other leagues to keep the league in the right amount of teams. However, the information and standings are wrong, as they still contain the other teams. In the player statistics and in the schedule, the new teams and their players are in.

Image
I put Metallurg Nk in the Russian Vysshaya Liga and replaced them with a new team (Beijing Dragons)

Image
I put Medvescak back in EBEL (I also made EBEL have the right amount of teams) and Vityaz in the Russian Vysshaya Liga. I replaced them with AIK Hockey and Eisbären Berlin

Image
Here's what it looks like in the information tab
Pepito9198
Junior League
Posts: 9
Joined: Thu Feb 25, 2016 4:31 am
Favourite Team: Montreal Canadiens

Re: EHM 1 Database Editor (2016)

Post by Pepito9198 »

archibalduk wrote:
Pepito9198 wrote:Hi, i downloaded the editor and i can only get to the games default databases. I have downloaded the TBL 8.1 which is updated and all but can load it into the editor. What could i be doing wrong? I can find the TBL 8.1 folder no problem, however the files are not (.DB)... ](*,)
You need to use the Import function in EHM to generate the DB file.
Agreed. Whenever i try to do that, the dialog box is empty. I mean, when i click ''Import Database : Import an EHM 2007 format database'' there is a dialog box, called Choose Database. Nothing is there. I must've forgotten a step somewhere..
Pepito9198
Junior League
Posts: 9
Joined: Thu Feb 25, 2016 4:31 am
Favourite Team: Montreal Canadiens

Re: EHM 1 Database Editor (2016)

Post by Pepito9198 »

Archie, i found how... silly me i was such in a hurry if forgot the most important step: unzipping the file ](*,)
now part two of the question, can we remove the salary cap?
Pepito9198
Junior League
Posts: 9
Joined: Thu Feb 25, 2016 4:31 am
Favourite Team: Montreal Canadiens

Re: EHM 1 Database Editor (2016)

Post by Pepito9198 »

Pepito9198 wrote:Archie, i found how... silly me i was such in a hurry if forgot the most important step: unzipping the file ](*,)
now part two of the question, can we remove the salary cap?

OK, so i was able to load the 8.1 DB update nto the editor. I saved my work under a different name. Now cant load a new game with it... it's already a .DB file, so i assume no need to import? I ''unziped'' it but not sure what that step is for exactly...
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 Editor (2016)

Post by archibalduk »

Exarz wrote:I discovered a glitch: I added some teams to the KHL and moved some teams to other leagues to keep the league in the right amount of teams. However, the information and standings are wrong, as they still contain the other teams. In the player statistics and in the schedule, the new teams and their players are in.
Yes this was raised previously IIRC. The database has some new tables that weren't in EHM 2007 and relate to things such as league rules, structures and schedules. These were hardcoded in EHM 2007 and are now editable via the DB in EHM 1. However, I don't know the structures for these tables yet and so we cannot edit them in the Editor. I suspect some of those tables are affecting which leagues teams are placed in. The only way to get around it at the moment is to use the import_config.cfg file before importing the EHM 2007 format database. See here: http://www.ehmtheblueline.com/forums/vi ... 70#p199124
Pepito9198 wrote:now part two of the question, can we remove the salary cap?
You need to edit the transfer_rules.cfg file located in the same folder as your database.db file. Open the file using Notepad.
Pepito9198 wrote:OK, so i was able to load the 8.1 DB update nto the editor. I saved my work under a different name. Now cant load a new game with it... it's already a .DB file, so i assume no need to import? I ''unziped'' it but not sure what that step is for exactly...
You need to save the file as database.db as this, to my knowledge, is the only way for the database to appear in game.

I'm not sure what you mean about unzipping. I wonder if you mean the Unpack button in the Editor. You don't need to use this. Just use the button entitled "Save".
User avatar
Edgars
Top Prospect
Posts: 134
Joined: Fri Mar 08, 2013 6:37 am
Location: Rīga, Latvija

Re: EHM 1 Database Editor (2016)

Post by Edgars »

archibalduk wrote:
Edgars wrote:Are you planning to add "Delete" function to the editor?
Yes eventually. But I need to first fully decode the DB in order to do so.
OK - thank you - keep up the great work! =D>
User avatar
A9L3E
All-Star
Posts: 1230
Joined: Tue Sep 09, 2008 6:22 am
Custom Rank: Shiny gilded nameplate
Favourite Team: Helsingin Jokerit
Location: Vantaa, Finland

Re: EHM 1 Database Editor (2016)

Post by A9L3E »

I really wonder why Riz is not helping you with decoding the database. It could save him some work in adding more playable leagues and potentially boost the game sales.
Pepito9198
Junior League
Posts: 9
Joined: Thu Feb 25, 2016 4:31 am
Favourite Team: Montreal Canadiens

Re: EHM 1 Database Editor (2016)

Post by Pepito9198 »

Archie: Very good, it worked!!! thanks! :thup:
User avatar
JakeTheSnake
Prospect
Posts: 73
Joined: Fri May 06, 2011 9:07 am
Location: Finland

Re: EHM 1 Database Editor (2016)

Post by JakeTheSnake »

Archie, you said in this discussion (and there's also a note about it on the editor) that we should make backups of our databases/saved games.
Does that mean i can edit my saved games in some way with the editor?

How? I can't seem to find any way to open a saved game with the editor.
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 Editor (2016)

Post by archibalduk »

That's right; you can edit saved games but only with version 0.0.3 onwards. Sounds like you might have the older version still. Just download the latest version here:

http://www.ehmtheblueline.com/forums/vi ... 48&t=16014

You'll see there is an Open Saved Game button next to the Open Database button
User avatar
JakeTheSnake
Prospect
Posts: 73
Joined: Fri May 06, 2011 9:07 am
Location: Finland

Re: EHM 1 Database Editor (2016)

Post by JakeTheSnake »

Fantastic!
Thank you!
Pepito9198
Junior League
Posts: 9
Joined: Thu Feb 25, 2016 4:31 am
Favourite Team: Montreal Canadiens

Re: EHM 1 Database Editor (2016)

Post by Pepito9198 »

Archibalduk: I know it cant be done now, but are you going to add some league editing tools to the editor? Like changing/removing salary cap, max contract lenght etc? i know it can be done before a game but what about a save game?
zbguy
Top Prospect
Posts: 121
Joined: Wed Aug 28, 2013 7:01 pm

Re: EHM 1 Database Editor (2016)

Post by zbguy »

Thanks for the save-game editing, Archi. It works very nicely with EHMAssistant!
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 Editor (2016)

Post by archibalduk »

Pepito9198 wrote:Archibalduk: I know it cant be done now, but are you going to add some league editing tools to the editor? Like changing/removing salary cap, max contract lenght etc? i know it can be done before a game but what about a save game?
I don't really know. It depends on whether and how much of the league editing I can implement into the Editor (the table structures are complex) and then whether the league rules are stored in the same way in the saved game as the database (as the database editing functions are my priority). Each database editing screen in the Editor will load any such data in the saved game too. But the saved games don't always store the data in the same way which means they won't appear in the Editor - see for example the Affiliations editing screen (you'll see it's blank/empty in the saved game because the data is stored elsewhere and in a different format).
tjackie
Junior League
Posts: 7
Joined: Sat Nov 07, 2015 3:12 pm
Favourite Team: Mora IK

Re: EHM 1 Database Editor (2016)

Post by tjackie »

Hi. I dunno if this is already answered somewhere. But can someone give me instructions (if it is possible) how to export my own team (Toronto atm) to .csv without getting the whole database or all the players that exists? I just want an export of my own team but I have no idea what im doing wrong. I use the latest version, got the vcredist installed and I managed to edit some weight on a player that I wanted to do also but the exporting player part just doesn't work for me.. I wish I could use both EHM EA assistant but now that the game is updated I cant use the assistant anymore. Any help is appreciated.

I think I posted this in the wrong forum before. Sorry. ](*,)
Post Reply