SPCSAMPATT - Attribute characteristic sample import
This import template allows inserting/editing:
- Sample data of attribute characteristics.
- Sample defect data of attribute characteristics.
- Sample defect cause data of attribute characteristics.
For the insertion of each one of these items, the standard documented below must be followed.
Insert/edit/delete attribute-characteristic sample
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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: 3 - Insert attribute-characteristic sample; if the sample exists already, its data will be updated; 4 - Delete attribute-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 | Number of items. |
| NMFIELD15 | X | TEXT | 255 | Number of defective items. |
| NMFIELD16 | X | TEXT | 255 | Number of rejected items. |
| NMFIELD17 | TEXT | 255 | Workflow ID # (required if the collection object is a workflow or a workflow activity). | |
| DSFIELD01 | TEXT | 4000 | List of defects and their respective quantities separated by semicolon (;) and colon (:). If the ID # contains one of the two delimiting characters, use backslash () as the antecedent character, following this format: Format: DEFECT01:3;DEFECT;02:4 |
Insert/edit/delete sample defect for attribute characteristic
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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: 5 - Insert attribute-characteristic sample defect; if the defect exists already, its data will be updated; 6 - Delete defect from attribute-characteristic sample (defects are set to 0). |
| NMFIELD01 | X | TEXT | 255 | Collection number (field required for deletion). |
| NMFIELD02 | X | TEXT | 255 | Characteristic ID # (field required for deletion). |
| NMFIELD03 | X | TEXT | 255 | Sample number (field required for deletion). |
| NMFIELD04 | X | TEXT | 255 | Defect ID # (field required for deletion). |
| NMFIELD05 | X | TEXT | 255 | Number of defects. |
Insert/edit/delete sample defect cause for attribute characteristic
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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: 7 - Insert attribute-characteristic sample defect cause; if the cause exists already, its data will be updated; 8 - Delete defect cause from attribute-characteristic sample (causes are set to 0). |
| NMFIELD01 | X | TEXT | 255 | Collection number (field required for deletion). |
| NMFIELD02 | X | TEXT | 255 | Characteristic ID # (field required for deletion). |
| NMFIELD03 | X | TEXT | 255 | Sample number (field required for deletion). |
| NMFIELD04 | X | TEXT | 255 | Defect ID # (field required for deletion). |
| NMFIELD05 | X | TEXT | 255 | Cause ID # (field required for deletion). |
| NMFIELD06 | X | TEXT | 255 | Number of causes. |