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

[archibalduk]

The link to the 2007 Updater is down/dead (?):

Ah apologies - OneDrive changed their URL format and the old links were invalidated. Here's a fixed link: https://1drv.ms/u/s!AsXFKQMOdPqghWP4bti ... R?e=2G9SbS . However, having looked at it, it probably isn't as helpful for your city editing.

As you've already figured out, you need to put an "a" in the Mode column. The Mode column is named "Mode (e)" which means that it will default to "e" (i.e. edit) if you leave the cell blank. As the cell is blank, it was trying to find Kabul and edit it. By putting "a" in the Mode column, it will add Kabul rather than try to edit an existing entry. The reference to "City" in the error spreadsheet means that it couldn't find that city to edit.

[bäckström19]

Ho i can chnage with that editor something in a save game?
Is there another save game editor, there is one, but since 2 days it doesn't work anymore.

[xECK29x]

Ho i can chnage with that editor something in a save game?
Is there another save game editor, there is one, but since 2 days it doesn't work anymore.

You can't, we have to wait for EHM Assistant to be updated.

[xECK29x]

I would like a tool that would help identify duplicate career history entries (where year + all stats are same but teams/leagues are different) this would help clean up older entries with the wrong teams or leagues linked.

[xECK29x]

Also would it be possible to add Contract Start/End Date to the Player and Staff Roster tabs under clubs?

[archibalduk]

Also would it be possible to add Contract Start/End Date to the Player and Staff Roster tabs under clubs?

If you click on the Club Contract tab at the bottom of the Player/Staff Roster tabs then you'll see the start and end dates.

I'm working on the next release but there's quite a lot to add, so it may take a little while. I'll initially release it as a beta for testing because various of these features are fairly involved to add.

[archibalduk]

This is probably a big ask, and I know adding more to the staff filter slows it down, but being able to filter on contract end date would be a big help

Do you want to filter by year or precise date?

[xECK29x]

Do you want to filter by year or precise date?

Precise, it would help with cleanup work.

[xECK29x]

Small bug/request

In Staff Awards if there is free text entered into the Forename or Surname (not linked to an ID) you cannot clear it. It would be good to have a right click open to "clear value" on that screen for cleanup work.

Nevermind I just have to select "none" under person and it clears it.

[xECK29x]

There appears to be an issue with 'Has Alternative Dates for Olympic Years' flag on Playoff rounds, I had issues getting that checkbox to activate in the editor and it looks like it is not working when checked, works fine for Regular Season though which is strange. Will share test DB over email.

[archibalduk]

I suspect the checkbox isn't "sticking". I imagine it might work if you press Tab after checking/unchecking it. I'll take a look...

[archibalduk]

Found an issue with exporting from a database and importing/exporting using the Jersey Generator 1.0.0 beta 6.

Files are Exported as: FirstName_LastName_1.1.2000.png
They should have underscores for the dates: FirstName_Lastname_1_1_2000.png

Workaround, using the Player Export then in Excel, Find ".", replace with "_" in the birthdate column, and Jersey exporter exports in proper format.

I've fixed this in the Jersey Generator which I'll try to release sooner rather than later.

[xECK29x]

I suspect the checkbox isn't "sticking". I imagine it might work if you press Tab after checking/unchecking it. I'll take a look...

Yea that's how I got it checked but it looks like it may just be visual, it's having issues with any stage outside of stage 1. Will send DB shortly.

[archibalduk]

I would like to request to have a shortcut for deleting one entry in a table(for example one game/date in a schedule template) instead of having to right-click it and then clicking delete. I have no idea if this is possible but it would help a lot. Thanks for this awesome editor and all work you do.

I've been looking into this one but it's looking unlikely for Editor v1 because of the way tables work in Qt. The only way I've been able to add a delete button is to add a dummy column to the table in which the delete button can be placed. However, I would need to go through every data model/table and manually add this additional column which is a big project. I'll keep looking to see if there's any way around this but I suspect this might have to wait until Editor v2.

[archibalduk]

I suspect the checkbox isn't "sticking". I imagine it might work if you press Tab after checking/unchecking it. I'll take a look...

Yea that's how I got it checked but it looks like it may just be visual, it's having issues with any stage outside of stage 1. Will send DB shortly.

I have dropped you an email but, for the benefit of anyone else interested: The setting is definitely checked in the database, so it's not a case of the Editor not "pushing" the value to the database. This can be verified by navigating to another record and then back to the affected league or by reloading the database. If the setting isn't pushed then the checkbox would revert back to the original setting. It can also be verified by clicking on Export -> Export Text Report (the button is located in the bottom right of the Rules & Structures screen). This will show you the data pulled directly from the database.

[xECK29x]

I have dropped you an email but, for the benefit of anyone else interested: The setting is definitely checked in the database, so it's not a case of the Editor not "pushing" the value to the database. This can be verified by navigating to another record and then back to the affected league or by reloading the database. If the setting isn't pushed then the checkbox would revert back to the original setting. It can also be verified by clicking on Export -> Export Text Report (the button is located in the bottom right of the Rules & Structures screen). This will show you the data pulled directly from the database.

Thanks for confirming! Will do more digging

[xECK29x]

Neverminded there is what I was requesting!

[TBIF]

Request but not sure if possible:

Having a way to see if Arenas/Cities are being tied to anything else. Whether to a club or player.

[xECK29x]

Having a way to see if Arenas/Cities are being tied to anything else. Whether to a club or player.

+1, would be good to have a count of times used (similar to the count you see looking at a specific first/last name).

[djskek]

I tried to adjust the player budget. Even with the new patch and editor, the data is still not adopted. Are there any other options?

I found it. Great, now you can finally adjust the budget.

[archibalduk]

Having a way to see if Arenas/Cities are being tied to anything else. Whether to a club or player.

+1, would be good to have a count of times used (similar to the count you see looking at a specific first/last name).

I'll see how doable this is for Editor v1. Definitely doable for v2 and in fact already implemented in part.

I'm doing my best to finish off the current work in progress of Editor v1 which I'll be releasing as a beta initially given that some of the new features will need more testing (e.g. the contract expiry date filtering, city synonyms and deleting finance info/transfer rules/etc).

[archibalduk]

Historical club names are now reverse sorted by ID; and

Just a note on this want to make sure its expected behavior, I just added two entries for a club and it added them as ID 2 and 3 (and I guess moved all the others down as I don't see duplicate IDs) when I would have expected it to add these as new IDs (which would have been 238 and 239 in this DB).

Is your work-in-progress DB on Dropbox? If so, I'll take a look at that version. I tested the ordering using an initially blank historical club names list and so perhaps the behaviour is different if existing names are present in the DB at loading.

In any event, it won't cause any issues as that table doesn't actually use IDs. The IDs are only present for the purposes of allowing the table to be sorted in reverse chronological order - they're not actually saved to the DB.

I haven't been able to reproduce this issue and, given that it is purely cosmetic, I'm going to leave as-is.

[archibalduk]

Here is a BETA of upcoming version 1.1.0: https://github.com/archibalduk/Eastside ... 1.0-beta.1

As mentioned above, THIS IS A BETA AND IS NOT SUITABLE FOR USE ON PRODUCTION DATABASES. I'm sharing this because some of the changes are relatively significant and in case anyone else wants to test these. I have done some limited testing so far and will be doing further testing over the next few days. Please continue to use v1.0.2 for any master/production databases.

Most of the changes are self explanatory but there is one item I wanted to flag: I noticed in the Pivot Rosters that one of the protected Ruling Body entries had been erroneously changed from "-International-" to "Europe". The first four entries in the Ruling Bodies table (id 0 = International, id 1 = Europe, id 2 = North America and id 3 = Asia) shouldn't have their Type, Competition, Nation or Continent values changed from the default values - and for this reason, these values are grey out for these entries in the Editor. However, I noticed in the Pivot Rosters that id 0 had changed from International to Europe, resulting in two Europe entries in the table. There was an additional International entry but this was at something like id 45 so it wasn't in the correct place. Given that the protected entries have those protected values greyed out in the Editor, I suspect that importing an .ehm file might have resulted in the International entry being overwritten with Europe data.

I have added an automatic validation check to the Editor which is applied upon loading, importing and saving a database in order to fix the issue. However, you will need to delete any duplicate International entry from the Pivot database (you can tell which is the unprotected entry because it won't have the protected values greyed out - and it won't let you delete a protected entry in any case). You should also check the Ruling Body setting for every playable league in case any point to the wrong International or Europe entry. Obviously I'd highly recommend making this fix once the final v1.1.0 Editor is released given the current beta status.

Something I realised I have overlooked is adding a list of synonyms to the Cities editing screen. I'll add this for the final release of v1.1.0.

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; and
• Added the ability to delete Finance Info, Ruling Bodies and Transfer Rules.

Fixes and Improvements:

• Added contract expiry date filtering to the Staff screen;
• Added support for DB versions 1016 and 1018;
• Corrected "Candidate League for Continental Licence" extra rules from boolean to integer (Extra Rules 177-179);
• 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".

[xECK29x]

Thanks Archi, good catch on the Ruling Bodies I'll get those fixed up in the V6 beta.

[TBIF]

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