roflwafflez
New Member
- Joined
- Nov 20, 2015
- Messages
- 2
Hi All,
I've been scouring the web trying to find an answer to this. I have a programming background, so if anyone could provide any resources that could help that would be greatly appreciated.
I am trying to automatically download / update a sheet on my excel (or google sheet if that is easier) based off a dynamic .csv export. The export is in .csv or .tsv form and comes from BBstate and provides college basketball stats. Right now I goto the site each time and download each of the csvs and am trying to find a way to automate this. This site is behind a username and password, once I am logged in I click whatever statistic set I want and hit a data export button, which provides a .csv download.
I installed an HTTP trace (see below) to see if I could figure it out, but wasn't having any luck (its been a while since I've coded and I am bit out of date especially with web stuff). I wanted to see if it were possible (without a massive time investment) and if so whether anyone knew any resources available that could enable me to do it. Again, if using google sheets makes its easier, I have no qualms using that instead of excel.
http://bbstate.com/data/798b388599193f73f520db989
GET http://bbstate.com/data/798b388599193f73f520db989Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8Upgrade-Insecure-Requests: 1User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36Referer: Advanced Performances - Basketball State gzip, deflate, sdchAccept-Language: en-US,en;q=0.8Cookie: auid=1673xxxxxxxx170; __atssc=google%3B4; __atuvc=10%7C45%2C17%7C46; __atuvs=564ead195587222b010
HTTP/1.1 200 OKDate: Fri, 20 Nov 2015 05:59:58 GMTServer: Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/1.0.1e-fips mod_bwlimited/1.4 PHP/5.5.30X-Powered-By: PHP/5.5.30Content-Length: 0Keep-Alive: timeout=5, max=200Connection: Keep-AliveContent-Type: text/html
I've been scouring the web trying to find an answer to this. I have a programming background, so if anyone could provide any resources that could help that would be greatly appreciated.
I am trying to automatically download / update a sheet on my excel (or google sheet if that is easier) based off a dynamic .csv export. The export is in .csv or .tsv form and comes from BBstate and provides college basketball stats. Right now I goto the site each time and download each of the csvs and am trying to find a way to automate this. This site is behind a username and password, once I am logged in I click whatever statistic set I want and hit a data export button, which provides a .csv download.
I installed an HTTP trace (see below) to see if I could figure it out, but wasn't having any luck (its been a while since I've coded and I am bit out of date especially with web stuff). I wanted to see if it were possible (without a massive time investment) and if so whether anyone knew any resources available that could enable me to do it. Again, if using google sheets makes its easier, I have no qualms using that instead of excel.
http://bbstate.com/data/798b388599193f73f520db989
GET http://bbstate.com/data/798b388599193f73f520db989Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8Upgrade-Insecure-Requests: 1User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36Referer: Advanced Performances - Basketball State gzip, deflate, sdchAccept-Language: en-US,en;q=0.8Cookie: auid=1673xxxxxxxx170; __atssc=google%3B4; __atuvc=10%7C45%2C17%7C46; __atuvs=564ead195587222b010
HTTP/1.1 200 OKDate: Fri, 20 Nov 2015 05:59:58 GMTServer: Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/1.0.1e-fips mod_bwlimited/1.4 PHP/5.5.30X-Powered-By: PHP/5.5.30Content-Length: 0Keep-Alive: timeout=5, max=200Connection: Keep-AliveContent-Type: text/html
