EHM 2007 Updater (A Pre-Game & Saved Game Editor)

[Manimal]

I get the 'too many columns error' when I copy info into a XML-file (template) sometimes. However, I don't always get it

[archibalduk]

Upload or email the file to me when you next get the error and I can check it out.

[Manimal]

I noticed a peculiar and annoying thing when editing a staff_new.xml file.
If I delete several rows at a time, then I get an error when trying to save the file. Deleting one row at a time works fine.

[archibalduk]

That sounds like a Libre/OpenOffice issue. I'm afraid there's nothing I can do about that. I don't know if it helps, but a new version of LibreOffice was released today - http://www.libreoffice.org/download/libreoffice-fresh/

Btw I received your xml file with the too many columns error. I'll hopefully find time to check it next week. I haven't had time this week and I'm away this weekend.

[Manimal]

That sounds like a Libre/OpenOffice issue. I'm afraid there's nothing I can do about that. I don't know if it helps, but a new version of LibreOffice was released today - http://www.libreoffice.org/download/libreoffice-fresh/

Btw I received your xml file with the too many columns error. I'll hopefully find time to check it next week. I haven't had time this week and I'm away this weekend.

No rush. I copied the info into a working file

[Mike Lowe]

Every time I try and run this, I get the following error. I've tried numerous saved leagues:

http://screencast.com/t/dzq6yNv9ER44

[archibalduk]

The Updater is only compatible with uncompressed saved games. Are you sure your game is not compressed?

[Mike Lowe]

How do I know the difference with these files? Total noob here.

[nino33]

The Updater is only compatible with uncompressed saved games. Are you sure your game is not compressed?

How do I know the difference with these files? Total noob here.

When starting a new game, from the main/initial screen click on Preferences (bottom of the screen)...then make sure Save Compressed is unchecked
For a game already started, load game and click on Options (top right of screen), select Preferences, then then make sure Save Compressed is unchecked

[Muznick]

So I just started playing with the updater, made some chanes in Jiri Sekac's potential ability. I don't know if it worked but his age is now -56. In my excel sheet I didn't change his DOB. Any idea what I'm doing wrong?

EDIT: I just modified his height so I know it works. His DOB is still 1992 and we are still in 2014..why is he -56 years old??

[sTeeL86]

I get EHM2007 Updater has stopped working each time I try to load a saved game.

[archibalduk]

I get EHM2007 Updater has stopped working each time I try to load a saved game.

The EHM 2007 Updater is compatible with EHM 2007 saved games only. Are you trying to use it to load an EHM:EA saved game?

If you're trying to load an EHM 2007 saved game, make sure you haven't enabled "Save Compressed" in EHM. If you have disable it, re-save your game and then try re-loading in the Updater.

[sTeeL86]

Apologies. Was attempting to use it with EA version. Will we have an EA Updated version of this program soon?

[archibalduk]

Apologies. Was attempting to use it with EA version. Will we have an EA Updated version of this program soon?

I'm afraid not for the time being. The new DB structure hasn't been published and I imagine it'll be fluid for now anyhow.

In the mean time, the best thing to do is to edit an EHM 2007 database and then import it into EHM:EA.

[mpronger]

Any ideas if a EHM EA version is possible? I didn't expect 2007 to work with EA saved game, but I was surprised that it loaded most of the file until it stuck on 85% whilst loading "player_stats_hist.tmp" so maybe not much has changed in the saved game structure?

[archibalduk]

I'm afraid it won't be any time soon. I need SI to release details of the DB structure in order for me to do anything. But it's not a major problem right now as I'll continue improving the EHM 2007 one in the meantime.

I haven't looked at the EHM:EA saved game structure, but it must have a similar header to that as the EHM 2007 saved game. That'll explain why it will load the saved game to some extent before crashing. The DB structure (and that means the saved game too as that is basically a modified DB) is so different in EHM:EA that it won't be able to read any of the data even if it hadn't have crashed.

[archibalduk]

I was looking at the NCAA in the new editor and it definitely does need some work. I was going to try to play around with putting all of the teams in one league to see how that worked, but I can't figure out (or remember) how to change stuff like that. I exported the clubs and tried changing some stuff, but I don't know how to put that file back into the DB. Any help or is that not available in the new editor?

You cannot edit teams via the Updater right now (but you will in the next version or two). You have to use the Pre-Game Editor.

Another thing I noticed about the editor is that when I exported all, they came out as xml. When I changed it to csv and tried to export all, they still came out as xml. If I exported things individually though, they came out as csv. It may just be a small bug.

Thanks!

Via the Spreadsheet menu, click on 'Use CSV Spreadsheets' if you want to export all as CSV.

[Spartacus70]

Ok I made some tests this morning related to player role in EHM-EA. I used of course the new version of the updater and everyting looked fine on the spreadsheets. I put Lafleur and Dionne all around (w_all_around and c_all_around) and B. Orr d_standard on my 1974 roster. I imported the data and started a new game and voila! the roles are not the same in game : B. Orr in the position screen is skilled deffenseman and Lafleur is playmaker (with scoring ability scaled down...).

[nino33]

Ok I made some tests this morning related to player role in EHM-EA. I used of course the new version of the updater and everyting looked fine on the spreadsheets. I put Lafleur and Dionne all around (w_all_around and c_all_around) and B. Orr d_standard on my 1974 roster. I imported the data and started a new game and voila! the roles are not the same in game : B. Orr in the position screen is skilled deffenseman and Lafleur is playmaker (with scoring ability scaled down...).

Hmmm...maybe the game engine uses Attributes to deduce Player Role if the Attributes are there [though it seems it may "adjust" these Attributes as well as the Player Role (based on the inputted Attributes)]...and if a player has "0" for their Attributes then the game engine uses the Player Role without changing it?

Eventually it'd be nice to start with the blank DB and test a bunch of players at different CA/PA levels and different Player Roles, but otherwise "0" for all Attributes (including Offensive/Defensive Role)...would similar CAs and Player Roles produce similar Attributes?

At this point I trust that Player Role in the end will be correct/relevant! HaHa and I'm busy enough with the initial work to adjust/tweak the EHM07 DBs to EHM:EA...and Riz hasn't explained a lot yet, and things are in a state of change/development (the release announcement stated there will be "some major improvements to player progression" coming in the second update, which will be April 23rd) - sure is a busy time of change/development!

[Spartacus70]

You are right Nino! I will continue populating the roster and adjusting the prospects at 14yrs before to be worried about some things that Riz will explain later.

[Kojuk]

Does anyone have a list of the different player roles? I believe that it was mentioned there was approximately 50 roles. These are the ones I've found so far:
1. c_all_around
2. c_def
3. c_finesse
4. c_playmaker
5. c_playmaker_finesse
6. c_playmaker_physical
7. d_def
8. d_def_finesse
9. d_def_physical
10. d_off
11. d_off_physical
12. d_playmaker
13. d_rugged
14. d_standard
15. g_butterfly
16. g_mixed
17. g_standup
18. g_unorthodox
19. w_all_around
20. w_def_finesse
21. w_def_physical
22. w_finesse
23. w_grinder
24. w_playmaker
25. w_power_forward
26. w_sniper_finesse
27. w_sniper_physical

[umwoz]

Very hard to judge how we should proceed without knowing whats going on with player development. Also, it seems there's only a correlation between the db role and the in game role. I suppose as long the attributes hold true it doesn't matter much.

[archibalduk]

There's a Player Roles.pdf file I wrote and included with the Updater download. It lists every setting (from memory, there are 46 of these).

[archibalduk]

UPDATER SPREADSHEETS

Here is a guide on the basics of the most commonly used Updater Spreadsheets. This only covers the very basics. Additional information can be found by reading the User Manual included with the EHM Updater zip file: http://www.ehmtheblueline.com/forums/vi ... 88&t=13532


