Suggestions: Tools and Functions - Page 2

Tony M · 07-26-2007, 06:39 PM

Quote:

Originally Posted by battists

Suggestion
Create a special SQL export of scouting reports of players from each team. That is, each team's scout's reports on each player.

If this could be done, a utility could be written by someone in the community to allow online league owners to log into an application and see their scouting reports.

I can currently decode the scouting.dat file down to each scout and player but haven't managed to work out what each of the fields refer to - I thought I had got someway with batting, but then couldn't get pitching to fit in with the same format.

Tony M · 08-01-2007, 10:54 AM

Suggestion

Make the database structure available to people who want to use it to make mods.

Reason

It would make life easier

Priority

Personally, high. Likelihood, lower than the Dead Sea

Raidergoo · 08-11-2007, 04:10 PM

Suggestion

Use PGP encryption on team emails. Each team would have a different key, and the emails generated would be encrypted, and then locally decrypted by the game.

Reason

No more online league espionage reading other rival team's email.

Priority

LOW

Raidergoo · 08-11-2007, 04:11 PM

Processed.

endgame · 08-12-2007, 09:53 PM

Suggestion

Allow the almanac to be created in user-defined path as its final destination.

Reason

As much as I advocated including an almanac, in its present form there is no economy. It's created in a game directory, then moved to the almanac location, then many move it again to an external drive to save space, then finally the original is deleted from its /almanac directory. Even roughly with a large league, that's an hour per step with duplications of intent.

Priority

Medium-High

Tony M · 08-13-2007, 06:13 AM

Suggestion

Wherever possible in stats that are split in the database for batting purposes add a split for side of plate.

Reason

You can see for any batter what they're like against L or R handed pitchers, but you can't see the following splits (or if you can, I've never found it)

vs LHP Batting L
vs LHP Batting R
vs RHP Batting L
vs RHP Batting R

Priority

Medium

DerekT · 08-13-2007, 08:47 PM

Suggestion

Keep career vs team stats for the lifetime of the player instead of one season

Reason

It would be nice in playoffs for how well a pitcher/batter has done vs the opposing team, and for HOFers it would be notable to see which team the player did best/worse against.

Priority

Medium

Millsy · 08-15-2007, 09:52 PM

Suggestion

Allow for Sortable Player Statistics by League.

Reason

You would think that something so simple would already be an option. I can currently filter player statistics by over 70 different categories (including Nick Name!) but not by league. League Level, yes....League, no. ???

Priority

High

Raidergoo · 08-16-2007, 02:01 PM

Processed To Here.

enuttage · 08-23-2007, 12:35 PM

Suggestion
Allow access to data path options even after having re-routed the data path.

Reason
You can't re-route the path without copying all the data over to the new path. If you make a mistake, you're in some trouble. Right now (AFAIK), there's no way to 'go back' if you do this.

Priority
Medium

Raidergoo · 08-30-2007, 02:12 PM

Suggestion
Develop a Draft pool editor export and reimport function to facilitate mass draft pool editing. The export would dump a csv that a league commish could edit to suit, then reimport the csv when done, allowing modifying the draft pool outside OOTP.

Reason
My online league uses a customized draft pool with more than a hundred players added to the pool manually. Excel is a great, fast tool to edit lots of data vs using the game to edit each player one by one. You could make quick comparisons on multiple categories and swiftly edit players when you see an issue.

Priority
medium

battists · 09-16-2007, 11:54 AM

Suggestion
Improved backup feature

Reason
When a league is being saved, it overwrites all the .dat files. We should rename/move the old files into backup folders before saving the new .dat files. This doesn't "cost" much time, just less than a second. We should also write the name of the league into a file when the league is being loaded and delete that file when the league has been closed and completely saved. So, when you start OOTP and the file still exists the game knows that it has crashed last time. In that case OOTP should open the new troubleshooting dialog and ask whether the last backup (or any previous backup) should be restored.

Of course there will be some inconsistances in the .txt files in that case, which the game should try to fix by deleting the records that have a timestamp greater than the last league date.

Priority
medium

Tony M · 09-16-2007, 12:58 PM

Quote:

Originally Posted by Raidergoo

Suggestion
Develop a Draft pool editor export and reimport function to facilitate mass draft pool editing. The export would dump a csv that a league commish could edit to suit, then reimport the csv when done, allowing modifying the draft pool outside OOTP.

Reason
My online league uses a customized draft pool with more than a hundred players added to the pool manually. Excel is a great, fast tool to edit lots of data vs using the game to edit each player one by one. You could make quick comparisons on multiple categories and swiftly edit players when you see an issue.

Priority
medium

I may be wrong, but when the draft pool is announced, you can see the draft eligible players in the players.csv, and therefore they can be edited and re-imported into the program - I wrote a small app that does a lot of csv re-importing. I know it's not part of the game per se.

Raidergoo · 09-16-2007, 08:38 PM

Quote:

Originally Posted by redsoxford

I may be wrong, but when the draft pool is announced, you can see the draft eligible players in the players.csv, and therefore they can be edited and re-imported into the program - I wrote a small app that does a lot of csv re-importing. I know it's not part of the game per se.

Doesn't help if you are in an online league with no access to the file.

Raidergoo · 09-24-2007, 01:37 PM

Processed

DesertFox07 · 09-25-2007, 10:10 AM

Suggestion: Not sure if this counts as a "tool" but I don't see a specific player customization thread.

Add a screen to batch edit basic player attributes on a per team basis. These attributes include name (manual edit or Generate name button), ethnicity, nationality, position, number, bats, throws and popularity.

Reason: On my international league of foreign teams, I limit teams to only have players from their particular country so I need to edit any drafted players outside that country. It's just time consuming to change the ethnicity and nationality of all the players on that team and generate new names and photos. Being able to do them all on one screen or even have a button to set all of a teams players to the same nationality/ethnicity would be a HUGE help in maintaining what I've found to be a fun addition to my fictional universe.

Priority: Medium-High

BMW · 09-26-2007, 12:27 PM

Suggestion:
Can a feature be added that would simply chop up MySQL files to a certain amount of bytes as they come out of OOTP?

Reason:
Many users with purchased web hosting may not have the ability to customize file-size limits for MySQL or memory limits for PHP. Once the files reach this threshold, you have all this great data, but no easy way to import it. For a very detailed league, players_at_bat_batting_stats.mysql.sql can balloon to 100MB by the end of a season.

Go here for a more expanded explanation.

Priority: Medium-Low

Tony M · 09-26-2007, 03:54 PM

Suggestion

Storing game pitch details in the database so that game logs can be rebuilt on demand rather than in html files.

Reason

A standard MLB setup will generate 330+ Mb of game log/box score files. I tend to turn this option off, but sometimes would like to look at them. Storing it in the database would enable that. I am working on the structure and at the moment it looks like it would take up no more than 100 Mb for a season.

Priority

High

murmur13 · 09-28-2007, 09:42 PM

Suggestion

Ability to import statistics for a "new" season (for example, via a Lahman-like import) and re-calculate player ratings considering the new stats and aging. Could also move players to new teams based on the team ID in the Lahman-like DB.

Reason

This could REALLY make roster making easier for future seasons. Instead of having to make a new file every year, one can easily build on a past roster file, with changes automatically made using this tool.

For example, someone can take a 2006 MLB league, and at the end of the 2007 season, import the 2007 stats from the Lahman DB. It would

a) Update player ratings for current playeres, based on the new stats and aging

