HOW TO: Import an EHM 2007 database into EHM 1

This is the place to discuss database or roster projects for Eastside Hockey Manager. Any queries about data editing should be asked in the Data Editing Forum.
Forum rules
Data Editing Forum: Editing the game, databases or saved games. Home of the EHM Editor and the EHM Assistant.

Game Add-ons Forum: Database projects, graphics and sounds. Any discussion which does not relate to editing databases or saved games.

Game Knowledge Discussion: Attributes, coaching, drafting, scouting, tactics and training/practice.

Rosters Forum: Discussion relating to all database and roster projects for Eastside Hockey Manager.

Technical Support: Difficulties, crashes and errors when installing or running the game (and nothing else). Any issues relating to the TBL Rosters must be posted in the TBL Rosters forum. Questions about how to install add-ons must be posted in the Game Add-ons Forum.

General EHM Chat: Anything relating to Eastside Hockey Manager 2004 / 2005 / 2007 / 1 which does not fall within any of the other forums.

Please carry out a forum search before you start a new thread.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

mikewilliams11 wrote:Hi guys, I'm really confused about all of this. I've never had or played EHM 2007, and have never downloaded the pre-game editor either, however I want to be able to make changes to the database for EHM EA. Sooooo I downloaded the editor but from here I'm stcuk ](*,) I tried to follow the instructions but I lost track at the import config file. Also when I downloaded the roster update for EHM 2007, I have no idea where to put it so that I can edit it, any help would be massively appreciated!
Only EHM 2007 format databases can be edited right now. So you need to download an EHM 2007 database (there is a 2007 version of the v7.3 rosters HERE) -> then edit using the Pre-Game Editor (HERE) -> then import into EHM:EA by following the guide in the first post of this thread.

You can place you EHM 2007 DB anywhere to edit it (e.g. just put it in a sub-folder on your Desktop). Then once you're done, move the DB to your data/database/ folder as described by the guide in the first post of this thread.
ExxonPirate wrote:Hey everyone.

I'm so freaking excited to see this game; I thought I'd be playing 2007 until I died.

Anyway. I've created a database in EHM 2007 that completely overhauled the AHL. I changed the name, and changed all the teams. In '07 it works flawlessly--haven't had a crash since I finished it--and I've imported it into EA. It went smoothly, and there were no errors during the importing process. However, when I start up a game the team names are not changed, and there are no rosters on any teams. I tried deleting and reimporting; I tried a bunch of things I thought would work, but to no avail.

Does anyone have an tips, or do the databases with custom teams/players not work?

Thanks.
Did you create new teams and move them to the AHL? If so, you will need to use the 2006 rule set when importing into EHM:EA. The Import function looks for the original AHL teams in the DB and places them in the new AHL. So you will need to overwrite the existing AHL teams rather than place your new teams in the AHL.

Last month I asked Riz if we could have a command in the import_config so that we can override the Import function in respect of which teams move where. He said he'd look into it, so hopefully this is something that'll be possible in the future. In the mean time, we just have to use the existing AHL teams and edit those accordingly (note that team names are not hardcoded in EHM:EA and so you can rename the teams and leagues to whatever you want).
jetwing13
Junior League
Posts: 12
Joined: Tue Jan 15, 2008 5:21 pm

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by jetwing13 »

jetwing13 wrote:Do you have to do anything special if you try to import a database twice? I imported a database without any issues the first time, then noticed some errors. When I tried to re-import it, none of those changes showed up when starting a new game. I tried copying and renaming the database folder, but that had no effect.
archibalduk wrote:Did you first delete the database.db file that was created the first time around beforehand?

Yes, i deleted the file and tried to re-import, but the same issue persisted.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

Your best bet is to move your EHM 2007 DB into a new sub-folder and import again (delete your previous subfolder).
User avatar
Comete89
Learning to skate
Posts: 4
Joined: Mon Apr 06, 2015 12:06 am
Favourite Team: Montréal Canadiens

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Comete89 »

Is there anyway to change the number of roster spots/veteran players?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

Comete89 wrote:Is there anyway to change the number of roster spots/veteran players?
No, the import_config file does not provide for this.
ExxonPirate
Junior League
Posts: 45
Joined: Fri Apr 24, 2009 3:21 am

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by ExxonPirate »

archibalduk wrote: Did you create new teams and move them to the AHL? If so, you will need to use the 2006 rule set when importing into EHM:EA. The Import function looks for the original AHL teams in the DB and places them in the new AHL. So you will need to overwrite the existing AHL teams rather than place your new teams in the AHL.

