EHM 1 Database & Saved Game Editor v1: BUG REPORTS & FEATURE REQUESTS

[xECK29x]

https://imgur.com/a/WBZT86c

when I try to start a new game this comes and game crashes

database which I edited is xECK29x's Premier Pivot Database (v5.1)

what to do now?

You must have broken a league structure, it's impossible to troubleshoot without knowing what you did, did you also accidentally save the database as version 1033 (click the home page and check) you should be using 1025.

[archibalduk]

Doing some testing with the 1.5 PA ranges and it appears they are being saved into a 1033 header DB just fine, but the new PAs all show visually as -15, is this expected? Using the internal build you shared (0.4.5) but this may be the case with any version that supports 1033.

Hmm that doesn't sound right. Let me take a look...

How is the json patcher? No worries if you haven't been able to try it. Just thought I'd ask as I'll be posting a public release soon.

[xECK29x]

How is the json patcher? No worries if you haven't been able to try it. Just thought I'd ask as I'll be posting a public release soon.

Used it for the 5.1 release, no complaints!

[archibalduk]

Excellent - thanks!

[TBIF]

@archi

For overwriting, just when scraping drafts then leagues but I've figured out some work arounds!

[xECK29x]

For 'auto set PA' slight change, if a CA is 0 just ignore skip it.

[archibalduk]

Version 0.4.6 of the Editor is now available here: viewtopic.php?p=206841#p206841

A full changelist is set out at the end of this post. It has been a been a really disruptive time for me which is why I haven't been quite so active on the forums and why it has taken so long to release the latest version of the Editor. Sadly I'm around 6+ months behind schedule with Editor v2 which means no release until mid/late 2021. Hopefully over the next few months I can start making some real progress again.

This release of the Editor includes a completely re-written internal database version tracker which should resolve the issue with the database version/format being altered mid-save. This is a big change to the Editor which obviously brings risk but I've done a lot of testing with this and xECK29x has been using this for a few months now, so it should be fine. Aside from this, the main changes introduced with this version are:

• JSON patching ability. This is fairly limited but it is enough to created patches to change the number of teams in a playable league. This was specifically designed to allow a 31-team NHL to be patched to a 32-team NHL. However, I'm certain this can be used for other types of patching. Click on File -> Import Patch to see further details. There are also two sample .json files included with the Editor (See "patch_example01.json" and "patch_example01.json").
• Club/player records importing and exporting (by popular demand!). Click on File -> Import Spreadsheet -> Create Templates in order to create a template spreadsheet. If you're not sure how to complete the spreadsheet, click on File -> Export Spreadsheet -> Club Records and this will show how the importer spreadsheet should be completed. Note that the DOB column only needs to be completed if the person exists in the database. If the record holder does not exist in the database, just enter their first and second name and leave the DOB blank.
• Improved text searching on the Players & Non-players screen. Unfortunately the addition of all of these extra staff filters has really slowed things down. Text searching is particularly slow. However, text searching is now much quicker if all staff filters are disabled. Text searching with any staff filters enabled is still very slow/laggy and unfortunately this is unavoidable - but this shouldn't be an issue for EHM Editor v2.

I'm hoping to have another release in the very near future to include (1) improved schedule generation; (2) a fix to saved game viewing for v1.5 game format; and (3) the tweak to 'auto set PA' requested by xECK29x above.


