EHM Editor v2: Development thread

[archibalduk]

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.

[archibalduk]

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.