Last month I asked Riz if we could have a command in the import_config so that we can override the Import function in respect of which teams move where. He said he'd look into it, so hopefully this is something that'll be possible in the future. In the mean time, we just have to use the existing AHL teams and edit those accordingly (note that team names are not hardcoded in EHM:EA and so you can rename the teams and leagues to whatever you want).
Thanks, archi. That's good news. It was such a pain to have to keep the old teams, and make sure that the new teams were in the proper divisions. Anyway, I guess I'll just start the database over.

Oh, and I had used the league rules editor that (you?) made that allows you to change roster limits and such, to set the AHL to allow an unliminted amount of "Veteran" roster players. I assume I can't use that on EA, or can I?

Again, thanks.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

Regarding the League Rules Editor (i.e. the Hardcode Editor): You're right about that - the Editor won't work with EA I'm afraid.
Burial11
Learning to skate
Posts: 2
Joined: Sun Mar 22, 2015 8:16 pm

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Burial11 »

Hi) Is there any way i can get 2006 Non-Patched Rosters version of TBL Rosters v7.3? Thanks)
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

Burial11 wrote:Hi) Is there any way i can get 2006 Non-Patched Rosters version of TBL Rosters v7.3? Thanks)
1. Download and extract the EHM Updater to a temporary folder (and note the minimum requirements as stated on the download page): http://www.ehmtheblueline.com/forums/vi ... 88&t=13532
2. Load the EHM Updater, the click on File -> Open Database and select the TBL Rosters you want to adjust. Note that you should use the Run as Admin setting when loading the EHM Updater otherwise your changes may not be saved (right-click on the EHM Updater exe file and you’ll see the Run as Administrator option).
3. Click on the Database tab.
4. At the bottom of the Database screen you will see a Year Adjustment setting. You will need to enter the appropriate negative year setting in order to adjust the years correctly. To do so, subtract 2006 from the starting year of the rosters. For example, if the roster is for the 2014/15 season, subtract 2014 from 2006 = -8 (i.e. minus 8).
5. Enter the appropriate value in the Year Adjustment setting and click on Adjust Years. This will adjust the rosters for a 2006 start date.
6. Click on File -> Save to save your changes.
vyassaran
Learning to skate
Posts: 3
Joined: Fri Mar 27, 2015 9:09 am

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by vyassaran »

Anyone know how I can pull this off on Mac? Desperate to get a save game/pregame editor running and I blieve it requires importing an 07 databse...
Burial11
Learning to skate
Posts: 2
Joined: Sun Mar 22, 2015 8:16 pm

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Burial11 »

archibalduk wrote:
Burial11 wrote:Hi) Is there any way i can get 2006 Non-Patched Rosters version of TBL Rosters v7.3? Thanks)
1. Download and extract the EHM Updater to a temporary folder (and note the minimum requirements as stated on the download page): http://www.ehmtheblueline.com/forums/vi ... 88&t=13532
2. Load the EHM Updater, the click on File -> Open Database and select the TBL Rosters you want to adjust. Note that you should use the Run as Admin setting when loading the EHM Updater otherwise your changes may not be saved (right-click on the EHM Updater exe file and you’ll see the Run as Administrator option).
3. Click on the Database tab.
4. At the bottom of the Database screen you will see a Year Adjustment setting. You will need to enter the appropriate negative year setting in order to adjust the years correctly. To do so, subtract 2006 from the starting year of the rosters. For example, if the roster is for the 2014/15 season, subtract 2014 from 2006 = -8 (i.e. minus 8).
5. Enter the appropriate value in the Year Adjustment setting and click on Adjust Years. This will adjust the rosters for a 2006 start date.
6. Click on File -> Save to save your changes.
Thanks alot!)
CCFHL commish
Learning to skate
Posts: 1
Joined: Fri Apr 17, 2015 11:14 am
Favourite Team: Philadelphia Flyers

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by CCFHL commish »

Hi All,

Can someone tell me if you have to download "OneDrive" in order to get the rosters?

Thanks,
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

No, you don't.
User avatar
MattL41
Junior League
Posts: 5
Joined: Sun Apr 19, 2015 10:40 am
Favourite Team: Braehead Clan

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by MattL41 »

Hello

I am trying to start a new game in Easy Access with the TBL 7.3 roster update. I have downloaded the database and saved it to the right place, but when I select "Import Database" the "Database" field is blank and the "Location" field shows 'Application Folder'. There is no drop down menu in either field.

Any help in finding the database would be greatly appreciated.

Cheers.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

If nothing is appearing in the Import menu then you haven't put the rosters in the correct place. The folder structure should look like this:

