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

Discuss all aspects of editing the data and databases in EHM here. Have a question about the EHM Editor, EHM Assistant, editing the .cfg files, hex editing the .dat or .db files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
Forum rules
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.

Have a bug or feature request for the EHM Editor? Post them in the EHM Editor thread. Please start a new thread or post in another thread if you have a question about how to use the EHM Editor.

Given the large number of questions on similar topics, we ask that you start a new thread for a new question unless you can locate a similar question in an existing thread. This will hopefully ensure that similar questions do not get buried in large threads.

Useful links: EHM 1 Assistant (Download) | EHM 1 Editor (Download) | EHM 1 Editor Tutorials | Editing Rules & Structures Guide | Converting EHM 2004 / 2005 DBs to EHM 1 | Converting an EHM 2007 DB to EHM 1 | Extra_config.cfg | Import_config.cfg | Player Roles
Post Reply
zbguy
Top Prospect
Posts: 121
Joined: Wed Aug 28, 2013 7:01 pm

Re: EHM 1 Database & Saved Game Editor

Post by zbguy »

Thanks for the update, I love the filtering and can't wait to check out some of the new player importing features.

I've noticed a bug where when I set the editor to use North American date styles, it doesn't change anything; they remain European date styles. Even when saving the DB, even when closing and restarting the editor, nothing changes it.

One other thing, and I don't know if this is theoretically impossible for the Editor to do, is that databases won't display player ratings from 1-100 even if the setting is ticked. I'm guessing that's because ratings are by default 1-20 and wouldn't switch to 1-100 until game start but, yeah.
User avatar
Tonait
Junior League
Posts: 24
Joined: Mon Sep 19, 2011 9:15 pm
Location: Turku, Finland

Re: EHM 1 Database & Saved Game Editor

Post by Tonait »

I dont know how i set every player as free agent, Can someone tell how it works?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

