copy Group Categories and Groups to Page Categories and Pages.
By Abi on Saturday, 15 June 2019
Posted in General
Likes 0
Views 485
Votes 0
Hello,

I have more than 200 group categories and each one has a single group. They all use the same workflow called Nations Workflow with ID 254.

Since pages are like groups, I would like to use phpmyadmin to copy all the group categories to page categories and all the groups to pages and thereby create new Page categories and Pages. Each of the group categories has an avatar which I will like the corresponding page category to have/share. Each group has an avatar and cover that I would like each corresponding page to have/share. The page workflow is called Page Workflow and has an ID of 252.
Currently only the admin user that created the groups is a member of groups that same user can be the owner of the new pages.

Can you please tell me which SQL statements to use?
Hello Abi,

Although pages are pretty similar to groups, they are not exactly like groups and cannot be treated that way. What you probably need is to create a workflow for the group category and then duplicate those categories from pages into groups from the table #__social_clusters_categories.

Once that is done, you need to create a mapping between the workflow which you have just created and the newly created categories for the group in the table #__social_workflows_maps.

I am really sorry but this is beyond the scope of our support and we are unable to assist you on this further.
Mark
·
Saturday, 15 June 2019 12:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Mark.
Abi
·
Monday, 17 June 2019 06:33
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome. Glad to hear that your issue has been resolved now.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.
Arlex Wong
·
Monday, 17 June 2019 10:00
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post