Relocating a NHL team with EHM1 editor

[Ukko]

Hello

I would like to relocate one NHL team and its AHL + ECHL affiliates (with full rename + relocation of affiliates) from one city to another, and with minor Division changes (switching two teams afterwards).
No player moves or anything, just rename/rebrand of the 3 teams and moving.

I have done all the edition in the EHM 1 editor and I am struggling to understand how I can create a new game in EHM using this db.
I am looking for something similar to this : http://www.ehmtheblueline.com/forums/vi ... 90&t=17678 but I will not change players' statuses in my game. I just want a cosmetic/geographic change.

Do I have to put the database.db file in the EHM directory and then import the db ? Or is it easier to start from a save and edit it ?


The relocation is set as follows :
Carolina Hurricanes becomes the Quebec Nordiques and goes to Atlantic Division.
Boston Bruins moves to Metropolitan Division

Affiliates :
Quebec Nordiques (Quebec City,QC / NHL, Atlantic) >> Duluth Harfangs (Duluth,MN / AHL, Midwest) >> Portland Pirates (Portland, ME / ECHL)


Thanks for helping !


edit : as I am checking the Hurricanes' roster in the latest db, I might want to "fire" a few players and shop a bit among free-agents. Let's say I'd like to remove maybe a third of the franchise's players. As colinrsmall did, I need to erase their info in the editor, player by player, which doesn't frighten me too much, is that a good way to do it ?

[archibalduk]

Put your database.db file in a sub-folder of you database folder. Edit the database using the Editor and then start a new game in EHM. Do not use the Import function. The flowchart below shows how the Editor works with different types of DB:

[Ukko]

Will try this out tomorrow eve.

Quick question : does changing the teams' names and affiliation, plus the leagues' rules is enough ? Or shall I hunt down every player of the Canes franchise and change their contract attributes ?

[archibalduk]

Just renaming the team name will be enough.

[nino33]

Just renaming the team name will be enough.

Really? Do just renaming The Carolina Hurricanes the Quebec Nordiques will automatically make all of Carolina's players Quebec's players?

