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

[archibalduk]

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.

Update 26 March 2015: Version 2.0.6 of the EHM 2007 Updater is now available to download. Here is the link: http://www.ehmtheblueline.com/forums/vi ... 88&t=13532


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.

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).

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.

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.

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.

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).

SCREENSHOTS

[archibalduk]

I have uploaded version 2.0.0 of the EHM 2007 Updater. Please see the link in the first thread for the download link.

PLEASE NOTE: The Updater has been completely re-written from scratch. For this reason, there is every chance that there may be bugs in the program. I therefore highly recommend that you make regular backups of your database and that you keep backups of all of your updater spreadsheets. Backup your database before using the Updater for the first time too. I have done my best to test things, but I can't foresee every possible situation/permutation.

Treat this as a BETA version and carefully check in game all of the data that you update using the Updater. If you're not comfortable using this version, then you may prefer to use the tried and tested previous version (v0.4.1 xp4): http://sdrv.ms/12kjU7Q

Hopefully the readme will explain how to use the Updater. If you've used a previous version of the Updater, you should be able to use the new version okay. The readme is a bit of a work in progress and I need to proof-read it a little more closely. But hopefully it has all of the main points covered. If anybody has any questions (no matter how small), please let me know in this thread and I'll do my best to explain things (this will help me improve the readme too).

I've had to temporarily disable the Database Optimisation function whilst I work out a bug with it. I hope to release a new version in the next week or two. This will also have CSV support. Although XML spreadsheets are really useful, they have large file sizes and this causes the Updater to struggle with very large volumes of data (e.g. importing 250,000 rows of career history data) - CSVs don't have this problem.

[nino33]

Version 2.0.0 of the EHM 2007 Updater is now available to download.

Awesome! downloading right now! Thanks so much Arch!

[Manimal]

It is looking good!
I have not tried any of the import features yet (as I'm working directly with the master-db) but I'll try them out soon.

[archibalduk]

I just remembered - I totally forgot to test out the use of Imperial measurements using attribute_update. I'll give it a test this week or next.

I also should have mentioned that I added three new columns right at the end of the attribute_update spreadsheet. This allows you to change the DOB of a player (there are similar columns in the nonplayer_update which allow you to change non-players' DOBs). You don't have to enter the full DOB. E.g. if you just want to change the day then just enter the number for the new day. Or if you just want to change the month, just enter the number for the new month. Note that attribute_update spreadsheets without these additional 3 columns should still be imported fine into the Updater.

The main reason for adding these DOB columns is so we can correct the DOBs of young players in the 1974 DB once saved game editing is enabled. It'll also be useful for correcting DOBs generally within the DB.

I have not tried any of the import features yet (as I'm working directly with the master-db) but I'll try them out soon.

If XML is going to be a problem for OpenOffice, you may prefer to wait until I've released the next version as this will restore CSV support.

[archibalduk]

I've found a bug with the Erase Data button which means that it is linked to the wrong drop-down menu. The behaviour of the button is unpredictable and may cause a crash (it depends on what you have selected on the Export XML drop-down menu). I've fixed the bug for v2.0.1. I've also added full csv support.

[archibalduk]

I have uploaded version 2.0.1. The download link and the changelist are in the first post of this thread. If you have v2.0.0 installed, just replace your v2.0.0 EHM 2007 Updater.exe with the v2.0.1 version included in the ZIP file. The readme.pdf has also been updated.

I haven't added everything in my planned to-do list because I wanted to get the CSV support added and uploaded asap. The Updater I've uploaded today has CSV support for both importing and exporting spreadsheets. All of the importing and most of the exporting can be done as either CSV or XML by selecting the appropriate file type on the Save dialogue window as per the screenshot below. However, if you want to use the 'Export All' function or export the CA Ranges, Index and Roster Errors as CSV, you must enable the 'Use CSV Spreadsheets' option from the Spreadsheet menu. Enabling this setting also makes CSV the default format for exporting spreadsheets. So if you want to export data as CSV, I recommend enabling this setting as it'll make things a little more convenient.

There is also a Convert CSV Delimiter function in the Spreadsheet menu which converts a CSV file from one delimiter to another.

Note that for the CSV spreadsheets, you must use the set filename (e.g. contract_update.csv, etc). Unlike XML, you cannot use custom filenames.

[archibalduk]

I forgot to mention in the readme that if you're using CSV updater spreadsheets, you must use an underscore '_' to represent any commas in any names, etc. For example, "Saint-Georges COOL FM 103,5" must be entered as "Saint-Georges COOL FM 103_5" in a CSV spreadsheet. This is not a problem with the XML spreadsheets - you can use commas and semicolons.

[archibalduk]

I have uploaded a new version. The download link can be found in the first post of this thread. There are a couple of minor bugs which I haven't had time to fix (I'm losing my internet connection on Sunday whilst I move house and so I need to get the Updater online today):

* The imperial setting doesn't correctly work for heights/weights in attribute_update.
* Header column spanning for CSV files seems that it isn't working correctly anymore (they're not aligned to the correct columns).
* On the Saved Game tab, only the first human GM is listed even where there are multiple human GMs.
* This is not necessarily a bug, but it might be: When editing DOBs in a saved game, the separate Year of Birth field is updated. However, it seems in a saved game that the Year of Birth field might instead be used to track a player/non-player's age. I don't know for sure and haven't had enough time to fully test. DOB updating seemed to work okay for saved games, but I want to mention this point just in case anybody encounters any issues.

You'll see that if you load a saved game in the Updater that there are a couple of additional options in the Export drop-down menu. This includes things such as schedules and scores (including basic game stats) and player stats. Unfortunately I haven't yet figured out how staff IDs are linked to player stats and so you'll see if you export this data that there are no player names listed (I think the staff IDs are linked via a separate file).

The full changelist is as follows:

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.

P.s. My plans for the next update are likely to be as follows:

• Fix the imperial measurement bug with attribute_update.
• Fix a bug with the birth city not being cross-checked with the birth nation
• Fix the CSV spanned header alignment bug
• Try to figure out how the attributes work in the saved game so that we can edit them using attribute_update
• Draft history and draft rights updating
• Arena updating
• Club updating
• Official (i.e. referees) adding, editing and deleting.

[Manimal]

P.s. My plans for the next update are likely to be as follows:

• Fix the imperial measurement bug with attribute_update.
• Fix the CSV spanned header alignment bug
• Try to figure out how the attributes work in the saved game so that we can edit them using attribute_update
• Draft history updating And rights, I hope?
• Arena updating
• Club updating
• Official (i.e. referees) adding, editing and deleting.

[archibalduk]

Yes I meant that too. I've updated my earlier post so it's clearer.

[archibalduk]

Note to self:

Regarding the updating of DOBs:- The attribute_update file is used only for players. To update DOBs for non-players, use the nonplayer_update file.

I did try that, but it didn't seem to work...

I also tried to "fix" all the Staff young ages in a saved game using the Updater. I used an "exported_staff" file to get the initial data, and then used a "nonplayer_update" to try to change the Birth Year so the youngest Staff would be age 25.....but when I checked in game the Staff showed as age -99

That's why I was wondering...

Can the Updater be used to change Birth Year?Maybe I did something wrong...or maybe the Updater doesn't allow Birth Year editing (for the correcting of extra young players DOB Birth Year stays the same, only Month/Day needs correcting.....so maybe the Updater doesn't allow for editing of Birth Year?)

