EHM The Blue Line

Cool beans, no need to jump on it, just something that could make future database mods easier for the end users.

archibalduk wrote:I have ironed out the remaining issues with the EHM 2005 conversion and now have the original EHM 2005 database up and running in EHM 1! I haven't done much simming yet, but it's looking pretty good to so far (using the 2006 rule set of course).

Kazakhstan had an argument with the IOC?

archibalduk wrote:I have ironed out the remaining issues with the EHM 2005 conversion and now have the original EHM 2005 database up and running in EHM 1! I haven't done much simming yet, but it's looking pretty good to so far (using the 2006 rule set of course).

2005? Was that the last year of the EIHL/BHL/ENL structure in Britain? Would it just be the case we'd need to get league-structures in (as the player data already exists).

No, that was 2004/05. So the season covered by EHM 2004. But yes, it's just a case of adding the structures to the DB.

I can partly read the EHM 2004 database but I haven't finished it yet. Annoyingly the EHM 2004 Editor won't run unless EHM 2004 installed but I don't have a CD-ROM drive, meaning I cannot install the game. I tried running the demo but that's not enough to keep the Editor happy. I need to run the EHM 2004 Editor in order to figure out the data structure.

I ended up ordering a cheap external DVD drive on Amazon so that I can install EHM 2004 on my laptop and hopefully figure out the database structure.

I've made quite a few adjustments/improvements to the Editor since the last release. I've also added player/staff auto-deletion (i.e retired and invalid staff) and city and affiliate importing/editing via spreadsheets. I'm now working on a new form of staff import spreadsheet which I hope will make working on the roster updates a little easier (you just list the rosters in the spreadsheet and the Editor will figure out what moves to make and what players to create).

