EHM The Blue Line

archibalduk wrote: Mon May 03, 2021 10:47 am Riz has taken a look at the above issue. It isn't a DB issue but a game-related UI issue which seems to be caused by the sheer volume of leagues in the database. Apparently this might not be an easy fix in the game, so we'll have to just wait and see. Perhaps the solution is to re-order the Club Competitions table in the database by prioritising the lower IDs for playable leagues ([***NOTE TO SELF***])

Good to know! The re-ordering seems like a good option. Thanks for getting that looked into!

archibalduk wrote: Sun May 02, 2021 5:09 pm Historical club names are now reverse sorted by ID; and

Just a note on this want to make sure its expected behavior, I just added two entries for a club and it added them as ID 2 and 3 (and I guess moved all the others down as I don't see duplicate IDs) when I would have expected it to add these as new IDs (which would have been 238 and 239 in this DB).

xECK29x wrote: Mon May 03, 2021 6:34 pm

archibalduk wrote: Sun May 02, 2021 5:09 pm Historical club names are now reverse sorted by ID; and

Just a note on this want to make sure its expected behavior, I just added two entries for a club and it added them as ID 2 and 3 (and I guess moved all the others down as I don't see duplicate IDs) when I would have expected it to add these as new IDs (which would have been 238 and 239 in this DB).

Is your work-in-progress DB on Dropbox? If so, I'll take a look at that version. I tested the ordering using an initially blank historical club names list and so perhaps the behaviour is different if existing names are present in the DB at loading.

In any event, it won't cause any issues as that table doesn't actually use IDs. The IDs are only present for the purposes of allowing the table to be sorted in reverse chronological order - they're not actually saved to the DB.

Can't really find a solution on this but my savefile always crash and get corrupt after I use the editor and I have tried other versions on the editor aswell but still have the same problem. Any idea what the problem could be?
First time I'll ever have this problem.

sebastianraberg98 wrote: Wed May 05, 2021 4:21 pm Can't really find a solution on this but my savefile always crash and get corrupt after I use the editor and I have tried other versions on the editor aswell but still have the same problem. Any idea what the problem could be?
First time I'll ever have this problem.

The editor isn't made to modify save games, it gives fair warnings that it can corrupt saves. (it's mostly used for looking at the data in saves rather than changing it).

What are you trying to change? I'd recommend changing the starting database rather than the save.

archibalduk wrote: Tue May 04, 2021 8:56 pm Is your work-in-progress DB on Dropbox? If so, I'll take a look at that version. I tested the ordering using an initially blank historical club names list and so perhaps the behaviour is different if existing names are present in the DB at loading.

In any event, it won't cause any issues as that table doesn't actually use IDs. The IDs are only present for the purposes of allowing the table to be sorted in reverse chronological order - they're not actually saved to the DB.

Yea it looks like it works fine until I save, then it scrambles the IDs, no big deal

ideawithoutamind wrote: Wed May 05, 2021 5:57 pm

sebastianraberg98 wrote: Wed May 05, 2021 4:21 pm Can't really find a solution on this but my savefile always crash and get corrupt after I use the editor and I have tried other versions on the editor aswell but still have the same problem. Any idea what the problem could be?
First time I'll ever have this problem.

The editor isn't made to modify save games, it gives fair warnings that it can corrupt saves. (it's mostly used for looking at the data in saves rather than changing it).

What are you trying to change? I'd recommend changing the starting database rather than the save.

Yeah I know, that's why I always use the editor before I start playing if the file will get corrupt. But as I wrote, it's the first time I have this problem. Have worked everytime in those 4 years I've used it, that's why I thought it was wierd now. But I will try use the editor and change the starting database instead.

I would like to request to have a shortcut for deleting one entry in a table(for example one game/date in a schedule template) instead of having to right-click it and then clicking delete. I have no idea if this is possible but it would help a lot. Thanks for this awesome editor and all work you do.

This is probably a big ask, and I know adding more to the staff filter slows it down, but being able to filter on contract end date would be a big help

Could a synonym file be added also for cities? Ex: constantly changing Astana to Nur-Sultan or Wien to Vienna

