topic Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ? in ArcGIS Pro Questions

ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Fri, 26 Jan 2018 16:05:39 GMT

Hi,

Just a simple question. From the Catalog Pane, if I right-click a shapefile -> Design -> Fields, I can view the fields but cannot edit them, such as making a field Nullable for example.

All the fields are greyed out!

Morever, I made these fields with the ModelBuilder Add Field with a variable set to IsNullable (as the option is not included in the Add Field right-click settings in ModelBuilder)

Finally, if I use Delete Fields (as below), these fields still show up in the Field design pane! As a result, the ModelBuilder crash because it considers these fields still existing...

I am puzzled and I suspect ArcGIS Pro do not refresh features classes after geoprocessing... If I restart, these fields do not show up and I can run the Model...

Any help appreciated

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

DanPatterson_Retired — Fri, 26 Jan 2018 16:56:34 GMT

I don't know about modelbuilder, but there are lots of ways to get to designing fields

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Fri, 26 Jan 2018 17:56:21 GMT

Hi,

Following my previous post, it looks like Nullable field are not possible on shapefile, which would explain the greyed out part in the Field Design pane and the IsNullable variable not applied in the ModelBuilder above...

If that's the case, how a newly calculated field would work is Null value are not allowed? In the same model, I receive the following error and I cannot complete the ModelBuilder!

How can I calculate this field?

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

DanPatterson_Retired — Fri, 26 Jan 2018 18:07:06 GMT

Shapefile fields are not nullable for sure so if at some stage you are using Add Field http://pro.arcgis.com/en/pro-app/tool-reference/data-management/add-field.htm

make sure you set it so that the field is not nullable

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Fri, 26 Jan 2018 18:32:40 GMT

Thanks Dan for your insight.

You are correct, I cannot add a Nullable field in a shapefile. The Calculate Field in my Model gives an error when it tries to calculate a Null field. This is illustrated here from the attribute table:

It is obvious. The column on the left cannot be Null and as a result, it cannot "calculate" the value coming from the right column.

That's ok, but how is it possible to skip these Null values from Calculate Field?

With ArcMap 10.5.1, I used to receive warnings for such cases but the processes could continue into my Model until it was finished...

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Fri, 26 Jan 2018 18:50:34 GMT

Unless I write a Python expression in the Code Block with an if statment to test if there is a Null value:

If Null value -> not calculate

Else -> Calculate

Tedious but it could work

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

DanPatterson_Retired — Fri, 26 Jan 2018 19:22:22 GMT

python parser for calculate

if not None:

... calculate value...

would be safer since 'null' is a slippery concept, but None will work

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Mon, 29 Jan 2018 13:29:36 GMT

I tried and tried again and I cannot figure out the proper syntax:

The Model joins a shapefile in which I would like to calculate the OPERATOR field (which cannot be Nullable) and a text tab delimited joined table. The Python function should be quite simple but it does not work! And the process in the Model do not even consider as correct and colored in green... Where is the error?

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

DanPatterson_Retired — Mon, 29 Jan 2018 13:43:43 GMT

if that is a python code block

if operator is None:

return operator

if and is are not capitalized.

As for the field that you are passing to test( ) I presume it is a field in the destination table and not the table you are using to join to it.

Barring that.... Do the calculate field manually using Calculate Field and get the correct syntax in the Results window. It will have the correct python syntax

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Mon, 29 Jan 2018 15:47:06 GMT

Dan, your advice helped with the syntax, with capital letters and indentation. Now ArcGIS Pro seems to recognize it and highlight python keywords in blue, and the box in ModelBuilder turns yellow for the process:

But still when I run the tool, I get the error because the field in not nullable in the shapefile! It should not because the If statment from the Code Block is supposed to filter out Null values (None)

This is just a nightmare!

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

DanPatterson_Retired — Mon, 29 Jan 2018 16:49:27 GMT

I know this is from PRO, but it is the same in 'Map see the code block

assuming your field is called that, field.isNullable

http://pro.arcgis.com/en/pro-app/arcpy/classes/field.htm

Test the field...

isNullable

(Read and Write)

Indicates if the field can contain null values.

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Mon, 29 Jan 2018 17:09:59 GMT

Found the solution!

When there was a Null value in the joined table, the conditional statment could not "leave" a Null value in the shapefile. Instead, I inserted an else statment to return an empty value!

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Mon, 29 Jan 2018 17:44:42 GMT

Just one last question, I cannot Calculate Field containing the silly ~ sign, such as in ALASKA~C. How can I improve my code to deal with these ~ signs?

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

DanPatterson_Retired — Mon, 29 Jan 2018 17:52:47 GMT

don't know...

also, in your accepted answer, also add a check to see if the field is numeric since it will have to return 0 rather than ''... hence the suggested 'isNullable' check, because if it isn't nullable, then it already has the shapefile equivalent for None (aka '' for text and 0 for numbers)

Re: ArcGIS Pro 2.0 | How to design Fields in shapefile from Catalog Pane ?

VincentLaunstorfer — Tue, 30 Jan 2018 10:15:12 GMT

Thanks Dan. You're correct, I should check if the field is Numeric or Text in order to assign either 0 or ''. This would make the code more robust. Will investigate this soon...

Otherwise, Calculate Field with special character such as ~ did finally work with the code shown below (don't know waht happened yesterday!)