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 | 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 | 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 #. |
| NMFIELD03 | X | TEXT | 255 | Attribute value |
| 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. Information required if the attribute value is of the MEMO type. |