xECK29x wrote: Fri May 14, 2021 3:01 pm Could a synonym file be added also for cities? Ex: constantly changing Astana to Nur-Sultan or Wien to Vienna

I second this!

Found an issue with exporting from a database and importing/exporting using the Jersey Generator 1.0.0 beta 6.

Files are Exported as: FirstName_LastName_1.1.2000.png
They should have underscores for the dates: FirstName_Lastname_1_1_2000.png

Workaround, using the Player Export then in Excel, Find ".", replace with "_" in the birthdate column, and Jersey exporter exports in proper format.

Thanks - I'm taking a look at these for the next release.

Some logic with the way the synonyms work needs to looked at.

For example let's say I have the following in the clubs list: HC Vita Hästen,IK Vita Hästen,Hästen Hockey,NSH 96. In the database HC Vita Hästen is active however this is also a legacy older inactive club for Hästen Hockey. When importing players contracted to HC Vita Hästen it's putting them on the inactive Hästen Hockey, the only way around this is to rename that old entry (which is fine as I am cleaning them all up and updating any records) but I don't believe the editor should be doing that anyways.

That was the intention behind the synonyms; they're intended to be a fall-back if the team name doesn't exist in the database. I'd originally designed the synonym function to deal with importing player career history so that older team/competition names could be linked to an appropriate entry if there is no team/comp with that specific name.

I've no objection to reversing the logic but it'll just take me a few weeks to switch it around.

Ok so all the teams in those stanzas are linked together? IMO it should be 'Name to Use','AKA','AKA','AKA' if that makes sense?

Yes I see what you mean. If it's an easy fix then I'll change that too, but my first thought it that this could involve a complete re-write.

Just to add: This is definitely something we should re-think for EHM Editor v2, particularly now that we have the historical club names table. I just wonder if it's better to use the historical club names table rather than having a separate synonym list for clubs.

I've made a great deal of progress with Editor v2 over the past three or four weeks and hope to share some screenshots in the coming weeks.

archibalduk wrote: Sun May 16, 2021 4:35 pm Just to add: This is definitely something we should re-think for EHM Editor v2, particularly now that we have the historical club names table. I just wonder if it's better to use the historical club names table rather than having a separate synonym list for clubs.

I've made a great deal of progress with Editor v2 over the past three or four weeks and hope to share some screenshots in the coming weeks.

If you could link those it would help, but I do use the synonyms sometimes to match real life name with EP name (which is sometimes outdated).

Very good point!

Not exactly an editor bug/feature request, but...

Is it possible to include some kind of basic tutorial on how to format/use the spreadsheets for import/export? My intuitive impression is an export from one database can be imported into another without touching it, in order to transfer information between them, but that seems like it's not the case. Plus, the error details for some data is non-existent (specifically, the cities and arena error files don't really give any indication on what's wrong).

Could you give an example of one thing you'd like to change? I will then explain it for you, probably this weekend.

IIRC there's a manual included with the EHM 2007 Updater which explains how the import spreadsheets work. They work the same way in the Updater as in the Editor, so it should give some background.

Not really so much a change, as just an explanation. I'll give an example of what I mean.

When importing creates an error, it spits out "x_errors.xlsx" where "x" is the data source (cities, clubs, etc). Some of them give good details on what the error is (capital city/colours/arenas in nation_errors.xlsx, for example). The two in question do not.

Here's the first 3 lines of a cities_errors.xlsx file that I got:
There's nothing in there that tells me exactly why it's not importing properly.

Note, again, that I literally just exported the cities from one pregame file (TBL Rosters 2020-21 v 13.2.5) and tried to import it into another (Flinch's 2000-01 Rosters (WIP)).

The link to the 2007 Updater is down/dead (?):
ETA: I do have "EHM_Edit_2007_Import.txt" from the 2007 pregame editor v2007.1.7. I'm not sure if this is still valid?

That's just saying the city itself doesn't exist in the other DB, trying adding an "a" infront of the line.

TBIF wrote: Mon May 24, 2021 8:54 pm That's just saying the city itself doesn't exist in the other DB, trying adding an "a" infront of the line.

Ah. I assume "a" = add?

Note: I put "a" into the "mode" column to get it to work, just in case anyone else sees this.