Page 6 of 82
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 5:33 pm
by archibalduk
bäckström19 wrote:i didnt find any players, why?
where i can change the states from the player?
archibalduk wrote:The players are under the Staff button/category. Staff means both players and non-players.
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 5:33 pm
by archibalduk
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 6:47 pm
by archibalduk
New version here:
http://www.ehmtheblueline.com/forums/vi ... 06#p206841
CHANGELIST: VERSION 0.0.3 (25-Feb-2016)
New Features:
- Arena editing screen;
- First name and second name editing screens;
- Official editing screen;
- Player awards editing screen;
- Export screen added;
- Non-player and player attributes exporting;
- Add data button enabled for all editing screens except for Staff and Officials;
- Raw table data export function on each editing screen;
- Saved game loading, saving, unpacking and editing support.
Fixes and Improvements:
- Added additional World Championship divisions to Senior National Team division settings;
- EU Membership setting on the Nations screen fixed;
- Fixed Morale and Natural Fitness attributes being swapped around;
- Improved header/labelling system including headers that update with each edit;
- Rearranged the Database Header editing screen;
- Year of Birth field now automatically updates upon editing a date of birth.
***** BACKUP YOUR SAVED GAME / DATABASE BEFORE USING THE EDITOR *****
Note that you cannot move players between teams when editing saved games (it won't work properly in game).
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 6:49 pm
by A9L3E
Can one see from the arena editing screen which clubs have the arena as their home rink?
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 6:52 pm
by archibalduk
A9L3E wrote:Can one see from the arena editing screen which clubs have the arena as their home rink?
No, I'm afraid not. However, I have some code from the Updater v3 for creating a spreadsheet showing this - I'll try to remember to copy this over to the Editor for the next version.
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 6:54 pm
by A9L3E
archibalduk wrote:No, I'm afraid not. However, I have some code from the Updater v3 for creating a spreadsheet showing this - I'll try to remember to copy this over to the Editor for the next version.
That would be highly appreciated.

Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 8:06 pm
by Edgars
Are you planning to add "Delete" function to the editor?
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 8:17 pm
by archibalduk
Edgars wrote:Are you planning to add "Delete" function to the editor?
Yes eventually. But I need to first fully decode the DB in order to do so.
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 8:22 pm
by ehmfans
great job with editor!
Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 9:33 pm
by Exarz
Great editor!
However, it would be nice if you could add the option to search teams by league! It simplifies things a lot when you want teams to switch leagues etc!

Re: EHM 1 Database Editor (2016)
Posted: Thu Feb 25, 2016 11:13 pm
by Exarz
I discovered a glitch: I added some teams to the KHL and moved some teams to other leagues to keep the league in the right amount of teams. However, the information and standings are wrong, as they still contain the other teams. In the player statistics and in the schedule, the new teams and their players are in.

I put Metallurg Nk in the Russian Vysshaya Liga and replaced them with a new team (Beijing Dragons)

I put Medvescak back in EBEL (I also made EBEL have the right amount of teams) and Vityaz in the Russian Vysshaya Liga. I replaced them with AIK Hockey and Eisbären Berlin

Here's what it looks like in the information tab
Re: EHM 1 Database Editor (2016)
Posted: Fri Feb 26, 2016 2:22 am
by Pepito9198
archibalduk wrote:Pepito9198 wrote:Hi, i downloaded the editor and i can only get to the games default databases. I have downloaded the TBL 8.1 which is updated and all but can load it into the editor. What could i be doing wrong? I can find the TBL 8.1 folder no problem, however the files are not (.DB)...
](./images/smilies/wallbash.gif)
You need to use the Import function in EHM to generate the DB file.
Agreed. Whenever i try to do that, the dialog box is empty. I mean, when i click ''Import Database : Import an EHM 2007 format database'' there is a dialog box, called Choose Database. Nothing is there. I must've forgotten a step somewhere..
Re: EHM 1 Database Editor (2016)
Posted: Fri Feb 26, 2016 2:38 am
by Pepito9198
Archie, i found how... silly me i was such in a hurry if forgot the most important step: unzipping the file
now part two of the question, can we remove the salary cap?
Re: EHM 1 Database Editor (2016)
Posted: Fri Feb 26, 2016 4:10 am
by Pepito9198
Pepito9198 wrote:Archie, i found how... silly me i was such in a hurry if forgot the most important step: unzipping the file
now part two of the question, can we remove the salary cap?
OK, so i was able to load the 8.1 DB update nto the editor. I saved my work under a different name. Now cant load a new game with it... it's already a .DB file, so i assume no need to import? I ''unziped'' it but not sure what that step is for exactly...
Re: EHM 1 Database Editor (2016)
Posted: Fri Feb 26, 2016 10:31 am
by archibalduk
Exarz wrote:I discovered a glitch: I added some teams to the KHL and moved some teams to other leagues to keep the league in the right amount of teams. However, the information and standings are wrong, as they still contain the other teams. In the player statistics and in the schedule, the new teams and their players are in.
Yes this was raised previously IIRC. The database has some new tables that weren't in EHM 2007 and relate to things such as league rules, structures and schedules. These were hardcoded in EHM 2007 and are now editable via the DB in EHM 1. However, I don't know the structures for these tables yet and so we cannot edit them in the Editor. I suspect some of those tables are affecting which leagues teams are placed in. The only way to get around it at the moment is to use the import_config.cfg file before importing the EHM 2007 format database. See here:
http://www.ehmtheblueline.com/forums/vi ... 70#p199124
Pepito9198 wrote:now part two of the question, can we remove the salary cap?
You need to edit the transfer_rules.cfg file located in the same folder as your database.db file. Open the file using Notepad.
Pepito9198 wrote:OK, so i was able to load the 8.1 DB update nto the editor. I saved my work under a different name. Now cant load a new game with it... it's already a .DB file, so i assume no need to import? I ''unziped'' it but not sure what that step is for exactly...
You need to save the file as database.db as this, to my knowledge, is the only way for the database to appear in game.
I'm not sure what you mean about unzipping. I wonder if you mean the Unpack button in the Editor. You don't need to use this. Just use the button entitled "Save".
Re: EHM 1 Database Editor (2016)
Posted: Fri Feb 26, 2016 10:41 am
by Edgars
archibalduk wrote:Edgars wrote:Are you planning to add "Delete" function to the editor?
Yes eventually. But I need to first fully decode the DB in order to do so.
OK - thank you - keep up the great work!

