Skip to main content
Version: 2.2.0

STRVALUES - Indicator target/measurement import

This import template allows inserting/editing:

  • Indicator target and measurement values.

To insert each of these items, the standard documented below must be followed:

Insert/Edit

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32ID of the user with import permission in the scorecard, or target and/or measurement permission in the indicator.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
138 - Code of the SoftExpert Performance component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
6 - Insert/edit values.
NMFIELD01XTEXT255Scorecard indicator ID #
NMFIELD02XTEXT255ID of the user with import permission in the scorecard, or target and/or measurement permission in the indicator.
NMFIELD03TEXT255For daily or based-on-event indicators, the target/measurement day must be entered, from 1 to 31.
For weekly indicators, the number of the week of the month for target/measurement must be entered, from 1 to 5.
For biweekly indicators, the number of the fortnight of the month for target/measurement must be entered, 1 or 2.
For indicators with other frequencies, it must remain empty;
NMFIELD04TEXT255For daily, weekly, biweekly, monthly or based-on-event indicators, the number of the month must be entered, from 1 to 12.
For bimonthly indicators, the number of the bimester for target/measurement must be entered, from 1 to 6.
For quarterly indicators, the number of the quarter for target/measurement must be entered, from 1 to 4.
For four-month-period indicators, the number of the four-month-period for target/measurement must be entered, from 1 to 3.
For biannual indicators, the number of the semester for target/measurement must be entered, 1 or 2.
For yearly indicators, it must remain empty.
NMFIELD05XTEXT255Target/measurement year with 4 digits. E.g.: 2020
NMFIELD06TEXT255Target weight. If it is not entered, the default weight of the indicator will be considered.
NMFIELD07TEXT255Determine whether the period will be set as not applicable:
1 - Set period as not applicable.
2 - Do not set (default value).
NMFIELD08TEXT255Target value³.
NMFIELD09TEXT255Measurement value³.
NMFIELD10TEXT255Accumulated target value³.
NMFIELD11TEXT255Accumulated measurement value³.
NMFIELD12TEXT255Value³ of additional field 1.
NMFIELD13TEXT255Value³ of additional field 2.
NMFIELD14TEXT255Value³ of additional field 3.
NMFIELD16TEXT255Value³ of accumulated additional field 1.
NMFIELD17TEXT255Value³ of accumulated additional field 2.
NMFIELD18TEXT255Value³ of accumulated additional field 3.
NMFIELD19TEXT50Comment/explanation title for the period.
DSFIELD01TEXT4000Comment/explanation description for the period.
info

Note:

  • X¹ - Field required if the indicator entered has "Daily", "Weekly", "Biweekly" or "Based on event" frequency.
  • X² - Field required if the indicator entered has any frequency other than "Yearly".
  • ³ - The value must be entered without measurement unit, and with decimal separator only. E.g.: 999999.12345678