Ad Hoc Maintenance

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

• Copy Series Keys and other attributes for pasting to spreadsheets, editors, and other applications
• Pin selected series to the dZCorkboard
• Run out-of-cycle data refresh/update from URLrefreshes

Discussion

Selecting 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.

You can often hover your mouse over action buttons and drop-down list items for handy further information.

Data Comparison Columns section

When all of parameters are selected, you do a trial data fetch and examine the results. You can tweak parameters if needed and re-fetch. When you are satisfied that the trial fetch is right for the data series, you can Accept the Parameters and Commit to dataZoa.

The three data comparison columns show:

• The legacy Current data for this Series as stored at dataZoa.
• The proposed Trial data for this Series as it will be fetched with the current parameters.
  • Hover over the Current URL row to see the raw legacy data path.
  • Hover over the Current Title row to see the full description of the legacy data.
• An optional Raw Fetch direct from the data source, with minimal processing, to help resolve any subtleties about the data as stored at the source.