Finding the newsletter solution

For Community Server, there doesn't seem to be a feature for sending a newsletter to only subscribed members. Here is a simple solution from JO Eriksson on designing a simple opt out newsletter scheme for Community Server installation.

Now the only thing while i was implementing it for Community Server 2.1 (Standard Edition) was that the Stored procedure (meant for migrating existing users into the role) produced in the post wasn't working for me. Appears there was a schema change in CS 2.1. I have modified the SP to work with CS 2.1 as follows:

 

CREATE TABLE #NewRole (
[UserId] [uniqueidentifier] NOT NULL ,
[RoleId] [uniqueidentifier]
)

INSERT INTO #NewRole (UserID)
select userid from aspnet_Users
where userid not in
(
select aspnet_users.userid from aspnet_UsersInRoles inner join aspnet_users on aspnet_Users.UserId = aspnet_UsersInRoles.UserId
where aspnet_UsersInRoles.RoleId = 'bb497bc8-d18a-4244-8b1b-8aaa80dc974d'
)

UPDATE #NewRole
SET RoleID = 'bb497bc8-d18a-4244-8b1b-8aaa80dc974d'

INSERT INTO aspnet_UsersInRoles (UserID, RoleID)
SELECT UserID, RoleID FROM #NewRole

DROP TABLE #NewRole

 

Technorati tags: , ,

Comments

Anonymous said…
Hmmm... I wonder if the need for the SQL Script change is due to that you've also gone from ASP .NET 1.1 to ASP .NET 2.0.
November 22, 2006 at 4:47:00 AM GMT+5:30
Post a Comment

Popular posts from this blog

Community Star Discussions and Future

In my continuing discussion with Community Stars across the country, I had a discussion today with Sadashiv. Though he works out of chennai and was here for a short trip, he found time today to discuss the opportunities for Community Star program to improve on. Some of thoughts we generated out of the discussion are as follows: 1. Community Stars are disengaged 'cause of lack of communication with them from MS. Better communication channels need to be developed. 2. Award experience and delivery of the Community Star benefits leave a lot to be desired. 3. Community Stars feel that MS is not laying enough importance on Community Stars and do not value their contributions much. More information needs to flow to CSs. From our end, we are doing the following: 1. Launch an extranet portal exclusively for Community Stars. We will host issue submission on this site. Also, we will share opportunities via this site e.g. beta opportunities 2. Re-launch the Community Star distributi...
Read more

Notes from an Internet Marketing Seminar

These are my notes from an internet marketing seminar I attended. Read through to see if you can figure out who delivered this and i promise you would be surprised :) Topic: Web & New Media: Emerging Trends 183 bn emails sent a day 49 mn internet users in India 7.5 hrs spent on internet/ week (18-35 Males) 1.2 bn searches / month- search increasing at 80% 80% online shop Online Time Spent in India: 23% – TV 30% Internet 26% Print 21 % Radio Advertising Money Spent: 41% TV 1% Internet 40% Print 12% Radio 1.4 bn online out of 6.6 bn in the world mobile is the next huge thing... computing cloud is the current stage after PC being personal era.. web is not US centric.. 211 still the largest.. inspite of the company being so "open source".. the presentation consistently says Confidential & PROPRIETARY .. paradoxical.. the presentation laptop from google is running Windows XP.. sweet.. and oh! the presenta...
Read more

Solving the multi-platform challenge in mobile devices

Image
The writing is on the wall is clear with mobile devices becoming mainstream business devices. In addition to the current workhorse – the PC, consumers and businesses are adopting internet connected smartphones and tablets in record numbers. The path for mobile device enablement for businesses is fragmented and full of challenging decisions. This starts from mobile application landscape being multi-platform and multi-resolution. While Android uses Java, iOS uses Objective-C, Windows Phones use .NET. Natively hitting all of these environments requires one to build multiple versions of an app and to learn multiple technology platforms. New challenges also open up with the client devices in deliver visualizations and touch enablement. How to work with multi-platform challenge Fortunately there exists a solution to this madness in HTML 5. This stack takes advantage of browser based technologies and hence can run on all of the major mobile platforms as well as desktop platforms. However, th...
Read more