Public
New Commentator

Export Group information

Hello Khoros community !

I 'm asking for your help as I have two issues concearning group functionality.  

>>> Issue 1

Is there any way I can export in a csv all groups with the ID of the group ?

Example : 

https://communaute.ucpa.com/t5/Le-groupe-des-Parisiens/gp-p/Parisiens-UCPA

I need :

  • Column 1 (group name): Le groupe des Parisiens
  • Column 2 (group ID): Parisiens-UCPA

 

I can go URL by URL and copy the ID, but I have more than 500 groups (private) and I need an export or something that will do it automatically.

 

>>> Issue 2

I need to know to how to what group on our community belong each member.

Is there an easy method not to look but to export all groups and members who belong to them ? Or maybe export all users and the groups to which they belong ?

 

Thank you for your help !

 

Anton KALININ

https://communaute.ucpa.com/

7 Replies 7
Khoros Oracle

For the first question, I believe the easiest way to get that kind of very specific list, in the precise manner that you need it, would be through an API query.  I do not know how the query would be structured, but you could go ask on the Developer part of the Community for advice (assuming that you or somebody on your team has the technical skills to run API queries).

On the other hand, for the non-technical user (like myself), you can get pretty close to that list if you did an export in the LSI analytics engine.  You would do this:

Lithium Social Intelligence > Content > Top 20 (click the gear way over on the right to have the Export CSV option occur) 

It says 'top 20', but the export should reveal ALL of your groups.  What the export will provide is the Group Name, the Group URL (which has the ID of the Group contained within the URL), and various other metrics.

In regards to the Member export question, I am almost certain that this would have to be done via an API query.  There is no single easy way to get that list (as far as I know) through the traditional UI.  

Thanks @JakeR our dev team is expecting some trouble using the API for this case, however we'll deploy LSI component this week and I'll test your solution. 

Occasional Contributor

Hello @JakeR 

I have a similar question. However, I am trying to simply export the user list for one of my groups. 

I was able to locate the list of users from the Admin panel, but I dont see a way to export this to a csv or xlsx file.

Thanks!

Khoros Oracle

My apologies if this is a way too simplistic answer, but when you look at your list of Users / Members, off to the right side (kind of near the top) do you see a small 'gear' icon?  If so, click on that icon and you should see an option to export the list as a CSV file.

Advisor

@JakeR when I click that gear icon i'm just taken to the member management page where it lists the members, but I don't see an option to export. Can you explain where I can find this option to export all members? 

TEST
Advisor

Also for anyone else looking for where to locate the group members from the admin panel, go to group hub admin > users > members. 

 

It'll look like:

https://yourcommunitynamehere/t5/bizapps/bizappspage/tab/community%3Aadmin%3Ausers%3Auser-permissions%3Amembers-list/node-display-id/grouphub%3Agroup-id-here

 

group id = the url / id associated with your group

TEST
Khoros Oracle

The 'gear icon' should have a dropdown that appears where you can export (as CSV), schedule a report, or manage columns.  If you do not see those options, when you click the gear icon, you may not have the full / proper permissions to export.  In that case, I would consult internally with your team and/or open a Support ticket with Khoros.

Also, sort of a weird question, but why does it say 'TEST' in the signature of all of your posts?

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.