b) Make player ratings for rookies.

c) Move players to new teams based on the last team in the 2007 DB.

And possibly other stuff....

Priority

Medium. I would say hi...but I think this might be tough to do.

Raidergoo · 09-28-2007, 10:40 PM

All suggestions in this thread have been collected.

08-01-2007, 10:54 AM	#22 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,303	Suggestion Make the database structure available to people who want to use it to make mods. Reason It would make life easier Priority Personally, high. Likelihood, lower than the Dead Sea __________________ Tony M Technical Support Moderator

08-11-2007, 04:10 PM	#23 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 7,282	Suggestion Use PGP encryption on team emails. Each team would have a different key, and the emails generated would be encrypted, and then locally decrypted by the game. Reason No more online league espionage reading other rival team's email. Priority LOW __________________

08-11-2007, 04:11 PM	#24 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 7,282	Processed. __________________

08-12-2007, 09:53 PM	#25 (permalink)
endgame Hall Of Famer Join Date: Aug 2002 Posts: 6,392	Suggestion Allow the almanac to be created in user-defined path as its final destination. Reason As much as I advocated including an almanac, in its present form there is no economy. It's created in a game directory, then moved to the almanac location, then many move it again to an external drive to save space, then finally the original is deleted from its /almanac directory. Even roughly with a large league, that's an hour per step with duplications of intent. Priority Medium-High __________________ "Try again. Fail again. Fail better." -- Samuel Beckett We live in the shadowlands. The sun is always shining somewhere else. __________________

08-13-2007, 06:13 AM	#26 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,303	Suggestion Wherever possible in stats that are split in the database for batting purposes add a split for side of plate. Reason You can see for any batter what they're like against L or R handed pitchers, but you can't see the following splits (or if you can, I've never found it) vs LHP Batting L vs LHP Batting R vs RHP Batting L vs RHP Batting R Priority Medium __________________ Tony M Technical Support Moderator

08-13-2007, 08:47 PM	#27 (permalink)
DerekT Minors (Triple A) Join Date: Apr 2004 Posts: 222	Suggestion Keep career vs team stats for the lifetime of the player instead of one season Reason It would be nice in playoffs for how well a pitcher/batter has done vs the opposing team, and for HOFers it would be notable to see which team the player did best/worse against. Priority Medium

08-15-2007, 09:52 PM	#28 (permalink)
Millsy Minors (Rookie Ball) Join Date: Dec 2002 Location: Red Sox Nation Posts: 40	Suggestion Allow for Sortable Player Statistics by League. Reason You would think that something so simple would already be an option. I can currently filter player statistics by over 70 different categories (including Nick Name!) but not by league. League Level, yes....League, no. ??? Priority High __________________ Commissioner: GUBA Owner: Jackson Gators Commissioner: MBWBA Owner: Cape Cod Hooks

