Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

RSS feed Suggestions Requested for Our Database Queries

  • GUEST
7 years 11 months ago #288184 by
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.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
7 years 11 months ago #288198 by krileon
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.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • GUEST
7 years 11 months ago #288220 by
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.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
7 years 11 months ago #288251 by krileon

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.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • GUEST
7 years 11 months ago #288278 by
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.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum