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

[archibalduk]

1. I cannot replicate this issue. Can you describe step by step how to replicate?

2. Yes. I'm doing this from memory but you should enter the player name and DOB along with the season, team, league and playoff (Y/N) of the entry in question. Then enter 0 (zero) in the GP column. The entry should then be deleted when you save the DB.

1) Easy, just click the Staff Filter -> Enable player filter -> Rights held by (any club in NHL) -> Uncheck filter -> Search for any non-player and none should appear, just tested on 0.3.4.

2) Thanks!

Thanks. It's because the Enable Player Filter check-box is still checked even though no player filters are selected (unchecking it fixes it). I'll see what I can do. I was hoping to do it this weekend but I got distracted by the Extraliga.

[xECK29x]

Thanks. It's because the Enable Player Filter check-box is still checked even though no player filters are selected (unchecking it fixes it). I'll see what I can do. I was hoping to do it this weekend but I got distracted by the Extraliga.

No rush!

[archibalduk]

A new version of the Editor is now available (v0.3.5): https://www.ehmtheblueline.com/forums/v ... 48&t=16014

This is essentially a hotfix and features just two changes:

New Features:

• Added Playable League Dates spreadsheet export via File -> Export Spreadsheet.

Fixes and Improvements:

• Fixed bug on the Staff filter screen which would cause players or non-players to be filtered out when no non-player or player specific filters were enabled.

I'm hoping the Playable League Dates spreadsheet might help with debugging some of these in-game crashes. The spreadsheet will generate a list of all stages of each playable league in the database (i.e. every league from the Rules & Structures screen). The data it shows for each stage depends on whether the stage is a league stage or a cup stage. A league stage is shown as a single row whereas cup stages are listed round by round.

I have set out below a brief summary of what detail is shown. This isn't 100% perfect but it should hopefully help when we get date-related crashes. For instance, xECK29x recently mentioned a crash on 22 March 2020. You could then filter out the Draw Dates and End Dates (Columns H and J) in the spreadsheet (and possibly also the Start Dates) to see what might relate to 21-23 March 2020. For example, the first round of the SHL playoffs finishes on 21 March 2020.

It is important to note that there is a one day margin of error in the spreadsheet and in the Editor where the schedule date in question falls on a leap year. When you look at the Schedule Dates in the Editor, you will see that it allows you to set the Day & Month along with the Year Offset. The database actually stores the Day and Month simply as a Day Number (e.g. 0 = 1st day of the year aka 1 January; 1 = 2nd day of the year aka 2 January; etc) - the Editor shows this as Day & Month so that it is easy to understand. What I hadn't appreciated until now is that if the year on which the date falls is a leap year (such as 2020) then there is a one day margin for error because the 60th day of the year will fall on 29 February on a leap year and on 1 March on a non-leap year. So you will find that dates are one year out in game in comparison to the Editor/spreadsheet. Hence it is worth assuming that dates listed in the spreadsheet for any leap year have a one day margin of error.

League Stages
Stage No: Stage number of the league stage.
Start Date: The date on which the first league game is played.
End Date: The date on which the final league game is played.

Note: Certain league stages do not have any schedule dates (e.g. the various additional simultaneous initial stages where a schedule template is used) and therefore the State Date and End Dates will be blank.


Cup Stages
Stage No: Stage number of the cup round.
Round: Round number of cup round.
Start Date: The date on which the first game of the cup round is played.
End Date: The date on which the first game of the cup round is played.


Additional Columns
Last Stage: No: This is the "Stage to Draw Teams" setting from the Editor. In other words, this shows the stage number from which the current stage draws its teams (the "Last Stage").
Last Stage: End Date: This is the date on which the Last Stage finishes. This is useful because you can compare it with the Draw Date of the current stage.
Last Stage: Date Clash: The Draw Date of the current stage should occur on either the end date of the Last Stage or any time afterwards. If it does not then it will state "_ERROR_" in this column. It's worth noting that this isn't 100% reliable because if the preceding stage does not have any dates (such as certain league stages) then there is nothing to compare against. Also, it doesn't take into account third/fourth place cup rounds because it will compare against the end date of the final rather than the semi finals. So you might see some errors listed because of the fact there is a third/fourth place cup game (which you can safely ignore).

[xECK29x]

Thanks Archi!

[xECK29x]

Feature request:
Import sheets for Club Records and Player Records, if possible .

[xECK29x]

Another one, need warning/errors messages for invalid club affiliations (inactive). Debugging save games has shown this will cause a crash.

[Warhorse]

