Navigation:  Integration via database > Published interfaces > Administration >

ADMATR - Attribute import

Previous  Top  Next

This import template enables to add new attributes to the SoftExpert Suite components. 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:

153 - Code of component SoftExpert Administration.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

96 - Inserts a new attribute.

NMFIELD01

X

TEXT

255

Attribute ID #.

NMFIELD02

X

TEXT

255

Attribute name.

NMFIELD03

X

TEXT

255

User ID #.

NMFIELD04

X

TEXT

255

Attribute type.

1 - List of values;

2 - Non-discrete;

3 - External;

4 - SoftExpert Suite object.

NMFIELD05

X

TEXT

255

Attribute data type.

List of values:

1 - Text;

2 - Numeric;

3 - Date;

5 - Currency.

Non-discrete:

1 - Text;

2 - Numeric;

3 - Date;

4 - Memo;

5 - Currency.

SoftExpert Suite object:

8 - User;

9 - Organizational unit;

10 - Indicator;

11 - Audit;

12 - Kanban task;

13 - Document;

14 - Item;

15 - Asset;

16 - Supply;

17 - Waste;

18 - Project;

19 - Project task.

NMFIELD06

 

TEXT

255

Selection mode.

The 'List of Values' and 'External' attribute types must inform the 'Selection Mode'. Accepted values:

1 - Zoom;

2 – Combo.

NMFIELD07

 

TEXT

255

The 'List of Values' attribute type can inform whether the attribute will be 'Multivalued'. Accepted values:

1 - Multivalued

NMFIELD8

 

TEXT

255

Associate attributes with the component. Separate the component codes with “;”.

Example:109;107.

NMFIELD09

 

TEXT

255

Field format:

1 - Single mask;

2 - Regular expression.

DSFIELD01

 

TEXT

4000

Single format or regular expression mask.