EHM The Blue Line

The EHM 2007 Updater is a database and saved game editor for Eastside Hockey Manager 2007. Both databases and saved games can be edited using CSV/XML spreadsheets which are imported using the Updater. Data can also be exported from databases and saved games (such as player attributes, schedules and scores).

The EHM Updater is designed to make the task of mass editing EHM’s database easier. Updater files can be created using Excel / LibreOffice / OpenOffice which can then be applied to the database. The changes you want to make are simply entered into the XML/CSV spreadsheet files and then the Updater will process and apply the changes.

The Updater is also able to export data from the database. This may be useful for checking the database, etc. but it can also form the basis of an updater file itself. For example, the player career history can be exported from one database and then imported into another database.

The Updater also includes a variety of data validation functions and other tools, such as a free agent utility.

Questions and comments can be posted via the official support/discussion thread: viewtopic.php?f=110&t=11154

Download: https://1drv.ms/u/s!AsXFKQMOdPqghWP4bti ... R?e=2G9SbS

SCREENSHOTS

CHANGELIST

v 2.0.1

• Added support for CSV files.
• Added a CSV delimiter conversion function.
• Added a function timer which is displayed in the status bar when Debug Mode is enabled.
• Enabled the Database Optimisation function and fixed a bug.
• Fixed a bug with the Erase Database function which resulted in unexpected behaviour and Updater crashes.
• Player rights are now removed from players when using the Free Agent Utility (note that I have not yet added the ability to remove rights from player/coaches when the ‘Non-Player’ only option is selected).

CHANGELIST

v 2.0.2

• Added the ability to load and save saved games (including loading an extracted saved game).
• Added the ability to extract saved games into sub-files and recompile them.
• Added the ability to export host country data, IIHF rankings, player stats and schedule/score data from saved games.
• Added the ability to apply attribute_update and non_player update files to saved games.
• Added simple matching which allows staff names, team names, etc to be matched in an updater spreadsheet regardless of difference accents. Staff names are matched according to birth year only (day and month of birth are ignored).
• Added a duplicate staff checking function.
• Added left and right borders to spanned cells.
• Added the ability to export draft history.
• The Year Adjustment function now also adjusts the Year Founded for all teams and national teams.
• The progress dialog windows no longer automatically close when using the various database functions.
• Fixed a bug where the Staff History Validation function did support CSV export.
• Fixed a bug where the Year of Birth wasn’t always updated when modifying a player or non-player’s date of birth using attribute_update and nonplayer_update.

CHANGELIST

v 2.0.3

• Fixed a bug where imperial measurements weren’t working in updater spreadsheets.
• Fixed a bug where the Birth Nation in staff_new was being ignored when assigning a player/staff’s Birth City.
• Newly-created goalies now have a Def Role of 20.
• The Optimise Database and Player Update functions now set all goalie’s Def Role to 20.

CHANGELIST

v 2.0.4

• Added Team/Player Rights editing using contract_update and staff_new.
• Added ability to export Team/Player Rights.
• Added a Pass Tendency calculation function.
• Added an Auto Correction function for team and league names.
• Added Birth Year editing for attribute_update, nonplayer_update and staff_new.
• Added support for tab delimited csv files.
• XML files with incorrect <Title> tags can now be imported so long as their filename is the default filename.
• Added the EHM Updater version to the <Author> tag of XML spreadsheets.
• Corrected the heading cells for the duplicate_staff spreadsheet.
• Partially fixed the bug with misaligned header columns in exported csv files where the cells are spanned across multiple columns (more work needed to full fix this bug).
• Fixed a bug with staff_awards_update which prevented award names from being correctly matched.
• Fixed the Erase Player Awards History function so that it leaves a blank entry in order to be compatible with the Pre-Game Editor.
• Fixed the staff_new_errors file so that the error messages are shown in the correct column (and not at the end of each row).
• Upgraded from Qt v5.0.1 to v5.0.2.

CHANGELIST

v 2.0.5

• Fixed an issue with Auto Names Correct where it would fail to match consecutive instances of a particular name.
• Fixed an issue with the Database Optimisation function which corrupted clubs' disliked and favourite staff settings.
• Added auto repair of invalid club disliked and favourite staff settings (auto repair is applied each time you load and save the DB in the Updater).
• Added erase club disliked and favourite staff setting to the Erase Data drop-down menu.
• Fixed a bug whereby the year of birth wasn't always updating players and non-players.
• Fixed a bug with auto-correct names whereby _none was not being processed as a correction.
• Fixed a bug with header column spanning which wasn’t always working correctly in csv files.
• Significantly increased the number of teams and leagues corrected by the auto-correct function.
• Added affiliation export.
• Added arena export.
• Added colour export (as both xml/csv and an html colour chart).
• Added currency export.
• Added injury export.
• Added officials export.
• Added currency mini-editor (but it seems editing the exchange rates has no effect in-game).

PLEASE NOTE: This new version of the Updater requires a newer version of the Microsoft Visual C++ 2013 Redistributable: http://www.microsoft.com/en-gb/download ... x?id=40784


CHANGELIST

v 2.0.6

• Added support for EHM:EA Player Roles via attribute_update and staff_new.
• Added a Research Guide (via the Database menu) which generates a list of Current Abilities for a chosen league. The Research Guide is a work in progress.
• Upgraded to Qt v5.4.0 and Microsoft Visual C++ 2013.

PLAYER ROLES
EHM:EA Player Roles can be set via attribute_update and staff_new. A full list of player roles is included with the EHM Updater download (see 'Player Roles Guide.pdf'). Although the Roles are being set via the EHM 2007 database, they do not have any effect on the EHM 2007 game (except for the goalie Player Roles). You must import the database into EHM:EA afterwards for the Roles to take effect.




RESEARCH GUIDE
This is accessible via the Database menu. This is a half-finished function and so the UI looks a little messy (I had never intended to release it until EHM:EA was announced!). However, the main function works as intended. Select the league and then enter the number of players you want to rate. The Updater will then create a spreadsheet showing suggested Current Ability ratings to use for the players. The suggested CAs are just for a starting point.