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

[Fusion]

Could someone please explain this?




Nothing is correct here what i can see in the editor/game shows different nummers
EDIT: I added also AIK as a rival team but it does not show it ingame too. I made a save out of it and have also retry to load the edited savegame

[archibalduk]

Clubs file, Archi, clubs file

Here you go. Not much to it:

Could someone please explain this?

It's because you're editing a saved game and these do not work in the same way as databases. The Editor is more for viewing rather than editing saved games.

[Alessandro]

Clubs file, Archi, clubs file

Here you go. Not much to it:

Hmmm, really the only difference is that you added a nickname and I did not. I am now trying to run other attempts.

[Alessandro]

So, now it's working, and I also tried to edit while changing long name, and adding an arena, everything worked
I'm now waiting for your new version prior to do other testing.

[archibalduk]

Great! Thanks for all of your help.

I'll do my best to have a new version released today.

[Fusion]

Thanks for your answer Archi. Is it maybe possible to next update you can add so its possible to do changes in Saved game also during your game play? Like the editor for FM series you could add money and change players atribute during game play?

[Named]

Fusion: You can use EHM Assistant for that.

[archibalduk]

Thanks for your answer Archi. Is it maybe possible to next update you can add so its possible to do changes in Saved game also during your game play? Like the editor for FM series you could add money and change players atribute during game play?

No I'm afraid not. Database editing is the sole focus of my work for the foreseeable future.

[archibalduk]

Here is a new version of the Editor (v0.1.9): http://www.ehmtheblueline.com/forums/vi ... 05#p206841

This fixes the various issues that Alessandro and I have encountered with the Importer spreadsheets. It also adds some additional data export. Two important things to note about exporting spreadsheets are:

1. Exporting larger spreadsheets (such as unfiltered player and non-player data) seems to cause a crash if exporting to XLSX format. CSV and XML are fine however.
2. The spreadsheet headings/titles are temporary - they need finalising/tidying up.

CHANGELIST: VERSION 0.1.9 (30-Apr-2017)

New Features:

• Added club spreadsheet export (standard and research sheet); and
• Added player and non-player spreadsheet export (standard and research sheet).

Fixes and Improvements:

• Added club and competition editing to the Career History importer spreadsheet;
• Added setting to use nation abbreviations and/or short names when specifying cities and arenas in an importer spreadsheet;
• Contract expiry date and date joined are now reset if a player/non-player becomes a free agent (both club and national team contracts);
• Fixed issue with values being reset to a zero or negative number where an imported spreadsheet contains a blank value;
• Fixed unused player/non-player data removal (e.g. when changing classification) when loading and saving databases;
• Forced a reset of all flags in the "common" sub-folder;
• "[none]" is now an alternative to the "_none" flag when importing; and
• Numbers in scientific notation format (e.g. 3E+07) are now correctly imported as digits.

Known Limitations and Bugs:
If you encounter an issue which is not listed below then please do report it here: http://www.ehmtheblueline.com/forums/vi ... 10&t=14290

• Exporting large spreadsheets using XLSX spreadsheet format can result in a crash;
• There is no option to select non-CSV spreadsheet import templates at present;
• The Import Spreadsheet and Export Spreadsheet icons are very similar (I will change these);
• There is a slight pause halfway through the loading the database where no dialog window is displayed;
• Certain of the club records in the Editor do not match what is displayed in game and there is one unknown record type;
• Club Division Level flags should be displayed as a text input rather than a drop-down menu;
• EHM 2005 to 2007 conversion results in two error messages when importing in EHM 1 relating to the number of AHL and ECHL teams;
• EHM 2004 support not fully operational;
• EHM 2005-2007 support is experimental;
• Exporting Model Data as XLSX format sometimes results in an invalid spreadsheet file;
• Not all data can be deleted yet (an error message will be displayed where this is not possible);
• The mouse cursor does not change when hovering over certain editing fields which makes certain tasks, such as editing Club Contracted/Playing For, not immediately obvious (the field should be clicked on in order to display the selection dialog window);
• The improved table display has not yet been rolled out to all tables/screens;
• Table column widths have not yet been set (and will frequently appear too narrow/small);
• Certain icons could be improved/replaced;
• Drop-down menus are all sorted alphabetically which is not always appropriate;
• Set a non-player's Nation Contract is completely untested and may cause a crash;
• Altering club competition names do not carry across the various editing screens; and
• The editor text settings do not currently work.