CHANGELIST: VERSION 0.4.6 (06-December-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. 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

New Features:

• Added club records importing;
• Added json patching;
• Player potential ability auto-calculation for players aged 24 and older via (i) the Player Details tab of the Staff screen (for a single player) and (ii) via the People -> Mass Edit menu (mass editing); and
• Re-written the internal database version tracker in order to fix an issue with the Editor changing database format mid-save.

Fixes and Improvements:

• Added an 'Enable Logging' setting in order to toggle logging for the purposes of testing (I highly recommend that this setting is always enabled);
• Added an 'NHL Draft Eligibility' indicator to the Statistics tab of the Staff screen;
• Added club records exporting;
• Added extra extended logging text;
• Added Position filtering for players;
• Added Player Role filtering for players;
• Adjusted the default settings on the Find and Replace Club Competitions function for mass editing player career histories;
• Club record entries are now added for any club without any assigned;
• Fixed a crash when attempting to access the Find and Replace Club Competitions function for mass editing player career histories;
• Fixed potential crash when re-ordering the Retired Numbers table where there are two identical entries;
• Fixed an issue with the NHL Draft eligibility player filter;
• Fixed an issue with the stylesheet which was resulting in it not being applied to the Editor;
• Inactive clubs with a Continental Licence set are now flagged as a club error in the Editor;
• Improved performance when using the text search on the Staff screen where all filters are disabled;
• Increased the log file size to 2,048 lines;
• Rearranged the home screen in order to give greater prominence to the editor log;
• The Schedule Dates Generator now accounts for leap years (note: dates falling on 29 February will continue to appear as 1 March in the Schedule Dates table due to the way in which the day of the year is stored in the database - but this shouldn't impact the in-game dates which should still account for a leap year in any event); and
• Tidied up the Importer screen slightly.

NOTE: Versions 0.4.3 - 0.4.5 were internal releases. The above changelist includes changes incorporated in versions 0.4.3 - 0.4.5.

[archibalduk]

Note to self care of prountercoductive on Reddit:

Awesome, will give a try today.

Also one note from the last version, when exporting/re-importing nations. The Senior and Junior divisions seem to get swapped, it's an easy fix in Excel, but was wondering if you caught that in this update.

[xECK29x]

Small bug, if you use the Club Contracted staff filter you need to apply it twice for it to work properly.

[xECK29x]

Would love for the ability to generate an export sheet (same as players & non-players research sheet) from the Export Data button on a selected staff/player. This would allow us to take that sheet and run it against a tool to dynamically set attributes and allow for easy re-import.

[archibalduk]

Would love for the ability to generate an export sheet (same as players & non-players research sheet) from the Export Data button on a selected staff/player. This would allow us to take that sheet and run it against a tool to dynamically set attributes and allow for easy re-import.

Small bug, if you use the Club Contracted staff filter you need to apply it twice for it to work properly.

I'm looking at both of these today along with your staff_history error and keyboard shortcuts (no guarantee on whether shortcuts will be feasible however). I gave up trying to port my code over to Qt 6 as it was taking far too much time with little benefit. I'll keep Editor v1 as Qt 5.x and Editor v2 will be Qt 6.x as it should be a little simpler to port.

[TBIF]

I'd also love an export player or export contracted to team function!

[EArk]

It would be very nice to be able to play with all WJC divisions, so you can be able to take a small nation all the way through the divisions.

[archibalduk]

Version 0.4.7 of the Editor is now available: https://ehmtheblueline.com/editor

This is largely a hotfix to address a crash when importing player career history into a database which already has a large number of history entries (around 350,000+ entries). This also includes the requests from xECK29x and TBIF above.

CHANGELIST: VERSION 0.4.7 (20-December-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. 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

New Features:

• Added an option to export a staff research spreadsheet via the "Export Data" button in the bottom right hand corner of the Players and Staff screen and the Clubs screen.

Fixes and Improvements:

• Added warnings on the Affiliations screen where Affiliation Type is set to (i) [None] or (ii) Junior where the lower club is not a junior club;
• Fixed a bug with player/non-player filtering which required a filter to be applied twice before the data would be properly filtered;
• Fixed a bug with saved games not being loaded correctly;
• Fixed a crash when importing player career history into databases with a large volume (approx. 350,000+) of existing player career history data; and
• Fixed a mismatch between Senior and Junior Final Position columns when importing nation data.

[archibalduk]

Would love for the ability to generate an export sheet (same as players & non-players research sheet) from the Export Data button on a selected staff/player. This would allow us to take that sheet and run it against a tool to dynamically set attributes and allow for easy re-import.

You'll see I have added this to v0.4.7 but I was wondering whether you wanted the ability to create such a spreadsheet for every single player in the DB. I.e. a single click and it creates ~30,000 spreadsheets (one per player/staff). Is that something that would be useful?

[xECK29x]

You'll see I have added this to v0.4.7 but I was wondering whether you wanted the ability to create such a spreadsheet for every single player in the DB. I.e. a single click and it creates ~30,000 spreadsheets (one per player/staff). Is that something that would be useful?

Nah, I think just for the focused player, export entire focused club contracted/playing would be helpful though . Thanks for turning the bugs around so quick!

[xECK29x]

Another small ask, can you add "Calculate Player Pass Tendency" to the Tools and Mass Edit sections? I believe this is only used when importing player career histories? I could have sworn I saw something for it.

[EArk]

Hi is it possible to download the last database instead of just have it on steam?, so that I can work with it in the editor?

Br

[TBIF]

You can do two things: Copy and paste it from steam into your DB folder, or also just edit the steam download but future updates will wipe out your changes. However if you're just doing quick edits and then creating a new game it wouldn't matter.

[jtpedigo]

Hi everyone,

I am running EHM 1.4.1 and i just downloaded the most recent Save Game Editor and the most recent Visual C++ but i cannot seem to get anything to load after i select the save game database i want to edit. any thoughts or suggestions?

thanks

[ideawithoutamind]

Thanks so much for this tool, spent way too much time experimenting with it.

Anyways I have a few requests/notes listed in no particular order. This list is by no means a demand list, just some notes after using the tool for a bit that would come in handy. Not sure if some are even possible.

1. Playable League Validation, some sort of check for at least common errors in league creation. Even a baseline check would be nice, I know it can't cover every situation.

2. Some of these function one way at the moment, not all work importing, but some of the spreadsheets that would be helpful to be able to import/export:
- Names (first, second)
- Awards
- Financial Info
- Transfer rules

3. Not sure if it's a bug, haven't done extensive testing, but in import/export of National teams, cannot edit separately edit U20 and National Team without it editing both. Ex. Exporting and re-importing Serbia U20.and Senior team overwrites same info from spreadsheet to both.

4. Some sort of rough in editor guide to what CA/PA matches with what reputation for leagues. ex. Creating a -7 PA, 95 CA would likely sign/wouldn't sign with a team of x reputation or a league of Y reputation. Trying to fill out some mid level leagues, I'd like to make sure the appropriate players are available.

5. In app searching for players at a certain NHL draft age, not just year but by date. Ex Players born between 15.9.2005 and 14.9.2006 are elible for the 2024 draft, to be able to search specifically by 2024.

6. Search counters (quick stats from searches). From the search a quick status of how many returned, how many with contracts, and nation list with count.

7. Open / re-opening different databases without needing to close and reopen.

[archibalduk]

Hi everyone,

I am running EHM 1.4.1 and i just downloaded the most recent Save Game Editor and the most recent Visual C++ but i cannot seem to get anything to load after i select the save game database i want to edit. any thoughts or suggestions?

thanks

Sorry I'm not entirely clear. Is it the Editor or game which isn't loading your database? What exactly have you edited, if anything?

Thanks so much for this tool, spent way too much time experimenting with it.

Anyways I have a few requests/notes listed in no particular order. This list is by no means a demand list, just some notes after using the tool for a bit that would come in handy. Not sure if some are even possible.

1. Playable League Validation, some sort of check for at least common errors in league creation. Even a baseline check would be nice, I know it can't cover every situation.

Thanks for your kind comments and taking the time to post feedback, which is super useful.

Playable league validation is high on my list. The current editor isn't very user friendly, so I'm planning to redesign the user interface and implement some validation for Editor v2. It's not that straightforward to add to the current v0.x/1.x Editor (i.e. the current Editor which is currently v.0.x.x but will eventually become v1.x.x) because it requires a complete redesign under the hood to make this possible. If there's any particular things you would like validated then let me know. I have a rough idea in my mind (e.g. stage counts and checking that dates between stages do not overlap) but I'm sure there's other things it can cover.

2. Some of these function one way at the moment, not all work importing, but some of the spreadsheets that would be helpful to be able to import/export:
- Names (first, second)
- Awards
- Financial Info
- Transfer rules

Names - This can be done in a bit of an indirect way already. You can import players/staff with the names you want to add to the database and then immediately retire those players/staff. This will get the names into the database and delete the temporary players/staff. Editor v2.x handles names very differently and allows us to import/export/add/delete names more easily.

Awards - I can put this on my list for v0.x/1.x.

Financial info / transfer rules - I will see if I can do this for v2.x. It might be a bit of a push for v0.x/1.x.

3. Not sure if it's a bug, haven't done extensive testing, but in import/export of National teams, cannot edit separately edit U20 and National Team without it editing both. Ex. Exporting and re-importing Serbia U20.and Senior team overwrites same info from spreadsheet to both.

Well spotted! I haven't looked at this but I know exactly what the issue will be. I'll fix this for the next release.

4. Some sort of rough in editor guide to what CA/PA matches with what reputation for leagues. ex. Creating a -7 PA, 95 CA would likely sign/wouldn't sign with a team of x reputation or a league of Y reputation. Trying to fill out some mid level leagues, I'd like to make sure the appropriate players are available.

This is a very interesting idea and could definitely be added. If we could figure out some sort of approximate formula then this would be very doable. xECK29x is this something you have ever thought about?

5. In app searching for players at a certain NHL draft age, not just year but by date. Ex Players born between 15.9.2005 and 14.9.2006 are elible for the 2024 draft, to be able to search specifically by 2024.

This is possibly a bit of a push for v0.x/1.x just because of the way in which filtering works in the Editor. The volume of filters in the Editor has really slowed it down. Things are better in Editor v2.x which doesn't have the same limitation and in fact allows basically any field to be filtered. I'll need to figure out a simple way of how this could be filtered in Editor v2.x because Europeans are eligible for multiple draft years, so that will make things a bit complex - but I'll see what I can do.

6. Search counters (quick stats from searches). From the search a quick status of how many returned, how many with contracts, and nation list with count.

I'll see if I can get this into the next release.

7. Open / re-opening different databases without needing to close and reopen.

I'm afraid this simply isn't possible for Editor v0.x/1.x because of the way in which the data is loaded in the Editor. I'm hoping it will be possible in Editor v2.x because I've specifically had this in mind when redesigning it. I won't be able to test this out for a while yet (I haven't yet worked on processing playable leagues) but I'm hopeful this should be possible.

[xECK29x]

This is a weird one, and I'm not sure how it can be handled. We have a few cities where we use ',' in the longitude to get some divisions working properly. The ',' is not rendering properly on @Matee's editor, it always renders back as a '.'. Is this a localization issue? Matte is Polish and his Windows is set to Polish localization settings while I am on American English.

[jtpedigo]

Sorry, I try to load my saved game in the editor and I cannot search for any players, teams, citys. It like its not loading the saved game database

[ideawithoutamind]

Wow, thanks for the detailed response, much appreciated. I'll try to answer what you've asked back regarding my questions.

Thanks so much for this tool, spent way too much time experimenting with it.

Anyways I have a few requests/notes listed in no particular order. This list is by no means a demand list, just some notes after using the tool for a bit that would come in handy. Not sure if some are even possible.

1. Playable League Validation, some sort of check for at least common errors in league creation. Even a baseline check would be nice, I know it can't cover every situation.

Thanks for your kind comments and taking the time to post feedback, which is super useful.

Playable league validation is high on my list. The current editor isn't very user friendly, so I'm planning to redesign the user interface and implement some validation for Editor v2. It's not that straightforward to add to the current v0.x/1.x Editor (i.e. the current Editor which is currently v.0.x.x but will eventually become v1.x.x) because it requires a complete redesign under the hood to make this possible. If there's any particular things you would like validated then let me know. I have a rough idea in my mind (e.g. stage counts and checking that dates between stages do not overlap) but I'm sure there's other things it can cover.

A few things that would be helpful for quick checks are:
Team counts matching (via structure or teams assigned via club table), and teams being pulled from whatever source are correctly input/connected in the database, many of the crashes in game aren't very informative (do you know if there's a debug mode to help troubleshoot that in EHM itself?))
Stages being correctly called/verified, and making sure teams will be assigned from previous stage. Dotting the i's and crossing the t's
Warnings on some common areas misconfigured areas

