EHM The Blue Line

Yes that is a bit of an issue because it should be able to find enough Swedish pro clubs to take any spare CHL-specific UIDs. Potentially you could end up with a CHL UID being allocated to a non-junior team but that's all that'll happen. So it's an easy fix once I've figured out the issue.

I'll take a look and will let you know.

archibalduk wrote: Sun Feb 07, 2021 4:02 pm Version 0.4.9 of the Editor is now available here: viewtopic.php?p=206841#p206841

A full changelist is set out at the end of this post. I was planning on adding some more features before release but the UID bug identified by ideawithoutamind above added some urgency to this release. The bug relates to importing data using spreadsheets which wasn't properly incrementing the UID tracker with each new item imported. So you'd end up with imported entries having duplicate UIDs. This bug is now fixed but you'll need to use the UID Validator to repair any existing duplicates.

Most of what is included with this release are feature requests from ideawithoutamind and xECK29x. There are additional requests which I haven't yet incorporated into the Editor but I hope to do so for the next release, subject to any other bugs/issues which might require a more urgent release.

The Editor now incorporates First Name and Second Name importing using spreadsheets and you can get the templates using the usual Import Spreadsheet -> Create Templates function. The template is very simple with just a 'Name' column and a 'Nation' column. Simply enter the text of the name and its nationality in the two columns. Any duplicate names will not be imported, so don't worry about importing names where you're not sure if they already exist in the database. A name is considered a duplicate of another if they are both spelled exactly the same (this is case sensitive) and the nation is the same. Names which are spelled the same but have different lowercase/uppercase letters are not considered duplicates - e.g. "da Costa" is not a duplicate of "Da Costa". One other thing to keep in mind is that the spreadsheets can only add names; it isn't possible to delete or edit names.

I'm now hosting the Editor on GitHub in addition to OneDrive (links can be found here). GitHub is a nice way of keeping a backup of each version with changelists, so I'm going to host the Editor there in addition to OneDrive. Unfortunately I cannot make the source code public, so the code remains on a separate private GitHub repository for now.

