CSV Export for MLB

stembot  4/3/2016 10:00 AM

Hi,

in NBA there was a link to download the CSV export, a permalink of sorts, available through one of the settings/options pages

does something similar exist for MLB subscribers (er well, once you let us pay for it!? :) )

If not is it easy enough to add a link like that for downloading the .csv every day without having to visit and configure the projections page?

ken_admin  4/3/2016 10:01 AM

We'll create a link for this and include one for XLS also.

bobmcadoo78  4/3/2016 10:09 AM

That would be great.

ocdobv  4/3/2016 1:54 PM

Probably need 2 links.  1 for batters and 1 for SPs.

cdenny99  4/9/2016 1:58 PM

Hello.  Just wondered if this was still in the plans?

ken_admin  4/9/2016 2:00 PM

Yes, this is still on the way.  I would estimate by Tuesday.

cdenny99  4/9/2016 2:03 PM

Sounds good--thanks!

ken_admin  4/10/2016 7:29 PM

This will likely require two links, one for hitters and one for pitchers. Is this what you're expecting?

stembot  4/10/2016 9:21 PM

yeah two links is great, preferred, does not matter!

I guess a side question ... it seems, I guess, why are the BM factors not included as a column on the CSV export?  I'd like the have them for view

could the same thing be done for the .xls export, just throw all the links and we can use whatever?

csv definiltey the preference though if only one is possible

cdenny99  4/11/2016 7:16 PM

I can work with two separate links--no problem

cdenny99  4/13/2016 6:15 AM

Hi there..  Any updates on this?  Thanks

ken_admin  4/13/2016 6:51 AM

I'll try to wrap this up today and have it ready for tomorrow.

cdenny99  5/9/2016 9:24 PM

I would like to see the csv reflect the same info I see on the main DFS projections page--like you had with NBA

Thanks!

stembot  5/13/2016 9:26 AM

Hey Ken not trying to be a pest, but I got excited when you did mention back originally that this would be possible.

What's the current situation?  As of right now I have the download link for CSV but every single day I Have to go through and export excel files (for each site also, not just one) in order to get the BM factors.

Is there any way around that?  Either permanlinks to the excels (by site) OR just adding factors to the CSV OR - I mean - WHATEVER might be easiest / cleanest for you?  I'm not sure if you had an idea already when you brought it up ... so don't let me spin that into left field just ... thinking out loud!

 

ken_admin  5/13/2016 9:36 AM

I think the link would be easiest, and I'll give this a shot in the next few days.

atruecubsfan@yahoo.com  5/13/2016 1:01 PM

would love a link for the Excel file.   While you're at it, also would be nice for the names to be clean and dated like the CSV files (like Export_20160513.csv).  Right now when I download the excel file it comes out as d5yrxytmq....xls.  Not important though.

ken_admin  5/13/2016 1:22 PM

Yes, that changes makes sense too. Thanks

sangamc  5/14/2016 3:05 PM

When i try and import the CSV i get an xls doc missing all the different salaries and positions. From the DFS page, download CSV has several lines out of order. As shown below.

ken_admin  5/14/2016 3:23 PM

It should work now.  It looks like there was an invalid character in the Odds field.  Sorry for the trouble.

sangamc  5/14/2016 3:36 PM

Spoke too soon. Test with SP, and no issue with that CSV, but Batters still adds extra rows.

ken_admin  5/14/2016 4:18 PM

Both look OK for me.  Can you show a screenshot again?

sangamc  5/15/2016 7:08 AM

The CSV export from the main DFS page was correct. The export CSV from the settings page produces the XLS instead of the CSV which is missing all the salary/pos info for all the sites.

ken_admin  5/15/2016 7:23 AM

The CSV links should work for you now.

sangamc  5/15/2016 8:19 AM

THanks!

stembot  5/17/2016 3:26 PM

Hey Ken,

I see the xls links now in the user settings page.  Are these "live" or are you still working on them?

Thanks either way!

ken_admin  5/17/2016 3:27 PM

They are live so feel free to try them out.

stembot  5/19/2016 6:59 PM

The .XLS files that are downloaded from the permalink are .. not the same as the ones on the /Daily.aspx page?  They do not have the same information, namely, the daily matchup factors for whichever site we're using.

That was the only reason I mentioned the xls - I was hoping to be able to download matchup factors automatically, because they are not included in the CSV nor the permalinked XLS stuff you just made ... they ARE in the .xls files that are available for download on /Daily.aspx ...... but the permalinks go to a different document ...

Is there any way to be able to download ANY kind of file from ANYWHERE with one of those permalinks ... that includes the daily factors in a column ??

ken_admin  5/19/2016 9:27 PM

Yes, ideally, the XLS would contain the same fields that you've selected on the DFS page, and I'll make that change.