I posted a similar question two weeks ago here. I must be missing something.
How do I get the Summary Reports GP Tool's Area Description parameter to work, as in appear in my output?
Here's what I'm doing:
How do I get my site name into that empty cell?
I know I can wrap this tool in python, and before invoking it, parse the report.xml, and insert my site name into the xml. It just seems like Area Description should work.
Solved! Go to Solution.
I figured it out.
A few notes:
I should have named this post "How to get the site name to appear in the output summary report?" I thought area description was correct because the comparison table editor in the infographic builder looks like this -
The report.xml contains a table definition that looks like this -
<tr height="26.94076">
<td style="font-size:9.75;" align="center" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">Sites</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2000 Total Population (U.S. Census)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2010 Total Population (U.S. Census)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2020 Total Population (U.S. Census)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2023 Total Population (Esri)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2028 Total Population (Esri)</td>
</tr>
<tr height="26.94076">
<td style="font-size:9.75;" align="center" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="headers.AREA_DESC"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.KEYUSFACTSTOTPOP00" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.AGEBYRACEBYSEXTOTPOP10" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.KEYUSFACTSTOTPOP20" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.ATRISKTOTPOPCY" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.AGEBYRACEBYSEXTOTPOPFY" m="#,#0"/>
</td>
</tr>
The first headers.AREA_DESC is where the missing site name should go. Subsequent rows populate correctly. "headers" refers to entries in a fields element in metadata.xml (another file in the imported template). headers.SITE_NAME refers to a "SpecialField" in metadata.xml.
I figured it out.
A few notes:
I should have named this post "How to get the site name to appear in the output summary report?" I thought area description was correct because the comparison table editor in the infographic builder looks like this -
The report.xml contains a table definition that looks like this -
<tr height="26.94076">
<td style="font-size:9.75;" align="center" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">Sites</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2000 Total Population (U.S. Census)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2010 Total Population (U.S. Census)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2020 Total Population (U.S. Census)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2023 Total Population (Esri)</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="TableHeader" pad="2.25" vpad="1.5">2028 Total Population (Esri)</td>
</tr>
<tr height="26.94076">
<td style="font-size:9.75;" align="center" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="headers.AREA_DESC"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.KEYUSFACTSTOTPOP00" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.AGEBYRACEBYSEXTOTPOP10" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.KEYUSFACTSTOTPOP20" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.ATRISKTOTPOPCY" m="#,#0"/>
</td>
<td style="font-size:9.75;" align="right" valign="center" overrideStyle="Default" pad="2.25" vpad="1.5">
<d f="comparison_0.AGEBYRACEBYSEXTOTPOPFY" m="#,#0"/>
</td>
</tr>
The first headers.AREA_DESC is where the missing site name should go. Subsequent rows populate correctly. "headers" refers to entries in a fields element in metadata.xml (another file in the imported template). headers.SITE_NAME refers to a "SpecialField" in metadata.xml.