Hi everbody, I want to export from gis.user.search() the json array "groups". Here some Information about the "groups": arcgis.gis module — arcgis 1.6.1 documentation How can I see the groups from user? Thanks . from arcgis . gis import GIS import arcgis import json gis = GIS ( "url_to_portal" , "admin_user" , "password" ) user_accounts = gis . users . search ( ) group = gis . groups . search ( ) for user in ( str ( user_accounts . groups ) ) : liste = { } user = json . loads ( user_accounts . groups ) print ( user ) else : print ( "isn't working so far" ) #Error Msg - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - AttributeError Traceback ( most recent call last ) ipython - input -18 - 57b3d16d2703 > in module > 19 - - - > 20 for user in ( str ( user_accounts . groups ) ) : 21 liste = { } AttributeError : 'list' object has no attribute 'groups'

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export gis.user.groups from portal

ShukwaunCheung

Hi everbody,

I want to export from gis.user.search() the json array "groups".

Here some Information about the "groups": arcgis.gis module — arcgis 1.6.1 documentation

How can I see the groups from user?

Thanks .

<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">import</SPAN> arcgis
<SPAN class="keyword token">import</SPAN> json

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"url_to_portal"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"admin_user"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"password"</SPAN><SPAN class="punctuation token">)</SPAN>

user_accounts <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>users<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
group <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> user <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>user_accounts<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    liste <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
    user <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>user_accounts<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>user<SPAN class="punctuation token">)</SPAN>
   
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"isn't working so far"</SPAN><SPAN class="punctuation token">)</SPAN>
	
	
	
<SPAN class="comment token">#Error Msg</SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
AttributeError                            Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token"><</SPAN>ipython<SPAN class="operator token">-</SPAN>input<SPAN class="number token">-18</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">57b3d16d2703</SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
     <SPAN class="number token">19</SPAN> 
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN> <SPAN class="number token">20</SPAN> <SPAN class="keyword token">for</SPAN> user <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>user_accounts<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
     <SPAN class="number token">21</SPAN>     liste <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>

AttributeError<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'list'</SPAN> object has no attribute <SPAN class="string token">'groups'</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trouver plus de publications taguées avec

Accepted answers

Clubdebambos

Hi @chill_gis_dude

Here's an implementation, code is commented. I have an issue with accessing some users' groups.

from arcgis import GIS
import csv

## connect to agol/portal
agol = GIS("home")

## csv filepath for file creation/overwrite 
csv_filepath = r"path\to\user_groups.csv"

## get a list of user objects
users = agol.users.search(max_users=1000)

## create/overwite csv
with open(csv_filepath, 'w', newline="") as csv_file:
    writer = csv.writer(csv_file)
    ## write the header
    writer.writerow(["username", "email", "groups"])
    ## iterate through users
    for user in users:
        print(user)
        ## write a new row with info per user
        try:
            groups = ",".join([group.title for group in user.groups])
            new_row = [user.username, user.email, groups]
            writer.writerow(new_row)
        ## i have instances where I cant seem to access a users groups
        ## you may or may not encounter this issue
        except:
            new_row = [user.username, "", ""]
            writer.writerow(new_row)
            print("\t FAILED")

## save the file
csv_file.close()

All comments

Clubdebambos

Hi @chill_gis_dude

Here's an implementation, code is commented. I have an issue with accessing some users' groups.

from arcgis import GIS
import csv

## connect to agol/portal
agol = GIS("home")

## csv filepath for file creation/overwrite 
csv_filepath = r"path\to\user_groups.csv"

## get a list of user objects
users = agol.users.search(max_users=1000)

## create/overwite csv
with open(csv_filepath, 'w', newline="") as csv_file:
    writer = csv.writer(csv_file)
    ## write the header
    writer.writerow(["username", "email", "groups"])
    ## iterate through users
    for user in users:
        print(user)
        ## write a new row with info per user
        try:
            groups = ",".join([group.title for group in user.groups])
            new_row = [user.username, user.email, groups]
            writer.writerow(new_row)
        ## i have instances where I cant seem to access a users groups
        ## you may or may not encounter this issue
        except:
            new_row = [user.username, "", ""]
            writer.writerow(new_row)
            print("\t FAILED")

## save the file
csv_file.close()

chill_gis_dude

Were you ever able to figure this one out?

ShukwaunCheung

Hi Egge-Jan Pollé,

thank you for your help.
I was able to create a CSV with help of your script, in which I could see the users with all available groups. Each user had a zero as a result for each group, which means that this user is not in this group. Later I invited a user to a group, I got a one in the whole table as result. I know that there should be serveral ones. 😕
My aim was to list each user's groups in a column with a comma as seperater.

What I got:

What I got

What I want:

Whats I want

some Ideas?

Egge-Jan_Pollé

Hi Shukwaun Cheung‌,

You might have a look at a Python script which I have published here:

https://community.esri.com/people/EPolle_TensingInternational/blog/2019/03/21/a-quick-overview-of-group-membership-in-your-agol-organization

Does this serve your purposes?

Cheers,

Egge-Jan

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.