How I got Brockleigh's CFL Roster into my game database...

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

How I got Brockleigh's CFL Roster into my game database...

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Current Games From Matrix.] >> [Sports] >> Maximum-Football 2.0 >> Public Beta Forum >> How I got Brockleigh's CFL Roster into my game database...

Page: [1]

Message

<< Older Topic Newer Topic >>

How I got Brockleigh's CFL Roster into my game database... - 12/8/2006 8:12:44 PM

brb321

Posts: 21
Joined: 11/19/2006
Status: offline

Hey everyone. I have been successful on taking Brockleigh's CFL Roster, which is in the unsorted files at FBMAX.com, and puting them into my own database. I used Access 2000 and Excel for this task. I would recommend saving a copy of your excisting database somewhere else before you try this.

- The first thing I did was reset the league I wanted to use. I then ran the draft and training camp. The game will fill the rosters with it's tempoary players.

- After that, go into your database, open the 'players' database and get the LeagueID #. Write this down. If you have run the draft and training camp, you can delete all the players in the database by 'select all records' in 'Edit', and then 'delete all records' in 'Edit'. The database saves automatically, so you can close. Next, go into the 'Teams' database. I would recommend printing this so you can have the team IDs if you need them.

- Next I opened Brockleigh's CLF database and opened it Access. I opened the 'Players' database, hit 'select all records' in ''edit', and then 'copy' in 'edit'. Now you can delete this database by using the same directions in step 2.

- Open up a new worksheet in Excel. Paste the database into Excel. Here you can make the appropriate changes, like LeagueID, and to match up your TeamID 3's with the TeamID of your players. It is easier in Excel because you can make changes to several entries at a time by using the copy and paste feature in Excel. When you are complete, 'copy' the entire database.

- Go back to your original database, open the'players' database, and 'paste' it in.

- Open MF, go to league Games, and open your League. Check to see if your changes to effect. Good luck.

Let me know if you need help. Thanks to Brockleigh for the CFL Roster

_____________________________

GO RIDERS!!!!!!

Post #: 1

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 7:23:45 AM

Brockleigh

Posts: 418
Joined: 10/25/2005
Status: offline

Excellent, brb321. Good to see that the Rosters are actually useful.

Quick question to the floor: I've ditched MSOffice for OpenOffice. I've read somewhere that I might not be able to do what brb321 has described above with OpenOffice because it's missing a key or something. Is this true? Is there another tool I can use outside of Access to utilize the database?

_____________________________

It's time to kick ass and chew bubblegum... and I'm all outta gum.

(in reply to brb321)

Post #: 2

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 8:35:59 AM

David Winter

Posts: 5158
Joined: 11/24/2004
From: Vancouver, BC
Status: offline

quote:

- The first thing I did was reset the league I wanted to use. I then ran the draft and training camp. The game will fill the rosters with it's tempoary players.

- After that, go into your database, open the 'players' database and get the LeagueID #. Write this down. If you have run the draft and training camp, you can delete all the players in the database by 'select all records' in 'Edit', and then 'delete all records' in 'Edit'. The database saves automatically, so you can close. Next, go into the 'Teams' database. I would recommend printing this so you can have the team IDs if you need them.

I really don't think this is a good idea.

The reason being is that the depth charts are not being updated. The computer assigns depth charts during training camp with the players it thinks are on the roster. The training camp also creates depth chart 'slots' (1st string, 2nd string, etc..) Even if it's a human controlled team, the computer will take a first crack at the depth charts so there is at least something there.

If you run a training camp, then import a bunch of different players the depth charts are no longer synced up. When you go into a quick sim game, it can't load the players the depth charts are telling it to load.

I believe something like this is what is causing the QuickSimGoKickoff crash reported in another thread.

I've looked at adding some additional code so that the computer will double check whether or not a player on the depth chart is actually in the roster, but that begins to slow down the works. If it gets too bad for speed, I'll have to remove that functionality.