Re: EHM 1 Database Editor (2016)
Posted: Fri Feb 26, 2016 12:29 pm
by A9L3E
I really wonder why Riz is not helping you with decoding the database. It could save him some work in adding more playable leagues and potentially boost the game sales.
Re: EHM 1 Database Editor (2016)
Posted: Sat Feb 27, 2016 5:23 am
by Pepito9198
Archie: Very good, it worked!!! thanks!

Re: EHM 1 Database Editor (2016)
Posted: Mon Feb 29, 2016 6:11 pm
by JakeTheSnake
Archie, you said in this discussion (and there's also a note about it on the editor) that we should make backups of our databases/saved games.
Does that mean i can edit my saved games in some way with the editor?
How? I can't seem to find any way to open a saved game with the editor.
Re: EHM 1 Database Editor (2016)
Posted: Mon Feb 29, 2016 7:02 pm
by archibalduk
That's right; you can edit saved games but only with version 0.0.3 onwards. Sounds like you might have the older version still. Just download the latest version here:
http://www.ehmtheblueline.com/forums/vi ... 48&t=16014
You'll see there is an Open Saved Game button next to the Open Database button
Re: EHM 1 Database Editor (2016)
Posted: Mon Feb 29, 2016 8:13 pm
by JakeTheSnake
Fantastic!
Thank you!
Re: EHM 1 Database Editor (2016)
Posted: Thu Mar 03, 2016 5:14 am
by Pepito9198
Archibalduk: I know it cant be done now, but are you going to add some league editing tools to the editor? Like changing/removing salary cap, max contract lenght etc? i know it can be done before a game but what about a save game?
Re: EHM 1 Database Editor (2016)
Posted: Thu Mar 03, 2016 7:49 am
by zbguy
Thanks for the save-game editing, Archi. It works very nicely with EHMAssistant!
Re: EHM 1 Database Editor (2016)
Posted: Thu Mar 03, 2016 9:47 pm
by archibalduk
Pepito9198 wrote:Archibalduk: I know it cant be done now, but are you going to add some league editing tools to the editor? Like changing/removing salary cap, max contract lenght etc? i know it can be done before a game but what about a save game?
I don't really know. It depends on whether and how much of the league editing I can implement into the Editor (the table structures are complex) and then whether the league rules are stored in the same way in the saved game as the database (as the database editing functions are my priority). Each database editing screen in the Editor will load any such data in the saved game too. But the saved games don't always store the data in the same way which means they won't appear in the Editor - see for example the Affiliations editing screen (you'll see it's blank/empty in the saved game because the data is stored elsewhere and in a different format).
Re: EHM 1 Database Editor (2016)
Posted: Fri Mar 04, 2016 1:51 pm
by tjackie
Hi. I dunno if this is already answered somewhere. But can someone give me instructions (if it is possible) how to export my own team (Toronto atm) to .csv without getting the whole database or all the players that exists? I just want an export of my own team but I have no idea what im doing wrong. I use the latest version, got the vcredist installed and I managed to edit some weight on a player that I wanted to do also but the exporting player part just doesn't work for me.. I wish I could use both EHM EA assistant but now that the game is updated I cant use the assistant anymore. Any help is appreciated.
I think I posted this in the wrong forum before. Sorry.
](./images/smilies/wallbash.gif)