Difference between revisions of "Your Data"
(→Updating) |
|||
| (31 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= | + | {{Template:DataNav|offset=166|desc=select the <i>Upload</i> icon}}<br> |
| − | === <div class="GfakeTabGroup"><div class="GfakeTab">From | + | {{:Uploading_from_a_File}} |
| + | {{:Uploading_from_Text_(Copy/Paste)}} | ||
| + | |||
| + | == Updating == | ||
| + | {{Template:DataNav|offset=202|desc=select the <i>Update</i> icon}}<br> | ||
| + | |||
| + | === <div class="GfakeTabGroup"><div class="GfakeTab">From Updated File</div></div> === | ||
<div> | <div> | ||
| − | + | 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"> | + | === <div class="GfakeTabGroup"><div class="GfakeTab">In Named Datasets</div></div> === |
<div> | <div> | ||
| − | + | 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 == |
| − | + | ||
<div> | <div> | ||
| − | [[ | + | {{:DataZoa_API}} |
| + | |||
| + | Learn more [[dataZoa_API|here]]. | ||
</div> | </div> | ||
| − | == | + | == Preserve Your Series Keys == |
<div> | <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: | + | [[Category:How_To]] |
| + | [[Category:Editing]] | ||
| + | [[Category:Time_Savers]] | ||
Latest revision as of 15:37, 26 March 2020
- 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.
Contents
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
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
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.
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.
