Skip to main content
Version: 2.2.0

ADMATRVAL - Attribute value import

This import template allows inserting values for attributes created in SoftExpert Suite. Follow the standard documented below.

Insert​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
95 - Add a value to an attribute.
NMFIELD01XTEXT255Attribute ID #.
NMFIELD02TEXT255Attribute value ("List of values" attribute required).
NMFIELD03TEXT255Use as default ("List of values" attribute required):
1 - The value of the attribute will be the default for the attribute;
2 - The value of the attribute will not be the default for the attribute.
NMFIELD04XTEXT255User ID.
NMFIELD05TEXT255Address of the database server (external attribute required).
NMFIELD06TEXT255Alias/Database path (external attribute required).
NMFIELD07TEXT255Database user (external attribute required).
NMFIELD08TEXT255Database password (external attribute required).
NMFIELD09TEXT255Database type (external attribute required).
Supported databases:
1 - INTERBASE;
2 - MSSQL;
3 - MSSQL (ODBC);
4 - ORACLE < 8.05;
5 - ORACLE 8/9 (SERVICE NAME);
6 - ORACLE 8/9 (SID);
7 - ORACLE (ODBC);
8 - DB2 (ODBC);
9 - INFORMIX;
10 - ORACLE 8/9 (TNS NAME);
11 - MYSQL;
12 - POSTGRESQL.
NMFIELD10TEXT255SQL to be executed in the database (external attribute required).
NMFIELD11TEXT255Query field (external attribute required).
danger

Attention

The import of values for an undetermined attribute is not allowed.