We’ve moved from WordPress’s free site (https://beyondtoiletbowl.wordpress.com/), to this hosted solution. I have self imposed a temporary suspension of my Fantasy Football privileges, until I get a job. So I won’t be analyzing weekly stats. If you have job for a C# programmer with Winforms, ASPX, and HTML experience, let me know.
But I think a Analysis of 2018 NFL Fantasy Football Season, would be a good segue to the Piker’s applications of the HtmlParser. This is for the guy between cut and paste from browser, and actually buying the data from a data provider.
The people we will be comparing against, will be the experts from some popular Fantasy Football sites and see how you would do, if you used their top 200 list for your drafting strategy. I will not be using HTML Parser to get the list from these guys. A one time cut and paste will work just fine. But if you get data every day, and they are kind enough to publish in exactly the same format every day, HTML Parser might have value, a use case, (whatever you call it) for you.
- Matthew Berry @ ESPN
- Tristan H. Cockcroft @ ESPN
- Michael Fabiano @ NFL.com
- USA Today Sports
- CBS Sports.com
- FFToday.com
Surprisingly, it’s not stupid easy to create a table from cut and paste. But upgrade slightly to nimrod like me, and it can be figured it out.
https://support.discountasp.net/kb/a1179/how-to-import-a-csv-file-into-a-database-using-sql-server-management-studio.aspx
So, how many cut-and-pastes does a nimrod need, before he needs a special app to make it easier to cut and paste text from webbrowser to a database table? It takes 3 min to do the import and fix the data cut and paste from browser, and save to file.
–3min to import the file to SQL server (or access)
–plus 2min to fix the first import that messed up
–and if you have foreign keys to establish with existing data, about 10min of work/200 rows of data imported, of brain-work to create a set of matching critera to create the foreign key field.
I’m guessing about 10 cut-and-pastes every month like that, will make a nimrod like me, write an app for that.