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

[archibalduk]

Thank you - I'm glad it is of use!

Something random I came across the other day is that you can use an asterisk (*) as a wildcard when using the text search filters. E.g. "new*rangers" will bring up the New York Rangers.

[BKarchitect]

Awesome new feature archi - anybody who edits databases I would think would love this "one-screen editing ability". Can't wait!

[EZJaeger]

The latest version of the Eastside Hockey Manager 1 Database Editor can be downloaded here: http://www.ehmtheblueline.com/editor

Is anyone playing on Mac with a PlayonMac mirror and managed to make this work? this is impossible...
I would like to eliminate the salary cap, since it does not go up or down and my save has a bug where teams are attributed with cap penalties that I don't know how they were aggregated....

[archibalduk]

The latest version of the Eastside Hockey Manager 1 Database Editor can be downloaded here: http://www.ehmtheblueline.com/editor

Is anyone playing on Mac with a PlayonMac mirror and managed to make this work? this is impossible...

I read on Reddit that somebody had gotten it running on the Mac (with PlayonMac IIRC). I have been trying to get OS X up and running using Virtual Box but it is prone to crashing and I'm struggling to get the compiler running. I'll try it again in the coming weeks. If I can get it to work then I may be able to compile a Mac version of the Editor. It's a big IF.

I would like to eliminate the salary cap, since it does not go up or down and my save has a bug where teams are attributed with cap penalties that I don't know how they were aggregated....

Editing saved games is highly risky and usually ends with irreparable corruption. Try editing the "transfer_rules_config.cfg" file which accompanies the database. You can edit this in any text editor.

[EZJaeger]

Hi Archi,

the problem that I have is that If the roster update is a subscription from steam workshop e.g. TBL 10.1, I cannot find the appropriate database config file in the "database" folder.

[archibalduk]

There's a guide here: viewtopic.php?f=13&t=17841&p=224816#p225184

[EZJaeger]

Thank you. Followed the instructions and changed the cap value but there were no changes. Is there a higher salary cap value limit to input or shall I just change the value to 0?

[Primis]

Haha! There were a lot of changes between the September 2017 version and the current version, so it should be a nice surprise features-wise!

It is, in fact. It is very different. You're doing great work here, Archi.

With the Staff filters, can you add an option to filter by PA/CA eventually? Thanks.

[nino33]

Am I correct in thinking I can use the Editor to add a single player to the database? i.e. I can add players manually one at a time rather than using a spreadsheet?

To do so do I click on "Add Item" on the Players & Staff screen?

[Manimal]

Am I correct in thinking I can use the Editor to add a single player to the database? i.e. I can add players manually one at a time rather than using a spreadsheet?

To do so do I click on "Add Item" on the Players & Staff screen?

Yes

[nino33]

Am I correct in thinking I can use the Editor to add a single player to the database? i.e. I can add players manually one at a time rather than using a spreadsheet?

To do so do I click on "Add Item" on the Players & Staff screen?

Yes

Thanks!

[archibalduk]

Haha! There were a lot of changes between the September 2017 version and the current version, so it should be a nice surprise features-wise!

It is, in fact. It is very different. You're doing great work here, Archi.

With the Staff filters, can you add an option to filter by PA/CA eventually? Thanks.

