We successfully completed the upgrade. Thanks for the advice. We now have a nested group creation question and a data import question.

This implementation is for an international school system with schools located around the world.
We are using groups to manage the relationships between the 45 districts, 2,500 schools and 24,000 members (mostly teachers). We are working with a legacy MSSQL database and have migrated the data to MySQL

We need help set creating nested groups and populating them with data from our tables:

We have 3 relevant tables:
districts (45)
schools (2,500)
teachers (24,000)

We want to create a nested hierarchical grouping based on these 3 existing tables
where

1. superadmin is "parent" to districts
2. districts are "parents" to schools (districts have a one to many relationship to Schools and Schools have a one to one relationship with a district)
3. schools are "parents" to teachers
(we will eventually want to have teachers that are "parents" to students)

Can you offer advice and help with:

(1) How we create the nested categories needed as described above (superadmin, districts, schools and categories)? and how do we set-up our data (superadmin, distrcts, schools and teachers) in these nested categories to properly function within Group Jive 2.4rc.

(2) How we import our data from the above described tables into these groups? Which fields would we need to use in CB OR GJ?

(3) OR what are the appropriate Joomla Group Jive (or Community Builder) table(s) we can use to add data directly from our MySQL tables?

I'm not sure I've been clear about the need. Please feel free to ask questions if you need clarification.

Hi,

I have installed "int_cbgroupjiveforums_24" plugin. But I not able to see this tab in front end. Please tell me where i did mistake.

Regards,

We had a smooth install and our previous groups were integrated. We successfully created nested categories and integrated with Kunena forum. Very cool!

However, we have an issue that appeared when we deleted two of the nested groups from the Joomla administrator back end using the Kunena forum control panel shown in the screen grab. The groups deleted are shown in this grab and were the Michigan District and St. Lorenz school. The Michigan District contained 4 groups, one of which was the St. Lorenz school

After this deletion, we received the following message when the group owner logged in and tried to display Joined groups or Category overviews (only the group owner received this message, all other logins load groups correctly.)

Error loading Modules: MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jost_modules_menu AS mm ON mm.moduleid =m.id WHERE m.published =1 AND m.access <=2 AND m.client_id = 0 AND (mm.menuid =0) ORDER BY position, ordering


Can you advise?

Thanks for the help. We took the easy way out and reverted to the version before the deletions and error message. Things are now back to normal.