Image
MartanCJ
Learning to skate
Posts: 2
Joined: Sun Feb 14, 2010 7:37 pm

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by MartanCJ »

Hello,

am I doing something wrong or the leagues as Swiss, KHL, British and few others are not playable?

Thank you.
User avatar
nino33
Mr. Goalie
Posts: 6088
Joined: Sat Aug 07, 2010 3:37 am
Custom Rank: Retro Rosters Specialist
Favourite Team: 1970s hockey

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by nino33 »

MartanCJ wrote:Hello,

am I doing something wrong or the leagues as Swiss, KHL, British and few others are not playable?

Thank you.
The Swiss and British Leagues are currently not playable in EHM:EA, but the KHL is playable
User avatar
Asher413
Challenge Moderator
Posts: 355
Joined: Wed May 20, 2009 2:28 am
Favourite Team: Pittsburgh Penguins

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Asher413 »

Hi all,

A couple of questions after reading all this-

I have been working on for... about 5 years a 1972 database in EHM 2007. If I'm reading all of this correctly, I would have to go and find the original NHL/AHL/ECHL teams and then overwrite those instead of creating new teams to replace in the NHL etc. (Which is what I did). Are there any suggestions on how to go about this without major work? (Don't get me wrong, the custom start date alone and the potential gets me motivated... I was through about Pittsburgh or so in the NHL).

How does EA handle the future moves, retirements, minor league affiliations etc? Would I have to redo those? (Are those features even on in EA?)

It appears that the new EHM freezes guys until they are 14- so could you (in theory) create every single player up to 2015 and they would show up at 14? (I'm not sure that's even a good idea with regens, but trying to understand the lay of the land)

Soviet Union- can you add/change/activate nationalities such as this (my old/current plan is I simply am leaving no quality players with just fillers for the former Soviet republics)

Last one (sorry for a long list) I see the unfaking database isn't working yet- I would assume that the original EHM2007 database would import, but are there any out there that go back to 2006 that are working? (A bitter Pens fan here who really wants to see if I can use 71/87/29 without leaving the whole cupboard bare like our GM's did)

Thanks in advance- spent about a day working in EA, but really found the historic properties of the 2006 rosters are lost when I constantly need to use hockeydb.com to figure out who is who (and can't add nicknames like FM)
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by archibalduk »

Asher413 wrote:I have been working on for... about 5 years a 1972 database in EHM 2007. If I'm reading all of this correctly, I would have to go and find the original NHL/AHL/ECHL teams and then overwrite those instead of creating new teams to replace in the NHL etc. (Which is what I did). Are there any suggestions on how to go about this without major work? (Don't get me wrong, the custom start date alone and the potential gets me motivated... I was through about Pittsburgh or so in the NHL).
I'll just quickly respond to this part as I want to get back to working on the Updater this evening. Have you tried importing the DB using the 2006 structure? This should work fine (it worked fine when I tested it using Nino's 1974 DB). Some people have reported errors importing the 2006/07 Unfaking DB and so I can't say for sure you'll be successful, but it's worth a try and will only take you about 5 minutes to test - just copy the import_config.cfg file from the default fictional 2006 rosters but change the start date setting to 1972 (use Notepad to edit the file).
User avatar
nino33
Mr. Goalie
Posts: 6088
Joined: Sat Aug 07, 2010 3:37 am
Custom Rank: Retro Rosters Specialist
Favourite Team: 1970s hockey

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by nino33 »

Asher413 wrote:How does EA handle the future moves, retirements, minor league affiliations etc?
AFAIK EHM:EA handles these things the same way EHM07 did

Asher413 wrote:It appears that the new EHM freezes guys until they are 14- so could you (in theory) create every single player up to 2015 and they would show up at 14?
That is correct

Asher413 wrote:Soviet Union- can you add/change/activate nationalities such as this (my old/current plan is I simply am leaving no quality players with just fillers for the former Soviet republics)
No one has tried/tested this (if you do, please let me know how it goes)

Asher413 wrote:I have been working on for... about 5 years a 1972 database in EHM 2007.
Sounds cool! In 1972 there were 16 NHL teams...how did you populate the remaining 14 NHL teams? Have you done the minors too? Juniors? Europe/Russia? I'd definitely be interested in knowing more

Asher413 wrote:spent about a day working in EA, but really found the historic properties of the 2006 rosters are lost when I constantly need to use hockeydb.com to figure out who is who
I'm not sure what you're saying here, but if you're saying you know the 1970s hockey world much better than the 2006 hockey world, you might be interested in trying the 1974 DB with EHM:EA http://www.ehmtheblueline.com/forums/vi ... 116&t=9915
User avatar
Asher413
Challenge Moderator
Posts: 355
Joined: Wed May 20, 2009 2:28 am
Favourite Team: Pittsburgh Penguins

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Asher413 »

