Latest Contributions by RussellBrennan

Working with SDE data should be the same as working with any other data. The path to the data can be slightly different but the behavior of the data should be the same. Take a look at this topic: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002t0000000v000000.htm ... View more

Elee, Do your attachments have any type of 'key value/key field' that would associate them to the record in the feature class or table you want to attach to? For example: Does the name of the utility inspection reports have some sort of unique id that would be able to be related to the actual infrastructure record in the feature class? Perhaps you have a unique feature ID that you use to name the inspection reports? Currently in ArcGIS 10, we have a manual option through ArcGIS Desktop for adding attachments one record at a time. We looking at methods for attaching multiple attachments to multiple records in a batch operation. ... View more

There is currently no gp method for creating historical markers through Python. We have not received many requests for this functionality but is something that we could look into implementing. Can you describe your desired workflow if this functionality was available? ... View more

Hi Ted, There is no option for creating OLE DB connections through Python. We do have a create ArcSDE connection file tool at 10. Also, here is a link to an ArcObjects sample that will create an ArcSDE connection file at 9.3/10. With a little bit of tweaking you should be able to get this to work with odc files. http://blogs.esri.com/Dev/blogs/geoprocessing/archive/2008/09/24/Tips-and-Tricks-_2D00_-Creating-ArcSDE-connection-files-on-the-fly-using-Python-and-ArcObjects.aspx Unfortunately ArcObjects/Java is not my forte so if you do go this route you may want to post in one of the programming forums for assistance. ... View more

This is probably the best place to get started. Look at the topics specific to the DBMS you are working with for more information. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/What_is_ArcSDE/000500000001000000/ ... View more

Ozan, Based on the description of the issue in this thread it appears as if you are encountering NIM063748. You have correctly identified a workaround in creating attachments before registering as versioned with the ability to move edits to base. We intend to include the resolution for this issue with 10 SP2. ... View more

Help on script tools: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001500000006000000.htm Adding a custom tool to a toolbar: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002400000005000000.htm (look under the heading "Adding a custom tool to a menu or toolbar".) Hope this helps, ... View more

Attached is a toolbox containing two custom script tools that I wrote a little while ago. The first one will register a spatial table with SDE and then with the geodatabase. The second will register a regular table with SDE and then with the geodatabase. I have hardcoded a number of options either through the script itself or through the tool dialog. You should be able to edit this tool/script to your liking. Hope this helps, ... View more

Laura, We are looking at an implementation of this for the next release of the software and are working on user requirements for the new tools. We would be interested in knowing how you would like to see this tool work? Specifically, how would you like to see the association between an individual feature and attachment take place in an automated process? ... View more

Hi Ted, Can you clarify the workflow you are talking about for the upgrade and be a bit more specific about what you 'get' and 'do not get' about the upgrade? Thanks, ... View more

What about hiding the ArcSDE schema from other users on the instance? At 9.3.1, write privileges (I,U,D) are granted to PUBLIC for GDB_ tables. Read privs are given to most or all tables in the SDE schema. And execute is granted to PUBLIC for all packages and procedures in the SDE schema. I submitted an idea for hardening the ArcSDE repository to ideas.arcgis.com. Vote on it if you'd like: http://ideas.arcgis.com/ideaView?id=087300000008HY6AAM Is this the information you were looking for? http://resources.arcgis.com/content/kbase?fa=articleShow&d=37824 ... View more

Glad to hear that helped. Did ESRI do away with the "This post answered my question" thingamajig for these new forums? The thingamajig is gone for now. I *think* there are plans to bring it back at some point but am not 100% sure. ... View more

Dan, Try running this line right before creating the version. arcpy.ClearWorkspaceCache_management() I have seen some cases in my testing where connection properties were cached and caused issues when trying to create new workspaces. Hope this helps, ... View more

Help on Describe is here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Describe/000v00000026000000/ Once on this page you can click on the link to the data element you will be describing to find out what the output type of the describe will be. For example, this is what is returned when describing a feature class: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/FeatureClass_properties/000v0000002p000000/ Also notice in the summary in the help topic for feature classes that there is access to Table Properties and Dataset Properties as well. Most if not all data elements that you describe will inherit properties. ... View more

Holly, ArcObjects will give you a little bit more efficiency in the ability to copy data and map to new fields at the same time. Without going into too much detail a possible geoprocessing workflow would be to use the feature class to feature class tool to set up your field mapping and copy to a new dataset, you could then use delete rows/delete features to 'clean up' the existing dataset, finally you could use copy features/copy rows to copy the data created from the feature class to feature class tool into the geodatabase. Hope this helps. ... View more