> Forums > Active Social > Community Support > SQL Script to manually set Group to receive notifications
Last Post 24 May 2011 08:44 AM by Steven Webster. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Not Resolved
Stephen Nill
Customers
Stephen Nill
Post Count:152

--
23 May 2011 07:06 PM
    • Active Social Version: 1.9.3
    • DotNetNuke Version: 5.6.2
    We need to be able to set all members of a group to receive all notifications (by default, they don't). I wish this was a capability of AS but it's not, at least, not yet. Has anyone come up with a solution? For example, has anyone come up with a SQL script to enable us to manually do this? Any help would be greatly appreciated.

    Thanks!
    Steve
    Steven Webster
    Customers
    Steven Webster
    Post Count:1665

    --
    24 May 2011 08:44 AM
    Steve, ideally this would be handled on Group Join. There is an API and while it adds a user to a group and handles all the notifications for joining...it doesn't currently handle notifications. I've written a small module that allows me to replace the AS join group with my own....my intent is to create a wizard that walks a user through the group joining process, asks them to select notifications hey want and finally asks them to invite friends. It's not even close to done but when it is I plan to make it available on dnnOsphere to members.

    Until then, I believe everything for group journal subscriptions is handled in the activesocial_Groups_Subscriptions table. There are three values to worry about, UserId, GroupId and JournalTypeId.

    Lastly, I've been lobbying Will to include notification handling and templates for the third party journal API and to split up group journal notification templates by journal type. Having control of all of these issues at the admin level would provide a very comprehensive notifications solution within AS.

    Steven Webster
    dnnOsphere.com, An Independent Community for DotNetNuke Users
    You are not authorized to post a reply.
    > Forums > Active Social > Community Support > SQL Script to manually set Group to receive notifications
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy