topic Re: Setting the Time Zone when publishing Map Service via ArcPy? in ArcGIS Pro Questions

Setting the Time Zone when publishing Map Service via ArcPy?

RandyKreuziger — Sat, 11 Dec 2021 17:06:00 GMT

We are using a bare bones ArcPy Script from the ESRI site to publish Map Services from ArcGIS Pro projects. When publishing, the default Time Zone is none but we want it changed to Pacific Time with values adjusted for daylight savings. Is there a way to do this when using arcpy when publishing?

for m in aprx.listMaps():
    if mapNames == "ALL" or mapNames == m.name:
        AddMsgAndPrint("Map: " + m.name)
        serviceName = m.name    
        SDPath = os.path.join(tempPath, serviceName + ".sd")
    
        # Create MapServiceDraft and set service properties
        sddraft = arcpy.sharing.CreateSharingDraft('STANDALONE_SERVER', 'MAP_SERVICE', serviceName, m)
        sddraft.targetServer = server_con
        sddraft.serverFolder = serverFolder
        # copyDataToServer = False will reference data from registered data sources with the targetServer
        sddraft.copyDataToServer = False
        sddraft.exportToSDDraft(SDdraftPath)
        
        # Read the contents of the original SDDraft into an xml parser
        doc = DOM.parse(SDdraftPath)
        
        # The follow code piece modifies the SDDraft from a new MapService with caching capabilities
        # to a FeatureService with Map, Create and Query capabilities.
        typeNames = doc.getElementsByTagName('TypeName')
        for typeName in typeNames:
            if typeName.firstChild.data == "FeatureServer":
                extention = typeName.parentNode
                for extElement in extention.childNodes:
                    if extElement.tagName == 'Enabled':
                        extElement.firstChild.data = 'false'
        
        # Turn off caching
        configProps = doc.getElementsByTagName('ConfigurationProperties')[0]
        propArray = configProps.firstChild
        propSets = propArray.childNodes
        for propSet in propSets:
            keyValues = propSet.childNodes
            for keyValue in keyValues:
                if keyValue.tagName == 'Key':
                    if keyValue.firstChild.data == "isCached":
                        keyValue.nextSibling.firstChild.data = "false"
        
        # Write the new draft to disk
        f = open(newSDdraftPath, 'w')
        doc.writexml(f)
        f.close()
        
        # Stage the service
        arcpy.StageService_server(newSDdraftPath, SDPath)
        AddMsgAndPrint("  Staged service")
        
        # Upload the service
        arcpy.UploadServiceDefinition_server(SDPath, server_con)
        AddMsgAndPrint("  Uploaded service")
        
        # Delete drafts
        Cleanup(SDdraftPath)
        Cleanup(newSDdraftPath)
        Cleanup(SDPath)
        AddMsgAndPrint("  Removed temp files")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Setting the Time Zone when publishing Map Service via ArcPy?

AngelaDeegan — Wed, 21 Aug 2019 16:21:39 GMT

Would love to have an answer to this question. Since enabling editor tracking in our Enterprise database (using database time) we are unable to get the arcpy.StageService_server command to run successfully. We can publish a map just fine via the ArcGIS Pro GUI (with time set to UTC-08:00 and the Daylight savings time box checked). But when we try to automate this using a script, it fails every time with the following error:

arcgisscripting.ExecuteError: ERROR 001272: Analyzer errors were encountered ([{"code":"00129","message":"Map has layers and tables that record Editor Tracking dates in database time zone, but time zone has not been defined","object":"Viewer - Meter Reading"}]).

Failed to execute (StageService).

Re: Setting the Time Zone when publishing Map Service via ArcPy?

JulieEckman1 — Tue, 27 Aug 2019 14:56:31 GMT

I would like an answer to this issue also. I have editor tracking enabled in my feature table and its two associated relation tables being used in ArcGIS Pro. Even though I set up the feature table's time with Pacific, I can't seem to do the same for the relation tables (no time available in their properties). I am trying to create a web map in either ArcGIS Online or in our own portal and I run into the same error which needs to be fixed before it can be shared as a web map. Removing the tracking fields is not an option.

Re: Setting the Time Zone when publishing Map Service via ArcPy?

GaryChristensen1 — Tue, 31 Dec 2019 19:48:55 GMT

Angela,

Did you find an answer or work around to this? I would also like to overwrite a Feature Service while keeping the editor tracking enabled.

Re: Setting the Time Zone when publishing Map Service via ArcPy?

ThomasColson — Mon, 10 Feb 2020 12:37:22 GMT

Did you figure this out? We have a script to auto-update a service where display of time stamps in the correct time zone is critical.

Re: Setting the Time Zone when publishing Map Service via ArcPy?

ThomasColson — Mon, 10 Feb 2020 16:07:04 GMT

ENH-000128370: Provide a timezone parameter when sharing as a web layer using ArcPy

Re: Setting the Time Zone when publishing Map Service via ArcPy?

WilliamCraft — Sat, 11 Dec 2021 17:06:03 GMT

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)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Setting the Time Zone when publishing Map Service via ArcPy?

MollyWatson1 — Mon, 20 Apr 2020 16:57:30 GMT

I've tried using this example to set the time zone property for some feature services in AGOL, but I continue to get a HTTP Error 404: Not Found. Has anybody else who has used this code example experienced the 404 error and were able to troubleshoot it?

Re: Setting the Time Zone when publishing Map Service via ArcPy?

WilliamCraft — Tue, 21 Apr 2020 17:08:03 GMT

Is the 404 error in reference to the baseURL value? Post a screenshot of the full error message. My example above assumes you're using SSL so the URL is prefixed with HTTPS. Is it possible you need to use HTTP with port 6080 instead?