2. Some of these function one way at the moment, not all work importing, but some of the spreadsheets that would be helpful to be able to import/export:
- Names (first, second)
- Awards
- Financial Info
- Transfer rules

Names - This can be done in a bit of an indirect way already. You can import players/staff with the names you want to add to the database and then immediately retire those players/staff. This will get the names into the database and delete the temporary players/staff. Editor v2.x handles names very differently and allows us to import/export/add/delete names more easily.

I know this trick, I was just wondering there would be a way to seed it with just the names without the players. I've been building a fairly comprehensive name generator expanded upon the existing databases, and adding hundreds of names for the non-regular hockey countries.

Awards - I can put this on my list for v0.x/1.x.

Financial info / transfer rules - I will see if I can do this for v2.x. It might be a bit of a push for v0.x/1.x.

Thanks, that'd be great! Definitely let me know if you need any testers for that. I'd be happy to play around.

3. Not sure if it's a bug, haven't done extensive testing, but in import/export of National teams, cannot edit separately edit U20 and National Team without it editing both. Ex. Exporting and re-importing Serbia U20.and Senior team overwrites same info from spreadsheet to both.

Well spotted! I haven't looked at this but I know exactly what the issue will be. I'll fix this for the next release.

Great!

4. Some sort of rough in editor guide to what CA/PA matches with what reputation for leagues. ex. Creating a -7 PA, 95 CA would likely sign/wouldn't sign with a team of x reputation or a league of Y reputation. Trying to fill out some mid level leagues, I'd like to make sure the appropriate players are available.

