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

Making Vista Search your PST Files

Vista can index a lot of files and for some reason it doesn’t index the MS Outlook files.. maybe it is as Outlook is already doing the same.. in case you still want to search PST from Vista Search here is what you can do: Go to the Control Panel Choose "Indexing Options" Click on the "Advanced" button Click on the "File Types" tab Check the checkbox next to "PST" to include it in the search Select the bullet next to the option "Index Properties and File Contents" Click OK and OK again on the message that appears. This is especially useful for information workers like me who have large PST files and are forced to archive from time to time … indexing the archives would return the information from these forgotten folders as well :) Tip taken from On10.net Technorati tags: Outlook , PST , search
Read more

Technocratical Society

In the past days, I haven’t been blogging. A lot has happened in that time – terrorist attack in Mumbai, MNS lost track, global recession set in and Congress advanced in the country. Here’s an ode to the state of the society as viewed by my nephew, Shantanu Chandra who is in Class XII, Amity International, Gurgaon. The lines below capture the times prevailing and the need for us to drop the “chalta hai” attitude but with caution: This techie world of gizmo and gadget This eerie feeling of incongruous widget Which gives us pleasure and takes pain Along with it makes us insane; Absurdness to such a horizon from where one would never fall And still people call you “Microsoft—…That’s all” A teen like me can’t do without a mobile-call Even though I know it is killing my brain cells, after all; This techie world of gizmo and gadget Makes a non-techie guy weird and hollow The bureaucrat are more concerned about their Sunday meal Than to serve the poor people whose w
Read more