EHM The Blue Line

I plan on writing some guides once I have released the next version of the Editor (hopefully released this weekend if all goes well). That will explain how to use the importer files.

archibalduk wrote:I plan on writing some guides once I have released the next version of the Editor (hopefully released this weekend if all goes well). That will explain how to use the importer files.

Sounds good, thanks!

Here is a new version (v.0.2.5) : viewtopic.php?f=148&t=16014&p=233289#p206841

This is probably the biggest changelist for any release so far! I'd actually planned on adding a few more features (e.g. staff preferences and officials importing) but I'm running out of steam. I'm going to take a break and write some guides before I return to working on the Editor again. I will make a separate post in a moment with further details on some of the main changes.

For the next release, I plan on adding some more importing functions (e.g. staff preferences, officials and club/competition records and histories), tidy up the UI and hopefully also replace the third party XLSX code with something more efficient and stable.

CHANGELIST: VERSION 0.2.5 (21-Jan-2018)

New Features:

• Added affiliation importing;
• Added city importing;
• Added exporting of: (i) Affiliations, (ii) Arenas, (iii) Cities, (iv) Nations and (v) Player career history;
• Added filters to the following editing screens: (i) Club Competitions, (ii) Clubs, (iii) Officials, (iv) Retired Numbers, (v) Staff and (vi) Staff Awards;
• Added mini control panel to the Home screen for quickly changing the version and start year;
• Added nation importing; and
• Added smart roster importing.

Fixes and Improvements:

• Added a prompt when attempting to close the Editor where there is an open database or saved game;
• Added a static selection dialogue window for arenas and corrected certain editing screens which were using a dynamic selection dialog window for cities instead of the static version;
• Added extra Preferred Tactic attribute values and removed the -1 value which would cause an in-game crash;
• Added help/readme panel to the Importer and Settings screens;
• Added nation, reputation and name editing options to the Club Conversion spreadsheet in the 'conversion_data' folder;
• Added option to populate all conferences or current conference via the Structure sub-screen of the Rules & Structures editing screen;
• Added setting: Enable data linking. This ensures that various of the tables are correctly linked and displayed in the Editor. This setting should ALWAYS be enabled otherwise you will find that linked data will not appear in various screens;
• Added setting: Reallocate staff UIDs in numerical order;
• Added setting: Repair drafted player name indexes;
• Added setting: Repair non-player attributes (i.e. the Preferred Tactic attribute);
• Added setting: Staff data validation. This deletes invalid and retired staff;
• Added start year validation for databases in order to ensure that both start year settings in the database remain synchronised;
• Added visual warning where a club is assigned to a league but has no reputation set (this will cause a crash in game where the league is playable);
• Added year filter to the Export Spreadsheet screen;
• Added zero file size error when loading empty databases or saved games;
• Blank names are no longer permitted when creating new items via Importer spreadsheets;
• Blank spaces are automatically removed from the start and end of text (i.e. in order to avoid inadvertantly putting spaces before/after team names, etc);
• Corrected Preferred Tactic to Preferred Job for non-players in EHM 1;
• Databases can now be saved using custom file names;
• Dates of birth entered as 0.0.yyyy in an Importer spreadsheet now correctly result in a year of birth of yyyy with a date of birth of 1.2.1900;
• Extra synonyms added for first names;
• Filter buttons are no longer displayed on editor screens which cannot be filtered (aside from text searching);
• Filtered data is now correctly sorted alphabetically;
• First time warning dialogue window is now displayed each time the user runs a new version of the Editor;
• Fixed in-game crash when viewing certain non-player profiles caused by the inclusion of the Preferred Tactic (now Preferred Job) attribute;
• Fixed issue with the currently viewed item on the various editing screens not being updated when importing an Importer file or using the Converter;
• Fixed "TM" trademark symbol not being correctly displayed in the Editor (this relates to the way in which EHM databases stored the symbol in ASCII format);
• Fixed significant comparison issue which could cause skaters' positions to be incorrectly validated as goaltenders;
• Improved restoration of the Editor window state;
• Improved rounding when showing imperial heights and weights on the Player Details editing screen;
• Latest player career history season is now listed on the Players & Non-players export spreadsheet;
• Memory usage improvements with internal text strings;
• Minor performance improvement when importing certain Importer spreadsheets;
• Optimised player career history deletion (the average deletion is now near instantaneous instead of taking approx 45 seconds);
• Redesigned control panel with settings now saved to the Windows registry rather than to the settings.dat file;
• Redesigned home screen with a list of useful and important information;
• Removed deprecated fonts from the stylesheet.css file (delete the css file in order for the changes to take effect);
• The Export Spreadsheet screen now has a checkbox in order to select the research spreadsheet format rather than having separate research and non-research spreadsheets listed;
• The save button when editing a person's name is now hidden when changing records where the user has not saved the name change of the previous record;
• The staff data table is now sorted;
• Updated the Preferred Tactic field to reflect the apparent possible range of values;
• Upgraded to Qt 5.10;
• Validation of the database/saved game can be enabled/disabled according to the EHM version of the database/saved game; and
• Various minor adjustments in readiness for forward and backward compatibility with EHM 1.5 database build version.

