Difference between revisions of "Ad Hoc Maintenance"

From dataZoa Wiki
Jump to: navigation, search
(Created page with "{{Template:Important_Warning|content=AFF Obsolete as of March 31, 2020}} {{Template:Data_Source_Maintenance_Has_Keytip}} <div class="dataToolTip" style="width: 60em;"><div c...")
 
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Template:Important_Warning|content=AFF Obsolete as of March 31, 2020}}
+
This [https://www.datazoa.com/utils/adhoc.asp AdHoc Maintenance] utility is a handy way to locate groups of series and operate on them in various ways, including:
 +
<br>
 +
* Copy [[Application_Conventions|Series Keys]] and other attributes for pasting to spreadsheets, editors, and other applications
 +
* Pin selected series to the [[dZCorkboard]]
 +
* Run manual out-of-cycle data [[Automatic_Updates|refresh/update from URL]] refreshes
 +
<br>
 +
==Discussion==
 +
<div style="width: 60em;">
 +
== <b>Locate Series</b> section ==
 +
<p>
 +
The <b>Locate</b> section helps you identify a set of series from your dataZoa account.
 +
</p>
 +
<p>
 +
On the left hand side of the panel, you can set various search criteria to get a list of possible candidates, or just put in one or more specific series key, (like <i>MyAccount/0003417</i>).
 +
</p>
 +
<p>
 +
On the right hand side of the panel, you can filter that pool of series by giving further conditions.
 +
</p>
 +
<p>
 +
When you use the <b>List Series</b> button, dataZoa generates rows of Series that match your current criteria.  Note that there is a modest upper limit to the number of Series shown.
 +
</p>
  
{{Template:Data_Source_Maintenance_Has_Keytip}}
+
== <b>Actions</b> section ==
 +
<p>
 +
You will also see a section with some choices about what to do with the list of Series.
 +
</p>
 +
<p>
 +
Notes:
  
<div class="dataToolTip" style="width: 60em;"><div class="imgGlyph24 imgKeyTip"></div>
+
* Any "copy to clipboard" actions will copy plain text to the computer clipboard.  When needed, multiple rows and columns are separated by <i>newline</i> and <i>tab</i> characters, respectively. Copied text can typically be pasted straight in to spreadsheets and editors.
<b>Key Tips for Census.gov/American Fact Finder (AFF) Data Migration:</b>
+
* The "pin to dZCorkboard" action is a handy way to select Series for new Displays and Grouplists.   
<ul>
+
* The "Refresh" action applies only to Series that originate from outside data sources, and does not affect manually maintained Series.
<li>In March of 2020, the US Census Bureau [https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml de-commissioned] its legacy American Fact Finder data catalog.</li>
+
<li>For dataZoa, this means the location and names of data selected with the dZ-Dot simply no longer exist, and therefore cannot be automatically updated.</li>
+
<li>The good news is that the underlying data still exists and is accessible via a new Census.gov Application Programming Interface (Census.gov API).</li>
+
<li>Further, dataZoa has an application page to help you update your existing links for dataZoa displays and calculationsUse [https://www.datazoa.com/utils/cenapi.asp this tool] to convert old Census data locations to new ones.</li>
+
<li>This process does involve manual review and confirmation of how to translate legacy links to the new style, but this is a one-time process for the series. The utility is by and large very good at mapping the old to the new, with a bare minimum of user intervention.</li>
+
</ul>
+
</div>
+
<br><br><br>
+
  
{{Template:Data_Source_Maintenance_General_Discussion}}
+
<div><div class="imgGlyph24 imgIdea"></div> You can often hover your mouse over action buttons and drop-down list items for handy further information.</div>
 +
</p>
  
 +
== <b>Series Listing</b> ==
 +
<p>
 +
The bottom section is a list of Series that match your Series selections and filters.  These results are one Series per row, and have some further individual Action buttons interspersed. 
 +
</p>
 +
<div><div class="imgGlyph24 imgIdea"></div> Initially the rows are sorted by Series key, but they can be reordered by clicking on any column header.
 +
 +
 +
 +
</div>
  
[[Category:Intermediate]][[Category:How_To]][[Category:Time_Savers]][[Category:Displays]]
+
[[Category:Advanced]][[Category:How_To]][[Category:Time_Savers]][[Category:Displays]]
 +
[[Category:Utility]]

Latest revision as of 12:09, 7 June 2024

This AdHoc Maintenance utility is a handy way to locate groups of series and operate on them in various ways, including:


Discussion

Locate Series section

The Locate section helps you identify a set of series from your dataZoa account.

On the left hand side of the panel, you can set various search criteria to get a list of possible candidates, or just put in one or more specific series key, (like MyAccount/0003417).

On the right hand side of the panel, you can filter that pool of series by giving further conditions.

When you use the List Series button, dataZoa generates rows of Series that match your current criteria. Note that there is a modest upper limit to the number of Series shown.

Actions section

You will also see a section with some choices about what to do with the list of Series.

Notes:

  • Any "copy to clipboard" actions will copy plain text to the computer clipboard. When needed, multiple rows and columns are separated by newline and tab characters, respectively. Copied text can typically be pasted straight in to spreadsheets and editors.
  • The "pin to dZCorkboard" action is a handy way to select Series for new Displays and Grouplists.
  • The "Refresh" action applies only to Series that originate from outside data sources, and does not affect manually maintained Series.
You can often hover your mouse over action buttons and drop-down list items for handy further information.

Series Listing

The bottom section is a list of Series that match your Series selections and filters. These results are one Series per row, and have some further individual Action buttons interspersed.

Initially the rows are sorted by Series key, but they can be reordered by clicking on any column header.