Originally Posted by Rich Parker
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.