Here is an overview of some of the new features:

No more in-game non-player profile crashes!
It turns out that the Preferred Tactic field is actually a Preferred Job field and consequently -1 is not a valid value for this field (this was the default value for new non-players in previous versions of the Editor). I have corrected this throughout the Editor and have added an automatic fix which will patch the issue in any existing database. Just load and save your database in the Editor and the issue will be fixed.


Filtering
More filters have been added as follows: (i) Club Competitions, (ii) Clubs, (iii) Officials, (iv) Retired Numbers, (v) Staff and (vi) Staff Awards.

Several of these are more advanced that the filters includes with previous versions (such as the Club Competitions, Clubs and Staff filters). The Staff filter does not yet have any attribute filtering - I will add this for a future version (hopefully the next version).








Importer & Exporter Buttons
These have been moved from the 'Tools' menu to the 'File' menu. I think this will make it easier to find (especially for new users who might not think to look at the 'Tools' menu).




Affilition Importing
For those familiar with the Importer spreadsheets, this one should be self-explanatory. For those who are not familiar with the spreadsheets, I am starting to write guides for all Importer spreadsheets.

To edit an existing affiliation, enter the existing Upper Club and Lower Club. Then use the rest of the columns to list the changes you want to make. You can delete the affiliation by putting "_none" in either of the New Upper Club or New Lower Club columns (it doesn't matter which).


City Importing
Again, this one should be pretty self-explanatory for those who are familiar with Importer spreadsheets.


Nation Importing
Also self-explanatory. Note that you cannot add or delete nations. You can only edit nations.


Smart Update (Players Only)
Sorry for the cheesy name! I wanted to differentiate it from the other Importer spreadsheets and didn't know what else to call it. This spreadsheet is still rather experimental and I advise using caution when trying it out.

The idea behind this spreadsheet is to make it quicker and easier to update rosters for a team. There are a few ways in which it does this:

1. You can set an entire team's rosters without having to manually transfer out any existing players. Just list the entire roster for a team(s) in the spreadsheet and then tick the "Clear Club Rosters" setting in the Importer screen in the Editor. This will make all existing players on the team(s) free agents and will then assign your listed players to that team.

2. Rather than having to manually set whether a player needs to be created, the Importer will try and figure this out for itself. I do not think it is quite perfect - specifically, it cannot quite differentiate between players who have 1.2.1900 dates of birth. This is something I will continue to work on.

3. Where we do not know the player's specific position (e.g. where we only know they are a defenceman or a forward), the Importer will randomly generate an appropriate position. The position will in the first instance be determined by the player's stick side (e.g. a left handed defenceman will be made an LD and a left handed forward will be made an LW or C). More than one position can be entered with each subsequent position being treated as a second, tertiary, etc position as appropriate (each should be separated by a "/" forward slash). Possible values are: G, LD, RD, LW, C, RW, D, F, W.

4. Contract expiry dates are automatically set according to the contract expiry year you enter for each player in the spreadsheet. Players contracted to a North American team will have an expiry date of 30 June and all other players will be 30 April.

5. Any birth cities listed in the spreadsheet which do not already exist in the database can either be ignored or automatically added by the Importer. This avoids having to wade through city errors and/or manually compile a list of cities to be added.




Mode and Year Selection
To make life a little easier, it is now possible to change the start date from the bottom left corner of the 'Home' screen. This will also update the years in the relevant Rules & Structures entries so that all years in the database remain in sync.

There is also a Mode selection menu next to the Year selection input. This will become relevant once EHM v1.5 is released as it will provide an easy way to convert a v1.4 database into a v1.5 database in the event there are any changes to the database structure.

Aw some!

Sounds great but I cannot start the editor.
I get a message saying something like I might not have the clearance to open the file. My antivirus also gives me a warning about the file

I suspect it is a false positive. Can you add the EHM Editor.exe file to your safe list/white list?

It might be because the Editor now uses the Windows registry to store its settings. Perhaps the anti-virus doesn't like that.

archibalduk wrote:I suspect it is a false positive. Can you add the EHM Editor.exe file to your safe list/white list?

It might be because the Editor now uses the Windows registry to store its settings. Perhaps the anti-virus doesn't like that.

No idea what a safe list/white list is but i had the option to say I trust the file

archibalduk wrote:It might be because the Editor now uses the Windows registry to store its settings. Perhaps the anti-virus doesn't like that.

Any explanation/reason why this change was made to editor in the first place?

Yes that should do it. Is it working now? If not, post a screenshot of the error and I'll try and figure out the source (admittedly it'll be in Swedish).

