Create users and roles from a CSV file

chill_gis_dude — Thu, 12 Oct 2023 18:39:09 GMT

I am trying to work through the code example to bulk add users with csv on this page:

https://enterprise.arcgis.com/en/server/10.8/administer/windows/example-create-users-and-roles-from-a-csv-file.htm

The code has not been updated from python 2 to python 3 and I am getting stuck on this error message:

gaierror: [Errno 11001] getaddrinfo failed

The code is below as well

# This script creates a bank of users and roles given a comma-separated text file # They should be listed in the following format and saved in a file with a .txt extension: # # User,Role,RoleType,Password,EMail,FullName,Description # John,Admins,ADMINISTER,changeme,johndoe@esri.com,John Doe,Server admin # Jane,Publishers,PUBLISH,changeme,janedoe@esri.com,Jane Doe,Server publisher # Etc. import json, urllib,httplib # For system tools import sys # For reading passwords without echoing import getpass def main(argv=None): # Ask for admin/publisher user name and password username = raw_input("Enter user name: ") password = getpass.getpass("Enter password: ") # Ask for server name & port serverName = raw_input("Enter server name: ") serverPort = 6080 # Input File with the Role and user information inFile = raw_input("Path to comma-delimited text file containing users and roles: ") # InFile = r"C:\testing\agsUsersRoles.txt" opnFile = open(inFile,'r') # Dictionaries to store user and role information roles = {} users = {} addUserRole = {} # Read the next line ln = opnFile.readline() # Counter to get through the column header of the input file num = 0 while ln: if num == 0: pass # File header else: # Split the current line into list lnSplt = ln.split(",") # Build the Dictionary to add the roles roles[lnSplt[1]] = {lnSplt[2]:lnSplt[len(lnSplt) -1].rstrip()} # Add the user information to a dictionary users["user" + str(num)] = {"username":lnSplt[0],"password":lnSplt[3],"fullname":lnSplt[5],"email":lnSplt[4],"description":lnSplt[-1].rstrip()} # Store the user and role type in a dictionary if addUserRole.has_key(lnSplt[1]): addUserRole[lnSplt[1]] = addUserRole[lnSplt[1]] + "," + lnSplt[0] else: addUserRole[lnSplt[1]] = lnSplt[0] # Prepare to move to the next line ln = opnFile.readline() num +=1 # Get a token and connect token = getToken(username, password,serverName,serverPort) if token == "": sys.exit(1) # Call helper functions to add users and roles addRoles(roles, token,serverName,serverPort) addUsers(users,token,serverName,serverPort) addUserToRoles(addUserRole,token,serverName,serverPort) def addRoles(roleDict, token, serverName, serverPort): for item in roleDict.keys(): # Build the dictionary with the role name and description roleToAdd = {"rolename":item} # Load the response jsRole = json.dumps(roleToAdd) # URL for adding a role addroleURL = "/arcgis/admin/security/roles/add" params = urllib.urlencode({'token':token,'f':'json','Role':jsRole}) headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} # Build the connection to add the roles to the server httpRoleConn = httplib.HTTPConnection(serverName, serverPort) httpRoleConn.request("POST",addroleURL,params,headers) response = httpRoleConn.getresponse() if (response.status != 200): httpRoleConn.close() print "Could not add role." return else: data = response.read() # Check that data returned is not an error object if not assertJsonSuccess(data): print "Error when adding role. " + str(data) return else: print "Added role successfully" httpRoleConn.close() # Assign a privilege to the recently added role assignAdminUrl = "/arcgis/admin/security/roles/assignPrivilege" params = urllib.urlencode({'token':token,'f':'json',"rolename":item, "privilege":roleDict[item].keys()[0]}) headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} # Build the connection to assign the privilege httpRoleAdminConn = httplib.HTTPConnection(serverName, serverPort) httpRoleAdminConn.request("POST",assignAdminUrl,params,headers) response = httpRoleAdminConn.getresponse() if (response.status != 200): httpRoleAdminConn.close() print "Could not assign privilege to role." return else: data = response.read() # Check that data returned is not an error object if not assertJsonSuccess(data): print "Error when assigning privileges to role. " + str(data) return else: print "Assigned privileges to role successfully" httpRoleAdminConn.close() def addUsers(userDict,token, serverName, serverPort): for userAdd in userDict: jsUser = json.dumps(userDict[userAdd]) # URL for adding a user addUserURL = "/arcgis/admin/security/users/add" params = urllib.urlencode({'token':token,'f':'json','user':jsUser}) headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} # Build the connection to add the users httpRoleConn = httplib.HTTPConnection(serverName, serverPort) httpRoleConn.request("POST",addUserURL,params,headers) httpRoleConn.close() def addUserToRoles(userRoleDict,token, serverName, serverPort): for userRole in userRoleDict.keys(): # Using the current role build the URL to assign the right users to the role addUserURL = "/arcgis/admin/security/roles/addUsersToRole" params = urllib.urlencode({'token':token,'f':'json',"rolename":userRole,"users":userRoleDict[userRole]}) headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} # Build the connection httpRoleConn = httplib.HTTPConnection(serverName, serverPort) httpRoleConn.request("POST",addUserURL,params,headers) response = httpRoleConn.getresponse() if (response.status != 200): httpRoleConn.close() print "Could not add user to role." return else: data = response.read() # Check that data returned is not an error object if not assertJsonSuccess(data): print "Error when adding user to role. " + str(data) return else: print "Added user to role successfully" httpRoleConn.close() def getToken(username, password, serverName, serverPort): # Token URL is typically http://server[:port]/arcgis/admin/generateToken tokenURL = "/arcgis/admin/generateToken" params = urllib.urlencode({'username': username, 'password': password,'client': 'requestip', 'f': 'json'}) headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} # Connect to URL and post parameters httpConn = httplib.HTTPConnection(serverName, serverPort) httpConn.request("POST", tokenURL, params, headers) # Read response response = httpConn.getresponse() if (response.status != 200): httpConn.close() print "Error while fetching tokens from admin URL. Please check the URL and try again." return else: data = response.read() httpConn.close() # Check that data returned is not an error object if not assertJsonSuccess(data): return # Extract the token from it token = json.loads(data) return token['token'] # A function that checks that the input JSON object # is not an error object. def assertJsonSuccess(data): obj = json.loads(data) if 'status' in obj and obj['status'] == "error": print "Error: JSON object returns an error. " + str(obj) return False else: return True # Script start if __name__ == "__main__": sys.exit(main(sys.argv[1:]))

