RSS feed Suggestions Requested for Our Database Queries

Currently, we use MailChimp to send normal RSS feed information to our users. We would like to periodically include new user and / or group creation information from, say, date1 through date2. Depending on a user's group membership, we would like the newsletter to include:
○ New members for particular groups
○ New Groups created within a particular GJ Category

Both the above require similar database queries to extract the data, but what steps / Auto Actions would you suggest to create the RSS feed? We would like to automate the process.

CB and GJ do not have RSS feeds at all. Unsure of what you're asking. Are you needing queries for that information? GJ groups are stored within the _groupjive_groups table. The usergroups assigned to users are in _user_usergroup_map. GJ fires the gj_onAfterCreateGroup trigger when a new group is created. When a new usergroup is assigned from backend the trigger onAfterUpdateUser is fired.

Thanks, that information is helpful.

Is CB Auto Actions capable of running an action automatically every so often, say, every 10 days, without someone having to remember to kick it off manually? Assuming we have queries ready, where would you suggest generating output--blog or forum posts, or somewhere else, so the output would become part of an existing RSS feed? What Auto Actions would be best to accomplish getting query information in an existing blog or forum post (to be picked up by the RSS feed)? We're just wanting some ideas of how best to implement getting this type of information to users via the existing blog or forum RSS feeds. Your ideas / thoughts are appreciated.

Is CB Auto Actions capable of running an action automatically every so often, say, every 10 days, without someone having to remember to kick it off manually?

Yes, if you use CRON to schedule it, but that's independent of triggers and has nearly no information to work with beyond user object.

Assuming we have queries ready, where would you suggest generating output--blog or forum posts, or somewhere else, so the output would become part of an existing RSS feed?

I've no idea. Try both I suppose.

What Auto Actions would be best to accomplish getting query information in an existing blog or forum post (to be picked up by the RSS feed)?

No trigger can help you with that as you're wanting information from the database or through API on demand. So you could really only make sure of CB Auto Actions by setting Triggers to None and using a Code action with Method set to PHP to utilize PHP to do whatever you're wanting. If you're wanting to push information about a newly created group to some other extension then you'd use the trigger provided in my previous reply.

We're just wanting some ideas of how best to implement getting this type of information to users via the existing blog or forum RSS feeds. Your ideas / thoughts are appreciated.

I don't really recommend bothering with RSS feeds. They're barely used anymore. I suggest simply using CB Activity and they can see new groups, etc.. directly on the activity stream.

Some of our users aren't regularly active visiting or posting on our site. Some of them do, however, regularly check their email and click on the forum and blog links that our RSS newsletters provide. Providing information this way helps us to keep users informed and engaged with our site.

Thank you for your ideas.