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

[archibalduk]

I have a new version of the Editor pretty much good for release but there is one bug which I just cannot figure out: Creating a new active team and adding it to a league causes a crash. Regardless of how simple the league structure is, I still get a crash (I have been trying the BeNeLiga as it draws clubs straight from the Club settings). I'm going to ask Riz about this one because I'm not getting anywhere with it...

It turns out to be a bug with the game which will now be fixed with the next version of EHM. In the meantime, any active team must have a Reputation set and must have at least one player.

There is another bug/quirk with the game: Any inactive team must have their Nation set to None. Otherwise it can cause the game to crash when it generates exhibition games during game start up. This will also be fixed for EHM v1.5. In the meantime, I'm going to add some validation to the Editor to ensure inactive teams have no nation set.

[Alessandro]

Archi - I was wondering. Is there any way to delete retired players?

[archibalduk]

Not yet, no. It's a relatively complex task which is why I have been leaving it until later. I actually got it slightly wrong once with the Updater which messed up all of the Liked/Disliked Staff settings for the clubs (we had to reset/erase all of those for the clubs in the TBL Rosters a few years back). Hence I want to take my time on that one!

[wildcat62]

When I import a spreedsheet, it loading indefinitely.... Someone can help ?

Having this same issue. Have only received one error message while trying to import a club competition sheet which said that there was no identifier in cell A1 or something along those lines.

EDIT: Just had a thought - I've been making changes to the csv in Excel, do I need to be doing it in a dedicated csv editor instead?

[archibalduk]

When I import a spreedsheet, it loading indefinitely.... Someone can help ?

Having this same issue. Have only received one error message while trying to import a club competition sheet which said that there was no identifier in cell A1 or something along those lines.

EDIT: Just had a thought - I've been making changes to the csv in Excel, do I need to be doing it in a dedicated csv editor instead?

When I import a spreedsheet, it loading indefinitely.... Someone can help ?

The solution might be to wait for the next version. I fixed an issue with large spreadsheets which would take a very long time to import - I expect your issue is the same.

[Javs]

What is the spread factor under finance info?? Example the NHLs 'Wage Budget Spread Factor' is 3?

[Alessandro]

What is the spread factor under finance info?? Example the NHLs 'Wage Budget Spread Factor' is 3?

It's a multiplier.

[Javs]

What is the spread factor under finance info?? Example the NHLs 'Wage Budget Spread Factor' is 3?

It's a multiplier.

Well I figured that, but what exactly does it effect in the game?

[Alessandro]

I don't remember on the top of my head, it is reputation of the player multiplied by the spread factur divided by the level of player contract as set up in the finances, something like that.

[Asher413]

First- thank you, thank you, thank you Archi for the editor (and Riz for continuing to allow us to stretch the game and add features!)

Second- Sorry if it's here, I didn't find it on my first readthrough last week: Is it possible after editing an EHM1 database with the editor to go back and still edit things on the import_config/extra_config? Let's just say some moron was working on his 1972 db and forgot to turn off the salary cap, change minor league affiliations from a 30 team NHL to a 12 NHL and I'm sure a few other errors before editing the converted database...

In a related note- how much data is exported under the export data? Trying to figure how much this first run is salvageable vs. learning how to do it faster next time .

[archibalduk]

First- thank you, thank you, thank you Archi for the editor (and Riz for continuing to allow us to stretch the game and add features!)

Second- Sorry if it's here, I didn't find it on my first readthrough last week: Is it possible after editing an EHM1 database with the editor to go back and still edit things on the import_config/extra_config? Let's just say some moron was working on his 1972 db and forgot to turn off the salary cap, change minor league affiliations from a 30 team NHL to a 12 NHL and I'm sure a few other errors before editing the converted database...

Ha! You cannot edit the import_config because it is only relevant when importing the data from EHM 2007 format (you can delete the import_config afterwards). The other config files are still used however. So you can tweak those as much as you like.

In a related note- how much data is exported under the export data? Trying to figure how much this first run is salvageable vs. learning how to do it faster next time .

All data is exported (but within the confines of the tables that are exportable at present). However, not all data can be re-imported. You'll need to export the "(Research Sheet)" spreadsheets as these can be imported straight back into the database (there are only a couple of these research sheets at present however).

[archibalduk]

Here is a new release (version 0.2.1): http://www.ehmtheblueline.com/forums/vi ... 99#p228699

My original plan was to add some more features before release but I felt it was important I release now because of a couple of critical bugs which were uncovered (which would hamper the TBL Rosters research work). As is often the case, the amount of spare time I have is very low and this has reduced my ability to test the Editor. Whilst all fixes have been tested by me, there is of course the chance I have overlooked something or broken something else. Please do continue reporting any bugs and I'll take a look. A big thank you to Alessandro and Named who have reported many of the bugs which are fixed in this update.

The Rules & Structures import screen now has more options. Specifically, you can choose whether to overwrite existing data, not import at all or link to existing data. Hopefully this gives a little more flexibility when sharing updated playable league settings. I want to expand the options further, but I am doing it in small steps given its relative complexity. For this reason, I would highly recommend exercising caution when using this function. It has worked fine in my tests but there is of course the chance I have overlooked something.

Runtime data remains and issue and I'm not convinced my changes in the new release really improves things. I will be discussing this with Riz so that I can hopefully get things working in time for next season's first release of the TBL Rosters.

CHANGELIST: VERSION 0.2.1 (08-Jul-2017)

New Features:

• Added Club Records validation (re-ordering of the table and removing unlinked items);
• Added "Set club as inactive" button to the Clubs editing screen;
• Added validation of clubs so that any club without a league set will have its nation cleared; and
• Expanded the Rules & Structure importing with new options to create new items or overwrite existing items.

Fixes and Improvements:

• Added "Do not allow too many columns" setting to the Importer;
• Added move item up/down buttons to the Stages sub-screen of the Rules & Structures screen;
• Creating a new club no longer results in the creation of an unassigned Club Records item;
• Dialog windows now fully syncronise with the underlying data models when items are added and deleted;
• Enabled negative Stage numbers on the Stages sub-screen (the lowest possible negative stage number is -5);
• Fixed blank rows occasionally appearing in _error csv files;
• Fixed default Job For Club value for new staff appearing as a non-existent value rather than 'Invalid';
• Fixed Importer errors when attempting to add new items with the "Prevent Duplicates" setting enabled;
• Fixed "Ø" which was not correctly being correctly matched against in text strings;
• Fixed potential invalid pointer crash when deleting an item from the Rules & Structures screen;
• Fixed the incorrect error message being displayed when the Importer detects too many columns of data in a spreadsheet;
• Rules & Structures can now be deleted;
• Runtime Data: Added minimum threshold of 30 GP (goalies) and 40 GP (skaters) when counting NHL seasons played (playoff games are no counted at present);
• Runtime Data: Current club and league stats are now based on Club Playing For instead of Club Contracted;
• Runtime Data: Temporarily disabled the Professional Games Played statistic (i.e. all players are set as zero);
• Significantly improved the speed of loading and saving spreadsheets;
• The Author field on the Database Header screen now becomes read-only once text has been entered; and
• The Importer now correctly recognises the "[None]" command.

[andda715]

Great work as always!

"Enabled negative Stage numbers on the Stages sub-screen (the lowest possible negative stage number is -5);"

What do negative values on Stage numbers mean, i.e. how can we use them when editing?

Thanks,
Anders

[archibalduk]

I cannot remember exactly how they work. However, Alessandro knows and so hopefully he can explain.

The Editor shows a modified value so that the stage numbers are easier to understand. I believe I have set up the negative numbers correctly (i.e. so the value displayed in the Editor corresponds to the intended value) - but it is well worth taking small steps with this in case I got the maths wrong.

[Alessandro]

They are used to prevent stages to wait for another stage to end when it's not relevant.
EG you set a relegation round before playoffs end, then the stage won't wait th end of playoffs.

[andda715]

Great, thanks! That explains a lot.

[archibalduk]

