Skip to main content
Version: 2.2.1

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

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
107 - Code of the SoftExpert PDM component.
FGOPTIONXNUMERIC2Code 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.
NMFIELD01TEXT255Item ID #.
NMFIELD02TEXT255Item name.
NMFIELD03TEXT255Item type ID #.
NMFIELD04TEXT255Responsible team ID #.
NMFIELD05TEXT255Measurement unit ID #.
NMFIELD06TEXT255Physical state:
1 – Solid;
2 – Liquid;
3 – Gas;
4 – Sludge.
NMFIELD07TEXT255Odor ID #.
NMFIELD08TEXT255Color name.
NMFIELD09TEXT255UN code.
NMFIELD10TEXT255Hazard ID #.
NMFIELD11TEXT255Classification ID #.
NMFIELD12TEXT255ABNT code.
NMFIELD13TEXT255Revision date.
NMFIELD14TEXT255Revision ID #.
NMFIELD15TEXT255User ID.
NMFIELD16TEXT255Item family:
1 - Yes.
NMFIELD17TEXT255Item family ID #.
NMFIELD18TEXT255Item cost value.
NMFIELD19TEXT255Drawing ID #
DSFIELD01TEXT4000General description of the composition.
DSFIELD02X⁴TEXT4000Item 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.