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
Buho
Junior League
Posts: 37
Joined: Mon Mar 13, 2017 5:47 pm
Favourite Team: NYR

EHM 1 Database & Saved Game Editor

Post by Buho »

archibalduk wrote: Mon Feb 10, 2020 6:52 pm No, the Editor is intended for viewing only for saved games as trying to edit them generally causes irreparable corruption.
I know, but I still don't understand why it's possible to change players role, for example, and that change will take effect in the game, but changing jersey numbers have no effect whatsoever.
btw changing players role in saved games doesn't cause file corruption.
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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

Buho wrote: Mon Feb 10, 2020 7:05 pm
archibalduk wrote: Mon Feb 10, 2020 6:52 pm No, the Editor is intended for viewing only for saved games as trying to edit them generally causes irreparable corruption.
I know, but I still don't understand why it's possible to change players role, for example, and that change will take effect in the game, but changing jersey numbers have no effect whatsoever.
btw changing players role in saved games doesn't cause file corruption.
It's because the saved game data is set out in a very different manner compared with the database data. The saved game contains a whole bunch of additional tables which the Editor cannot decode. When you start a new game, it basically takes parts of the database and transfers them into the saved game. So whilst there might be a Jersey Number field in a database table within the saved game, that's not to say there aren't other parts of the saved game which affect jersey numbers. Hence why changing a value in a saved game via the Editor might not have any effect in-game.

Whilst you might get away with editing a Player Role or other attribute, you should bear in mind that the Editor performs certain validation operations when saving in order to ensure that table references are correct (because the database/saved game is essentially a relational database). It is possible that this could result in some sort of issue when the game next updates the game data (e.g. on/around 1 January or 30 June). So simply loading and saving a saved game in the Editor, regardless of any changes that might be made, could ultimately result in corruption later on.
radusauce47
Learning to skate
Posts: 1
Joined: Wed Feb 12, 2020 7:52 pm
Favourite Team: Dallas Stars

EHM 1 Database & Saved Game Editor

Post by radusauce47 »

Can you edit databases such as Pivot with the editor? I am very tech savvy but have been struggling to figure it out. What I'm trying to do is add an affiliate to an NHL team and a few player edits.

Any ideas?
Smirnov2Chistov
Prospect
Posts: 80
Joined: Mon Jul 10, 2017 10:06 pm
Favourite Team: Anaheim Ducks

EHM 1 Database & Saved Game Editor

Post by Smirnov2Chistov »

radusauce47 wrote: Wed Feb 12, 2020 7:58 pm Can you edit databases such as Pivot with the editor? I am very tech savvy but have been struggling to figure it out. What I'm trying to do is add an affiliate to an NHL team and a few player edits.

Any ideas?
Have you tried using the EHM Assistant? You can do player edits a bit easier on that
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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

radusauce47 wrote: Wed Feb 12, 2020 7:58 pm Can you edit databases such as Pivot with the editor? I am very tech savvy but have been struggling to figure it out. What I'm trying to do is add an affiliate to an NHL team and a few player edits.

Any ideas?
This might help: https://www.ehmtheblueline.com/forums/v ... 92#p241892
Beatle
Junior League
Posts: 6
Joined: Mon Feb 24, 2020 5:36 am
Favourite Team: Boston Bruins

EHM 1 Database & Saved Game Editor

Post by Beatle »

I have a question? When you make changes to a player in abilities, how do you update current ability status in the editor? There must be a way to add the changes to give you a new current ability number.
Beatle
Junior League
Posts: 6
Joined: Mon Feb 24, 2020 5:36 am
Favourite Team: Boston Bruins

question on the editor 3.5?

Post by Beatle »

I have a question on the editor 3.5? When you make changes to a player in abilities, how do you update current ability status in the editor? There must be a way/button to calculate and update the changes you give a player that result in a new current ability number.
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

Current Ability is manually set, the game will auto-adjust around the CA value set, not the other way around. You can try setting your attributes to whatever and set the CA to 0 and see what happens but I bet it won't work how you expect.
User avatar
TurboJ
Drafted
Posts: 194
Joined: Mon Jan 14, 2019 12:08 pm
Favourite Team: TPS

EHM 1 Database & Saved Game Editor

Post by TurboJ »

