EHM The Blue Line

Doing some of my first work with the CSV files. Archi you're a genius and a half.

Side note: When using the PGE save, and save often

I did about 6 hours man work to my "based on a true story" DB, using an older UUDB save and adding new players for smaller nations to give the game some more diversity.

Left it open and the computer on while I was away at work, and Nortons wonder "we'll restart your computer in 4 hours whether you like it or not" message popped up. Guess who wasn't home

I can't seem to get the Player Roles to stick. No matter what they change to 1 and 1

Tyees wrote:I can't seem to get the Player Roles to stick. No matter what they change to 1 and 1

I got that but only for goalies. Do you get it for skaters, too?
The goalies gets reverted to 1-20 when using the 'database optimization'

Thats 100% why, thanks!

In addition to the DB Optimisation, I think the Updater will prevent any attempts to make a goalie's Off Role anything other than 1 when using attribute_update. So if you use the attribute_update to try and set a goalie's Off Role to anything other than 1, the Updater will automatically change it to 1. It's just a way of preventing mistakes (e.g. accidentally setting a goalie to having a secondary position as a skater).

I exported the player attributes then opened the file with XML Viewer (excel). When I save it and then try to Import it back into the Updater I get an error saying too many columns, that there are 81 and it expects 80.

Had the same problem. In the file you import you have to delete the colums with the contract info and then add the birth date after the last column. Then in works.
Let the Updater create a spreadsheet and compare it to the file with the exported data. You will see the differences.

You don't use the same files to export/import.
You copy/paste data from the exported files to "Templates" that are used for importing
Click on "Spreadsheet" at the top of Updater screen, and then select "Create Spreadsheet Templates" - this will create the Templates you use to import edited data

I've started work on version 2.0.4 of the Updater. I won't promise how quickly I'll get it released because unfortunately I don't have as much time as I used to and I'm working on various EHM/FHM roster things in between.

Version 2.0.3 was never released publicly because it just involved some minor changes and I didn't update the readme. It was just a quick release to help with the TBL Rosters. Here's the changelist for v2.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 goalies' Def Role to 20.

Here's what I have planned for v2.0.4:

