ITITEM - Item import
This import template enables insertion, editing, deletion, revision creation, and status change for items or item families.
caution
- The item ID # is generated automatically when the
NMFIELD01
field is left empty during the inclusion of a new item. - To insert a released item or a released item revision, the
NMFIELD13
field must be completed. - Date fields must be completed in the
YYYY/MM/DD
format. - The item type must be configured to allow customized identifiers so that the
value entered in the
NMFIELD14
field can be applied. - For numeric fields, use
.
as a decimal separator.
For the insertion of each one of these items, the standard documented below must be followed.
Insert/edit/delete item
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: 1 - Insert new item; if the record exists already, it will be edited. 2 - Delete item. 24 - Insert new revision for the item. 25 - Change item status. |
NMFIELD01 | X¹ | TEXT | 255 | Item ID #. |
NMFIELD02 | X² | TEXT | 255 | Item name. |
NMFIELD03 | X² | TEXT | 255 | Item type ID #. |
NMFIELD04 | X² | TEXT | 255 | Responsible team ID #. |
NMFIELD05 | X² | TEXT | 255 | Measurement unit ID #. |
NMFIELD06 | TEXT | 255 | Physical state: 1 – Solid; 2 – Liquid; 3 – Gas; 4 – Sludge. | |
NMFIELD07 | TEXT | 255 | Odor ID #. | |
NMFIELD08 | TEXT | 255 | Color name. | |
NMFIELD09 | TEXT | 255 | UN code. | |
NMFIELD10 | TEXT | 255 | Hazard ID #. | |
NMFIELD11 | TEXT | 255 | Classification ID #. | |
NMFIELD12 | TEXT | 255 | ABNT code. | |
NMFIELD13 | TEXT | 255 | Revision date. | |
NMFIELD14 | TEXT | 255 | Revision ID #. | |
NMFIELD15 | X³ | TEXT | 255 | User ID. |
NMFIELD16 | TEXT | 255 | Item family: 1 - Yes. | |
NMFIELD17 | TEXT | 255 | Item family ID #. | |
NMFIELD18 | TEXT | 255 | Item cost value. | |
NMFIELD19 | TEXT | 255 | Drawing ID # | |
DSFIELD01 | TEXT | 4000 | General description of the composition. | |
DSFIELD02 | X⁴ | TEXT | 4000 | Item attributes. Example: identifier_of_attribute1=value_of_attribute1 ; identifier_of_attribute2=value_of_attribute2 ; identifier_of_attribute3=value_of_attribute3 . Example with a multivalued attribute: identifier_of_attribute1=value1_of_attribute1 , value2_of_attribute1 , value3_of_attribute1 . |
info
Note:
X¹ - Required for EDITING
, DELETING
, INSERTING NEW REVISION
, or
CHANGING THE STATUS
of an item; X² - Required for INSERTING
or EDITING
an
item; X³ - Required for INSERTING
an item when the type has revision control,
or for INSERTING NEW REVISION
for an item; X⁴ - Required for INSERTING
an
item when the item type has required attributes.