Export to CSV

NixonTheGrouch  3/30/2014 11:35 AM

Is it possible to add an Export to CSV option to Daily Projections like Basketbal Monster has?

lamartin  3/30/2014 9:37 PM

Along with this.........is it possible to get 1 file with both hitters and pitchers in it?

ken_admin  3/30/2014 9:39 PM

Yes, we'll work on getting a fixed-format CSV file. A single file with hitters and pitchers would be pretty big. How is this better than two files?

lamartin  3/30/2014 11:33 PM

kslight - Less buttons to click for my cutting and pasting.  It's not a big deal if it doesn't / can't happen.  Ideally I would create a macro to auto import them into my excel documents, but the excel web query will not let me change the hitters to the pitchers.

NixonTheGrouch  3/30/2014 11:42 PM

Two files makes more sense to me since it is different data, but either would be helpful.  Thank you!

lamartin  4/4/2014 7:30 AM

Wanted to bump this to make sure it is not forgotten about...

ken_admin  4/4/2014 10:11 AM

It's not at the top yet, but we'll make sure it's ready by next weekend at the latest.

NixonTheGrouch  4/13/2014 12:54 AM

Any update on this?  Thank you!

ken_admin  4/13/2014 7:07 AM

We'll finish this today and have it there for tomorrow morning.

NixonTheGrouch  4/13/2014 9:03 AM

Awesome, thanks for taking care of this!

ken_admin  4/13/2014 10:23 AM

This is on our test site if you want to give it a look: http://preview1.baseballmonster.com/default.aspx

Here's the planned format for hitters:

id,last_name,first_name,team,position,opponent,games,pa,ab,singles,doubles,triples,home_runs,walks,strikeouts,sb,cs,hbp,sac_flies,gidp,errors,outs, price_fanduel,price_draftstreet,price_draftkings,price_draftday,price_starstreet,price_fantasyfeud,price_fanthrowdown,price_starfantasyleagues,price_fantasyaces, positions_fanduel,positions_draftstreet,positions_draftkings,positions_draftday,positions_starstreet,positions_fantasyfeud,positions_fanthrowdown,positions_starfantasyleagues,positions_fantasyaces

And pitchers:

id,last_name,first_name,team,position,opponent,games,innings,singles,doubles,triples,home_runs,walks,strikeouts,runs,earned_runs,opp_ba,cg,qs,wins,losses,saves,blown_saves,holds,hbp,outs, price_fanduel,price_draftstreet,price_draftkings,price_draftday,price_starstreet,price_fantasyfeud,price_fanthrowdown,price_starfantasyleagues,price_fantasyaces, positions_fanduel,positions_draftstreet,positions_draftkings,positions_draftday,positions_starstreet,positions_fantasyfeud,positions_fanthrowdown,positions_starfantasyleagues,positions_fantasyaces

phillydilly  4/14/2014 6:14 AM

Looks good to me, only one suggestion I would like.

You have positions listed as one column for each sites position, so DD would be 1B/OF. I personally would like to have site with two positions split into two columns so it would be 1B, OF instead. I realize this might create issues where someone only has one position, but you could either leave this blank, repeat their position one, or something else.

ken_admin  4/14/2014 6:23 AM

Currently, the comma delimits the columns so if we use a comma to separate positions, that will cause there to be too many columns if a player has multiple positions. To avoid this, we use a semicolon to separate positions for players if there's more than one. Does this work?

NixonTheGrouch  4/14/2014 11:40 AM

Thanks, this looks great!

phillydilly  4/14/2014 2:54 PM

Actually, another comment on this. Could you add the matchup field to the CSV?

I like to use it to see opponent pitcher, bat L/R, opp pitch L/R etc

NixonTheGrouch  4/17/2014 12:59 AM

It looks like the player csv doesn't have runs and RBIs unless I'm misreading the headings.  Would it be possible to add them?

ken_admin  4/17/2014 5:42 AM

Added runs, RBIs, and matchup. We'll aim to stabilize this format soon since we know many rely on it not changing.

phillydilly  4/17/2014 8:01 AM

Starting to work with the CSV file, think it has a lot of promise. I'd also like to see weather, injury, odds, and BvP data added to it. Basically, everything I can see in the excel export, i'd like to be able to see on the CSV export

phillydilly  4/26/2014 8:04 AM

bump to see if any progress has been made on adding these items to the csv

ken_admin  4/26/2014 9:21 AM

These should be easy, and we'll aim to have these ready Tuesday,

ken_admin  4/29/2014 7:18 AM

Can you take a look at our test site to see if it contains what you need. Before deploying, we want to make sure the format is not likely to change again. Thanks

http://preview1.baseballmonster.com/

phillydilly  4/29/2014 7:44 AM

looks good, but if possible I'd like to see the injury column also.

ken_admin  4/29/2014 8:33 AM

OK, I've added injuries too: http://preview1.baseballmonster.com/

phillydilly  4/29/2014 8:59 AM

looks great!

thanks for all your work on getting this done.

ken_admin  4/29/2014 9:08 AM

OK, great. We will deploy these changes tomorrow.

phillydilly  4/30/2014 8:43 AM

came across an issue on the preview site. When I unselect games, they still show up in the CSV. for instance, today i want to exclude teh two early games, but they still appear in the csv after i uncheck them.

ken_admin  4/30/2014 8:46 AM

Yes, currently, the export includes all games, and most of the page filters are not applied (in an effort to create a consistent format). Using the game filter does seem reasonable since it won't affect the format so we'll look into applying that.