• Investigate and fix the issue with the player awards update for the TBL Rosters v6.0 which seemed to a cause a memory/pointer error with the Pre-Game Editor; [I'll defer this until v2.0.5 as this is proving really difficult to figure out]
• Fix staff_new_errors where error messages appear at the end of the row (rather than the beginning) when multiple errors arise for a new entry; [DONE]
• Fix the erase player awards function so that it doesn't cause an issue with the Pre-Game Editor (it doesn't like having zero records); [DONE - But this is still subject to the player awards update editing which causes the Pre-Game Editor to crash]
• Fix the bug with player award names not matching correctly for the player awards update; [DONE]
• Automatically calculate Pass Tendency based on player career history; [DONE - But the formulae will need tweaking]
• Player rights updating (add/edit/delete rights); [DONE]
• Auto-correction of team and league names (e.g. if you enter "NHL" in an updater sheet then it'll auto-correct to "National Hockey League" so it avoids errors - this will be useful where you copy and paste data from a website into a staff_history_update file because you won't have to spend hours making sure all of the league and team names are correctly spelled - currently the auto-correction lists are hard-coded but I will add the option to customise the lists via a settings file); [DONE]
• Add/edit Birth Year for players and non-players (including newly created players); [DONE]
• Support for tab delimited csv files (this will fix the problem where Libre/OpenOffice removes the commas/semi-colons and the Updater won't currently import them); [DONE]
• Xml title tags are no longer necessary so long as the filename is the default name (this should allow xml files edited with Open/LibreOffice to work with the Updater); [DONE]
• Fix the headings for the duplicate_staff spreadsheet; [DONE]
• Fix the misalignment of headers for csv files where the first cell is located at an index other than 0; [50% DONE - But needs more testing (exported_attributes.csv still not aligned correctly?)]
• Add EHM Updater version number to Author tag of XML spreadsheets; [DONE]
• Upgrade to QT v5.0.2 [DONE]

Plans for after v2.0.4:

• Automatic redistribution of non-technical attributes on a per league basis (ambitious, long term aim - I'm not 100% sure of whether this is necessarily a good idea - I need to think more about this);
• Full-blown schedule editing for saved games;
• Regen repairing for saved games (switch around PAs for regens for each nationality) - and possibly fixing non-technical attributes so that they're more appropriate for the player's position and Def/Off Roles;
• Fix the bug where you try to load a second DB / saved game. The previous data isn't currently wiped first;
• Add the option to customise the auto-correct lists using a settings file (if no settings files exists, the Updater will default to the hard-coded list);
• Detect corrupt saved games (those filled with zero bytes) and give an appropriate error message;
• Salary cap editing for saved games;
• Updating for arenas, teams, officials, draft history, etc;
• Changing players to non-players and vice-versa;
• Edit nationalities and birth cities for players/non-players;
• Make the Updater more forgiving where decimal numbers are inadvertently used in a spreadsheet rather than whole numbers;
• Retired numbers updating;
• Nations updating;
• The option to automatically remove unused first and second names;
• Mass editing including player reputation editing (similar to the Realism Patch MET Attribute Editor);
• Remove player rights for player/coaches when using the 'Non-Players' option of the Free Agent Utility;
• Look at whether it is possible to import team stats histories (club_histories.dat) into a saved game;

If there is anything I've missed or any requests, please let me know and I'll update the lists above.

You work is pretty amazing. You started that by yourself? (just found the thread)

philou21 wrote:You work is pretty amazing.

Yes it is!

Stupid question Nino but can I only use this and not the old pre-game editor I'm used to?

philou21 wrote:Stupid question Nino but can I only use this and not the old pre-game editor I'm used to?

You can use both! I do some things with the PreGame Editor, and other/most things with the Updater

EDIT - IMO for simple/small changes, the Pregame Editor makes more sense to use...but for any significant amount of editing the Updater's the only way to go!

Okay thanks! I'll check this out then.

Pre-game editor dos not work with TBL rosters 6.0. It will with 6.0.2 or whatever the name will be when Archi releases it soon

Yeah I know! I'm looking foward to it!

Is there any chance of editing player/staff names in saved game files?

zbguy wrote:Is there any chance of editing player/staff names in saved game files?

I can probably put that on my task list. However, I would expect that you could only use existing first names and second names.

I've updated my earlier task list for v2.0.4 (click here) with additional tasks and I've marked [DONE] for those I've completed. Hopefully I'll get Pass Tendency calculation and player rights updating done this weekend, depending on how much free time I have.

The player rights updating will likely be done via contract_update. However, existing contract_update spreadsheets will still be compatible with the Updater

archibalduk wrote: The player rights updating will likely be done via contract_update. However, existing contract_update spreadsheets will still be compatible with the Updater

Is it also possible to have rights in the staff_new file? It would be great to have once we're gonna add CHL draftees.

Manimal wrote:

archibalduk wrote: The player rights updating will likely be done via contract_update. However, existing contract_update spreadsheets will still be compatible with the Updater

Is it also possible to have rights in the staff_new file? It would be great to have once we're gonna add CHL draftees.

I agree that adding Rights via the staff_new file would be great!

How will draft history be added? Will it be possible to add more than one entry? (i.e. adding Major Junior and NHL draft history at the same time)

Manimal wrote:Is it also possible to have rights in the staff_new file? It would be great to have once we're gonna add CHL draftees.

I hadn't thought of that. That's an extremely good idea. I'll make it possible for staff_new too.

I need to add player rights exporting to the Updater first (I'll be doing that today) because I need to see how player rights has been used in the DB in practice. However, it might be quicker to ask you: Is there ever a situation where you have had more than one team in the same league owning rights to the same player in the DB?

nino33 wrote:How will draft history be added? Will it be possible to add more than one entry? (i.e. adding Major Junior and NHL draft history at the same time)

Yes all drafts can be added at the same time. It'll be very similar to existing Updater functions. You just list the player (name + DOB), the draft name (E.g. NHL Draft, CHL Import Draft, etc), Year, Round, Overall Pick and Team name.

It will also be possible to delete entries too. This will also be possible with the player rights editing - you will be able to delete a specific right for a player or indeed all rights for a particular player (probably by putting something like _delete_all in the spreadsheet in the Rights column).

I'm tempted to hold back the next release of the Updater for an additional week so that I can get draft history updating done (I'd previously intended to leave this until the next version). There's no ETA for the next release. I'm pretty much limited to weekends at the moment and I'm away next weekend. So I'm thinking it'll be a February release.

archibalduk wrote: I need to add player rights exporting to the Updater first (I'll be doing that today) because I need to see how player rights has been used in the DB in practice. However, it might be quicker to ask you: Is there ever a situation where you have had more than one team in the same league owning rights to the same player in the DB?

No, never.
Unless there have been a mistake but I have never seen it

Manimal wrote:

archibalduk wrote: I need to add player rights exporting to the Updater first (I'll be doing that today) because I need to see how player rights has been used in the DB in practice. However, it might be quicker to ask you: Is there ever a situation where you have had more than one team in the same league owning rights to the same player in the DB?

No, never.
Unless there have been a mistake but I have never seen it

Excellent - thanks. That's as I'd hoped. In which case I can make editing rights very straightforward.

THat will make life so much easier...the draft stuff and the rights as well. Excellent work ladies.