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; } } }

A quick overview of group membership in your AGOL organization

Egge-Jan_Pollé · 2019-03-21T21:35:21+00:00

Do you recognize this? * "Over time our ArcGIS Online organization has grown. We have quite a few users now and a considerable number of groups has been created. Can you please provide me with a quick overview of who is member of which group?" * "Yes, I can." * "OK - and please note: not only quick, but also in Excel. Is…

Egge-Jan_Pollé

Do you recognize this?

"Over time our ArcGIS Online organization has grown. We have quite a few users now and a considerable number of groups has been created. Can you please provide me with a quick overview of who is member of which group?"
"Yes, I can."
"OK - and please note: not only quick, but also in Excel. Is that possible?"
"Eh... yeah, that is also possible."

We are going to use the ArcGIS API for Python with groups.search() and users.search() to get an overview of our organization. Next we compile a matrix - users along the y-axis and groups along the x-axis - with a 1 or a 0 to indicate wether the user is a member of the group or not. This matrix is being written to a CSV file.

And then the boss should be able to import this CSV into a colorful and manageable spreadsheet. With or without a little help.

Does the script below work for you? Just 'like' or 'share' if it does. And if you want to, you can just open your Jupyter Notebook to try it line by line.

<SPAN class="comment token">## ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</SPAN>
<SPAN class="comment token">## ArcGIS Online Management Information</SPAN>
<SPAN class="comment token">## Script: agol_group_membership.py</SPAN>
<SPAN class="comment token">## Goal: to create an overview of group membership in your ArcGIS Online organisation</SPAN>
<SPAN class="comment token">## Author: Egge-Jan Polle - Tensing GIS Consultancy</SPAN>
<SPAN class="comment token">## Date: August 3, 2018</SPAN>
<SPAN class="comment token">## ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="comment token"># This script should be run within a specific ArcGIS/Python environment using the batch file below</SPAN>
<SPAN class="comment token"># (This batch file comes with the installation of ArcGIS Pro)</SPAN>
<SPAN class="comment token"># "C:\Program Files\ArcGIS\Pro\bin\Python\scripts\propy.bat" agol_group_membership.py</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="keyword token">import</SPAN> csv<SPAN class="punctuation token">,</SPAN>os<SPAN class="punctuation token">,</SPAN> sys
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">from</SPAN> provide_credentials <SPAN class="keyword token">import</SPAN> provide_credentials

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'==================='</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'The script that is running: '</SPAN> <SPAN class="operator token">+</SPAN> __file__<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'First you have to log in to ArcGIS Online'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Log in</SPAN>
username<SPAN class="punctuation token">,</SPAN> password <SPAN class="operator token">=</SPAN> provide_credentials<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
my_agol <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"https://www.arcgis.com"</SPAN><SPAN class="punctuation token">,</SPAN> username<SPAN class="punctuation token">,</SPAN> password<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Start: "</SPAN><SPAN class="operator token">+</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%c'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">## Get all groups</SPAN>
my_groups <SPAN class="operator token">=</SPAN> my_agol<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## Optionally: have a look at all groups</SPAN>
<SPAN class="comment token">#my_groups</SPAN>
<SPAN class="comment token">## Optionally: count the number of groups</SPAN>
<SPAN class="comment token">#len(my_groups)</SPAN>

<SPAN class="comment token">## Get all users</SPAN>
my_users <SPAN class="operator token">=</SPAN> my_agol<SPAN class="punctuation token">.</SPAN>users<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN>max_users <SPAN class="operator token">=</SPAN> <SPAN class="number token">350</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># The default of max_users = 100, so increase it if you have more</SPAN>
<SPAN class="comment token">## Optionally: have a look at all users</SPAN>
<SPAN class="comment token">#my_users</SPAN>
<SPAN class="comment token">## Optionally: count the number of users</SPAN>
<SPAN class="comment token">#len(my_users)</SPAN>

<SPAN class="comment token">## Create a list with all group titles</SPAN>
my_group_titles <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> my_group <SPAN class="keyword token">in</SPAN> my_groups<SPAN class="punctuation token">:</SPAN>
    my_group_titles<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>my_group<SPAN class="punctuation token">.</SPAN>title<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">## Create a list with field names</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USERNAME'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EMAIL'</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> title <SPAN class="keyword token">in</SPAN> my_group_titles<SPAN class="punctuation token">:</SPAN>
    fieldnames<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>title<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## Optionally: have a look at the field names</SPAN>
<SPAN class="comment token">#fieldnames</SPAN>

<SPAN class="comment token">## Create a CSV file with a matrix of the groups with their members</SPAN>
today <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%Y%m%d'</SPAN><SPAN class="punctuation token">)</SPAN>
fname <SPAN class="operator token">=</SPAN> <SPAN class="string token">'AGOL_Group_Membership'</SPAN><SPAN class="operator token">+</SPAN>today<SPAN class="operator token">+</SPAN><SPAN class="string token">'.csv'</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
    os<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> OSError<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">pass</SPAN>
