Latest Contributions by RussellBrennan

GR, If you are planning to upgrade to 10.1 when it becomes available and you are willing to wait for it; all of the functionality that you are looking for will be available through Python/geoprocessing. You could either use Python scripts directly or you could make geoprocessing calls from your C#/ArcObjects code. ... View more

To ESRI: I am sure that the Table to Domain tool for the tool's dialog box in my ArcCatalog 10 is not working for me - it is a bug in your software.  (1) Please fix it. (2) Is any different way (like Python programming) to get the Table to Domain task done in ArcCatalog 10?  Please kindly respond and advise. Thanks, Scott Chang I am able to run the table to domain tool without issue. Can you please post sample data and a screenshot of the parameters you are using to run the tool? ... View more

This probably does not help you right now but with version 10.1 of ArcGIS there will be an arcpy.da.listdomains function that will return domain objects with the properties you are looking for. ... View more

Is it possible, using arcpy, to query version information from SDE? I would like to report information such as Version Name, Owner, Creation Date, Modified Date, Description, and Permissions. Thanks, Ryan Currently this is not possible @ version 10.0 of ArcGIS. With 10.1 we will have an arcpy.da.ListVersions function that will return version objects with all of these properties. ... View more

Something that you might want to look for if you are moving to 10.1 is the new editor tracking capabilities. This will allow the geodatabase to automatically enter certain attributes such as user names when records are updated. ... View more

There is a Summary Statistics tool in the analysis toolbox that will get you to get the max value for a field and output this value to a new table. ... View more

I've actually been using SP3 for a while. I've decided to just to my edits in a file geodatabase and then just replace all the rows in the SDE table on a weekly basis with Delete and Append. Were you able to run the sample code that I posted above? ... View more

I am attempting to use the insert cursor on an SDE connection and v10 sp3 doesn't seem to help, no row is added.  Perhaps I am doing something else incorrectly? Can you send a simple example of what you are attempting to do? Here is a quick script that I wrote that is working on my 10.1 beta build and should also work on 10.0 SP3: import arcpygdb = 'Database Connections/gdb.sde' #change this to your GDB table = arcpy.CreateTable_management(gdb, 'testCursor') arcpy.AddField_management(table, 'testField', "TEXT") cur = arcpy.InsertCursor(table) row = cur.newRow() row.testField = 'insertedTextFromCursor' cur.insertRow(row) del cur del row ... View more

Cool tool.  I can explicitly run analyze, but I only want to run from the dataset level, and the only option is to itemize every fc, so if I have 100 feature datasets with 20 feature classes in most of the fd, that is a lot of selecting, especially at the last minute that I don't want to analyze 1 specific FD with its 40 sub layers.  This change would need to be un selected manually.  Seems like I should have the capability to just analyze at the FD level, too.  Do like the idea though, at least 1 script will need to be reworked. Ted, The Analyze Datasets and Rebuild Indexes tools give you a list of all the data that the currently connected user owns. You are correct that we do not provide an option to just analyze a single feature dataset. If you are using the tool through the UI you will need to manually unselect the data that you do not wish to analyze. If you are running the tool through Python you could pass in a list of only the classes in the feature datasets you wish to analyze. The help topic that I wrote for this has an example of how to get a list of all the data in your geodatabase. You could quickly alter this script to only use a single feature dataset as the source of the datasets to analyze. Here is the current code sample: # set the workspace environment arcpy.env.workspace=workspace # NOTE: Analyze Datasets can accept a Python list of datasets. # Get a list of all the datasets the user has access to. # First, get all the stand alone tables, feature classes and rasters. dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters() # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy.ListDatasets("","Feature"):     arcpy.env.workspace = os.path.join(workspace,dataset)     dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() # reset the workspace arcpy.env.workspace = workspace Change this to: # set the workspace environment arcpy.env.workspace=workspace # The name of your feature dataset FDS = 'NameOfYourFDS' # NOTE: Analyze Datasets can accept a Python list of datasets. # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy.ListDatasets(FDS,"Feature"):    arcpy.env.workspace = os.path.join(workspace,dataset)    dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() # reset the workspace arcpy.env.workspace = workspace ... View more

Ted, can you please clarify. The way I read the question is that you want to be able to find out how long a user was connected to a database whilst you are disconnecting them? ... View more

This was a bug that we fixed at 10.0 SP3. If you are attempting to use insert or update cursors against versioned data and they are not working, please try installing SP3. ... View more

P.S.  How do I put my code above in a special box like everyone else seems to do? There is a button when you are replying that looks like # it will put [noparse] [/noparse] tags around your selected text. ... View more

No problem, I am pleased that this worked for you. ... View more

Hi Steve, There is currently no option to create or alter query layers through Python at 9.x or 10. If you have access to the Beta program you can take a look at the "Make Query Layer" tool in 10.1 Beta. ... View more