nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

cut & paste annotations

MikeYoung5

Can Python be used to cut & paste Annotations? I have read through arcpy.CopyFeatures_management and arcpy.Copy_management ESRI help docs. I have been unable to find anything that mentions cut & paste Annotations.

Find more posts tagged with

Accepted answers

All comments

JacobDrvar

jdrvar;330609 wrote:

Well this is nothing like a Field Calculation, so of course the !TextString! won't work. I did not know you were going to this kind of script. Just use the updatecursor itself to do this.
FieldName = arcpy.GetParameterAsText(0)
cursor = arcpy.da.UpdateCursor(History, [FieldName])
for row in cursor:
 row[0] = "(" + row[0] + ")"
 cursor.updateRow(row)
del row
del cursor
The input parameter would be any text field name. So choose "TextString" in that parameter. Or forget the parameter and hard code the field name.
cursor = arcpy.da.UpdateCursor(History, ["TextString"])
for row in cursor:
 row[0] = "(" + row[0] + ")"
 cursor.updateRow(row)
del row
del cursor
I suppose I should have been more specific. Using your suggestion works! I just need to refresh to display the ().
arcpy.RefreshActiveView()

RichardFairhurst

jdrvar;329266 wrote:
I changed the text to match my field name. My field name is TextString. So, my line of script reads:

"(" + !TextString! + ")"QUOTE]

addParentheses = "(" + !TextString! + ")" returns a Syntax Error. I know the field name and type are correct, therefore, believed the expression to be correct. That left the concatenation of parentheses. But, the concatenation worked within Field Calculator. Then, I went back reread the posts and tried adding a second variable; expression = (!TextString!). Which also created a Syntax Error. So, I removed the exclamation points from the addParentheses variable. Removing the exclamation points, the script runs, and replaces existing text with parentheses. But, I want to concatenate the existing text with parentheses. Any suggestions?
TextString = arcpy.GetParameterAsText(0)
addParentheses = "(" + TextString + ")"

cursor = arcpy.da.UpdateCursor(History, ["TextString"])
for row in cursor:
 row[0] = addParentheses
 cursor.updateRow(row)
del row
del cursor 
Well this is nothing like a Field Calculation, so of course the !TextString! won't work. I did not know you were going to this kind of script. Just use the updatecursor itself to do this.
FieldName = arcpy.GetParameterAsText(0)
cursor = arcpy.da.UpdateCursor(History, [FieldName])
for row in cursor:
 row[0] = "(" + row[0] + ")"
 cursor.updateRow(row)
del row
del cursor
The input parameter would be any text field name. So choose "TextString" in that parameter. Or forget the parameter and hard code the field name.
cursor = arcpy.da.UpdateCursor(History, ["TextString"])
for row in cursor:
 row[0] = "(" + row[0] + ")"
 cursor.updateRow(row)
del row
del cursor

JacobDrvar

jdrvar;329266 wrote:
I changed the text to match my field name. My field name is TextString. So, my line of script reads:

"(" + !TextString! + ")"QUOTE]

addParentheses = "(" + !TextString! + ")" returns a Syntax Error. I know the field name and type are correct, therefore, believed the expression to be correct. That left the concatenation of parentheses. But, the concatenation worked within Field Calculator. Then, I went back reread the posts and tried adding a second variable; expression = (!TextString!). Which also created a Syntax Error. So, I removed the exclamation points from the addParentheses variable. Removing the exclamation points, the script runs, and replaces existing text with parentheses. But, I want to concatenate the existing text with parentheses. Any suggestions?

TextString = arcpy.GetParameterAsText(0)
addParentheses = "(" + TextString + ")"

cursor = arcpy.da.UpdateCursor(History, ["TextString"])
for row in cursor:
 row[0] = addParentheses
 cursor.updateRow(row)
del row
del cursor

JacobDrvar

I plan to use a selection within the MXD. So, I would only need to create the statement to add parentheses to the output. Thanks for all of your assistance.

RichardFairhurst

I am running a similiar script to copy & paste annotations, which is why I posted in this thread. The copy & paste part of my script works fine. I have two annotation Feature Classes, but only want the parentheses added to one Annotation Feature Class. Which, is why I attempted to specify the Feature Class to add the parentheses. I probably should have set up a conditional statement.

Your suggestion of "(" + !TextString! + ")" works using Field Calculator. Parentheses are added to selected values within the TextString field.

