EHM 1 Database & Saved Game Editor

Discuss all aspects of editing the data in EHM here. Have a question about the Pre Game Editor, editing the .cfg files, hex editing the .dat files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
Forum rules
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.

Please note that discussion about roster updates belongs in the Game Add-ons Forum.
User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Sun Mar 11, 2018 3:31 pm

nino33 wrote:
archibalduk wrote: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?
It could potentially happen to clubs, staff and affiliations. I think that's all of them, but there could be others (basically its any table where the Editor re-orders the data).

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Sun Mar 11, 2018 4:07 pm

archibalduk wrote: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.
I've now gotten to the bottom of this issue too. It was a really simple fix - it just took a bit of logic/thought. Anyhow, I'm now allowing myself to go out for my run! :D

User avatar
nino33
Mr. Goalie
Posts: 5862
Joined: Sat Aug 07, 2010 3:37 am
Custom Rank: Retro Rosters Specialist
Favourite Team: 1970s hockey

Re: EHM 1 Database & Saved Game Editor

Post by nino33 » Sun Mar 11, 2018 4:08 pm

Thanks for clarifying; I'm thinking of my work on the 74DB.....so far I've been editing Attributes and I don't recall adding/deleting any clubs, staff or affiliations, so I figure I should be OK

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Sun Mar 11, 2018 4:11 pm