zbguy wrote:I've noticed a bug where when I set the editor to use North American date styles, it doesn't change anything; they remain European date styles. Even when saving the DB, even when closing and restarting the editor, nothing changes it.
That's strange. What screens are you looking at? I just tested it now and it is working fine for me.
zbguy wrote:One other thing, and I don't know if this is theoretically impossible for the Editor to do, is that databases won't display player ratings from 1-100 even if the setting is ticked. I'm guessing that's because ratings are by default 1-20 and wouldn't switch to 1-100 until game start but, yeah.
That's right - AFAIK only once the data is in a saved game is the 1-100 range used. I have not tried, but I would expect that the game will ignore that setting when starting a new game from the database (worth testing out though). The setting won't have an impact on the Editor because it just shows whatever is in the database (and ticking/un-ticking that box doesn't result in any of the attributes being automatically converted between 1-20 and 1-100 ranges).
Tonait wrote:I dont know how i set every player as free agent, Can someone tell how it works?
You need to use the staff Importer spreadsheet. You will need to list every single person in that spreadsheet and put the word "_none" in the Club Contracted column for each person. There is a guide on how to use the Staff Importer spreadsheet here: viewtopic.php?f=150&t=18864#p233374

I recommend reading through the full guide because it explains how to create the blank spreadsheet you'll need along with how to generate a list of all persons from the database: viewtopic.php?f=150&t=18864#p233369
User avatar
xECK29x
TBL Rosters Researcher
Posts: 1010
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

Archi,

I am having an issue working with importing player career history, when I import this spreadsheet it's deleting all entries for these players. Any idea what might be causing it?

DB and spreadsheet: https://www.dropbox.com/s/lqpcsjw9at7fk ... t.zip?dl=0
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

xECK29x wrote:Archi,

I am having an issue working with importing player career history, when I import this spreadsheet it's deleting all entries for these players. Any idea what might be causing it?

DB and spreadsheet: https://www.dropbox.com/s/lqpcsjw9at7fk ... t.zip?dl=0
It looks like the career history table display is not updating after importing data. However, the histories aren't being deleted; they're just not displayed. If you save your DB and re-load the Editor, you'll find they're all there (including the imported ones).

I have put fixing this to the top of my list for the next release.
User avatar
xECK29x
TBL Rosters Researcher
Posts: 1010
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

Excellent, thank you!
zbguy
Top Prospect
Posts: 121
Joined: Wed Aug 28, 2013 7:01 pm

Re: EHM 1 Database & Saved Game Editor

Post by zbguy »

Hi Archi, it's on the player editing screen:

Image
Image
Kart99
Junior League
Posts: 48
Joined: Wed Apr 01, 2015 2:35 pm

Re: EHM 1 Database & Saved Game Editor

Post by Kart99 »

Can I ask something else? I've been having a bit of a play around with the database seeing what it can do, adding teams to leagues etc.

I seem to have everything working bar one thing - and it's a rather annoying thing. I get one error message constantly when you look at the news feed for any team I GM. So basically, everytime I click on a message or click the button Read-all etc it shows this message:

NEWS_ITEM::get_data() : the index is invalid

I'm scratching my head a little bit so any suggestions?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

zbguy wrote:Hi Archi, it's on the player editing screen:

Image
Image
Are you running version 0.2.6 of the Editor? I cannot tell from the screenshots. The version is stated in the window title bar.

If you are, then it's a bit of a mystery as I cannot reproduce the issue here and knowing the underlying mechanism of the dates. Assuming this to be the case, I'll add some sort of diagnostics to the next version of the Editor to help try to get to the bottom of the issue.
Kart99 wrote:Can I ask something else? I've been having a bit of a play around with the database seeing what it can do, adding teams to leagues etc.

I seem to have everything working bar one thing - and it's a rather annoying thing. I get one error message constantly when you look at the news feed for any team I GM. So basically, everytime I click on a message or click the button Read-all etc it shows this message:

NEWS_ITEM::get_data() : the index is invalid

I'm scratching my head a little bit so any suggestions?
It is hard to say what the issue might be without knowing what you have edited. The only time I have heard of this error arising is where a league has a large number of teams added (IIRC a number of around 42+ teams will result in this error).
Kart99
Junior League
Posts: 48
Joined: Wed Apr 01, 2015 2:35 pm

Re: EHM 1 Database & Saved Game Editor

Post by Kart99 »

I may have a solution then. For kicks I created a league of 50 teams, so in theory I should just edit it back down to 42 or so teams and see is that sorts the issue?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

Kart99 wrote:I may have a solution then. For kicks I created a league of 50 teams, so in theory I should just edit it back down to 42 or so teams and see is that sorts the issue?
Yes that should sort it (you might have to go as low as 40, but I think you can get to 42 safely). :thup:
Kart99
Junior League
Posts: 48
Joined: Wed Apr 01, 2015 2:35 pm

Re: EHM 1 Database & Saved Game Editor

Post by Kart99 »

Yeah, that's it sorted. Thanks again Archi! Much appreciated.
zbguy
Top Prospect
Posts: 121
Joined: Wed Aug 28, 2013 7:01 pm

Re: EHM 1 Database & Saved Game Editor

Post by zbguy »

Yeah, I'm on version 0.2.6.
User avatar
ppaalloo
TBL Rosters Researcher
Posts: 95
Joined: Tue Jul 02, 2013 2:31 pm
Favourite Team: Colorado Avalanche
Location: Slovakia, Bánovce nad Bebravou

Re: EHM 1 Database & Saved Game Editor

Post by ppaalloo »

Hi I have some problem with my research. I have dates in excel http://prntscr.com/i8ktdy but when I import my spreadsheet editor give me errors and changes to this http://prntscr.com/i8ky0d I have Europe format dates so I dont know where is problem :( If players go out from club to the other there is no problem with import... problem is just with players who are coming to clubs from other leagues...
User avatar
xECK29x
TBL Rosters Researcher
Posts: 1010
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

Small feature request, is it possible to add a button to automatically generate updated statistics (in the Statistics tab) for current and career stats for a player based on what is in History?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

ppaalloo wrote:Hi I have some problem with my research. I have dates in excel http://prntscr.com/i8ktdy but when I import my spreadsheet editor give me errors and changes to this http://prntscr.com/i8ky0d I have Europe format dates so I dont know where is problem :( If players go out from club to the other there is no problem with import... problem is just with players who are coming to clubs from other leagues...
This is the same problem CJ had with his spreadsheet. Go to the top left corner of the spreadsheet and change the "dmy" text to "ymd".
xECK29x wrote:Small feature request, is it possible to add a button to automatically generate updated statistics (in the Statistics tab) for current and career stats for a player based on what is in History?
Yes I can add a button to do that. I take it you are aware that these stats are also automatically updated when loading and saving the DB?
User avatar
xECK29x
TBL Rosters Researcher
Posts: 1010
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

Re: EHM 1 Database & Saved Game Editor

Post by xECK29x »

Yes I am, it's purely to help with my OCD :)
User avatar
ppaalloo
TBL Rosters Researcher
Posts: 95
Joined: Tue Jul 02, 2013 2:31 pm
Favourite Team: Colorado Avalanche
Location: Slovakia, Bánovce nad Bebravou

Re: EHM 1 Database & Saved Game Editor

Post by ppaalloo »

This is the same problem CJ had with his spreadsheet. Go to the top left corner of the spreadsheet and change the "dmy" text to "ymd".
doesnt work editor crash when I import spreadsheet
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

xECK29x wrote:Yes I am, it's purely to help with my OCD :)
Ha! It's on my list for the next release. :thup:
ppaalloo wrote:
This is the same problem CJ had with his spreadsheet. Go to the top left corner of the spreadsheet and change the "dmy" text to "ymd".
doesnt work editor crash when I import spreadsheet
Could you email your sheet to me please? I will take a look. My address is webmaster (AT) ehmtheblueline (DOT) com.
User avatar
ppaalloo
TBL Rosters Researcher
Posts: 95
Joined: Tue Jul 02, 2013 2:31 pm
Favourite Team: Colorado Avalanche
Location: Slovakia, Bánovce nad Bebravou

Re: EHM 1 Database & Saved Game Editor

Post by ppaalloo »

Okay I send it
ForNever
Minor League
Posts: 277
Joined: Tue Dec 31, 2013 10:26 am
Favourite Team: SaiPa (Liiga), Anaheim (NHL)
Location: Joensuu, Finland

Re: EHM 1 Database & Saved Game Editor

Post by ForNever »

Hello. I haven't been on the forum for a while because of lack of time, but I just had to stop by to say thank you Archibalduk for your amazing work on this editor. I happened to download to latest rosters yesterday (haven't even played the game for half a year I think) and later found myself editing the database for four hours straight during the night. I had to stop because it was 4 am and I needed some sleep. :-D

