Latest Contributions by Kathleen_Crombez

‎02-18-2016

The way you are declaring the checkbox, it looks like it is a dojo checkbox and would more than likely need to be access with Ken Buja solution. dijit.byId("slrbxC").set("checked", false);

‎02-12-2016

Thanks for taking the time to try to figure it out.

‎02-12-2016

I think the problem is that arcpy.GetCount_management(ViewTable) returns an object. So count will never equal 0. You can test this by doing... count = arcpy.GetCount_management(ViewTable) print type(count) To get the integer value of the count object do this... result = arcpy.GetCount_management(ViewTable) count = int(result.getOutput(0))

‎02-12-2016

The machine running 10.2.2 has Windows Server 2008 R2 Enterprise 64-bit OS. (Virtual) The python shell launches as Python 2.7.5 (default, May 15 2013, 22:43:36) [MSC v.1500 32 bit (Intel)] on win32 The machine running 10.3.1 has Windows 7 Professional 64-bit OS. The python shell launches as Python 2.7.8 (default, Jun 30 2014, 16:03:49) [MSC v.1500 32 bit (Intel)] on win32 I'm not certain how to test for background processing. Both machine were set up with the standard install. The script was written on the Windows 7 machine before upgrading from 10.2.2 to 10.3.1 The Summary_CondoPin table is in a file geodatabase located on a Windows Server 2012 R2 Standard 64-bit OS. print """{} > 1 AND {} IS NULL""".format(arcpy.AddFieldDelimiters(Summary_CondoPin, 'FREQUENCY'), arcpy.AddFieldDelimiters(Summary_CondoPin, 'Comment')) Returned FREQUENCY > 1 AND Comment IS NULL Using the syntax you provided me for the MakeTableView failed with the same error. Traceback (most recent call last): File "X:\ParcelFeaturesQC\ParcelFeaturesQC.py", line 676, in <module> startArcSDE(True) File "X:\ParcelFeaturesQC\ParcelFeaturesQC.py", line 619, in startArcSDE QC.runCondoPinCheck() File "X:\ParcelFeaturesQC\ParcelFeaturesQC.py", line 519, in runCondoPinCheck arcpy.MakeTableView_management(Summary_CondoPin,'Frequency_CondoPin', """{} > 1 AND {} IS NULL""".format(arcpy.AddFieldDelimiters(Summary_CondoPin, 'FREQUENCY'), arcpy.AddFieldDelimiters(Summary_CondoPin, 'Comment'))) File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\management.py", line 7047, in MakeTableView raise e ExecuteError: ERROR 000358: Invalid expression Failed to execute (MakeTableView).

‎02-11-2016

Joshua Bixby, It is strange, because I have other MakeTableView statements with a where clause that run before this one and they all run fine. This is the line that throws the error in 10.3 Here is the error Here are the field properties of the Summary_CondoPin table One thing I did notice about the Summary_CondoPin table is the where clause returns zero records. So maybe that has something to do with the error. But as I mentioned before, this line runs fine without error in 10.2

‎02-11-2016

Does anyone know how to add keyboard accessibility to the LayerSwipe dijit? This is a requirement in order to meet WCAG 2.0 requirements.

‎02-11-2016

Sounds like a bug was introduced at 10.3 Can anyone at Esri Technical Support comment on this issue???

‎01-29-2016

I have run into the same error using the arcpy.MakeTableView_management function on a feature class that HAS and OBJECTID field. I am also using a where clause in the function. The script runs perfectly in 10.2 but fails on this function in 10.3

‎01-28-2016

Can anyone from ESRI comment on this? This is a serious show stopper for automating tasks!

‎01-21-2016

The dialog box is prompting for SDE connection credentials. So far the old map documents I have been testing are so old (2005) that ArcGIS Server did not even exist yet. I manually opened one of the trouble documents and the issue is a secured layer that does not have the login credentials saved.

‎01-21-2016

