Latest Contributions by WilliamCraft

When attempting to generate a token using an enterprise account (which I believe you said does not work currently), are you specifying the domain in conjunction with the username?  For example, [email protected].   ... View more

Can you tell me the name of your web adaptors?  Is the web adaptor for Portal named 'arcgis'?  If so, what is the name of your ArcGIS Server web adaptor?  I'm just wanting to understand the URL scheme you've mentioned earlier in terms of what is working versus not.   ... View more

Thank you.  For question #4, I'm talking specifically about the configuration within IIS.  How are both of your web adaptors (Portal and Server) configured in terms of anonymous and Windows authentication?   ... View more

A few questions... What version of the software are you using? Is there Federation between ArcGIS Server and Portal? For enterprise users, are you using SAML integration, LDAP, or IWA? What are the current authentication settings for your Portal and ArcGIS Server web adaptors?  (anonymous vs Windows) Are you able to log into ArcGIS Server Admin using non-PSA accounts? ... View more

Interesting.  And you're absolutely sure there isn't already a user in AGOL named 'DemoUser'?  If not, I'm out of ideas.   ... View more

Also, according to the documentation, the required user_type parameter value must either be 'creator' or 'viewer'.   ... View more

Yes, your syntax does appear to be correct.  Can you remove all of the parameters in your create command that follow the role='org_user' portion?  You might try trimming that section down a bit to get to the bare minimum parameters required for creating a user.  It's possible that some of those parameters don't apply to AGOL; only to Portal.   ... View more

Can you provide a bit more of the preceeding code to give a bit more context so we can see where you create the GIS object?   ... View more

After making the change, did you close and re-open ArcGIS Desktop?    ... View more

Change the column definition from VARCHAR(MAX) to something else with a suitable length such as VARCHAR(100).  Let me know if it works after that.   ... View more

If the field is a VARCHAR, then you can have up to 8000 characters.  Check to see if the column definition uses VARCHAR(MAX).  If it does, try using a limited size rather than MAX.  What version of SQL Server are you using?  There is a limitation in SQL Server (depending on the version) that VARCHAR(MAX) and NVARCHAR(MAX) cannot be used in indices.  Instead, a fixed length must be used to make it eligible for use in the index. ... View more

The best example I can find is this video.  It's not manufacturing specific (I couldn't find one like that), but it gets the point across in a short-lived amount of time.   ... View more

I was able to accomplish setting the Time Zone name (i.e., the 'dateFieldsTimezoneID' property) using the script below.  I also set the 'dateFieldsRespectsDayLightSavingsTime' property to True at the same time.  This script iterates through all map services and makes the adjustments, but you could adapt this for publishing as well.   import requests, urllib, ssl, json, arcpy, sys context = ssl._create_unverified_context() baseURL = "https://<server_name>:6443/arcgis" userName = "admin" passWord = "password" timeZone = "Central Standard Time" # Get the token parameters = urllib.parse.urlencode({'username' : userName, 'password' : passWord, 'client' : 'requestip', 'expiration': 60, 'f' : 'json'}).encode("utf-8") response = urllib.request.urlopen(baseURL + '/admin/generateToken?',parameters, context=context).read() jsonResponse = json.loads(response) token = jsonResponse['token'] # Loop through services within folders and set Time Zone value params = {'f': 'json', 'token': token} req = urllib.request.Request(baseURL + '/admin/services?f=pjson', urllib.parse.urlencode(params).encode("utf-8")) response = urllib.request.urlopen(req, context=context) data = json.load(response) for d in data['foldersDetail']: folderName = d['folderName'] if folderName != 'System' and folderName != 'Utilities': req = urllib.request.Request(baseURL + '/admin/services/' + folderName + '?f=pjson', urllib.parse.urlencode(params).encode("utf-8")) response = urllib.request.urlopen(req, context=context) data = json.load(response) for i in data['services']: serviceName = i['serviceName'] arcpy.AddMessage("Modifying " + folderName + "/" + serviceName + "...") req = urllib.request.Request(baseURL + '/admin/services/' + i['folderName'] + '/' + serviceName + '.MapServer?f=pjson', urllib.parse.urlencode(params).encode("utf-8")) response = urllib.request.urlopen(req, context=context) data = json.load(response) try: dateFieldsTimezoneID = data['properties']['dateFieldsTimezoneID'] except: dateFieldsTimezoneID = "" data["properties"]["dateFieldsTimezoneID"] = timeZone data["properties"]["dateFieldsRespectsDayLightSavingTime"] = "true" updatedSvcJson = json.dumps(data) editSvcURL = baseURL + '/admin/services/' + i['folderName'] + '/' + serviceName + '.MapServer/edit' headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} params = urllib.parse.urlencode({'token':token, 'f': 'json', 'service': updatedSvcJson}) r = requests.post(editSvcURL, params, headers = headers, verify = False) # Loop through services within the root folder and set Time Zone value params = {'f': 'json', 'token': token} req = urllib.request.Request(baseURL + '/admin/services?f=pjson', urllib.parse.urlencode(params).encode("utf-8")) response = urllib.request.urlopen(req, context=context) data = json.load(response) for i in data['services']: if i['type'] == 'MapServer': serviceName = i['serviceName'] arcpy.AddMessage("Modifying " + "root/" + serviceName + "...") req = urllib.request.Request(baseURL + '/admin/services/' + serviceName + '.MapServer?f=pjson', urllib.parse.urlencode(params).encode("utf-8")) response = urllib.request.urlopen(req, context=context) data = json.load(response) try: dateFieldsTimezoneID = data['properties']['dateFieldsTimezoneID'] except: dateFieldsTimezoneID = "" data["properties"]["dateFieldsTimezoneID"] = timeZone data["properties"]["dateFieldsRespectsDayLightSavingTime"] = "true" updatedSvcJson = json.dumps(data) editSvcURL = baseURL + '/admin/services/' + serviceName + '.MapServer/edit' headers = {"Content-type": "application/x-www-form-urlencoded", "Accept": "text/plain"} params = urllib.parse.urlencode({'token':token, 'f': 'json', 'service': updatedSvcJson}) r = requests.post(editSvcURL, params, headers = headers, verify = False)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more