Vjylku

When does a person lose diplomatic status?

Isn't a semicolon (';') needed after a function declaration in C++?

What is an explicit bijection in combinatorics?

Why is Acetic acid (pKa = 4.76) stronger than carbonic acid (pKa = 6.36)?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

How can I prevent an oracle who can see into the past from knowing everything that has happened?

Linearity Assumption

Did ancient Germans take pride in leaving the land untouched?

Can't figure out a htaccess rule

In a post apocalypse world, with no power and few survivors, would Satnav still work?

If we can’t finish all tasks, does this mean we are doing Scrum wrong?

Why is it that Bernie Sanders is always called a "socialist"?

How unreachable are Jupiter's moons from Mars with the technology developed for going to Mars?

How many diagrams is too much in a research article?

Is the percentage symbol a constant?

Is this Article About Possible Mirrored Universe Junk Science?

What could cause an entire planet of humans to become aphasic?

Are all power cords made equal?

How can I differentiate duration vs starting time

Boss asked me to sign a resignation paper without a date on it along with my new contract

Crack the bank account's password!

What is the meaning of "usr"?

Is the tritone (A4 / d5) still banned in Roman Catholic music?

What does "south of due west" mean?

Transformer Annotations Location Removed on Field Calculate in ArcFM Electrical?

Why do these annotations appear stacked/overlapping?Annotation features containing both GraphicElement and TextElement objects not drawing in ArcGIS Server map service?Annotation doesn't update when features are inserted via FMEWhy does Append on large annotation layer give WARNING 000594: Input feature falls outside of output geometry domains?Feature-linked Annotation Angle field error: ArcGIS 10.1Use Field Calculator to change “Status” field in AnnotationsRuntimeError: Field is not editable when using InsertCursor on ArcSDE geodatabase with ArcFM installed?Can HTML annotations be autogenerated for each location in QGIS 2.4How to recover from deleting the symbolid of a arcgis annotation feature class?Red boxes appear where annotation should be

0

I am working with ArcFM and I have done a mass update to a textfield that was being used for the kVA field in the Transformers Table.

The annotation script itself was looking for a text string that contained the letters kva and if it did contain those letters it would draw the annotation.

We used the field calculator like so:
KVA = Replace([KVA],"kVA","")

This replaced each and every record in the table and it worked flawlessly. When we inspected the map some time later however the annotation for KVA was missing from every single transformer. I believe it is because we did not first modify the annotation script before executing the field calculation...

Ideally we wanted to revert back to the backup that took place the day before this kva field update occurred. Unfortunately this is how we discovered there is a problem with our backups and the latest one we have is about ~week old.

We have a test server set up which has one of the backups loaded onto it. I am able to export the layer file and when I import it and make it visible in the layers all of the KVA's are there.

So I thought I could easily join/relate the table and then swap the Shape field in the TransformerAnno table. But it does not seem possible to use import a complex data type like geometry from a different table.

The alternative to not being able to programmatically backup the Shape field from the layer/TransformerAnno table to the table in question is to replace every single annotation and move it by hand.

annotation arcfm

share|improve this question

edited 3 mins ago

PolyGeo♦

53.6k1780240

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you just put back the string "kVA" on the end of non-empty records?
  
  – Michael Stimson
  Jul 28 '14 at 23:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I tried doing this but it does not redraw the annotations, when I click to manually redraw them they are in a totally different spot.
  
  – Dbmaki
  Jul 28 '14 at 23:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can't copy/calculate blobs (Binary Large OBjects) using normal methods. You could do it in ArcObjects but the effort would be (possibly) more than regenerating and replacing the annotations.
  
  – Michael Stimson
  Jul 28 '14 at 23:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for your help Michael. Do you think it would be possible to update these "blob" fields in SQL? We currently have our geodatabase hosted in an oracle environment.
  
  – Dbmaki
  Jul 28 '14 at 23:19
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  They are binary objects and the format of these isn't shared by Esri. You could try copying them using Oracle - just remember to keep a backup as it is possible that it could break the data... let me know how it goes, I might need to do it myself one day.
  
  – Michael Stimson
  Jul 28 '14 at 23:26
  

  
  
  
  

