SPCSAMPVAR - Variable characteristic sample import
This import template allows inserting/editing:
- Sample data of variable characteristics.
For the insertion of each one of these items, the standard documented below must be followed.
Insert/edit/delete variable-characteristic sample
Column | Required | Type | Precision | Description |
---|---|---|---|---|
OIDINTERFACE | X | TEXT | 32 | Sequential code - Identifies an item to be imported into SoftExpert Suite. |
FGIMPORT | X | NUMERIC | 2 | Import status: 1 - New; 2 - In progress; 3 - Finished; 4 - Error. |
CDISOSYSTEM | X | NUMERIC | 10 | Code of the system for which the integration will be performed: 116 - Code of the SoftExpert SPC component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 1 - Insert attribute-characteristic sample; if the sample exists already, its data will be updated; 2 - Delete variable-characteristic sample. |
NMFIELD01 | X | TEXT | 255 | Collection number (field required for deletion). |
NMFIELD02 | X | TEXT | 255 | Characteristic ID # (field required for deletion). |
NMFIELD03 | TEXT | 255 | Sample number (field required for deletion). Note: If it is not entered, the system will use the last sample and add up one unit. | |
NMFIELD04 | X | TEXT | 255 | Sample date (mm/dd/yyyy). |
NMFIELD05 | X | TEXT | 255 | Time (hh:mm). |
NMFIELD06 | X | TEXT | 255 | Flag to reconstitute the sample general data: 1 - Previous sample; 2 - Characteristic. |
NMFIELD07 | TEXT | 255 | Machine ID # (required depending on the system parameterization). | |
NMFIELD08 | TEXT | 255 | Operator ID # (required depending on the system parameterization). | |
NMFIELD09 | TEXT | 255 | Inspector ID # (required depending on the system parameterization). | |
NMFIELD10 | TEXT | 255 | Work shift ID # (required depending on the system parameterization). | |
NMFIELD11 | TEXT | 255 | Measurement gage ID # (required depending on the system parameterization). | |
NMFIELD12 | TEXT | 255 | Lot number (required depending on the system parameterization). | |
NMFIELD13 | TEXT | 255 | M.O. number (required depending on the system parameterization). | |
NMFIELD14 | X | TEXT | 255 | Reading values (readings must be separated by “;” and use "." as decimal separator). |
NMFIELD15 | TEXT | 255 | Workflow ID # (required if the collection object is a workflow or a workflow activity). |