When searching for a player in a saved game, is there any way to use a wildcard character like * or ? to replace the non-standard characters in a player's name? eg H?gberg or H*gberg vs Hogberg with an umlaut over the o?

[Javs]

Every time I open a database and click on any league under 'rules & structure' the editor crashes. (.35 and .34 versions)

[archibalduk]

When searching for a player in a saved game, is there any way to use a wildcard character like * or ? to replace the non-standard characters in a player's name? eg H?gberg or H*gberg vs Hogberg with an umlaut over the o?

No I'm afraid I removed that function because it slows down the Editor substantially. I will consider if I can add something to this effect (at least as an option) in the version 2.x of the Editor which I'm working on at the moment.

Every time I open a database and click on any league under 'rules & structure' the editor crashes. (.35 and .34 versions)

Which database are you trying to edit? Is it one you downloaded and have not edited yet or is it one you have already edited? Does it crash if you try viewing the Finance Info, Schedule Templates or Ruling Bodies screens?

1. Open the database;
2. Click on the Print Diagnostic Details button below the Editor Log (on the Home Screen); and
3. Copy and paste the contents of the Editor Log into this thread. Feel free to censor the folder names in the Log if you like (e.g. if they refer to your name, etc).

I cannot promise to fix the issue as it is not something that has ever been reported, but the Log might give me an idea.

[xECK29x]

Please add a filter for National Team Contract under the Staff Filters

[Javs]

Which database are you trying to edit? Is it one you downloaded and have not edited yet or is it one you have already edited? Does it crash if you try viewing the Finance Info, Schedule Templates or Ruling Bodies screens?

1. Open the database;
2. Click on the Print Diagnostic Details button below the Editor Log (on the Home Screen); and
3. Copy and paste the contents of the Editor Log into this thread. Feel free to censor the folder names in the Log if you like (e.g. if they refer to your name, etc).

I cannot promise to fix the issue as it is not something that has ever been reported, but the Log might give me an id

I have tried the newest TBL rosters and the default. It only crashes under Rules & Structure. See info below:

================== Editing session started: Monday 30 December 2019 ==================

20:55:08: Read database C:/Program Files (x86)/Steam/steamapps/common/Eastside Hockey Manager/data/database/Javs/database.db
20:55:08: Format Database
20:55:08: Mode EHM 1013/1025
20:55:08: Format Database
20:55:08: Mode EHM 1013/1025
20:55:08: Version 1025
20:55:08: Game Basic Data 0 - 12
20:55:08: Database Header 13 - 103
20:55:08: Version 1025
20:55:08: Continents 104 - 503
20:55:08: Nations 504 - 40202
20:55:08: Cities 40203 - 689480
20:55:08: States 689481 - 692536
20:55:08: Arenas 692537 - 924294
20:55:08: Colours 924295 - 928346
20:55:09: Clubs 928347 - 8727624
20:55:09: Affiliations 8727625 - 8771918
20:55:09: Retired Numbers 8771919 - 8801683
20:55:09: Staff 8801684 - 13771857
20:55:09: Staff Preferences 13771858 - 15856127
20:55:09: Non Players 15856128 - 16179323
20:55:09: Players 16179324 - 18493867
20:55:10: Staff History 18493868 - 28116889
20:55:10: Club Competitions 28116890 - 28360529
20:55:10: Club Competition History 28360530 - 28469495
20:55:10: Staff Awards 28469496 - 28569313
20:55:10: Staff Award History 28569314 - 28900035
20:55:10: Officials 28900036 - 28930665
20:55:10: First Names 28930666 - 29433480
20:55:10: Second Names 29433481 - 31447825
20:55:10: Injuries 31447826 - 31453332
20:55:10: Currencies 31453333 - 31455844
20:55:10: Stage Names 31455845 - 31464616
20:55:10: Drafted Players 31464617 - 31764076
20:55:10: Drafts 31764077 - 31764660
20:55:10: Player Rights 31764661 - 31838346
20:55:10: Club History 31838347 - 32222254
20:55:10: Club Records 32222255 - 37444474
20:55:10: Player Info 37444475 - 38871250
20:55:10: Staff Info 38871251 - 39686068
20:55:10: Comp Basic Rules 39686069 - 39839169
20:55:10: Comp Ruling Body 39839170 - 39840755
20:55:10: Comp Transfer Rules 39840756 - 39855496
20:55:10: Finance Info 39855497 - 39858526
20:55:10: Schedule 39858527 - 40089354
20:55:10: End of file 40089355 - 40092676
20:55:11: Roster status OK
20:55:11: Result Success
20:55:11: Initialising editor screens...
20:55:21: Elapsed 12.539 secs
================== Application ==================
EHM Editor version: 0.3.5
================== Display ==================
Screen resolution (actual): 1920 x 1080
Screen resolution (scaled): 1920 x 1080
Screen scaling: 1
Dots per inch: 166 x 166
================== System Environment ==================
System: Windows 10 (10.0)
Kernel: 10.0.17763
Architecture: x86_64
Qt runtime: 5.13.0
================== Build ==================
Build kernal: winnt
Build system: x86_64-little_endian-llp64 (x86_64)
Build date: 12/11/2019
Build time: 15:22:20.59
Qt build: 5.13.0
MSVC++: 1916
================== Locale ==================
Name: en_CA
Country: Canada
Language: English
Date format: MMMM d, yyyy
Decimal point: .
Delimiter: Comma

