ITITEM - Item import

This import template allows inserting/editing/deleting:

• Item data.

caution

• To insert a new item that is already released, the DTREVISION field is required;
• If you wish, use the IDREVISION field to customize the revision ID #;
• To create a new revision releasing the item right away, do not complete the DTREVISION and IDREVISION fields.

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 item; if the record exists already, it will be edited. 2 - Delete item.
NMFIELD01		TEXT	255	Item ID #; if it is not entered, an ID # will be created automatically (for deletion, only this field is required).
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, in the YYYY/MM/DD format.
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		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_attibute1. Note: For attributes with a numeric value, the decimal place separator must be ".". For date fields, the value must have the “Y-M-D” (Year-Month-Day) format.

info

Note:

X¹ - Required only when the item type used contains revision.