archibalduk wrote: Sat Jan 04, 2020 3:28 pm If you want to add a new player then just click on the People tab from the main menu and then click on Players & Staff. This shows all of the players and non-playing staff in the DB. Near the bottom right corner of the screen, click on the Add Item button to add a new person. Set his Classification to Player and his Job For Club as Player. Then just complete any other details you like.
I would like to try adding a player to the most recent TBL database for my next game. I'm talking about a draft prospect for the 2020 draft. I wonder if there's somewhere a guide how you should set up a new player so that there's no bugs and crashes. I have read this forum a lot regarding how to, and I understand the skill atts rely on the CA you set for the player; this should be easy enough for me to figure out. But how do you set up player reputation? Can you just type in any number you like or does it have to rely on some other stats?

Also, how about adding a player history for a created player? I assume these things are 'numbers only' and don't actually affect any team histories or records etc. How about contracts, player rights? Is there any example or guide somewhere how these should be set right to avoid any bugs?

BTW; would there happen to exist a 'copy player' feature - so it would make it easier to make a new player, you know, with having a template that you could then edit...?
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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

No I'm not aware of any such guide I'm afraid and nor is there any copy and paste feature. You might want to take a read through this post which might help: https://www.ehmtheblueline.com/forums/v ... 920#p79564

AFAIK it's pretty difficult to cause a crash by simply creating a player. The best thing I can suggest is to take a look at another prospect and manually copy their settings. The Editor will highlight some fields in yellow if you set them up incorrect. The most important thing is to set the player's Classification to "Player" and Job For Club as Player. There is menu entitled "Tools" in the bottom-right corner of the editing screen when you edit your player which will allow you to auto-set Reputation based on the player's CA. However you can set any number you want (between 1 and 200).

Adding histories is straightforward. Just click on the History tab when editing the player and you will see an Add Item button which lets you add entries. Histories do in fact have some bearing on various records in-game.
Beatle
Junior League
Posts: 6
Joined: Mon Feb 24, 2020 5:36 am
Favourite Team: Boston Bruins

EHM 1 Database & Saved Game Editor

Post by Beatle »

Thanks for the response
User avatar
TurboJ
Drafted
Posts: 194
Joined: Mon Jan 14, 2019 12:08 pm
Favourite Team: TPS

EHM 1 Database & Saved Game Editor

Post by TurboJ »

Thanks on my part too! I think I have succeeded in making my first custom player. Now I will just have to see if the player succeeds as well :)
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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

Version 0.3.7 is now available: https://www.ehmtheblueline.com/forums/v ... 48&t=16014

Please note that you must install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash (prior versions of the Editor used the 2017 edition). You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

As set out in the changelist below, this release is largely a collection of tweaks and improvements rather than any ground-breaking new features. Most of my efforts are now concentrated on the new EHM Editor v2 which I would really like to release at some point later this year if I can (outside life permitting of course). Two changes I want to highlight are:

1. ROLLING SAVES: Similar to EHM, the Editor will now create rolling saves of your database. The default number of rolling saves is 3 but you can change this via the Settings screen (setting the number to zero will disable rolling saves). Each rolling save will have the file name "database[xxx].bak" where "[xxx]" will be an incremental three digit number. You can restore one of the rolling saves simply by renaming it to "database.db". Note that the Editor will delete any old rolling saves in the event the number of rolling saves exceeds the limit you set in the Settings screen. For example, if you have seven rolling saves and you set the limit to three in the Settings screen then the Editor will delete the four oldest rolling saves when you next save (and will then add new rolling save) - so just be careful if you decide to keep lots of spare rolling saves in the same folder as your main database file.

2. RULES & STRUCTURES: I have redesigned the Structures sub-screen in the hope this fixes some of the issues/crashes some users have encountered. The new design is a bit more clunky than I would like but hopefully it will do until Editor v2.

Special credit to xECK29x as many of the bugs fixed were identified by him.

CHANGELIST:

New Features:
  • Added Draft History mass deletion via the Competitions -> Mass Edit menu; and
  • Added rolling saves when saving a database.
