EHM The Blue Line

P.s. I can't remember if saving is still disabled in v2 but if it's not, please don't click Save in v2. It'll corrupt your database.

This is probably of limited interest but Alpha.3 of EHM Editor v2.0.0 is now available here: https://github.com/archibalduk/Eastside ... lpha.3.zip

Three really important points to flag:

• Whatever you do, DO NOT CLICK ON SAVE OR SAVE AS. It will likely irretrievably corrupt your database. Please only use the Editor for viewing/exporting/testing.
• The Editor takes a few seconds to load. I need to look into why this is. It will either be because of the new theme manager which applies the light/dark mode style or because the Editor now includes the Chromium web engine (see point below). I'll see if I can add a splash screen whilst the Editor loads up.
• The Editor is now packaged with the Chromium webengine as this is used to generate the PDF Database Report mentioned below. Essentially the Editor generates the report in html/css which is then printed to PDF using Chromium. This has substantially increased the overall size of the Editor to just over 100mb.

A lot has changed since the release of Alpha.2 back in March 2022. I've tried to put together a summary of the main changes below. A lot of work has been on behind-the-scenes stuff which I haven't included below.

KNOWN ISSUES

• The Playable Leagues screen has not yet been implemented and it currently lists lots of zeros;
• Dark mode is working but needs polishing;
• There's still an issue with dates when importing spreadsheets. I think this is due to a difference between Windows 10 and 11;
• Mass editing large volumes of Staff data is still slow;
• Certain input tables require polishing/tidying. Their design is partly dependant on how I end up laying out the Playable Leagues editing screen; and
• Rebuilding the database doesn't yet update UIDs which means Flags and the list of divisions in Schedule Templates go out of sync.

SUMMARY OF CHANGES

General

• Dark mode is working but needs polishing;
• General performance improvements when rebuilding the database (multi-threading);
• Implemented caching of certain dynamically created fields (e.g. draft and league rights filtering of staff) which substantially improves filtering performance);
• Database Report/Guide PDF generation via Database -> Database Report. This generates what is intended to be reference guide for the database. Currently it creates a section detailing nation-by-nation data (e.g. player/non-player counts and league lists) and I want to eventually include league and team/depth chart sections. The formatting/layout is a work in progress;
• Various user interface tweaks; and
• Various minor bugfixes and a crash fix.

File / Spreadsheet Handling

• Version 1.5 database format is supported;
• Database and spreadsheet files can be dragged and dropped into the Editor;
• Databases can be closed and a new one opened in the Editor;
• Multiple instances of the Editor can be run at the same time without conflict;
• The entire database can be loaded and saved;
• Minor performance improvements when exporting to csv (multi-threading);
• Csv spreadsheets can be imported using Utf-8 (this must be enabled via File -> Settings;
• Csv importing automatically detects Utf-8 when importing; and
• Csv supports text qualifiers in order to allow commas or semi-colons in text without breaking the column layout.

Editing

• Added all editing screens other than Playable Leagues (aka Rules & Structures);
• All filters from Editor v1 are implemented (e.g. draft and league rights filtering of staff);
• All mass editors from Editor v1.1.8 are implemented;
• Most database validation functions from Editor v1 are implemented other than in respect of UIDs; and
• Club competitions include assigned club counts and assigned club filtering.