Customer Service | Training | Contact Us
You are here: Home > User Forums > arcsde users online discussion forum > Thread Replies

ArcSDE Users Online Discussion Forum

ArcSDE: General forum

Sync Feature-linked Annotation with MVV edi...   brad eckrose Mar 20, 2007
Re: Sync Feature-linked Annotation with MVV...   brad eckrose Mar 23, 2007
Re: Sync Feature-linked Annotation with MVV...   Matthew Barlow May 01, 2007
Re: Sync Feature-linked Annotation with MVV...   brad eckrose May 01, 2007
Report Inappropriate Content • Top • Print • Reply    
Subject Sync Feature-linked Annotation with MVV edit 
Author brad eckrose 
Date Mar 20, 2007 
Message Forum,

I want to use a multi-versioned view and SQL to update an attribute that is part of a feature-linked annotation expression.

Will the feature-linked annotation be automatically updated when I reconcile/post that edit? Or is text generation handled on the client?

How do I mass update attributes that participate in a feature-linked annotation expression and get the text to change automatically?

Thanks for helping on this newbie question,


Brad 
   
Report Inappropriate Content • Top • Print • Reply    
Subject Re: Sync Feature-linked Annotation with MVV edit 
Author brad eckrose 
Date Mar 23, 2007 
Message Ok, what I've found out so far is that feature-linked annotation appears to be more of a client-side concept and that the ArcObjects view of data stored in SDE is not the same as SDE's; very confusing.

With SDE not knowing what a ArcDesktop/ Server/ Engine feature class is (or an annotation feature class extension, for that matter), I think that reconciling and posting will not raise any events that cause the annotation to be updated.

So the question now is, what Arc* action will cause the FL expression to be re-evaluated? If the MVVs update a particular version, should I write ArcObjects code (!) to spin through every feature in that version and read/write it before reconcile/post? Will that regenerate the text? Is there a python script somewhere that will do just that?

What if I had reconciled/posted already? Is there a toolbox item to resync all feature-linked anno feature classes?

Thanks

Brad


 
   
Report Inappropriate Content • Top • Print • Reply    
Subject Re: Sync Feature-linked Annotation with MVV edit 
Author Matthew Barlow 
Date May 01, 2007 
Message Brad,

Did you have any luck sorting this issue out? We are experiencing the exact same problem with feature-linked annotation based on a spatial view not updating when the attributes change. I cannot get a response from ESRI.

I'd be very interested to find out your solution.

Thanks,
Matthew 
   
Report Inappropriate Content • Top • Print • Reply    
Subject Re: Sync Feature-linked Annotation with MVV edit 
Author brad eckrose 
Date May 01, 2007 
Message Matthew,

I suspect there is no response from ESRI because the architecture of ArcGIS precludes a response other than "works as designed."

The way to think of it is this: mvvs are not object references; they do not give you access to objects, so you cannot fire methods or events on the objects and/or related objects. Rather, mvvs give you access to the low-level date storage MODEL, not the GIS object abstractions. Even the SDE api is unaware of FL Annotation, although it may possible to use it to deal with the text element blobs. Again, an extremely low-level API.

Our solution was to include a flag in the updated record, then write an ArcMap tool to select the records and update the related annotation object. Another developer on our team ended up doing it, so I do not know if he simply read and wrote the object or if he used an explicit API call to reevaluate the FL expression. We did it in VB.NET, but I suspect a good scripter could do it in VBA or Python.

It's nice to know that solutions that I once applied to Intergraph FRAMME/IGDS still apply in this day and age. Come to think of it, they at least provided a batch executable that would do it! ;)

Maybe some Redlands newbie could be assigned the thankless task of writing a stored procedure or trigger to update FL text in an SDE database.

Brad