question

We're finally about to merge the data from into Ask.SSC. There has been some good discussion of this before, but now we're getting down to specifics. We could use your help to make sure the bases are well-covered. First, there is an issue of different tags being used to represent basically the same thing. We have uploaded CSV files of all the tags from both SQLTeam and CCS to so nobody needs to endure the aggravation of cutting and pasting pages of web data into a spreadsheet. What we'd like (and we're not exactly sure the optimal way to do it) is to have you guys decide which tags from SQLTeam you would like remapped to existing tags in SSC. We really just need a file that has the tag pairs to show what target tag to use for any original tag that you want to be mapped. If there is no mapping for a given tag, then we'll just preserve the original tag. Second, and significantly more complex, is the question of correctly combining users who have accounts in both communities. Here are some statistics: 1. There are 2664 users in SSC and 1515 in SQLTeam. 2. There are 119 users with the exact same username. 3. 115 users in both sites have the same email. 4. Of these users, 57 also have the same username. 5. There are 29 users that share some authentication key. 6. Of these, 21 have the same username on both sides. 7. 23 Users share both email and authentication key. 8. 19 share it all: auth key, email and username. So, you can see that the overlap is, at best, unclear and doesn't cover most users. We have a strategy in mind to produce a reasonable combination of the user datasets, and we think we have a good idea about how to let users combine accounts in a "self-service" mode for those who end up with multiple accounts. Hernani will discuss the merge strategy more below. Finally, there may be other important issues about merging that we have not considered, so let's get them all on the table in hopes of getting to the most useful and successful outcome. Thanks!