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

[archibalduk]

Version 1.0.0 of the Editor is now available here: https://www.ehmtheblueline.com/editor

This is the first release with the additional v1.5 database setting screens visible. The new screens/sections introduced with the EHM v1.5 database format are as follows:

1. Contract Details
It is now possible to add detailed contract data to players, such as year by year salaries and contract clauses. The database format also allows bonuses to be added but, as far as I'm aware, bonuses have not yet been implemented in the game.

To add detailed contract details, click on the Set Player Contract Details button on the Player screen. This will then enable the Contract Details tab. You can delete the Contract Details by clicking on the Delete All Contract Details button on the Contract Details -> Salary tab. Note that you do not need to click on the Set Player Contract Details button each time you want to access the Contract Details tab - you just need to click on it in order to enable the tab if it is disabled.










2. Historical Club Names
This allows historical/old club names to be added which will then appear for player career histories. The screen is accessible via the Clubs menu.




3. Game Extra Details
Additional settings have been added to the Database Settings screen which is accessible via the Data tab. The additional settings are listed under the Game Extra Details tab and should be useful for historical databases.




LEAGUE RULES AND STRUCTURES
Whilst not new to the v1.5 database, another new feature in the Editor is a structure chart available via the Chart tab when viewing Rules and Structures. The chart is still in its early stages and doesn't do much more than visualise how the stages connect together. I'm hoping to add some additional details such as start and end dates and stage names. I will also add a legend to explain the colour scheme - but for now, the colour scheme is blue = initial stage, green = upper stage and red = lower stage.

I've also added some additional league validation rules which are accessible via the Status tab of the Rules and Structures screen. Further details can be found here. I should highlight that the validation rules are still a work in progress and I would advise against blindly following the warnings shown on this screen. If your league is already running fine then you may want to consider ignoring any warnings.






VERSION NUMBERING
I have now moved away from the old version numbering scheme of 0.x.y where I'd simply increment y and then x (e.g. 0.4.9, 0.5.0, 0.5.1, etc) to using 1.minor.patch using semantic versioning. This means that each subsequent version number will depend on whether the release is a minor release or just a patch release.


CHANGELIST: VERSION 1.0.0 (23-April-2021)

New Features:

• Added a structure chart sub-screen to the Rules and Structure screen (this is a work in progress);
• Added ability to refresh synonym data via File -> Refresh Synonyms;
• Added Contract Details editing via the People -> Players and Staff screen (version 1.5 database format);
• Added Extra Rule settings #163-181 from game version 1.5 (version 1.5 database format);
• Added Game Extra Data to the Data -> Database Settings screen (version 1.5 database format);
• Added Historical Club Names editing screen (via the Clubs tab) for adding historical club names for player career histories (data can also be imported/exported via the Import buttons at the foot of the screen) (version 1.5 database format);
• Added League Sort Rule #12 (regulation wins only) (version 1.5 database format); and
• The 'Always save databases using the latest EHM version' setting is now automatically enabled when upgrading from any version of the Editor prior to v1.0.0 (this can be overridden in the Settings screen.

Fixes and Improvements:

• Added a setting on the Import Spreadsheet screen which allows synonym settings to be saved across Editor sessions;
• Added additional validation rules to the Rules & Structures screen - see HERE for further details;
• Added support for curly quotation marks when removing "A" and "C" suffixes from club names when importing player career history;
• Comments and blank lines can now be added to synonym files. Comment lines are added by placing two forward slashes at the front of the comment line (e.g. "// This is a comment");
• Fixed issue with Financial Power being corrupted when importing a Nations spreadsheet;
• Fixed issue with League Standard not being updated when importing a Nations spreadsheet;
• Increased the width of the Reputation fields on the Nations screen;
• Minor adjustment to the Alternative Schedule Dates data structure in order to fix a potential crash when saving the database;
• Minor improvements to the dates specified in the Rules and Structures text report which now take into account the final potential date for a cup stage schedule date; and
• Minor optimisations to various functions/classes.

[xECK29x]

Thanks Archi! Small thing, looks like the new PA ranges aren't supported?

[archibalduk]

Urgh! Let me check and I can release a hotfix tomorrow morning.

[archibalduk]

Thanks Archi! Small thing, looks like the new PA ranges aren't supported?

This is now fixed (v1.0.1): https://www.ehmtheblueline.com/editor

[xECK29x]

Found a crash condition, attempting to Add (copy) the league structure for the World Cup causes a CTD.

[archibalduk]

Thanks - I'll take a look

[BulldogsFan]

Hey Archi

I was just wondering i don't know if this can be done but if we add teams into the editor is there a way to add something where it auto populates a schedule in the editor or no? So lets say you add 3-4 teams to a league instead of trying to add the teams into the schedule you hit the button and it auto populates the schedule?

[archibalduk]

Incorrect salaries. Note the ID at the bottom of the screen shot.

To fix: I found the Financial ID =1, the Polska Hokej Liga duplicate record. Since another already existed, I just copied all the settings from the NHL into the Financial ID = 1. Changed the League to New NHL and Nation to USA. For Financial ID=69, I changed League and Nation both to [None]

Loaded the game up, and now the salaries are correct.

As I think you noted in other aspects of the game, I think IDs or ID ranges may be hardcoded for some things, I didn't test other ID's to see which work and which don't, but I have a feeling it's related. I was struggling to get the salaries working in the GUH db in an earlier version, and I have a feeling this is why.

I've taken a look at this and it's a data issue with your broken database. You have two entries in the Financial Rules section for the Polska Hokej Liga and the game doesn't behave correctly if you have duplicate records. The solution is simply to change one of the Polska Hokej Liga Financial Rules entries to any other league or nation which doesn't already have a Financial Rules entry. For testing purposes, I just changed one of them to Luxembourg and then the salaries appeared correctly for Burns ($8m) and Balcers ($0.735m) in the New San Jose team.

I'll put deleting Financial Rules and other playable league tables on my to-do list for the next release along with a validation rule to check for duplicates [***NOTE TO SELF***].

xECK29x - do you have any objection to the Editor auto-deleting Financial Rules, Transfer Rules, etc if they are set as [None]?

[xECK29x]

xECK29x - do you have any objection to the Editor auto-deleting Financial Rules, Transfer Rules, etc if they are set as [None]?

Not at all, I need to do a cleanup there anyways!

[ideawithoutamind]

I'll put deleting Financial Rules and other playable league tables on my to-do list for the next release along with a validation rule to check for duplicates [***NOTE TO SELF***].

Awesome find! Glad it looks like an easy fix/validation! I believe that DB was built from Pivot5.5,(I just checked 5.6.1, and it has the same duplicate record. )

Just making note for xECK29x as well.

Also curious of that rule also extends to the other club competition sections like Ruling Body, Transfer Rules, etc, may be good to add validation/dupe check for all sections if possible.

[archibalduk]

Hey Archi

I was just wondering i don't know if this can be done but if we add teams into the editor is there a way to add something where it auto populates a schedule in the editor or no? So lets say you add 3-4 teams to a league instead of trying to add the teams into the schedule you hit the button and it auto populates the schedule?

It's actually already possible to an extent. When you're viewing the Schedule Dates table for any stage, you'll see a Generate Dates button in the bottom left. When you're viewing a Schedule Template you'll see a Schedule Generator button in the bottom right hand corner.

[Mgomrjsurf]

I would maybe add a Rule option for DFA,Wavier Trades to and also relocation can happen. Also an Error Message for if Game Exits when starting a new game for no reason can fix Error.
Also in Mass Edit give it a command say like your to create pass/present Drafted by Teams or played on and want to do it fast and that would be the way to do it.

[xECK29x]

Small ask, for Auto Set Pass Tendency can you implement a rule that always sets goaltenders to 15?

[archibalduk]

Sure - will do

[jonathanorjas]

I think I found a bug in the version 1.0.1 of the editor. When I try to add item on the Rules and Structure Tab the editor crashes. I have tried with multiple databases but the result is the same.

[ideawithoutamind]

I think I found a bug in the version 1.0.1 of the editor. When I try to add item on the Rules and Structure Tab the editor crashes. I have tried with multiple databases but the result is the same.

Confirming this in 1.0.1 and 1.0.0. Same results for Add a blank League as well as Copy existing one. I've mostly been working on existing leagues instead of making new ones, so good find!

Work around for now: Open db in 0.5.2 and create the new Rules and Structure League just as a placeholder, then re-open in 1.0.1

[ideawithoutamind]

One thing also, I found the saves don't create the old backup .bak files anymore. Even when rolling saves are have a value.

[archibalduk]

I think I found a bug in the version 1.0.1 of the editor. When I try to add item on the Rules and Structure Tab the editor crashes. I have tried with multiple databases but the result is the same.

Thanks I'll take a look and will try and push an update this weekend if it's an easy fix. I suspect something I tweaked in the structure chart isn't happy with the creation or import of a new league.

One thing also, I found the saves don't create the old backup .bak files anymore. Even when rolling saves are have a value.

Interesting. I haven't touched anything relating to rolling backups. I'll take a look and will try to fix at the same time.

[xECK29x]

One thing also, I found the saves don't create the old backup .bak files anymore. Even when rolling saves are have a value.

Oh good it's not just me, I just noticed it also.

[xECK29x]

Looks like I'm having some issues with the synonym files and special characters, what encoding should be used on the txt files?

Example lines:
Slovak Hokejová Liga,Slovakia2
Mountfield HK Hradec Králové U16,HC Hradec Kralove U16

Solved my own question, adding the BOM fixed it.

[xECK29x]

When adding a historical club name can the default sort be a reverse sort of the ID (so newest stick to the top)? This would make adding them much easier as once you add the league abbreviation you have to find where it ended up in the list.

[archibalduk]

One thing also, I found the saves don't create the old backup .bak files anymore. Even when rolling saves are have a value.

I have checked and rolling saves are working for me. Make sure you have a figure set in the Rolling Saves setting on the Settings screen (if this is set to zero, you won't have any rolling saves). Also check whether you have any other unrelated .bak files in the same folder as your database.db file.

Incidentally, rolling saves will now be saved with a hyphen before the number as the Editor was getting confused when there were other digits in the file name.

When adding a historical club name can the default sort be a reverse sort of the ID (so newest stick to the top)? This would make adding them much easier as once you add the league abbreviation you have to find where it ended up in the list.

Done. I just need to fix the Rules & Structures crash and will then upload the new release.

[ideawithoutamind]

Also check whether you have any other unrelated .bak files in the same folder as your database.db file.

Bingo, that might have been it. I make some of my own .bak files when working and that might have been it. Will come up with my own naming convention for in process projects I'm working on.

Thanks!

[archibalduk]

Here's a hotfix for the League Rules & Structures crash: https://www.ehmtheblueline.com/editor

CHANGELIST: VERSION 1.0.2 (02-May-2021)

Fixes and Improvements:

• Fixed a crash when creating or importing a new Playable League Structure caused by the 'maximum league games' validation rule where no stages are initially present;
• Goalies are now set to 15 Pass Tendency when applying the Auto-Set Pass Tendency mass editor;
• Historical club names are now reverse sorted by ID; and
• Rolling saves are now saved as "database-[xxx].bak" instead of "database[xxx].bak" in order to avoid conflict where the base database.db filename contains digits.

[archibalduk]

I'm strictly a 1.4.1 user, so not sure if this carries over to 1.5 (worth verifying before doing anything extensive troubeshooting to figure it out)

This is using a modified version of PremierPivot 5.5 (I had stripped out a bunch of the playable league rules, and copied the DEL and Germany setup over to a full Brazilian setup mimicking germany, and added Brazilian players (basically copied and renamed from German players)
Figured xECK29x may want to know this as well. I'll ping him on discord after I post this.
Brazilian Ice Hockey League

Let me know if you have any issues accessing it

This is not unique to creating new leagues, as I fiddled around with this when making GUH and got it working, but wondering if there's some behind the scenes things with UID that comes into play. I've tried using the UID validator in other cases, and it usually doesn't make a difference to this behavior

I included both databases, which should be identical in setup. Both leagues run and can sim without any issues. The issue is with the menu navigation.
Brazil BrokenMenu, Brazilian Ice Hockey League = 1246683
Clicking the top Trophy Icon, Brings you to the Overview screen (most working leagues bring you to standings)
On a team page, clicking the BIHL does nothing (other working leagues bring you to standings page)

Brazilian_NewUID, I renamed an existing extinct league (I kept the name and added ID in long name just for quick reference, but that is just cosmetic)= Brazilian Ice Hockey League (11214 - Alpen League)
I updated the teams to point to the new LeagueID and updated the stages, finance, rules, and transfer rules to point to the existing new ID.

Otherwise everything should be configured exactly the same.

Clicking Trophy Icon brings you to standings
Clicking BIHL from team page brings you to standings

The game and sim works fine, just the weird menu issue.

I've been taking a look at this but cannot see anything obvious which would cause this issue. I'll send this to Riz tomorrow in case he is able to diagnose it.

Riz has taken a look at the above issue. It isn't a DB issue but a game-related UI issue which seems to be caused by the sheer volume of leagues in the database. Apparently this might not be an easy fix in the game, so we'll have to just wait and see. Perhaps the solution is to re-order the Club Competitions table in the database by prioritising the lower IDs for playable leagues ([***NOTE TO SELF***])