[Paddy_ZA]

Wonderful work archibalduk but is there any way that the nat_club file can be incorporated into the EHM 1 Database & Saved Game Editor as in there is no way for me to change the nation's name as this keep the english translation of the country - so if i changed both the nation & the nation club names - i keep on getting the original name of the country in game. I used open the nat_club in the EHM 2007 formal using HXD (hector program) to change it & then use the import function in the game to change it to EHM 1 format - it worked without a problem - but the 9.2 EHM 2007 format has errors into it & there no way of saving EHM 1 db into a 2007 EHM format
Isnt there a way of saving a EHM 1 format db into a 2007 format using the editor - please archibalduk i knw this editor has taken alot of hard work but if u would work on this
Keep up the good work archibalduk
Paddy

[Alessandro]

The fixes are good.
The only thing is that I think I keep having the Bears added to the game only if I have "retain all teams"... which is odd because all the other teams are in, no matter what.

[archibalduk]

The fixes are good.
The only thing is that I think I keep having the Bears added to the game only if I have "retain all teams"... which is odd because all the other teams are in, no matter what.

Yes that's strange. It works fine for me though... I use a Large database setting. Do you use a smaller setting? Either way, I don't think this will be an issue relating to the importer functions. It'll either be the game or we're just overlooking a setting/attribute for the club.

Wonderful work archibalduk but is there any way that the nat_club file can be incorporated into the EHM 1 Database & Saved Game Editor as in there is no way for me to change the nation's name as this keep the english translation of the country - so if i changed both the nation & the nation club names - i keep on getting the original name of the country in game. I used open the nat_club in the EHM 2007 formal using HXD (hector program) to change it & then use the import function in the game to change it to EHM 1 format - it worked without a problem - but the 9.2 EHM 2007 format has errors into it & there no way of saving EHM 1 db into a 2007 EHM format
Isnt there a way of saving a EHM 1 format db into a 2007 format using the editor - please archibalduk i knw this editor has taken alot of hard work but if u would work on this
Keep up the good work archibalduk
Paddy

