Suggestions: Tools and Functions

[Tony M]

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]

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]

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]

Processed.

[endgame]

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]

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]

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]

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]

Processed To Here.

[enuttage]

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]

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]

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]

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]

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]

Processed

[ootpFox07]

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]

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]

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]

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]

All suggestions in this thread have been collected.