[CJ]

Right now I'm updating the UUD database, so I downloaded this editor but I can't get it to work properly.

I export "exported_attributes" as a CSV. I open it in Excel and edit some player attributes etc. Then I save it again as a CSV file, but it shows me this:


Ok, so after that I go to the EHM 07 updater and try to import that file and it shows this:


So the question here is, what am I doing wrong?

[nino33]

I export "exported_attributes" as a CSV. I open it in Excel and edit some player attributes etc. Then I save it again as a CSV file, but it shows me this:

This is because you're saving to/from different formats (i.e. excel to csv)...it's just telling you that not everything in excel saves in csv (i.e. colour is only in excel), nothing to worry about as long as you're knowingly doing so

Ok, so after that I go to the EHM 07 updater and try to import that file and it shows this:

So the question here is, what am I doing wrong?

You can't just import the same file as you exported. You need to use the correct import template to import data.

Within the Updater click on "Spreadsheets" at the very top, then click on "create spreadsheet templates" and this will produce seven different files you use to import data (attribute_update, comp_history_update, contract _update, nonplayer_update, staff_awards_update, staff_history_update and staff_new).

You can copy/paste your exported data into these templates, or format the exported data to match the template, and then your imports will work!


I encourage you to use the ReadMe, the answers are within!
For those that just want to make a few small edits I'd suggest continuing to use the Pregame Editor, but to edit EVERYTHING you want the Updater! IMO it's so worth the time it takes to get comfortable using it!

[CJ]

Thanks for the quick response. Gonna try again soon.

[ExxonPirate]

Really cool!

So I've got a question:

I screwed up and forgot to add a league when I started this saved game. I want to add the league, but obviously I can't mid-game. My solution is to use (perhaps your editor) to extract the rosters, and then just create a new database and use that in place of starting all over. Is that possible using your editor?

