topic Re: Trouble Understanding Get Count in ModelBuilder Questions

topic Re: Trouble Understanding Get Count in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836731#M2793 <HTML><HEAD></HEAD><BODY><P>Quick update. I changed over to the following python script:</P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">import</SPAN> arcpy locno <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> year <SPAN class="operator token">=</SPAN> locno<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN> workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"O:/plan/luam/1p2007/"</SPAN> <SPAN class="operator token">+</SPAN> year <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> locno <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/data_for_item.gdb"</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace inFc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'in_memory\AddressSelect'</SPAN> numRecords <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>inFc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> numRecords <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>     arcpy<SPAN class="punctuation token">.</SPAN>AddError<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Incorrect address. Please try again.'</SPAN><SPAN class="punctuation token">)</SPAN>     result <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN> <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>     result <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> result<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P>I tried it both using AddWarning and AddError.</P><P>AddWarning gives the following to the output then continues to run through all tools/scripts providing either the message 'precondition is false' or 'inputs are not current':</P><P><IMG __jive_id="270084" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/270084_pastedImage_1.png" /></P><P>AddError provides the following, and seems to be a bit 'cleaner' and I think easier for the end user to know that something is not right:</P><P><IMG __jive_id="270085" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/270085_pastedImage_2.png" /></P><P>Something I find interesting is the script with AddWarning does display as Completed at the top left of the form while the AddError script shows Executing Test For Records... is that because in the case of AddWarning, the model did complete and with AddError it did not?</P></BODY></HTML> Sun, 12 Dec 2021 10:09:45 GMT ChrisHolmes 2021-12-12T10:09:45Z Trouble Understanding Get Count https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836726#M2788 <HTML><HEAD></HEAD><BODY><P>Good day everyone,</P><P>I think I'm having some trouble understanding how to make use of Get Count. I have the following:</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/269479_pastedImage_1.png" /></P><P>What I want to see happen is if Row Count = 0 > End the model. If Row Count > 0 continue the model. What I see is when Row Count > 0 the model continues and when Row Count = 0 it just seems to spin it's wheels for a bit (30 seconds) then end. I don't know if maybe it has something to do with Select Layer By Location using AddressSelect as it's Selecting Features? Or maybe I'm just using Get Count completely wrong and there's a different way I should be approaching this.</P><P></P><P>Thanks for the help,</P><P>Chris</P></BODY></HTML> Tue, 22 Nov 2016 16:07:31 GMT https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836726#M2788 ChrisHolmes 2016-11-22T16:07:31Z Re: Trouble Understanding Get Count https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836727#M2789 <HTML><HEAD></HEAD><BODY><P>Upon further investigation, it looks like maybe it is working. When Row Count = 0 it continues going through all tools/scripts it just doesn't execute them, due to either "precondition is false" or "inputs are not current". The following is what is displayed. Now that I think it's working, would there be a way to add in a arcpy.AddWarning("Incorrect address, try again") in addition to or in lieu of all of the precondition is false... inputs are not current...</P><P></P><P>Thanks!</P><P></P><P>Executing: FinalModel22 "7 windermure rd sw" M-4</P><P>Start Time: Tue Nov 22 13:01:22 2016</P><DIR><SPAN style="font-size: small;"> </SPAN><P>Executing (GetLocNo): GetLocNo</P><P>Start Time: Tue Nov 22 13:01:23 2016</P><P>Running script GetLocNo...</P><P>Completed script GetLocNo...</P><P>Succeeded at Tue Nov 22 13:01:25 2016 (Elapsed Time: 2.50 seconds)</P><P>Executing (Select): Select "Construction Layers\CALGIS.ADDRESS_POSSE" in_memory\AddressSelect "ADDRESS =UPPER('7 windermure rd sw')"</P><P>Start Time: Tue Nov 22 13:01:25 2016</P><P><SPAN style="color: #008000; font-size: small;">WARNING </SPAN><SPAN style="color: #700000; font-size: small;">000117</SPAN><SPAN style="color: #008000; font-size: small;">: Warning empty output generated.</SPAN></P><SPAN style="color: #008000; font-size: small;"> </SPAN><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.73 seconds)</P><P>Executing (Get Count): GetCount in_memory\AddressSelect</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>Row Count = 0</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Select Layer By Location): SelectLayerByLocation "Construction Layers\OPF - Ownership Parcel Fabric\CALGIS.OPF_PARCEL" INTERSECT in_memory\AddressSelect # NEW_SELECTION</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>The process did not execute because the precondition is false.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Zoom To Selected Feature): ZoomToSelected</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Append): Append 'Construction Layers\OPF - Ownership Parcel Fabric\CALGIS.OPF_PARCEL' site_polygon NO_TEST # #</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Append (2)): Append 'Construction Layers\OPF - Ownership Parcel Fabric\CALGIS.OPF_PARCEL' "PROPOSED - proposed_LUD_polygon - OUTLINE" NO_TEST # #</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Update Proposed Lud Polygon Info): UpdateProposedLudPolygonInfo LOC2017-0016 M-4</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Update Site Polygon Info): UpdateSitePolygonInfo LOC2017-0016</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Set Scale): SetScale400</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P><P>Executing (Create Site Location): CreateSiteLocation #</P><P>Start Time: Tue Nov 22 13:01:26 2016</P><P>All the inputs are not current.</P><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 0.00 seconds)</P></DIR><P>Succeeded at Tue Nov 22 13:01:26 2016 (Elapsed Time: 3.44 seconds)</P></BODY></HTML> Tue, 22 Nov 2016 20:14:24 GMT https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836727#M2789 ChrisHolmes 2016-11-22T20:14:24Z Re: Trouble Understanding Get Count https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836728#M2790 <HTML><HEAD></HEAD><BODY><P>The output of the Get Count tool is of type integer, which when it has the value of zero is interpreted as false when linked to the next tool in the chain as a precondition.  This can cause problems when you want the tool to <EM>continue</EM> when the count is zero. In situations like that you are better off running the Get Count inside a Python function (arcpy.GetCount_management(lyr)) in the Calculate Value tool (that is, hiding the results from the Model Builder) and returning true or false as Boolean based on the Get Count result.</P></BODY></HTML> Wed, 23 Nov 2016 03:19:26 GMT https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836728#M2790 curtvprice 2016-11-23T03:19:26Z Re: Trouble Understanding Get Count https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836729#M2791 <HTML><HEAD></HEAD><BODY><P>In response to this question:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Could there be a way to add in a arcpy.AddWarning("Incorrect address, try again") in addition to or in lieu of all of the precondition is false... inputs are not current...</P></BLOCKQUOTE><P>Without <A href="https://blogs.esri.com/esri/arcgis/2011/09/12/modelbuilderifthenelse3/" rel="nofollow noopener noreferrer" target="_blank">building a python script to print the messages,</A> you can do this in the Calculate Value tool. I have discovered you cannot embed "\n" in the Calculate value tool; I use chr(12) instead to print newlines.</P><P></P><P>Expression</P><PRE class="lia-code-sample line-numbers language-none"><CODE>test<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"%AddressSelect%"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P>Code Block:</P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">def</SPAN> <SPAN class="token function">test</SPAN><SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>    <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">:</SPAN>        <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"{0}{0}Incorrect address{0}{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>chr<SPAN class="punctuation token">(</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>Data Type: String</P><P></P><P>This will print (in the middle of your messages):</P><PRE class="lia-code-sample line-numbers language-none"><CODE> Incorrect Address ‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>But I think no matter what you do you'll see all those warning messages about inputs not current. If you really want full control of messages, you need to start thinking about Python scripting. Model Builder is awesome, but it has its limits.</P></BODY></HTML> Sun, 12 Dec 2021 10:09:42 GMT https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836729#M2791 curtvprice 2021-12-12T10:09:42Z Re: Trouble Understanding Get Count https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836730#M2792 <HTML><HEAD></HEAD><BODY><P>Super. Thanks for your time Curtis.</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Wed, 23 Nov 2016 03:42:13 GMT https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836730#M2792 ChrisHolmes 2016-11-23T03:42:13Z Re: Trouble Understanding Get Count https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836731#M2793 <HTML><HEAD></HEAD><BODY><P>Quick update. I changed over to the following python script:</P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">import</SPAN> arcpy locno <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> year <SPAN class="operator token">=</SPAN> locno<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN> workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"O:/plan/luam/1p2007/"</SPAN> <SPAN class="operator token">+</SPAN> year <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> locno <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/data_for_item.gdb"</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace inFc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'in_memory\AddressSelect'</SPAN> numRecords <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>inFc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> numRecords <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>     arcpy<SPAN class="punctuation token">.</SPAN>AddError<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Incorrect address. Please try again.'</SPAN><SPAN class="punctuation token">)</SPAN>     result <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN> <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>     result <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> result<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P>I tried it both using AddWarning and AddError.</P><P>AddWarning gives the following to the output then continues to run through all tools/scripts providing either the message 'precondition is false' or 'inputs are not current':</P><P><IMG __jive_id="270084" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/270084_pastedImage_1.png" /></P><P>AddError provides the following, and seems to be a bit 'cleaner' and I think easier for the end user to know that something is not right:</P><P><IMG __jive_id="270085" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/270085_pastedImage_2.png" /></P><P>Something I find interesting is the script with AddWarning does display as Completed at the top left of the form while the AddError script shows Executing Test For Records... is that because in the case of AddWarning, the model did complete and with AddError it did not?</P></BODY></HTML> Sun, 12 Dec 2021 10:09:45 GMT https://community.esri.com/t5/modelbuilder-questions/trouble-understanding-get-count/m-p/836731#M2793 ChrisHolmes 2021-12-12T10:09:45Z