I know how to switch affiliation but what is the best way to transfer all the players from team A to team B?
Ex: If Vancouver Canucks players where with Lake Erie and Vancouver switched affiliation to Utica, do I have to change one by one in the pre game editor?
Affiliation change and player moves
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
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
- Asbeen
- Drafted
- Posts: 161
- Joined: Wed May 03, 2006 2:41 pm
- Location: Gatineau
- Contact:
- 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: Affiliation change and player moves
Or you could use the EHM Updater.
If you use the Pre-game editor, you can filter the players by selecting 'Club playing for'. Saves time not to have to type all player names
If you use the Pre-game editor, you can filter the players by selecting 'Club playing for'. Saves time not to have to type all player names
- Asbeen
- Drafted
- Posts: 161
- Joined: Wed May 03, 2006 2:41 pm
- Location: Gatineau
- Contact:
Re: Affiliation change and player moves
Do you know how to do it with the Ehm Updater?Manimal wrote:Or you could use the EHM Updater.
If you use the Pre-game editor, you can filter the players by selecting 'Club playing for'. Saves time not to have to type all player names
- Asbeen
- Drafted
- Posts: 161
- Joined: Wed May 03, 2006 2:41 pm
- Location: Gatineau
- Contact:
Re: Affiliation change and player moves
Just downloaded the Ehm Updater, I'll have some reading to do I guess! 

- 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: Affiliation change and player moves
Not sure if the Updater is faster than the editor, actually. I always use the pre-game editorAsbeen wrote:Just downloaded the Ehm Updater, I'll have some reading to do I guess!
- archibalduk
- TBL Admin Team
- Posts: 20373
- 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: Affiliation change and player moves
Switching players from Team A to Team B is probably quicker using the Updater. But this is only the case if you know how to use the Updater.
Off the top of my head, you could do it as follows:
1) Load the Updater -> Spreadsheet menu -> Create Templates
2) Load your DB in the Updater -> At the bottom of the Home Screen, select "Staff" from the Export Data drop-down menu and click on the Export button.
3) Load the exported_staff spreadsheet you created in Step #2 using Excel/OpenOffice.
4) Within exported_staff, select Row 2 (by clicking on the "2") and either use the Sort Option to sort by Club Contracted or use the Auto Filter to filter Club Contracted to filter out those players/staff contracted to Team A.
5) You should now have the players/staff from Team A listed in your exported_staff file. Copy and paste the player/staff names & DOBs from your exported_staff to your contract_update spreadsheet (this spreadsheet will have been created when you followed Step #1 above).
6) In contract_update, enter the name of Team B for each player under the Club Contracted column. Save your spreadsheet and exit Excel.
7) In the Updater click on Import -> Select you contract_update file and click on OK.
8) Done!
If I can find a way of uploading a video to YouTube to show how this works then I'll try and get something uploaded. I think it'd be much easier using a visual example.
Off the top of my head, you could do it as follows:
1) Load the Updater -> Spreadsheet menu -> Create Templates
2) Load your DB in the Updater -> At the bottom of the Home Screen, select "Staff" from the Export Data drop-down menu and click on the Export button.
3) Load the exported_staff spreadsheet you created in Step #2 using Excel/OpenOffice.
4) Within exported_staff, select Row 2 (by clicking on the "2") and either use the Sort Option to sort by Club Contracted or use the Auto Filter to filter Club Contracted to filter out those players/staff contracted to Team A.
5) You should now have the players/staff from Team A listed in your exported_staff file. Copy and paste the player/staff names & DOBs from your exported_staff to your contract_update spreadsheet (this spreadsheet will have been created when you followed Step #1 above).
6) In contract_update, enter the name of Team B for each player under the Club Contracted column. Save your spreadsheet and exit Excel.
7) In the Updater click on Import -> Select you contract_update file and click on OK.
8) Done!
If I can find a way of uploading a video to YouTube to show how this works then I'll try and get something uploaded. I think it'd be much easier using a visual example.
- 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: Affiliation change and player moves
For me, I do that faster in the pre-game editor with the filter to 'club playing for'
- archibalduk
- TBL Admin Team
- Posts: 20373
- 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: Affiliation change and player moves
Yeah I think the Updater is more advantageous when you're looking at larger bulk changes. Otherwise you're best off with the Pre Game Editor.Manimal wrote:For me, I do that faster in the pre-game editor with the filter to 'club playing for'