[nino33]

Really cool!

So I've got a question:

I screwed up and forgot to add a league when I started this saved game. I want to add the league, but obviously I can't mid-game. My solution is to use (perhaps your editor) to extract the rosters, and then just create a new database and use that in place of starting all over. Is that possible using your editor?

I don't think Archi currently has much internet access (moving) and so may not be able to answer you right away. As noted in this thread (http://www.ehmtheblueline.com/forums/vi ... 18#p158318) the Updater can be used with a saved game to extract things like rosters, team names, competition names, arenas, etc - basically everything except player attributes and player career history.....so it doesn't seem you can just copy/paste be using your saved game in a new game

[Manimal]

Well, you could use the Updater to clear a db of players making it blank. Then you could extract all players and staff from your db. Copy what is needed into a staff_new file and then copy the rest into attribute_update and non-playing_update

[nino33]

Well, you could use the Updater to clear a db of players making it blank. Then you could extract all players and staff from your db. Copy what is needed into a staff_new file and then copy the rest into attribute_update and non-playing_update

I thought of that too initially, but because we can't copy/paste (or edit) Attributes from a saved game I didn't see it as a solution; while I think you can copy/paste CA/PA the 49 other Attributes would all have to be "0" ratings, and the game doesn't have a good record of creating players in such cases

[ExxonPirate]

Well, you could use the Updater to clear a db of players making it blank. Then you could extract all players and staff from your db. Copy what is needed into a staff_new file and then copy the rest into attribute_update and non-playing_update

That was my plan, but the only problem is, when I'm copying the exported staff, it includes staff AND players. So when I get to the CA/PA part and beyond, the only information I can go off of is from the exported attributes xml, which contains only players, so I have to sift through all the names and grab only the info that I need.

[nino33]

Manimal wrote:Well, you could use the Updater to clear a db of players making it blank. Then you could extract all players and staff from your db. Copy what is needed into a staff_new file and then copy the rest into attribute_update and non-playing_updateThat was my plan, but the only problem is, when I'm copying the exported staff, it includes staff AND players. So when I get to the CA/PA part and beyond, the only information I can go off of is from the exported attributes xml, which contains only players, so I have to sift through all the names and grab only the info that I need.

If you export just the Player Attributes file you won't have any Staff, but you'll have player name, DOB, team and CA/PA, all you need to copy/paste into a staff_new file

Then export the Non-Player Attributes, you'll have only Staff (no Players) , and again you'll have what you need to copy/paste them into a staff_new file

Regarding getting "CA/PA and beyond" keep in mind you won't be able to copy/paste any Attributes from your saved game...so things like Acceleration, Agility, Determination, Work Rate, Passing, Positioning, Shooting, Consistency, Pass Tendency, Agitation, Loyalty, Professionalism....ALL of the Attributes beyond CA/PA will have to be random/0 ratings as you can't copy/paste/edit individual Attributes from a saved game

So you won't need to use an attribute_update file (because the Updater isn't yet able to copy/paste the individual Attributes from a saved game)

So while the players from your saved game will have the CA/PA of the saved game, they will be the only ratings that are not newly/randomly generated when you start up again

[Manimal]

Ah yes, I've never bothered with saved game things so I forgot that.
He could take the atts from the db he started with as that would be better than zeros all over

[nino33]

He could take the atts from the db he started with as that would be better than zeros all over

Yes he could!

And if he really wanted to he could use the "Estimated attribute values by CA" chart (http://www.ehmtheblueline.com/forums/vi ... =13&t=4920) to look at some key Attributes or Attribute "groupings" in relation to the "new" CA, and make some Attribute adjustments to address the two years of development that would be missing


FYI - when I say Attribute groupings I mean looking at the average of some combined Attributes (like Acceleration/Agility/Balance/Speed for skating). I always look at skating separately for everyone, and I also have a specific Attribute combination I use for Defensemen and another for Forwards.

[ExxonPirate]

Ahhh, I'm slowly getting the hang of this now. I have work in five minutes (n) so I won't be able to try any of this out, but I will tonight.

Thanks for the help guys.

Oh, and I did use the attribute_update file (among others), and when I tried to boot up the game, it crashed. The game will crash if I try to force it to use the aforementioned files, ya?

[rob_lee]

Hello!

Is there any way to make a staff into a player again?

The thing is that I am at year 2043 now and I have coached a guy from the age of 15 in a small town in sweden and followed him all over during his career in all kinds of tournaments and he is more or less a legend now. He is at my side as a ass. GM and I would love to see him play at least one game more, just as a showoff.

If anyone has any solution... any at all. PLEASE let me know!