Re: Setting the Time Zone when publishing Map Service via ArcPy?

MollyWatson1 — Wed, 22 Apr 2020 14:05:40 GMT

Yes, I think the 404 issues was related to the baseURL value. I was actually able to find another work around so I don't need to edit the time zone properties in AGOL. We added a time stamp to our date values. When our data is uploaded to AGOL, it retains the current date instead of going backwards one date due to the difference in hours from UTC and MST. Our data just needs to have the correct date, so this process works for us for now.

Re: Setting the Time Zone when publishing Map Service via ArcPy?

RandyKreuziger1 — Tue, 01 Mar 2022 19:06:06 GMT

Original poster here, we are still looking for a way to do this via arcpy script during publishing.

Re: Setting the Time Zone when publishing Map Service via ArcPy?

James_Norquest — Wed, 31 May 2023 15:43:53 GMT

Got this figured out with the help of a coworker and ESRI. Sorry about the spacing, ill see if I can attach a file with the correct indents.

import os

import arcpy
from arcgis.gis import GIS
import xml.dom.minidom as DOM

# Function to configure properties of an extension
# soe = extension for which properties have to be added

def enable_configproperties(sddraftPath, soe, property_set):

# Read the sddraft xml.
doc = DOM.parse(sddraftPath)

# Find all elements named TypeName. This is where the server object extension
# (SOE) names are defined.
typeNames = doc.getElementsByTagName('TypeName')
for typeName in typeNames:
# Get the TypeName we want to enable.
if typeName.firstChild.data == soe:
extension = typeName.parentNode
# prp = extension.childNodes.getElementsByTagNameNS('PropertyArray')
for extElement in extension.childNodes:
if extElement.tagName == 'Definition':
for definition in extElement.childNodes:
if definition.tagName == 'ConfigurationProperties':
for config_prop in definition.childNodes:
if config_prop.tagName == 'PropertyArray':
for prop in property_set:
prop_set = doc.createElement("PropertySetProperty")
attr = doc.createAttribute("xsi:type")
attr.value = "typens:PropertySetProperty"
prop_set.setAttributeNode(attr)

prop_key = doc.createElement("Key")
txt = doc.createTextNode(prop["key"])
prop_key.appendChild(txt)
prop_set.appendChild(prop_key)

prop_value = doc.createElement("Value")
attr = doc.createAttribute("xsi:type")
attr.value = "xs:string"
prop_value.setAttributeNode(attr)
txt = doc.createTextNode(prop["value"])
prop_value.appendChild(txt)
prop_set.appendChild(prop_value)

config_prop.appendChild(prop_set)

# Write to sddraft
f = open(sddraftPath, 'w')
doc.writexml(f)
f.close()

# Specify the location of the project file
prjPath = r"C:\Users\jnorquest\Documents\ArcGIS\Projects\Overwrite\Overwrite.aprx"

# Specify the feature service name in ArcGIS Online, including the owner credentials.
sd_fs_name = "Potable"
portal = "http://www.arcgis.com"
user = "******"
password = "******"

# Set the desired sharing options. The following code sample sets the service to be shared
# only with the organization.

shrOrg = True
shrEveryone = False
shrGroups = ""

# Specify a local path for storing temporary contents to be used for publishing the
# service definition draft and service definition file.
relPath = r'C:\Users\jnorquest\Documents\ArcGIS\Projects\Overwrite'
sddraft = os.path.join(relPath, "ProjectsWUDtest.sddraft")
sd = os.path.join(relPath, "ProjectsWUDtest.sd")

# Create a new SDDraft file, and stage the draft to the SD file.
print("Creating SD file")
arcpy.env.overwriteOutput = True
prj = arcpy.mp.ArcGISProject(prjPath)
mp = prj.listMaps()[0]

sharing_draft = mp.getWebLayerSharingDraft("HOSTING_SERVER", "FEATURE", sd_fs_name)
sharing_draft.summary = "My Summary"
sharing_draft.tags = "My Tags"
sharing_draft.description = "My Description"
sharing_draft.credits = "My Credits"
sharing_draft.useLimitations = "My Use Limitations"

sharing_draft.exportToSDDraft(sddraft)

# Set timezone
property_set = [{
"key": "dateFieldsRespectsDayLightSavingTime",
"value": "true"
},
{
"key": "dateFieldsTimezoneID",
"value": "UTC"
}]
# To set time zone on hosted feature service, soe = "FeatureServer"
enable_configproperties(sddraft, soe="FeatureServer", property_set=property_set)

arcpy.StageService_server(sddraft, sd)

print("Connecting to {}".format(portal))
gis = GIS(portal, user, password)

# Find the SD, update it, publish /w overwrite and set sharing and metadata
print("Search for original SD on portal…")
print(f"Query: {sd_fs_name}")
sdItem = gis.content.search(query=sd_fs_name, item_type="Service Definition")
i=0
while sdItem[i].title != sd_fs_name:
i += 1
print('Item Found')
print(f'item[i].title = {sdItem[i].title}, sd_fs_name = {sd_fs_name}')
item = sdItem[i]
item.update(data=sd)

print("Overwriting existing feature service…")
fs = item.publish(overwrite=True)

if shrOrg or shrEveryone or shrGroups:
print("Setting sharing options…")
fs.share(org=shrOrg, everyone=shrEveryone, groups=shrGroups)

print("Finished updating: {} – ID: {}".format(fs.title, fs.id))

Re: Setting the Time Zone when publishing Map Service via ArcPy?

James_Norquest — Wed, 31 May 2023 17:07:39 GMT