Importing Teams

[Brockleigh]

Is it at all possible to import a team from one league to another?

I want to make two CFL leagues. One with the nine teams that the league has on it's website, the other with about three expansion teams. Now with nine, forty-man teams, that's 360 players that I have entered manually, and I'd hate to do this all over again. So I've exported the teams that I've already enetered and created an 'expansion league' that I was going to import them to. When I tried to import the teams from the old league to the new league, I got an error saying the teams were not for the selected league.

Ummm, help?

[fredirat]

Use the Remote Out facility in the Main Menu & Standings screen (bottom right)
This exports all the teams in the league in csv files (files are exported to the MF folder 'export')
To import them into your new league, use the Remote In button on the same screen.

You need to edit the files before import as they each contain a league id. Replace that with the id of your new league before importing.

At least, thats how I think its supposed to work - haven't actually tried it myself[:)]
Good luck

[DONMVP]

or just play out your 9 team league , before next season add the expansion teams.

[Brockleigh]

fredirat: I'd done everything you had mentioned there except for the changing the league ID. Dave or Mauraders, how would one do that?
 
DONMVP: I want to keep both leagues, mainly to play seasons with the Expansion League, and play quick games with the Standard League.

[fredirat]

If you've got Access you can get the ID of your new league from the Leagues table in your new league DB.

Then replace the line LeagueID:182806 (or whatever your old league ID is) in the CSV file
with LeagueID:xxxxxx (where xxxxxx is the ID of your new league)

[David Winter]

There is no official way to do this. I'm not sure you could fool the game into importing a team from another league by editing the contents of that file.. it might work.. but you would need to create the team in that league first.
 
You can only use the remote in functions on a team that already exists in your league. If the team doesn't exist, you can't use remote in.
 
So, you'd have to create the team in the second league, find out what the team ID is, and edit the remote out generated file to match that team.
 
The catch there is that there is no way for you to know the teamID in the database through any tools or game screens I provide. It's not really something the user should need to know, so I never display it anywhere. So unless you have Access or Excel, it's unlikely this will work.
 
Once I get the bug reports under control and I have some time, I'll see about adding something to do this to the utilities.
 

[Brockleigh]

OKay, so even though it's not official and only theoretical...

I've opened the database and found that my CFL original league ID is 120484, and all my exported teams are 120484.

So all I'd have to do is in the Excel file is change the one value to whatever the new league ID number is?

I'll give it a go. If I have a catastrophic meltdown, I'll post it here and tell everyone and their brother not to do it.

[Brockleigh]

Okay, so here's how it went...

I experimented using the Toronto Argonauts (because if the Boatmen get ruined, that's not an altogether bad thing). In order for a new league to recognise the exported .csv file, you apparently have to change both the League ID and the Season number in the Excel file to match the new League.

So I did this, and the game told me that the Import was successful... however, when I hit "View Team" from the League Menu, the roster was totally blank. No players in any position.

I closed the game and re-opened the .csv file, and the information is all there. The Roster in the spreadsheet is correct.

I also tried importing the Tiger-Cats roster I had "Remote Out"ed from my standard CFL League into my existing CFL League (no messing around with the spreadsheet required), and when I opened the team, only Jason Maas was on the roster. All other positions were blank.

So, Dave, is this a bug, or is there something I have to do to prep the game before importing a team in?

[Marauders]

Well, it isn't really a bug, because it is a non-supported feature.
 
It would be nice, and David has stated he may look at it as a future feature.
 

[Brockleigh]

Okay... I walked into that one...

Then how about the Ti-Cats thing... With that one, I had entered all the CFL rosters into the original league. Then I was playing around with the Tiger-Cats roster within the game itself, and buggered everything up. I remembered that I exported the teams out, and so I went to import them back in, and when I did that (the remote file was loaded successfully without issue), only Jason Maas was on the roster. 39 other players seem lost in cyber-space.

[David Winter]

Well. I'm not sure what you mean by 'buggered everything up'. Maybe in the processing of editing the 'remote out' file something was done incorrectly. I'm not sure.

If the problem is that you exported a team, then simply tried to import it back in (with out editing the file) and something went wrong, then that's something I can look at. You'll need to zip up your league mdb file, and the exported team file, and email them to support@wintervalley.com I'll step through the code and see what's going on.

But if it's a case of editing files that were never intended to be edited, forcing them back into the game, and the game not working, I'm afraid I'll have to say that's not a bug because you're trying to make the game do something it was never meant to do.