That's the long term plan. It's a little more complex than the existing filters because it involves pulling data from three tables (i.e. the basic staff data table, the player attributes table and the non-player attributes table). I need to give it some thought because the filtering needs to be as efficient as possible when filtering all of that data given the volume of staff data present. As you will see, filtering the staff data is already a bit slow (and that's filtering against just the staff data table).

Am I correct in thinking I can use the Editor to add a single player to the database? i.e. I can add players manually one at a time rather than using a spreadsheet?

To do so do I click on "Add Item" on the Players & Staff screen?

I am working on the buttons/menus running along the lower edge of the screen at the moment (needs some tidying up IMO) - I'll try and make that button a little more obvious (e.g. "Add New Person" instead of "Add New Item", etc).

[nino33]

I'm getting a crash of the Editor while working on the 74DB
If I click on the Kingston Canadians team on the Clubs tab the Editor crashes

Also, in looking into it I noticed a few team names on the Clubs tab list were highlighted in yellow!
I figured the yellow highlight was to highlight an error issue; I found that entering the "Nation" got rid of the yellow (IIRC it had been None -1)

[archibalduk]

Could you email a copy of your current DB to me please? I will take a look at the crash.

That's right - the Editor will highlight in yellow if an active team does not have a nation or Reputation set. The game will crash if a team on a playable league has no nation or a Reputation of zero. I don't think this will be an issue with the next version of the game however (but it seems to make sense to ensure these are set for playable teams anyhow).

P.s. I'll get back to you this week on your previous email.

[nino33]

Could you email a copy of your current DB to me please? I will take a look at the crash.

DB emailed/thanks

That's right - the Editor will highlight in yellow if an active team does not have a nation or Reputation set. The game will crash if a team on a playable league has no nation or a Reputation of zero. I don't think this will be an issue with the next version of the game however (but it seems to make sense to ensure these are set for playable teams anyhow).

I thought it was pretty cool!

[lucamo99]

What can I do to see the text on the left? https://imgur.com/a/NoBN9

[Dadonov]

I have absolutely no idea how to use the editor, the main thing I want to do is be able to change prospect's potential, but when I see a player has a potential of: -15, I have no idea what that means, and what to change it to. Say I want to make some random prospect like Ivan Chukarov a future superstar and give him the best possible potential, how would I go about doing that?

[archibalduk]

What can I do to see the text on the left? https://imgur.com/a/NoBN9

What screen resolution are you using? It looks like the screen size is too small for the Editor.

I have absolutely no idea how to use the editor, the main thing I want to do is be able to change prospect's potential, but when I see a player has a potential of: -15, I have no idea what that means, and what to change it to. Say I want to make some random prospect like Ivan Chukarov a future superstar and give him the best possible potential, how would I go about doing that?

The negative Potential Ability ratings mean that the game will randomly generate a Potential Ability for each saved game within a certain range.

See here: viewtopic.php?p=6795#p6795

[lucamo99]

I use a 1920 x 1080 screen, I have a laptop 13' is it normal or my settings are wrong?

[archibalduk]

That resolution should be plenty large enough. Given the size of your screen, I suspect you have the scaling setting up pretty high and this would result in the issue you're seeing.

Right click on your desktop and click on Display Settings. There is a setting entitled "Scale and layout: Change the size of text, apps and other items". Reduce the percentage value. This should fix it, but the downside is that everything will look smaller on your screen.

Alternatively, right-click on your EHM Editor.exe file -> Properties -> Compatibility. You will see a setting entitled "Override high DPI scaling behaviour". You could try enabling this and trying the various settings in the drop-down menu. I'm not sure it will make much of a difference though.

[archibalduk]

Looks like creating any new club, not sure if it is something with junior/national U20 records having issues. I'll know it happens because a GUI bug appears shortly after saving. You won't see it instantly after creating the club and saving, what will happen is when I go to assign staff to the club I'll see the name of the club change in the selection box to Zaire U20 or Zimbabwe or some other nation, that is how I know it occurred. When I look up the nation I saw in the selection box usually the city, arena, and reputation info of the club I created will overwrite the country, and make it a junior team. After a long editing session creating clubs I have to figure out what national team was overwritten and manually correct the changes via the tip you gave me in the other thread. Sometimes it will bug out for teams I created weeks ago, it's pretty weird.

Happy to do a Zoom meeting or something to show you in person, just PM me. I should be able to reproduce it pretty easily.

I have been unable to reproduce this bug. Creating new teams doesn't cause any issue when I try it (I have been testing using your Pivot Rosters). Could you email to me a copy of a database with the issue present please? ehmtheblueline AT gmail DOT com.

Also, if you can post a step by step of how you can recreate the issue then that would be very useful.

[xECK29x]

Looks like creating any new club, not sure if it is something with junior/national U20 records having issues. I'll know it happens because a GUI bug appears shortly after saving. You won't see it instantly after creating the club and saving, what will happen is when I go to assign staff to the club I'll see the name of the club change in the selection box to Zaire U20 or Zimbabwe or some other nation, that is how I know it occurred. When I look up the nation I saw in the selection box usually the city, arena, and reputation info of the club I created will overwrite the country, and make it a junior team. After a long editing session creating clubs I have to figure out what national team was overwritten and manually correct the changes via the tip you gave me in the other thread. Sometimes it will bug out for teams I created weeks ago, it's pretty weird.

Happy to do a Zoom meeting or something to show you in person, just PM me. I should be able to reproduce it pretty easily.

I have been unable to reproduce this bug. Creating new teams doesn't cause any issue when I try it (I have been testing using your Pivot Rosters). Could you email to me a copy of a database with the issue present please? ehmtheblueline AT gmail DOT com.

Also, if you can post a step by step of how you can recreate the issue then that would be very useful.

Sent!

[archibalduk]

Sent!

Thanks so much for this. I have identified the issue and have fixed about 95% of the issue. The remainder is taking some more figuring out.

The issue is because the GUI goes out of sync with the data when either importing data or when running any validation functions (which are applied when saving the database). When you add a new club, it is added to the end of the clubs table. Then when you save, the database is re-ordered and the national teams are put to the end of the clubs table. However, the GUI still thinks that the newly created team is at the end of the table when in fact it is the final U20 national team (being Zaire in the first instance). This means that you are actually editing Zaire U20 after you save the database when it appears from the GUI that you are editing your newly created team. This could potentially happen with many editing screens (including staff). I have now fixed this aspect of the issue.

A second issue is that even with this issue fixed, there is some copying of data from the newly created record to the final club in the clubs table (being Zaire U20). It only affects certain values and specifically those with drop-down menus. Strangely, it is not all drop-downs but just the Professional Status drop-down. A similar issue appears when importing data via a spreadsheet - the item currently viewed in the Editor will not be fully updated (specifically, certain drop-down menus). I was aware of this latter issue and have been trying to fix it, but now I know that the issue is much wider than I first thought. Had it not been for this additional issue, the temporary work around would be to navigate to another record immediately after saving as this would refresh the GUI. But this doesn't work because of this second "copying" issue.

The temporary work around is to exit the Editor after saving the database. It's not ideal, but all I can suggest whilst I continue to look at the bug.

[nino33]

The temporary work around is to exit the Editor after saving the database. It's not ideal, but all I can suggest whilst I continue to look at the bug.

Just to clarify, is this only in regards to adding a new club?

[archibalduk]

I've fixed the copying issue now, which is a relief. Thanks again to xECK29x for reporting this. I'll try and get a new version out sooner rather than later but it'll need to wait until I have completed and fully tested the roster management changes.

I still need to fix the issue with the Importer though. It's a fairly minor issue, but an issue nonetheless.