Skip to Content Skip to Menu

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

Understanding the groupjive MySQL tables

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
7 years 11 months ago #287455 by timstohr
Hi Kyle,

I am trying to understand the MySQL tables of groupjive. I think I have done but please confirm:
New entry gets incremented on ID. Published, Groups ID and User ID are clear.

The entry in REPLY indicates if the post is a reply and to which entry ID it belongs to.

Did I understand that right?

PS: I am exporting all my FB group conversation and trying to put it all on group jive. Would give 1000s of pages of original content in one go...

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

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
7 years 11 months ago #287456 by timstohr
Replied by timstohr on topic Understanding the groupjive MySQL tables
Btw, the export with Grytics gives an amazing detail of ideas on how FB built up their MySQL tables in order to provide the services they do. If you want I can send it to you.

Bye

Tim

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 #287469 by krileon
Replied by krileon on topic Understanding the groupjive MySQL tables
Sounds like you're referring to the _groupjive_plugin_wall table specifically. ID is the auto increment column. Your imports simply should just not specify that column at all and it'll auto increment. user_id is the user id of the user who made the post and have no idea how you plan to link the FB post user to a Joomla user. group is of course the GJ group id the post is in. reply is the ID of another post that it's replying to (so the post it's replying to must exist first). post is of course the post contents. date is the date the post was created. published is simple -1 (pending approval), 1 (published), or 0 (unpublished).


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.

Moderators: beatnantkrileon
Powered by Kunena Forum