Setting the Time Zone when publishing Map Service via ArcPy?

RandyKreuziger

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?

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

James_Norquest

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