Since your script is just a geoprocessing script, you could build the Selection and field calculation in Model Builder and export that as a Python Script. If you had been using cursors to do this then it would be the same expression, just set to a specific field in a cursor operating on the correct layer.

A more sophisticated Field Calculator expression could add parentheses only where they did not already exist and otherwise leave the field as it is, so that even if you did not select the records in advance the output would be fine:

def AddParentheses(TextString):
  Output = TextString
  if Output[0] != "(":
    Output = "(" + Output + ")"
  return Output

Expression: AddParentheses(!TextString!)

JacobDrvar

I have no idea what you think you were doing in the second calculation, but that version definitely should not work. Aren't you just using a single feature class for the anno? If two feature classes are involved you never mentioned that.

Screen shot the table and the field calculator dialog set up you used with my original expression. I want to see exactly what you have and what you did.

Use the Field Calculator field list to build the expression and to insert the field name in the calculation. Quotes should be fine, but so should single quotes (only for Python, not for VB Script).

I am running a similiar script to copy & paste annotations, which is why I posted in this thread. The copy & paste part of my script works fine. I have two annotation Feature Classes, but only want the parentheses added to one Annotation Feature Class. Which, is why I attempted to specify the Feature Class to add the parentheses. I probably should have set up a conditional statement.

Your suggestion of "(" + !TextString! + ")" works using Field Calculator. Parentheses are added to selected values within the TextString field.

Table.jpg

FieldCalc.jpg

RichardFairhurst

I changed the text to match my field name. My field name is TextString. So, my line of script reads:

"(" + !TextString! + ")"

But, a Syntax Error is returned. Changing the outer double quotes to single quotes eliminates the syntax error, yet does not add the parentheses. I have a couple of Annotation Feature Classes with the field TextString. Then, I attempted to specify which Feature Class to apply the parentheses.

'(" + (History)!TextString! + ")'

The script does not have any errors. Yet, does not add the parentheses.

I have no idea what you think you were doing in the second calculation, but that version definitely should not work. Aren't you just using a single feature class for the anno? If two feature classes are involved you never mentioned that.

Screen shot the table and the field calculator dialog set up you used with my original expression. I want to see exactly what you have and what you did.

Use the Field Calculator field list to build the expression and to insert the field name in the calculation. Quotes should be fine, but so should single quotes (only for Python, not for VB Script).

JacobDrvar

Than the text should be calculated to a simple Python calculation of:

"(" + !AnnoText! + ")"

where you are calculating the annotation text field and that text field name is AnnoText. Change AnnoText to match your actual annotation text field name.

The same simple calculation in VB Script is:

"(" & [AnnoText] & ")"

I changed the text to match my field name. My field name is TextString. So, my line of script reads:

"(" + !TextString! + ")"

But, a Syntax Error is returned. Changing the outer double quotes to single quotes eliminates the syntax error, yet does not add the parentheses. I have a couple of Annotation Feature Classes with the field TextString. Then, I attempted to specify which Feature Class to apply the parentheses.

'(" + (History)!TextString! + ")'

The script does not have any errors. Yet, does not add the parentheses.

RichardFairhurst

The string is not working. I suspect that is because I asked the wrong question. I have an Annotation Feature Class that is displaying the information as integers within ArcMap, but the field type is a string.

Than the text should be calculated to a simple Python calculation of:

"(" + !AnnoText! + ")"

where you are calculating the annotation text field and that text field name is AnnoText. Change AnnoText to match your actual annotation text field name.

The same simple calculation in VB Script is:

"(" & [AnnoText] & ")"

JacobDrvar

In python to make an integer variable into a string with parentheses added around it you would do something like:

parenInt = "(" + str(myInt) + ")"

where myInt is an integer value variable and parenInt is a string of the interger surrounded by parantheses.

The string is not working. I suspect that is because I asked the wrong question. I have an Annotation Feature Class that is displaying the information as integers within ArcMap, but the field type is a string.

RichardFairhurst

All,

I am writing a similiar script. I need the output to have parentheses added around an integer. For example, instead of 31, I need the output to be (31). Where can I locate information on how to add parentheses?

In python to make an integer variable into a string with parentheses added around it you would do something like:

parenInt = "(" + str(myInt) + ")"

where myInt is an integer value variable and parenInt is a string of the interger surrounded by parantheses.

JacobDrvar

All,

I am writing a similiar script. I need the output to have parentheses added around an integer. For example, instead of 31, I need the output to be (31). Where can I locate information on how to add parentheses?

