Team Records/History - Bug?

[Mordrehl]

I know, it's probably been posted before but I couldn't find a relevant thread ...

Now, I've put up with this "bug" for quite sometime ... but it's finally starting to annoy me

Most Points, Most Wins, Most Losses, Most Goals Score, Most Goal Against ... not populating and just listed as a dash

Anybody know if and where you can fix this? I assume it has to be done prior to starting a season?


EDIT : Now that I look at it, it seems to predominantly be teams that don't exist in the original DB

[archibalduk]

Are you referring to the team records (as opposed to the player records)? I.e. most points accrued by the team during a season, most wins by the team, etc?

These can be added to the database, but not via the Pre-Game Editor. I have written a team records editor of sorts but it's not that user friendly at the moment. If you're interested, I can post the link.

Note that there is an issue with EHM whereby not all of the records can be added via the database (for example, average attendance, biggest win, most points by a defenceman, etc). So there will always be a range of stats that appear blank when you first start a new game.

[Mordrehl]

Yup, the team records themselves. Seems any team that was added to the DB that wasn't in the orignal EHM2007 db is lacking the mentioned records. They're all listed as a dash and never update

And sure, I'll take a look at that editor

[archibalduk]

Here is the link to the Team History Extractor: https://skydrive.live.com/redir.aspx?ci ... cm80J4-ezw

It isn't the most straightforward way of editing the data, but it's not too bad once you get your head around it. Nino33 has used it without any problems for his 1974 roster update. Here are the instructions I gave to Nino33 on this:

*** REMEMBER TO MAKE LOTS OF BACKUPS OF YOUR ENTIRE DATABASE BEFORE AND DURING EDITING ***

How to use it
Place the tool in the same folder as your database and use the 'Run as Admin' option to load it.

When you export the data, it will create several csv files. Club_records.csv is the file you'll need to edit. The other csv files are for your reference in order to figure out which ID numbers to enter into the club_records.csv file.

Within the club_records.csv you will see there is various information. Here's a rough run-down:

• Club name - This isn't a compulsory field. You can just enter a zero in this field if you like (in fact you can enter whatever you want). This field is simply to help you see what entries are in the table. It is not reimported into the database.
• Club ID - You will need to enter the Club ID of the team you want to add a set of records for. List_clubs.csv has a list of Club ID numbers for you. Note that you should not have more than one entry for a team in the database. However, you don't have to have an entry for every team in the game - if you remove a team from the list then it will remove all of the team records.
• Team records - After the Club ID there are several fields for the team's records - e.g. most pts accrued in a season, most wins, etc. You will see there is one field for the stat and one field for the season (I'm fairly certain you enter 2006 for the 2006/07 season, 2007 for the 2007/08 season, etc - but you'll need to double-check that).
• Season records - Oddly, all of the season records are clustered together but the rookie goals category is on its own at the far right of the spreadsheet.
• Career records

With regards to the season and career player records, you have to enter the Staff ID, First Name ID and Surname ID. You can use the list_staff.csv, list_first_names.csv and list_second_names.csv to find the appropriate ID numbers. However, you don't necessarily have to enter all three IDs. It all depends on whether the player you want to add to a record exists in the database. You can add any player to a record regardless of whether or not he exists in the database. Here's what you need to enter:

Player exists in the database
All you need to enter is the Staff ID number. Just enter zero into the First Name and Surname ID fields.

Player does NOT exist in the database
Enter the Staff ID as -1 (minus one)
Use the two list csv files to find the ID numbers for the first and surnames you want to use. You will see that there are multiple ID numbers for many names. Don't worry about this; you can use any of the ID numbers relating to the correct first/surname.

Once you have finished, use the 'import' option of the tool (the tool and club_records.csv file must be in the same folder as your database). The tool will import your data and will update your index.dat.

You may also want to look at record_config.cfg in your database folder (you can view the file using Notepad). This allows you to add records too (you might want to try this before using my editor) but IIRC the records don't always appear in game.

[Mordrehl]

So, using the editor you provided I've found the cause ... it seems the teams in question are lacking any entries at all for the 5 categories I listed (in fact, lacing any entries at all for Team History). Setting these to even a value of 1 and the problem resolves itself (for the MOST XXX records)

As an example, check either the Winnipeg Jets of the NHL or Victoria Royals of the WHL in Manimal's current DB