Latest Contributions by PaulSchneider

Yes, programmatically at 10.8.1+, at least for ArcGIS Server Map/Feature services: Add the new item with the item_id you desire using the ContentManager and the (Available at 10.8.1+) item_id property. In the ArcGIS Server admin console, edit the portal properties of the referenced service to match the new item_id Republish (overwrite) the new Portal layer with service content (from ArcGIS Pro) - this might be optional but would allow you to confirm your settings Delete the 'old' item(s) from Portal ... View more

I had this issue; what I found was that the service I was trying to overwrite was having a pre-existing problem.  In other words, make sure the current service functions properly before attempting to overwrite it.  Stopping, re-starting, then reviewing the ArcGIS Server logs. ... View more

Scoping it inside an edit session will likely be your ticket here.     ## CREATE VERSIONED EDIT SESSION     with arcpy.da.Editor(gisConn) as edit:         edit.startEditing(True, True) #see the Help; multi-user mode         edit.startOperation()         #Do work         ## STOP EDITING         edit.stopOperation()         edit.stopEditing(True) # True saves edits ... View more

1) You'd need something to denote the processing values to separate into which text file.  This could be a separate field, or (if you dare) hard-code your Python... but I'd only recommend the latter if your separations are static.  Assuming you have a way to separate, I'd push the separate value and their output text file to a dict, and move the process of writing the data to a separate function.  Then while processing the rows, you can specify which file they go to.  Something like: import arcpy, os, time # you don't need os or time if you use a constant log file name (line 18) def log(txt, inFile, newRun):     try:         if newRun == True:             csvFile = open(inFile, 'w')         elif newRun == False:             csvFile = open(inFile, 'a')         csvFile.writelines(txt)         csvFile.flush()         csvFile.close()     except IOError:         print 'Unable to write to file ' + inFile def main():     inDS = r"C:\TEMP\JUNK\ServiceRequest.gdb\ServiceRequests"     whereClause = r"STATUS = 'Unassigned'"     statusField = "STATUS"     deptField = u'DEPT_ASSIGNEE' ##determines how to separate the tables (see table separation note below)     logDir = r"C:\TEMP\JUNK"     updateTo = "Assigned"     fieldArr = []     for fld in arcpy.ListFields(inDS):         fieldArr.append(fld.name)     fieldArr.remove('SHAPE')     ##Table Separation Note     ##Create the list of output text files (must be based on a common value) - note does not have to be a field in the data...     ##you could create a dictionary to hold these values in code, but doing so would cause the code to go stale upon new unbeforeseen values     with arcpy.da.SearchCursor(inDS,fieldArr) as sc:         fileStore = {}         for scr in sc:             for j in range(len(scr)):                 if j == fieldArr.index(deptField) and not in fileStore.keys():                     fileStore[scr ] = logDir + os.sep + time.strftime('%Y%m%d', time.localtime(time.time())) + str(scr ) + '.csv'     headerLine = ""     for i in range(len(fieldArr)):         if i != len(fieldArr) - 1:             headerLine += str(fieldArr) + ","         else:             headerLine += str(fieldArr) + "\n"     for k,v in fileStore.iteritems():         log(headerLine, v, True)     fieldxi = fieldArr.index(statusField)     sepxi = fieldArr.index(deptField)     try:         with arcpy.da.UpdateCursor(inDS, fieldArr, whereClause) as cursor:             for row in cursor:                 rowLine = ""                 fileWrite = ""                 for i in range(len(row)):                     if i == sepxi:                         fileWrite = fileStore[row]                     if i != len(row) - 1:                         rowLine += str(row) + ","                     else:                         rowLine += str(row) + "\n"                 row[fieldxi] = updateTo                 cursor.updateRow(row)                 log(rowLine, fileWrite, False)     except:         print 'Error updating the dataset' if __name__ == '__main__':     main() 2) The smtplib module should be able to assist you with sending email as attachments.  3) Using a try/except is considered good practice for error handling you should add in anyhow; to expand this you could add an if statement with a break to exit a segment of code. Good Luck ... View more

Something like this maybe? import arcpy connectionFile = r"<path\to>\connection.sde" #block new connections to the database. arcpy.AcceptConnections(connectionFile, False) #disconnect all users from the database. arcpy.DisconnectUser(connectionFile, "ALL") # do work here #allow new connections to the database. arcpy.AcceptConnections(connectionFile, True) ... View more

Try this link as another possible solution to this error. ... View more

I believe you are getting this error because the dataset is not registered as versioned with the database? Try changing to: ... edit.startEditing(True,False) ... or register the dataset as versioned before opening the edit session ... View more

When you unregister a replica, be sure to do it on both ends; you need to 'cut the cord' between parent and child on the parent end and the local/ child end as well. This poses somewhat of a problem.  If an ArcGIS Server administrator is using a Geodata Service to accept data updates from users, the client controls when they make (register) the replica and if/when they choose to unregister it.  As the data administrator, one can very quickly end up with many replicas and not know which ones are being used, and/or which ones have been unregistered client-side.  http://ideas.arcgis.com/ideaView?id=087E00000004rvpIAA For the near-term its probably best to have pretty tight permissions on the ArcGIS Server as to who can access your GeoData services. ... View more

Used this today... Utilized the .GetDataSource method of the IMapServerDataAccess ... [LEFT]IMapServer3 mapServer = serverObjectHelper.ServerObject as IMapServer3; IStandaloneTableInfos satInfos = _MapServerInfo.StandaloneTableInfos; IStandaloneTableInfo satInfo; string myTableName; for (int i = 0; i < satInfos.Count; i++) {[INDENT]satInfo = satInfos.get_Element(i); if (myTableName.Equals(satInfo.Name, StringComparison.InvariantCultureIgnoreCase) == true) { [INDENT]ITable myTable = setNonSpatialTable(mapServer.DefaultMapName, i); break;[/INDENT]}[/INDENT]} ... private ITable setNonSpatialTable(string mapName, int tablei) { [INDENT]if (tablei != null) { [INDENT]tablei = tablei + _MapServerInfo.MapLayerInfos.Count; //Tables listed after layers ITable outTable = (ITable)_MapServerDataAccess.GetDataSource(mapName, tablei); return outTable;[/INDENT]} return null;[/INDENT]} ...[/LEFT] Thanks! ... View more

ERROR 001272: Analyzer errors were encountered (codes = 90) When trying to publish a feature service of a single SDE feature class: default symbology, no definition query, non-versioned data.  All 'Analyze' results have been remedied. ERROR 001272: Analyzer errors were encountered (codes = 52) When trying to publish the same service with two non-versioned tables from the same data source Suggestions anybody? Took a little digging and some help from here http://resources.arcgis.com/en/help/main/10.1/index.html#/00090_value_requires_a_registered_database/00sq000000m4000000/ Adjusted my connection settings and.... money. Hope this helps someone else! ... View more

We were having a similar issue, only on SQL Server.  In the first step of the Geometric Network Wizard we had been selecting 'Yes' to 'Snap Features within a specified tolerance'; and specifying a looser tolerance level than the feature dataset is based on. By selecting 'No', we were able to create and build the geometric network successfully. We still needed to snap our features however, so we used the Snap Tool (Editing Tools Toolbox); which gave us a little more control over how snapping was carried out anyway. Maybe this will work for your Feature Dataset? ... View more