I now have the basics of the Smart Update up and running (I know it's a tacky name, but I want to distinguish it from the Staff Importer spreadsheet). This is really just a slightly different form of Staff Importer spreadsheet with the main differences being that the Smart Update will (1) create a new player if it cannot find a matching player in the database (rather than coming back with a "No Match" error) and (2) empty each relevant team's rosters before importing the changes (but this can be disabled).

The idea behind this is that you list a team's entire roster in a spreadsheet (see screenshot below) and the Importer will then make the necessary changes by moving players to those teams and/or creating any missing players. The reason for the Smart Update clearing those teams' rosters before running the changes is so that players who have left those teams are made free agents (and can then be covered in a separate Smart Update spreadsheet or manually edited in the Editor). Only the teams covered in the Smart Update will have their rosters cleared (i.e. it won't affect the whole database).

The main challenge I have at the moment is figuring out how the Smart Update can find similar players where the DOB is slightly wrong in the DB but is correct in the spreadsheet. For example, I found a UK youth player in the DB with a DOB from 1996 but his correct DOB is 1998 (which is how it is in the spreadsheet). The incorrect DOB is obvious to a person looking at it but I haven't quite figured out how the Smart Update can figure this out for itself and then make the correction. If the Smart Update cannot figure this out (as is the case at present) then it'll create a new player who will be a duplicate of the player with the wrong DOB...

Just wondering if anyone has any idea how to edit Pittsburgh Penguins colors ? I just recently updated, the logo from the gold to yellow. I've tried the EHM Editor 2.4 and saved but no changes take effect after I save it.

J'ai effectué des changements dans le database (ajout de nom) . Lorsque je recommence une partit, je n'ai pas c'est nom lorsque je veux les editer. Quel est le probleme ?

The forum language is English. Please repeat your question in English.

is there anyway of getting the editor to work within playonmac?

Trying to edit the newest data update pre-game. I can start a new game with the database, but can't find the file with the editor. Any help?

Edit: Figured it out. But how can I switch draft picks?

Hey Archi, is there a way (or, if not, are there plans) to export/import players individually?

Bradkelly57 wrote:is there anyway of getting the editor to work within playonmac?

I'm afraid I don't have a Mac and cannot test this. Try installing the 32-bit version (also known as vcredist_x86.exe) (do not install the 64-bit version): https://www.microsoft.com/en-gb/downloa ... x?id=48145

Also install the latest .NET Framework.

trevorjazz wrote:Just wondering if anyone has any idea how to edit Pittsburgh Penguins colors ? I just recently updated, the logo from the gold to yellow. I've tried the EHM Editor 2.4 and saved but no changes take effect after I save it.

Are you editing a database or a saved game. Saved game editing is not advisable and changes are unlikely to work. If editing a database, ensure that you use Run as Admin when running the Editor.

zbguy wrote:Hey Archi, is there a way (or, if not, are there plans) to export/import players individually?

You can export a Player & Non-Player Research Sheet via Tools -> Export Spreadsheet. Delete all of the rows of data from the spreadsheet except for the individual player. Then put an "a" in the Mode column next to the player in question. Then import this into your chosen database.

The next version of the Editor also allows Career History exporting which can also then be imported using a similar method as described above.

Epic wrote:Trying to edit the newest data update pre-game. I can start a new game with the database, but can't find the file with the editor. Any help?

Edit: Figured it out. But how can I switch draft picks?

Use the "DRAFT_PICK_SWITCH" setting in extra_config - see here: viewtopic.php?f=110&t=2382

Hi. I am using the editor to edit the new rosters (10.0). I have a question. When saving the edited database, where should I save it? Should I save it in the folder with all the other databases as a new file, or should I overwrite the database that I donwloaded from the Steam workshop? Also, I have tried saving it multiple times but when I try loading the database in game, nothing happens. I turned of Save Compressed, and still nothing happens. Why? When I go and see when the .db file was last modified, it says that there weren't any changes. Why? Do I need to close the editor? Or is it something else?

Hi i would like to ask, if i can change competitions from which is European champions league or continental cup binding... For example i dont want in continental cup club from Serbian league but i want in continental cup club from Slovenian league. Is it possible? Sorry for my english

thanks

leafsrock67 wrote:Hi. I am using the editor to edit the new rosters (10.0). I have a question. When saving the edited database, where should I save it? Should I save it in the folder with all the other databases as a new file, or should I overwrite the database that I donwloaded from the Steam workshop? Also, I have tried saving it multiple times but when I try loading the database in game, nothing happens. I turned of Save Compressed, and still nothing happens. Why? When I go and see when the .db file was last modified, it says that there weren't any changes. Why? Do I need to close the editor? Or is it something else?

It really depends on how you are keeping backups of your database and whether you want your edited database to be separate from the original. If your changes are not being saved then it might be because you are not running the Editor as administrator. Here are the steps to do so:

1. Right-click on the EHM Editor.exe file.
2. Choose Properties.
3. On the Compatibility tab, select the Run This Program As An Administrator option.
4. Click OK.
5. When you next load the Editor, if you see a User Account Control prompt, accept it.

I suggest saving your edited database to your desktop and then manually moving it to a new sub-folder of your <EHM installation folder>/data/database/ folder.

erik12 wrote:Hi i would like to ask, if i can change competitions from which is European champions league or continental cup binding... For example i dont want in continental cup club from Serbian league but i want in continental cup club from Slovenian league. Is it possible? Sorry for my english

thanks

No I don't think you can. It is currently hard-coded. I believe you can alter which teams start in the first season by adding/removing Continental Licences, but I don't think you can change which leagues feed into the CHL from the second season onwards.

Hi Archi,

first, happy new year:)
second, thanks again for all your work on the editor. Before I use a new database I create (by your import function) lots of new players (and non players) to have more second names in the game.
As a german, it's much more fun if every german player is not named Seidenberg or so:). But I noticed that if I create too many new players the game crashes after some playing time (3, 4 years, usually) due to an array overflow.
Well, OK, I overdid it with creating >100k new players, so I wonder:
is it possible to have an importer function for second names?

Yes that would certainly be possible. I have added it to my list and will look into it when I look into name deletion options (so that we can delete garbage/typo names).

It is interesting that ~150k players will cause the game to crash. I guess with each player having numerous career history entries then the database will fill up fast.

Happy New Year to you too!

Awesome, thank you. I wonder if Riz would be interested in the save file?

Hello all I'm new on Eastside Hockey Manager and really would like to use the Editor and help with Roster Updates. Is somewhere a Editor's tutorial avaliable?

Thanks

Matt

I am afraid there isn't any manual at present. I plan on writing some sort of help guide, but I need to keep developing the Editor for now.

If you are interested in helping with the TBL Roster updates then let me know in this thread and we can help you get started. Research for the TBL Rosters requires the use of spreadsheets rather than the Editor. I know you previously posted in that thread, but I wasn't sure if you were offering to research the AlpsHL or just looking to create some addons for it.

Great Imp wrote:Awesome, thank you. I wonder if Riz would be interested in the save file?

Possibly. I suggest uploading it to the SI Forums - details here: https://community.sigames.com/topic/345275-ftp-details/

I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?

How can I place all players as free agents at the beginning of the game?

MasterMatt23 wrote:I just have a quick question. I just downloaded the Editor for EHM 1, and I edited the ratings and potential on some of the players. Whenever I attempt to load that database, the game crashes? How come?

Editing ratings shouldn't cause a crash. Did you edit something else as well?

Tonait wrote:How can I place all players as free agents at the beginning of the game?

You could use the Staff importer file to list every player and make them free agents.

archibalduk wrote:

Tonait wrote:How can I place all players as free agents at the beginning of the game?

You could use the Staff importer file to list every player and make them free agents.

I'm not sure now How i find Staff importer file?