Export list of users out of uStore

[StevensIS XMPie Team]

Hi All,

I'm trying to export a list or database of users who belong to a specific group (or just a list of all uStore users), but it doesn't appear to be an option in uStore Back Office. Am I missing something? Seems like this should be super easy to do :)

We are on uStore 7.3, if that makes any difference.

Thanks!

[Guillaume Besnier]

In uStore Admin 7.3, there indeed isn't any tool available to export Users.
Feel free to send a Feature Request to the editor.
Meanwhile, if you have the uStore API and some development resource with you, consider using the UserGroupWS.GetUserListByGroup method.

---

Expéditeur : StevensIS XMPie Team <stevensx...@gmail.com>
Date de réception : Mercredi, Octobre 16, 2013 11:11PM
Destinataire : xmpie...@googlegroups.com
Sujet : [xmpie-users] Export list of users out of uStore

 

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users...@googlegroups.com.
To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at http://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/groups/opt_out.

[Mark Cini]

Hi Steven,

In addition to Guillaume's suggestion, you could create a Report in uStore to export a list of Users who belong to a group.

There are two parts to that Report. A Report Parameter called UserGroup which allows you to choose a Group, which uses the following SQL:

SELECT 'Name' = ACL.[Name], 

'Value' = ACL.UserGroupId,

'Selected' = 0

        FROM [uStore].[dbo].[ACL_UserGroup] ACL

And the actual Report which uses the following SQL:

SELECT U.[UserID]

      ,[FirstName]

      ,[LastName]

      ,[Email]

       FROM [uStore].[dbo].[Users] U

  join [uStore].[dbo].[ACL_UserGroupMembership] UG on UG.[UserId] = U.[UserID]

  where [StatusID] = 1

  and UG.[UserGroupId] = @UserGroup

This could obviously be tweaked for your needs. If you're unsure how to setup a report, I'd suggest speaking to XMPie support and they should be able to assist.

Regards,

Mark.

[StevensIS XMPie Team]

Thanks, both of you! I'm not at the point where I can do API development, but I was able to create that report which does exactly what I needed. I really appreciate the tip.

Expéditeur : StevensIS XMPie Team <stevens...@gmail.com>

Date de réception : Mercredi, Octobre 16, 2013 11:11PM
Destinataire : xmpie...@googlegroups.com
Sujet : [xmpie-users] Export list of users out of uStore

 

Hi All,

I'm trying to export a list or database of users who belong to a specific group (or just a list of all uStore users), but it doesn't appear to be an option in uStore Back Office. Am I missing something? Seems like this should be super easy to do :)

We are on uStore 7.3, if that makes any difference.

Thanks!

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users...@googlegroups.com.
To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at http://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/groups/opt_out.