outfile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">)</SPAN>
writer <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>DictWriter<SPAN class="punctuation token">(</SPAN>outfile<SPAN class="punctuation token">,</SPAN> delimiter <SPAN class="operator token">=</SPAN> <SPAN class="string token">';'</SPAN><SPAN class="punctuation token">,</SPAN> lineterminator<SPAN class="operator token">=</SPAN><SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">,</SPAN> fieldnames<SPAN class="operator token">=</SPAN>fieldnames<SPAN class="punctuation token">)</SPAN>
writer<SPAN class="punctuation token">.</SPAN>writeheader<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## Add for each user the full name and email and for each group a 1 or 0, depending on group membership</SPAN>
<SPAN class="keyword token">for</SPAN> user <SPAN class="keyword token">in</SPAN> my_users<SPAN class="punctuation token">:</SPAN>
    membership <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
        thisUser <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
        thisUser<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USERNAME'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> user<SPAN class="punctuation token">.</SPAN>fullName
        thisUser<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EMAIL'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> user<SPAN class="punctuation token">.</SPAN>email
        
        <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># Group membership outside the organisation will raise an error ("You do not have permissions to access this resource or perform this operation.")</SPAN>
            <SPAN class="keyword token">for</SPAN> group <SPAN class="keyword token">in</SPAN> user<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">:</SPAN>
                membership<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>group<SPAN class="punctuation token">.</SPAN>title<SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">pass</SPAN>
        <SPAN class="keyword token">for</SPAN> title <SPAN class="keyword token">in</SPAN> my_group_titles<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">if</SPAN> title <SPAN class="keyword token">in</SPAN> membership<SPAN class="punctuation token">:</SPAN>
                thisUser<SPAN class="punctuation token">[</SPAN>title<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
            <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
                thisUser<SPAN class="punctuation token">[</SPAN>title<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
    <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"PLEASE NOTE: no information can be retrieved about user "</SPAN><SPAN class="operator token">+</SPAN>user<SPAN class="punctuation token">.</SPAN>fullName<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">pass</SPAN>
    writer<SPAN class="punctuation token">.</SPAN>writerow<SPAN class="punctuation token">(</SPAN>thisUser<SPAN class="punctuation token">)</SPAN>
outfile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Ready: "</SPAN><SPAN class="operator token">+</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%c'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'==================='</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'The CSV file can be found here:'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>abspath<SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'==================='</SPAN><SPAN class="punctuation token">)</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>‍</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><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And here is the provide_credentials script which is used above to login to AGOL:

<SPAN class="keyword token">import</SPAN> json<SPAN class="punctuation token">,</SPAN> os
<SPAN class="keyword token">from</SPAN> getpass <SPAN class="keyword token">import</SPAN> getpass <SPAN class="comment token">#to accept passwords in an interactive fashion</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">provide_credentials</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    file_with_credentials <SPAN class="operator token">=</SPAN> <SPAN class="string token">'my_credentials.json'</SPAN>
    username <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN>
    password <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN>
    <SPAN class="keyword token">if</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>exists<SPAN class="punctuation token">(</SPAN>file_with_credentials<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>file_with_credentials<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> f<SPAN class="punctuation token">:</SPAN>
            data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">)</SPAN>
            username <SPAN class="operator token">=</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'username'</SPAN><SPAN class="punctuation token">]</SPAN>
            password <SPAN class="operator token">=</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> username <SPAN class="operator token">or</SPAN> username <SPAN class="operator token">==</SPAN> <SPAN class="string token">'USERNAME'</SPAN> <SPAN class="operator token">or</SPAN> <SPAN class="operator token">not</SPAN> password <SPAN class="operator token">or</SPAN> password <SPAN class="operator token">==</SPAN> <SPAN class="string token">'PASSWORD'</SPAN><SPAN class="punctuation token">:</SPAN>
        username <SPAN class="operator token">=</SPAN> input<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Please enter your username: '</SPAN><SPAN class="punctuation token">)</SPAN>
        password <SPAN class="operator token">=</SPAN> getpass<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Please enter your password (this will remain invisible): '</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> username<SPAN class="punctuation token">,</SPAN> password<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>

With the input file my_credentials.json:

<SPAN class="punctuation token">{</SPAN>
	<SPAN class="string token">"username"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"USERNAME"</SPAN><SPAN class="punctuation token">,</SPAN>
	<SPAN class="string token">"password"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"PASSWORD"</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Happy coding!

Egge-Jan

Find more posts tagged with

Comments

JeffTimm

Forgive my ignorance but where in the world would

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">print</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>os<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>path<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>abspath<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>fname<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>

be if I ran this on and Enterprise Notebook?

I ran this with no errors and it said:

=================== The CSV file can be found here: /arcgis/AGOL_Group_Membership20200416.csv ===================

But I cannot find this file

Egge-Jan_Pollé

Hi Jeff Timm,

Has the file not just been created in the same folder where the Python script resides?

BR,

Egge-Jan

Katie_Clark

Egge-Jan Pollé‌, this seems extremely useful, and I really appreciate you sharing! This is the type of more advanced GIS work (utilizing the API's) that I want to get in to, but for someone who is a complete newbie, I'm a bit unclear where to start. I've written/modified scripts to use in geoprocessing, but never involving multiple python files or interacting with my Organization account. Do you think you could go into a bit more detail how to approach this? (also, does this script work with both AGOL and Enterprise accounts?)

I created the JSON file and two separate .PY scripts from the code you provided, all in the same folder. Then I added the "agol_group_membership.py" script to a toolbox in ArcGIS Pro and attempted to run the tool. This is the error message I got:

Obviously I'm just not understanding how to set it up correctly. I know it's a lot to ask, but if you could at least maybe share a resource that helps explain how to get started with this stuff that would be SO helpful!

Wishing you all the best,

Katherine

Egge-Jan_Pollé

Hi Katherine Clark,

Please have a look at the screen capture of the DOSBox below.

I did create a new folder on my C:\-drive specifically for this test (Yes, the folder is called Katherine :-))
In this folder I placed the two files agol_group_membership.py and provide_credentials.py (for the content of these files, see code in post above)
And then I did run the following command: "C:\Program Files\ArcGIS\Pro\bin\Python\scripts\propy.bat" agol_group_membership.py

Please note: It is very important to run this script in combination with the bat file mentioned to make sure you run it in the correct ArcGIS/Python environment (This batch file comes with the installation of ArcGIS Pro). Without making sure you use this correct environment the script will fail anyway...

Please let me know if this works for you.

Stay safe, stay home - have a nice weekend.

Egge-Jan

Katie_Clark

Thank you! I got it to run once I changed the credentials in the JSON to be my ArcGIS Online login rather than my Enterprise login (is there a way to make this work with Enterprise?)

Strangely, I did receive these messages about not having permissions:

However, there was a csv produced in the same folder where the scripts are stored, as expected. The only bad part....the csv has different rows for each user, but no column separations. Have you experienced this before?

Katie_Clark

Update: I was able to correct the csv file by using the "Text to Columns" tool in the Data tab of the Excel Ribbon since all the values were neatly separated by semi colons.

However, still curious if this is expected behavior for the output of the script.

Anonymous User

Dumb question. I wanted to find documentation about this:

"gis.users.search(max_count=...)"

Where would I find it? The answer will be embarrassing, but I can't find it. I've searched the ArcGIS API for python documentation and I don't see an explanation of this property.

I was getting a list of users and did not realize there was a limit of 100 returned and was getting extremely frustrated with the results, wondering why they were incomplete. I found your post and discovered the "max_count" property, and am now wondering how I could go straight to the source and find such information more directly.

Thank you,

Randy McGregor

ErikLash_HiCo

Easiest way to get it to get it to automatically open in Excel as a table is to change the delimiter to a comma from a semi colon. Since we can use whatever delimeters we wish the decision on what to include here is based on the needs of the client application that will be consuming the output.

ErikLash_HiCo

Not sure if anyone answered your question regarding making it work with Enterprise.

The answer is yes it will work with any 'portal' of whether that portal is enterprise on premesis, cloud, or arcgisonline.

Just enter the details of the portal under the login comment at the top.

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># Log in</SPAN>
username<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> password <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> provide_credentials<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>
my_agol <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> GIS<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;"><SPAN style="border: 0px; font-weight: inherit;"><SPAN>"</SPAN><A _jive_internal="true" href="https://community.esri.com/yourEnterprise.com/PortalWebadaptor" target="_blank">https://yourEnterprise.com/PortalWebadaptor</A></SPAN><SPAN style="border: 0px; font-weight: inherit;">"</SPAN></SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> username<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> password<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>

If the variable name "my_agol" seems a bit like a mental roadblock, you can rename it throughout the script to something like "my_portal".

Egge-Jan shared a highly adaptable and fantastically useful nugget of code here that makes short work of pulling info into spreadsheets about users and groups.

If like me you want the code to work on all your portals without much modification there are a few things you can do such as automatically naming your output csv by pulling the portal name directly via implementation of "my_portal.properties.portalName" in the fname= variable.

DataOfficer

Could anyone suggest how this could be modified to list users within the Groups, where those users are not from the same organisation? I can get it to list our organisation's users and their Group memberships, but it excludes the hundreds of users we have in those Groups within our hub community organisation.

Many thanks.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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