How to update Spotfire Statistica Web Data Entry samples using Import Data
Article ID: KB0138629
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.3 and higher |
| Spotfire Statistica - All Servers | 14.3 and higher |
Description
Statistica's Web Data Entry (a.k.a Data Entry) has the Import Data functionality. Can it update existing samples?
Environment
OS: Windows
Resolution
Yes, existing samples can be updated.
Prerequisites
- Any data entry setup must have a label with a unique ID (this does not include the system generated Sample ID).
Below is a simple example.
1. In this example, there is a data entry setup with one labels and one characteristic:
2. Look at one sample in the data entry setup, Sample ID: 51. Note this sample ID number.
3. Via the data entry UI, select "Import Data". Then select the Data Entry Setup for which you want to update samples. Then select the "Download Template" link:
4. Open the data entry setup template spreadsheet in Statistica. Add an additional variable/column named Sample_ID as an Integer Type:
5. Update the desired sample values and add the Sample_ID value of 51:
6. Go back to "Import Data" in the Data Entry UI. Select the Data Entry Setup to update. Choose the spreadsheet as the file and click the Upload button
7. Select the Auto Match button and select Sample_ID as the sample identification variable:
8. Click the "Import Data" button at the bottom left of the page:
9. The samples will be imported and updated. The results will be provided at the bottom of the page.
The Sample ID 51 shows the updated values:
Note: An email notification with the same import result can be configured by an administrator by adding the key-value to the data entry web.config file:
<add key="ImportRecipients" value="xxx@xxx.com"/>
For more information, please see the reference below.
Issue/Introduction
How to update Spotfire Statistica Web Data Entry samples using Import Data
Additional Information