Nino wrote:
Asher413 wrote:Soviet Union- can you add/change/activate nationalities such as this (my old/current plan is I simply am leaving no quality players with just fillers for the former Soviet republics)
No one has tried/tested this (if you do, please let me know how it goes)
[/quote]

Will try and let you guys know, probably won't be a while as it's state test time, a teacher's most relaxing time of the year!
Nino wrote:
Asher413 wrote:I have been working on for... about 5 years a 1972 database in EHM 2007.
Sounds cool! In 1972 there were 16 NHL teams...how did you populate the remaining 14 NHL teams? Have you done the minors too? Juniors? Europe/Russia? I'd definitely be interested in knowing more
I will find the spreadsheet later on my old computer, but off the top of my head: I took the WHA to fill some of the teams, then the top WHL teams to fill the rest, and basically ranked up the minor leagues and filled each level that way. The UHL will be mostly sarcastic guys who will retire, such as the District 9 ducks, Mystery Eskimos, Charlestown Chiefs etc. The names will stick, but the guys from those movies will retire the first year.
The juniors: (Which wouldn't load in 2007 and I'm not sure which team caused the problem) I started with the 'major' leagues, and did the same thing (found the highest junior leagues in the region and filled teams in).
I have information on Europe and Russia, but haven't touched them yet, mostly from a lack of finding reliable information to know where to start. (Of course, I've been using the highest profile Europeans I can find to fill in players to keep Ukraine from having great players, etc.)
Nino wrote:
Asher413 wrote:spent about a day working in EA, but really found the historic properties of the 2006 rosters are lost when I constantly need to use hockeydb.com to figure out who is who
I'm not sure what you're saying here, but if you're saying you know the 1970s hockey world much better than the 2006 hockey world, you might be interested in trying the 1974 DB with EHM:EA http://www.ehmtheblueline.com/forums/vi ... 116&t=9915
I'm thinking about it, I enjoyed the Flames challenge with it.

Thanks for the responses all, when I get time I'll try to import the database and see what happens. One of the big things I worked on (which gets interesting 20 years down the road) is having minor league affiliation change in the 'future', as outside of a few cases, about every 5 years a team changed their association. It also makes an interesting challenge when the WHA teams all have the first couple of years with affiliates like the Suncoast Suns, which only made the ECHL in my version. The only real problems with this that came up is with career minor leaguers resigning over and over again stay with the team they were first assigned, they don't change until they are called up (and in some cases, that's never).

Sorry to rant, always excited about the project, never enough time :)
User avatar
Loosie
Team Captain
Posts: 941
Joined: Fri Mar 14, 2008 2:16 pm
Custom Rank: Holy journeyman Batman
Location: Kitchener, Ontario, Canada

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Loosie »

So I can't seem to find this anywhere so I'm going to ask it here.

Do I have to re-import the 7.3 Roster database with 15.2b? I tried starting a new game and the new playable leagues are not there.
User avatar
nino33
Mr. Goalie
Posts: 6088
Joined: Sat Aug 07, 2010 3:37 am
Custom Rank: Retro Rosters Specialist
Favourite Team: 1970s hockey

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by nino33 »

Loosie wrote:So I can't seem to find this anywhere so I'm going to ask it here.

Do I have to re-import the 7.3 Roster database with 15.2b? I tried starting a new game and the new playable leagues are not there.
Yes, you have to reimport the database
Slimey
Junior League
Posts: 8
Joined: Wed Apr 01, 2015 8:06 pm
Favourite Team: Frölunda Indians

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Slimey »

I´ve tried a couple of times to import the TBL database (both versions) into the game but it doesn´t work properly. I´m getting a lot of COMP_LEAGUE_(Division/conference etc) errors which breaks almost every league in the game.
Did the 15.3b update break something?
Slimey
Junior League
Posts: 8
Joined: Wed Apr 01, 2015 8:06 pm
Favourite Team: Frölunda Indians

Re: HOW TO: Import an EHM 2007 database into EHM:EA

Post by Slimey »

Slimey wrote:I´ve tried a couple of times to import the TBL database (both versions) into the game but it doesn´t work properly. I´m getting a lot of COMP_LEAGUE_(Division/conference etc) errors which breaks almost every league in the game.
Did the 15.3b update break something?
This is really annoying, I have tried everything to get my database imported (tried several times to import it, edited it in both editors, start the game as admin etc..) but it fails every time. I really want to start with a database with the new changes applied but that seems to be impossible for me... :(
Post Reply