Affiliation change and player moves

Discuss all aspects of editing the data and databases in EHM here. Have a question about the EHM Editor, EHM Assistant, editing the .cfg files, hex editing the .dat or .db files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
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
Post Reply
User avatar
Asbeen
Drafted
Posts: 161
Joined: Wed May 03, 2006 2:41 pm
Location: Gatineau
Contact:

Affiliation change and player moves

Post by Asbeen »

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?
User avatar
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

Post by Manimal »

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
User avatar
Asbeen
Drafted
Posts: 161
Joined: Wed May 03, 2006 2:41 pm
Location: Gatineau
Contact:

Re: Affiliation change and player moves

Post by Asbeen »

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
Do you know how to do it with the Ehm Updater?
User avatar
Asbeen
Drafted
Posts: 161
Joined: Wed May 03, 2006 2:41 pm
Location: Gatineau
Contact:

Re: Affiliation change and player moves

Post by Asbeen »

Just downloaded the Ehm Updater, I'll have some reading to do I guess! :)
User avatar
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

Post by Manimal »

Asbeen wrote:Just downloaded the Ehm Updater, I'll have some reading to do I guess! :)
Not sure if the Updater is faster than the editor, actually. I always use the pre-game editor
User avatar
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

Post by archibalduk »

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.
User avatar
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

Post by Manimal »

For me, I do that faster in the pre-game editor with the filter to 'club playing for'
User avatar
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

Post by archibalduk »

Manimal wrote:For me, I do that faster in the pre-game editor with the filter to 'club playing for'
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.
Post Reply