Navigation:  Integration via database > Published interfaces > SPC >

SPCSAMPVAR - Variable characteristic sample import

Previous  Top  Next

This import template enables to insert/edit:

Variable characteristic sample data;

 

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

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

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 variable characteristic sample; if it exists, updates its data;

2 - Delete variable 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

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).