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	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: 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. Format: - YYYY-MM-DD.
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.