We are getting ready to upgrade our enterprise database to 10.3 which no longer supports application connections. So I have written a script that will walk through all mxd files in a directory and replace all the application connections with direct connects. The problem I've encountered... When a mxd document has connections that do not save the username and password a dialog box pops up and the script pauses until the dialog box is manually closed. According to Example 4 in ESRIs documentation MapDocument—Help | ArcGIS for Desktop We simply need to create a connection using the Create ArcSDE Connection File—Help | ArcGIS for Desktop tool before calling the MapDocument function. Since my main goal is to use direct connects instead of application connections I am using Create Database Connection—Help | ArcGIS for Desktop instead and it is not suppressing the dialog box. And in the ListBrokenDataSources—Help | ArcGIS for Desktop documentation it clearly states "The arcpy.mapping scripting environment will, by default, supress these dialogs during execution". This does not seem to be the case and is a major issue when we have hundreds maybe even thousands of mxd files to update. Esri Technical Support Please advice on how to suppress the dialog in the arcpy.mapping scripting environment.

‎01-21-2016

I am having the same problem. Did you ever find a work around?

‎01-21-2016

This does not seem to work... I am using CreateDatabaseConnection_management instead of CreateArcSDEConnectionFile_management because I want to make a direct connection to SQL Server instead of an application connection. But it is NOT suppressing the dialog box. The script pauses and will not continue until I click cancel or close the dialog box. Here is my code.... sde = arcpy.CreateDatabaseConnection_management("foldername", "filename", "SQL_SERVER", "servername", "DATABASE_AUTH", "username", "password", "SAVE_USERNAME", "database", "#", "TRANSACTIONAL", "sde.DEFAULT") mxd = arcpy.mapping.MapDocument("path to mxd") Seems like arcpy.mapping.MapDocument should be rewritten to accept login credential parameters.

‎12-31-2015

I am not able to use tabindex to set focus on the map. Has anyone been able to get this to work? I would really like to see a working example if it can be done. No matter what I tried, the map navigation keyboard shortcuts only seems to work when the mouse is hovering over the map. My work around solution was to set the map slider to false and create my own custom zoom and pan buttons.

‎12-17-2015

Well... I don't know what caused the sudden issue. But I found a work around to the div being deleted. I simply create a div dynamically to attach the layer swipe widget to. (in bold below).I also found that the swipeWidget.on("swipe") always returns 0 for left, so I removed that. Here is the new function. function swipeLayer_Changed() { require(["esri/dijit/LayerSwipe", "esri/layers/ArcGISImageServiceLayer" ], function (LayerSwipe, ArcGISImageServiceLayer) { if (swipeWidget) { swipeWidget.destroy(); } for (var i = 0; i < swipeLayers.length; i++) { map.removeLayer(swipeLayers); } swipeLayers = []; // initiate the swipe tool if (swipeChecked) { var swipeContainer = document.getElementById("swipeContainer"); if (!swipeContainer) { swipeContainer = document.createElement("div"); swipeContainer.id = "swipeContainer"; var swipeDiv = document.getElementById("swipeDiv"); swipeDiv.appendChild(swipeContainer); } var swipeLayer = document.getElementById("swipeLayer").value; var urls = urlDict[swipeLayer]; for (var i = 0; i < urls.length; i++) { var layer = initImageLayer(ArcGISImageServiceLayer, urlDict[swipeLayer], "swipe" + String(i), 1.0); map.reorderLayer(layer, swipeIndex + i); layer.show(); swipeLayers.push(layer); } swipeWidget = new LayerSwipe({ type: "vertical", //Try switching to "scope" or "horizontal" left: 155, map: map, layers: swipeLayers }, "swipeContainer"); swipeWidget.startup(); } }); }

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by Kathleen_Crombez

Re: how to programmatically uncheck checkboxes?

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

Re: Python Conditional Statement not Working

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

LayerSwipe Dijit Keyboard Accessibility - WCAG 2.0

Re: Why are the labels not following the settings on the edge of the data frame in layout view?

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

Re: arcpy.mapping scripting environment NOT suppressing dialog box - possible bug

Re: ArcPy Show Stopper: Automated scripts require user input via dialog boxes?

arcpy.mapping scripting environment NOT suppressing dialog box - possible bug

Re: ArcPy Show Stopper: Automated scripts require user input via dialog boxes?

Re: ArcPy Show Stopper: Automated scripts require user input via dialog boxes?

Re: Section 508 Compliance with the JavaScript API?

Re: Layer Swipe Slide Bar / Slide Handle Not Displaying

Re: Antivirus blocks projects and geodatabases

ArcGIS Pro Metadata - FGDC CSDGM Standards - Enume...

ArcMap Metadata in GDB_Items Not Displaying in Pro

Re: What will happen with Clip and Ship example in...

Re: Looking for ArcGIS Enterprise Antivirus Recomm...