topic Re: Macros in ArcGIS Pro? in ArcGIS Pro Questions

Macros in ArcGIS Pro?

HectorBorro1 — Tue, 26 Jul 2016 22:59:41 GMT

Hi, Anyone knows how to run an automated process?

I need to to the following 280 times:

select layer by attribute
clip
Label
Change label field
Symbology: Graduated Colors
Change Field
set Method: Quantiles
set Clases: 5
set Color Scheme

Many thanks for any guidance!

Re: Macros in ArcGIS Pro?

DanPatterson_Retired — Tue, 26 Jul 2016 23:11:55 GMT

If you use tools in arctoolbox in PRO, then the process can be automated using modelbuilder

What is ModelBuilder?—ArcGIS Pro | ArcGIS for Desktop

If not, then your task is going to have to entail a different strategy.

Using tools in Python—Geoprocessing and Python | ArcGIS for Desktop

ArcGIS Pro SDK | ArcGIS for Desktop

Re: Macros in ArcGIS Pro?

HectorBorro1 — Tue, 26 Jul 2016 23:19:14 GMT

thanks!

It's time to learn Model Builder... I was a bit adamant about it. but the alternative is Phyton, which for the moment I don't know...

I'll let you know how it goes.

Re: Macros in ArcGIS Pro?

HectorBorro1 — Wed, 27 Jul 2016 13:30:02 GMT

Ok, So I built my model... The old dog is learning new tricks...

now the task is to automate it...

3 questions:
1. How to set the attribute to a variable. my SQL query is STORE = '1234' or I could use FID in an incemental way?

2. The resulting layer name should be Income_1234. shp where 1234 is the store number

3. How to apply the symbology and labeling?

thanks!

Re: Macros in ArcGIS Pro?

LeileiDuan1 — Wed, 27 Jul 2016 13:54:15 GMT

If I understand correctly, you were trying to loop through the attribute table and run analysis on each record right? If that's the case, Iterators in Model Builders can be quite helpful.

Iterators—ArcGIS Pro | ArcGIS for Desktop

Examples of using iterators in ModelBuilder—Tools | ArcGIS for Desktop

I haven't tried to apply symbology through ModelBuilder before, but it seems like this tool here could be a good start. The idea is to apply a symbology layer to your target layers. Just gave me something to try out this morning.

Re: Macros in ArcGIS Pro?

DanPatterson_Retired — Wed, 27 Jul 2016 14:06:10 GMT

To make inputs changeable, they need to be specified as a parameter, so that there is a 'P' by the oval etc

have a read through that whole section

Creating model parameters—Help | ArcGIS for Desktop

Re: Macros in ArcGIS Pro?

LR — Wed, 27 Jul 2016 16:15:41 GMT

I threw something together real quick, it's not complete but should help I hope. You iterate through all features in your layer (found under Insert), get each feature's FID for example and use that to name your output layers (Variable enclosed in %). Mind the precondition here, which basically means "don't do the step, before the precondition has finished". This ensures you get the proper Val.

Afterwards you could apply the Symbology from another layer - just define one that covers everything you need to show in your seperate layers. IDK why I can't use this with the clipping output, you might need to make a second model and iterate through those afterwards. You can unfortunately only use one Iterator per model .

Re: Macros in ArcGIS Pro?

HectorBorro1 — Wed, 27 Jul 2016 18:40:22 GMT

Thanks Dan Patterson, L R, Leilei Duan
I managed to create the iteration and I'll run it in a bit.

One question comes to mind when using Apply Symbology From Layer—Data Management toolbox | ArcGIS for Desktop as the same problem arises when trying to apply the Symbology...

How could I make the second iteration to apply the symbology and labels?

Re: Macros in ArcGIS Pro?

HectorBorro1 — Wed, 27 Jul 2016 18:41:20 GMT

BTW.. I already have a Style created for this purpose, but can't use it in the ModelBuilder...

Re: Macros in ArcGIS Pro?

