ADMATR - Attribute import
This import template allows adding new attributes to the SoftExpert Suite components. Follow the standard documented below.
Insert
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 96 - Insert 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 - Undetermined; 3 - External; 4 - SoftExpert Suite object. |
| NMFIELD05 | X | TEXT | 255 | Attribute data type. List of values: 1 - Text; 2 - Numeric; 3 - Date; 5 - Currency. Undetermined: 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; 18 - Project; 19 - Project task. |
| NMFIELD06 | TEXT | 255 | Selection mode. The "List of Values" and "External" attribute types must determine the "Selection Mode". Accepted values: 1 - Zoom; 2 - Combo. | |
| NMFIELD07 | TEXT | 255 | The "List of values" attribute type can determine 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 - Simple mask; 2 - Regular expression. | |
| DSFIELD01 | TEXT | 4000 | Simple format or regular expression mask. |