PING: Commishes who use my site stuff.

[Ben E Lou]

Does anyone have the written instructions for manipulating the fofroster.csv file to update ratings? I need to provide those to someone, and can't put my hands on them.

[Yoda]

updating Player's Ratings

Run FOF Extractor on the entire league including Free Agents

Open FOFRoster.CSV upon the extractor's completion

Insert a blank Column to be "A"

Give everyone a unique numerical ID to populate the new Col. A, starting at 1 (should be something like 1 through roughly 2700)

Delete the following columns from the table:

Positions to Popularity
Solecismic to Impress
Conflicts to Affinities

We need to get rid of the Nicknames:

Highlight Col. B
Press
in Find what: {enter}'*' (This is four characters...1. single quote...2. asterisk....3. single quote...4. space)
replace with: {leave blank}

We need to fix nams with spaces in them.

Insert 3 columns after the player's names - Col B&C

Select Data from the Excel toolbar

Text to columns
select: delimited
{next}
check {space}
uncheck {tab}
check for data in col D and E

Now manually check for information that has filled columns D or E and you'll see those player's with dbl names, IE. Bear Claw Jones or Billy Joe David or Foster Van Pelt.

Now manually fix those names to be included in the column they should be so that Col D & E are empty when you're through. Column B should contain first names. Column C last names.

delete columns D&E since they're now empty

delete row 1 - (all of the headers)

save as and click yes to warnings


----------------------------------------

Go to PHPmyadmin

select {playerratings} table

structure view

{click} empty on the toolbar at the top to clear out the table

Near the bottom:

select Insert data from a text file into the table

Change: "Fields terminated by" to a {comma}

click: {submit}

Exit phpmyadmin and browse to updateroster.php at the end to complete the process.