ATTRIBUTE_UPDATE
This spreadsheet is used to edit player attributes. You must enter the player’s name and date of birth in the far left hand columns (the spelling and DOB must match the data in the database). The rest of the spreadsheet is optional. Just enter bits you want to edit. Anything you leave blank will remain unedited in the database.

For Player Roles, please see ’Player Roles Guide.pdf’ mentioned earlier. You will see that there is a ’Setting’ column in the pdf file – these are the settings you can enter into the Updater Spreadsheet.

You can edit/set a new date of birth using the far right columns of the spreadsheet (columns BZ – CB). If only the year of birth is known, enter the day and month as zero (e.g. 0/0/1992).

Height is usually entered as centimetres and weight as kilograms. It is possible to enter imperial measurements using a special setting – if you want to do so, please ask and we will explain how to do this.




NONPLAYER_UPDATE
This spreadsheet is used to edit non-player attributes. You must enter the non-player’s name and date of birth in the far left hand columns (the spelling and DOB must match the data in the database). The rest of the spreadsheet is optional. Just enter bits you want to edit. Anything you leave blank will remain unedited in the database.

You can edit/set a new date of birth using the far right columns of the spreadsheet (columns BZ – CB). If only the year of birth is known, enter the day and month as zero (e.g. 0/0/1992).




CONTRACT_UPDATE
This spreadsheet is used to move players/non-players to other teams/free agency, edit their contracts and retire them. You must enter the non-player’s name and date of birth in the far left hand columns (the spelling and DOB must match the data in the database). The rest of the spreadsheet is optional.

To move a player/non-player to a new team: Enter the team name in the Club Contracted column (you do not have to enter anything into the Club Playing For unless you want to also loan the player or assign him to an affiliate.

To move a player/non-player to a free agent: Enter _ufa in the Club Contracted column.

To retire a player/non-player: Enter _retire in the Club Contracted column. The player/non-player will be deleted from the database. NOTE: If the player/non-player is likely to return in the future, then just make him a free agent and let Manimal know that he needs to be temporarily retired (we can retire him via extra_config.cfg instead).

Add/edit team rights: Use either or both of the Add Rights columns. Enter the team(s)’s names into these columns. If a team in the same league already has rights to the player, those rights will be automatically removed. To remove all existing rights, enter _remove_all in the Delete Rights column (you can also enter a team’s name in this column to remove rights for that team).

Contract Expiry Dates: For European teams, always enter the expiry date of 30 April. For North American teams, always enter the expiry date of 30 June. If you do not know how long the contract is, enter 1 February 1900.




STAFF_NEW
This spreadsheet is used to create new players/non-players. You must enter all of the following details (the rest is optional):

- FIRST NAME & SECOND NAME
- DATE OF BIRTH: If you only know the year of birth, then leave the day and month columns blank.
- PRIMARY NATIONALITY: Enter the name of the nation (e.g. Germany) rather than the nationality (e.g. German).
- JOB FOR CLUB: Enter one of the following options:

• Player
• Player/Coach (note that there are no spaces either side of the slash ‘/’)
• GM/Coach (note that there are no spaces either side of the slash ‘/’)
• GM
• Assistant GM
• Head Coach
• Coach
• Scout
• Physio
• Chairman
• Managing Director
• President
• Director of Personnel

Some notes about some of the optional data:
- BIRTH PLACE: Enter the name of the city and the nation of the city
- CLUB CONTRACTED & CLUB PLAYING FOR: See the notes about Contract_Update[/] as the same principles apply
- DECLARED NATION: 0 = None declared, 1 = Primary nation declared, 2 = Secondary nation declared
- JUNIOR PREFERENCE: Possible options: none, College, Major Junior, Europe

[Midas]

Arch your updater is fantastic as always. I'm glad birthplaces were added to the import function, but at the moment the export function lacks a birthplace section. As the game doesn't fill them in automatically, leaving it completely blank, this would be a problem for things like the CHL (which parse player availability by region). Would it be possible to include this in future versions? It would go a long way in making creating completely fictional databases easier !