How to create a customised database?

[SEPH]

Hello, all as noted in my previous thread I am making my own custom database and need some help concerning what I want to do...

My plan was to do this...

EASTERN CONFERENCE
Northeast
Boston Bruins [AHL: Providence Bruins | ECHL: Worcester Railers]
Montreal Canadiens [AHL: Laval Rocket | ECHL: Quebec City Nordiques]
New Jersey Devils [AHL: Binghamton Devils | ECHL: Adirondack Thunder]
Ottawa Senators [AHL: Belleville Senators | ECHL: Maine Mariners]

Atlantic
Carolina Hurricanes [AHL: Charlotte Checkers | ECHL: Florida Everblades]
Florida Panthers [AHL: Orlando Solar Bears | ECHL: South Carolina Stingrays]
Tampa Bay Lightning [AHL: Syracuse Crunch | ECHL: Jacksonville IceMen]
Washington Capitals [AHL: Hershey Bears | ECHL: Norfolk Admirals]

Metro
New York Islanders [AHL: Bridgeport Sound Tigers | ECHL: Springfield Thunderbirds]
New York Rangers [AHL: Hartford Wolfpack | ECHL: Manchester Monarchs]
Philadelphia Flyers [AHL: Lehigh Valley Phantoms | ECHL: Reading Royals]
Pittsburgh Penguins [AHL: Wilkes-Barron/Scranton Penguins | ECHL: Wheeling Nailers]

East
Buffalo Sabres [AHL: Rochester Americans | ECHL: Utica Comets]
Detroit Red Wings [AHL: Grand Rapids Griffins | ECHL: Toledo Walleye]
Columbus Blue Jackets [AHL: Cleveland Monsters | ECHL: Greenville Swamp Rabbits]
Toronto Maple Leafs [AHL: Toronto Marlies | ECHL: Brampton Beast]

WESTERN CONFERENCE
Central
Chicago Blackhawks [AHL: Chicago Wolves | ECHL: Indy Fuel]
Nashville Predators [AHL: Milwaukee Admirals | ECHL: Atlanta Gladiators]
St. Louis Blues [AHL: San Antonio Rampage | ECHL: Fort Wayne Komets]
Winnipeg Jets [AHL: Manitoba Moose | ECHL: Rockford IceHogs]

West
Arizona Coyotes [AHL: Tucson Roadrunners | ECHL: Rapid City Rush]
Colorado Avalanche [AHL: Colorado Eagles | ECHL: Tulsa Oilers]
Dallas Stars [AHL: Texas Stars | ECHL: Allen Americans]
Minnesota Wild [AHL: Iowa Wild | ECHL: Quad City Mallards]

Northwest
Calgary Flames [AHL Stockton Heat | ECHL: Oklahoma City Blazers]
Edmonton Oilers [AHL: Bakersfield Condors | ECHL: Saskatchewan Whitetails]
Seattle Metropolitans [AHL: Kansas City Scouts | ECHL: Knoxville Ice Bears]
Vancouver Canucks [AHL: Idaho Steelheads | ECHL: Kalamazoo Wings]

Pacific
Anaheim Ducks [AHL: San Diego Gulls | ECHL: California Golden Seals]
Los Angeles Kings [AHL: Ontario Reign | ECHL: Wichita Thunder]
San Jose Sharks [AHL: San Jose Barracuda | ECHL: Fresno Falcons]
Vegas Golden Knights [AHL: Utah Grizzles | ECHL: Cincinnati Cyclones]

- How hard is it to edit teams to make this sort of structure?

- What about the schedule?

- What about changing affiliates? Would I have to transfer over the players by hand or is it automatic?

- I want to leave the IIHF format the same in terms of men's hockey groups such as main division, division 1A, and division III for example. However, I want to add more teams to the main group, is that also possible with the editor? Furthermore, can I also add more national countries like Greece, Brazil, and Tunisia to the IIHF groups? Like maybe expand DIII from 6 teams to 10 teams or make a DIV????

