import daily lineups into excel

oilcountry99  8/2/2018 1:08 PM

Is there a way to import this https://baseballmonster.com/lineups.aspx into excel?

ken_admin  8/2/2018 1:19 PM

Currently not, but that's a good idea.  Would a CSV format work?

oilcountry99  8/2/2018 1:27 PM

It should work. I wish it worked with Excel Power Query 

oilcountry99  8/3/2018 8:48 AM

kslight, you would be my hero if you could make something happen to get these lineups.  I can find other sources but they don't list a projected lineup and only post when they have a confirmed lineup.  I like a projected lineup early in the day and then update it when the official lineup is released as you do here at Baseball Monster.  Other sources i've found that fit my requirements are not importable to Exce.

For example fantasylabs has it and I need an elaborate workaround to get them, I had to get help for that as it's above my vba knowledge base.  I'm not a computer scientist, but enjoy dabbling in baseball projections.

OC99

ken_admin  8/3/2018 8:54 AM

It shouldn't be too hard to create a CSV format containing:

team code, mlb id, player name, batting order, position, confirmed

Would this do it?

oilcountry99  8/3/2018 9:07 AM

Yes that would do it.

oilcountry99  8/4/2018 9:19 AM

kslight, just wondering if this is being worked on and if there is a timeline?  Thanks for your help!

ken_admin  8/4/2018 9:20 AM

I'll give it a shot Monday so I would estimate Tuesday.

oilcountry99  8/5/2018 8:33 AM

That would be fantastic! I hope it works out. Keep me posted

ken_admin  8/6/2018 4:03 AM

Here's a link showing to get a CSV for today's lineups:

https://baseballmonster.com/Lineups.aspx?csv=1

How's this look, and are any other fields needed?

oilcountry99  8/6/2018 6:06 AM

kslight....that looks awesome!  I think I can work with this. The next question I have is how often will the csv be updated?  Is it updated everytime lineups are confirmed on baseball monster?  What is your source for the lineups? Where will I find the daily link to access these. I really appreciate your efforts in doing this.  I'm suprised how hard it is to find such a basic necessity (lineups) for easy import into excel.  Now onto figuring out the best way to import these to my excel sheet, if you have any tips you'd like to share I'm all ears!

Thanks again

OC99

ken_admin  8/6/2018 6:11 AM

The CSV holds the same info as the Lineups page so it's updated as lineups come in.  For a source, we either use Twitter or rely on our data provider, SportRadar (if timely enough).

oilcountry99  8/6/2018 6:39 AM

all the best to you!  you're a real class act kslight

oilcountry99  8/6/2018 7:09 AM

I know I'm reaching here but is there any chance of getting the table shown in the .csv as an added page to the site?  So basically a stripped down version of the daily lineups page that could be easily scraped into excel?  The way it's set up now becomes complicated because you have to log into the site and goto your user profile to access .csv files.  I figure it can't hurt to ask.

ken_admin  8/6/2018 8:13 AM

It shouldn't require a login.  Browsing to:

https://baseballmonster.com/Lineups.aspx?csv=1

should be available to everyone.

oilcountry99  8/6/2018 11:01 AM

Works like a charm through excel power query!  Thank you so much, I hope others can benefit as well!