Plain text output!

JustinM · 05-12-2010, 07:05 PM

This would be a great help for dynasty writers. Plain text output of box scores, stats, rosters, standings, etc. would be fantastic. Basically, if you can output something in .csv or .html, it should be possible to output that in plain, fixed-width text, for purposes of copying and pasting into the forum.

EDIT: If this is small enough that it could fit in a patch, let me know and I'll put it in the proper place.

Ambermonk · 05-12-2010, 08:04 PM

Quote:

Originally Posted by JustinM

This would be a great help for dynasty writers. Plain text output of box scores, stats, rosters, standings, etc. would be fantastic. Basically, if you can output something in .csv or .html, it should be possible to output that in plain, fixed-width text, for purposes of copying and pasting into the forum.

EDIT: If this is small enough that it could fit in a patch, let me know and I'll put it in the proper place.

Do you mean something like this text that I pasted into a word document?

SmoothGentleman · 05-12-2010, 08:29 PM

Is that from a dynasty? I'd love to follow it, great graphics

.

Ambermonk · 05-12-2010, 09:08 PM

Quote:

Originally Posted by SmoothGentleman

Is that from a dynasty? I'd love to follow it, great graphics

.

Sorry, I haven't looked into dynasties yet, so I don't really understand them. I have playing my current league for 6 seasons now, and have compiled a huge number of Excel spreadsheets and Word documents. Unfortunately, I don't believe that there is any way to upload these kinds of files to a format like the Dynasty forum. If there had been, I would have uploaded them long ago.

The picture above is a screen capture of part of one page of a Word doc. I have a large binder filled with paper copies of all the documentation that I have developed. For example, each game-month I create a spreadsheet of how my Single-A team is doing. This way I can evaluate how my new players are progressing.

But since you are interested, here is another screenshot of a Word doc that I created recently...

SmoothGentleman · 05-12-2010, 10:47 PM

You took time to make the jersey graphics as well? Pretty awesome.

You sound like a gm or scout lol.

edm · 05-12-2010, 11:05 PM

I agree Justin. especially for boxscores. right now to get a viewable boxscore online we need to output the html, upload the file along with the css. etc...

Would love the ability to generate a simple txt file like we did in games like earl weaver and high heat had.

JustinM · 05-12-2010, 11:23 PM

This is what I'm talking about. He had to type that manually. I shamelessly copied it for my own (while thanking him for the work, of course), but the game should really, really do that on its own already.

joe_44850 · 05-21-2010, 07:37 PM

Oh man. That's not right. I'm going to make a fix for this in my utilities program, I'll let you guys know when it's ready.

JustinM · 05-22-2010, 02:10 PM

Hadn't considered an external utility for it, but that sounds good to me. Please do keep us updated!

darkcloud4579 · 05-22-2010, 08:10 PM

I agree this that this would be great. For years, especially in my earlier OOTP days I wanted to be able to just print stuff to text so I could ride on the subway and read stats of my teams and such alike. I think it's well needed and should be easy to implement.

joe_44850 · 05-22-2010, 08:53 PM

So, I read your guys' post yesterday, and decided this might be a nice addition to the OOTP-Utils program. So far, I have it so that there are two versions: a plain text version, and a stripped-down HTML version (of box scores). Basically, you go into the program, choose a range of dates to export, and it creates a folder named after those ranges and saves all of the resulting text and plain html. I'm having some problems with formatting widths, however, so it's taking a bit longer than anticipated. Here is a what the resulting html looks like:

The text version is a little dicier, I'm having a lot of issues with name widths, text-wrapping, and columns bleeding over.

joe_44850 · 05-22-2010, 09:26 PM

You'll see here that when you have long names or extra positions, some of the text is no longer in it's column. And the totals line is weird. I'm at the mercy of the html code that OOTP creates (it does not store player-performance box scores, only winning & losing pitchers, so I have to parse it, cut it up, extract CSS info, insert column widths and replace table data with tabs and spaces)

Code:

    Seattle	AB	R	H	RBI	BB	K	LOB	AVG	HR	RBI
U. Martin LF	5	1	2	1	0	0	0	.469	0	3
D. Grieve RF	5	0	1	0	0	0	4	.333	0	3
C. Leiby CF	4	1	3	2	1	1	0	.321	0	5
L. Gargano SS, 2B	5	0	1	0	0	0	2	.107	0	2
H. Ault 1B	3	0	0	0	1	1	4	.182	0	0
a-G. Hollinshed PR, 1B	0	0	0	0	0	0	0	.167	0	1
E. Morgan 3B	4	0	1	1	0	0	4	.500	0	5
E. Bingham 2B	3	0	0	0	0	0	1	.000	0	0
b-F. Brooks PH	1	0	1	0	0	0	0	.571	0	3
c-S. Edington SS	0	0	0	0	0	0	0	.667	0	1
T. Linzey C	4	1	1	0	0	1	2	.261	0	4
D. Barnes P	3	1	1	0	0	1	0	.111	0	0
Totals	37	4	11	4	2	4	17

JustinM · 05-23-2010, 12:10 PM

Hey, looks like you're well on the way to something eminently useful. I do worry that the last 5% will be the hardest. It always seems to be that way.

joe_44850 · 05-24-2010, 08:39 PM

Ok, I think I got it. Here is what a typical game looks like (this is copied directly from the outputted text file the program creates for each game). Does this work? Any input? If not, I'm going to put this into OOTP-Utils and start a thread for it. I'll also be adding league leaders and standings text-output as well, but this seemed like a good place to start.

Code:

			 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | R  H  E 
Boston          	 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1  5  0 
Manhattan       	 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 4  8  0 


Boston         		AB  R  H  2B 3B HR RBI BB  K  SB CS SAC 
L.Lane-cf      		 4  0  0   0  0  0  0   0  0  0  0    
H.Punt-lf      		 3  0  2   0  1  0  0   1  0  0  0    
J.Ellingson-rf 		 4  0  1   0  0  0  0   0  0  0  0    
C.Thibeault-1b 		 4  0  0   0  0  0  0   0  1  0  0    
B.Cutlip-2b    		 3  1  1   1  0  0  0   1  1  0  0    
F.Combs-ss     		 3  0  0   0  0  0  0   0  0  0  1    
E.Baron-3b     		 3  0  1   0  0  0  1   0  1  0  0    
V.Hotchkiss-c  		 3  0  0   0  0  0  0   0  1  0  0    
O.Woods-p      		 2  0  0   0  0  0  0   0  0  0  0    
N.Knoll-ph     		 1  0  0   0  0  0  0   0  0  0  0    
----------------------------------------------------------------- 
Totals: 		30  1  5   1  1  0  1   2  4  0  0  0

Boston        		   IP   H   R  ER  BB  K  HR   PI   GB   FB 
C.Atkins        	    1   1   0   0   1  0   0   18    2    1
O.Woods L       	    7   7   4   4   2  7   0  127   10    4

BATTING
 Doubles:  B. Cutlip  (22, 2nd Inning off J. Rogers, 0 on, 0 outs)  
Triples:  H. Punt  (2, 1st Inning off J. Rogers, 0 on, 1 out)  
Total Bases:  B. Cutlip  2 ,  J. Ellingson ,  H. Punt  4 ,  E. Baron 
Runners left in scoring position, 2 outs:  O. Woods  ,  C. Thibeault  ,  F. Combs  
GIDP:  J. Ellingson 
Team LOB:  5 

BASERUNNING
 CS:  F. Combs  (4) 

FIELDING


Manhattan      		AB  R  H  2B 3B HR RBI BB  K  SB CS SAC 
R.Lehr-lf      		 4  0  1   0  0  0  1   0  0  0  0    
L.Hertz-3b     		 4  0  0   0  0  0  0   0  1  0  0    
L.Fairchild-rf 		 4  1  1   0  0  0  0   0  1  0  0    
T.Roberts-ss   		 4  1  1   0  0  0  0   0  2  0  0    
F.Ward-1b      		 4  1  2   2  0  0  2   0  0  0  0    
O.Mintz-2b     		 4  0  2   0  1  0  0   0  1  0  0    
O.McDonald-cf  		 1  1  0   0  0  0  0   3  0  1  0    
D.Bess-c       		 4  0  1   0  0  0  0   0  1  0  0    
J.Rogers-p     		 3  0  0   0  0  0  0   0  1  0  0    
----------------------------------------------------------------- 
Totals: 		32  4  8   2  2  0  3   3  7  0  0  0

