Skip to main content
Version: 2.2.3

STMEVENTATTRIB - Event attribute association import

This import template allows inserting:

  • Event attribute association data.

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

Insert

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Primary key - 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:
180 - Code of the SoftExpert Storeroom component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
12 - Insert new event attribute association.
NMFIELD01XTEXT255Event ID #.
NMFIELD02XTEXT255Attribute ID #.
NMFIELD03XTEXT255Attribute value.
NMFIELD04XTEXT255Revision ID #.
Information required if the component needs the revision code in the specific table of the attribute.
NMFIELD10TEXT255If the entered value is 1, the interface will check if the attribute value already belongs to the list of values; if it does not exist, it will be added.
DSFIELD01TEXT4000Attribute value.
Information required if the attribute value is of the MEMO type.
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
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.