HOW TO: Import an EHM 2007 database into EHM 1

[archibalduk]

Did you make any changes to the database or import_config file?

[Slimey]

I tried with all kind of databases (both TBL versions, a couple of modified databases in the editors) and with a changed/fresh import_config file. Something with the leagues seems broken when I import it when I read the errors I get.

[archibalduk]

Can you get it working with the unedited TBL Rosters?

What I'm looking to determine is whether you have made edits to the DB/import_config because it's likely that user modification has caused these issues (e.g. if you have tried to move teams to/from leagues).

[Slimey]

No, the unedited TBL doesn´t work for me. That was the first I tried and the reason why I´m writing here

[archibalduk]

Hm hard to diagnose as it works with others and it is the first time I've heard of this issue. All I can suggest at this stage is to uninstall and reinstall the game.

[MGSPORTS]

Works fine for me.

[Slimey]

Oh, I forgot about this thread
I have reinstalled it twice, and after the recent update the import works better, but it is still broken. Some of the leagues is missing and NHL is unplayable, but the rest seems to work ok. I will wait a while longer and hopefully the problem solve itself after some updates.

EDIT: I finally found a solution/workaround to this issue. I still have problem with the import function after several attempts to reinstall the game, but my temporary solution to this is to run it in my virtual machine (with Win 10 TP) and import the databases there. Same game & same database but it´s now working perfect!

[hockey17jp]

I just downloaded the game and I have no experience with extracting and importing files so bear with me.

I extracted the v7.3 EHM 2007 rosters into the data/database/ folder and everything is in place just like it is in the picture in the directions, but when I open up the game to import nothing shows up.

I didn't mess with the import config at all because the directions said not to if we don't care about what year it starts at.

I'm not sure what to do and any help would be much appreciated.

Is there any chance someone could make a step by step video on how to download it and post it on Youtube or something? The current (and only) video on Youtube is outdated and there are many people in the comment sections that are having the same problem I am. A video would make this a lot easier for us newbies.

[archibalduk]

It sounds like perhaps there's a sub-folder within a sub-folder. Make sure that the .dat files are within data/database/<TBL v.3 folder>/ and not data/database/<TBL v.3 folder>/<sub-folder>/.

Which YouTube video are you watching?

[hockey17jp]

It sounds like perhaps there's a sub-folder within a sub-folder. Make sure that the .dat files are within data/database/<TBL v.3 folder>/ and not data/database/<TBL v.3 folder>/<sub-folder>/.

Which YouTube video are you watching?

Thank you so much! The folder with the .dats was in another folder with a README. I have everything working fine now.

[Stormsky]

I've run into a couple of problems, and hoping that maybe there is a solution someone knows.

I've tried so far to import the TBL Rosters v6.3 and the Unfaking Database v6.1 (using the 2006 config file). Both times I run into problems where the database will not import. With the 6.3 rosters there are a bunch of errors about defunct teams and with the Unfaking rosters the issues are the number of teams in Scandinavian leagues. I'm really not sure what it is I am doing wrong, so any help/ideas are appreciated.

[archibalduk]

I don't think you're doing anything wrong. It's just that the game is struggling to import the DBs.

I took at look at the Unfaking DB v6.1 in the Updater. The number of teams in the SM-Liiga and Allsvenskan appear to be correct - or at least there's nothing like the 42 teams like it suggests (I checked both the Main Division and Other Division settings). I think this is a bug we need to report (I'll do my best to remember to report this over the weekend with a detailed report).

As for the TBL Rosters v6.3 - although I haven't checked these, I'm almost certain it'll be because some of the original teams are now defunct. The Import function in the game expects teams with certain ID numbers to be active in the DB because those teams will be assigned to the playable leagues. Some of these teams must have been made inactive in the DB and so the game does not like this.

[nino33]

The Import function in the game expects teams with certain ID numbers to be active in the DB because those teams will be assigned to the playable leagues.

This is what I wonder about with the UUDB databases...is the game looking for certain team names that are in the default DB but not in an UUDB (because some of the teams in the default DB had their name "faked" and the UUDB has the "unfaked" team name - with the import function is the game looking for default DB team names?)

[Stormsky]

Alright, thanks guys.