Edgars wrote:

archibalduk wrote:It might be because the Editor now uses the Windows registry to store its settings. Perhaps the anti-virus doesn't like that.

Any explanation/reason why this change was made to editor in the first place?

It makes accessing the settings in the Editor significantly easier when coding. And it's a pretty standard thing to do.

https://imgur.com/a/zWcqW

Everytime

Tonait wrote:https://imgur.com/a/zWcqW

Everytime

Are you using XLSX? As mentioned in the list of issues on the Home screen, XLSX is currently unstable with large exports. Use CSV or XML instead.

archibalduk wrote:

Edgars wrote:

archibalduk wrote:It might be because the Editor now uses the Windows registry to store its settings. Perhaps the anti-virus doesn't like that.

Any explanation/reason why this change was made to editor in the first place?

It makes accessing the settings in the Editor significantly easier when coding. And it's a pretty standard thing to do.

Actually, I don't think it will be this. The Importer has been using the Registry for a couple of versions, so nothing new there. I just extended it to the Settings screen this version.

This is awesome! Thank you!!!!

archibalduk wrote:Yes that should do it. Is it working now? If not, post a screenshot of the error and I'll try and figure out the source (admittedly it'll be in Swedish).

Today, it opened without issues

archibalduk wrote:

MasterMatt23 wrote:I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?

Editing ratings shouldn't cause a crash. Did you edit something else as well?

I don't think I did. Also is there an ability to create real players? I want to have real prospects and complete OHL/WHL drafts. The 2017 drafts for those are not complete

MasterMatt23 wrote:

archibalduk wrote:

MasterMatt23 wrote:I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?

Editing ratings shouldn't cause a crash. Did you edit something else as well?

I don't think I did. Also is there an ability to create real players? I want to have real prospects and complete OHL/WHL drafts. The 2017 drafts for those are not complete

The best way to add new players is with a spreadsheet.
If you decide to create the missing OHL/WHL draftees then we'd gladly accept if we could use them for the TBL roster update as nobody is currently working on those leagues

Have a look at these guides: viewtopic.php?f=110&t=18124

viewtopic.php?f=150&t=18864

Manimal wrote:

MasterMatt23 wrote:

archibalduk wrote:
Editing ratings shouldn't cause a crash. Did you edit something else as well?

I don't think I did. Also is there an ability to create real players? I want to have real prospects and complete OHL/WHL drafts. The 2017 drafts for those are not complete

The best way to add new players is with a spreadsheet.
If you decide to create the missing OHL/WHL draftees then we'd gladly accept if we could use them for the TBL roster update as nobody is currently working on those leagues