I suppose that makes sense...does that mean, because Carolina is no longer in the database (because they've been overwritten) that all their history will show as Quebec now? so for example their 2006 Stanley Cup will show as being won by Quebec?

[Alessandro]

Just renaming the team name will be enough.

Really? Do just renaming The Carolina Hurricanes the Quebec Nordiques will automatically make all of Carolina's players Quebec's players?

I suppose that makes sense...does that mean, because Carolina is no longer in the database (because they've been overwritten) that all their history will show as Quebec now? so for example their 2006 Stanley Cup will show as being won by Quebec?

Yes, of course.

[Ukko]

Very nice ! Thanks for the info, I will try this out this afternoon

I'll edit the Stanley cup history if I can, I wanna try to win the 1st cup of the Franchise

[nino33]

Just renaming the team name will be enough.

Really? Do just renaming The Carolina Hurricanes the Quebec Nordiques will automatically make all of Carolina's players Quebec's players?

I suppose that makes sense...does that mean, because Carolina is no longer in the database (because they've been overwritten) that all their history will show as Quebec now? so for example their 2006 Stanley Cup will show as being won by Quebec?

Yes, of course.

Can you still make a team Defunct, instead of overwriting them?
And can you actually create a team if it's not in the database?

Wouldn't a lot more than just Stanley Cup history change if you overwrite a team? Wouldn't "everything" change, like previous seasons Team History, stat lines (Team Player For) for players and Team/League Records?

IMO the few minutes it takes to change the Team Contracted To/Playing For from one to the other for a few dozen players (in this case from Carolina to Quebec) are worth it to not lose previous history/records + have correct team history/records for the "new" team (or in cases of reestablishing a team by creating it, blank team records would be IMO better than incorrect/unrelated team records from the original overwritten team)

[Ukko]

Yes I think it would be better and worth it to move the players to a new team instead of editing an existing franchise's history and legacy.

About moving Boston to Metropolitan and Quebec/Carolina to Atlantic, how does it work? I edit the teams' info and league rules? Or I'm missing things I need to do

[archibalduk]

You need to edit their Detailed Division settings on the Club editing screen. Then in the Leagues & Structures screen you'll need to edit the NHL (via the Structure tab). The same goes for bringing a new team in for another - just revise the League/Detailed Division and Structure accordingly.

[Ukko]

Yes, thanks a lot

I'll start a blog once it's up and running !

[Manimal]

If you are adding a new team instead of Carolina but with the Hurricanes players, remember to add the ones with rights too. Also, Aleksi Saarela's loan, the traded draft picks and the cap penalties needs to be edited in the extra_config

[nino33]

Archi - with your EHM1 Editor, can you make a team defunct but still existing in the database (so history/records referencing said team remain)? And can you create a team "from scratch" that wasn't in the database to begin with?

[Alessandro]

Archi - with your EHM1 Editor, can you make a team defunct but still existing in the database (so history/records referencing said team remain)? And can you create a team "from scratch" that wasn't in the database to begin with?

All the teams are retained for such purpose, you just need to select "retain all teams" option when you create new games

[archibalduk]

Archi - with your EHM1 Editor, can you make a team defunct but still existing in the database (so history/records referencing said team remain)? And can you create a team "from scratch" that wasn't in the database to begin with?

Yes and yes. As Alessandro mentions above, you will need to tick the "Retain all teams" option when starting a new game in order for the histories to refer to that defunct team rather than "Unknown Team" in game.

The next version of the Editor is, as far as I'm aware, on a par with the EHM 2007 Pre-Game Editor in that all data can be edited and you can create new items in each table (i.e. you can add new clubs, staff, competitions, playable competitions, histories, etc etc).

[nino33]

Thanks Arch!

The reference earlier to just overwriting the team name/renaming would make it no longer exist right? So retaining teams wouldn't help, as that team would no longer exist in the database; seems to me just overwriting a team is never the way to go but rather always make teams defunct (and create teams as necessary) and always move players and player rights one-by-one)

[Manimal]

We have the option of making a teams history appear under a different name in the import_config.
That way you can keep the old history and stats as some franchises decided to keep such stuff when re-locating

[archibalduk]

Thanks Arch!

The reference earlier to just overwriting the team name/renaming would make it no longer exist right? So retaining teams wouldn't help, as that team would no longer exist in the database; seems to me just overwriting a team is never the way to go but rather always make teams defunct (and create teams as necessary) and always move players and player rights one-by-one)

If the "new" team is the successor to the team to be overwritten (i.e. the old history should carry over) then I think, as a general rule, you should overwrite the existing item. If it is an entirely new team then I'd agree that a new team should be created.

We have the option of making a teams history appear under a different name in the import_config.
That way you can keep the old history and stats as some franchises decided to keep such stuff when re-locating

I need to figure out how this works once the database has been converted. AFAIK the import_config file has no relevance once the database is in EHM 1 format. So I wonder how or if we can use this option for updating franchises in an EHM 1 format database... I'll add this to my list of things to look at.

[nino33]

So if you overwrite Carolina with Quebec Nordiques, and the database already has a Quebec Nordiques...what does the Editor do? Is the end result two teams that are named the Quebec Nordiques and no team named the Carolina Hurricanes, like what would happen using the old EHM07 PreGame Editor? Or does the Editor "know" when overwriting Carolina that it's using the Quebec Nordiques that already exists, and not creating another one by overwriting?

[archibalduk]

So if you overwrite Carolina with Quebec Nordiques, and the database already has a Quebec Nordiques...what does the Editor do? Is the end result two teams that are named the Quebec Nordiques and no team named the Carolina Hurricanes, like what would happen using the old EHM07 PreGame Editor? Or does the Editor "know" when overwriting Carolina that it's using the Quebec Nordiques that already exists, and not creating another one by overwriting?

It behaves in exactly the same way as the EHM 2007 Pre-Game Editor. So you can add as many teams as you like with the same team name.

[nino33]

Thanks Arch!

The reference earlier to just overwriting the team name/renaming would make it no longer exist right? So retaining teams wouldn't help, as that team would no longer exist in the database; seems to me just overwriting a team is never the way to go but rather always make teams defunct (and create teams as necessary) and always move players and player rights one-by-one)

If the "new" team is the successor to the team to be overwritten (i.e. the old history should carry over) then I think, as a general rule, you should overwrite the existing item. If it is an entirely new team then I'd agree that a new team should be created.

If you use overwriting, doesn't the "old team" you're overwriting cease to exist? And thus all old records of the team before relocations would show as the new team?

Maybe it's a personal preference thing, but I'd want the records/history to show the actual team of that year, and not the "new team" that existed in the future

[nino33]

So if you overwrite Carolina with Quebec Nordiques, and the database already has a Quebec Nordiques...what does the Editor do? Is the end result two teams that are named the Quebec Nordiques and no team named the Carolina Hurricanes, like what would happen using the old EHM07 PreGame Editor? Or does the Editor "know" when overwriting Carolina that it's using the Quebec Nordiques that already exists, and not creating another one by overwriting?

It behaves in exactly the same way as the EHM 2007 Pre-Game Editor. So you can add as many teams as you like with the same team name.

But they're ultimate based on Team ID # right?
So if you overwrite the Carolina Hurricanes with the Quebec Nordiques in the TBL 9.0b database, all you do is create a second Quebec Nordiques team while totally erasing the Carolina Hurricanes from existence...so the 2006 Stanley Cup winners wouldn't/couldn't show as the Carolina Hurricanes because they weren't made defunct, they were overwritten/deleted

Overwriting Carolina with Quebec doesn't activate the defunct Quebec right? Doesn't it create a second Quebec Nordiques? And make it so the Carolina Hurricanes never existed?

[archibalduk]

If you use overwriting, doesn't the "old team" you're overwriting cease to exist? And thus all old records of the team before relocations would show as the new team?

Maybe it's a personal preference thing, but I'd want the records/history to show the actual team of that year, and not the "new team" that existed in the future

Yes exactly. However, the import_config file lets you have former franchise names for a team which will then show in a player's career history entries for the chosen years. But if you're looking for a clean slate with team records, etc then creating a new separate team is the way to go.

But they're ultimate based on Team ID # right?
So if you overwrite the Carolina Hurricanes with the Quebec Nordiques in the TBL 9.0b database, all you do is create a second Quebec Nordiques team while totally erasing the Carolina Hurricanes from existence...so the 2006 Stanley Cup winners wouldn't/couldn't show as the Carolina Hurricanes because they weren't made defunct, they were overwritten/deleted

Overwriting Carolina with Quebec doesn't activate the defunct Quebec right? Doesn't it create a second Quebec Nordiques? And make it so the Carolina Hurricanes never existed?

Yes it is all ultimately based upon Team ID - so exactly as you describe above.

The basis of the EHM 1 and EHM 2007 DBs is exactly the same. It's just that the EHM 1 DB includes some additional fields and tables. Similarly, the basis of the EHM 2007 Pre-Game Editor and EHM Editor is exactly the same.

[nino33]

If you use overwriting, doesn't the "old team" you're overwriting cease to exist? And thus all old records of the team before relocations would show as the new team?

Maybe it's a personal preference thing, but I'd want the records/history to show the actual team of that year, and not the "new team" that existed in the future

Yes exactly. However, the import_config file lets you have former franchise names for a team which will then show in a player's career history entries for the chosen years. But if you're looking for a clean slate with team records, etc then creating a new separate team is the way to go.

Just to clarify for anyone editing and reading this, it's not just the "clean slate" for the new team I'm thinking of, but also the losing of a team showing in League history/records by overwriting a team (such as overwriting Carolina with Quebec would remove the Carolina Hurricanes from the list of Stanley Cup winners)

[Ukko]

Well, here's the status :

I've created the Nordiques, Harfangs and Pirates from scratch, and edited all the team info for them.
I have edited the NHL, AHL and ECHL rules in order to have the teams in their supposed divisions

I have put the whole Hurricanes' roster as Nordiques players, and some Charlotte Checkers were moved to Harfangs.

It crashes in EHM when loading "start a new game".. I have no idea why, but I suspect the Nordiques' creation date set up to 2016 and some players' contracts older than 2016 are the issue.

I changed the Nordiques' creation date to 1972, didnt work..