Thursday, March 31, 2011

Not keeping up with Java

Well, it's been a few weeks since posting about keeping up with Java. As far as that little URL dumper into a text file, then parsing and saving as a csv suitable for importing into sqlite, well, have not worked on that one for quite some time.

The good news is that on Sunday evenings, once the leaderboard is posted, I can get that URL data and run those three little programs and manually import into the sqlite using a firefox browser plug in. So at least I'm in the data collection mode, even if it is manual.

That final goal would be to have a Java program import that csv into the sqlite without me bringing up firefox. Eventually I'll get there.

Sunday, March 6, 2011

Keeping up with Java

With the fantasy golf season underway, understanding the technology is just as fun as choosing a golfer who finishes in the top 10. I'd think the technology is pretty much simple. Pick a golfer, the match is played, golfer's finish in a particular order. Finally, your pick result is posted. So off I went to create a similar, yet crude version of this as a programming exercise.

Things needed:
1. Application to download the web page with the data into a text file (url reader).
2. Application to parse out that text file into just the players.
- Players are in the tournament finishing order.
- The text file will be a csv file, suitable for import into an sqlite database using a firefox plugin.
3. Application that will automate the importing of the data into that sqlite.

So that is where I'm at for now. It will be worked on a little later when I feel like doing some java / sql programming again. It is fun, just need to do something different.