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

[xECK29x]

Would like to get the ability to delete Staff Awards for cleanup of awards for expired or inactive leagues.

[xECK29x]

Also question about the Extra Rules under Staff Awards, is that linking the right rules table, these look like transfer rules? I would imagine these award rules would include like minimum games played or something?

Nevermind the award rules are mixed in.

[archibalduk]

Archi any chance we could get the ability to edit Longitude and Latitude through import?

This should already be possible. In the Cities importer spreadsheet, enter "e" in the Mode column, enter the name of the city you want to edit and then enter the new coordinates in the Latitude and/or Longitude columns.

Would like to get the ability to delete Staff Awards for cleanup of awards for expired or inactive leagues.

Sure I'll add this to the next release. IIRC there's nothing else in the DB which points to Staff Awards, so it's easy to add a deletion function for that table.

Also question about the Extra Rules under Staff Awards, is that linking the right rules table, these look like transfer rules? I would imagine these award rules would include like minimum games played or something?

Nevermind the award rules are mixed in.

Yeah the Extra Rules list is a generic list of all possible Extra Rules. It would be a question for Riz as I've never looked at this in detail, but I have always assumed that certain Extra Rules can be used for multiple tables (e.g. both for Transfer Rules and for Staff Awards) - so I assume this is why they're all bunched in together.

[xECK29x]

On the Transfer Rules tab I'd love to have the same filer used on Club Competition to filer and sort the competitions associated to specific transfer rules. This will allow me to quickly sort and go through all transfer rules for specific types of leagues.

[MickMurphy]

I am trying to run the latest version of the editor and it shows an icon on the taskbar but the program never actually opens into a window. I downloaded the redistributable file and ran everything as an admin. I am currently using the 1.5.0b1555888 steam version of EHM, and using xECK29x's Premier Pivot DB v5.6.2.

[archibalduk]

On the Transfer Rules tab I'd love to have the same filer used on Club Competition to filer and sort the competitions associated to specific transfer rules. This will allow me to quickly sort and go through all transfer rules for specific types of leagues.

Let me think about how that might work. It would be rather different to the usual type of filters so it'll just need a bit of planning.

I am trying to run the latest version of the editor and it shows an icon on the taskbar but the program never actually opens into a window. I downloaded the redistributable file and ran everything as an admin. I am currently using the 1.5.0b1555888 steam version of EHM, and using xECK29x's Premier Pivot DB v5.6.2.

