Career Statistics - Keeping Them With Upgrading to 2.27

[mbsports]

Good Evening,

So MBCFL is nearing the end of Season 2 and we have some things like expansion and new players and a draft to do so there's a lot going on and one of the things I'm working with is how to keep the career stats and link them into the new 2.27 so that we don't lose any history.

Here's what I'm doing and please if you have a better way - I'd love to hear it as it would probably save me a load of time. I use Access, I know others will have different solutions so again - if you have a better one, please chip in.

Step 1 - Copy the Stats_League Table in the lge_name database
Step 2 - Change all colons and slashes in the StatValues column to commas
Step 3 - Output without headers to a comman delimited text file
Step 4 - Import into a new Access DB and rename the headers as is possible
Step 5 - By Linking to the lge_name DB pull out any player/team information as desired and create new tables for each of the stat categories

That gets me to a point where I have each of the stat categories as a table with a linking id - either Team ID or Player ID that I should be able to use along with version 2.27 to append in those statistics and subtotal in order to get career stats.

It's a little bit of a pain in the behind and I have a feeling I could right up some sql/php to do it automagically but this will work and will allow you to keep those stats for posterities sake.

-Mb

www.mbsportsnet.com/mbfl/mbfl.htm