Re: Create users and roles from a CSV file

David_McRitchie — Fri, 20 Oct 2023 16:34:42 GMT

Hey George,

For what version of Enterprise is this for? The documentation is for version 10.8.1 so this might be where we are hitting the error.

The following sample might be more useful if you are using a version later than 10.8.1.

Hope that helps,

David

Re: Create users and roles from a CSV file

SGTomlins — Fri, 23 Feb 2024 18:11:43 GMT

I hacked this to work with 3.7....

Now I get the follwing error... 😞

fumbling thru an example... i am..

File "C:\SGT\ESRI\Python\ArcGIS Enterprise\AddUserToEntPortal-fumblethru.py", line 58, in generateToken
if responseJSON.has_key('error'):
AttributeError: 'dict' object has no attribute 'has_key'

# Requires Python 2.7+

# Demonstrates how to add users to the ArcGIS Enterprise portal in bulk

# For Http calls
import urllib3, urllib, json
import urllib.parse
import urllib.response
from urllib.request import urlopen

from notebook.notebookapp import raw_input

# This function connects to the portal and adds members to it from a collection
# def createUsers(username,password, portalUrl, provider,userParamsQ):
# ## these are the tinkerbell-az server credentials: DEVELOPMENT server
username = "sitdg5g45634min"
password = "fdghfdghfdghfdghfdghv"
portalUrl = "https://tinkerbell-az.ci.janesville.wi.us/devportal"
serverUrl = "https://tinkerbell-az.ci.janesville.wi.us/devserver/admin"

# This function gets a token from the portal
#def generateToken(username, password, serverUrl, json_obj=None):
def generateToken(username, password, serverUrl):
parameters = urllib.parse.urlencode({'username' : username,
'password' : password,
'client' : 'referer',
'referer': portalUrl,
'expiration': 600,
'f' : 'json'})
pmans = parameters.encode('utf-8')
try:
#response = urllib3.urlopen(portalUrl + '/sharing/rest/generateToken?', parameters).read()
response = urllib.request.urlopen(serverUrl + '/generateToken?', pmans)
#response = urllib.request.urlopen(serverUrl + '/generateToken?', pmans).read()
responsestring = response.read().decode('utf-8')
json_obj = json.loads(responsestring)
#print('this is the response :' + json_obj)

except Exception as e:
#raise SystemExit( 'Unable to open the url %s/sharing/rest/generateToken' % (portalUrl))
raise SystemExit('Unable to open the url %s/' % (serverUrl))
# responseJSON = json.loads(response.strip(' \t\n\r'))

responseJSON = json.loads(responsestring)

#content = json.loads(r.decode('utf-8').replace('\n', ''))

# Log results
if responseJSON.has_key('error'):
errDict = responseJSON['error']
if int(errDict['code'])==498:
message = 'Token Expired. Getting new token... '
token = generateToken(username,password, serverUrl)
else:
message = 'Error Code: %s \n Message: %s' % (errDict['code'],
errDict['message'])
raise SystemExit(message)
token = responseJSON.get('token')
return token

print('...Connecting to ' + portalUrl)
token = generateToken(username,password, serverUrl)
print('...Adding users ')

topic Re: Create users and roles from a CSV file in ArcGIS API for Python Questions

Create users and roles from a CSV file

Re: Create users and roles from a CSV file

Re: Create users and roles from a CSV file