Page 63 of 82
EHM 1 Database & Saved Game Editor
Posted: Mon Feb 10, 2020 7:05 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Mon Feb 10, 2020 9:06 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Wed Feb 12, 2020 7:58 pm
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?
EHM 1 Database & Saved Game Editor
Posted: Wed Feb 12, 2020 9:59 pm
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
EHM 1 Database & Saved Game Editor
Posted: Thu Feb 13, 2020 8:02 am
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
EHM 1 Database & Saved Game Editor
Posted: Sat Feb 29, 2020 11:52 pm
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.
question on the editor 3.5?
Posted: Sun Mar 01, 2020 3:29 am
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.
EHM 1 Database & Saved Game Editor
Posted: Wed Mar 04, 2020 9:52 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Sat Mar 07, 2020 8:32 pm
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...?
EHM 1 Database & Saved Game Editor
Posted: Sun Mar 08, 2020 11:31 am
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.
EHM 1 Database & Saved Game Editor
Posted: Sun Mar 08, 2020 11:35 pm
by Beatle
Thanks for the response
EHM 1 Database & Saved Game Editor
Posted: Mon Mar 09, 2020 6:22 am
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

EHM 1 Database & Saved Game Editor
Posted: Sun Mar 15, 2020 3:44 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Sun Mar 15, 2020 7:31 pm
by xECK29x
WOOOOOO
EHM 1 Database & Saved Game Editor
Posted: Mon Mar 16, 2020 6:02 pm
by ZaZooM
Is it possible, to open and sort in savegame editor current draft list of players?
EHM 1 Database & Saved Game Editor
Posted: Mon Mar 16, 2020 6:23 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Sun Mar 22, 2020 11:55 am
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?

EHM 1 Database & Saved Game Editor
Posted: Sun Mar 22, 2020 4:48 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Wed Apr 01, 2020 7:53 pm
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?
EHM 1 Database & Saved Game Editor
Posted: Wed Apr 01, 2020 7:59 pm
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).
EHM 1 Database & Saved Game Editor
Posted: Thu Apr 02, 2020 1:19 pm
by xECK29x
Small feature request (likely more-so for v2), but import sheets for retired numbers, I don't think that is currently supported.
EHM 1 Database & Saved Game Editor
Posted: Thu Apr 02, 2020 5:42 pm
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.

EHM 1 Database & Saved Game Editor
Posted: Sun Apr 05, 2020 7:17 pm
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?
EHM 1 Database & Saved Game Editor
Posted: Tue Apr 07, 2020 12:44 pm
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.
EHM 1 Database & Saved Game Editor
Posted: Sun Apr 19, 2020 3:02 pm
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.