Return to Jive Software

Up to Discussions in Support

This Question is Answered

1 "correct" answer available (4 pts) 1 "helpful" answer available (2 pts)
2,250 Views 5 Replies Last post: Feb 23, 2009 8:07 AM by Vinh RSS
Beau Gordon Novice
Beau Gordon
129 posts since
Aug 27, 2007
Currently Being Moderated

Nov 26, 2008 3:14 PM

Automatically subscribe users to a particular subcommunity

Hi,

 

I have a subcommunity that I want all users to receive email notifications for.  I just want to bulk-subscribe all my users to it.

 

I thought that I could insert a row in the jiveWatch table for each user for that subcommunity, but that doesn't seem to have worked.  What am I missing?

 

Thanks,

Beau

Vinh Jive Employee
Vinh
12,343 posts since
Apr 1, 2008
Currently Being Moderated
Dec 3, 2008 8:06 AM in response to: Beau Gordon
Re: Automatically subscribe users to a particular subcommunity

Can you show the ID of the community and the query you were using to insert rows into the jiveWatch table?

Beau Gordon Novice
Beau Gordon
129 posts since
Aug 27, 2007
Currently Being Moderated
Feb 20, 2009 12:07 PM in response to: Vinh
Re: Automatically subscribe users to a particular subcommunity

Hey Vinh,

 

Sorry for the delay here.

 

I ran this SQL statement:

 

insert into jiveWatch (userID, objectType, objectID, watchType, expirable) values (3230, 14, 2168, 1, 1)

 

The subcommunity ID is 2168, the userID is 3230.  This statement does not appear to subscribe the user to email notifications.  (When I log in as that user and go to the subcommunity, the message still says "Receive email notifications" instead of "stop email notifications."

 

CS Community 2.5.3.

 

Beau

Brad Molander Novice
Brad Molander
75 posts since
Jun 17, 2008
Currently Being Moderated
Feb 20, 2009 12:19 PM in response to: Vinh
Re: Automatically subscribe users to a particular subcommunity

Beau,

 

I just did something similar but used the WatchManager class. Using that I was able to programmatically build RSS feeds based on what they were "watching" in the community and send those to a richclient/rssreader. Looking at the class, there is a createWatch(User,JiveObject) method which probably does what you want.

Beau Gordon Novice
Beau Gordon
129 posts since
Aug 27, 2007
Currently Being Moderated
Feb 20, 2009 12:23 PM in response to: Brad Molander
Re: Automatically subscribe users to a particular subcommunity

Good idea.  Looks like I can get to this via the watchService webservice too, which will work better for my use case.  I will give that a shot.

 

Thanks.

Vinh Jive Employee
Vinh
12,343 posts since
Apr 1, 2008
Currently Being Moderated
Feb 23, 2009 8:07 AM in response to: Beau Gordon
Re: Automatically subscribe users to a particular subcommunity

I agree with Brad's recommendation of web services, as that will make the necessary calls to the API to add a watch for that user to the database. Let me know if you have problems with this.

 

Vinh

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.