The Blue Line

EHM 1 Database & Saved Game Editor

Discuss all aspects of editing the data in EHM here. Have a question about the Pre Game Editor, editing the .cfg files, hex editing the .dat files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
Forum rules
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.

Please note that discussion about roster updates belongs in the Game Add-ons Forum.

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sun Feb 04, 2018 9:36 pm

Change the format of the date columns to "Text". That should stop them appearing as dates. You can then use Find & Replace to replace all "/" with ".".

Image

Manimal wrote:For example, I had some issues in a schedule file I sent Archi the other day and he could not see the error but I could.


Can you post an example screenshot of this? It might help me reproduce the issue and then get a fix in the Editor.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby ppaalloo » Sun Feb 04, 2018 9:40 pm

I have problem with that I can from my leagues transfer players to other teams in other leagues without date problems but when I bring players with other leagues or free agents then editor give me error list with 1/2/1900 dates but in original spreadsheet I have 1.2.1900 dates fot these players
User avatar
ppaalloo
TBL Rosters Researcher
 
Posts: 92
Joined: Tue Jul 02, 2013 3:31 pm
Points: 0.92

Re: EHM 1 Database & Saved Game Editor

Postby Manimal » Sun Feb 04, 2018 9:42 pm

ppaalloo wrote:I have problem with that I can from my leagues transfer players to other teams in other leagues without date problems but when I bring players with other leagues or free agents then editor give me error list with 1/2/1900 dates but in original spreadsheet I have 1.2.1900 dates fot these players


No, the problem is the dates you write yourself.
The players from Tipsport Liga was already in the file
User avatar
Manimal
EHM Rosters Man
TBL Admin Team
 
Posts: 6,147
Joined: Thu Apr 24, 2008 5:01 am
Points: 205.52
Trophies:  4 

Re: EHM 1 Database & Saved Game Editor

Postby ppaalloo » Sun Feb 04, 2018 9:51 pm

No, the problem is the dates you write yourself.

yes I thought so
Change the format of the date columns to "Text". That should stop them appearing as dates. You can then use Find & Replace to replace all "/" with ".".

where can I find it? that picture with these options
User avatar
ppaalloo
TBL Rosters Researcher
 
Posts: 92
Joined: Tue Jul 02, 2013 3:31 pm
Points: 0.92

Re: EHM 1 Database & Saved Game Editor

Postby Manimal » Sun Feb 04, 2018 9:57 pm

archibalduk wrote:
Manimal wrote:For example, I had some issues in a schedule file I sent Archi the other day and he could not see the error but I could.


Can you post an example screenshot of this? It might help me reproduce the issue and then get a fix in the Editor.


I'm not sure how it helps you.
When I wrote 15 Sep it turned into 2015-09-01
If I write 15 Oct then it is fine as we use the abbreviation of Okt in swedish.
All other months turned into dates, so I reckon it has to do with the cell formats
User avatar
Manimal
EHM Rosters Man
TBL Admin Team
 
Posts: 6,147
Joined: Thu Apr 24, 2008 5:01 am
Points: 205.52
Trophies:  4 

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sun Feb 04, 2018 10:12 pm

Manimal wrote:
archibalduk wrote:
Manimal wrote:For example, I had some issues in a schedule file I sent Archi the other day and he could not see the error but I could.


Can you post an example screenshot of this? It might help me reproduce the issue and then get a fix in the Editor.


I'm not sure how it helps you.
When I wrote 15 Sep it turned into 2015-09-01
If I write 15 Oct then it is fine as we use the abbreviation of Okt in swedish.
All other months turned into dates, so I reckon it has to do with the cell formats


By seeing the precise format of the text, I can programme the Editor to correctly interpret and process it. It also helps me to see which spreadsheet and column you're referring to.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby ppaalloo » Sun Feb 04, 2018 11:17 pm

Guys FINALLY I fix this so I can continue with my research... Only problem is with new players I thinks I entry them bad to excel or what... and new team Nové Zámky B in St. Nicolaus 1. liga
User avatar
ppaalloo
TBL Rosters Researcher
 
Posts: 92
Joined: Tue Jul 02, 2013 3:31 pm
Points: 0.92

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Sun Feb 11, 2018 3:57 pm

Got one feature request and a possible bug for you Archi.

Can you please sort any blank entries (such as a player, city, club etc) as ([None]) always at the top? I find this is not uniform across these screens and can lead to unneeded blank entries, small thing I know :).

This DB (https://www.dropbox.com/s/zuw6q54mmv7h9 ... se.db?dl=0) is crashing when exporting the model or exporting all players/non-players, might be a bug. I was looking for all players across the DB linked to a specific city I was going to remove and had to correct some outstanding records. I was able to get to what I needed by creating an export filter only on players/non-players from the United States.
User avatar
xECK29x
Premier Pivot Rosters Man
Prospect
 
Posts: 67
Joined: Sun May 03, 2015 3:52 pm
Points: 0.67

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sun Feb 11, 2018 5:00 pm

xECK29x wrote:Got one feature request and a possible bug for you Archi.

Can you please sort any blank entries (such as a player, city, club etc) as ([None]) always at the top? I find this is not uniform across these screens and can lead to unneeded blank entries, small thing I know :).


They should be already. Can you post a screenshot of an example please?

xECK29x wrote:This DB (https://www.dropbox.com/s/zuw6q54mmv7h9 ... se.db?dl=0) is crashing when exporting the model or exporting all players/non-players, might be a bug. I was looking for all players across the DB linked to a specific city I was going to remove and had to correct some outstanding records. I was able to get to what I needed by creating an export filter only on players/non-players from the United States.


Are you exporting using xlsx? Exporting large amounts of data with xlsx is a known issue. Use csv and it'll be fine.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Sun Feb 11, 2018 6:38 pm

Looks like Arenas/Cities/Clubs are pretty consistent actually:

Image
Image
Image

But staff behaves like this:

Image
Image
User avatar
xECK29x
Premier Pivot Rosters Man
Prospect
 
Posts: 67
Joined: Sun May 03, 2015 3:52 pm
Points: 0.67

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sun Feb 11, 2018 7:38 pm

Thanks - I see what you are getting at. I will see if I can get these "[None]" players to the top of the list in the next release.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: Editing league rules and structures in EHM 1

Postby Manimal » Sun Feb 11, 2018 9:42 pm

The Updater had a function where we could see what the CA levels were in each league. worst-medium-highest
Is it possible to include something like that in the editor?
User avatar
Manimal
EHM Rosters Man
TBL Admin Team
 
Posts: 6,147
Joined: Thu Apr 24, 2008 5:01 am
Points: 205.52
Trophies:  4 

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sun Feb 11, 2018 9:54 pm

Yes, absolutely. I'll add it to my list.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Mon Feb 12, 2018 11:05 pm

Archi,

Seems I found a big bug in the editor, whenever I create a new junior team with my current DB is it overwriting a national junior team (stating with the letter Z and working it's way backwards). Not sure why it's doing this but I can provide the DB and it's pretty easy to re-produce. PM me and I can work with you directly.
User avatar
xECK29x
Premier Pivot Rosters Man
Prospect
 
Posts: 67
Joined: Sun May 03, 2015 3:52 pm
Points: 0.67

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Fri Feb 16, 2018 2:18 am

xECK29x wrote:Archi,

Seems I found a big bug in the editor, whenever I create a new junior team with my current DB is it overwriting a national junior team (stating with the letter Z and working it's way backwards). Not sure why it's doing this but I can provide the DB and it's pretty easy to re-produce. PM me and I can work with you directly.


Has anyone else had this issue? It's starting to become really burdensome to keep on top of, luckily I am almost done creating teams for a while.
User avatar
xECK29x
Premier Pivot Rosters Man
Prospect
 
Posts: 67
Joined: Sun May 03, 2015 3:52 pm
Points: 0.67

Re: EHM 1 Database & Saved Game Editor

Postby Manimal » Fri Feb 16, 2018 10:49 am

xECK29x wrote:
xECK29x wrote:Archi,

Seems I found a big bug in the editor, whenever I create a new junior team with my current DB is it overwriting a national junior team (stating with the letter Z and working it's way backwards). Not sure why it's doing this but I can provide the DB and it's pretty easy to re-produce. PM me and I can work with you directly.


Has anyone else had this issue? It's starting to become really burdensome to keep on top of, luckily I am almost done creating teams for a while.


Never stumbled upon that during all my years of editing
User avatar
Manimal
EHM Rosters Man
TBL Admin Team
 
Posts: 6,147
Joined: Thu Apr 24, 2008 5:01 am
Points: 205.52
Trophies:  4 

Re: EHM 1 Database & Saved Game Editor

Postby Primis » Fri Feb 16, 2018 4:15 pm

Archi I know you are eventually planning to make Staff accessible from the Team info (ie, can see who's signed with that team). That'll honestly be great.

Is there any chance of eventually adding Staff filters though so you could filter staff by Team, Nationality, etc?
User avatar
Primis
Freeware Moderator
 
Posts: 1,639
Joined: Tue Aug 03, 2010 8:46 pm
Points: 16.39

Re: EHM 1 Database & Saved Game Editor

Postby Manimal » Fri Feb 16, 2018 9:07 pm

Primis wrote:Archi I know you are eventually planning to make Staff accessible from the Team info (ie, can see who's signed with that team). That'll honestly be great.

Is there any chance of eventually adding Staff filters though so you could filter staff by Team, Nationality, etc?


Not sure I understand what you are looking for, but you can filter by job for club and club contracted.
Do you mean this should be editable in the clubs section?
User avatar
Manimal
EHM Rosters Man
TBL Admin Team
 
Posts: 6,147
Joined: Thu Apr 24, 2008 5:01 am
Points: 205.52
Trophies:  4 

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sat Feb 17, 2018 11:06 am

xECK29x wrote:Archi,

Seems I found a big bug in the editor, whenever I create a new junior team with my current DB is it overwriting a national junior team (stating with the letter Z and working it's way backwards). Not sure why it's doing this but I can provide the DB and it's pretty easy to re-produce. PM me and I can work with you directly.


So are you just creating a new club, setting them to junior and that's it? I'll try and replicate it here to see what is happening.

Sorry for the delay in responding - it has been a really long week at work.

Primis wrote:Archi I know you are eventually planning to make Staff accessible from the Team info (ie, can see who's signed with that team). That'll honestly be great.

Is there any chance of eventually adding Staff filters though so you could filter staff by Team, Nationality, etc?


As Manimal mentioned, there is an orange filter button in the bottom left hand corner of most editing screens. On the staff screen you can filter by club, nationality, etc. If you are referring to something else then do let me know.

That's right about the club screen. I also want to be able to edit contract data and move players/non-players to/from clubs via that screen.
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby Primis » Sat Feb 17, 2018 5:18 pm

archibalduk wrote:As Manimal mentioned, there is an orange filter button in the bottom left hand corner of most editing screens. On the staff screen you can filter by club, nationality, etc. If you are referring to something else then do let me know.


So... I was really confused at this. There's been a grayed-out FIlter icon in the lower-left forever but never an orange one. And I've been downloading and updating versions all along.

I finally figured out the problem. When I've extracted the last few versions they didn't overwrite but put them in a new subfolder, I was still using one form last September. Ooops. So I haven't actually been using the newer versions.

My bad. Fixed. I'm an idiot who doesn't pay attention. I now see the filters, whoooooo! Very excited, it will greatly simplify things.
User avatar
Primis
Freeware Moderator
 
Posts: 1,639
Joined: Tue Aug 03, 2010 8:46 pm
Points: 16.39

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Sun Feb 18, 2018 5:54 pm

Looks like creating any new club, not sure if it is something with junior/national U20 records having issues. I'll know it happens because a GUI bug appears shortly after saving. You won't see it instantly after creating the club and saving, what will happen is when I go to assign staff to the club I'll see the name of the club change in the selection box to Zaire U20 or Zimbabwe or some other nation, that is how I know it occurred. When I look up the nation I saw in the selection box usually the city, arena, and reputation info of the club I created will overwrite the country, and make it a junior team. After a long editing session creating clubs I have to figure out what national team was overwritten and manually correct the changes via the tip you gave me in the other thread. Sometimes it will bug out for teams I created weeks ago, it's pretty weird.

Happy to do a Zoom meeting or something to show you in person, just PM me. I should be able to reproduce it pretty easily.
User avatar
xECK29x
Premier Pivot Rosters Man
Prospect
 
Posts: 67
Joined: Sun May 03, 2015 3:52 pm
Points: 0.67

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Sun Feb 18, 2018 7:57 pm

xECK29x wrote:Looks like creating any new club, not sure if it is something with junior/national U20 records having issues. I'll know it happens because a GUI bug appears shortly after saving. You won't see it instantly after creating the club and saving, what will happen is when I go to assign staff to the club I'll see the name of the club change in the selection box to Zaire U20 or Zimbabwe or some other nation, that is how I know it occurred. When I look up the nation I saw in the selection box usually the city, arena, and reputation info of the club I created will overwrite the country, and make it a junior team. After a long editing session creating clubs I have to figure out what national team was overwritten and manually correct the changes via the tip you gave me in the other thread. Sometimes it will bug out for teams I created weeks ago, it's pretty weird.

Happy to do a Zoom meeting or something to show you in person, just PM me. I should be able to reproduce it pretty easily.


Thanks! I'm in the midst of revamping roster management in the Editor at the moment (in order to allow player and non-player editing via the Clubs screens) - so I'll take a look as soon as I have completed this. I should be able to track the issue pretty easily. The game requires the national teams to be placed as the final entries in the database. It sounds like newly created teams, in certain circumstances, are either ending up at the end of the table or have a National Team flag. I'll let you know.

Primis wrote:
archibalduk wrote:As Manimal mentioned, there is an orange filter button in the bottom left hand corner of most editing screens. On the staff screen you can filter by club, nationality, etc. If you are referring to something else then do let me know.


So... I was really confused at this. There's been a grayed-out FIlter icon in the lower-left forever but never an orange one. And I've been downloading and updating versions all along.

I finally figured out the problem. When I've extracted the last few versions they didn't overwrite but put them in a new subfolder, I was still using one form last September. Ooops. So I haven't actually been using the newer versions.

My bad. Fixed. I'm an idiot who doesn't pay attention. I now see the filters, whoooooo! Very excited, it will greatly simplify things.


Haha! :D There were a lot of changes between the September 2017 version and the current version, so it should be a nice surprise features-wise!
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby xECK29x » Mon Feb 19, 2018 1:20 am

Here is a small visual example of the bug, this happened immediately after saving.

Image

Image

I am able to reproduce this 100% of the time, it is the creation of any club that does it.
User avatar
xECK29x
Premier Pivot Rosters Man
Prospect
 
Posts: 67
Joined: Sun May 03, 2015 3:52 pm
Points: 0.67

Re: EHM 1 Database & Saved Game Editor

Postby archibalduk » Mon Feb 19, 2018 5:57 pm

Thanks. I'll check it out. :thup:

On another topic: Below is very early draft of the player roster sub-screen of the Clubs screen. I was originally going to just cover the contract details but I think it would be handy if everything could be editable from this screen (with some buttons to show just certain categories of data - e.g. one button will display just contract data, another will show goalie attributes, etc). There will also be something similar for the non-players as well. Obviously in the final screen, data such as birth cities and nationalities will be shown as text rather than numbers.

Image
User avatar
archibalduk
Seaside + Fruit Juice Mode
TBL Admin Team
 
Posts: 18,708
Joined: Tue Jul 06, 2004 9:44 pm
Points: 198.28
Trophies:  1   2   1

Re: EHM 1 Database & Saved Game Editor

Postby nino33 » Mon Feb 19, 2018 6:59 pm

archibalduk wrote:I think it would be handy if everything could be editable from this screen (with some buttons to show just certain categories of data - e.g. one button will display just contract data, another will show goalie attributes, etc). There will also be something similar for the non-players as well.
I agree/this sounds great! :thup:


While I've done some significant editing work in the last year in excel spreadsheet format, I've done little if any "active editing" with the actual editor...until lately; I've recently begun editing the 1974 master database again, and I'm doing so in the new EHM format (with the idea of not editing in EHM07 format and then importing the database into the new EHM, I've now completely left EHM07 behind)

As always, spectacular work Arch! :notworthy: The addition of the filtering options are very helpful! :nod:
User avatar
nino33
Retro Rosters Specialist
Mr. Goalie
 
Posts: 5,795
Joined: Sat Aug 07, 2010 4:37 am
Points: 76.00

PreviousNext

Return to Data Editing Forum

Who is online

Users browsing this forum: No registered users and 1 guest