It sounds like the Editor is being opened either minimised, off-screen (e.g. if you have multiple screens or a virtual desktop) or with a zero window size (which I don't think should be possible). Try pressing the Windows Key + Up Arrow once or twice to see if this maximises the window.

[xECK29x]

Let me think about how that might work. It would be rather different to the usual type of filters so it'll just need a bit of planning.

Thanks! Just a quality of life ask, no rush!

[archibalduk]

Would like to get the ability to delete Staff Awards for cleanup of awards for expired or inactive leagues.

I've added this for the imminent release but do take care if deleting awards for any active leagues as I've no idea whether EHM has any hardcoded expectations for certain awards to be active (e.g. Art Ross, etc).

[archibalduk]

Here is version 1.1.1: https://www.ehmtheblueline.com/editor

This is largely the same as the previous beta version save for the additional items highlighted in bold below.

New Features:

• Added automatic repair of protected Ruling Body records (i.e. International, Asia, Europe and North America);
• Added duplicate player career history reporting via the Export Spreadsheet screen;
• Added synonym support for cities using the following format: "Database Name", "Alternate Name 1", "Alternative Name 2", etc;
• Added synonym field to the Cities screen; and
• Added the ability to delete Finance Info, Ruling Bodies, Transfer Rules and Staff Awards.

Fixes and Improvements:

• Added contract expiry date filtering to the Staff screen;
• Added support for DB versions 1016 and 1018;
• Changed the 'common' data version to 1010 in order to push the corrected flag values detailed in this changelist;
• Corrected "Candidate League for Continental Licence" extra rules from boolean to integer (Extra Rules 177-179);
• Corrected the description of the "Clubs divided North South" Rules & Structures flag to "Clubs divided geographically";
• Fixed bug where text files in the 'common' sub-folder were being erroneously flagged as incomplete and re-written;
• Fixed record navigation when deleting a record (previously the Editor would navigate two records down);
• Re-enabled counting of Professional Seasons when re-calculating player runtime data; and
• Synonym data for Clubs and Club Competitions now use the following format "Database Name", "Alternate Name 1", "Alternative Name 2", etc. Name synoynms continue to use the original synonym format which uses any column as the "Database Name".

[MickMurphy]

I am trying to run the latest version of the editor and it shows an icon on the taskbar but the program never actually opens into a window. I downloaded the redistributable file and ran everything as an admin. I am currently using the 1.5.0b1555888 steam version of EHM, and using xECK29x's Premier Pivot DB v5.6.2.

It sounds like the Editor is being opened either minimised, off-screen (e.g. if you have multiple screens or a virtual desktop) or with a zero window size (which I don't think should be possible). Try pressing the Windows Key + Up Arrow once or twice to see if this maximises the window.

I tried the Windows + Up Arrow and no luck. I am running dual monitors, not sure if that could cause a problem running it.

[xECK29x]

Synonym data for Clubs and Club Competitions now use the following format "Database Name", "Alternate Name 1", "Alternative Name 2", etc. Name synoynms continue to use the original synonym format which uses any column as the "Database Name".

What exactly is the "Database Name"? I have a 500+ clubs synonym file going to have to add something in front of all the entries is going to be a bit of work.

[archibalduk]

What exactly is the "Database Name"? I have a 500+ clubs synonym file going to have to add something in front of all the entries is going to be a bit of work.

It's this stanza format you requested:

Ok so all the teams in those stanzas are linked together? IMO it should be 'Name to Use','AKA','AKA','AKA' if that makes sense?

So the first name in the list should be the club's name as it appears in the database (i.e. the database name) and then each name appearing after it is the AKA name.

E.g. "Arizona Coyotes,Phoenix Coyotes,Insert another team name" here would add "Phoenix Coyotes" and "Insert another team name" as synonyms of Arizona. However, if you already had a Phoenix Coyotes in the DB, these synonyms would not appear as synonyms for Phoenix because only the first name in the list is used to link to a team in the database.

If you've changed your mind on this format then I can easily change it back to how it was before.

[archibalduk]

I am trying to run the latest version of the editor and it shows an icon on the taskbar but the program never actually opens into a window. I downloaded the redistributable file and ran everything as an admin. I am currently using the 1.5.0b1555888 steam version of EHM, and using xECK29x's Premier Pivot DB v5.6.2.

It sounds like the Editor is being opened either minimised, off-screen (e.g. if you have multiple screens or a virtual desktop) or with a zero window size (which I don't think should be possible). Try pressing the Windows Key + Up Arrow once or twice to see if this maximises the window.

I tried the Windows + Up Arrow and no luck. I am running dual monitors, not sure if that could cause a problem running it.

Yes that could well be the issue but it's hard to say with any certainty. Windows + Left/Right Arrow moves windows to different screens so you could try that.

I will tweak the way in which the Editor generates the window on the screen but I cannot guarantee whether this will have any effect.

[xECK29x]

So the first name in the list should be the club's name as it appears in the database (i.e. the database name) and then each name appearing after it is the AKA name.

E.g. "Arizona Coyotes,Phoenix Coyotes,Insert another team name" here would add "Phoenix Coyotes" and "Insert another team name" as synonyms of Arizona. However, if you already had a Phoenix Coyotes in the DB, these synonyms would not appear as synonyms for Phoenix because only the first name in the list is used to link to a team in the database.

If you've changed your mind on this format then I can easily change it back to how it was before.

Ahh ok yea that is what I have been using this whole time, it looks like Synonyms are not working for me. I'll email you.

[archibalduk]

All received. I'll take a look hopefully tomorrow evening.

[archibalduk]

So the first name in the list should be the club's name as it appears in the database (i.e. the database name) and then each name appearing after it is the AKA name.

E.g. "Arizona Coyotes,Phoenix Coyotes,Insert another team name" here would add "Phoenix Coyotes" and "Insert another team name" as synonyms of Arizona. However, if you already had a Phoenix Coyotes in the DB, these synonyms would not appear as synonyms for Phoenix because only the first name in the list is used to link to a team in the database.

If you've changed your mind on this format then I can easily change it back to how it was before.

Ahh ok yea that is what I have been using this whole time, it looks like Synonyms are not working for me. I'll email you.

I took at look and I'm getting a whole bunch of different club errors than you but I suspect that this is because you're using a different club synonym file compared with what you sent me. Looking at the specific error that you flagged in your players_errors.xlsx file, it looks like there is a blank space immediately prior to the club name. If you open up your original players.xlsx file and click into one of the club fields, you'll see the blank space at the beginning of the name. Do a search and replace in Excel in order to replace the blank space with nothing and this should hopefully remedy it. I thought that the Editor automatically strips out blank spaces like this so I'll take a look to see if anything is being missed here. Removing the blank space allowed "HK 36 Skalica U20" to be processed successfully.

You can check whether a synonym has been successfully linked to a club by finding the club in the Editor and then going to the Preferences tab on the Clubs screen. You'll then see a Synonyms field in the bottom right which lists the linked synonyms.

[xECK29x]

Yea the synonym file that comes with the editor does not really align well to my DB anymore, a lot of team names have changed since that was first built (looks like an on older TBL). I am making sure I maintain my own sets of files to align to modern Pivot/TBL, and I was planning on sharing them with you once I had them fairly built out. I actually lost a large amount of this work as I accidentally overwrote the files with the ones fro m the 1.1.1 editor .

[archibalduk]

Urgh that's frustrating. Something like this would actually be quite a good Github project as you could invite others to help input data and it's all backed-up.

[xECK29x]

Urgh that's frustrating. Something like this would actually be quite a good Github project as you could invite others to help input data and it's all backed-up.

Yea I thought I had Google Backup & Sync set for that folder, at least I had shared the files two weeks prior with another researcher so I had something.

[xECK29x]

I have a pie-in-the-sky Wishlist item, it would be terrific if the Editor could auto-calucate the "Two-way Percentage" value from an entered value instead of me doing that calculation myself. I could take the value from CapFriendly and put it in there and the Editor auto-calculates the percentage (rounded up or down), this would save me a ton of time and allow me to just quickly add them in as I do updates on players. Also I would imagine adding import sheet support for Contract Details is an Editor 2.0 item due to the amount of potential work involved?

Example contract: https://www.capfriendly.com/players/jack-drury

I put in 70000 and the editor calculates and entered 8% in the field. Bonus points for having a button that just does this auto-magically on the Basic Data tab next to the Annual Salary .

[archibalduk]

I'm always up for bonus points!

Leave it with me and I'll see what I can do.

[xECK29x]

Small thing I found. For Auto-Set Potential Value, it appears is the CA is set to 0 (not set) it's setting the World Rep to 5, can you correct this so it sets it to 0 (correcting this behavior across the DB)?

[xECK29x]

Another small ask, can you create an error condition for players with multiple primary position values (multiple 20 values)?

[archibalduk]

Just a small update now available: https://www.ehmtheblueline.com/editor

Hopefully this fixes the inconsistent matching up of synonyms in the database but it will need more people to test it out given how sporadic the issue is. It seems to be fixed from my testing at least. I'll take a look at the error condition for multiple positions and the two-way salaries for the next release.

CHANGELIST: VERSION 1.1.3 (11-July-2021)

Fixes and Improvements:

• Fixed synonyms not always linking with a team/competition/etc in the database; and
• World Reputation is now set to zero where a player has a zero Current Ability when auto-setting Reputation using the xECK29x algorithm.

[TBIF]

Not sure how viable it would be but I'd love an option that if you have "filter by club" active and hit "Add New" staff it would auto set to that club so you don't have to clear filters in the Editor.