MikeYoung5

It sounds to me like you are expecting Copy Features to do something it won't do. It won't append features to an existing feature class, it creates a new feature class. To append to an existing feature class and keep any previously existing features you have to use Append.

If you actually do want to overwrite an existing feature class with a new feature class that uses the same name you cannot use the environment overwrite setting in a Python script to do that. That setting does not work in a Python script, it only works in Model Builder. You have to explicitly use the Delete tool to delete an existing feature class and then you can write to the same name the second time. This is how it always works. I have to run a script once without the Delete tool to just generate the outputs during the first run. Then before I can run it any more times I first have to add the Delete tool to the code and then I can run it again.

Based on your second paragraph, I was able to modify the script. The script now runs as intended. It copies from pa, pastes into oa, and deletes the original annotation from pa.

RichardFairhurst

Richard,

The result is the same. The script works, the selected annotation is copied from pa to oa. But, when the script is run the second time, the first copy is nullified, and the annotation(s) revert back from oa to pa. It works like editing and not saving edits. The tricky part seems to be copying & pasting into an existing Feature Class and having the Annotations saved into the Feature Class. I have also tried the Copy_management(input, output), but the statement does not like the existing oa Feature Class. Any further suggestions on how to get the copy & paste to "save"?

Mark,

Your suggestion of copying & pasting to a new Feature Class works. But, I want to use the two existing Annotation Feature Classes within ArcMap.

It sounds to me like you are expecting Copy Features to do something it won't do. It won't append features to an existing feature class, it creates a new feature class. To append to an existing feature class and keep any previously existing features you have to use Append.

If you actually do want to overwrite an existing feature class with a new feature class that uses the same name you cannot use the environment overwrite setting in a Python script to do that. That setting does not work in a Python script, it only works in Model Builder. You have to explicitly use the Delete tool to delete an existing feature class and then you can write to the same name the second time. This is how it always works. I have to run a script once without the Delete tool to just generate the outputs during the first run. Then before I can run it any more times I first have to add the Delete tool to the code and then I can run it again.

MikeYoung5

Try:

arcpy.CopyFeatures_management(pa, oa.dataSource)

pa should be the layer, because it has a selection, but dataSource should get the feature class and path for the output.

Richard,

The result is the same. The script works, the selected annotation is copied from pa to oa. But, when the script is run the second time, the first copy is nullified, and the annotation(s) revert back from oa to pa. It works like editing and not saving edits. The tricky part seems to be copying & pasting into an existing Feature Class and having the Annotations saved into the Feature Class. I have also tried the Copy_management(input, output), but the statement does not like the existing oa Feature Class. Any further suggestions on how to get the copy & paste to "save"?

Mark,

Your suggestion of copying & pasting to a new Feature Class works. But, I want to use the two existing Annotation Feature Classes within ArcMap.

RichardFairhurst

Richard,

