Navigation:  Integration via database > Published interfaces > Asset >

ASTASTATT - Asset attributes import

Previous  Top  Next

This import template enables to update:

Values of asset attributes.

 

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

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:

13 - Inserts the value for an attribute. If it exists, edits it.

NMFIELD01

X

TEXT

255

Asset ID #.

NMFIELD02

X

TEXT

255

Attribute ID #.

NMFIELD03

X

TEXT

255

Attribute value.

NMFIELD04

 

TEXT

255

Revision ID # of the asset.

NMFIELD10

 

TEXT

255

If the value 1 is entered, the interface will verify whether the attribute value already belongs to the list of values. If it does not exist, it will be added.

DSFIELD01

 

TEXT

4000

Attribute value. Mandatory information if the type of the attribute value is MEMO.