Yeah you should be fine in that case. It is easy to identify the issue for clubs because Zaire U20 will no longer be listed as U20 (instead you'll have two senior Zaire teams).

User avatar
xECK29x
Minor League
Posts: 253
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x » Mon Mar 12, 2018 12:34 am

Not a problem and I have seen this with staff as well so I'm glad you caught that.

Happy to test for you if needed.

wildcat62
Junior League
Posts: 15
Joined: Tue Feb 02, 2010 10:48 pm

Re: EHM 1 Database & Saved Game Editor

Post by wildcat62 » Wed Mar 21, 2018 3:03 pm

Hey archi, is there currently a way to mass delete both Draft and Staff history using excel imports?

EDIT: Just worked out the draft history based on your instructions, at first I thought they said to set everything but the draft and year to "[none]"

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Sun Mar 25, 2018 9:37 am

Progress with the Editor has felt really slow of late. The new roster management functions and the club roster editing screens have been a lot of work. It hasn't helped that I have been restricted to weekends recently as my job has involved long working hours these past few weeks. However, I think it is all done now. I just want to add some more tweaks/improvements to the Editor and then I'll post a new release hopefully during April. I was originally planning to add more before releasing, but this clubs editing fix needs to be released sooner rather than later.

laving39
Learning to skate
Posts: 2
Joined: Tue May 19, 2015 5:26 pm
Favourite Team: Ottawa Senators

National Team Counts does not add up

Post by laving39 » Sun Mar 25, 2018 2:22 pm

I've been creating a custom database from a TBL Rosters, and made som big changes. I've put in so much time on this one, that I would even pay to get this fixed if necessary. (Recreated NHL to a European Fantasy League, put in a 32nd team both for Pro League and Farm League, created schedules both for normal season and Olympic season for Pro League and Farm League, created logos to the 32 european fantasy teams, added arenas to every fixtional team, created some other fixtional teams to other leagues, and so on)

When trying to start a new save, I now get two error messages right after choosing my custom database.

"National Team Counts does not add up"

Followed by

"Fatal
v1.4.1 select_leagues_screen.cpp 114"

And then the game crashes.

I have no backup on my work with the database, since all errors so far have showed up on or after the "Select Leagues Screen". On that screen, you normally see which league are broken. If not, you see it in the game once started. I don't get to that screen now.

What happened between last working database, and the damaged one, is that I switched places on two teams between Norwegian Second Division and Third Division, and then added 4 teams to the Second Division (not playable). I of course tried to delete these 4 teams from the Second Division again, without any luck. What really bothers me, is the first error message, "National Team Counts does not add up". I haven't touched the national teams since I started on this database.

I've been using the EHM Editor version 0.2.0.

Please help. I don't want to start over...

BKarchitect
Checking Line
Posts: 538
Joined: Sat Jan 07, 2012 11:21 pm

Re: EHM 1 Database & Saved Game Editor

Post by BKarchitect » Sun Mar 25, 2018 2:52 pm


User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Sun Mar 25, 2018 3:52 pm

BK has posted the solution above, but just to add that you should really be using the latest version of the Editor. Version 0.2.0 was a long time ago and many bugs have been fixed since then.

laving39
Learning to skate
Posts: 2
Joined: Tue May 19, 2015 5:26 pm
Favourite Team: Ottawa Senators

Re: EHM 1 Database & Saved Game Editor

Post by laving39 » Sun Mar 25, 2018 5:00 pm

Thanks! It worked! And yes, upgraded to latest version.

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Sun Mar 25, 2018 9:11 pm

Great. :thup:

The next version will periodically check for new updates which should hopefully keep everybody more up to date.

Issegoz
Learning to skate
Posts: 3
Joined: Wed Mar 28, 2018 12:44 pm
Favourite Team: AIK

Re: EHM 1 Database & Saved Game Editor

Post by Issegoz » Wed Mar 28, 2018 12:52 pm

Hi, i have started playing again after a long break so the last editor i used was the first one. I downloaded the latest editor but when i try to start it i just get a error message. " The application was unable to start correctly (0xc0000022). Click OK to close the application."
What seems to be the problem? I have so many ideas of things i want to edit so i just wanna get started. :help:

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Wed Mar 28, 2018 9:08 pm

I tried Googling the error and it sounds like it relates to the Visual C++ Redistributable files being missing. Did you follow the installation instructions set out in the Editor download thread?
archibalduk wrote:INSTALLATION INSTRUCTIONS
IMPORTANT! You must first install the Microsoft Visual Studio 2015 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 32-bit version (also known as vcredist_x86.exe). Even if you have 64-bit Windows, you must nonetheless install the 32-bit version of the Redistributable (this is because the Editor is a 32-bit application).

The Redistributable can be downloaded here: https://www.microsoft.com/en-gb/downloa ... x?id=48145

Once you have installed the Redistibutable, just extract the contents of the Editor zip file wherever you like and double-click on 'EHM Editor.exe' to load the Editor.


RUN AS ADMINISTRATOR
I highly recommend enabling Run as Admin in order to ensure that the Editor is able to save your database files. As EHM is normally installed in the C:/Program Files/... set of folders, the Editor is unable to save databases within that folder structure unless Run as Admin is enabled (otherwise it either won't save or you will end up with shadow copies in your Roaming folder).

To enable Run as Admin, right-click on 'EHM Editor.exe' and click on Properties -> Compatibility -> tick the box labelled "Run this program as an administrator".

matheuzcordeiro
Learning to skate
Posts: 2
Joined: Thu May 25, 2017 7:07 pm
Favourite Team: Bruins

Re: EHM 1 Database & Saved Game Editor

Post by matheuzcordeiro » Wed Mar 28, 2018 10:27 pm

is there a chance that next update coming with a filter by PA and CA?
Last edited by matheuzcordeiro on Wed Mar 28, 2018 10:57 pm, edited 1 time in total.

matheuzcordeiro
Learning to skate
Posts: 2
Joined: Thu May 25, 2017 7:07 pm
Favourite Team: Bruins

Re: EHM 1 Database & Saved Game Editor

Post by matheuzcordeiro » Wed Mar 28, 2018 10:56 pm

btw, editor is not working, it loads but if I try search anything it doesn't appear

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Thu Mar 29, 2018 7:29 am

matheuzcordeiro wrote:btw, editor is not working, it loads but if I try search anything it doesn't appear
Please can you post or upload your log.tx file (located in the same folder as your Editor exe file)? Also some screenshots of the issue would help.

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Thu Mar 29, 2018 7:30 am

matheuzcordeiro wrote:is there a chance that next update coming with a filter by PA and CA?
No there's no chance.

Issegoz
Learning to skate
Posts: 3
Joined: Wed Mar 28, 2018 12:44 pm
Favourite Team: AIK

Re: EHM 1 Database & Saved Game Editor

Post by Issegoz » Thu Mar 29, 2018 3:01 pm

Arch: I had the Redistibutable but just in case i deleted it and reinstalled it but i still get the same message.. really annoying!

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Thu Mar 29, 2018 9:48 pm

Presumably you're using Windows 7 or newer? You did install the 32-bit version of the Redistributable didn't you?

You could try running Dependency Walker to check whether you are missing any DLL files. Run Dependency Walker and click on File->Open and select the EHM Editor.exe file. It will take about 30-60 seconds. You can ignore the warnings about API-MS-*** files. Any other warning symbols might indicate a missing DLL.

Image

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Fri Mar 30, 2018 4:46 pm

Here is the new version (v0.2.7): viewtopic.php?f=148&t=16014

This fixes various of the bugs recently reported; such as the issue with the wrong club data being overwritten and the national clubs being lost/edited. Aside from that, the main feature is the new roster management function. This won't be all that obvious at first glance, but there are a few new aspects which should hopefully make things easier; e.g. the new Player Roster and Non-Player Roster screens on the Clubs editing screen which allows players and non-players to be edited in table format.

There are various new features which I will post separately about later today.

CHANGELIST: VERSION 0.2.7 (30-Mar-2018)

New Features:
  • Added a button to show the currently viewed city in Google Maps via the Tools menu of the City editing screen;
  • Added a button to the Staff editing screen to immediately runtime data recalculation for the selected player;
  • Added club history exporting;
  • Added club history importing;
  • Added system diagnostic details button to the Home screen;
  • New roster management with real time roster processing;
  • Player Roster and Staff Roster sub-screens on the Clubs screen which lists each club's rosters and allows all player/staff data to be edited; and
  • Weekly checks for software updates with notification messages (with a button to manually check for updates on an ad-hoc basis).
Fixes and Improvements:
  • Added a new small toolbar size setting;
  • Added a UTF hex code field to the Names editing screens (for debugging purposes);
  • Adjusted the design of the lower toolbar on each editing screen;
  • Adjusted the method by which club history, club records, draft histories and player rights are linked to clubs and players in order to prevent a crash where invalid IDs have been assigned to those tables;
  • Automatic detection of yyyy-mm-dd dates in Importer spreadsheets;
  • Corrupted "c" and "e" with carons in the names "Petr Hucko" and "Vojtech Krejirik" in the TBL Rosters v10.1 will be automatically fixed when next saving the database;
  • Fixed issue with drop-down menus overwriting imported values from an Importer spreadsheet for the item currently displayed in an Editor screen;
  • Fixed issue with the toolbar size setting being ignored;
  • Fixed major issue with the Editor GUI going out of sync with the underlying data in certain circumstances after saving;
  • Fixed potential memory allocation error with the Database Header table;
  • Improved player/non-player Classification and Job For Club/Nation validation;
  • Merged the Miscellaneous tab into the Preferences tab on the Clubs editing screen;
  • Moved the automatic strength and primary position buttons on the Player screen to the Tools menu;
  • Moved the "Set club as inactive" button on the Clubs screen to the Tools menu;
  • Stage navigation combo box on the Rules & Structures screen now contains more descriptive stage names;
  • The database data is now automatically refreshed when importing via the Importer;
  • 'TM' symbols are now omitted from text csv files;
  • The exit confirmation dialog window is now only displayed if the database/saved game has not been saved within the past five seconds;
  • The Tools menu on each editing screen no longer shows the Importer Text item unless Expert Mode is enabled;
  • True/false flag settings are now adjusted by single-clicking on the setting; and
  • Various minor user interface adjustments.

Issegoz
Learning to skate
Posts: 3
Joined: Wed Mar 28, 2018 12:44 pm
Favourite Team: AIK

Re: EHM 1 Database & Saved Game Editor

Post by Issegoz » Fri Mar 30, 2018 7:08 pm

Arch: Yes i have Win7 and its something wrong with the Qt5Core.dll but how do i fix that? I tried replacing it with another Qt5Core.dll from dll-files.com but that didnt work. Thank you for your work and time!

BKarchitect
Checking Line
Posts: 538
Joined: Sat Jan 07, 2012 11:21 pm

Re: EHM 1 Database & Saved Game Editor

Post by BKarchitect » Fri Mar 30, 2018 8:54 pm

Archi - I cannot tell you how awesome these team screens are now...amazing work, the ability to do sortable editing basically just like in the export spreadsheets is wonderful!

Thought I would post some screens to give people a taste:

:notworthy: :notworthy: :notworthy: :notworthy: :notworthy: :notworthy: :notworthy: :notworthy:

Image

Image

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Fri Mar 30, 2018 10:36 pm

Issegoz wrote:Arch: Yes i have Win7 and its something wrong with the Qt5Core.dll but how do i fix that? I tried replacing it with another Qt5Core.dll from dll-files.com but that didnt work. Thank you for your work and time!
The dll is included with Editor already. I'd use the version included with the Editor as the version on dll-files.com might be out of date (i.e. not version 5.10). I have to admit that I'm struggling to come up with any further suggestions. If you have the 2015 Redistributable 32-bit installed then it should be fine. :-?
BKarchitect wrote:Archi - I cannot tell you how awesome these team screens are now...amazing work, the ability to do sortable editing basically just like in the export spreadsheets is wonderful!
I'm glad it is useful. You have no idea how painful it has been coding those screens along with the roster management functions!

User avatar
archibalduk
TBL Admin Team
Posts: 19096
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk » Fri Mar 30, 2018 11:17 pm

As promised, here is a brief run down of some of the changes in this latest version of the Editor. Click on any of the screenshots below in order to view a larger size.


Menu Size
I just wanted to mention this first: I added a new menu size setting which might help those with smaller screen resolutions (i.e. the size of the menu bar running along the top of the screen). You might find that when you first load the Editor that it will default to the smallest menu bar setting. If you want to restore its size, go to File -> Settings -> Main menu toolbar size and select 'Medium'. On a related note, a warning will now be displayed in the log when loading the Editor if the screen resolution is too small or the scaling setting is too large.


Roster Management
The roster management functions have been completely re-written so that the rosters are updated instantaneously rather than just when saving or loading the database. This is a significant change and it has taken a lot of work. As far as I can tell, I have ironed out the initial bugs but please do keep an eye out for anything roster-related which appears to not be working as it should.

The status bar in the bottom right corner of the screen will be highlighted in red when there are any roster errors. Each team has a certain number of slots for players and staff (e.g. each team can have up to 75 players, 3 physios, 1 general manager, etc). A roster error is simply where you have tried to assign too many players/physios/etc to a team. Such players/staff will appear in game in a sort of limbo; they will not appear on the team's roster but their profile will show them as contracted to that team (but they cannot be selected, etc). It is important to fix any roster errors in order to avoid any of these issues.

Any player/staff who has a roster error will have their name highlighted in yellow the list running down the left-hand side of the Players & Staff editing screen. There are now Club Roster and National Team Roster status fields listed in each person's profile which will be highlighted in yellow where there is any issue.

The easiest way of finding any affected players/staff is to click on the Filter button on the Players & Staff editing screen and then filter by Validity (Has Errors) like so:

Image


Roster Editing Screens
This follows on from the roster management functions. It is now possible to edit player/staff data using the Player Roster and Staff Roster tabs on the Staff editing screen. The tabs running along the bottom of the screen allow you to toggle what data is shown.

I plan to add a right-click menu as an easy way of making a player/staff a free agent. In the meantime, just click on the person's Club Contracted or Playing For and select the "- None -" option.

Image
Image


Club History Importing
It is now possible to import/edit/delete club histories via the Import Spreadsheet screen. To delete an entry, just enter the club, competition and year and then set the GP to zero and the Edit Competition column to "_none".

On a related note, I have made some further tweaks to the way in which the Editor detects dates in spreadsheets. The Editor will automatically detect any yyyy-mm-dd date formats in a spreadsheet even if the spreadsheet's setting has been set otherwise or where other dates are in other formats. Hopefully this should fix the issue ppalloo and CJ encountered with importing spreadsheets.


New Tools Menu
Various functions have been added to the Tools menu located in the bottom right corner of the screen. This is mostly relevant just for players and clubs. E.g. this is now where you can quickly set a player's position or re-calculate their runtime date (this was requested by xECK29x so that he could see updated runtime data for a player on the fly - but this can otherwise be disregarded as runtime data for everybody is recalculated whenever you load or save). The Tools menu on the Cities editing screen allows you to view that city in Google Maps via your web browser (based upon the longitude and latitude in the database) - this is just so that you can check that the longitude and latitude is correctly set.

Image


User Interface Tweaks
I have made quite a lot of UI changes throughout the Editor. The window now has no border down the left and right sides which allows a little more room for the editing screens. There is also an improved prompt displayed when closing the Editor - it tells you when you last saved (or if you haven't at all). If you close the Editor within 5 seconds of loading/saving then no prompt is displayed.

The true/false settings throughout the Editor (e.g. the various flags, etc) can now be toggled with a single click. Hopefully this makes things a little easier. Also, the drop-down menu listing the league stages displays a little more information to help with navigation (see screenshot below). The drop-down menu also shows the in-game stage number used when EHM displays stage-related errors in-game. You will find this number running down the right-hand side of the drop-down menu (i.e. the numbers running, -1, 0, 1, 2, etc):

Image


Update Notifications
I have recently noticed than some people are running really old versions of the Editor and are, in some cases, missing out on fairly significant bug fixes. The Editor will now check for a software update once a week (every 7 days from when the Editor last auto-checked or when the manual "Check for Updates" button has been pressed). It takes 3 or 4 seconds for the Editor to check and so it will do so when loading a database/saved game rather than when loading the Editor (because otherwise the Editor would take a few seconds to appear). The automatic update checking can be disabled via the Settings menu. The Editor will buffer any update notification so that it will remind you each time you load that a new update is available. This isn't the Editor checking online each time you load; it's just that once it knows an update is available it will tell you every time you load.

Note that this is just a notification. You still have to visit the site and manually download. I don't want to add auto-downloads as it is more secure to visit the site manually (an auto-download could in theory be hacked to trick you into downloading a file from another site).

Post Reply

Return to “Data Editing Forum”