Fixes and Improvements:
  • Added "Is Valid" columns to the Affiliations spreadsheet to indicate whether the Upper and Lower Clubs are valid (i.e. not inactive);
  • Added Nation Contracted and Job for Nation filters to the Staff screen;
  • Added Upper League and Lower League fields to the Affiliations screen;
  • Blank rows of data in a spreadsheet are now ignored when importing data (note: a row is considered blank if all of the first five columns are blank);
  • Fixed cramped/hidden checkbox settings on the Import Spreadsheet screen;
  • Fixed issue with City importer spreadsheets not matching existing city records when "[None]" or "_none" is present in the State column;
  • Increased the maximum log.txt file size from 500 lines to 1,500 lines;
  • Invalid affiliations are now highlighted in yellow in the Affiliations screen (i.e. to flag inactive clubs);
  • Redesigned the Structure sub-screen of the Rules & Structures screen;
  • The Help tab is now visible before a database or saved game is opened; and
  • Updated to Qt version 5.14 and Microsoft Visual Studio C++ 2019 - please ensure that you now install the Microsoft Visual Studio 2019 Redistributable from https://aka.ms/vs/16/release/VC_redist.x64.exe
NOTE: Version 0.3.6 was an internal release. The above changelist includes changes incorporated in version 0.3.6.
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

WOOOOOO
User avatar
ZaZooM
Prospect
Posts: 79
Joined: Fri Sep 03, 2010 5:26 pm
Favourite Team: Lokomotiv Yaroslavl / NY Rangers
Location: Moscow, Russia

EHM 1 Database & Saved Game Editor

Post by ZaZooM »

Is it possible, to open and sort in savegame editor current draft list of 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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

No I don't think there is I'm afraid. The in-game draft history is saved elsewhere in the saved game. If you just want a list of all players, you can just open the saved game and export spreadsheets via the Export Spreadsheet button. You can then filter it out in Excel.
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

I think something may be bugged in the new Structure screen for Conferences, I can't seem to view what these four divisional clubs are, nor can I add any?

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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

xECK29x wrote: Sun Mar 22, 2020 11:55 am I think something may be bugged in the new Structure screen for Conferences, I can't seem to view what these four divisional clubs are, nor can I add any?
Apologies, that screen is very clunky and painful. I have a much better idea of how it can be implemented but it would require way too much work to implement for the existing Editor. If you select/click on the row in the Conference and then the row in the Division then it will show the clubs. I ought to have mentioned that double-clicking on a cell in any of those tables allows you to change the Conference/Division/Club name.
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

Is there anyway to generate a list of duplicate UUIDs found so I know exactly what changed? I see entire competitions would be modified and without the exhaustive list (6k+ changes) it's going to be hard to manually rectify and validate. Maybe this functionality can be limited to playable leagues only?
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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

I will have a think about whether/how a list might be exported.

The UIDs are used for a lot more than just the playable league data. There are lots of items of data where changing the UID is inconsequential. The only things you need to check with the UIDs a few tables in the Editor. I could have sworn I wrote a guide somewhere but I can't find it now. Seems I missed it off the changelist too. I'll put something together when I can (probably the weekend).
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

Small feature request (likely more-so for v2), but import sheets for retired numbers, I don't think that is currently 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:

EHM 1 Database & Saved Game Editor

Post by archibalduk »

xECK29x wrote: Thu Apr 02, 2020 1:19 pm Small feature request (likely more-so for v2), but import sheets for retired numbers, I don't think that is currently supported.
Sure thing. :thup:
User avatar
wildcat62
Junior League
Posts: 16
Joined: Tue Feb 02, 2010 10:48 pm

EHM 1 Database & Saved Game Editor

Post by wildcat62 »

Hey Archi -

Is there currently a way to allow NHL teams to loan players without Junior Rights to Junior teams or is that one of those hard-coded things like the draft?
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

wildcat62 wrote: Sun Apr 05, 2020 7:17 pm Hey Archi -

Is there currently a way to allow NHL teams to loan players without Junior Rights to Junior teams or is that one of those hard-coded things like the draft?
It's not that it's hard coded, you can put rights for junior clubs in manually via the database or EHM Assistant. However the league must support the use of player rights within it's transfer rules.
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

EHM 1 Database & Saved Game Editor

Post by xECK29x »

Small request, under cities can you put a counter for how many times its used? Will help me in some of the work to remove duplicates/wrong entries. Similar to how names are counted.
Post Reply