CHANGELIST: VERSION 0.4.9 (07-February-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• First name and second name importing via the Import Spreadsheets function.

Fixes and Improvements:

• Added a sanity check when exporting .ehm files where invalid Transfer Rules ids have been set in the Editor;
• Added a filtered row count to the bottom of each editor screen;
• Added date of birth, status and duplicate count columns to the Player Rights editing screen;
• Added "[inactive]" to the end of club names in the editing screens and when importing non-research spreadsheets of players & staff and clubs;
• Added jersey number to the sub-heading on the Players & Staff editing screen;
• Auto-set Potential Ability function no longer modifies players with a zero Current Ability rating;
• Fixed a bug when exporting club research sheets where the date of birth of alternate captains would be listed twice;
• Fixed a bug when importing spreadsheets where the UID value would not be correctly incremented;
• Fixed a bug with senior and junior national teams being mixed up when importing spreadsheets;
• Jersey numbers are now initialised with zero (instead of -1) as the default value;
• Pass Tendency calculation can now be accessed via the Tools menu when viewing a player and via People -> Players & Staff -> Mass Edit; and
• The UID validator now re-numbers all club UIDs and assigns CHL-specific UIDs to clubs with a continental licence.

NOTE: Version 0.4.8 was an internal release. The above changelist includes changes incorporated in version 0.4.8.

Wow! Thank you so much! Awesome work, as always!

xECK29x wrote: Sun Feb 07, 2021 8:15 pm Hey Archi I noticed this in the log when running the validator against the main working copy of the DB, is this something we should be concerned about? I assume it means just allocate licenses to 7 more clubs?

15:14:14: "WARNING: Insufficient clubs either (i) with a Continental License or (ii) being a Professional Swedish club for the purposes of allocating CHL-specific uids (7 additional clubs required)."

So it looks like there are no clubs with Continental Licences allocated via the Clubs screen in your DB. Presumably this is intentional?

The Editor tries to allocate any spare CHL reserved UIDs to professional Swedish clubs but, as there are no clubs with continental licences, the number of spare reserved UIDs outnumbers the number of Swedish professional teams in the database. Hence the 7 spare UIDs. I tested the function with an earlier version of the DB which did had licences allocated which is why I wasn't getting this issue. I have now tweaked the Editor so that it will allocate any spare CHL reserved UIDs to any professional teams from Finland, Germany and Sweden which gives provides more than enough capacity in the event there are no licences allocated. I'll try to get the fixed version of the Editor online tomorrow night.

archibalduk

Any chance we could get a "Zero Out Attributes" option on a players or a non players page?

Sure - I'll add that.

Maybe the most niche error you'll find but if you deactive the swiss national league you get a nation index error

TBIF wrote: Sat Feb 13, 2021 3:28 am Maybe the most niche error you'll find but if you deactive the swiss national league you get a nation index error

How did you deactivate the league? Did you do anything to the nation settings? Is the game or the Editor giving you this error?

@archibalduk

Moved my 00 Mod over to TBL/Pivot 2020 release, better UID allocation, club selection etc. Just going through and de-activating league rules, I got everything minus national stuff, olympics etc to work except for the Swiss league. When loading up a game it gets to club rosters I believe and freezes/grey screens with a Nation Index: not selected nation error, I'll try and replicate it and screen it.

Hey Archi,

Can you swap Auto-Set Pass tendency and Strength? I've built up quite the muscle memory to click Auto-Set Strength as the top one in that list .

I think it would be convenient to have the ability to make all teams playing in inactive leagues 'inactive' themselves. This would greatly help clean up a database.

Javs wrote: Sat Feb 13, 2021 11:45 pm I think it would be convenient to have the ability to make all teams playing in inactive leagues 'inactive' themselves. This would greatly help clean up a database.

Great idea - I'll add it to my list.

Searching in the Editor by : Role {None} only returns Goalie: Mixed

Something that I would use personally that I think would be easy to implement is a copy and paste on the player attribute page. I do a lot of my player profiles through the editor rather than Excel and this would let me tackle a swarm of similar players at the same time just making minor adjustments here and there.

Hey Archi,

I'm trying to open one of BK's 32X DBs and it's locking up in the editor under finances, I think this may be an Editor bug as this DB is functional.

https://www.dropbox.com/s/ffjqwgbtp0mdo ... A.zip?dl=0

Thanks!

xECK29x wrote: Sun Feb 21, 2021 12:56 pm Hey Archi,

I'm trying to open one of BK's 32X DBs and it's locking up in the editor under finances, I think this may be an Editor bug as this DB is functional.

https://www.dropbox.com/s/ffjqwgbtp0mdo ... A.zip?dl=0

Thanks!

It sounds like that old bug where the database version would get corrupted. Try opening it up in the Database Settings Editor and make sure that the Created With Version and Database Version are set to 1025. If they're not, change them to 1025 in the Database Settings Editor and click on Save.

archibalduk wrote: Sun Feb 21, 2021 4:21 pm It sounds like that old bug where the database version would get corrupted. Try opening it up in the Database Settings Editor and make sure that the Created With Version and Database Version are set to 1025. If they're not, change them to 1025 in the Database Settings Editor and click on Save.

Still locks up with this specific DB

Ok I'll try and take a look tonight. If it's crashing at Finance Info and it's not the version issue then it's very odd that it's working in the game.

xECK29x wrote: Sun Feb 21, 2021 11:26 pm

archibalduk wrote: Sun Feb 21, 2021 4:21 pm It sounds like that old bug where the database version would get corrupted. Try opening it up in the Database Settings Editor and make sure that the Created With Version and Database Version are set to 1025. If they're not, change them to 1025 in the Database Settings Editor and click on Save.

Still locks up with this specific DB

When I opened up the DB in the Settings Editor, the Created With Version and Database Version were wrongly set to 1018. You just need to change them both to 1025, hit 'save' and it'll load fine in the Editor.

archibalduk wrote: Mon Feb 22, 2021 7:36 pm When I opened up the DB in the Settings Editor, the Created With Version and Database Version were wrongly set to 1018. You just need to change them both to 1025, hit 'save' and it'll load fine in the Editor.

Weird I thought I did it right, I'll try again

xECK29x wrote: Mon Feb 22, 2021 7:43 pm

archibalduk wrote: Mon Feb 22, 2021 7:36 pm When I opened up the DB in the Settings Editor, the Created With Version and Database Version were wrongly set to 1018. You just need to change them both to 1025, hit 'save' and it'll load fine in the Editor.

Weird I thought I did it right, I'll try again

I also did this with one of his db's. I opened in an older version of the editor, saved as 1025, and then re-opened in a more recent version and it worked fine.

I apologize if any are repeat requests, just keeping all thoughts together. After working with this a bit more and through a series of different databases. I did a tab by tab breakthrough of requests/improvements that would be helpful. Happy to test anything as well. I just noticed you hopped on the discord server a few days ago, I'm penguinrevolt there if you want to reach out.

Wishlist
Import Exporting. Big request, but an additional "advanced" import/export of spreadsheets, using the UID. I have been playing around with the default database a bit, and especially team names, have noticed there are a lot of duplicate team and arena names. This would be used more for editing existing data than data importing.
Importing Exporting. Exporting / importing (leagues, teams) Colours by HEX. If matching hex, assign that colour, if a hex does not exist then create a new colour by hex name. *may need to filter so same hex is not added multiple times. Helpful for porting teams/settings from one db to another.
Importing Exporting. Export set. Exporting City, Arena, Teams, and Leagues as a set of xlsx files to a folder. Used for a quick export of a whole league (to swap between databases) to edit all the related pieces without having to export/filter each set for each.
Club > Affiliation. Filter those with errors. They are highlighted, but cannot filter just the errors
Club > Clubs. Add Filter by playable leagues, filter by State, add player count in header?
Competitions > Club Competition. Filter by playable league, add team count in header. (add team/ player tab*see quick export from this table)
Competitions > Rules and Structure > Stages > Rules. Team Picking preview, see what teams would be picked using the current set of rules* not sure if possible, but figure I'd ask.
Schedule Template. Warning if league doesn't have Comp Uses Real Schedule Template set
Transfer Rules > Extra Rules. Import/Export rules
People > Staff Awards. Import/Export


Lower requests
Import Exporting. *From within tabs, a quick export of players, teams from club competitions
Import Exporting. *From within tabs, a quick export of players, teams, leagues from Geographical locations
Club > Arenas. Counts* (see cross referencing request, but just the number of linked clubs, nations to start would be nice)
Competitions > Rules and Structure > Flags > Comp Uses Real Schedule Template. In application check if template exists and teams/divs match template. *lower priority, but nice to have
Ruling Body > Add tab/count of leagues using these sets of rules.
Stage Names. Counts and/or cross referencing to which leagues/tables are cross referenced
Transfer Rules. Counts of cross referencing
Geography > Cities. Count of cross referenced teams, players, arenas
Geography > Continent. Count of cross referenced teams, players. Add quick export of players, or teams based on continent
Geography > Nations. Count of referenced cities, teams, players. Add quick export of players, or teams based on Nation
Geography > States. Count of referenced cities, teams, players. Add quick export of players, or teams based on State
Colours. *See import/export request re: colour
Colours. Colour name consolidating by hex. Remove duplicate HEX colours.



Thanks again so much for your work! Just adding these here so I don't forget them! I understand many likely wouldn't be available until a later version, and that's fine, just adding my thoughts to reference!

Thanks - some really good ideas here! Keep the suggestions coming!

I can't promise what I can get into the Editor v1 for technical reasons, but much/all of what you say is perfectly feasible for v2 and some of it is already there.

Just a very minor update to the EHM Editor: https://www.ehmtheblueline.com/editor

CHANGELIST: VERSION 0.5.1 (06-March-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added spreadsheet exporting for use with the EHM Jersey Generator; and
• Added support for database version 1034.

Fixes and Improvements:

• Adjusted the UID validator to allocated CHL-specific UIDs to Finnish, German and Swedish professional clubs where there are no clubs with a continental licence.

NOTE: Version 0.5.0 was an internal release. The above changelist includes changes incorporated in version 0.5.0.

Hello,Why I can't click on the Wizard button at the rules and structure???

Running into a weird issue where I'm trying to mass-update Pass Tendency, it looks like this value may be getting ignored on import. I will provide a sheet via email.