Latest Contributions by MichaelVolz

‎06-14-2013

Are you trying to update SDE datasources? I ask because I have a script that updates SDE datasources for feature classes, but I am unable to update standalone tables because I cannot access the SDE connection properties for a standalone SDE table. Is this a situation that you are encountering? Currently I just log the location of standalone tables and change them manually after the script has completed. I can justify this because there a very few standalone SDE tables compared to SDE feature classes. I'm hoping that ESRI exposes the connection properties for SDE standalone tables with the release of ArcMap v10.2.

‎06-12-2013

I have added code to update the datasource of standalone tables that are sourced from an SDE database. The coding is very similar to SDE feature classes, especially when setting the connection properties. The behavior is odd because I can see that the connection properties of the standalone table have been updated immediately after running the Add-In, but the feature class connection properties do not appear to be updated immediately. I need to save the mxd and then close and re-open the mxd in order to see the updated connection properties. Does anyone know why this is occurring? Does anyone know how to get the connection properties of SDE feature classes in mxds to show changes immediately after the Add-In has finished running? Any help or hints are greatly appreciated.

‎06-11-2013

Thank you Neil, but the last line of your suggestion when used with Intellisense does not expose the ConnectionProperties object. Update: Your code did work. I changed Workspace to Workspace2 assuming that Workspace2 was the same but just exposed additional properties. But Workspace2 exposes less properties which include ConnectionProperties. Once I changed it to Workspace I was able to access ConnectionProperties.

‎06-11-2013

To All ArcObjects Developers: I am writing an Add_In to change the properties of a standalone SDE table in ArcMap. I have the following code that I thought would get the connection properties, but it keeps crashing the Add-In. pStndAloneTbl = pTableColl.StandaloneTable(k) 'Instantiate the property set object pPropset = New PropertySet pDataLayer2 = pStndAloneTbl pDatasetName2 = pDataLayer2.DataSourceName pWorkSpaceName2 = pDatasetName2.WorkspaceName pPropset = pWorkSpaceName2.ConnectionProperties The code crashes at pDatasetName2 = pDataLayer2.DataSourceName even though Intellisense tells me that the DataSourceName method is available from the pDataLayer2 object. Can anyone please tell me what I am doing wrong here as it seems to me like this code should work? Any help or hints are greatly appreciated.

‎06-07-2013

Thank you Ken. The combination of your 2 posts allowed me to trap if the raster layer originated from an SDE database.

‎06-07-2013

Tamadie: On your scheduled task under the General tab, do you have it set to Run whether user is logged on or not and Run with highest privileges I had issues in the past if I did not have Run with highest privileges set on the scheduled task. Does the service account you are using have Administrator privileges on the server? You probably need this as well.

‎06-07-2013

Ken: Do you know what objects I need to expose to go from the ILayer object to IWorkspace object?

‎06-06-2013

Can you post one of your python scripts that is not working in 10.1?

‎06-06-2013

I am now trying to use the following code to determine data source, but it is crashing ArcMap: pDataLayer = pLayer pDatasetName2 = pDataLayer.DataSourceName - Intellisense provides DataSourceName as an member of pDataLayer but this is where the code crashes ArcMap I would then like to use pDatasetName2.Category to determine if the data is "SDE Feature Class" Does anyone know what I am doing wrong here?

‎06-06-2013

At this point is the task executing, but the actual update to the SDE database is not occurring? Do you have any error checking enabled in your python script to determine what is not working? Can you run the python script through IDLE and see if it updates the SDE database as you would expect, completely separate from the scheduled task?

‎06-05-2013

To All GIS VB.NET Developers: What object of ILayer (layer in an mxd) can I use to determine if the layer is sourced from an SDE database? In the past if I had a raster layer from SDE I used the RasterLayer.FilePath object which provides the path to where the SDE layer was created. This did not work when I copied a raster SDE layer from one mxd to another. In this case it showed the path to the SDE layer but did not include the .sde connection. Any help or hints are greatly appreciated.

‎06-05-2013

Can you provide your python script? Are you writing to a file geodatabase on a network drive?

‎06-05-2013

Tamadie: Go into Windows Explorer and navigate to a python file Right click on the python file and select Properties from the drop-down menu Make sure the General tab then has the focus when you are in Properties Near the top there is Opens with: Notepad.exe Change button - I'm thinking this is what it looks like for you It should say Opens with: python.exe So hit the Change button and select python.exe, hit OK and then hit Apply in the General tab Now when you right click on the python file you should see "Edit with IDLE" as the 2nd item in the drop-down menu (Right now when NotePad is the default application to open you just see "Edit" as the 2nd item in the drop-down menu I hope this helps.

‎06-04-2013

Tamadie: You might want to check with IT people at your organization to see if this server gets automatic OS updates. If so, you might want to see if there was an update on May 29. If there was, you might want to see if they can revert back to the OS before this update and then see if your scheduled task runs. You could also try running your scheduled task from a bat file that calls the python script.

‎06-04-2013

Sorry Tamadie as my last post gave you incorrect information Cut the path from Start in and paste it into the Add arguments box then try running your script I usually use bat files to call python scripts, but this should now work.

Online Status	Online
Date Last Visited	4 hours ago

My Ideas

Latest Contributions by MichaelVolz

Re: Update data source of join table

Re: Show New SDE Connection Parameters After Running Add-In

Re: Access Connection Properties of SDE Standalone Table

Access Connection Properties of SDE Standalone Table

Re: Determine DataSource in VB.NET

Re: Python scripts do not run complete on Sheduled task

Re: Determine DataSource in VB.NET

Re: pythonw.exe has encountered a problem and needs to close

Re: Determine DataSource in VB.NET

Re: Python scripts do not run complete on Sheduled task

Determine DataSource in VB.NET

Re: Python scripts do not run complete on Sheduled task

Re: Python scripts do not run complete on Sheduled task

Re: Python scripts do not run complete on Sheduled task

Re: Python scripts do not run complete on Sheduled task

Re: Address Locator - Manually Locates But Won't G...

Re: Count of records in sde views fails

Re: ArcGIS Pro and using Teams for File Storage

Re: Using Append in Python is suddenly requiring a...

Re: Satellite photos from 1984 of local DE address...