I have tested each of the suggestions multiple times and my results were unsuccessful.
arcpy.CopyFeatures_management(pa, oa) approach returns the Error 840: The value is not a Feature Class.
arcpy.CopyFeatures_management(pa.name, oa.name approach runs but does not work.

But, arcpy.env.workspace = "C:\Working\MyData\Python.gdb"
arcpy.CopyFeatures_management("PropertyAnno", "OwnerAnno") works. An annotation is selected and using the Select Features tool, the script runs, and copies and pastes the annotation from PropertyAnno into OwnerAnno.

The issue is with:

pa = arcpy.mapping.ListLayers(mxd, "PropertyAnno", df)[0]
oa = arcpy.mapping.ListLayers(mxd, "OwnerAnno", df)[0]

They are defined as Layers, but the output requires a Feature Class. Commenting those out, the script works outside of an edit session. But, when the script is run multiple times, the previous copy does not save. How can the copy be saved?

Mark, I am currently testing your suggestion.

Try:

arcpy.CopyFeatures_management(pa, oa.dataSource)

pa should be the layer, because it has a selection, but dataSource should get the feature class and path for the output.

AdamCrateau1

Hello,

I am trying to do a similar task:

1. Make a selection_by_attributes on a .gdb Annotation layer.
2. Copy & Paste this selection into an Existing .gdb Annotation layer. Further, I'd like to copy the selected annotation into a specific annotation class within the specified target layer.

I am able to do this in an editing session. Is this possible using python? Can you use cursors to copy and paste features from one FC to another?

Thanks.

MikeYoung5

It doesn't work because you are telling the CopyFeatures_management to use the literal strings "pa" and "oa", which are not the names of any layers. Unquote those variables and possibly use the .name property as you did in the messages. So try either:

arcpy.CopyFeatures_management(pa, oa)

or try

arcpy.CopyFeatures_management(pa.name, oa.name)

Richard,

I have tested each of the suggestions multiple times and my results were unsuccessful.
arcpy.CopyFeatures_management(pa, oa) approach returns the Error 840: The value is not a Feature Class.
arcpy.CopyFeatures_management(pa.name, oa.name approach runs but does not work.

But, arcpy.env.workspace = "C:\Working\MyData\Python.gdb"
arcpy.CopyFeatures_management("PropertyAnno", "OwnerAnno") works. An annotation is selected and using the Select Features tool, the script runs, and copies and pastes the annotation from PropertyAnno into OwnerAnno.

The issue is with:

pa = arcpy.mapping.ListLayers(mxd, "PropertyAnno", df)[0]
oa = arcpy.mapping.ListLayers(mxd, "OwnerAnno", df)[0]

They are defined as Layers, but the output requires a Feature Class. Commenting those out, the script works outside of an edit session. But, when the script is run multiple times, the previous copy does not save. How can the copy be saved?

Mark, I am currently testing your suggestion.

RichardFairhurst

I am confused as to why the script does not work. I believe something is wrong my CopyFeatures_management statement.
import arcpy

arcpy.env.workSpace = "C:\Working\MyData\Python.gdb"
arcpy.env.overwriteOutput = 'True'

mxd = arcpy.mapping.MapDocument ("CURRENT") 
df = arcpy.mapping.ListDataFrames (mxd)[0] 
pa = arcpy.mapping.ListLayers(mxd, "PropertyAnno", df)[0]
oa = arcpy.mapping.ListLayers(mxd, "OwnerAnno", df)[0]
arcpy.AddMessage(pa.name)
arcpy.AddMessage(oa.name)

arcpy.CopyFeatures_management("pa", "oa")
Yet, if I write a basic script the CopyFeatures_management works. I only want to copy selected features & paste into an existing Feature Class, not create a new Feature Class.

import arcpy
try:
    arcpy.env.workspace = "C:\Working\MyData\Python.gdb"

    arcpy.CopyFeatures_management("HomeValue", "Test")
except:
    print arcpy.GetMessages()

It doesn't work because you are telling the CopyFeatures_management to use the literal strings "pa" and "oa", which are not the names of any layers. Unquote those variables and possibly use the .name property as you did in the messages. So try either:

arcpy.CopyFeatures_management(pa, oa)

or try

arcpy.CopyFeatures_management(pa.name, oa.name)

markdenil

pa = arcpy.mapping.ListLayers(mxd, "PropertyAnno", df)[0]
#      pa is the input: it is a layer in arcMap. 
#      Copy Features accepts a layer as input, 
#      so you can have selected or query defined subsets of the FC features

oa = arcpy.mapping.ListLayers(mxd, "OwnerAnno", df)[0]
#      oa is supposed to be the output: it is a layer in arcMap. 
#      Copy Features cannot accept a layer as output; it must write to a fc on disc
#      since the oa layer is in your open ArcMap session, the underlying FC is locked
#      so you cannot write to the underlyng FC either

fc = r"C:\Working\MyData\Python.gdb\AnAnnotationFC"
#      fc is an annotation FC in the same gdb, but is NOT in the open mxd
#      try writing to that


arcpy.CopyFeatures_management(pa, fc)

MikeYoung5

I am confused as to why the script does not work. I believe something is wrong my CopyFeatures_management statement.

import arcpy

arcpy.env.workSpace = "C:\Working\MyData\Python.gdb"
arcpy.env.overwriteOutput = 'True'

mxd = arcpy.mapping.MapDocument ("CURRENT") 
df = arcpy.mapping.ListDataFrames (mxd)[0] 
pa = arcpy.mapping.ListLayers(mxd, "PropertyAnno", df)[0]
oa = arcpy.mapping.ListLayers(mxd, "OwnerAnno", df)[0]
arcpy.AddMessage(pa.name)
arcpy.AddMessage(oa.name)

arcpy.CopyFeatures_management("pa", "oa")

Yet, if I write a basic script the CopyFeatures_management works. I only want to copy selected features & paste into an existing Feature Class, not create a new Feature Class.

import arcpy
try:
    arcpy.env.workspace = "C:\Working\MyData\Python.gdb"

    arcpy.CopyFeatures_management("HomeValue", "Test")
except:
    print arcpy.GetMessages()

MikeYoung5

The feature layer at its core is a feature class, but the layer itself is on top of that and is a Desktop display wrapper that defines its output location as a layer designed for placement in a map dataframe, not as a feature class file in a directory. This geoprocessing tool cannot use the layer wrapper that hides the feature class information from the tool.

That is why when you interactively complete the tool you cannot drag a layer into the output text box of the CopyFeatures tool or type a layer name into the output of the tool. You have to navigate directories to fill in that part of the tool dialog with a full feature class path or you must only connect raw feature class variables or tool outputs that store direct pointers to a feature class path. Layers are only an indirect pointer to a feature class, not a direct pointer.

Although many people use the term layer indiscriminately to refer to both what you see in the TOC of a Desktop map and the underlying data in ArcCatalog, technically the term is actually only correctly used to refer to what you see in a Desktop map TOC. The data stored on disk seen in ArcCatalog is only a feature class that has its own independent existence even if it was never used to create a layer in a Desktop map TOC. Likewise, layers can exist without a feature class (when a layer has a red exclamation mark due to a lost data connection it is still a layer even though it has no feature class and virtually no real functionality).

Layers can refer to anything with the ArcMap TOC (as you mention) and files with the .lyr extension.

Your logic makes sense. For a tool to run, the input and output folder locations are required.

Therefore, once the environment is set, an error is still returned saying pa does not exist or is not supported. Only one environment is set, since the input and output locations are the same, and the file names remain the same(both are stored within the same File Geodatabase). Is the issue with overwriting the output file?

RichardFairhurst

Mark,

How is oa not a Feature Class? ArcCatalog and ArcMap list the Data Type as a File Geodatabase Feature Class.

The feature layer at its core is a feature class, but the layer itself is on top of that and is a Desktop display wrapper that defines its output location as a layer designed for placement in a map dataframe, not as a feature class file in a directory. This geoprocessing tool cannot use the layer wrapper that hides the feature class information from the tool.

That is why when you interactively complete the tool you cannot drag a layer into the output text box of the CopyFeatures tool or type a layer name into the output of the tool. You have to navigate directories to fill in that part of the tool dialog with a full feature class path or you must only connect raw feature class variables or tool outputs that store direct pointers to a feature class path. Layers are only an indirect pointer to a feature class, not a direct pointer.

Although many people use the term layer indiscriminately to refer to both what you see in the TOC of a Desktop map and the underlying data in ArcCatalog, technically the term is actually only correctly used to refer to what you see in a Desktop map TOC. The data stored on disk seen in ArcCatalog is only a feature class that has its own independent existence even if it was never used to create a layer in a Desktop map TOC. Likewise, layers can exist without a feature class (when a layer has a red exclamation mark due to a lost data connection it is still a layer even though it has no feature class and virtually no real functionality).

MikeYoung5

The output of CopyFeatures is a feature class, not a layer.

oa is a layer, not a Feature Class.

Mark,

How is oa not a Feature Class? ArcCatalog and ArcMap list the Data Type as a File Geodatabase Feature Class.

markdenil

The output of CopyFeatures is a feature class, not a layer.

oa is a layer, not a Feature Class.

MikeYoung5

Does anyone have a suggestion on how to fix the CopyFeatures_management statement? The input and outputs are specified. What else is missing? Also, I am using Feature Classes instead of layers.

MikeYoung5

What do you mean by "cut & paste annotations"?
Copy Features respects feature selections on layers....

I want to cut and paste from one annotation layer to another. Basically, I want the same functionality as the cut & paste buttons from the standard toolbar.

import arcpy

mxd = arcpy.mapping.MapDocument ("CURRENT")
df = arcpy.mapping.ListDataFrames (mxd)[0]
pa = arcpy.mapping.ListLayers(mxd, "PropertyAnno", df)[0]
oa = arcpy.mapping.ListLayers(mxd, "OwnerAnno", df)[0]
arcpy.AddMessage(pa.name)
arcpy.AddMessage(oa.name)

arcpy.CopyFeatures_management(pa, oa)

An ExecuteError is thrown. ExecuteError: Failed to execute. Parameters are not valid. ERROR 840: The value is not a Feature Class.

markdenil

What do you mean by "cut & paste annotations"?
Copy Features respects feature selections on layers....

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.