- Same questions of IIHF above, but concerning Olympics? Can I add more teams to qualifying stages and more teams to the actual group Olympic stages?

- Can I change the schedule for either the IIHF or Olympics without causing it to crash? Like making the Olympics in the summer if I wanted to? And make the IIHF divisions happen during the same type as the main group?

- What about the World Cup of Hockey? I see that I can add teams to the editor, but will I run into problems that will cause the saved game to crash? I want to potentially add all playable international teams to World Cup of Hockey and make the date earlier. Is that possible? If so, how would I make group stages similar to the World Cup in Futball? And another question, could I add teams like Brasil, Portugal, and Argentina to the World Cup of Hockey tournament?

Thanks a lot!

[BKarchitect]

- How hard is it to edit teams to make this sort of structure?
Pretty easy. You just have to make sure to cross your 't's' and dot your 'i's' in all the various screens.

- What about the schedule?
Difficult. Although I already have a 36 team schedule obviously which you could use as base. First you need to figure out your structure in terms of divisional games, conference games, etc for each team. What are the scheduling rules? How does each team get to 82 (and 41 Home/41 Away)?

- What about changing affiliates? Would I have to transfer over the players by hand or is it automatic?
Changing affiliates is easy. The question is this...say with Florida now having Orlando as an AHL affiliate...ok, well it potentially doesn't affect any of the players actually signed to Florida. In my database, I have all Florida Panthers contracted players also starting out playing on the Florida roster. Since teams have to go through training camps, I just let the CPU then decide who to send down. So changing them from Springfield to Orlando would have no affect, the CPU will just send their players down to Orlando now. Players signed to Orlando however, in the ECHL right now, would now be with Orlando AHL. I don't view this as a big deal but if you do, you'll have to move A LOT of players around. Also if the DB you are starting from has Florida's AHL level players pre-assigned to Springfield, then again, you'll have a lot of editing to do. But my rule of thumb is keep all NHL signed players both contracted and playing with their NHL club in the database and let the CPU move them around since they will call everyone up for training camp and move players to the AHL how they want to anyways. Exceptions would be loans back down to the CHL or to European clubs.

- I want to leave the IIHF format the same in terms of men's hockey groups such as main division, division 1A, and division III for example. However, I want to add more teams to the main group, is that also possible with the editor? Furthermore, can I also add more national countries like Greece, Brazil, and Tunisia to the IIHF groups? Like maybe expand DIII from 6 teams to 10 teams or make a DIV????
Can't help you there but editing International stuff appears to be very difficult if not impossible in some cases.

- Same questions of IIHF above, but concerning Olympics? Can I add more teams to qualifying stages and more teams to the actual group Olympic stages?
I think so, but it'll be a lot of work...you'll have to edit the structure, schedules, dates and add new stages.

- Can I change the schedule for either the IIHF or Olympics without causing it to crash? Like making the Olympics in the summer if I wanted to? And make the IIHF divisions happen during the same type as the main group?
Don't know.

- What about the World Cup of Hockey? I see that I can add teams to the editor, but will I run into problems that will cause the saved game to crash? I want to potentially add all playable international teams to World Cup of Hockey and make the date earlier. Is that possible? If so, how would I make group stages similar to the World Cup in Futball? And another question, could I add teams like Brasil, Portugal, and Argentina to the World Cup of Hockey tournament?
You have lots of international editing ambitions which I am not sure have ever been tried before!

Thanks a lot!

[BKarchitect]

PS - if you need to move a lot of players around dig into Archi's export/import functions in the editor. It makes mass editing much easier (once you get used to it - if you are comfortable in Excel then that's half the battle).

[SEPH]

PS - if you need to move a lot of players around dig into Archi's export/import functions in the editor. It makes mass editing much easier (once you get used to it - if you are comfortable in Excel then that's half the battle).

Thanks for the responses! I really appreciate it!

- To follow up upon the scheduling comment, did you have to put it in manual when you were doing your NHL 36 Foppa? And is there a guide I can find to change leagues for teams?