This is a very interesting idea and could definitely be added. If we could figure out some sort of approximate formula then this would be very doable. xECK29x is this something you have ever thought about?

Also great, or if there's some where to put some of that information or formulas, that'd be great as well, I've been playing around with a pretty modified prospect generator and randomly trying different combos and seeing where players end up.

5. In app searching for players at a certain NHL draft age, not just year but by date. Ex Players born between 15.9.2005 and 14.9.2006 are elible for the 2024 draft, to be able to search specifically by 2024.

This is possibly a bit of a push for v0.x/1.x just because of the way in which filtering works in the Editor. The volume of filters in the Editor has really slowed it down. Things are better in Editor v2.x which doesn't have the same limitation and in fact allows basically any field to be filtered. I'll need to figure out a simple way of how this could be filtered in Editor v2.x because Europeans are eligible for multiple draft years, so that will make things a bit complex - but I'll see what I can do.

Awesome, I've been doing a lot of exporting and writing custom formulas in Excel to filter as needed, but would be great to be able to look in editor, and have a rough idea/counts would be great.

6. Search counters (quick stats from searches). From the search a quick status of how many returned, how many with contracts, and nation list with count.

I'll see if I can get this into the next release.

7. Open / re-opening different databases without needing to close and reopen.

I'm afraid this simply isn't possible for Editor v0.x/1.x because of the way in which the data is loaded in the Editor. I'm hoping it will be possible in Editor v2.x because I've specifically had this in mind when redesigning it. I won't be able to test this out for a while yet (I haven't yet worked on processing playable leagues) but I'm hopeful this should be possible.

