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

[Alessandro]

It's an EHM bug, unfortunately these things are AFAIK hardcoded

[archibalduk]

Manimal has encountered an issue where the DB is saved as a blank file. I don't know what the cause is but I'll add something to the next release to check that the file is successfully saved and to display an error message.

I haven't checked the current release, but I do know there is an issue with the unreleased version I'm working on where saving the DB after importing an .ehm will result in the DB being saved to the .ehm file. I am fixing this for the next release. If in the meantime this happens to anybody then just rename the .ehm file to database.db and this should be fine (but I have not tested this).

[xECK29x]

Just a small request for a future release, very low priority. Can you add some validation to City coordinates? I see there is a mix of Longitude coordinates with and without '-' at the beginning, not sure if this will impact how the game chooses cities for generated players/staff.

[archibalduk]

Just a small request for a future release, very low priority. Can you add some validation to City coordinates? I see there is a mix of Longitude coordinates with and without '-' at the beginning, not sure if this will impact how the game chooses cities for generated players/staff.

I'm not sure I follow. Longitude ranges from -180 (west) and +180 (east) with zero being located at the Prime Meridian in Greenwich. London. Are you saying that cities are missing a negative when they shouldn't?

[xECK29x]

I'm not sure I follow. Longitude ranges from -180 (west) and +180 (east) with zero being located at the Prime Meridian in Greenwich. London. Are you saying that cities are missing a negative when they shouldn't?

Actually yes, sorry it's been a hell of a week. Any country in the western hemisphere that does not have a - for Longitude, can that be addressed? If it doesn't have any impact in the game who cares, just something I noticed.

[Manimal]

In Sweden there is a new rule that limits the number of transfer loans in a season. Can that be added to the Editor?
Now we can only allow or disallow loans

[archibalduk]

In Sweden there is a new rule that limits the number of transfer loans in a season. Can that be added to the Editor?
Now we can only allow or disallow loans

Unfortunately I cannot add new settings to the Editor. The Editor simply displays the available settings. It would be down to Riz to add any new settings.

[archibalduk]

I'm not sure I follow. Longitude ranges from -180 (west) and +180 (east) with zero being located at the Prime Meridian in Greenwich. London. Are you saying that cities are missing a negative when they shouldn't?

Actually yes, sorry it's been a hell of a week. Any country in the western hemisphere that does not have a - for Longitude, can that be addressed? If it doesn't have any impact in the game who cares, just something I noticed.

This wouldn't work because some countries straddle the east and west hemispheres - such as England and France. Have you come across a lot of cities with incorrect longitudes? If so, please can you provide some examples?

[archibalduk]

I have returned to the Editor for the first time in about two months today. I want to get another release out later this month if possible. I'm making some final fixes and also improving EHM 2004 compatibility (it is nearly getting close enough to be able to convert it to EHM 2007 format for importing into EHM 1).

[CJ]

Hello Archie.

Will you fix the adding of cities to the next update? As we're still not able to add longitude and latitude into it.

It's one of the things I need for the 1998 database, as I don't know any other way how to add new cities to the game.

[BKarchitect]

Speaking of cities - do the geographic coordinates (outside the nation and state) affect the game in any way? Do the coordinates help populate generated players in proximity to leagues/teams?

[Javs]

Unfortunately I cannot add new settings to the Editor. The Editor simply displays the available settings. It would be down to Riz to add any new settings.

If there was ever a way to limit the amount of transfers per season then Canadian junior leagues can be 90% accurate.

[archibalduk]

Hello Archie.

Will you fix the adding of cities to the next update? As we're still not able to add longitude and latitude into it.

It's one of the things I need for the 1998 database, as I don't know any other way how to add new cities to the game.

If I am able to re-produce the issue then I'll fix it for the upcoming release.

Speaking of cities - do the geographic coordinates (outside the nation and state) affect the game in any way? Do the coordinates help populate generated players in proximity to leagues/teams?

I think longitude/latitude might be used to ascertain how close clubs/arenas are. But I might be mixing this up with an old version of Football Manager.

[CJ]

Team colours don't show up again in v0.2.8. Worked in v0.2.7. (Maybe you had the same issue with v0.2.6?) The editor shows only gray and black logos. Once you change a colour on the team the other ones get corrected though.

[BKarchitect]

This is way, way down the list but along with universal player sorting/filtering by ratings (I know you can do it already on individual team screens - which is awesome), could you add a function that sorts not just by birth year but perhaps by (NHL) Draft year? Basically September 16, Year XX thru September 15, Year XX+1? Would come in handing when filtering younger players by eligible draft class.

Thanks archi!

[archibalduk]

Team colours don't show up again in v0.2.8. Worked in v0.2.7. (Maybe you had the same issue with v0.2.6?) The editor shows only gray and black logos. Once you change a colour on the team the other ones get corrected though.

I can't remember, but I think this was only an issue with v0.2.8 - but I'm not sure. In any event, I already fixed it for the upcoming version.

This is way, way down the list but along with universal player sorting/filtering by ratings (I know you can do it already on individual team screens - which is awesome), could you add a function that sorts not just by birth year but perhaps by (NHL) Draft year? Basically September 16, Year XX thru September 15, Year XX+1? Would come in handing when filtering younger players by eligible draft class.

Thanks archi!

Maybe. I still need to get the attribute filtering up and running. Whether I can add draft year filtering depends on the performance of the attribute filter. The more items you make it possible to filter by, the slower the filter (and the staff table is already a slow table). I'll have a think...

