Page 2 of 82
Re: EHM:EA Database Editor
Posted: Sun Jul 12, 2015 11:20 am
by archibalduk
zbguy wrote:I have a quick follow-up question: Will the EA DB editor be able to use 07 DBs too? Because I'd rather use the EA DB editor than import from an 07 DB, but if the EA editor can then I can get a head start on what I want to do.
The EA DB Editor will work on EA DBs only. So you'd have to import a 2007 DB via the EA game in order to convert it to EA format so that it can be edited via my editor.
Perhaps you already know this, but the EA database that ships with EA is just a version of the TBL v7.x Rosters with all of the data faked.
Re: EHM:EA Database Editor
Posted: Sun Jul 12, 2015 7:10 pm
by zbguy
Didn't know that, but it's actually rather helpful. Thanks
Re: EHM:EA Database Editor
Posted: Thu Jul 23, 2015 4:05 am
by BulldogsFan
archibalduk wrote:zbguy wrote:I have a quick follow-up question: Will the EA DB editor be able to use 07 DBs too? Because I'd rather use the EA DB editor than import from an 07 DB, but if the EA editor can then I can get a head start on what I want to do.
The EA DB Editor will work on EA DBs only. So you'd have to import a 2007 DB via the EA game in order to convert it to EA format so that it can be edited via my editor.
Perhaps you already know this, but the EA database that ships with EA is just a version of the TBL v7.x Rosters with all of the data faked.
does this mean that we can use TBL rosters in ea db with 30 AHL or not yet...
Re: EHM:EA Database Editor
Posted: Thu Jul 23, 2015 5:00 am
by nino33
BulldogsFan wrote:archibalduk wrote:zbguy wrote:I have a quick follow-up question: Will the EA DB editor be able to use 07 DBs too? Because I'd rather use the EA DB editor than import from an 07 DB, but if the EA editor can then I can get a head start on what I want to do.
The EA DB Editor will work on EA DBs only. So you'd have to import a 2007 DB via the EA game in order to convert it to EA format so that it can be edited via my editor.
Perhaps you already know this, but the EA database that ships with EA is just a version of the TBL v7.x Rosters with all of the data faked.
does this mean that we can use TBL rosters in ea db with 30 AHL or not yet...
The AHL has had 30 teams since the release of EHM:EA (with both Default Rosters & TBL Rosters)
There are currently only 2 choices, a 2006 setup and a 2014 setup.
The setup determines things what rules and league structures will be used.
The setup is determined by the import_config file (determines start year between 1970-2014, 2006 or 2014 setup, and you can rename leagues/tournaments).
The 2014 setup has 30 AHL teams. The 2014 setup has been the setup for the TBL Rosters since the release of EHM:EA
Re: EHM:EA Database Editor
Posted: Fri Jul 31, 2015 10:22 pm
by BulldogsFan
the ea db editor is it the ehm 2007 editor or is there a link for the ea db editor?
also how do i select which rules i want 2014 or 2006? once i import the TBL 7.4c roster?
Re: EHM:EA Database Editor
Posted: Fri Jul 31, 2015 10:53 pm
by nino33
BulldogsFan wrote:the ea db editor is it the ehm 2007 editor or is there a link for the ea db editor?
There is no EHMEA Editor yet (this thread is Archi saying he's started work on one).
There is the EHMEA Assistant
http://www.ehmtheblueline.com/forums/vi ... &start=225 that allows you to edit
some things in a saved game (but only in a saved game, the database can't be edited)
BulldogsFan wrote:also how do i select which rules i want 2014 or 2006?
The import_config file
http://www.ehmtheblueline.com/wiki/inde ... nto_EHM:EA
FYI - general message for everyone/anyone interested in EHMEA/editing.....
Regarding editing in EHMEA...EHMEA is
not the same game as EHM07, and editing is
not the same as it was in EHM07 (in terms of results).
The return of EHM was certainly a surprise, and EHMEA is different than EHM07, and those that spend significant time editing are still figuring things out! With the new Player Roles affecting Attributes and new/different programming "under the hood" affecting Attributes (and likely more) there are differences in database values & in-game values at start-up! Some have noted their changes made in the EHMEA Assistant did not "stick" in-game...
It seems editing needs to be "more realistic" now, and things like player age, Player Role and CA are considered when Attribute changes are made.....it seems certain ratios/algorithms are affecting things/must be maintained (you can't just change whatever you want). Also, it seems some Attributes that in EHM07 didn't change now do, and some Attributes that in EHM07 rarely changed/changed very little now develop "normally"
The more one looks at things from the editing perspective, the more one realizes how different EHMEA is from EHM07.
The evidence doesn't at all support those that thought/think EHMEA is basically the same game as EHM07
Re: EHM:EA Database Editor
Posted: Sun Aug 16, 2015 6:48 pm
by Xvash2
Is there any way yet to get only 12 teams into the NHL?
Re: EHM:EA Database Editor
Posted: Sun Aug 16, 2015 7:12 pm
by Manimal
Xvash2 wrote:Is there any way yet to get only 12 teams into the NHL?
Unfortunately not.
Image the quality of teams if the NHL only had 12 teams (and no cap, or crazy high one)
Re: EHM:EA Database Editor
Posted: Mon Aug 17, 2015 4:21 am
by Xvash2
I haven't looked, but I'm curious how the retro rosters are set up then?
Re: EHM:EA Database Editor
Posted: Mon Aug 17, 2015 4:35 am
by nino33
Xvash2 wrote:I haven't looked, but I'm curious how the retro rosters are set up then?
There are currently only two "set up" choices - the current/modern (2014-15 at present) set up, and the 2006 set up (i.e. just like the EHM07 days, the database has to have the number of teams/divisions and the same rules/playoffs as there were for 2006-07)
So currently, retro rosters still have to have 30 NHL teams like they did with EHM07.
The 1979 and 1998 databases have "fake teams" to ensure 30 teams.
The 1974 database used the 18 NHL teams and the 12 WHA teams to ensure 30 NHL teams.
I'm really hopeful that in the future (I'm thinking many months, but hopefully not years!) we'll be able to reduce the number of teams & adjust rules/playoffs and budgets/contracts.
We can now adjust the names of Leagues/Divisions (something we couldn't do in EHM07), but I don't think there's any retro databases that've taken advantage of this feature yet (no retro database has been updated yet since EHM:EA's release).
I've been working on both the 1974 and 1998 databases this summer, and I expect there to be updated versions released later this year (versions that are improved in general, and also include the new Player Roles and other adjustments that are needed to make them EHM:EA databases).
Re: EHM:EA Database Editor
Posted: Thu Aug 20, 2015 10:25 pm
by FalseCredential
I'm not sure if this is a stupid question or not, as I've never posted before, but is there an easy way to remove all of the players at the NHL level from a database? I have a desire to see what the quality of the league would become if every NHL team was forced to make a "franken-roster" from the scraps that are left over and develop over the years from there. I tried to mess around with the Database editor, but I could not get the edited file I was attempting to import to be recognized (I received an error for the file type even though it was an xml). Would I just delete the current players and then replace them with free agents on the teams? Balance issues don't concern me greatly, but the other thought would be issues with the salary cap floor.
Re: EHM:EA Database Editor
Posted: Thu Aug 20, 2015 10:55 pm
by nino33
FalseCredential wrote:I'm not sure if this is a stupid question or not, as I've never posted before, but is there an easy way to remove all of the players at the NHL level from a database? I have a desire to see what the quality of the league would become if every NHL team was forced to make a "franken-roster" from the scraps that are left over and develop over the years from there. I tried to mess around with the Database editor, but I could not get the edited file I was attempting to import to be recognized (I received an error for the file type even though it was an xml).
I think your post here is in the wrong place, as the EHM:EA Editor (this thread) is a work-in-progress and doesn't actually exist to be used yet!
Currently the only database editing option is to use an EHM07 Editor and import the edited database into EHM:EA.
You can edit an EHM07 database using the EHM Updater
http://www.ehmtheblueline.com/forums/vi ... 10&t=11154 or the the Pregame Editor
http://www.ehmtheblueline.com/forums/vi ... =88&t=6745
Sounds like you're using the EHM Updater.
You can't import using the same spreadsheets as are exported.
You export data, edit, copy/paste into templates and then import the edited data.
I believe everything you need to know is in the ReadMe that comes with the Updater.
FalseCredential wrote:Would I just delete the current players and then replace them with free agents on the teams? Balance issues don't concern me greatly, but the other thought would be issues with the salary cap floor.
I've not heard of anyone doing this before...I think you'd retire the players, then use the updater to delete the retired players. You could use free agents or create players or try to let the teams do it themselves (I suspect whatever you decide, over time the NHL teams will sign every "decent player" from other Leagues worldwide, especially the top Leagues in Russia/Sweden/Finland/Germany + the players from the AHL/ECHL + the young players coming up from junior)
If you're trying to remove all "NHL talent" worldwide you need to remove all players with a PA of 120-180 & also remove all players with a PA of -15, -14, -13, -10, -9, -8 and -7. This will give you a hockey world without even the poorest of NHL talent!
If you want to keep the fringe players and 4th liners and maybe some 3rd liners, you could make your range a PA of 140-180 & also remove all players with a PA of -15, -14, -10, -9, -8 and -7.
As for Salary Cap/Floor, not sure....if you're creating players for the NHL, perhaps using "0" (so the game generates a value) for their salary will ensure teams have salary totals above the floor; or give some created players higher salaries to ensure things work (though I have read that the only "result" of being under the Salary Floor is your team gets fines, so it doesn't sound like it should be a concern)
If you do do such a thing and get it working, let us know how it goes (I'm curious what scoring would be like & what salaries would be like)

Re: EHM:EA Database Editor
Posted: Thu Aug 20, 2015 11:28 pm
by FalseCredential
I apologize for posting in the wrong thread! If I get this experiment working I will create a post by itself.
Re: EHM:EA Database Editor
Posted: Fri Aug 21, 2015 12:13 am
by nino33
I figured I'd post your PM/my response here, and if a MOD wants to move these posts they can...
FalseCredential wrote:My plan is to only remove the players in the actual NHL, which in theory would change the game a good bit and do exactly as you have said, migrate the rest of the remaining talent to the NHL over time. I only generally know the basics of the EHM07 editor, so I'll try to carry out my plan, but any other tips would be appreciated! I don't intend to create any new players, but I'm worried that retiring the current players will somehow "break" the game because the NHL rosters will be empty. Would the sudden lack of talent and forced use of the less talented leftovers in FA cause the salary scale for talent to adjust by itself?
I think I gave my best tips above HaHa
To my knowledge no one has tried what you're proposing (or anything like it) with EHM:EA yet, so I'm not sure how it'll work out.....with EHM07 you could create an almost empty database (I think the Updater has a feature to do so), but I don't know anyone who's tried importing it into EHM:EA
Re: EHM:EA Database Editor
Posted: Fri Aug 21, 2015 12:30 am
by FalseCredential
What template would I use to make the import work? As far as I've figured out, I export the player_info file and take the data from there, but there doesn't seem to be a comparable template created by the updater. Like I said, I barely know what I am doing haha
Re: EHM:EA Database Editor
Posted: Fri Aug 21, 2015 12:49 am
by nino33
I usually use the exported_attributes file as a starting point for most everything I do...
I think you want to retire all NHLers...you'd copy/past their Name and DOB from the exported_attributes file to the contract_update template.
Then set all the players to retire (see page 41 of the ReadMe), and then import the contract_update file.
Once you've done the above you should have all the players you want retired.
Next open the Updater, load the database, and then on the Database tab select "Database Optimization" - this will delete your retired players (with EHM07 sometimes retired players seem to be used again by the game).....save your database, and you should be good to go!
Re: EHM:EA Database Editor
Posted: Fri Aug 21, 2015 12:56 am
by FalseCredential
Thank you so much! Sorry for the questions! I'll let you know how it all goes
Re: EHM:EA Database Editor
Posted: Fri Aug 21, 2015 3:41 am
by nino33
FalseCredential wrote:So I've taken to calling my experiment "Wasteland". Everything seems to be working with the NHL rosters having been retired and the teams seem to be transitioning as I had hoped. Scoring, albeit in a small sample size, seems to have stayed consistent with the normal rates. The biggest problem is the Salary Floor, as the average Team salary ended up being around $16-22 million, which would result in upwards of $1.5 million fines. I edited the corresponding file to change it to a $15 million cap floor, but I'll play around with that further if it needs more adjusting. Thanks for the tips, this seems to be working perfectly!
You're welcome!
FYI I'm posting your PM here as I think it's helpful to share such information (I've learned a ton via reading about the experiences of others!)
Re: EHM:EA Database Editor
Posted: Thu Aug 27, 2015 7:40 pm
by jesarino
Hey guys! I haven't seem an update in awhile - how is the actual EHM:EA Editor coming along?
Re: EHM:EA Database Editor
Posted: Thu Aug 27, 2015 7:57 pm
by Manimal
jesarino wrote:Hey guys! I haven't seem an update in awhile - how is the actual EHM:EA Editor coming along?
Very slowly as Archi has/is been busy with getting married and moving
Re: EHM:EA Database Editor
Posted: Thu Aug 27, 2015 8:20 pm
by nino33
He's been working on the next version of the EHM Updater since last year (and that's not ready yet, though hopefully soon!).....it's only been 3 months since he started working on the EHM:EA Editor, so I think it's a long ways off
Re: EHM:EA Database Editor
Posted: Fri Aug 28, 2015 12:34 pm
by archibalduk
Yeah it's some time off I'm afraid. I could have probably had a basic editor done by now, but I need to devote my time to the Updater and updating the rosters right now.

Re: EHM:EA Database Editor
Posted: Fri Sep 04, 2015 5:29 pm
by jesarino
No worries guys ... thanks for the update. We appreciate all the hard work that you do in your spare time!
Re: EHM 1 Database Editor
Posted: Sun Dec 06, 2015 8:44 pm
by archibalduk
Re: EHM 1 Database Editor
Posted: Mon Dec 07, 2015 6:16 pm
by zbguy
Nice! Thanks for the update