DES Import dialog box
The import operation looks for an object type.
When the files are imported back into Statistica, the program can identify the file names and recognize the object type(s) (Characteristic, Label, or Data Entry Setup) to import them correctly.
The base object types to import are determined by the presence of one of the following "Template Version" strings in the selected Excel files. If one of these template strings is not present in the selected Excel file, a log message is display and the file will be skipped.
Label Template Version: located in second row, first column. Identifies this as Label Excel file.
Characteristic Template Version: located in second row, first column. Identifies this as Characteristics Excel file.
DES Template Version: located on Header tab, first row, first column. Identifies this as Data Entry Setup file.
Version number
A Version Number is required for import to identify the kind of template. The initial template versions are defined as Version 1 in Statistica version 13.2. Future versions may add features that will increment the template version number.
Limitations to data imported:
The following limitations apply to the data that can be imported in the initial release:
Characteristics: Only variable characteristics are supported.
Label types: Only label types of piece, sample, cause, action and query are supported.
Additional Notes:
Import shall match by column name; names are defined as they are created on export
Import of strings and column names are not case-sensitive.
Any field that contains missing data/blanks will remain unchanged .
Audit Logging
If the System Options -> Versions and Approvals -> When committing changes prompt for and require a reason checkbox is checked, you are prompted for a reason. The supplied reason is maintained in the relevant entries of the audit log and in the version history of the new or updated objects.
Report
A Statistica Report window will detail all operations performed
Invalid or inconsistent data shall be reported in the Report window
Option Descriptions
The following label fields will be exported. Blank/missing data will be used for any missing fields in the label.
Version number import/export code (initial release will be Version 1)
Label Folder Path
Label Name
Label Description
Label Type (Piece, Sample, Cause, Action, Query)
Label List Type (Static, Dynamic, General, Datetime)
Label Values: (Pipe (|), separated list for Static or Dynamic Label List Types, Query)
Label Product Traceability Role (None, BatchID, Previous BatchID, Reference BatchID, Annotation, Start Time, Stop Time, Amount/Weight)
Label Product Traceability Aggregation Type (Mean, Median, Mode, Standard Deviation, Sum, First, Last, Minimum, Maximum, All)
DateTime Display Format
Label Sample Size (for Piece Labels)
The following characteristic fields will be exported. Blank/missing data will be used for any missing fields in the label.
Version number of import/export code (initial release will be Version 1)
Characteristic Folder Path
Characteristic Name
Characteristic Description
Characteristic Type (Only variable supported in initial release)
Characteristic Chart Type (X-Bar and R, Individuals, X-Bar and S, Moving Average, Moving Average and S, Moving Average and R, EWMA and R, EWMA and S)
Characteristic Check Reasonable Values
Characteristic Low Reasonable Value
Characteristic High Reasonable Value
Characteristic Sample Size
Characteristic Minimum N Per: Sample
Characteristic Use Constant Sample Size
Characteristic Number of Decimals: ( For input validation)
Characteristic Product Traceability Role (none, measurement)
Characteristic Product Traceability Aggregation (Mean, Median, Mode, Standard Deviation, Sum, First, Last, Minimum, Maximum, All)
Characteristic EWMA Lambda
Characteristic Moving Average Span
Data Entry Setups
Data Entry exports to Excel file shall consist of three tabs containing the following information:
Header: General information about the export:
Version number of export code (initial release will be Version 1)
Data Entry Setup Name
Data Entry Setup Description
User permissions (For read only access, pipe separated)
Group Permissions (For read only access, pipe separated)
User Permissions Writeable (pipe separated): items with "Edit" permissions
Group Permissions Writeable (pipe separated): items with "Edit" permissions
System Folder Location
Display by Row or Column
Requires Approval
Complete on Save
Blind Data Entry
Blind Data Entry Approval
Locale. This is created for export, and optional on input. It specifies the locale that the export was done in, and is either "US" or "NonUS". This refers to the decimal separator, and is significant for Constraints.
Fields: Details of the fields and properties within the data entry setup:
Fields list will list the characteristics, labels, and separators in order of the data entry setup
Folder Path
Name
Type (label, autolabel, characteristis, separator)
Formula
Required
Width
Lines
Hidden
Default Value
Link (For separator types)
Display Items By (row, column, default)
Blind Data Entry Compare
Blind Data Entry Required
Blind Data Entry Sample ID
Characteristic Check Reasonable Values
Characteristic Low Reasonable Value
Characteristic High Reasonable Value
Characteristic Number of Decimals
Characteristic Static Specifications (pipe separated list)
Label Verify Unique
Label Include in Recent Sample List