Have a look at these guides: viewtopic.php?f=110&t=18124

viewtopic.php?f=150&t=18864

Thanks! I can try to, but I'm not sure how well it will turn out. Plus I'm on a mac so i'm not sure if it will still work

I don't know how to do it.

I posted an updated version of the Editor yesterday (v0.2.6): viewtopic.php?f=148&p=233424#p206841

This is just a quick release to fix an issue with blank dates in an Importer spreadsheet being reset to 1.2.1900.

MasterMatt23 wrote:

archibalduk wrote:

MasterMatt23 wrote:I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?

Editing ratings shouldn't cause a crash. Did you edit something else as well?

I don't think I did. Also is there an ability to create real players? I want to have real prospects and complete OHL/WHL drafts. The 2017 drafts for those are not complete

Editing an attribute in the database won't cause a crash (all that is being done is changing a numerical value). It sounds like you changed something else where intentionally or inadvertently. Although I'm not all that clear how you edited the database if you're saying you have a Mac and you're not sure if the Editor will work. Also, I'm not really sure how this reconciles with what you said on Reddit yesterday HERE (see quote below) which suggests you encountered a crash by trying to add new players in the database using the Editor. I'm very confused.

MasterMatt25 wrote:So I'm wanting to edit/create real life porspects in order to make draft orders more realistic. At first it worked fine, but now at the end of year 1, my game keeps crashing. By creating prospects, I usually just take a nothing prospect and change their names and potentials. Is there a better way to make it more realistic?

As for adding players, you'll need to use the Editor. You can either follow the guide Manimal linked to (this specifically explains how to add new players via spreadsheets) or you can use the "Add" button in the Editor on the "Players & Staff" screen. This all assumes you are able to run the Editor on the Mac.

MasterMatt23 wrote:I don't know how to do it.

You don't know how to do what? Run the Editor on the Mac? I don't know if anyone has ever tried this. I don't have a Mac and have never used one, so I cannot really offer any advice.

So I have wine/playonmac which I use to play and run the game and editor.
I edited potentials and about the names of about 6 random players. At first it worked fine. When I went to edit a few more, the game kept crashing a few days later.
So I went to reddit to see if creating a player would work instead of editing, so far it hasn't. When I try to find the player, he's non-existent.
What I meant from my last comment was I don't know how to run the spreadsheet. I would follow the steps and then I'd get a message when importing it back that no new lines were added and to abort the import.
Sorry for confusion.

MasterMatt23 wrote:So I went to reddit to see if creating a player would work instead of editing, so far it hasn't. When I try to find the player, he's non-existent.

It might be that you haven't set the player's Classification and Job For Club (both should be set to 'Player').

MasterMatt23 wrote:What I meant from my last comment was I don't know how to run the spreadsheet. I would follow the steps and then I'd get a message when importing it back that no new lines were added and to abort the import.
Sorry for confusion.

It sounds like the error you're really getting says that a number of the rows contain errors and it give you the choice to proceed or abort. As the error message will say, details are saved in an "_errors" spreadsheet. Details of how to understand the errors spreadsheet and how to correct the mistakes are in the guide Manimal mentioned. Here's the relevant section: viewtopic.php?f=150&t=18864&p=233377#p233376

archibalduk wrote:

MasterMatt23 wrote:So I went to reddit to see if creating a player would work instead of editing, so far it hasn't. When I try to find the player, he's non-existent.

It might be that you haven't set the player's Classification and Job For Club (both should be set to 'Player').

MasterMatt23 wrote:What I meant from my last comment was I don't know how to run the spreadsheet. I would follow the steps and then I'd get a message when importing it back that no new lines were added and to abort the import.
Sorry for confusion.

It sounds like the error you're really getting says that a number of the rows contain errors and it give you the choice to proceed or abort. As the error message will say, details are saved in an "_errors" spreadsheet. Details of how to understand the errors spreadsheet and how to correct the mistakes are in the guide Manimal mentioned. Here's the relevant section: viewtopic.php?f=150&t=18864&p=233377#p233376

I could've sworn I set it as player. But maybe I missed it.