Contributor ⭐️⭐️

Export users - Add the unique user ID to the export

Forum|Forum|6 years ago
December 24, 2019
15 replies
128 views

On our Community we invite users to join hidden groups where they can share their thoughts and ideas on our new products and apps. To keep track of all of the testers, once in a while we export all of our users and do across check in Excel.

Due the rules on our Community the user names can change (eg no profanity etc). Changing names are messing up the cross check. User ID's are unique and will never change, but are excluded in the export.

I would like to see the unique user ID added as a column to the user export. This would help out greatly and streamline some of our other processes. Looking forward to your thoughts.

Open

tiffany.oda

Contributor ⭐️⭐️⭐️⭐️⭐️

Also voting on this and adding our use case.

Because the Salesforce integration only creates Community Members if there is an existing Contact in Salesforce, our Salesforce reporting will essentially be incomplete if not all Community Members and Activity are in Salesforce.

As such, we decided to do a weekly export of users from inSided, and use that to create the Contacts in Salesforce and thus their Community Members as well. Part of what is needed to create the Community Members is the UserId. When I went to do the User export from Control today, though, I noticed that UserId is missing. This would be very helpful to add as a column in the report.

Tiff

DannyPancratz

VIP ⭐️⭐️⭐️⭐️⭐️

FWIW, I just added two support tickets that could have been solved self-service via the API if I had UserId was in the user export. :relaxed:

FYI: I am no longer active in this community

tiffany.oda

Contributor ⭐️⭐️⭐️⭐️⭐️

This seems like it would be an easy quick-win.

Tiff

DannyPancratz

VIP ⭐️⭐️⭐️⭐️⭐️

Also voting on this and adding our use case.

Because the Salesforce integration only creates Community Members if there is an existing Contact in Salesforce, our Salesforce reporting will essentially be incomplete if not all Community Members and Activity are in Salesforce.

As such, we decided to do a weekly export of users from inSided, and use that to create the Contacts in Salesforce and thus their Community Members as well. Part of what is needed to create the Community Members is the UserId. When I went to do the User export from Control today, though, I noticed that UserId is missing. This would be very helpful to add as a column in the report.

Just seeing this use case. My tech team figured out a solve for creating contacts for those that weren’t already in Salesforce. I believe it happens right away so that the records start syncing from the beginning. If your team wants to talk to mine, send me a message and we can get it scheduled.

FYI: I am no longer active in this community

anirbandutta

Expert ⭐️

Thanks for documenting for all Cmgrs @Folkert Ziggo

Getting just the username is still pretty unusable if we wo not have the add on userID:

anirbandutta is no good unless I get the full /anirbandutta-1549 so absolutely need that.

Also in general an overall...

It's an opportunity for engagement

DannyPancratz

VIP ⭐️⭐️⭐️⭐️⭐️

FWIW, almost had to open a support ticket for something related to this again.

We solved thanks to having our SFDC integration with user ID, but it’s adding quite a bit of hassle.

With some much self-service capabilities taht can be done with the API and the API requiring user_id for a lot of things, I’m hoping this gets added soon along with my latest idea and total points:

FYI: I am no longer active in this community

DannyPancratz

VIP ⭐️⭐️⭐️⭐️⭐️

Bumping this idea again.

I encountered another use case where I would be able to solve something on my own via the API, but cannot because the user export doesn’t provide userId (required by the API).

FYI: I am no longer active in this community

Daniele Cmty

Helper ⭐️⭐️

Hi, I am bumping this again.

I need the User ID to run all my User-related Zaps (e.g. assign custom role in bulk via a google sheet) but I can’t do it unless I have the User IDs. (I use a complicated workaround to get the User ID via VLOOKUP and a Gainsight list, but I have to do that manually every single time)