Thanks! No unfortunately converting from EHM 1 format to EHM 2007 is very complex. Getting the format back would take some time (something I'm not willing to do at this stage as the TBL Roster work is priority for the foreseeable future) but, even once that is done, you'd have the issues with all of the teams/leagues with names that do not match the EHM 2007 hardcoded settings and of course the different numbers of teams in leagues. So it would be a big undertaking to undo all of that work even if it were possible to convert back to EHM 2007.

[Alessandro]

The fixes are good.
The only thing is that I think I keep having the Bears added to the game only if I have "retain all teams"... which is odd because all the other teams are in, no matter what.

Yes that's strange. It works fine for me though... I use a Large database setting. Do you use a smaller setting? Either way, I don't think this will be an issue relating to the importer functions. It'll either be the game or we're just overlooking a setting/attribute for the club.

Please send me your clubs file

[Fusion]

Fusion: You can use EHM Assistant for that.

Thanks its the EHM Assistant for EHM 2007 right this one?
http://www.ehmtheblueline.com/forums/vi ... =3&t=13874

Thanks for your answer Archi. Is it maybe possible to next update you can add so its possible to do changes in Saved game also during your game play? Like the editor for FM series you could add money and change players atribute during game play?

No I'm afraid not. Database editing is the sole focus of my work for the foreseeable future.

Thanks again Archi for your answer. By the way could you answer on this? Tryed to modify the database worked fine added so i my club that im GM of starts with 15mil in Finance balance and my Playerbudget on 8,5milj but turned out that i started the season with 55milj and was the richest hockey club in Swedish Hockey Allsvenskan lol. I guess i can change it later with the EHM Assistant or with cheatengine or artmoney

[archibalduk]

The fixes are good.
The only thing is that I think I keep having the Bears added to the game only if I have "retain all teams"... which is odd because all the other teams are in, no matter what.

Yes that's strange. It works fine for me though... I use a Large database setting. Do you use a smaller setting? Either way, I don't think this will be an issue relating to the importer functions. It'll either be the game or we're just overlooking a setting/attribute for the club.

Please send me your clubs file

Here you go: https://1drv.ms/u/s!AsXFKQMOdPqgiD485xlJu9Szp97A

Thanks again Archi for your answer. By the way could you answer on this? Tryed to modify the database worked fine added so i my club that im GM of starts with 15mil in Finance balance and my Playerbudget on 8,5milj but turned out that i started the season with 55milj and was the richest hockey club in Swedish Hockey Allsvenskan lol. I guess i can change it later with the EHM Assistant or with cheatengine or artmoney

Try using the "Disable starting financial adjustments" setting when creating a new game (I can't remember the exact wording, but it is something like that). You will see it in the various settings on the Start New Game screen in EHM.

[archibalduk]

I think we are nearly ready for using the Editor on the master database of the TBL Rosters. My to-do list for the next release (during May) is as follows:

- Final testing (I will be undertaking a basic update of the Spanish league using the three spreadsheets);
- Fix the players & non-players research spreadsheet which has some columns in the wrong place;
- Add a history club name and league name mass editing (so that we can change RSL entries to KHL for a certain range of seasons);
- Get the spreadsheet format setting working for generating spreadsheet templates; and
- Add resetting of salary data when making a person a free agent.

EDIT: I'm also going to add league and arena importing as I can test this as the same time as the others using the Spanish research.

[Named]

Are You planning to add options to take a look on what teams we have in specific league? Now its only visible when we populate by league/division. I think someone mentioned about it earlier Also I think ability to import Officials (referee) would be great option.

[archibalduk]

Are You planning to add options to take a look on what teams we have in specific league? Now its only visible when we populate by league/division.

So do you mean being able to see what teams are in a league by looking at the Club Comps editing screen? If so, then yes I can add that to my list.

Also I think ability to import Officials (referee) would be great option.

Agreed! It's not as high priority as other items, but it is on my list.

[Named]

YES & THANKS

[archibalduk]

Great - both noted and listed.

[EArk]

I have a question. My team went from HockeyAllsvenskn to SHL. My player budget in HA was around 200k.
When you play in SHL you get a lot of tv money. So my balance was at 30 millions. But the board set the player budget to 175k. Its not realistic, in the SHL you should at least have 2 million i player budget.
Does anyone know way it is like this. (This i not the first time it happens)
Its ignoniring when you a lot of money in the balance, but is not able to use it in the player budget.

[Named]

I found another bug. If You export mostly no matter which league Playoff dates it always had a problem with dates in csv file. Seems few leagues had correct export but mostly it's wrong. Regular Season Dates are okay exporting.

[archibalduk]

I found another bug. If You export mostly no matter which league Playoff dates it always had a problem with dates in csv file. Seems few leagues had correct export but mostly it's wrong. Regular Season Dates are okay exporting.

I had a quick check but I cannot see the issue you are reporting. The CSV file matches what is displayed in the table in the Editor. Could you show me a screenshot of the Editor so that it shows the correct dates which you mention are incorrectly exported?

[Named]

You can load 9.4 db and try for example export playoff dates in BENE league. (Stage 2) Or maybe it's cause my polish version of excel? I also not sure but editor seems problem with importing some clubs names in staff.xlsx file. For example SønderjyskE Ishockey. I get no match.

Btw. can we now retire players with this sheets? I get error when use _retire on Club Contracted rows.

[archibalduk]

I have checked Stage 2 of the BeNeLiga but the dates exported to the spreadsheet match what is shown in the Editor. I am struggling to repeat what I understand is your issue (i.e. that the wrong dates are shown in the spreadsheet).

Could you show me a screenshot of the Editor so that it shows the correct dates which you mention are incorrectly exported? In other words, so that I can compare your screenshot of the Editor against the screenshot of your spreadsheet which you posted earlier (so that I can clearly see what is not correctly exported).