[archibalduk]

Hello Archie.

Will you fix the adding of cities to the next update? As we're still not able to add longitude and latitude into it.

It's one of the things I need for the 1998 database, as I don't know any other way how to add new cities to the game.

I have fixed this. I have also fixed the Importer spreadsheets not accepting commas as the decimal point. Spreadsheets can now use dots or commas (or a combination of both). The Editor will use commas or dots according to your system settings. I think I have caught all instances of this across the Editor screens, but if anything looks like it has been missed when I release the next version then let me know.

[archibalduk]

Not sure if this is a bug or not but I noticed a lot of players won't have their year of birth set, I have to manually hit enter to get it to register. I don't think this is an issue in-game but maybe that is something that can be enforced on save?

Fixed.

[archibalduk]

Here is a new version: viewtopic.php?f=148&t=16014

This adds a few new importer spreadsheets (officials, staff award history and staff preferences) along with a few UI changes and a number of bug fixes. The Editor can now decode about 99% of the EHM 2004 database and I hope to add EHM 2004 to EHM 2007 conversion in the next main release. Thank you to everybody who reported bugs.

I think this will probably be the last release until I have completed the usual summer research for the TBL Rosters. But I might release a minor update if anybody finds any bugs or there is something critical we need for the TBL Rosters.

CHANGELIST: VERSION 0.2.9 (16-Jun-2018)

New Features:

• Added a file size error message when the database saved as a blank or small file size;
• Added copy, paste and invert/cycle buttons to each colour editor;
• Added copy all colours and paste all colours to the Clubs and Nations editing screens;
• Added data validation to the Awards History and Club History tables (the table is now re-sorted and unlinked entries are deleted);
• Added duplicate staff reporting (via Export Spreadsheets screen);
• Added Mass Edit drop-down menu to the People tab;
• Added mass editor (people): Delete all players and/or staff;
• Added mass editor (people): Free agent utility (players and/or staff);
• Added first names and second names exporting;
• Added "ignore old entries" setting when importing staff award history;
• Added officials exporting;
• Added officials importing;
• Added right-click menu to the Player Roster and Staff Roster tabs of the Clubs editing screen in order to quickly set players/staff free agents;
• Added saved game unpacking via the File -> Unpack button;
• Added staff award history exporting;
• Added staff award history importing;
• Added staff preferences exporting;
• Added staff preferences importing; and
• Enabled deletion of officials via the Officials editing screen.

Fixes and Improvements:

• Added a row count indicator to the bottom of each editing screen;
• Added club competition/league research spreadsheet exporting;
• Added year of birth validation to players/staff and officials;
• Any editing screens where there are no rows of data will be disabled;
• Clarified the labels of not applicable items on the Rules & Structure importing screen;
• Decimal points using a comma are now correctly processed in editing screens and Importer spreadsheets;
• EHM 2005 Staff Preferences data is now transferred from the Staff table to the Staff Preferences table;
• Fixed a major issue with the database being saved to an .ehm file after importing an .ehm file into the database;
• Fixed an issue with the colour previews not updating;
• Fixed an issue with the last edited field being reset when saving;
• Improved decoding of EHM 2004 databases (but it is not 100% complete yet);
• Moved Record ID and Unique ID indicators to the bottom of each editing screen;
• Player career history is always validated with the Set Linked Data setting enabled;
• The navigation lists on each editing screen are now correctly updated after the database tables have been re-ordered;
• The Staff and Officials editing screens now show the person's age for EHM 2004-2007 databases;
• Updated the application icon with the new TBL logo;
• Various adjustments to the player/staff matching functions, particularly in respect of the Staff Smart Import; and
• Year of Birth is automatically calculated irrespective of whether the Sort Staff Data setting is enabled.

[xECK29x]

Amazing work as always Archi! This added a lot of the features I think a lot of us were waiting on! Now to get started on all the award updates in my DB!

[riazorblues86]

Hi Archi,

I have one question regarding EHM Editor. Hope you can help.

Real world trade happened between 2 teams, which one team get a player, while other get drafts pick. So, I manage to change the player team in player section, but how do i change the
draft pick for other team? Is possible to change the draft pick in editor?

Hope you can help.

Thank you.

Regards,

[xECK29x]

Is possible to change the draft pick in editor?

Draft picks are found in extra_config.cfg which you can edit with a tool like Notepad++ or Sublime. These config files are loaded alongside the DB and should be placed in the same folder as the .db file.

[CJ]

I have fixed this. I have also fixed the Importer spreadsheets not accepting commas as the decimal point. Spreadsheets can now use dots or commas (or a combination of both). The Editor will use commas or dots according to your system settings. I think I have caught all instances of this across the Editor screens, but if anything looks like it has been missed when I release the next version then let me know.

Super awesome!

[88_06_12]

Hello!

When importing a file in "Rules & Structures" with the 0.2.8 version the file appeared in the db-folder, with 0.2.9 the file does not do that, it isn't seen anywhere. Does that matter? Or is the file in the db 'hidden'? Rookie question, sorry for that.

In this case i thinking of the 'Hockeyettan Schedule' file. Just to be sure the save can live a long life and not be stopped due to errors.

Thanks for your time!

[archibalduk]

The file appeared in the same folder as the DB in version 0.2.8 because of a bug (the DB file was being saved into the .ehm file). The Editor imports the contents of the .ehm file into the DB and so there is no separate file once imported as it is contained within the DB file. The .ehm file is just a handy way to transfer data from one DB to another.