HectorBorro1 — Wed, 27 Jul 2016 18:55:02 GMT

It looks like Aplly symbology can't be done on an iteration...

It is not allowing me to get the input working....

Re: Macros in ArcGIS Pro?

LeileiDuan1 — Wed, 27 Jul 2016 19:11:27 GMT

It's like LR mentioned above, ModelBuilder only allows one iterator. To use another iteration you have to build another model and integrate them together by dragging and dropping one model into the other. In my case, I made the first model output a precondition to the second model.

Looks like you already figured out the second iterator. It seems that Apply Symbology From Layer works if you add a step to make sure that the input is a layer file. (Mine is not valid because I don't have a symbology layer put in)

Re: Macros in ArcGIS Pro?

HectorBorro1 — Wed, 27 Jul 2016 20:59:22 GMT

great, thanks!

looks we are on the right direction...

I ran it, but I get some error messages. Any idea what may be causing them? It seems the Select layer by attribute is not the same value as

Here's the log:

Executing (Iterate Row Selection): IterateRowSelection "Polygons" "STORE#" true

Start Time: miércoles, 27 de julio de 2016 15:50:56

Executing (Make Feature Layer): MakeFeatureLayer "Polygons" "I_Polygons_STORE" ""STORE" = '3421'" # #

Start Time: miércoles, 27 de julio de 2016 15:50:56

Succeeded at miércoles, 27 de julio de 2016 15:50:56 (Elapsed Time: 0.03 seconds)

Succeeded at miércoles, 27 de julio de 2016 15:50:56 (Elapsed Time: 0.05 seconds)

Executing (Select Layer By Attribute): SelectLayerByAttribute "I_Polygons_STORE" "New selection" "STORE= 3421" NON_INVERT

Start Time: miércoles, 27 de julio de 2016 15:50:57

The process did not execute because the precondition is false.

Succeeded at miércoles, 27 de julio de 2016 15:50:57 (Elapsed Time: 0.00 seconds)

Executing (Clip): Clip "I_Polygons_STORE" "Factor INDIVIDUAL nacional" "C:\\Output\Layers\CL3421_IND_auto.shp" #

Start Time: miércoles, 27 de julio de 2016 15:50:57

All the inputs are not current.

Succeeded at miércoles, 27 de julio de 2016 15:50:57 (Elapsed Time: 0.00 seconds)

Re: Macros in ArcGIS Pro?

HectorBorro1 — Wed, 27 Jul 2016 21:31:31 GMT

Quick update:

With your previous idea Leilei Duan of Make Feature Layer, I incorporated it into the first model. So there is no need to nest 2 models!

Now the question is what are your parameters for Selecting Layer by attribute? I can't seem to create the expression based on the STORE attribute

it seems that I can't build an expression as it has no input until it runs....

Re: Macros in ArcGIS Pro?

LR — Thu, 28 Jul 2016 10:12:41 GMT

Right-click "Select Layer By Attribute" --> Make Variable --> From Parameter --> Expression. Then mark the expression bubble as parameter. This should give you an expression field when you run your model. The query builder should be populated with your selected data's attribute fields.

Re: Macros in ArcGIS Pro?

XanderBakker — Thu, 28 Jul 2016 11:19:54 GMT

As a side note, also have a look at Tasks: What is a task?—ArcGIS Pro | ArcGIS for Desktop This provides a more interactive way of automating workflows.

Re: Macros in ArcGIS Pro?

LeileiDuan1 — Thu, 28 Jul 2016 14:14:55 GMT

Hector can you send me a sample of your data so I can help you the best way I could? You should be able to send me messages since I just followed you.

Re: Macros in ArcGIS Pro?

HectorBorro1 — Fri, 29 Jul 2016 16:19:34 GMT

I found that when doing an iteration by rows there is no need to select by attributes as the attribute I'm interested in selecting is the one that is being itereated, so it is a duplicate process and can be removed...