If you can find a way to also import the depth charts, that would help.

< Message edited by David Winter -- 12/10/2006 9:42:51 AM >

(in reply to Brockleigh)

Post #: 3

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 3:10:06 PM

brb321

Posts: 21
Joined: 11/19/2006
Status: offline

quote:

If you can find a way to also import the depth charts, that would help.

That's a good idea. I will give it a try and see what happens...

_____________________________

GO RIDERS!!!!!!

(in reply to David Winter)

Post #: 4

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 3:59:27 PM

garysorrell

Posts: 2176
Joined: 1/29/2005
Status: offline

I also use these rosters, but all I did was drop the mdb file into the maxfb folder, create the Teams_CFL folder for the team folders and then had to change playbooks since I didnt download the ones the teams were already using.
It imported and works fine....Alouettes have already beaten the riders twice :-)

(in reply to brb321)

Post #: 5

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 4:07:31 PM

marcntx

Posts: 87
Joined: 8/11/2006
Status: offline

To get a roster file to work, don't you just need to upload the LGE database file and then the TEAMS folder that contain the graphics? I don't understand why the teams were exported, unless the goal is to add the teams to an existing league.

(in reply to brb321)

Post #: 6

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 4:09:35 PM

MjH

Posts: 165
Joined: 2/23/2006
Status: offline

quote:

ORIGINAL: Brockleigh
Quick question to the floor: I've ditched MSOffice for OpenOffice. I've read somewhere that I might not be able to do what brb321 has described above with OpenOffice because it's missing a key or something. Is this true? Is there another tool I can use outside of Access to utilize the database?

I didn't try the procedure you mentioned, but I was able to access and update the databases using OpenOffice. I put together the instructions for setting up OpenOffice to access MF databases, and they are in the unsorted directory on www.fbmax.com. The file is: MaximuFootballWithOpenOffice.zip.

(in reply to Brockleigh)

Post #: 7

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 5:04:21 PM

garysorrell

Posts: 2176
Joined: 1/29/2005
Status: offline

marcntx
Thats what I did, in this case, and all seems fine. Not sure what all this other stuff is about.

(in reply to MjH)

Post #: 8

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 6:17:23 PM

Deltadog

Posts: 389
Joined: 2/27/2006
Status: offline

In this case, you could just use Brockleigh's leage, but this procedure is valuable if you have the players in another database or perhaps on a spreadsheet and not in the league database. (that is if we can come up with a way to import the depth charts also) Maybe when the auto depth chart build option comes back, this will not be an issue.

(in reply to marcntx)

Post #: 9

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 7:29:06 PM

brb321

Posts: 21
Joined: 11/19/2006
Status: offline

I guess the best reason I did all this work was to get the actual CFL players, which I did not have. There appears to be other methods that work okay, but I was able to fix my depth chart problem until the new patch comes out...

_____________________________

GO RIDERS!!!!!!

(in reply to Deltadog)

Post #: 10

RE: How I got Brockleigh's CFL Roster into my game data... - 12/10/2006 10:34:48 PM

Brockleigh

Posts: 418
Joined: 10/25/2005
Status: offline

I've tried the MaximumFootballWithOpenOffice document, and I run into problems right off the hop:

The ODBC Data Sources Administrator isn't listing any data sources to select.

For me, I'd have to alter the League ID number in the importing file as I'm cureently running two CFL Leagues, one that I'll be keeping completely user controlled so I can update the league Rosters as the real teams do in real life, and the second one that will be my "career" league that I'll be doing most of the fooling around with.

_____________________________

It's time to kick ass and chew bubblegum... and I'm all outta gum.

(in reply to brb321)

Post #: 11

Page: [1]

All Forums >> [Current Games From Matrix.] >> [Sports] >> Maximum-Football 2.0 >> Public Beta Forum >> How I got Brockleigh's CFL Roster into my game database...

Page: [1]