You can use the Standard Utility to import and export standards.
The format for the *.std import file is comma-separated flat ASCII text file. You can see exactly what the file should look like by exporting data for a known standard and then examining the resulting file with a text editor such as NotePad.
The format expected by the import function follows.
Line 1: Heading information
The first line of the import file should contain all of the following values, in the order shown below, separated by commas.
The items displayed in italics depend on the labels that you have configured for these items.
Important: Values displayed below in quotation marks must be formatted with quotation marks in the import file.
Heading values |
Based on the user-defined label |
"Part Number" |
|
"Description" |
|
Subgroup size |
|
Range chart |
|
Num decimals |
|
Exponent |
|
Use exponent |
|
Meas system |
|
"Meas unit" |
|
"DE constant" |
|
Monitor |
|
"DMS Part Number" |
|
"DMS Process" |
|
RT checks |
|
Lo Spec |
|
Hi Spec |
|
Lo Gate |
|
Hi Gate |
|
Lo range Gate |
|
Hi range Gate |
|
Lo Ind. limit |
|
Hi Ind. limit |
|
Lo reas limit |
|
Hi reas limit |
|
Scale lo |
|
Scale hi |
|
Scale r |
|
Target x |
|
Target r |
|
"Variable 1" |
|
"Variable 2" |
|
"Variable 3" |
|
"Variable 4" |
|
Values >= 0 |
|
Example heading line
In your . std file, this heading line will look something like this:
"Part Number","Description",Subgroup size,Range chart,Num decimals,Exponent,Use exponent,Meas system,"Meas unit","DE constant",Monitor,"DMS Part Number","DMS Process",RT checks,Lo Spec,Hi Spec,Lo Gate,Hi Gate,Lo range Gate,Hi range Gate,Lo Ind. Limit,Hi Ind. Limit,Lo reas limit,Hi reas limit,Scale lo,Scale hi,Scale r,Target x,Target r,"Variable 1","Variable 2","Variable 3","Variable 4",Values >= 0
Lines 2 through the end: Standard information
Lines following the heading line should contain all of the following values, in the order shown below, separated by commas.
Important: Values displayed below in quotation marks must be formatted with quotation marks in the import file.
Standard fields |
Valid entries |
Example entry |
Can be blank? |
part number |
The name of the standard, up to 30 characters. |
"D-34KW LENGTH" |
N |
description |
A description of the standard, up to 14 characters. |
"blue widget" |
Y |
subgroup size |
Integer between 1 and 72. |
3 |
N |
range chart |
Range, Moving Range, or Sigma |
Range |
N |
number of decimals |
Integer between 0 and 10. |
3 |
N |
Exponent |
Non-zero integer between -323 and 307. |
0 |
Y |
use exponent |
True or False |
False |
N |
Measurement system |
English or Metric |
English |
N |
measurement unit |
A string of up to 10 characters. |
"Inch" |
N |
data entry constant |
Number up to 10 characters long. |
"0.7" |
N |
Monitor |
None (Never) Green (Data without failures) Red (For real-time failures) Both (For all data) |
Both |
N |
DMS part number |
The part number from DMS to use for defect data entry. |
"D-34KW" |
N |
DMS process |
The process from DMS to use for defect data entry. |
"E CUTTING" |
N |
real-time checks |
Integer, using the following rules: 0 No real-time checks If checking for Spec failures then add 3072. If checking for individual Gate failures then add 768. If checking for control limit failures then add 15. If checking for subgroup Gate failures then add 240. If checking for X-bar run failures then add 12288. If checking for range run failures then add 49152. If checking for X-bar trend failures then add 196608. If checking for range trend failures then add 786432. If checking for 2 of 3 zone failures then add 3145728. If checking for 4 of 5 zone failures then add 12582912. |
3087 |
N |
lower spec |
Lower specification limit. |
0.745 |
N |
upper spec |
Upper specification limit. |
0.755 |
N |
lower gate |
Lower gate limit. |
NONE |
N |
upper gate |
Upper gate limit. |
NONE |
N |
lower range gate |
Lower range gate limit. |
NONE |
N |
upper range gate |
Upper range gate limit. |
NONE |
N |
lower individual limit |
Lower individual limit. |
NONE |
N |
upper individual limit |
Upper individual limit. |
NONE |
N |
lower reasonable limit |
Lower reasonable limit. |
0.500 |
N |
upper reasonable limit |
Upper reasonable limit. |
1.000 |
N |
scale lower |
Lower scaling value for X-bar chart. |
NONE |
N |
scale upper |
Upper scaling value for X-bar chart. |
NONE |
N |
scale R |
Upper scaling value for R chart. |
NONE |
N |
target X |
Target X (nominal) value. |
0.750 |
N |
target R |
Target R value. |
NONE |
N |
variable 1 |
Standard variable 1, up to 30 characters long. |
"" |
Y |
variable 2 |
Standard variable 2, up to 30 characters long. |
"" |
Y |
variable 3 |
Standard variable 3, up to 30 characters long. |
"" |
Y |
variable 4 |
Standard variable 4, up to 30 characters long. |
"" |
Y |
Values >= 0 |
Lower Control limit cannot be less than zero |
False |
Y |
Blank values
If you are formatting a . std file for import and want to leave a field blank, you can simply avoid typing a value between the commas for that field. If the field requires quotation mark delimiters (such as the Part Number field), type just the quotation marks with no other characters between them.
For all of the limits (including specification limits, gate limits and reasonable limits), scaling values and target values, you can leave a limit blank by entering NONE or by failing to enter any characters between the commas for that field. The SPC Standard Utility will export these values as NONE if they are blank.
Length of values
If you are formatting a . std file for import, it is not necessary to pad each field with spaces so that it contains the maximum number of characters. If a value is too long or too short the SPC Standard Utility will automatically format it to the appropriate length. This also applies to users who add a space after each comma.
Case sensitivity
You can enter the values listed above in any combination of uppercase and lowercase characters, except for the values in the following fields:
Part Number
Description
Meas unit
DMS Part Number
DMS Process
These four values should be entered the way you want them to appear in GainSeeker.
Example data line
In your . std file, a data line will look something like this:
"B-34KB LENGTH A","Length",3,Range,3,0,False,English,"Inch","0.7",Red,"","",67108863,0.745,0.755,NONE,NONE,NONE,0.003,NONE,NONE,NONE,NONE,NONE,NONE,NONE,0.750,0.003,"","A","","Length",False,
Comma and period
The SPC Standard Utility uses the Windows List separator to separate values on one line of a standards export or import file. The default separator for computers using English (United States) settings is a comma.
The Standard Utility uses the Windows Decimal symbol for the decimal point. The default symbol for computers using English (United States) settings is a period.
For information on viewing or setting the Windows list separator and decimal symbol, see Regional options.