I loaded up the TBL:DB Unfaking database with no issues (the one here: http://www.ehmtheblueline.com/forums/vi ... =77&t=6643). Not sure if this supports or refutes the "names" theory.

I can also load up 7.3 just fine. However, part of what got me excited for EHM:EA is the ability to play historical set-ups. I was really looking forward to playing the 2006 and 2014 set-ups. I guess TBLDB will be fine for 2006, but is there any way to "roll back" the 7.3 roster to the start of 2014 or something like that?

[archibalduk]

The Import function in the game expects teams with certain ID numbers to be active in the DB because those teams will be assigned to the playable leagues.

This is what I wonder about with the UUDB databases...is the game looking for certain team names that are in the default DB but not in an UUDB (because some of the teams in the default DB had their name "faked" and the UUDB has the "unfaked" team name - with the import function is the game looking for default DB team names?)

No, the game no longer uses name indexes (hence we can now rename any league or team to whatever we want). The game goes purely by ID number.

There seem to be two errors that people have encountered:

1. Defunct teams - I think this is because a team with a particular ID is defunct (and the game is trying to add it to a playable league); and

2. League size error - this, I think, is a bug in the case of the UUDB.

The TBL:DB 2006 and the UUDB are two entirely different databases. Hence why one might work and not the other.

[nino33]

I loaded up the TBL:DB Unfaking database with no issues (the one here: http://www.ehmtheblueline.com/forums/vi ... =77&t=6643). Not sure if this supports or refutes the "names" theory.

I'd say it mostly refutes it...because we don't know why some databases won't input, and the TBL Unfaking is from 2006-07 I'd still wonder if maybe there's name changes that occurred in later seasons that might be causing a problem?

I remember with editing EHM07 you had to keep some NHL teams in the NHL or the game would crash, and it wasn't always the same teams!

[archibalduk]

I remember with editing EHM07 you had to keep some NHL teams in the NHL or the game would crash, and it wasn't always the same teams!

I think our posts crossed! Regarding the above, this issue was resolved with the introduction of EHM:EA as name indexes are no longer used. Try renaming the NHL in the Pre-Game Editor and import the DB - it should work no problem (indeed, we have already renamed many leagues and teams for the TBL Rosters v7.3 - such as the KHL).

[nino33]

I hope whatever the issue is gets fixed soon, as I'd like to reproduce my previous testing (looking at CA growth among other things) with the same database I used then, so I need the UUDB 6.0 working

[nino33]

I remember with editing EHM07 you had to keep some NHL teams in the NHL or the game would crash, and it wasn't always the same teams!

I think our posts crossed! Regarding the above, this issue was resolved with the introduction of EHM:EA as name indexes are no longer used. Try renaming the NHL in the Pre-Game Editor and import the DB - it should work no problem (indeed, we have already renamed many leagues and teams for the TBL Rosters v7.3 - such as the KHL).

I'm planning to look into this more in July! I figured to start I could look at some League/Division name changes with the 1974 DB as an opportunity to learn

Is there anywhere that lists what we can change, how to do it?
Or is it "look at those that exist" and learn by copying HaHa

[archibalduk]

Sorry this is brief - I have my phone in one hand and cleaning teeth with the other!

You can rename anything you like using the Pre Game Editor or import_config (see the TBL v7.3 config for examples of the command).

[mpronger]

I have managed to import UUDB v6.1. I'll try to get a tutorial asap as I'm not at home currently.

[mpronger]

Alright so here it is... I have also imported the 98-99 DB using similar method.

1: Extract your DB in the "Data\Database\UUDB v6.1" path under EHM's main folder. In my case I added "EA" to the folder name so I could identify it was to be used in the new EHM, therefore it's "UUDB v6.1 EA"

2: Copy the "import_config.cfg" file from the "historical 2006" folder to the newly made "UUDB v6.1 EA" folder



3: If you fire up EHM now and try to import you'll see the following errors



4: Execute the EHM 2007 Pre-game editor and load up the database we just extracted as bellow



5: In the club competitions tab, find the Finnish leagues.
6: Now here is where the importer goes nuts whem identifing the teams from leagues. If more than one league's last name is the same, the importer will think it's from the same league.

So we have the Finnish SM-League. The name here we need to look at is "SM-League". If you see the image of the Finnish leagues, you can see how both Finnish A-Jrs SM-League and Finnish B-Jrs SM-League end in "SM-League". The importer is thinking that the teams from these leagues are part of the Finnish SM-League.

7: Remove the "-" from both A-Jrs and B-Jrs league's making the name now "SMLeague" instead of "SM-League" and click the confirm button.



8 Now for the Swedish league issue. Pretty much the same, the teams from "Swedish J18 Allsvenskan" are trying to be imported into the "Swedish Allsvenskan".

Since there's no "-" to remove I decided to simply leave the name as "Swedish J18" in the name and "J18" in the short name. Confirm when the names have been changed and use the file menu to save the DB.



9 Now try to import the db in NHL EA. One you see the dialog called "Setting up record name indexes..." you'll have succeeded in a couple of minutes the DB will be ready to use.



10 You can now start a game and select the UUDB 6.1 EA database.



11 Once the db is loading you'll see an error as bellow, but I have no idea why but the game loads and plays normal. I suspect some team has their arena screwed up.



Hope this helps you guys. I've been trying to do this since the game came out in march. A couple of days ago I got the light.

[Stormsky]

Sorry if its a silly question, but is the utility the EHM 2007 Updater? Or is there some other editor I should use for this?

[nino33]

Sorry if its a silly question, but is the utility the EHM 2007 Updater? Or is there some other editor I should use for this?

The screen shot above shows the EHM07 Pregame Editor http://www.ehmtheblueline.com/forums/vi ... =88&t=6745
The EHM Updater is a different utility/editor (also for EHM07) http://www.ehmtheblueline.com/forums/vi ... hm+updater

mpronger - thanks for figuring things out/posting!

[Stormsky]

Works great! Thanks so much!