Difference between revisions of "Ad Hoc Maintenance"

From dataZoa Wiki
Jump to: navigation, search
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
This Ad Hoc Maintenance utility is a handy way to locate groups of series and operate on them in various ways, including:
+
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
 
* Copy [[Application_Conventions|Series Keys]] and other attributes for pasting to spreadsheets, editors, and other applications
 
* Pin selected series to the [[dZCorkboard]]
 
* Pin selected series to the [[dZCorkboard]]
* Run out-of-cycle data [[Automatic_Updates|refresh/update from URL]]refreshes
+
* Run manual out-of-cycle data [[Automatic_Updates|refresh/update from URL]] refreshes
 
+
<br>
 
==Discussion==
 
==Discussion==
 
<div style="width: 60em;">
 
<div style="width: 60em;">
== <b>Selecting Series</b> section ==
+
== <b>Locate Series</b> section ==
 
<p>
 
<p>
 
The <b>Locate</b> section helps you identify a set of series from your dataZoa account.
 
The <b>Locate</b> section helps you identify a set of series from your dataZoa account.
Line 20: Line 20:
 
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.
 
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>
 
</p>
 +
 
== <b>Actions</b> section ==
 
== <b>Actions</b> section ==
 
<p>
 
<p>
Line 28: Line 29:
  
 
* 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.
 
* 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.
<div><div class="imgGlyph24 imgKeyTip"></div> You can often hover your mouse over action buttons and drop-down list items for handy further information.</div>
+
* 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.
 +
 
 +
<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>
 
</p>
  
== <b>Data Comparison Columns</b> section ==
+
== <b>Series Listing</b> ==
 
<p>
 
<p>
When all of parameters are selected, you do a trial data fetch and examine the resultsYou can tweak parameters if needed and re-fetch. When you are satisfied that the trial fetch is right for the data series, you can <b><i>Accept the Parameters and Commit to dataZoa</i></b>.
+
The bottom section is a list of Series that match your Series selections and filtersThese results are one Series per row, and have some further individual Action buttons interspersed.   
</p>
+
<p>
+
The three data comparison columns show:
+
<ul>
+
<li>The legacy <b>Current data</b> for this Series as stored at dataZoa</li>
+
<li>
+
  The proposed <b>Trial data</b> for this Series as it will be fetched with the current parameters.
+
  <ul>
+
  <li><div><div class="imgGlyph24 imgIdea"></div> Hover over the <b>Current URL</b> row to see the raw legacy data path.</div></li>
+
  <li><div><div class="imgGlyph24 imgIdea"></div> Hover over the <b>Current Title</b> row to see the full description of the legacy data.</div></li>
+
  </ul>
+
</li>
+
<li>An optional <b>Raw Fetch</b> direct from the data source, with minimal processing, to help resolve any subtleties about the data as stored at the source.</li>
+
</ul>
+
 
</p>
 
</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>
 
</div>
  
 
[[Category:Advanced]][[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.