topic Re: calculate field add string multiple fields in ArcGIS Pro Questions

calculate field add string multiple fields

JaredPilbeam2 — Thu, 08 Apr 2021 20:26:24 GMT

I used to be able to use Python and auto-fill fields by putting the string in quotes. For some reason it hasn't been working lately. I'm using Pro v. 2.7.2. The expression verifies and the there are no errors, but the (text) fields are not populated with the string? The field length is set at 300, more than enough.

Re: calculate field add string multiple fields

JoeBorgione — Thu, 08 Apr 2021 20:51:45 GMT

What if you put an r in front of that statement like this:

r"https://blah/blah.blah/blah/blah.png"

I get it to work with or without the r which is basically short for 'raw' text so any escaped characters are taken literally: see this article for a more detailed explanation.

Re: calculate field add string multiple fields

JayantaPoddar — Thu, 08 Apr 2021 21:05:42 GMT

Please check if there are any undesired selected features in the input table? Ensure the table is not being edited by any other instance/application. Else reload the layer in ArcGIS Pro.

I am also using ArcGIS Pro 2.7.2, and adding an HTML path works just fine.

Re: calculate field add string multiple fields

JaredPilbeam2 — Thu, 08 Apr 2021 21:09:44 GMT

@JoeBorgione
It didn't hurt anything, but also didn't help.

Strange. It's such a simple thing that I've always been able to do. I've also tried the same expression on a different table that has a text field with the length set to 256, which is still more than enough. It would not work either.

Re: calculate field add string multiple fields

JoeBorgione — Thu, 08 Apr 2021 21:11:30 GMT

@JayantaPoddar brings up a good point: is this feature published anywhere? You'd need to shut down the service it is associated with if so...

Re: calculate field add string multiple fields

JaredPilbeam2 — Thu, 08 Apr 2021 21:12:04 GMT

@JayantaPoddar

What's an example of an "undesired selected feature"?

Re: calculate field add string multiple fields

JayantaPoddar — Thu, 08 Apr 2021 21:16:38 GMT

Any feature remained selected by mistake.

I guess that might not be the case.

You may try closing all ArcGIS Pro sessions > Open a new ArcGIS Pro session > Add the table > Calculate Field.

Let us know if this resolves the issue or not.

Re: calculate field add string multiple fields

JaredPilbeam2 — Thu, 08 Apr 2021 21:20:24 GMT

@JoeBorgione @JayantaPoddar

Well, I'm working on a hosted feature layer in Pro. So, yes, it's a published layer on AGOL. I'm signed in to my account in Pro and have added the hosted layer to the map via the Portal in the Catalog.

EDIT: I've since closed the browser which called the hosted layer then ran the field calculator again. No difference.

Re: calculate field add string multiple fields

JayantaPoddar — Thu, 08 Apr 2021 21:21:37 GMT

Are you editing the hosted feature table? If not, you may remove it from the map.

Re: calculate field add string multiple fields

JoeBorgione — Thu, 08 Apr 2021 21:31:22 GMT

Hmm. I just upgraded from 2.7.1 to 2.7.2 and grabbed a feature layer from my agol account; it all works for me. What I meant was if the feature you are editing is the source data for a published feature layer, like an enterprise gdb feature class that you published to a portal (including agol)

Re: calculate field add string multiple fields

DanPatterson — Thu, 08 Apr 2021 23:06:38 GMT

Did you try anything other than a an http?

"a"*10 or "a"*100 or "a"*300

Also, shut down, restart works for many problems too

Re: calculate field add string multiple fields

JaredPilbeam2 — Fri, 09 Apr 2021 16:15:39 GMT

@DanPatterson

I restarted (not because of this but a Windows sign-in issue) and now the field calculator is working. I wish I can say what the root of the problem was? All that I can say is that this hosted feature layer is not open in any browser, just Pro where I'm editing it.

Re: calculate field add string multiple fields

JoeBorgione — Fri, 09 Apr 2021 16:13:15 GMT

These guys always have a solution....

Re: calculate field add string multiple fields

DanPatterson — Fri, 09 Apr 2021 19:36:20 GMT

As I said....

Also, shut down, restart works for many problems too

So what was in the accepted solution that worked?

Re: calculate field add string multiple fields

JaredPilbeam2 — Fri, 09 Apr 2021 19:51:02 GMT

I could've accepted any of the replies since I don't really know what was causing the problem? But, I went with that one because I assumed it has something to do with that service being open in a browser that I had open at the time? Yes, it could have just needed a reset too.