No worries, I can definitely make due, definitely not a deal breaker or high priority, just something I thought would ease workflow.

Thanks again for everything! I hope I'm not sounding demanding, but just adding a few other suggestions and wishlists
In editor:
Team list from Club Competition screen (* more importance on playable leagues, but non-playable would be nice, too, this might be two separate features):
A tab within the club competitions (readonly if need be), that shows the teams either assigned via database, and for playable leagues, teams that would be pulled via the team picking rules
Would be helpful for all kinds of leagues, but specifically domestic junior/regular leagues.
For international competitions it would be nice to click World Championships, click a team tab, and know which teams would be pulled according to the current rules (Basic List, By Conference, Basecomp, Reputation, Finish from the initial launch of the game.) I know some of the playable leagues might be complicated with the team picking rules, so at the very least, clicking a club competition and seeing what teams are assigned from a main tab

Things that would be nice on the importing side.
For clubs, club competitions, nations, etc. - Colour schemes from various databases are a bit mismatched.I know the editor gives errors, but wondering if we could have a warning, and auto-fill some of the colours with a default colour set if there are any issues, so the rest of the data can go in.

Cities - Importing from either Player sheets, Club Wondering if mismatched cities could just get added to the database automatically (similar to how the first name/last names are added when you import players, adding cities like this or having the option to would be nice. (i see a smart update "add missing cities", not sure if that's supposed to be this feature, but incorrect cities still show up/get excluded when running player imports).

Combining a few steps: Club Creation involves making sure the city exists, making sure appropriate arenas or practice facilities exist, and the colour issue from above. Wondering if we could have a club creation option from the same spreadsheet, If values are left empty to automate:
1. adds the city to the nation if it doesn't exist, 0 values can be added to the longitude/latitude and attraction. Once they are in the database it'll be easier to export and edit.
2. add default named arenas and practice facilities for teams. If the value doesn't exist, add it to the arena table with the city from the city field (or the one created in that field). Seating/quality can be random or based on reputation if entered.
Fictional example (with all fields filled out correctly except City, Arena, Practice Facility)
Team: Gotham Dark Knights
Nation: United States
City: Gotham:NY:US
Arena: Batman Arena (If left blank, it would create a deault name based on the city, like "Gotham Rink" or something like that.
Practice: The Bat Cave
Having the option to create the city/arena/practice facilities from the data there would be extremely helpful.

Immensely appreciate your work on this, definitely none of these are NEEDS, but just giving my feedback!

Anyways those are just a few of my thoughts, happy to test or answer any additional questions if things aren't clear.