Import Error

[Asher413]

Working on a very old DB (started the work in 2009), and trying to import it into 2015 ruleset, and get the following error:

"Cannot find team with unique id 105980 to set continental flag !"

How can I find what the team is to remove it from the Continental competitions?

[nino33]

Working on a very old DB (started the work in 2009), and trying to import it into 2015 ruleset, and get the following error:

IMO you're brave to try! HaHa

Getting a retro database to work with a 2006 Rule Set means you can trust what you see in the PreGame Editor/Updater and make changes accordingly.....while the 2014/2015 Rule Sets AFAIK have a lot of things happen "automatically" due to coding (and what you see in the PreGame Editor/Updater is not necessarily what appears in the imported database)

the following error:

"Cannot find team with unique id 105980 to set continental flag !"

How can I find what the team is to remove it from the Continental competitions?

Is by chance "105980" a typo, with one extra number?
You can use the EHM Updater to export the club data, and it includes the unique ID number for each club - but for my 1974 database that goes from 0 to 4,685 & for TBL 8.1 goes from 0 to 7116.....so a team with an ID number above 100,000 seems odd

[Asher413]

IMO you're brave to try! HaHa

Sometimes the line between brave and stupid/stubborn is thin. I really was salavating at the thought of smaller American minors, and the 4 division formats. I also assumed (incorrectly after three hours of pain) that with force teams it would be a cinch.

the following error:

"Cannot find team with unique id 105980 to set continental flag !"

How can I find what the team is to remove it from the Continental competitions?

Is by chance "105980" a typo, with one extra number?
You can use the EHM Updater to export the club data, and it includes the unique ID number for each club - but for my 1974 database that goes from 0 to 4,685 & for TBL 8.1 goes from 0 to 7116.....so a team with an ID number above 100,000 seems odd[/quote]

Just tried again, it is indeed 105980. 4481 is the highest ID when I export, 4482 teams. I started with the EHM 2007 default db (maybe even before 3.4) and haven't added or deleted teams, just edited. Sure wish I could just turn off the Euro continental competitions, or it would at least let me import without them active just to test my progress... sigh.

I'm guessing I'll probably have to retreat and go back to 2006 ruleset.

[archibalduk]

You're looking at the ID number and not the Unique ID number (various tables in EHM 1 use both). Unique ID numbers for clubs begin at UID 100,000. So the team you're looking for is the team with ID 5,980. Although the national teams will also have team IDs (and these are located immediately after the club team IDs), it sounds like your DB is too small to include a team with ID 5,980. In the TBL v8.2 Rosters, HK Kremenchuk is the team with this ID and UID.

I suspect the issue is that you do not have enough teams in your database for the Import function in the game to setup the various rules and structures for the 2015 ruleset.

[nino33]

You're looking at the ID number and not the Unique ID number (various tables in EHM 1 use both).

Just curious, is there a reason we know of for why there's two? and is the non-National team unique ID number always the ID Number + 100,000?

[archibalduk]

IIRC the primary reason behind the UID is to get around the old hardcoded data limitations when importing data (e.g. the hardcoded requirements that the NHL is called the NHL, etc). I'm not entirely certain how it works in practice though.

The Importer in EHM reserves certain ranges for different tables upon import. So the Clubs table has a reserved range starting at 100,000 (I haven't look at what figure the reserved range extends to). So, as I understand it, the Club UID will always be the ID + 100,000 upon import. However, any clubs added after import (i.e. through my editor or any other EHM 1 DB editor) will simply use the next available UID (there is a table in the DB which tracks the next available UID number).

As I understand it, the UID is really for the purposes of importing data. Once the data is imported, I *think* the importance of the UID falls away somewhat. But I'm not 100% certain of this because I haven't yet been able to experiment sufficiently with adding data to the EHM 1 DB format.

If you want to take a closer look at the UID, it is displayed in the top right hand corner of the various editing screens of my Editor. IIRC it displays "n/a" where a particular table does not use a UID field.

[nino33]

Thanks for the great reply/explanation! much appreciated