Skip to main content
Version: 2.2.1

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​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
116 - Code of the SoftExpert SPC component.
FGOPTIONXNUMERIC2Code 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.
NMFIELD01XTEXT255Collection number (field required for deletion).
NMFIELD02XTEXT255Characteristic ID # (field required for deletion).
NMFIELD03TEXT255Sample number (field required for deletion).
Note: If it is not entered, the system will use the last sample and add up one unit.
NMFIELD04XTEXT255Sample date (mm/dd/yyyy).
NMFIELD05XTEXT255Time (hh:mm).
NMFIELD06XTEXT255Flag to reconstitute the sample general data:
1 - Previous sample;
2 - Characteristic.
NMFIELD07TEXT255Machine ID # (required depending on the system parameterization).
NMFIELD08TEXT255Operator ID # (required depending on the system parameterization).
NMFIELD09TEXT255Inspector ID # (required depending on the system parameterization).
NMFIELD10TEXT255Work shift ID # (required depending on the system parameterization).
NMFIELD11TEXT255Measurement gage ID # (required depending on the system parameterization).
NMFIELD12TEXT255Lot number (required depending on the system parameterization).
NMFIELD13TEXT255M.O. number (required depending on the system parameterization).
NMFIELD14XTEXT255Number of items.
NMFIELD15XTEXT255Number of defective items.
NMFIELD16XTEXT255Number of rejected items.
NMFIELD17TEXT255Workflow ID # (required if the collection object is a workflow or a workflow activity).
DSFIELD01TEXT4000List 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​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
116 - Code of the SoftExpert SPC component.
FGOPTIONXNUMERIC2Code 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).
NMFIELD01XTEXT255Collection number (field required for deletion).
NMFIELD02XTEXT255Characteristic ID # (field required for deletion).
NMFIELD03XTEXT255Sample number (field required for deletion).
NMFIELD04XTEXT255Defect ID # (field required for deletion).
NMFIELD05XTEXT255Number of defects.

Insert/edit/delete sample defect cause for attribute characteristic​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
116 - Code of the SoftExpert SPC component.
FGOPTIONXNUMERIC2Code 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).
NMFIELD01XTEXT255Collection number (field required for deletion).
NMFIELD02XTEXT255Characteristic ID # (field required for deletion).
NMFIELD03XTEXT255Sample number (field required for deletion).
NMFIELD04XTEXT255Defect ID # (field required for deletion).
NMFIELD05XTEXT255Cause ID # (field required for deletion).
NMFIELD06XTEXT255Number of causes.