add a comment | 

0

I am working with ArcFM and I have done a mass update to a textfield that was being used for the kVA field in the Transformers Table.

The annotation script itself was looking for a text string that contained the letters kva and if it did contain those letters it would draw the annotation.

We used the field calculator like so:
KVA = Replace([KVA],"kVA","")

This replaced each and every record in the table and it worked flawlessly. When we inspected the map some time later however the annotation for KVA was missing from every single transformer. I believe it is because we did not first modify the annotation script before executing the field calculation...

Ideally we wanted to revert back to the backup that took place the day before this kva field update occurred. Unfortunately this is how we discovered there is a problem with our backups and the latest one we have is about ~week old.

We have a test server set up which has one of the backups loaded onto it. I am able to export the layer file and when I import it and make it visible in the layers all of the KVA's are there.

So I thought I could easily join/relate the table and then swap the Shape field in the TransformerAnno table. But it does not seem possible to use import a complex data type like geometry from a different table.

The alternative to not being able to programmatically backup the Shape field from the layer/TransformerAnno table to the table in question is to replace every single annotation and move it by hand.

annotation arcfm

share|improve this question

edited 3 mins ago

PolyGeo♦

53.6k1780240

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you just put back the string "kVA" on the end of non-empty records?
  
  – Michael Stimson
  Jul 28 '14 at 23:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I tried doing this but it does not redraw the annotations, when I click to manually redraw them they are in a totally different spot.
  
  – Dbmaki
  Jul 28 '14 at 23:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can't copy/calculate blobs (Binary Large OBjects) using normal methods. You could do it in ArcObjects but the effort would be (possibly) more than regenerating and replacing the annotations.
  
  – Michael Stimson
  Jul 28 '14 at 23:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for your help Michael. Do you think it would be possible to update these "blob" fields in SQL? We currently have our geodatabase hosted in an oracle environment.
  
  – Dbmaki
  Jul 28 '14 at 23:19
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  They are binary objects and the format of these isn't shared by Esri. You could try copying them using Oracle - just remember to keep a backup as it is possible that it could break the data... let me know how it goes, I might need to do it myself one day.
  
  – Michael Stimson
  Jul 28 '14 at 23:26
  

  
  
  
  

add a comment | 

I am working with ArcFM and I have done a mass update to a textfield that was being used for the kVA field in the Transformers Table.

The annotation script itself was looking for a text string that contained the letters kva and if it did contain those letters it would draw the annotation.

We used the field calculator like so:
KVA = Replace([KVA],"kVA","")

This replaced each and every record in the table and it worked flawlessly. When we inspected the map some time later however the annotation for KVA was missing from every single transformer. I believe it is because we did not first modify the annotation script before executing the field calculation...

Ideally we wanted to revert back to the backup that took place the day before this kva field update occurred. Unfortunately this is how we discovered there is a problem with our backups and the latest one we have is about ~week old.

We have a test server set up which has one of the backups loaded onto it. I am able to export the layer file and when I import it and make it visible in the layers all of the KVA's are there.

So I thought I could easily join/relate the table and then swap the Shape field in the TransformerAnno table. But it does not seem possible to use import a complex data type like geometry from a different table.

The alternative to not being able to programmatically backup the Shape field from the layer/TransformerAnno table to the table in question is to replace every single annotation and move it by hand.

annotation arcfm

share|improve this question

edited 3 mins ago

PolyGeo♦

53.6k1780240

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41

share|improve this question

edited 3 mins ago

PolyGeo♦

53.6k1780240

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41

share|improve this question

edited 3 mins ago

PolyGeo♦

53.6k1780240

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41

edited 3 mins ago

PolyGeo♦

53.6k1780240

edited 3 mins ago

PolyGeo♦

53.6k1780240

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41

asked Jul 28 '14 at 23:04

DbmakiDbmaki

41