Navigation:  Integration via database > Published interfaces > SPC >

SPCSAMPATT - Attribute characteristic sample import

Previous  Top  Next

This import template enables to insert/edit:

Attribute characteristic sample data;

Attribute characteristic sample defect data;

Attribute characteristic sample defect cause data

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert/edit/delete attribute 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

System code where the integration will be performed to:

116 - Code of component SoftExpert SPC.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

3 - Insert attribute characteristic sample; if it exists, updates its data;

4 - Delete attribute characteristic sample.

NMFIELD01

X

TEXT

255

Collection number (required field for deletion).

NMFIELD02

X

TEXT

255

Characteristic ID # (field required for deletion).

NMFIELD03

 

TEXT

255

Sample number (field required for deletion).

Note: If not entered, the system will use the previous 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

Shift ID # (required depending on the system parameterization).

NMFIELD11

 

TEXT

255

Gage ID # (required depending on the system parameterization).

NMFIELD12

 

TEXT

255

Lot number (required depending on the system parameterization).

NMFIELD13

 

TEXT

255

O.F. number (required depending on the system parameterization).

NMFIELD14

X

TEXT

255

Quantity of items.

NMFIELD15

X

TEXT

255

Quantity of defective items.

NMFIELD16

X

TEXT

255

Quantity 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, according to the format:

Format:
DEFECT01:3;DEFECT\;02:4

 

Insert/edit/delete attribute characteristic sample defect

Column

Required

Type

Precision

Description

OIDINTERFACE

X

NUMERIC

10

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

System code where the integration will be performed to:

116 - Code of component SoftExpert SPC.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

5 - Insert attribute characteristic sample defect; if it exists, updates its data;

8 - Delete attribute characteristic sample defect (sets the defects as 0).

NMFIELD01

X

TEXT

255

Collection number (required field 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

Quantity of defects.

 

Insert/edit/delete attribute characteristic sample defect cause

Column

Required

Type

Precision

Description

OIDINTERFACE

X

NUMERIC

10

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

System code where the integration will be performed to:

116 - Code of component SoftExpert SPC.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

7 - Insert attribute characteristic sample defect cause; if it exists, updates its data;

8 - Delete attribute characteristic sample defect cause (sets the cause as 0).

NMFIELD01

X

TEXT

255

Collection number (required field 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

Quantity of causes.