[trailerman1978]

As stated above I'm a newbie to EHM. Been playing for 2 weeks with the standard 1.4.1 game, no ad-ons nothing. Just found out there is an editor and downloaded it as after reading it, it seemed easy to do! But I think I've made a mess and have all these files on my computer and when I open the editor I can find any files. I've since erased the editor and files to start from scratch.

Anyone with a bit a patience in teaching me the in/outs of using the editor would be greatly needed on my part. I'm kinda a half ass bad computer kinda guy. I figured it would be as easy as FM editor and assumed wrong, thus I can't seem to do anything right with this editor and I am fearful of messing something up real bad. Bad question but do they have a "EHM editor use for dummies" book I can find so I don't kill my computer or set of nuclear weapons within the game itself?

Thanks in advance,

Cowboy

[Javs]

Update on my problem: tried downloading the editor, all different databases, and re-downloaded the Redistributable files... nothing seems to work.

[trailerman1978]

Update on my problem: tried downloading the editor, all different databases, and re-downloaded the Redistributable files... nothing seems to work.

I seem to be having the same problem... I'm wondering if I can just rebuild every league and competition I want from scratch, without destroying the game?

[archibalduk]

Update on my problem: tried downloading the editor, all different databases, and re-downloaded the Redistributable files... nothing seems to work.

I seem to be having the same problem... I'm wondering if I can just rebuild every league and competition I want from scratch, without destroying the game?

Update on my problem: tried downloading the editor, all different databases, and re-downloaded the Redistributable files... nothing seems to work.

Sorry for the delay in responding. Work is just hideous at the moment.

Thanks so much for posting the log file. There is nothing obvious which points to the source of the issue. The log shows that you loaded the DB successfully and that, on the face of it, you're running it with the correct DLLs and on Windows 10 64-bit. I'm at a loss as to why both you and trailerman1978 are encountering this issue as it is not something which has been reported in the few years that the Editor has been developed. I suspect that this is a system compatibility issue but it's hard to debug without trying to build and run my source code on your systems. I will see if I can add some sort of additional error logging/messaging to try and pinpoint what the issue might be.

[archibalduk]

Please add a filter for National Team Contract under the Staff Filters

No problem. I'll add it to the upcoming release.

[archibalduk]

As stated above I'm a newbie to EHM. Been playing for 2 weeks with the standard 1.4.1 game, no ad-ons nothing. Just found out there is an editor and downloaded it as after reading it, it seemed easy to do! But I think I've made a mess and have all these files on my computer and when I open the editor I can find any files. I've since erased the editor and files to start from scratch.

Anyone with a bit a patience in teaching me the in/outs of using the editor would be greatly needed on my part. I'm kinda a half ass bad computer kinda guy. I figured it would be as easy as FM editor and assumed wrong, thus I can't seem to do anything right with this editor and I am fearful of messing something up real bad. Bad question but do they have a "EHM editor use for dummies" book I can find so I don't kill my computer or set of nuclear weapons within the game itself?

Thanks in advance,

Cowboy

I'm actually working on a brand new version of the Editor which I am trying to make as user friendly as possible. With hindsight, the current Editor could have been structured in a way which would have made it more accessible to everybody. It's a lot of work but I have made good progress and would hope to have something released before the end of 2020. I would really like to get a proper manual or set of tutorials together once the new Editor is in good shape. I have written a few tutorials so far HERE and HERE but they're possibly not much use to you.

To get started, I would suggest saving a copy of your database to somewhere like a sub-folder of your Desktop so that you can work on it without affecting any databases you have subscribed to in Steam (which will in any event be overwritten as and when a new version of the database is pushed by the author via Steam). You will find your Steam subscription folder here: https://www.ehmtheblueline.com/forums/v ... 16#p225184