Manhattan     		   IP   H   R  ER  BB  K  HR   PI   GB   FB 
J.Rogers W      	    9   5   1   1   2  4   0  117    7   14


 Doubles:  B. Cutlip  (22, 2nd Inning off J. Rogers, 0 on, 0 outs)  
Triples:  H. Punt  (2, 1st Inning off J. Rogers, 0 on, 1 out)  
Total Bases:  B. Cutlip  2 ,  J. Ellingson ,  H. Punt  4 ,  E. Baron 
Runners left in scoring position, 2 outs:  O. Woods  ,  C. Thibeault  ,  F. Combs  
GIDP:  J. Ellingson 
Team LOB:  5 

BASERUNNING
 CS:  F. Combs  (4)

JustinM · 05-25-2010, 10:44 PM

Good start. Three things I find odd about it.

a) The batting averages aren't there in this output, but they are in the game's box score.

b) The additional pitching info (batters faced, pitches for strikes, etc.) isn't there in this output.

c) The bottom-of-the-box-score info isn't there, like time of game, player of the game, etc.

It has to save this stuff somewhere, right?

joe_44850 · 05-26-2010, 07:25 AM

The batting averages will be tricky, and maybe not possible. The problem is, there is no way to query the database for, say, hits and atbats up to a certain date. You can only do it by year, so you could include averages, but they would show the current average - not the average immediately following that game.
The game has the 'advantage' of printing the box scores out immediately after the game, whereas this program is trying to reproduce the box scores long after the fact (though if you did an export after each game, I suppose you'd have the correct stats in the box score).

The other possibility would be to write code that parses the current html box score and try to extract the AVG HR RBI out of it - no easy task.

The other stuff can be included, I'm pretty sure, I'll see about adding it.
Right now I'm working on additional export areas, like season standings, batting reports, pitching, and league leaders. I may have it ready for download by saturday or sunday.

05-12-2010, 07:05 PM	#1
JustinM Major Leagues Join Date: Apr 2008 Location: Cranberry Twp, PA Posts: 445	Plain text output! This would be a great help for dynasty writers. Plain text output of box scores, stats, rosters, standings, etc. would be fantastic. Basically, if you can output something in .csv or .html, it should be possible to output that in plain, fixed-width text, for purposes of copying and pasting into the forum. EDIT: If this is small enough that it could fit in a patch, let me know and I'll put it in the proper place. Last edited by JustinM; 05-12-2010 at 07:13 PM.

05-21-2010, 07:37 PM	#8
joe_44850 Minors (Single A) Join Date: Oct 2002 Posts: 66	Oh man. That's not right. I'm going to make a fix for this in my utilities program, I'll let you guys know when it's ready. __________________ Southerners are very strange about that war -- Shelby Foote

05-22-2010, 08:10 PM	#10
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,648 Blog Entries: 32	I agree this that this would be great. For years, especially in my earlier OOTP days I wanted to be able to just print stuff to text so I could ride on the subway and read stats of my teams and such alike. I think it's well needed and should be easy to implement. __________________ ------ My Mods Managerial Strategy Pack Competitive Balance Tax Calculator Major League Women's Baseball (OOTP24) quickstart Indian Premier League \| 300+ years of baseball quickstart \| Expatriate League quickstart \| Off-Field Injuries Update \| Women's Name File for OOTP \| ---- Dynasty classics: Centurion comes to OOTP5 \| DC Moneyball Dynasty (2004)

05-22-2010, 08:53 PM	#11
joe_44850 Minors (Single A) Join Date: Oct 2002 Posts: 66	So, I read your guys' post yesterday, and decided this might be a nice addition to the OOTP-Utils program. So far, I have it so that there are two versions: a plain text version, and a stripped-down HTML version (of box scores). Basically, you go into the program, choose a range of dates to export, and it creates a folder named after those ranges and saves all of the resulting text and plain html. I'm having some problems with formatting widths, however, so it's taking a bit longer than anticipated. Here is a what the resulting html looks like: The text version is a little dicier, I'm having a lot of issues with name widths, text-wrapping, and columns bleeding over. __________________ Southerners are very strange about that war -- Shelby Foote Last edited by joe_44850; 05-22-2010 at 08:57 PM.

05-22-2010, 09:26 PM	#12
joe_44850 Minors (Single A) Join Date: Oct 2002 Posts: 66	You'll see here that when you have long names or extra positions, some of the text is no longer in it's column. And the totals line is weird. I'm at the mercy of the html code that OOTP creates (it does not store player-performance box scores, only winning & losing pitchers, so I have to parse it, cut it up, extract CSS info, insert column widths and replace table data with tabs and spaces) Code: Seattle AB R H RBI BB K LOB AVG HR RBI U. Martin LF 5 1 2 1 0 0 0 .469 0 3 D. Grieve RF 5 0 1 0 0 0 4 .333 0 3 C. Leiby CF 4 1 3 2 1 1 0 .321 0 5 L. Gargano SS, 2B 5 0 1 0 0 0 2 .107 0 2 H. Ault 1B 3 0 0 0 1 1 4 .182 0 0 a-G. Hollinshed PR, 1B 0 0 0 0 0 0 0 .167 0 1 E. Morgan 3B 4 0 1 1 0 0 4 .500 0 5 E. Bingham 2B 3 0 0 0 0 0 1 .000 0 0 b-F. Brooks PH 1 0 1 0 0 0 0 .571 0 3 c-S. Edington SS 0 0 0 0 0 0 0 .667 0 1 T. Linzey C 4 1 1 0 0 1 2 .261 0 4 D. Barnes P 3 1 1 0 0 1 0 .111 0 0 Totals 37 4 11 4 2 4 17 __________________ Southerners are very strange about that war -- Shelby Foote Last edited by joe_44850; 05-22-2010 at 09:29 PM.

05-12-2010, 08:29 PM	#3
SmoothGentleman Major Leagues Join Date: Apr 2009 Posts: 426	Is that from a dynasty? I'd love to follow it, great graphics .

05-12-2010, 10:47 PM	#5
SmoothGentleman Major Leagues Join Date: Apr 2009 Posts: 426	You took time to make the jersey graphics as well? Pretty awesome. You sound like a gm or scout lol.

05-12-2010, 11:05 PM	#6
edm All Star Starter Join Date: Dec 2001 Location: Philadelphia, PA Posts: 1,999	I agree Justin. especially for boxscores. right now to get a viewable boxscore online we need to output the html, upload the file along with the css. etc... Would love the ability to generate a simple txt file like we did in games like earl weaver and high heat had.

05-12-2010, 11:23 PM	#7
JustinM Major Leagues Join Date: Apr 2008 Location: Cranberry Twp, PA Posts: 445	This is what I'm talking about. He had to type that manually. I shamelessly copied it for my own (while thanking him for the work, of course), but the game should really, really do that on its own already.

05-22-2010, 02:10 PM	#9
JustinM Major Leagues Join Date: Apr 2008 Location: Cranberry Twp, PA Posts: 445	Hadn't considered an external utility for it, but that sounds good to me. Please do keep us updated!

05-23-2010, 12:10 PM	#13
JustinM Major Leagues Join Date: Apr 2008 Location: Cranberry Twp, PA Posts: 445	Hey, looks like you're well on the way to something eminently useful. I do worry that the last 5% will be the hardest. It always seems to be that way.

05-25-2010, 10:44 PM	#15
JustinM Major Leagues Join Date: Apr 2008 Location: Cranberry Twp, PA Posts: 445	Good start. Three things I find odd about it. a) The batting averages aren't there in this output, but they are in the game's box score. b) The additional pitching info (batters faced, pitches for strikes, etc.) isn't there in this output. c) The bottom-of-the-box-score info isn't there, like time of game, player of the game, etc. It has to save this stuff somewhere, right?

05-26-2010, 07:25 AM	#16
joe_44850 Minors (Single A) Join Date: Oct 2002 Posts: 66	The batting averages will be tricky, and maybe not possible. The problem is, there is no way to query the database for, say, hits and atbats up to a certain date. You can only do it by year, so you could include averages, but they would show the current average - not the average immediately following that game. The game has the 'advantage' of printing the box scores out immediately after the game, whereas this program is trying to reproduce the box scores long after the fact (though if you did an export after each game, I suppose you'd have the correct stats in the box score). The other possibility would be to write code that parses the current html box score and try to extract the AVG HR RBI out of it - no easy task. The other stuff can be included, I'm pretty sure, I'll see about adding it. Right now I'm working on additional export areas, like season standings, batting reports, pitching, and league leaders. I may have it ready for download by saturday or sunday. __________________ Southerners are very strange about that war -- Shelby Foote Last edited by joe_44850; 05-26-2010 at 07:28 AM.