Sanitization .csv and access files?

SkySpy · 04-14-2007, 11:40 AM

Is there any way to include an option to sanitize the .csv and access files in the almanac options to not output player values that would normally be hidden from leagues using scouts (e.g. actual player ratings, rust, injury, etc.)

Those of us that use the .csv files in on-line leagues for some of the utilities available (HOF Monitor and Winshares is just one example) as well as for general use aren't able to generate them because it displays some values that should remain hidden.

Would an easy fix be just to have an option to keep the fields there but "zero out" all of the applicable data within the files?

Thanks.

robster1225 · 04-14-2007, 11:42 AM

I agree, this would be a huge asset to online leagues. Let me see if this has been logged.

robster1225 · 04-14-2007, 11:51 AM

dola,
logged as a feature request: TT 3408

Comedian2004 · 04-16-2007, 10:12 AM

If someone would let me know which CSV files and what fields NOT to display, I can write a quickie prorgam to remove those fields out of the csv dumps.

Sorry Mac users....

robster1225 · 04-16-2007, 05:33 PM

the downside to that, is that the commish would still have to run the dump. While it would be a nice workaround, having it in the game would be best.

SkySpy · 04-16-2007, 05:39 PM

Quote:

Originally Posted by robster1225

the downside to that, is that the commish would still have to run the dump. While it would be a nice workaround, having it in the game would be best.

Correct. I'm not saying I don't trust our (or any league's commish) but why not remove temptation and just have the option in game?

I'll take a look at the .csv files tonight and post which tables and fields should be sanitized.

SkySpy · 04-16-2007, 05:53 PM

Quote:

Originally Posted by Comedian2004

If someone would let me know which CSV files and what fields NOT to display, I can write a quickie prorgam to remove those fields out of the csv dumps.

Sorry Mac users....

One more thing to think about, the commish sets the almanac options for the league which then sets permissions for what will be generated when the league owners run their own almanac. That being said, the commish would set permissions to run the alamanac with the generation of .csv/access/SQL tables turned on allowing the other owners of the league to do the same. We would have to trust other owners to run the cleanser utility on their own which basically puts us back into the same boat we're currently in.

robster1225 · 04-16-2007, 06:00 PM

Quote:

Originally Posted by SkySpy

One more thing to think about, the commish sets the almanac options for the league which then sets permissions for what will be generated when the league owners run their own almanac. That being said, the commish would set permissions to run the alamanac with the generation of .csv/access/SQL tables turned on allowing the other owners of the league to do the same. We would have to trust other owners to run the cleanser utility on their own which basically puts us back into the same boat we're currently in.

That's a good point. I linked this thread in the TT, so hopefully it catches Markus' eye.

04-14-2007, 11:40 AM	#1
SkySpy Bat Boy Join Date: May 2006 Posts: 17	Sanitization .csv and access files? Is there any way to include an option to sanitize the .csv and access files in the almanac options to not output player values that would normally be hidden from leagues using scouts (e.g. actual player ratings, rust, injury, etc.) Those of us that use the .csv files in on-line leagues for some of the utilities available (HOF Monitor and Winshares is just one example) as well as for general use aren't able to generate them because it displays some values that should remain hidden. Would an easy fix be just to have an option to keep the fields there but "zero out" all of the applicable data within the files? Thanks.

04-14-2007, 11:42 AM	#2
robster1225 Hall Of Famer Join Date: Jun 2006 Posts: 2,617	I agree, this would be a huge asset to online leagues. Let me see if this has been logged.

04-14-2007, 11:51 AM	#3
robster1225 Hall Of Famer Join Date: Jun 2006 Posts: 2,617	dola, logged as a feature request: TT 3408

04-16-2007, 10:12 AM	#4
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	If someone would let me know which CSV files and what fields NOT to display, I can write a quickie prorgam to remove those fields out of the csv dumps. Sorry Mac users....

04-16-2007, 05:33 PM	#5
robster1225 Hall Of Famer Join Date: Jun 2006 Posts: 2,617	the downside to that, is that the commish would still have to run the dump. While it would be a nice workaround, having it in the game would be best.