So my ultimate message is this: thank you so much, and please do keep up the awesome work, Arch! :notworthy:
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database & Saved Game Editor

Post by archibalduk »

ppaalloo wrote:Hi I have some problem with my research. I have dates in excel http://prntscr.com/i8ktdy but when I import my spreadsheet editor give me errors and changes to this http://prntscr.com/i8ky0d I have Europe format dates so I dont know where is problem :( If players go out from club to the other there is no problem with import... problem is just with players who are coming to clubs from other leagues...
Hi Ppalloo. I sent you an email with your fixed spreadsheets. This is the same issue CJ had. It looks as though Excel/LibreOffice does something to the dates if you enter them with "/" as the separator (e.g. 1/2/1990). The temporary solution is to use "." as the separator (e.g. 1.2.1990). I have an idea of how to automatically fix this - I'll add this to the next version of the Editor. In the meantime, just use "." in dates for now. :thup:
ForNever wrote:Hello. I haven't been on the forum for a while because of lack of time, but I just had to stop by to say thank you Archibalduk for your amazing work on this editor. I happened to download to latest rosters yesterday (haven't even played the game for half a year I think) and later found myself editing the database for four hours straight during the night. I had to stop because it was 4 am and I needed some sleep. :-D

So my ultimate message is this: thank you so much, and please do keep up the awesome work, Arch! :notworthy:
Welcome back! Thank you for the kind words! :-) There is still a lot of work to do on the Editor, but I feel it is now finally useful (rather than just experimental). I can't believe I started this project back in May 2015. Time has really flown!
User avatar
ppaalloo
TBL Rosters Researcher
Posts: 95
Joined: Tue Jul 02, 2013 2:31 pm
Favourite Team: Colorado Avalanche
Location: Slovakia, Bánovce nad Bebravou

Re: EHM 1 Database & Saved Game Editor

Post by ppaalloo »

The temporary solution is to use "." as the separator (e.g. 1.2.1990).
I use this style archy :) but I dont know why excel put to error list this (e.g. 1/2/1990)....
User avatar
Manimal
TBL Admin Team
Posts: 6344
Joined: Thu Apr 24, 2008 4:01 am
Custom Rank: EHM Rosters Man
Favourite Team: Djurgårdens IF
Location: Karlstad, Sweden

Re: EHM 1 Database & Saved Game Editor

Post by Manimal »

ppaalloo wrote:
The temporary solution is to use "." as the separator (e.g. 1.2.1990).
I use this style archy :) but I dont know why excel put to error list this (e.g. 1/2/1990)....
I think this is a language issue for the programs we use (Excel/LibreOffice). Countries write dates in different ways and with different characters.
For example, I had some issues in a schedule file I sent Archi the other day and he could not see the error but I could.

When I fill in the DOBs in ppaalloos Tipsport-file then they turn up ok
User avatar
ppaalloo
TBL Rosters Researcher
Posts: 95
Joined: Tue Jul 02, 2013 2:31 pm
Favourite Team: Colorado Avalanche
Location: Slovakia, Bánovce nad Bebravou

Re: EHM 1 Database & Saved Game Editor

Post by ppaalloo »

So you have 1/2/1990 types of dates in your excels?
Post Reply