ASTASTINSERT - Asset import

Insert

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:

109 - Code of component SoftExpert Asset.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 – Add asset; if it exists, it edits the existing asset

NMFIELD01

X

TEXT

255

Asset ID #

NMFIELD02

X

TEXT

255

Asset name.

NMFIELD03

X

TEXT

255

Asset type ID #.

NMFIELD04

X

TEXT

255

Responsible team ID #.

NMFIELD05

X

TEXT

255

Asset specification:

1 – Gage;

2 – Equipment;

4 – Others;

6 – Tooling;

7 – Tools;

11 – Computer.

NMFIELD06

X

TEXT

255

Operation start date. It must be entered in the YYYY-MM-DD format.

NMFIELD07

X

TEXT

255

Asset quantity

NMFIELD08

TEXT

255

Cavity (required for "Tooling").

NMFIELD09

TEXT

255

Manufacturer (company name)

NMFIELD10

TEXT

50

Serial number

NMFIELD11

TEXT

50

Template

NMFIELD12

TEXT

255

Calendar ID #

NMFIELD13

TEXT

255

Supplier (company name)

NMFIELD14

TEXT

255

Equipment cost

NMFIELD15

TEXT

255

Hourly cost

NMFIELD16

TEXT

255

Revision date. It must be entered in the YYYY-MM-DD format.

NMFIELD17

X1

TEXT

255

User's reg. code #.

DSFIELD01

TEXT

4000

Example:

identifier_of_attribute1=value_of_attribute1;

identifier_of_attribute2=value_of_attribute2;

identifier_of_attribute3=value_of_attribute3.

Example with a multivalued attribute:

identifier_of_attribute1=value1_of_attribute1,value2_of_attribute1,value3_of_attibute1

Note: For attributes with a numeric value, the decimal place separator must be '.'.

For date fields, the value must have the “Y-M-D” (Year-Month-Day) format.

DSFIELD02

TEXT

4000

Description

DSFIELD03

TEXT

4000

Characteristics

DSFIELD04

TEXT

4000

Comments