Skip to main content
Version: 2.2.1

ASTASTINSERT - Asset import

This import template allows inserting/editing:

  • Asset data

For the insertion of each one of these items, the standard documented below must be followed.

Insertā€‹

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:
109 - Code of the SoftExpert Asset component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
1 - Insert asset; if the record exists already, it will be edited;
NMFIELD01XTEXT255Asset ID #
NMFIELD02XTEXT255Asset name.
NMFIELD03XTEXT255Asset type ID #
NMFIELD04XTEXT255Responsible team ID #
NMFIELD05XTEXT255Asset specification:
1 - Gage;
2 - Equipment;
4 - Others;
6 - Tooling;
7 - Tools;
11 - Computer.
NMFIELD06XTEXT255Operation start date. It must be entered in the YYYY-MM-DD format.
NMFIELD07XTEXT255Asset quantity
NMFIELD08TEXT255Cavity (required for "Tooling").
NMFIELD09TEXT255Manufacturer (company name).
NMFIELD10TEXT50Serial number
NMFIELD11TEXT50Model
NMFIELD12TEXT255Calendar ID #
NMFIELD13TEXT255Supplier (company name).
NMFIELD14TEXT255Equipment cost
NMFIELD15TEXT255Hourly cost
NMFIELD16TEXT255Revision date. It must be entered in the YYYY-MM-DD format.
NMFIELD17XĀ¹TEXT255User ID.
DSFIELD01TEXT4000Example:
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.
DSFIELD02TEXT4000Description
DSFIELD03TEXT4000Characteristics
DSFIELD04TEXT4000Comments
info

Note:

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