ITATTR - Attribute association with items
This import template allows importing attributes to item records and setting values for them.
For the insertion of each one of these items, the standard documented below must be followed.
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: 107 - Code of the SoftExpert PDM component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 14 - Insert new attribute association. If the attribute is already associated, the system will simply update the value. |
| NMFIELD01 | X | TEXT | 255 | Item ID #. |
| NMFIELD02 | X | TEXT | 255 | Attribute ID #. |
| NMFIELD04 | TEXT | 255 | Revision ID #. | |
| NMFIELD10 | TEXT | 255 | If the value 1 is entered, The interface will check if the attribute value already belongs to the list of values; if it does not exist, it will be added. | |
| DSFIELD01 | TEXT | 4000 | Attribute value. |