08-16-2007, 02:01 PM	#29 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 7,282	Processed To Here. __________________

08-23-2007, 12:35 PM	#30 (permalink)
enuttage Hall Of Famer Join Date: Mar 2002 Location: Balcones Fault Line Posts: 2,251	Suggestion Allow access to data path options even after having re-routed the data path. Reason You can't re-route the path without copying all the data over to the new path. If you make a mistake, you're in some trouble. Right now (AFAIK), there's no way to 'go back' if you do this. Priority Medium __________________ WHBL - Managua Four Roses "When the going gets weird, the weird turn pro."

08-30-2007, 02:12 PM	#31 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 7,282	Suggestion Develop a Draft pool editor export and reimport function to facilitate mass draft pool editing. The export would dump a csv that a league commish could edit to suit, then reimport the csv when done, allowing modifying the draft pool outside OOTP. Reason My online league uses a customized draft pool with more than a hundred players added to the pool manually. Excel is a great, fast tool to edit lots of data vs using the game to edit each player one by one. You could make quick comparisons on multiple categories and swiftly edit players when you see an issue. Priority medium __________________

09-16-2007, 11:54 AM	#32 (permalink)
battists Administrator Join Date: Jul 2004 Posts: 14,219	Suggestion Improved backup feature Reason When a league is being saved, it overwrites all the .dat files. We should rename/move the old files into backup folders before saving the new .dat files. This doesn't "cost" much time, just less than a second. We should also write the name of the league into a file when the league is being loaded and delete that file when the league has been closed and completely saved. So, when you start OOTP and the file still exists the game knows that it has crashed last time. In that case OOTP should open the new troubleshooting dialog and ask whether the last backup (or any previous backup) should be restored. Of course there will be some inconsistances in the .txt files in that case, which the game should try to fix by deleting the records that have a timestamp greater than the last league date. Priority medium

09-24-2007, 01:37 PM	#35 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 7,282	Processed __________________

09-25-2007, 10:10 AM	#36 (permalink)
DesertFox07 Minors (Double A) Join Date: Dec 2005 Posts: 186	Suggestion: Not sure if this counts as a "tool" but I don't see a specific player customization thread. Add a screen to batch edit basic player attributes on a per team basis. These attributes include name (manual edit or Generate name button), ethnicity, nationality, position, number, bats, throws and popularity. Reason: On my international league of foreign teams, I limit teams to only have players from their particular country so I need to edit any drafted players outside that country. It's just time consuming to change the ethnicity and nationality of all the players on that team and generate new names and photos. Being able to do them all on one screen or even have a button to set all of a teams players to the same nationality/ethnicity would be a HUGE help in maintaining what I've found to be a fun addition to my fictional universe. Priority: Medium-High

09-26-2007, 12:27 PM	#37 (permalink)
BMW Minors (Triple A) Join Date: May 2003 Location: New Jersey Posts: 255	Improved support for very large MySQL files Suggestion: Can a feature be added that would simply chop up MySQL files to a certain amount of bytes as they come out of OOTP? Reason: Many users with purchased web hosting may not have the ability to customize file-size limits for MySQL or memory limits for PHP. Once the files reach this threshold, you have all this great data, but no easy way to import it. For a very detailed league, players_at_bat_batting_stats.mysql.sql can balloon to 100MB by the end of a season. Go here for a more expanded explanation. Priority: Medium-Low

09-26-2007, 03:54 PM	#38 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,303	Suggestion Storing game pitch details in the database so that game logs can be rebuilt on demand rather than in html files. Reason A standard MLB setup will generate 330+ Mb of game log/box score files. I tend to turn this option off, but sometimes would like to look at them. Storing it in the database would enable that. I am working on the structure and at the moment it looks like it would take up no more than 100 Mb for a season. Priority High __________________ Tony M Technical Support Moderator

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

09-28-2007, 09:42 PM	#39 (permalink)
murmur13 Minors (Single A) Join Date: Jun 2006 Posts: 52	Suggestion Ability to import statistics for a "new" season (for example, via a Lahman-like import) and re-calculate player ratings considering the new stats and aging. Could also move players to new teams based on the team ID in the Lahman-like DB. Reason This could REALLY make roster making easier for future seasons. Instead of having to make a new file every year, one can easily build on a past roster file, with changes automatically made using this tool. For example, someone can take a 2006 MLB league, and at the end of the 2007 season, import the 2007 stats from the Lahman DB. It would a) Update player ratings for current playeres, based on the new stats and aging b) Make player ratings for rookies. c) Move players to new teams based on the last team in the 2007 DB. And possibly other stuff.... Priority Medium. I would say hi...but I think this might be tough to do.

09-28-2007, 10:40 PM	#40 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 7,282	All suggestions in this thread have been collected. __________________ Last edited by Raidergoo : 10-08-2007 at 11:32 AM.