Latest Contributions by StefanOffermann

‎05-18-2010

Thanks for the answer. Right now I am using Wireshark and monitor the TCP traffic between my laptop (ArcSDE, MS SQL Server Express) and a virtual image (with ArcMap). Anybody knows if all traffic is sent via TCP? (This is a Microsoft-specific question, because I use direct connect).

‎05-17-2010

Hi, are there any (free) tools available to monitor the traffic of a connection from ArcMap to a SDE? I am interested in calculating the total size of data transferred from SDE to ArcMap by (a) loading a layer, (b) opening the attribute table, (c) zoom to full extent, (d) pan a bit, (e) zoom a bit, etc. In my testing environment, I have a MS SQL Express Database with ArcSDE, and ArcMap 9.3.1 on my development machine. I want to see how much network traffic is produced while executing the actions above. Can the geodatabase toolset help me to monitor the network traffic? Best regards, Stefan

‎05-05-2010

Do not use VB6 anymore, it is no longer supported by Micrsosoft and ESRI. Use VB.NET or C# instead.

‎04-27-2010

Then you have an error in your code. The double quotes are the right way. I don't know the exact way in VBA to escape the double quotes, in C# I would write: pQf.WhereClause = "\"FieldName\" <> Null" You should check how to use <> and Null in VBA.

‎04-26-2010

Have a look at the Geodatabase overview, there is a section related to Versioning. You should finde the appropiate Interface there: http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#/d/0008000436w2000000/ HTH, Stefan

‎04-25-2010

For File Geodatabase, you have to enquote field names with double quotes: "Field" = 'Value' see: http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=SQL_reference regards, Stefan

‎04-23-2010

I think .NET 4.0 is not yet supported. Try to set .NET 3/3.5 as target framework for your Visual Studio project. Does this help? Regards, Stefan

‎04-19-2010

Field names can not be renamed. You can only rename the Alias name, which is only reflected in MXD-documents, not in ArcCatalog. The only workaround is to create a new field with the new name and copy all values to this field, eg using CalculateField tool. Afterwards you can delete the old field. This may take much time, depending on how much rows and fields you want to "rename". Secondly, joins are only reflected in the MXD-document in ArcMap and are not visible in ArcCatalog. To make the join persistent, you can use the CopyRows tool, exactly as you've written. Another possibility is to use the JoinField tool (available at ArcInfo license level), which copies the field directly to the target table. Best regards, Stefan

‎04-17-2010

For anyone who has ever asked if MXD's can be created or altered through Python, there's a good chance the answer is "yes" if you use comtypes. It is a new feature of arcpy to get access to mxds and its contents with ArcGIS 10, isn't it? Have a look at the new "mapping" module: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s300000032000000.htm Best regards, Stefan

‎04-17-2010

You can use Python to script Geoprocessing. With 10, you can also get access to mxd files, the contained layers etc. What you cannot do: Build user interfaces. Instead VBA, you should do this with VB.NET or C# (which is a matter of taste between both programming languages). May be you want to have a look at the new Add-In Development possibillities when it comes to user interfaces. Best regards, Stefan

User Form in Background? · ‎04-15-2010

Is it possible to run user forms in the background of arcmap? I would like my form to be open and to still be able to work with my map document. Right now I have to close my user form in order to control arcmap. How do you open your dialog? Try to replace new Form().ShowDialog() with new Form().Show() This should open the dialog non-modal. Best regards, Stefan

‎04-15-2010

Hi there, will ArcGIS 10 support Desktop Extensions written on .NET Framework 4? Is WPF supported (besides Windows Forms)? Best regards, Stefan

‎02-17-2010

combined = r'C:\data.gdb\combined' Seems the File Geodatabase is the root of the error. When I export the raster with raster attribute table as C:\combined.img the Lookup works! Is it a bug in the geodatabase?

‎02-16-2010

Hi, the last days I tried to convert a python script from 9.3.1 to ArcGIS 10 Beta 2. Most of the conversion works fine as it is as simple as changing captalization of field.type or row.GetValue. The nice thing is the availablility to iterate over a cursor with a for-loop, instead of calling cursor.Next(). But: The final lines of my script execute a Lookup, which is not working. It produces some errors, but I am not able to detect the reason. Lets see my code: import arcpy as gp combined = r'C:\data.gdb\combined' betaField = 'Beta_final' betaMap = r'C:\data.gdb\BetaMap' print 'Spatial Analyst: %s' % gp.CheckExtension("Spatial") print ' License: %s' % gp.CheckOutExtension("Spatial") print 'Lookup' raster = gp.sa.Lookup(combined, betaField) print 'Save' raster.save(betaMap) print 'Done' The line with gp.sa.Lookup(...) fails: Traceback (most recent call last): File "C:\Scripts\test\TestLookup.py", line 14, in <module> raster = gp.sa.Lookup(combined, betaField) File "C:\Program Files\ArcGIS\Desktop9.4\arcpy\arcpy\sa\Functions.py", line 5708, in Lookup lookup_field) File "C:\Program Files\ArcGIS\Desktop9.4\arcpy\arcpy\sa\Utils.py", line 67, in swapper result = wrapper(*args, **kwargs) File "C:\Program Files\ArcGIS\Desktop9.4\arcpy\arcpy\sa\Functions.py", line 5702, in wrapper out_raster) File "C:\Program Files\ArcGIS\Desktop9.4\arcpy\arcpy\geoprocessing\_base.py", line 438, in <lambda> return lambda *args: val(*gp_fixargs(args)) arcgisscripting.ExecuteError: ERROR 999999: Error executing function. The table was not found. [VAT_Lookup_combi6] The item was not found. [RelationshipType (origin/destination typeIDs): {F3783E6F-65CA-4514-8315-CE3985DAD3B1}, {D4912162-3413-476E-9DA4-2AEFBBC16939}] The item was not found. [RelationshipType (origin/destination typeIDs): {F3783E6F-65CA-4514-8315-CE3985DAD3B1}, {5ED667A3-9CA9-44A2-8029-D95BF23704B9}] No spatial reference exists. ERROR 010067: Error in executing grid expression. Failed to execute (Lookup). Any hints why Lookup does not work? What do the GUIDs mean? I dont have a clue what "No spatial reference exists" means. The raster has a spatial reference, namely WGS_1984_UTM_Zone_37S

‎02-05-2010

for row in arcpy.SearchCursor(myTable) print row.getValue("Rank") Yeah, this is really really much more readable then in 9.3 Hooray! :cool:

Online Status	Offline
Date Last Visited	‎11-11-2020 02:22 AM

My Ideas

Latest Contributions by StefanOffermann

Re: How to monitor / summarize SDE network traffic?

How to monitor / summarize SDE network traffic?

Re: how to create a simple arcobject visual basic 6 code?

SQL syntax in query filter interface

Code c#.net for editing spatial database engine (sde geodatabase)

SQL syntax in query filter interface

ArcMap 9.3 and visual Studio 2010

ifieldedit.name to rename feature class field is not persistent

Accessing ArcObjects through Python

Customization with Python in ArcGIS 10

User Form in Background?

.NET Framework 4

Spatial Analyst, Lookup, Beta 2 - ERROR 010067: Error in executing grid expression

Spatial Analyst, Lookup, Beta 2 - ERROR 010067: Error in executing grid expression

Real Cool Stuff on Python

Re: How to Introspect a Describe "Object"

Re: How to Introspect a Describe "Object"

How to duplicate privileges from one SDE feature c...

Re: How to duplicate privileges from one SDE featu...

Failed to find the map