Page 1 of 2

CSV Report

Posted: Mon Oct 25, 2010 1:05 pm
by nick50119
Is there a way that I can see a sample of the CSV game stats report? I have not purchased the app yet but I would like to make sure I will be able to export the stats directly to my existing website. I am working on a baseball team management plugin for the popular CMS WordPress and would like to include this feature.

Re: CSV Report

Posted: Mon Oct 25, 2010 2:48 pm
by OhioTex
Send me a pm w/ your email and i can send you one... Basically if you can manage excel or cvs files you will be able to import, we have others with automated use of csv files....

See this thread for example of a power user for csv importing use..
viewtopic.php?f=4&t=2361" onclick="window.open(this.href);return false;

Re: CSV Report

Posted: Mon Oct 25, 2010 3:42 pm
by jcbeckman
Hey! Thanks for the mention OhioTex. That's my site he is referring to (http://www.beckmanjm.com/iscore" onclick="window.open(this.href);return false;). It's not necessarily very pretty graphically, but I import all the CSV files into a MySQL database and then generate all stats on the fly - so you can request team stats, league leaders, standings, etc. for any day.I also store the PDF in the database, so no scrounging for it on disk.

I am replaying the 1984 AL season with a tabletop game (APBA BAseball) and use iScore to score all my games (over 150 games now). It's perfect for scoring. The only things I can't get automatically from the files are the inning by inning scores and the winning/losing/save pitchers, so I have to enter those manually. But every other raw stat is from the CSV files. I don't use the calculated stats (ERA, AVG, OPS, etc) since I need to recalculate based on if it's for one game or a date range. The whole thing is done in PHP (with some code to read up the CSV files found on the PHP site, submitted by a user for all to use).

Re: CSV Report

Posted: Mon Oct 25, 2010 4:49 pm
by OhioTex
Of course jbeckman... Can i lobby for the 2010 ranger season some day...lol

Re: CSV Report

Posted: Mon Oct 25, 2010 4:51 pm
by jcbeckman
I do want to play the 2010 AL season at some point - I'd like to see what the Tigers would have done with a healthier team.

Re: CSV Report

Posted: Tue Oct 26, 2010 5:08 am
by nick50119
Thanks for you responses.

jcbeckman, how do you import it to mysql? Using PHP I hope?

Re: CSV Report

Posted: Tue Oct 26, 2010 5:45 am
by jcbeckman
Yes, It's all in PHP. When I get home I can look up the module for reading the CSV files and post a link - it will save you a ton of time.

Re: CSV Report

Posted: Tue Oct 26, 2010 9:29 am
by nick50119
much appreciated.

Re: CSV Report

Posted: Tue Oct 26, 2010 1:00 pm
by jcbeckman
Go to http://php.net/manual/en/function.fgetcsv.php" onclick="window.open(this.href);return false; and search well down the page for "michael dot martinek at gmail dot com" (this is the comment that has the parser code).

Re: CSV Report

Posted: Tue Oct 26, 2010 4:13 pm
by nick50119
Thanks!