- Another quick question does changing the regional strength have an affect on a nation's strength for generated players in the future?

- If not, what about changing the likes of Reputation such as "league standard", "financial power", "game importance", and "develop state"?

- I think I saw that you cannot add any staff to any new team you want in the editor, will that cause the game to crash?

- What is the youngest date you can put into the game for a player? I want to create some wonderkids for the future drafts and don't want them to be in one draft.

[nino33]

- What is the youngest date you can put into the game for a player? I want to create some wonderkids for the future drafts and don't want them to be in one draft.

You can have players who haven't even been born yet!
Players will be "hidden" ingame (you won't find them if you search) until age 14-16 when they will then appear ingame; retro databases use this feature to put future players ingame at the appropriate time

[SEPH]

- What is the youngest date you can put into the game for a player? I want to create some wonderkids for the future drafts and don't want them to be in one draft.

You can have players who haven't even been born yet!
Players will be "hidden" ingame (you won't find them if you search) until age 14-16 when they will then appear ingame; retro databases use this feature to put future players ingame at the appropriate time

Any EHM-wiki guide in how to do this?

With the Duchene going down, any word in how to use the editor to give the Avs the proper picks?

[Manimal]

- What is the youngest date you can put into the game for a player? I want to create some wonderkids for the future drafts and don't want them to be in one draft.

You can have players who haven't even been born yet!
Players will be "hidden" ingame (you won't find them if you search) until age 14-16 when they will then appear ingame; retro databases use this feature to put future players ingame at the appropriate time

Any EHM-wiki guide in how to do this?

With the Duchene going down, any word in how to use the editor to give the Avs the proper picks?

Use the extra_config file to set up traded draft picks. Open it and scroll down and you'll see how it is done with the other picks

[nino33]

- What is the youngest date you can put into the game for a player? I want to create some wonderkids for the future drafts and don't want them to be in one draft.

You can have players who haven't even been born yet!
Players will be "hidden" ingame (you won't find them if you search) until age 14-16 when they will then appear ingame; retro databases use this feature to put future players ingame at the appropriate time

Any EHM-wiki guide in how to do this?

No specific wiki guide, just the information in the Data Editing Forum http://www.ehmtheblueline.com/forums/vi ... .php?f=110

EDIT - you create the "extra young players" the as if they were the youngest prospects visible ingame as startup (because the extra young players will not have their CA/Attributes change in any way until they're actually visible ingame); I think players usually show up ingame at about age 13-14.....so ideally "extra young" players at startup would have their CA/Attributes be representative of a player age 13-14

[SEPH]

Sorry for being needy, but I see that all the things I am trying to do are manageable except the schedule. I actually have no clue how to edit the schedule and when I go into the Editor Template it gives me a main NHL schedule and an alternate NHL schedule. I assume that one is for home games and one is for away correct? Do I have to manually edit the schedule to add in a 32nd NHL team? Or is there a way to automatically create the schedule? I am not really worried about the NHL, it's the AHL and ECHL which are giving me fear since I want each club to have their one affiliate.

[BKarchitect]

Sorry for being needy, but I see that all the things I am trying to do are manageable except the schedule. I actually have no clue how to edit the schedule and when I go into the Editor Template it gives me a main NHL schedule and an alternate NHL schedule. I assume that one is for home games and one is for away correct? Do I have to manually edit the schedule to add in a 32nd NHL team? Or is there a way to automatically create the schedule? I am not really worried about the NHL, it's the AHL and ECHL which are giving me fear since I want each club to have their one affiliate.

I've already got a solid 32-team NHL schedule (and alternate schedule) you can export from my Seattle database. If the AHL and ECHL are both 32 teams as well you can simply use the same schedule template for them.

[SEPH]

Sorry for being needy, but I see that all the things I am trying to do are manageable except the schedule. I actually have no clue how to edit the schedule and when I go into the Editor Template it gives me a main NHL schedule and an alternate NHL schedule. I assume that one is for home games and one is for away correct? Do I have to manually edit the schedule to add in a 32nd NHL team? Or is there a way to automatically create the schedule? I am not really worried about the NHL, it's the AHL and ECHL which are giving me fear since I want each club to have their one affiliate.

I've already got a solid 32-team NHL schedule (and alternate schedule) you can export from my Seattle database. If the AHL and ECHL are both 32 teams as well you can simply use the same schedule template for them.

Sweet! Do you have a link by the chance for it?

Would I have to edit any parts to make it compatibility with the AHL or ECHL?

[DarkSlimus]

Sweet! Do you have a link by the chance for it?

Would I have to edit any parts to make it compatibility with the AHL or ECHL?

if your AHL and ECHL have same structure than your NHL, you don't have to edit the schedule template.

if you wait two or three days you can be my first beta tester for my EHM Scheduler cause a 32 team structure work fine with it. I'm near to present my alpha version of EHM Scheduler and I need you

[BKarchitect]

SEPH,

Here are 82 game schedules (normal and Olympic year) for a 32-team NHL - which can also be used for the AHL/ECHL - you just have to make sure you are using the same number of conferences/divisions/teams per division. Since the ECHL and AHL aren't affected by the Olympics you only need the regular schedule for them.

From my testing this is a pretty sound schedule that sticks to NHL scheduling rules, just with one extra Central Division team in the Western Conference for an 8/8/8/8 alignment.

https://www.dropbox.com/s/2rjck6d2a603l ... e.csv?dl=0
https://www.dropbox.com/s/z6d1038ppioy1 ... 9.csv?dl=0

If anybody wants to use these besides SEPH, go for it! Just throw a bit of credit my way if you ever release anything for public use with them...the schedule was painstakingly done manually and took many, many hours of checking and re-checking

[DarkSlimus]

yeah, it's a better way to download cause actualy my scheduler is not op ... I'm working on the formula to have a realistic schedule and it's not an easy way ... Sure you must have past a lot of hours to do it manually, it's a hard job and you do it nice, the 36 team NHL schedule is fine too!
You must change your name ScheduleArchitect

[BKarchitect]

The 36 team one is not perfect yet. It relies on a regular pattern of a game, then day off, then game, then day off. It works but it's not realistic since sometimes you have back to back, sometimes you have 2-3 days off between games, etc. At some point I need to make it more "organic". The 32 team one was much easier in comparison and more realistic.

[SEPH]

Hey guys...for the new update, the schedule(s) work absolutely perfectly Foppa! I am using it for NHL, AHL, and ECHL. I could careless that it boosts up the ECHL games from 70 something to 82. It's darn awesome! FYI, for anybody interested I reworked the IIHF schedules from random weeks in April all to take place at the same time during the main division and nothing has broken thus far. With my international roster, it's really cool to see Lucic play for Serbia and Luongo for Italy.

I am having some concerns, issues though...

1) I redid some of the NHL affiliates and majority work except three teams have their ECHL club over the AHL club when you try to send a player down. Again majority of the players go to the AHL from what I've seen, but it's more of an aesthetic problem. I even deleted the affiliations and redid them, but to no avail. Any reason why this happens?

2) A lot of countries players randomly join the United States National Program. True I did edit and made some wonderkids for like 40 countries, but the team has random players from North Korea, Singapore, Indonesia that I did not touch at all. Any reason why this is? And anyone know how to solve it?

3) The pretty much last thing I need to work on is the World Cup of Hockey and adding 48 teams to the tournament. But the problem is the next world cup is in 2023 from the Beta Roster. Anyone know how to change it to at least show up in 2020? So every two years is a World Cup, Olympics, World Cup, Olympics, etc.?

4) Anybody know how I can change the Champion's Hockey League from 3 team groups back to 4?

5) Is it important to add staff via the editor to all my new teams? I see that the game does add the likes of GMs, HC, and scouts, but a lot of the teams do not have chairmans and presidents.