Difference between revisions of "Your Data"

From dataZoa Wiki
Jump to: navigation, search
(Updating)
 
(29 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
* As you update your data, all downstream calculations and displays <b><i>[[Automatic_Updates#Displays|update automatically]]</i></b>, wherever they are used.
 
* As you update your data, all downstream calculations and displays <b><i>[[Automatic_Updates#Displays|update automatically]]</i></b>, wherever they are used.
 
<br>
 
<br>
 +
  
 
== Uploading ==
 
== Uploading ==
{{Template:DataNav|offset=159|desc=select the <i>Upload</i> icon}}<br>
+
{{Template:DataNav|offset=166|desc=select the <i>Upload</i> icon}}<br>
  
=== <div class="GfakeTabGroup"><div class="GfakeTab">From a File</div></div> ===
+
{{:Uploading_from_a_File}}
<div>
+
{{:Uploading_from_Text_(Copy/Paste)}}
[[Uploading_Spreadsheets|Spreadsheet Uploads]]
+
</div>
+
 
+
=== <div class="GfakeTabGroup"><div class="GfakeTab">From Text (Copy/Paste)</div></div> ===
+
<div>
+
[[Uploading_With_Copy_and_Paste|Direct Copy-and-Paste]]
+
</div>
+
  
 
== Updating ==
 
== Updating ==
{{Template:DataNav|offset=195|desc=select the <i>Update</i> icon}}<br>
+
{{Template:DataNav|offset=202|desc=select the <i>Update</i> icon}}<br>
  
 
=== <div class="GfakeTabGroup"><div class="GfakeTab">From Updated File</div></div> ===
 
=== <div class="GfakeTabGroup"><div class="GfakeTab">From Updated File</div></div> ===
 
<div>
 
<div>
[[Uploading_Spreadsheets|Spreadsheet Uploads]]
+
Use this tab when you have an updated file of data with appropriate dataZoa series keys included so the series are matched and replaced. 
 
</div>
 
</div>
  
 
=== <div class="GfakeTabGroup"><div class="GfakeTab">In Named Datasets</div></div> ===
 
=== <div class="GfakeTabGroup"><div class="GfakeTab">In Named Datasets</div></div> ===
 
<div>
 
<div>
[[Updating_Named_Datasets|Updating_Named_Datasets]]
+
This tab holds a list of named datasets you have already uploaded.  From here you can:
 +
<ul style="list-style: none;">
 +
<li><div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/Redo.png', title: 'Edit dataset values', xtraStyle: ' min-height: 16px; min-width: 16px;'  }"></div></div> - Update and extend series <li><div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/Reorder.png', title: 'Reorder dataset', xtraStyle: ' min-height: 16px; min-width: 16px;'  }"></div></div> - Reorder the series in the dataset
 +
<li><div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/Erase.png', title: 'Erase dataset', xtraStyle: ' min-height: 16px; min-width: 16px;'  }"></div></div> - Erase the dataset and its underlying series
 +
<li><div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/notrend.png', title: 'Rename dataset', xtraStyle: ' min-height: 16px; min-width: 16px;'  }"></div></div> - Rename the dataset</li>
 +
</ul>
 
</div>
 
</div>
  
 
== Using the API ==
 
== Using the API ==
 
<div>
 
<div>
[[DataZoa_API|API]]
+
{{:DataZoa_API}}
 +
 
 +
Learn more [[dataZoa_API|here]].
 +
</div>
 +
 
 +
== Preserve Your Series Keys ==
 +
<div>
 +
<div class="imgGlyph24 imgWarning"></div> <b>Important:</b>  When you upload your own data and you plan on refreshing or "re-uploading" that data again in the future, <i>you must keep track of your [[About_Series|series keys]]</i>.
 +
 
 +
When you first upload a data series, dataZoa creates a [[About_Series|series key]] as a unique identifier for the series.  If you later want to replace the data <i>in-place</i>, so that all of your calculations and displays still refer to the same entity, you must supply the key that was generated.  Just about any aspect of the series (title, units, time range, etc.) can change when replacing data in place, <i>just not the key</i>.
 +
</div>
 +
<br><br>
 +
 
 +
===After a File Upload===
 +
<div style="margin-left: 3em;">
 +
When you use the file upload wizard, newly created keys are shown when the upload finishes.  The wizard has a button yoiu can use right then to copy the new keys and insert them as a row or column (as appropriate) in your source file.
 +
</div>
 +
 
 +
===After a Text (Copy/Paste) Upload===
 +
<div style="margin-left: 3em;">
 +
As soon as you complete a text upload, there is a [[GroupLists|grouplist]] called <b><i>All of Latest Upload</i></b> that contains your new series and their keys.  If you select that grouplist in the [[Workbench|workbench]], you can immediately inspect the series for their series keys. 
 +
<br>
 +
<div class="imgGlyph24 imgHowTo"></div> One handy way to get the new series keys is to simply check mark the new series and then export them.  You will see all of your original data <i>plus</i> the series keys.
 +
</div>
 +
 
 +
===After an API Upload===
 +
<div style="margin-left: 3em;">
 +
New series keys are returned as part of the transaction used to inject new series.  They are thus available to be captured programmatically as part of the process.
 
</div>
 
</div>
  
[[Category:Provisional]]
+
[[Category:How_To]]
 +
[[Category:Editing]]
 +
[[Category:Time_Savers]]

Latest revision as of 16:37, 26 March 2020

In dataZoa, your own uploaded data works seamlessly right along with data from the Web.
  • All series are completely harmonized, no matter the source
  • As you update your data, all downstream calculations and displays update automatically, wherever they are used.



Uploading

In the data toolbar, select the Upload icon.

^

This brings you to a multi-tab page with uploading options:


From a File

This tab provides a multi-step "wizard" that lets you pick a file to upload, and then helps you describe the particulars of that file. The wizard accommodates sophisticated options like:

  • Row/column Orientation
  • Exclude certain rows or columns
  • Discover dates from multiple cells
  • Construct titles from multiple cells

When the wizard completes, you have the option to save your specifications as a template. You can re-use

When you complete an upload you have the opportunity to save the steps as a template so that you can apply the same

From Text (Copy/Paste)

This tab provides a large text box where you can enter free-form data to upload. Typically the data is copied from a web page or file and then pasted into the text box. dataZoa handles a wide variety of date and data formats, and will handle single ori multiple series in a single upload.

After you upload a new collection of data series, you can name the collection as a dataset. As a dataset, your newly created series keys are grouped together, and can thereafter be updated and maintained in dataZoa's grid-based data editor.

Updating

In the data toolbar, select the Update icon.

^

This brings you to a multi-tab page with uploading options:

From Updated File

Use this tab when you have an updated file of data with appropriate dataZoa series keys included so the series are matched and replaced.

In Named Datasets

This tab holds a list of named datasets you have already uploaded. From here you can:

  • - Update and extend series
  • - Reorder the series in the dataset
  • - Erase the dataset and its underlying series
  • - Rename the dataset

Using the API

The dataZoa API is an advanced feature for business users and data publishers to automate their data transfers.

If you have a dataZoa business or publishing license and you have important recurrent updates, your systems can cooperate with dataZoa for enhanced reliability, timeliness and accuracy.


Learn more here.

Preserve Your Series Keys

Important: When you upload your own data and you plan on refreshing or "re-uploading" that data again in the future, you must keep track of your series keys.

When you first upload a data series, dataZoa creates a series key as a unique identifier for the series. If you later want to replace the data in-place, so that all of your calculations and displays still refer to the same entity, you must supply the key that was generated. Just about any aspect of the series (title, units, time range, etc.) can change when replacing data in place, just not the key.



After a File Upload

When you use the file upload wizard, newly created keys are shown when the upload finishes. The wizard has a button yoiu can use right then to copy the new keys and insert them as a row or column (as appropriate) in your source file.

After a Text (Copy/Paste) Upload

As soon as you complete a text upload, there is a grouplist called All of Latest Upload that contains your new series and their keys. If you select that grouplist in the workbench, you can immediately inspect the series for their series keys.

One handy way to get the new series keys is to simply check mark the new series and then export them. You will see all of your original data plus the series keys.

After an API Upload

New series keys are returned as part of the transaction used to inject new series. They are thus available to be captured programmatically as part of the process.