I noticed yesterday that XML spreadsheet importing is slightly broken (it isn't picking up the header data). I'll fix this for the next version. In the meantime, CSV and XLSX are working. XLSX is my recommended format because it is more portable and easier to generally easier to use than XML or CSV.

And I can't get again "retire" to be working
What should I use? I tried both _retire and _retired but it gives me a "job for club" error

You need to enter "_retire" in either of the Club Playing or Club Contracted column (it doesn't matter which). I can see why it would make sense to include it in the Job For Club column too - I'll see if I can add this option to the next version.

[Great Imp]

Hi,
first, thank you Archie for this awesome editor! I am very grateful:)
I used your Updater from the 2007 EHM as well, so I am a little familiar with the import sheets. I can create new players with the spreadsheet importer, and all works fine. But when I use the importer function for Non-Players, I get a crash. The staff is getting created, but when I click on this person, EHM just stops working. I am not sure what I am doing wrong.
I use the editor (0.2.1) in admin mode
I use the proper notation like : a - first name - second name and Nationality, Classification, Job for Club in the respective columns.
Is there a minimum requirement for columns to be filled?
Thank you very much

Edit 1: I used a xlsx Excel file and I only have problems with free agent non-players. When I assign staff to Clubs everything works fine

[Alessandro]

It looks like the editor doesn't convert well the "year offset" column from csv spreadsheet. Strange, because it always worked.

Here you have the file: https://www.sendspace.com/file/ip3dia
and here you can see that it gets imported with all zeros in the editor

[Alessandro]

Seems not working only with CSV. Saved in XLSX and it worked just fine.

[BKarchitect]

I notice a lot of stuff works well only in xlsx not csv any more. Which is fine I like the formatting ability of xlsx better anyways. But I did a player info import ffrom I'm a csv and not only the Norwegian names but any letter with any kind of symbol caused an ID error. But in xlsx everything imported fine. So just a heads up.

[archibalduk]

Hi,
first, thank you Archie for this awesome editor! I am very grateful:)
I used your Updater from the 2007 EHM as well, so I am a little familiar with the import sheets. I can create new players with the spreadsheet importer, and all works fine. But when I use the importer function for Non-Players, I get a crash. The staff is getting created, but when I click on this person, EHM just stops working. I am not sure what I am doing wrong.
I use the editor (0.2.1) in admin mode
I use the proper notation like : a - first name - second name and Nationality, Classification, Job for Club in the respective columns.
Is there a minimum requirement for columns to be filled?
Thank you very much

Edit 1: I used a xlsx Excel file and I only have problems with free agent non-players. When I assign staff to Clubs everything works fine

Thanks! I'll take a look. I suspect it is a missing default value.

It looks like the editor doesn't convert well the "year offset" column from csv spreadsheet. Strange, because it always worked.

I'm getting the same thing. It's weird because the correct value is being picked up from the csv file and passed internally. Something seems to be overwriting it.

Btw, what screen resolution and scaling are you using? The UI looks a bit messy.

I notice a lot of stuff works well only in xlsx not csv any more. Which is fine I like the formatting ability of xlsx better anyways. But I did a player info import ffrom I'm a csv and not only the Norwegian names but any letter with any kind of symbol caused an ID error. But in xlsx everything imported fine. So just a heads up.

Do you have a copy of the csv file so that I may check please?

I significantly altered the way in which csv and xml reads and writes data in order to significantly improve the speed. So it's possible that the change has caused an issue with certain characters. Note that the Editor only supports ASCII characters when using csv (xml and xlsx use UTF). ASCII only allows a few different accents - here's a list (see the bottom half for the accented characters): https://cs.stanford.edu/people/miles/iso8859.html

[wildcat62]

*edit* nvm figured it out sorry carry on

[BKarchitect]

Hi archi,

In my Vegas DB - all of the Declared Nation slots for the players got reset to none. I don't know if this was caused by the editor or something else. What I do know is that when I tried to change them via exporting the player info and the re-importing it back in, the Declared Nation info (Primary Nationality or Secondary Nationality) did not get updated. I tried both XLSX and CSV. It doesn't cause any errors on the import, it just doesn't change the info in the editor.

[archibalduk]

Thanks - I'll take a look.

If it is a relatively quick fix then I'll try and get a new release out tomorrow if I can.