The database file consists of a "database.db" file along with a couple of .cfg files. It is the database.db file that you will want to open in the Editor. Once you have finished making your changes and want to try your database, you will need to create a new sub-folder in your <<EHM Installation Folder>>\data\database\ folder. You can call your sub-folder whatever you like (e.g. "Cowboy Database"). Then put your database.db and .cfg files in your sub-folder. Typically you will find your EHM installation folder here: C:\Program Files (x86)\Steam\steamapps\common\Eastside Hockey Manager\data\database but otherwise see here: https://ehmtheblueline.com/wiki/index.p ... ion_Folder

When you load EHM to start a new game, you will find your database in the list of databases to select from. The database will be named whatever your named your sub-folder (e.g. "Cowboy Database").

As for the Editor, you should extract the zip file containing the Editor and DLLs to a folder of your choice. Then just load the "EHM Editor.exe" file. One the Editor has loaded, click on Open Database and select the database.db file you want to edit. 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.

Changing any other parts of the DB simply click on the appropriate tab. If you're looking to add another playable league or move teams between leagues then you will need to read the tutorials I linked to above. If you're just looking to change colours/names/etc of a club or league then you can just change them without any issue.

Once you're done editing, click on Save and then copy over the database.db and .cfg files to EHM as I mentioned above.

[xECK29x]

Small thing, but editing dates under National Team Contract, requires you to hit tab in order for the values to stick

[trailerman1978]

I'm actually working on a brand new version of the Editor which I am trying to make as user friendly as possible. With hindsight, the current Editor could have been structured in a way which would have made it more accessible to everybody. It's a lot of work but I have made good progress and would hope to have something released before the end of 2020. I would really like to get a proper manual or set of tutorials together once the new Editor is in good shape. I have written a few tutorials so far HERE and HERE but they're possibly not much use to you.

To get started, I would suggest saving a copy of your database to somewhere like a sub-folder of your Desktop so that you can work on it without affecting any databases you have subscribed to in Steam (which will in any event be overwritten as and when a new version of the database is pushed by the author via Steam). You will find your Steam subscription folder here: https://www.ehmtheblueline.com/forums/v ... 16#p225184

The database file consists of a "database.db" file along with a couple of .cfg files. It is the database.db file that you will want to open in the Editor. Once you have finished making your changes and want to try your database, you will need to create a new sub-folder in your <<EHM Installation Folder>>\data\database\ folder. You can call your sub-folder whatever you like (e.g. "Cowboy Database"). Then put your database.db and .cfg files in your sub-folder. Typically you will find your EHM installation folder here: C:\Program Files (x86)\Steam\steamapps\common\Eastside Hockey Manager\data\database but otherwise see here: https://ehmtheblueline.com/wiki/index.p ... ion_Folder

When you load EHM to start a new game, you will find your database in the list of databases to select from. The database will be named whatever your named your sub-folder (e.g. "Cowboy Database").

As for the Editor, you should extract the zip file containing the Editor and DLLs to a folder of your choice. Then just load the "EHM Editor.exe" file. One the Editor has loaded, click on Open Database and select the database.db file you want to edit. 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.

Changing any other parts of the DB simply click on the appropriate tab. If you're looking to add another playable league or move teams between leagues then you will need to read the tutorials I linked to above. If you're just looking to change colours/names/etc of a club or league then you can just change them without any issue.

Once you're done editing, click on Save and then copy over the database.db and .cfg files to EHM as I mentioned above.

Thank you so much... I'm gonna give it a shot following your step by step instructions. I don't mind putting in the work for a passion. I spent 6 months using the editor in FM19 to open up every league while keeping player content at 150000 so my computer could handle it. It took a few months of learning and a patient teacher, but my guy was cool and patient and taught me everything via hosting. I love learning something new and to make a DB that brings out the best in something is worth it to me. I will look forward to your new editor via near the end of 2020, but I think with a bit of good coaching I can get this current one down...

Many thanks for the continued response,

Cowboy

[xECK29x]

We want to start adding retired staff to the DB to make historical records accurate. Is it possible to alter the behavior of the Database Validation task for Staff data into two separate items: 1) cleanup 'Retired' staff as an on/off switch and 2) Remove 'Invalid' classifications?

I would like the flexibility to still keep the DB clean but keep retired players/staff going forward.

[trailerman1978]

Still getting this message when trying to use the editor!

Every file is empty, no comps, no players, no nothing!

Code: Select all

