Thread: BBQRace.com
View Single Post
Unread 09-27-2012, 11:40 AM   #29
TheJackal
Full Fledged Farker

 
TheJackal's Avatar
 
Join Date: 09-14-09
Location: Flemington, NJ
Downloads: 0
Uploads: 0
Default

Quote:
Originally Posted by Rich Parker View Post
Idea:

Something I was planning to do but since your site is live, I have no need for it anymore.

Automate a process to scrap the data from their events section than when members find invalid team names they can contact KCBS to have it corrected and then initiate a refresh on the bbqrace.com side which would eliminate all of the merging issues you are having.

I was thinking the same thing. A few days ago, I actually pulled the data from a comp off of the kcbs site into Excel using the Get Data From Web import functionality just to see what it would look like. Not sure where they get their data from or what database platform they are using. If it is SQL Server then I'm sure they could source the KCBS URLs with SSIS to Extract Transform and Load the data into their database in an automated fashion and on a regular schedule.
__________________
Greg, Smokopolis BBQ -- http://www.facebook.com/SmokopolisBBQ
Yoder YS640
BBQ Guru Onyx
TheJackal is offline   Reply With Quote