Latest Contributions by BarryGuidry

I create incremental numbering in a field through the simple calculation: [OBJECTID] - ( <First[OBJECTID] - starting#>) But would like to do the reverse as well, create a script to incrementally decrease values by increment of 1, but with a first Objectid - a starting number (input by myself). ... View more

We are running ArcMap Desktop 10.5.1, and connect to enterprise geodatabases through SQL Server ArcGIS Server 10.7.  Up until recently we were all able to work in the geodatabases over Cisco VPN.  On May 7th, only two out of four of us can no longer open the geodatabase connections, nor create a new geodatabase connection to ArcGIS Server.  I see no Windows Update taken place on that date, or the previous date, and can find no reason for any change in the two laptops that can no longer connect.  Anyone else had this or similar problem? Barry ... View more

We are currently editing a one-to-many relationship (setup in ArcMap) between geospatial data and a non-spatial table (both within the same enterprise geodatabase).  Though, I believe we may be lacking "referential integrity", because we have orphans within the table.  I was looking at the online documentation here: https://desktop.arcgis.com/en/arcmap/10.5/manage-data/relationships/deciding-between-relationship-classes-joins-and-re.htm - Would a relationship class setup in the geodatabase solve our problem with orphans?  - Would database versioning have an affect on the relationship class? If so, how? - Are Global IDs necessary in an enterprise Geodatabase for a relationship class? Any help would be appreciated. ... View more

Is there another possible way to run nightly python scripts on Microsoft Server other than Windows Task Scheduler (such as the method available from ESRI below), possibly with SQL Manager and a Batch script? We were running via Task Scheduler, but it stopped working about a month back. http://desktop.arcgis.com/en/arcmap/10.3/analyze/executing-tools/scheduling-a-python-script-to-run-at-prescribed-times.htm ... View more

Has anyone ever had this problem?  When using the Intersect tool, on the same polyline data and two different polygon data sets, the output polylines differ in areas (see attachment). ... View more

I am simply using the ArcGIS Server Manager 10.0 web application wizard to run a geoprocessing model from within the associated map document. So, I the model sums acreage and writes the "Acreage" table to a geodatabase at specified location. I don't see a way to have the default web application builder display the Acreage results from within the web application, though. So, what I did was link the table to an Excel document. I am attempting to add a Python script to the model in order to open the Excel file to display the results, but get this error in the web application geoprocessing results: Submitted.     Executing...     Executing (Acreage): Acreage     Start Time: Wed Feb 05 15:46:05 2014     Executing (Select Layer By Attribute): SelectLayerByAttribute "Fuel Load (Acreage)" NEW_SELECTION "SIMPLE = 'Heavy Grass'"     Start Time: Wed Feb 05 15:46:06 2014     Succeeded at Wed Feb 05 15:46:06 2014 (Elapsed Time: 0.00 seconds)     Executing (Get Count): GetCount "Fuel Load (Acreage)"     Start Time: Wed Feb 05 15:46:06 2014     Row Count = 5     Succeeded at Wed Feb 05 15:46:06 2014 (Elapsed Time: 0.00 seconds)     Executing (Summary Statistics): Statistics "Fuel Load (Acreage)" \\Path_to\webappdata.mdb\Acreage "ACREAGE SUM" #     Start Time: Wed Feb 05 15:46:06 2014     Succeeded at Wed Feb 05 15:46:09 2014 (Elapsed Time: 3.00 seconds)     Executing (openxl): openxl     Start Time: Wed Feb 05 15:46:10 2014     Running script openxl...     Error: : unexpected indent (acreage.py, line 7)     Error: Failed to execute (openxl).     Failed at Wed Feb 05 15:46:12 2014 (Elapsed Time: 2.00 seconds)     Error: Failed to execute (Acreage).     Failed at Wed Feb 05 15:46:13 2014 (Elapsed Time: 8.00 seconds)     Error: Failed. Here is the Python script: ## Import win32 to interact with Excel application import win32com.client as win32 ## To open Acreage table in Excel excel = win32.gencache.EnsureDispatch('Excel.Application') excel.Visible = True excel.Workbooks.Open(\\Path_to\Landuse\Acreages.xlsm) Can anyone let me know what problem I may have in the script? ... View more