18:00:45: Read database C:/Users/Joel/Documents/Sports Interactive/EHM/add_ons/add_ons.db
18:00:45: Format Database
18:00:45: Mode EHM 1013/1025
18:00:45: Format Database
18:00:45: Mode EHM 1013/1025
18:00:45: Version 1025
18:00:45: Game Basic Data 0 - 12
18:00:45: Database Header 13 - 12
18:00:45: Version 0
18:00:45: Continents 13 - 12
18:00:45: Nations 13 - 12
18:00:45: Cities 13 - 12
18:00:45: States 13 - 12
18:00:45: Arenas 13 - 12
18:00:45: Colours 13 - 12
18:00:45: Clubs 13 - 12
18:00:45: Affiliations 13 - 12
18:00:45: Retired Numbers 13 - 12
18:00:45: Staff 13 - 12
18:00:45: Staff Preferences 13 - 12
18:00:45: Non Players 13 - 12
18:00:45: Players 13 - 12
18:00:45: Staff History 13 - 12
18:00:45: Club Competitions 13 - 12
18:00:45: Club Competition History 13 - 12
18:00:45: Staff Awards 13 - 12
18:00:45: Staff Award History 13 - 12
18:00:45: Officials 13 - 12
18:00:45: First Names 13 - 12
18:00:45: Second Names 13 - 12
18:00:45: Injuries 13 - 12
18:00:45: Currencies 13 - 12
18:00:45: Stage Names 13 - 12
18:00:45: Drafted Players 13 - 12
18:00:45: Drafts 13 - 12
18:00:45: Player Rights 13 - 12
18:00:45: Club History 13 - 12
18:00:45: Club Records 13 - 12
18:00:45: Player Info 13 - 12
18:00:45: Staff Info 13 - 12
18:00:45: Comp Basic Rules 13 - 12
18:00:45: Comp Ruling Body 13 - 12
18:00:45: Comp Transfer Rules 13 - 12
18:00:45: Finance Info 13 - 12
18:00:45: Schedule 13 - 12
18:00:45: End of file 13 - 12
18:00:45: Roster status OK
18:00:45: Result Success
18:00:45: Initialising editor screens...
18:00:47: Elapsed 2.086 secs

Archie there is no as you've stated database.db...

I get add_on.db only! Have I destroyed the world by pressing the nuke button accidentally?

[trailerman1978]

archibalduk


I found a way to get a database based on 2016 by loading a new saved game saving it to a database! Will that work? it seems too as it loads a bunch of workable data!

If this is a good way to go I then need to know how to download it to my game interface to test it. A good step by step or video could help... I've already made some changes to the database Opening up Italy moving clubs into the leagues there and adding a few teams! Hopefully all I've done is not for not!

Thanks,

Cowboy

[archibalduk]

Still getting this message when trying to use the editor!

Every file is empty, no comps, no players, no nothing!

You are trying to open a blank file which is why you're getting the error.

Archie there is no as you've stated database.db...

I get add_on.db only! Have I destroyed the world by pressing the nuke button accidentally?

The add_on.db file must have come from somewhere!... Presumably you have created that file as a blank file in Windows or renamed an existing file.

I found a way to get a database based on 2016 by loading a new saved game saving it to a database! Will that work? it seems too as it loads a bunch of workable data!

No this will not work. You will find that a lot of data is missing (such as player career histories) and all player attributes will be scrambled. You need to take a copy of an existing database and make your edits to that. You could for example take a copy of last season's Pivot Rosters or a copy of a database you have subscribed to in the Steam Workshop.

If this is a good way to go I then need to know how to download it to my game interface to test it.

You can follow my instructions here on how to get the database in EHM: https://www.ehmtheblueline.com/forums/v ... 92#p241892

A good step by step or video could help... I've already made some changes to the database Opening up Italy moving clubs into the leagues there and adding a few teams! Hopefully all I've done is not for not!

I'm not aware of any videos but you could try searching on Youtube. There are a few step-by-steps here but I suspect they don't cover what you're looking for: https://www.ehmtheblueline.com/forums/v ... 10&t=18124

[trailerman1978]

archibalduk

Ok so I've Subscribed to Ecks newest rosters starting 2019-2020!

I can load up a game and turn it into a database, then make my changes to it?

The data should be up to date as it's his latest and was down loaded through steam.

Thanks,

Cowboy

[archibalduk]

I can load up a game and turn it into a database, then make my changes to it?

Like I say, you cannot convert a saved game into a database. You need to make a copy of his database and then edit that copy. See here and here.