StreamData - COLL

Modifying Madden 08.
User avatar
elguapo
Hall of Fame
Posts: 2524
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

StreamData - COLL

Postby elguapo » Mon Sep 03, 2018 11:31 pm

The college list has been updated to Madden 19's list. Credit goes to the Madden 19 modding members.

Import the CSV file to the StreamData.db file in the COLL table. Included is the xlsx spreadsheet.

DOWNLOAD

StreamData - COLL

Sponsor

Sponsor
 

User avatar
RevanFan
Legend
Posts: 11362
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: StreamData - COLL

Postby RevanFan » Sat Sep 08, 2018 12:59 am

elguapo wrote:The college list has been updated to Madden 19's list. Credit goes to the Madden 19 modding members.

Import the CSV file to the StreamData.db file in the COLL table.

https://www.mediafire.com/file/pesl0d7913i9bep/StreamData+-+COLL.7z

(Rogerjinx, the Madden 19 conversion file I sent you displays the player's college correctly.)

Are any of the original IDs changed, or are they all the same?
My Historic Cowboys Teams - http://footballidiot.com/forum/viewtopic.php?f=12&t=240
My Cowboys Journal - http://footballidiot.com/forum/viewtopic.php?f=2&t=3610
I'm a die hard Cowboys fan and a New Yorker born and raised.

User avatar
rogerjinx
Hall of Fame
Posts: 2150
Joined: Sat Feb 11, 2012 12:51 am
Location: Philippines
Contact:

Re: StreamData - COLL

Postby rogerjinx » Sat Sep 08, 2018 1:12 am

elguapo wrote:The college list has been updated to Madden 19's list. Credit goes to the Madden 19 modding members.

Import the CSV file to the StreamData.db file in the COLL table.

https://www.mediafire.com/file/pesl0d7913i9bep/StreamData+-+COLL.7z

(Rogerjinx, the Madden 19 conversion file I sent you displays the player's college correctly.)



Thanks. Will apply this on the next roster release.

User avatar
elguapo
Hall of Fame
Posts: 2524
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: StreamData - COLL

Postby elguapo » Sat Sep 08, 2018 11:51 pm

Awesome Roger.

Yes RevanFan, as far as I tested it there are the same. I randomly tested players that I knew and they were correct.

User avatar
RevanFan
Legend
Posts: 11362
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: StreamData - COLL

Postby RevanFan » Sat Sep 08, 2018 11:57 pm

elguapo wrote:Awesome Roger.

Yes RevanFan, as far as I tested it there are the same. I randomly tested players that I knew and they were correct.

And all the colleges are accessible via the in-game player editor?
My Historic Cowboys Teams - http://footballidiot.com/forum/viewtopic.php?f=12&t=240
My Cowboys Journal - http://footballidiot.com/forum/viewtopic.php?f=2&t=3610
I'm a die hard Cowboys fan and a New Yorker born and raised.

User avatar
rogerjinx
Hall of Fame
Posts: 2150
Joined: Sat Feb 11, 2012 12:51 am
Location: Philippines
Contact:

Re: StreamData - COLL

Postby rogerjinx » Sun Sep 09, 2018 12:25 am

RevanFan wrote:
elguapo wrote:Awesome Roger.

Yes RevanFan, as far as I tested it there are the same. I randomly tested players that I knew and they were correct.

And all the colleges are accessible via the in-game player editor?


That I will check later especially with that player with college id # -1 or higher than those available in Madden 08 if they will be recognized by Amp or NZA

User avatar
elguapo
Hall of Fame
Posts: 2524
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: StreamData - COLL

Postby elguapo » Sun Sep 09, 2018 12:51 am

RevanFan wrote:
elguapo wrote:Awesome Roger.

Yes RevanFan, as far as I tested it there are the same. I randomly tested players that I knew and they were correct.

And all the colleges are accessible via the in-game player editor?


That is a good question. I did not test the in game editor but since the colleges did appear in the player's team management I'm assuming it does appear in the in game editor.

User avatar
elguapo
Hall of Fame
Posts: 2524
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: StreamData - COLL

Postby elguapo » Sat Mar 02, 2019 12:10 pm

I noticed a misspelling of one of the fields. The field "ENUM" should be "ENUN" with an N instead of M.

The row that contains "N/A" with a value of "-1" should be an number between 0-255 and not a negative number.

Roster editors like NZA will not be able to edit the new college settings and might give off errors if you try to load rosters with the college values.

Madden Amp has an updated college list if you need to edit college values.

User avatar
elguapo
Hall of Fame
Posts: 2524
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: StreamData - COLL

Postby elguapo » Sat Jul 13, 2019 4:59 pm

RevanFan pointed out that the list doesn't match with the old college list. I updated it to match the madden 08 college list and any new colleges would be put at the bottom the list.

I included the xlsx spreadsheet if you need to make changes.

The roster monster will need to be updated with this list but changes can always be done within madden or a db editor.


Return to “Modding”

Who is online

Users browsing this forum: No registered users and 8 guests